Dynamický dotaz - Účetní deník - likvidační listy

ID:

VTV1ZHN111R4RFKSPI3MUCGOUS

Datasety

MAIN

Popis:

Účetní deník

SQL definice:

SELECT {FIELDS} FROM
  GeneralLedger A
  LEFT JOIN Firms F ON F.ID=A.Firm_ID
  JOIN Periods P ON P.ID=A.Period_ID
  JOIN AccDocQueues ADQ ON ADQ.ID=A.AccDocQueue_ID
  JOIN Currencies C ON C.ID=A.Currency_ID
  JOIN SecurityUsers SU1 ON SU1.ID=A.CreatedBy_ID
  LEFT JOIN SecurityUsers SU2 ON SU2.ID=A.CorrectedBy_ID
  LEFT JOIN Accounts DA ON DA.ID = A.DebitAccount_ID
  LEFT JOIN Accounts CA ON CA.ID = A.CreditAccount_ID
  LEFT JOIN Divisions DD ON DD.ID = A.DebitDivision_ID
  LEFT JOIN Divisions CD ON CD.ID = A.CreditDivision_ID
  LEFT JOIN BusOrders DBO ON DBO.ID = A.DebitBusOrder_ID
  LEFT JOIN BusOrders CBO ON CBO.ID = A.CreditBusOrder_ID
  LEFT JOIN BusTransactions DBT ON DBT.ID = A.DebitBusTransaction_ID
  LEFT JOIN BusTransactions CBT ON CBT.ID = A.CreditBusTransaction_ID
  LEFT JOIN BusProjects DBP ON DBP.ID = A.DebitBusProject_ID
  LEFT JOIN BusProjects CBP ON CBP.ID = A.CreditBusProject_ID
  JOIN Relations SGR ON A.ID = SGR.LeftSide_ID AND SGR.Rel_def = 203
WHERE 
  A.IsRequest = 'N'
{ANDWHERE}
{ORDERBY}

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	C3S1BMBT4RD13ACL03KIU0CLP4
ADQ	OBTMKVQH3ZD13ACL03KIU0CLP4	AccDocQueue	Účetní řada dokladů
C	4R5FINKNYNDL3C5P00CA141B44	Currency	Měna
F	4K3EXM5PQBCL35CH000ILPWJF4	Firm	Firma
P	CAQPAYUOXVCL3ACL03KIU0CLP4	Period	Období

Podmínky

ID

Šablona:

ID

Dataset:

MAIN

Speciální parametry:

CLASSID=C3S1BMBT4RD13ACL03KIU0CLP4

AccountCode

Popiska:

Účet (znakově)

Typ/Subtyp:

ctSpecial/17

ckSingle:

##CASE {OPTION} #
##0#((A.DebitAccount_ID
    IN (SELECT ID FROM Accounts WHERE <<Code>> LIKE
    {:VALUE} ESCAPE '~' )) OR
    (A.CreditAccount_ID
    IN (SELECT ID FROM Accounts WHERE <<Code>> LIKE
    {:VALUE} ESCAPE '~' )))
##1#(A.DebitAccount_ID
    IN (SELECT ID FROM Accounts WHERE <<Code>> LIKE
    {:VALUE} ESCAPE '~' ))
##2#(A.CreditAccount_ID
    IN (SELECT ID FROM Accounts WHERE <<Code>> LIKE
    {:VALUE} ESCAPE '~' ))
##3#((A.DebitAccount_ID
    IN (SELECT ID FROM Accounts WHERE <<Code>> LIKE
    {:VALUE} ESCAPE '~' )) AND
    (A.CreditAccount_ID
    IN (SELECT ID FROM Accounts WHERE <<Code>> LIKE
    {:VALUE} ESCAPE '~' )))
##ELSE#((A.DebitAccount_ID
    IN (SELECT ID FROM Accounts WHERE <<Code>> LIKE
    {:VALUE} ESCAPE '~' )) OR
    (A.CreditAccount_ID
    IN (SELECT ID FROM Accounts WHERE <<Code>> LIKE
    {:VALUE} ESCAPE '~' )))
##END#

Dataset:

MAIN

Speciální parametry:

ConvertWildChars=True
IgnoreCase=True
OptionNames=MD nebo D;MD;D;MD a zároveň D
OptionValues=0;1;2;3

Account_ID

Popiska:

Účet

Typ/Subtyp:

ctSpecial/18

ckList:

##CASE {OPTION} #
##0#((A.DebitAccount_ID IN ({:LIST})) OR (A.CreditAccount_ID IN ({:LIST})))
##1#(A.DebitAccount_ID IN ({:LIST}))
##2#(A.CreditAccount_ID IN ({:LIST}))
##3#((A.DebitAccount_ID IN ({:LIST})) AND (A.CreditAccount_ID IN ({:LIST})))
##ELSE#((A.DebitAccount_ID IN ({:LIST})) OR (A.CreditAccount_ID IN ({:LIST})))
##END#

ckSingle:

##CASE {OPTION} #
##0#((A.DebitAccount_ID = {:VALUE}) OR (A.CreditAccount_ID = {:VALUE}))
##1#A.DebitAccount_ID = {:VALUE}
##2#A.CreditAccount_ID = {:VALUE}
##3#((A.DebitAccount_ID = {:VALUE}) AND (A.CreditAccount_ID = {:VALUE}))
##ELSE#(A.DebitAccount_ID = {:VALUE} OR A.CreditAccount_ID = {:VALUE})
##END#

Dataset:

MAIN

Speciální parametry:

CLASSID=K0TL1BKM1RD13ACL03KIU0CLP4
TextField=Code
OptionNames=MD nebo D;MD;D;MD a zároveň D
OptionValues=0;1;2;3

