ws.cartTxInvBas.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 TAXNAME, RATE, sum(SUBT) as SUBT
from
( select TXCT, SUBT from CARTLN
  where TXCT is not null and DISAB=0 and SELR:CONDSEL and OWNR=:CARTID
) as ALL_LINES
join TXCT on TXCT.IID=TXCT
join TXCTLN on TXCTLN.OWNR=TXCT.IID
join TAX on TXCTLN.TAX=TAX.IID
group by TAXID, TAXNAME, RATE;