acc.entr.SaRtSaTaxDbPaybCrCsh.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 9 as SRTY, SALRET.DAT, 'SATAXRECVRT' as ACDB, TAX.NME as SADNM, TAX.IID as SADID, 1008 as SADTY, SARTTXLN.TOT as DEBT,
'RETPAY' as ACCR, DBCR.NME as SACNM, DBCR.IID as SACID, 1002 as SACTY, SARTTXLN.TOT as CRED
from SARTTXLN
join TAX on TAX.IID=SARTTXLN.TAX
join SALRET on SALRET.IID=SARTTXLN.OWNR
join SALINV on SALINV.IID=SALRET.INV
join DBCR on DBCR.IID=SALINV.DBCR
where SARTTXLN.RVID is null and SALINV.RVID is null and SALINV.MDENR=1 and round(SALINV.TOPA+SALRET.TOT,2)>=round(SALINV.TOT,2) :WHEAD