Třídová akce

Popis:

Akce vrátí sumu ID řádků účetního deníku pro omezení za jeden účet a parametry. Pozor, pořadí fields je důležité, viz oBookEntries.

Kód:

19

Tělo:

select
    GL.ID as ID,
    GL.ACCDATE$DATE as AccDate,
    DQ1.Code as AccDocQueue,
    P1.Code as Period,
    F1.Name as Firm_Name,
    GL.TEXT as Text,
    GL.AMOUNT as Amount,
    C1.Code as Currency,
    GL.AMOUNTINCURRENCY as AmountInCurrency,
    GL.AUDITED as Audited,
    A1.Code as DebitAccount,
    D1.Code as DebitDivision,
    BO1.Code as DebitBusOrder,
    BT1.Code as DebitBusTransaction,
    A2.Code as CreditAccount,
    D2.Code as CreditDivision,
    BO2.Code as CreditBusOrder,
    BT2.Code as CreditBusTransaction,
    BP1.Code as DebitBusProject,
    BP2.Code as CreditBusProject,
    S1.Name as CreatedBy,
    S2.Name as CorrectedBy
    
from MainBookTurnovers(:Account_ID,:AccDateFrom, :AccDateTo, :IsRequest, :AUDITED, :DivisionsSelID, :DivisionsWithChilds, :BusOrdersSelID, :BusOrdersWithChilds, :BusTransactionsSelID, :BusTransactionsWithChilds, :BusProjectsSelID, :BusProjectsWithChilds, :FirmSelID) LGL
left join GeneralLedger GL on GL.ID = LGL.ID
left join AccDocQueues DQ1 on DQ1.ID = GL.ACCDOCQUEUE_ID
left join Periods P1 on P1.ID = GL.PERIOD_ID
left join Firms F1 on F1.ID = GL.FIRM_ID
left join Currencies C1 on C1.ID = GL.CURRENCY_ID
left join Accounts A1 on A1.ID = GL.DEBITACCOUNT_ID
left join Divisions D1 on D1.ID = GL.DEBITDIVISION_ID
left join BusOrders BO1 on BO1.ID = GL.DEBITBUSORDER_ID
left join BusTransactions BT1 on BT1.ID = GL.DEBITBUSTRANSACTION_ID
left join Accounts A2 on A2.ID = GL.CREDITACCOUNT_ID
left join Divisions D2 on D2.ID = GL.CREDITDIVISION_ID
left join BusOrders BO2 on BO2.ID = GL.CREDITBUSORDER_ID
left join BusTransactions BT2 on BT2.ID = GL.CREDITBUSTRANSACTION_ID
left join busprojects BP1 on BP1.ID = GL.DEBITBUSPROJECT_ID
left join busprojects BP2 on BP2.ID = GL.CREDITBUSPROJECT_ID
left join securityusers S1 on S1.ID=GL.CreatedBy_ID
left join securityusers S2 on S2.ID=GL.CorrectedBy_ID

{ORDER_BY}

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