acc.trade.invTot.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

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 sum(TOT) as TOT, sum(TOFC) as TOFC, sum(TOTX) as TOTX, sum(TXFC) as TXFC
from
( select TOT, TOFC, 0 as TOTX, 0 as TXFC
  from :TGDLN 
  where RVID is null and OWNR=:OWNR
union all
  select TOT, TOFC, 0 as TOTX, 0 as TXFC
  from :TSRVLN 
  where OWNR=:OWNR
union all
  select 0 as TOT, 0 as TOFC, TOT as TOTX, TOFC as TXFC
  from :TTAXLN 
  where OWNR=:OWNR
) as ALLNS;