Třídová akce

Kód:

14

Tělo:

SELECT A.ID,A.AMOUNT,A.CREDITACCOUNT_ID,A.DEBITACCOUNT_ID,
       A.CREDITDIVISION_ID,A.DEBITDIVISION_ID,
       A.CREDITBUSORDER_ID,A.DEBITBUSORDER_ID,
       A.CREDITBUSTRANSACTION_ID,A.DEBITBUSTRANSACTION_ID,
       B.CODE AS CRACCOUNTCODE, C.CODE AS DBACCOUNTCODE,
       A.CREDITBUSProject_ID,A.DEBITBUSProject_ID
FROM GeneralLedger A
JOIN Relations R ON (A.id = R.rightside_id)
LEFT JOIN Accounts B ON (A.CreditAccount_ID = B.ID)
LEFT JOIN Accounts C ON (A.DebitAccount_ID = C.ID)
WHERE (R.REL_DEF = :REL_DEF) AND (R.LEFTSIDE_ID = :PARENT_ID)

Generated by ABRA Software a.s. 27.10.2021 16:34:09