Dynamický dotaz - Obraty účtů - dny

ID:
PUXHLXTNWF3OTIQKI0ZG1NOLB0

Datasety

MAIN

Popis:
Obraty účtů
SQL definice:
SELECT {FIELDS}
FROM
  AccountTurnovers({$AccountSelID}, {$AccDateFrom}, {$AccDateTo}, {$IsRequest},
  {$Audited}, {$DivisionsSelID}, {$DivisionsWithChilds}, {$BusOrdersSelID},
  {$BusOrdersWithChilds}, {$BusTransactionsSelID}, {$BusTransactionsWithChilds},
  {$BusProjectsSelID}, {$BusProjectsWithChilds},
  {$FirmSelID}, {$AccountCode}, {$AllAccounts}, {$AmountFrom}, {$AmountTo}, 1,
  {$BusOrdersWithNull}, {$BusTransactionsWithNull}, {$BusProjectsWithNull})
  A
Fields:
Jméno Typ Velikost Výraz CLSID Popis
AccDate dtDateTime 10 
A.AccDate$Date
 Datum účtování
Account_Code dtString 10 
A.AccountCode
 Účet
Account_Name dtString 40 
A.AccountName
 Název účtu
CreditAmount dtFloat 10 
A.CreditAmount
 Částka D
DebitAmount dtFloat 10 
A.DebitAmount
 Částka MD

Podmínky

ID

Šablona:
ID
Dataset:
MAIN

Date

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

Account_ID

Šablona:
Account_ID (ReplacementLink)
Dataset:
MAIN
Speciální parametry:
AlwaysList=True

AccountCode

Šablona:
AccountCode (Replacement Link)
Dataset:
MAIN

Amount

Šablona:
Amount (Replacement Link)
Dataset:
MAIN

Firm_ID

Šablona:
Firm_ID (Replacement Link)
Dataset:
MAIN
Speciální parametry:
ExpandFirmAncestor=1

Division_ID

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

BusOrder_ID

Šablona:
BusOrder_ID (Replacement Link) with null
Dataset:
MAIN

BusTransaction_ID

Šablona:
BusTransaction_ID (Replacement Link) with null
Dataset:
MAIN

BusProject_ID

Šablona:
BusProject_ID (Replacement Link) is null
Dataset:
MAIN

Audited

Šablona:
Audited (Replacement Link)
Dataset:
MAIN

IsRequest

Šablona:
IsRequest (Replacement Link)
Dataset:
MAIN

AllAccounts

Šablona:
AccountsWithoutBeginnings (Replacement Link)
Dataset:
MAIN

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