acc.trade.invTxItBs.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of beige-acc Show documentation

It consists of double entry accounting and trading (web-store) business logic. It's based on previous beigesoft-accounting and beigesoft-webstore projects.

The newest version!

select TAX as TAXID, TAX.NME as TAXNME, sum(TOT) as TOTX, sum(TOFC) as TXFC
from
( select TAX, TOT, TOFC from :TGDTXLN
  where RVID is null and INVID=:INVID
union all
  select TAX, TOT, TOFC from :TSRVTXLN
  where INVID=:INVID
) as ALLNS
join TAX on ALLNS.TAX=TAX.IID
group by TAX, TAXNME;