acc.entr.SaInRecvDbGSalItcCr.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 6 as SRTY, DAT, 'RECEIVABLE' as ACDB, DBCR.NME as SADNM, DBCR.IID as SADID, 1002 as SADTY, SUM(SAINGDLN.SUBT) as DEBT,
'GSALES' as ACCR, ITMCT.NME as SACNM, ITMCT.IID as SACID, 1004 as SACTY, SUM(SAINGDLN.SUBT) as CRED
from SAINGDLN
join ITM on ITM.IID=SAINGDLN.ITM
join ITMCT on ITMCT.IID=ITM.CAT
join SALINV on SALINV.IID=SAINGDLN.OWNR
join DBCR on DBCR.IID=SALINV.DBCR
where SAINGDLN.RVID is null :WHEAD
group by SRTY, DAT, ACDB, SADNM, SADID, SADTY, ACCR, SACNM, SACID, SACTY