Dynamický dotaz - Účetní deník - souvztažně

ID:
WAWUT2ZH53E13C5R00CA141B44

Datasety

MAIN

Popis:
Účetní zápisy
SQL definice:
SELECT {FIELDS} FROM
  GeneralLedgerGroupsWithFirm({$AccDateFrom}, {$AccDateTo}, {$TextUsed},
    {$Text}, {$AccountCode}, {$AccountSelID}, {$AmountUsed}, {$AmountFrom}, {$AmountTo},
    {$AmountInCurrencyUsed}, {$AmountInCurrencyFrom}, {$AmountInCurrencyTo},
    {$Audited}, {$IDSelID}, {$AccDocQueueSelID}, {$PeriodSelID}, {$FirmSelID},
    {$DivisionsSelID}, {$DivisionsWithChilds},
    {$BusOrdersSelID}, {$BusOrdersWithChilds},
    {$BusTransactionsSelID}, {$BusTransactionsWithChilds},
    {$BusProjectsSelID}, {$BusProjectsWithChilds},
    {$CurrencySelID},
    {$WholeGroups}, {$OrdNumberUsed}, {$OrdNumberFrom}, {$OrdNumberTo}, 
    {$ShowGroups}, {$DocumentTypeSelID})
  B
  JOIN GeneralLedger A ON A.ID=B.ID
  LEFT JOIN Firms F ON F.ID=A.Firm_ID
  LEFT JOIN Firms GF ON GF.ID=B.GroupFirm_ID
  LEFT JOIN Periods P ON P.ID=A.Period_ID
  LEFT JOIN AccDocQueues ADQ ON ADQ.ID=A.AccDocQueue_ID
  LEFT JOIN Currencies C ON C.ID=A.Currency_ID
{WHERE}
ORDER BY
{BEGINORDERBY}B.AccDate$DATE, A.AccGroup_ID, A.AccDate$DATE
Aliasy:
Alias CLSID objektu Prefix Popis
A C3S1BMBT4RD13ACL03KIU0CLP4
ADQ OBTMKVQH3ZD13ACL03KIU0CLP4 AccDocQueue Účetní řada dokladů
C 4R5FINKNYNDL3C5P00CA141B44 Currency Měna
F 4K3EXM5PQBCL35CH000ILPWJF4 Firm Firma
GF 4K3EXM5PQBCL35CH000ILPWJF4 GrpFirm Firma pro skupinu
P CAQPAYUOXVCL3ACL03KIU0CLP4 Period Období
Fields:
Jméno Typ Velikost Výraz CLSID Popis
GroupAmount dtFloat 10 
A.Amount * (select Max(IValue) from SYS$DECIDETable where IValue = 0 or A.DebitAccount_ID in

  (select AC.ID from Accounts AC where A.DebitAccount_ID = AC.ID 

   and AC.Code like {$AccountCode} ESCAPE '~'

   and ({$AccountSelID} = '' or AC.ID in (select OBJ_ID from SELDAT where SEL_ID={$AccountSelID})))) -

A.Amount * (select Max(IValue) from SYS$DECIDETable where IValue = 0 or A.CreditAccount_ID in

  (select AC.ID from Accounts AC where A.CreditAccount_ID = AC.ID 

   and AC.Code like {$AccountCode} ESCAPE '~'

   and ({$AccountSelID} = '' or AC.ID in (select OBJ_ID from SELDAT where SEL_ID={$AccountSelID}))))
 Částka skupiny
GroupCreditAmount dtFloat 10 
A.Amount * (select Max(IValue) from SYS$DECIDETable where IValue = 0 or A.CreditAccount_ID in

  (select AC.ID from Accounts AC where A.CreditAccount_ID = AC.ID 

   and AC.Code like {$AccountCode} ESCAPE '~'

   and ({$AccountSelID} = '' or AC.ID in (select OBJ_ID from SELDAT where SEL_ID={$AccountSelID}))))
 Částka D
GroupDate$DATE dtDateTime 10 
B.AccDate$DATE
 Datum skupiny
GroupDebitAmount dtFloat 10 
A.Amount * (select Max(IValue) from SYS$DECIDETable where IValue = 0 or A.DebitAccount_ID in

  (select AC.ID from Accounts AC where A.DebitAccount_ID = AC.ID 

   and AC.Code like {$AccountCode} ESCAPE '~'

   and ({$AccountSelID} = '' or AC.ID in (select OBJ_ID from SELDAT where SEL_ID={$AccountSelID}))))
 Částka MD
GroupFirmName dtString 80 
GF.Name
 Název firmy pro skupinu

Podmínky

ID

Šablona:
ID
Dataset:
MAIN
Speciální parametry:
CLASSID=C3S1BMBT4RD13ACL03KIU0CLP4
AlwaysList=1
ReplacementLink=True
{$IDSelID}=SELECTIONID;''

