ws.cartTxItBas.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 TAXID, TAX.NME as TAXNAME, sum(TOT) as TOTALTAX
from (select TAX as TAXID, TOT from CARTITTXLN where DISAB=0 and SELID:CONDSEL and CARTID=:CARTID) as CTXL
join TAX on CTXL.TAXID=TAX.IID
group by TAXID, TAXNAME;