acc.trade.saRtTxInAdj.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 TXCT as TXCTID, TXCTLN.TAX as TAXID, TAX.NME as TAXNME, RATE, sum(SUBT) as SUBT, sum(SUFC) as SUFC, min(TOTX) as TOTX, min(TXFC) as TXFC, sum(TOT) as TOT, sum(TOFC) as TOFC
from
( select SAINGDLN.TXCT, SARTLN.SUBT, SARTLN.SUFC, SARTLN.TOT, SARTLN.TOFC from SARTLN
  join SAINGDLN on SAINGDLN.IID=SARTLN.INVL
  where SAINGDLN.TXCT is not null and SARTLN.RVID is null and SARTLN.OWNR=:INVID
) as ALLNS
join TXCT on TXCT.IID=ALLNS.TXCT
join TXCTLN on TXCTLN.OWNR=TXCT.IID
join TAX on TXCTLN.TAX=TAX.IID
join (select TAX, TOT as TOTX, TOFC as TXFC from SARTTXLN where OWNR=:INVID) as INVTLNS on TXCTLN.TAX=INVTLNS.TAX
group by TXCTID, TAXID, TAXNME, RATE
order by TAXID;