AccountCode

Popiska:
Účet (znakově)
Typ/Subtyp:
ctString/0
ckSingle:
<field> = {:VALUE}
Dataset:
MAIN
Speciální parametry:
AlwaysUsed=True
ReplacementLink=True
{$AccountCode}=VALUE;'*'
ConvertWildChars=True

Account_ID

Šablona:
Account_ID (ReplacementLink C&D)
Dataset:
MAIN

ShowGroups

Šablona:
ShowGroups
Dataset:
MAIN
Speciální parametry:
AlwaysUsed=True
ReplacementLink=True
{$ShowGroups}=VALUE;1

WholeGroups

Šablona:
WholeGroups
Dataset:
MAIN
Speciální parametry:
AlwaysUsed=True
ReplacementLink=True
{$WholeGroups}=VALUE;1

Period_ID

Šablona:
Period_ID
Dataset:
MAIN
Speciální parametry:
AlwaysList=1
ReplacementLink=True
{$PeriodSelID}=SELECTIONID;''

AccDate

Šablona:
AccDate
Dataset:
MAIN
Speciální parametry:
AlwaysUsed=True
ReplacementLink=True
{$AccDateFrom}=VALUE;0
{$AccDateTo}=VALUEHIGH;0

DocumentType

Popiska:
Typ dokladu
Typ/Subtyp:
ctSpecial/0
ckSingle:
<field> = {:VALUE}
ckList:
<field> IN ({:LIST})
Dataset:
MAIN
Speciální parametry:
AlwaysList=1
CLASSID=WBFHFPM0V3CL33N2010DELDFKK
DisplayField=Name
@ToAccount=A
ReplacementLink=True
{$DocumentTypeSelID}=SELECTIONID;''

AccDocQueue_ID

Šablona:
AccDocQueue_ID
Dataset:
MAIN
Speciální parametry:
AlwaysList=1
ReplacementLink=True
{$AccDocQueueSelID}=SELECTIONID;''

OrdNumber

Šablona:
OrdNumber
Dataset:
MAIN
Speciální parametry:
ReplacementLink=True
{$OrdNumberFrom}=VALUE;0
{$OrdNumberTo}=VALUEHIGH;999999
{$OrdNumberUsed}=USED;'N'

Firm_ID

Šablona:
Firm_ID (joined)
Dataset:
MAIN
Speciální parametry:
AlwaysList=1
ReplacementLink=True
{$FirmSelID}=SELECTIONID;''

Currency_ID

Šablona:
Currency_ID
Dataset:
MAIN
Speciální parametry:
AlwaysList=1
ReplacementLink=True
{$CurrencySelID}=SELECTIONID;''

Amount

Popiska:
Částka v lokální měně
Typ/Subtyp:
ctExtended/0
ckRange:
<field> BETWEEN {:LOW} and {:HIGH}
Dataset:
MAIN
Speciální parametry:
ReplacementLink=True
{$AmountFrom}=VALUE;0
{$AmountTo}=VALUEHIGH;99999999
{$AmountUsed}=USED;'N'

AmountInCurrency

Popiska:
Částka v měně dokladu
Typ/Subtyp:
ctExtended/0
ckRange:
<field> BETWEEN {:LOW} and {:HIGH}
Dataset:
MAIN
Speciální parametry:
ReplacementLink=True
{$AmountInCurrencyFrom}=VALUE;0
{$AmountInCurrencyTo}=VALUEHIGH;99999999
{$AmountInCurrencyUsed}=USED;'N'

Text

Šablona:
TextNoCaseSens
Dataset:
MAIN
Speciální parametry:
ReplacementLink=True
{$Text}=VALUE;''
{$TextUsed}=USED;'N'

CreatedBy_ID

Šablona:
CreatedBy_ID
Dataset:
MAIN

CorrectedBy_ID

Šablona:
CorrectedBy_ID
Dataset:
MAIN

Division_ID

Šablona:
Division_ID (C&D Replacement Link)
Dataset:
MAIN

BusOrder_ID

Šablona:
BusOrder_ID (Replacement Link C&D)
Dataset:
MAIN

BusTransaction_ID

Šablona:
BusTransaction_ID (Replacement Link C&D)
Dataset:
MAIN

BusProject_ID

Šablona:
BusProject_ID (Replacement Link C&D)
Dataset:
MAIN

Audited

Popiska:
Audit
Typ/Subtyp:
ctBoolean/0
ckSingle:
<field> = {:VALUE}
Dataset:
MAIN
Speciální parametry:
ReplacementLink=True
{$Audited}=VALUE;'%'

Klíče

GroupFirmName

Popiska:
Firma pro skupinu
SQL:
GF.Name  Collate PXW_CSY
Dataset:
MAIN

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