Period_ID

Šablona:

Period_ID

Dataset:

MAIN

AccDate

Šablona:

AccDate

Dataset:

MAIN

DocumentType

Popiska:

Typ dokladu

Typ/Subtyp:

ctSpecial/0

ckSingle:

A.AccDocQueue_ID IN (SELECT ID FROM 
AccDocQueues WHERE DocumentType = {:VALUE})

ckList:

A.AccDocQueue_ID IN (SELECT ID FROM 
AccDocQueues WHERE DocumentType IN ({:LIST}))

Dataset:

MAIN

Speciální parametry:

CLASSID=WBFHFPM0V3CL33N2010DELDFKK
DisplayField=Name
@ToAccount=A

AccDocQueue_ID

Šablona:

AccDocQueue_ID

Dataset:

MAIN

OrdNumber

Šablona:

OrdNumber

Dataset:

MAIN

Amount

Popiska:

Částka v lokální měně

Typ/Subtyp:

ctExtended/0

ckRange:

A.Amount BETWEEN {:LOW} and {:HIGH}

Dataset:

MAIN

Currency_ID

Šablona:

Currency_ID

Dataset:

MAIN

AmountInCurrency

Popiska:

Částka v měně dokladu

Typ/Subtyp:

ctExtended/0

ckRange:

A.AmountInCurrency BETWEEN {:LOW} and {:HIGH}

Dataset:

MAIN

Firm_ID

Šablona:

Firm_ID (joined)

Dataset:

MAIN

Text

Šablona:

Text

Dataset:

MAIN

CreatedBy_ID

Šablona:

CreatedBy_ID

Dataset:

MAIN

CorrectedBy_ID

Šablona:

CorrectedBy_ID

Dataset:

MAIN

Division_ID

Šablona:

Division_ID (C&D)

Dataset:

MAIN

BusOrder_ID

Šablona:

BusOrder_ID (C&D) (with NULL)

Dataset:

MAIN

BusTransaction_ID

Šablona:

BusTransaction_ID (C&D) (with NULL)

Dataset:

MAIN

BusProject_ID

Šablona:

BusProject_ID (C&D) (with NULL)

Dataset:

MAIN

Audited

Popiska:

Audit

Typ/Subtyp:

ctBoolean/0

ckSingle:

A.Audited = {:VALUE}

Dataset:

MAIN

Klíče

AccDate

Popiska:

Datum účtování

SQL:

A.AccDate$DATE

Dataset:

MAIN

OrdNumber

Popiska:

Číslo dokladu

SQL:

A.OrdNumber

Dataset:

MAIN

Amount

Popiska:

Částka

SQL:

A.Amount

Dataset:

MAIN

AmountInCurrency

Popiska:

Částka v cizí měně

SQL:

A.AmountInCurrency

Dataset:

MAIN

Firm

Popiska:

Název firmy

SQL:

F.Name Collate PXW_CSY {DIR},A.Firm_ID

Dataset:

MAIN

Period

Popiska:

Zkratka období

SQL:

P.Code Collate PXW_CSY {DIR},A.Period_ID

Dataset:

MAIN

AccDocQueue

Popiska:

Zkratka účetní řady

SQL:

ADQ.Code Collate PXW_CSY {DIR},A.AccDocQueue_ID

Dataset:

MAIN

CreatedBy_ID

Popiska:

Vytvořil

SQL:

SU1.Name Collate PXW_CSY {DIR}, A.CreatedBy_ID

Dataset:

MAIN

CorrectedBy_ID

Popiska:

Opravil

SQL:

SU2.Name Collate PXW_CSY {DIR}, A.CorrectedBy_ID

Dataset:

MAIN

Currency

Popiska:

Měna

SQL:

C.Code Collate PXW_CSY {DIR},A.Currency_ID

Dataset:

MAIN

Period_AccDocQueue_OrdNumber

Popiska:

Identifikace dokladu

SQL:

P.Code Collate PXW_CSY {DIR}, A.Period_ID {DIR}, ADQ.Code Collate PXW_CSY {DIR}, A.AccDocQueue_ID {DIR}, A.OrdNumber

Dataset:

MAIN

Text

Popiska:

Text

SQL:

A.Text Collate PXW_CSY

Dataset:

MAIN

DebitAccount_ID.Code

Popiska:

Účet MD

SQL:

DA.Code Collate PXW_CSY

Dataset:

MAIN

CreditAccount_ID.Code

Popiska:

Účet D

SQL:

CA.Code Collate PXW_CSY

Dataset:

MAIN

DebitDivision_ID.Code

Popiska:

Středisko MD

SQL:

DD.Code Collate PXW_CSY

Dataset:

MAIN

CreditDivision_ID.Code

Popiska:

Středisko D

SQL:

CD.Code Collate PXW_CSY

Dataset:

MAIN

DebitBusOrder_ID.Code

Popiska:

Zakázka MD

SQL:

DBO.Code Collate PXW_CSY

Dataset:

MAIN

CreditBusOrder_ID.Code

Popiska:

Zakázka D

SQL:

CBO.Code Collate PXW_CSY

Dataset:

MAIN

DebitBusTransaction_ID.Code

Popiska:

Obchodní případ MD

SQL:

DBT.Code Collate PXW_CSY

Dataset:

MAIN

CreditBusTransaction_ID.Code

Popiska:

Obchodní případ D

SQL:

CBT.Code Collate PXW_CSY

Dataset:

MAIN

DebitBusProject_ID.Code

Popiska:

Projekt MD

SQL:

DBP.Code Collate PXW_CSY

Dataset:

MAIN

CreditBusProject_ID.Code

Popiska:

Projekt D

SQL:

CBP.Code Collate PXW_CSY

Dataset:

MAIN

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