Dynamický dotaz - Definovatelné výkazy PKP

ID:
VK1HJK35WVFOZF3AFFH2ARVHMG

Datasety

MAIN

Popis:
Definovatelné výkazy
SQL definice:
SELECT 
  A.AccountCode AS AccountCode,
  A.Taxable AS Taxable,
  A.AccountType AS AccountType,
  A.DivisionCode AS DivisionCode,
  A.DebitBeginning AS DebitBeginning,
  A.CreditBeginning AS CreditBeginning,
  A.DebitTurnover AS DebitTurnover,
  A.CreditTurnover AS CreditTurnover,
  A.IsIncomplete AS IsIncomplete,
  A.Account_ID AS Account_ID,
  A.Short AS Short,
  A.TypeOfActivity AS TypeOfActivity,
  A.Firm_ID AS Firm_ID,
  F.OrgIdentNumber AS OrgIdentNumber,
  F.Name AS FirmName,
  F.StateConsolidationUnit AS StateConsolidationUnit
FROM
  RepAccStatementsPKP({$Audited}, {$AccDateFrom}, {$AccDateTo}, {$DivisionsSelID},
    {$BusOrdersSelID}, {$BusOrdersWithChilds},
    {$BusTransactionsSelID}, {$BusTransactionsWithChilds},
    {$BusProjectsSelID}, {$BusProjectsWithChilds},
    {$FirmSelID}, {$IsRequest}, {$DivisionsWithChilds})
  A
  LEFT JOIN Firms F ON F.ID = A.Firm_ID  
  ORDER BY AccountCode ASC, OrgIdentNumber ASC
Fields:
Jméno Typ Velikost Výraz CLSID Popis
A.Account_ID dtString 10 
A.Account_ID
 ID účtu
Account dtString 10 
A.AccountCode
 Účet (znakově)
AccountType dtString 1 
A.AccountType
 Typ účtu
CreditBeginning dtFloat 10 
A.CreditBeginning
 Počátek D
CreditTurnover dtFloat 10 
A.CreditTurnover
 Obrat D
DebitBeginning dtFloat 10 
A.DebitBeginning
 Počátek MD
DebitTurnover dtFloat 10 
A.DebitTurnover
 Obrat MD
Division dtString 5 
A.DivisionCode
 Středisko
Firm_ID dtString 10 
A.Firm_ID
 ID Firmy
FirmName dtString 220 
F.Name
 Název firmy
IsIncomplete dtBoolean 10 
A.IsIncomplete
 Neúplný účet
OrgIdentNumber dtString 15 
F.OrgIdentNumber
 IČO
Short dtBoolean 10 
A.Short
 Krátkodobý účet
StateConsolidationUnit dtBoolean 10 
F.StateConsolidationUnit
 Konsolidační jednotka státu
Taxable dtBoolean 10 
A.Taxable
 Daňový/nedaňový účet
TypeOfActivity dtInteger 10 
A.TypeOfActivity
 Typ činnosti

Podmínky

ID

Šablona:
ID
Dataset:
MAIN

Division_ID

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

Firm_ID

Šablona:
Firm_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

AccDate

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

Audited

Šablona:
Audited (Replacement Link)
Dataset:
MAIN

IsRequest

Šablona:
IsRequest (Replacement Link)
Dataset:
MAIN

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