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-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 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;