ws.cartTxItBasAggr.sql Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of beige-accandr Show documentation
Show all versions of beige-accandr Show documentation
Beigesoft™ Enterprise Information System is a standalone JEE web application that runs on the embedded A-Jetty for Android.
Web-Store is included for study and tests purposes, and you are also able to make a full DB copy from a cloud version,
and you can make price lists (in different price categories) and export them via CSV files to your customers and POS.
The newest version!
select CLID, TXCT as TAXCATID, TAX as TAXID, TAX.NME as TAXNAME, RATE, sum(TOTX) as TOTX
from
( select IID as CLID, TXCT, TOTX 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 CLID, TAXCATID, TAXID, TAXNAME, RATE;