Logo da alınan ve verilen hizmetlerin bağlı muhasebe kodları sql kodları rapor üretici içindir
normal sorgu olarak kullanmak isterseniz LG_dönemno_CRDACREF şeklinde güncelleyebilirsiniz.
Alınan Hizmetler
SELECT SVRCARD.CODE, SVRCARD.DEFINITION_, SVRCARD.VAT, EMUH.MUHCODE, EMUH.MUHDEFINITION_
FROM {SRVCARD} AS SVRCARD LEFT OUTER JOIN
(SELECT CRDACREF.CARDREF, EMUHACC.CODE AS MUHCODE, EMUHACC.DEFINITION_ AS MUHDEFINITION_
FROM {CRDACREF} AS CRDACREF FULL OUTER JOIN
{EMUHACC} AS EMUHACC ON CRDACREF.ACCOUNTREF = EMUHACC.LOGICALREF
WHERE (CRDACREF.TRCODE = 3)) AS EMUH ON SVRCARD.LOGICALREF = EMUH.CARDREF
WHERE (SVRCARD.CARDTYPE = 1)
Verilen Hizmetler
SELECT SVRCARD.CODE, SVRCARD.DEFINITION_, SVRCARD.VAT, EMUH.MUHCODE, EMUH.MUHDEFINITION_
FROM {SRVCARD} AS SVRCARD LEFT OUTER JOIN
(SELECT CRDACREF.CARDREF, EMUHACC.CODE AS MUHCODE, EMUHACC.DEFINITION_ AS MUHDEFINITION_
FROM {CRDACREF} AS CRDACREF FULL OUTER JOIN
{EMUHACC} AS EMUHACC ON CRDACREF.ACCOUNTREF = EMUHACC.LOGICALREF
WHERE (CRDACREF.TRCODE = 4)) AS EMUH ON SVRCARD.LOGICALREF = EMUH.CARDREF
WHERE (SVRCARD.CARDTYPE = 2)