Dynamický dotaz - Hlavní kniha - agenda - řádky

ID:
4KEODIH0FLWOJJAAVHCZOR0IV0

Datasety

MAIN

Popis:
Řádky
SQL definice:
SELECT {FIELDS}
FROM
  MainBookTurnovers({$Account_ID}, {$AccDateFrom}, {$AccDateTo}, {$IsRequest}, {$AUDITED}, {$DivisionsSelID}, {$DivisionsWithChilds}, {$BusOrdersSelID}, {$BusOrdersWithChilds}, {$BusTransactionsSelID}, {$BusTransactionsWithChilds}, {$BusProjectsSelID}, {$BusProjectsWithChilds}, {$FirmSelID})
A
join GeneralLedger GL on GL.ID = A.ID
left join AccDocQueues ADQ on ADQ.ID = GL.ACCDOCQUEUE_ID
left join Periods P on P.ID = GL.PERIOD_ID
left join Firms F on F.ID = GL.FIRM_ID
left join Currencies C on C.ID = GL.CURRENCY_ID
left join Accounts DA on DA.ID = GL.DEBITACCOUNT_ID
left join Divisions DD on DD.ID = GL.DEBITDIVISION_ID
left join BusOrders DBO on DBO.ID = GL.DEBITBUSORDER_ID
left join BusTransactions DBT on DBT.ID = GL.DEBITBUSTRANSACTION_ID
left join Accounts CA on CA.ID = GL.CREDITACCOUNT_ID
left join Divisions CD on CD.ID = GL.CREDITDIVISION_ID
left join BusOrders CBO on CBO.ID = GL.CREDITBUSORDER_ID
left join BusTransactions CBT on CBT.ID = GL.CREDITBUSTRANSACTION_ID
left join BusProjects DBP on DBP.ID = GL.DEBITBUSPROJECT_ID
left join BusProjects CBP on CBP.ID = GL.CREDITBUSPROJECT_ID
left join SecurityUsers CreatedBy on CreatedBy.ID=GL.CreatedBy_ID
left join SecurityUsers CorrectedBy on CorrectedBy.ID=GL.CorrectedBy_ID
{WHERE}
{ORDERBY}
Aliasy:
Alias CLSID objektu Prefix Popis
GL C3S1BMBT4RD13ACL03KIU0CLP4
Fields:
Jméno Typ Velikost Výraz CLSID Popis
CreditAmount dtFloat 10 
Coalesce(A.CreditAmount,0)
 Obrat D
DebitAmount dtFloat 10 
Coalesce(A.DebitAmount,0)
 Obrat MD

Podmínky

AccDate

Šablona:
AccDate (Replacement Link)
Dataset:
MAIN
Speciální parametry:
AlwaysUsed=True

Account_ID

Popiska:
Účet
Typ/Subtyp:
ctString/0
ckSingle:
{:VALUE}
Dataset:
MAIN
Speciální parametry:
CLASSID=K0TL1BKM1RD13ACL03KIU0CLP4
TextField=Code
ReplacementLink=True
{$Account_ID}=VALUE;''
AlwaysUsed=True
HiddenForABRAG1=True

Firm_ID

Šablona:
Firm_ID (Replacement Link)
Dataset:
MAIN

Division_ID

Šablona:
Division_ID (Replacement Link)
Dataset:
MAIN

BusOrder_ID

Šablona:
BusOrder_ID (Replacement Link)
Dataset:
MAIN

BusTransaction_ID

Šablona:
BusTransaction_ID (Replacement Link)
Dataset:
MAIN

BusProject_ID

Šablona:
BusProject_ID (Replacement Link)
Dataset:
MAIN

Audited

Šablona:
Audited (Replacement Link)
Dataset:
MAIN
Speciální parametry:

IsRequest

Šablona:
IsRequest (Replacement Link)
Dataset:
MAIN

Klíče

Audited

Popiska:
Audit
SQL:
GL.Audited
Dataset:
MAIN

AccDate$DATE

Popiska:
Datum účtování
SQL:
GL.AccDate$DATE
Dataset:
MAIN

DisplayName

Popiska:
Číslo dokladu
SQL:
P.Code Collate PXW_CSY {DIR}, ADQ.Code Collate PXW_CSY {DIR}, GL.OrdNumber
Dataset:
MAIN

Text

Popiska:
Text úč. zápisu
SQL:
GL.Text Collate PXW_CSY
Dataset:
MAIN

$Amount$LocalCurrencyCode

Popiska:
Částka (lok.)
SQL:
GL.Amount
Dataset:
MAIN

$AmountInCurrency$Currency_ID.Code

Popiska:
Částka dokladu
SQL:
GL.AmountInCurrency
Dataset:
MAIN

Firm_ID.Name

Popiska:
Firma
SQL:
F.Name Collate PXW_CSY
Dataset:
MAIN

Currency_ID.Code

Popiska:
Měna
SQL:
C.Code Collate PXW_CSY
Dataset:
MAIN

DebitAccount_ID.Code

Popiska:
Účet MD
SQL:
DA.Code Collate PXW_CSY
Dataset:
MAIN

DebitDivision_ID.Code

Popiska:
Středisko MD
SQL:
DD.Code Collate PXW_CSY
Dataset:
MAIN

CreditAccount_ID.Code

Popiska:
Účet D
SQL:
CA.Code Collate PXW_CSY
Dataset:
MAIN

CreditDivision_ID.Code

Popiska:
Středisko D
SQL:
CD.Code Collate PXW_CSY
Dataset:
MAIN

CreatedBy_ID.Name

Popiska:
Vytvořil
SQL:
CreatedBy.Name Collate PXW_CSY
Dataset:
MAIN

CorrectedBy_ID.Name

Popiska:
Opravil
SQL:
CorrectedBy.Name Collate PXW_CSY
Dataset:
MAIN

Generated by ABRA Software a.s. 27.10.2021 16:35