Dynamický dotaz - Mzdy - Roční zúčtování tisk

ID:
FHNCWXSTAQJ4Z4MZ14CS0ASRNO

Datasety

MAIN

Popis:
Roční zúčtování
SQL definice:
SELECT {FIELDS}
FROM AnnualClearings A
{JOIN}
{WHERE}
{ORDERBY}
Aliasy:
Alias CLSID objektu Prefix Popis
A NRGKP3OPYD0OPEDC1UPCRTTDMC
ADR 4C3EXM5PQBCL35CH000ILPWJF4 ADR Adresa
EMP CPP5AZU1CVF13JXS00KEZYD5AW EMP Zaměstnanec
P WEC02QYERNCL35CH000ILPWJF4 PER Osoba
PR CAQPAYUOXVCL3ACL03KIU0CLP4 PR Fiskální období
SU2 22AHIVDVAVE13C5S00CA141B44 SUCorrectedBy Uživatel
SU1 22AHIVDVAVE13C5S00CA141B44 SUCreatedBy Uživatel
DQ OFTMKVQH3ZD13ACL03KIU0CLP4 DQ Řada dokladů
Fields:
Jméno Typ Velikost Výraz CLSID Popis
EMP_DateOfBirth$DATE dtFloat 10 
P.DateOfBirth$DATE
 Datum Narození
EmployeePremium dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 10)

)
 Zaměstnanecká prémie (do 2010 včetně)
EmployeePremiumMonths dtInteger 10 
(select sum(ACCOffs.MonthCount)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 10)

)
 Zaměstnanecká prémie měsíce (do 2010 včetně)
FullInvalidAdvantage dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 4) and

  (COT.Code = 'SInvP') and

  (COT.TaxAdvantage = 'A')

)
 Slevy na úplnou invaliditu
FullInvalidCountOffs dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 4) and (COT.Code = 'IP') and (COT.TaxAdvantage = 'N')

)
 Odpočty na úplnou invaliditu
GiftCountOffs dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 6) and (COT.Code = 'DA') and

  (COT.TaxAdvantage = 'N')

)
 Odpočty na dary
ChildrenCountOffs dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 1)

)
 Odpočty na dítě
ChildrenTaxAdvantage dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 1) and

  (COT.TaxAdvantage = 'A')

)
 Slevy na dítě
Invalid2Advantage dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 5) and 

  (COT.Code = 'SZTP') and

  (COT.TaxAdvantage = 'A') 

)
 Slevy na ZTP
Invalid2CountOffs dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 5) and (COT.TaxAdvantage = 'N')

)
 Odpočty na ZTP
Invalid2TaxAdvantage dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 5) and

  (COT.TaxAdvantage = 'A')

)
 Slevy na ZTP
InvalidCountOffs dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 4) and (COT.TaxAdvantage = 'N')

)
 Odpočty na invaliditu
InvalidTaxAdvantage dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 4) and

  (COT.TaxAdvantage = 'A')

)
 Slevy na invaliditu
InvalidWifeCountOffs dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 8)

)
 Odpočty na invalidní manželku
LiveAssurance dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 6) and (COT.Code = 'PZ')

)
 Životní pojištění
MinCountOffs dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 0)

)
 Nezdanitelné minimum
MortgageInterests dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 6) and ((COT.Code = 'SU') or (COT.Code = 'HU'))

)
 Úroky z úvěrů
NumPersonalNumber dtInteger 10 
ib_convchartoint(P.PersonalNumber)
 Os. číslo numericky
NurseryPlacementDiscounts dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 11)

)
 Sleva za umístění dítěte §35bb
OldAgeAdditionalInsurance dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 6) and (COT.Code = 'PP')

)
 Penzijní připojištění
OtherCountOffs dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 6)

)
 Ostatní odpočty
OtherTaxAdvantage dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 6) and

  (COT.TaxAdvantage = 'A')

)
 Slevy odpočty
PaidInterest dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 12) and

  (COT.TaxAdvantage = 'A')

)
 Zaplacené úroky (Daňový bonus)
PartialInvalidAdvantage dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 4) and 

  (COT.Code = 'SInvC') and

  (COT.TaxAdvantage = 'A')

)
 Slevy na částečnou invaliditu
PartialInvalidCountOffs dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 4) and (COT.Code = 'IC') and (COT.TaxAdvantage = 'N')

)
 Odpočty na částečnou invaliditu
PurposeInsurance dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 6) and (COT.Code = 'US')

)
 Účelové spoření
RetFund dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 6) and (COT.Code = 'DDS')

)
 Doplňkové důchodové pojištění
Spa dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 13)

)
 Odpočet na lázeňskou péči (poplatník)
SpaWifeChild dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 14)

)
 Odpočet na lázeňskou péči (manžel/manželka, dítě)
SpecialTax dtFloat 10 
(select sum(ACR.SpecialTax)

from

  AnnualClearingRows ACR

where

  (A.ID = ACR.Parent_ID)

)
 Daň zvláštní sazbou
SpecialTaxBase dtFloat 10 
(select sum(ACR.SpecialTaxBase)

from

  AnnualClearingRows ACR

where

  (A.ID = ACR.Parent_ID)

)
 Základ daně sražené zvláštní sazbou
StudentCountOffs dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 3)

)
 Odpočty na studenta
StudentTaxAdvantage dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 3) and

  (COT.TaxAdvantage = 'A')

)
 Slevy na studenta
TotalInsurance dtFloat 10 
(select sum(ACR.TotalInsurance)

from

  AnnualClearingRows ACR

where

  (A.ID = ACR.Parent_ID)

)
 Pojistné celkem
TradeUnions dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 9)

)
 Odpočty na odbory
WifeCountOffs dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 2)

)
 Odpočty na manželku
WifeTaxAdvantage dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  ((COT.CountOffKind = 2) or (COT.CountOffKind = 8)) and

  (COT.TaxAdvantage = 'A')

)
 Slevy na manželku

ANNUALCLEARIGROWS

Popis:
Řádky ročního zúčtování
SQL definice:
SELECT {FIELDS} FROM
  AnnualClearingRows A
WHERE
  A.Parent_ID=:ID
Aliasy:
Alias CLSID objektu Prefix Popis
A 1GI5RYL2RPX4NCO2XS2ZBPM4LC

WAGELISTPARTIAL

Popis:
Mzdový list díčí
SQL definice:
SELECT {FIELDS}
FROM
WageListPartial A
{JOIN}
WHERE
EMP.ID = :Employee_ID
AND
(WP.DateFrom$Date <= ib_encodedate(:YearOfClearing, 12, 31))
AND
(WP.DateTo$Date >= ib_encodedate(:YearOfClearing, 1 ,1))
Aliasy:
Alias CLSID objektu Prefix Popis
A W1ZICXOZCBF13JXS00KEZYD5AW Mzdový list dílčí
EMP CPP5AZU1CVF13JXS00KEZYD5AW EMP Zaměstnanec
WLC G2POM1Q3C3F13JXS00KEZYD5AW WLC Mzdový list společný
WP QUCSC0QN3JF13FG501C0C2VN0K WP Mzdové období
WR RFW3EQ50IEVOF2F5F33OWL1GXC WR Pracovní poměr

WAGELISTCOMMON

Popis:
Mzdový list společný
SQL definice:
SELECT {FIELDS}
FROM WageListCommon A
{JOIN}
WHERE A.EMPLOYEE_ID = :EMP_ID
AND A.WagePeriod_ID=:WagePeriod_ID
{ANDWHERE}
ORDER BY WP.DateFrom$DATE
Aliasy:
Alias CLSID objektu Prefix Popis
A G2POM1Q3C3F13JXS00KEZYD5AW Mzdový list společný
WP QUCSC0QN3JF13FG501C0C2VN0K WP Mzdové období

Podmínky

ID

Šablona:
ID
Dataset:
MAIN
Speciální parametry:
CLASSID=NRGKP3OPYD0OPEDC1UPCRTTDMC

YearOfClearing

Popiska:
Rok zúčtování
Typ/Subtyp:
ctInteger/0
ckRange:
A.YearOfClearing BETWEEN {:LOW} and {:HIGH}
Dataset:
MAIN

Employee_ID

Šablona:
Employee_ID
Dataset:
MAIN

DocQueue_ID

Šablona:
DocQueue_ID
Dataset:
MAIN

DocDate

Šablona:
DocDate
Dataset:
MAIN

OrdNumber

Šablona:
OrdNumber
Dataset:
MAIN

CreatedBy_ID

Šablona:
CreatedBy_ID
Dataset:
MAIN

CorrectedBy_ID

Šablona:
CorrectedBy_ID
Dataset:
MAIN

Period_ID

Šablona:
Period_ID
Dataset:
MAIN

TotalCountOffs

Popiska:
Celkem odpočty (nárok uplatněný v RZ)
Typ/Subtyp:
ctExtended/0
ckRange:
A.TotalCountOffs BETWEEN {:LOW} and {:HIGH}
Dataset:
MAIN

TotalTaxAdvantage

Popiska:
Celkem daňové zvýhodnění (nárok posouzený v RZ)
Typ/Subtyp:
ctExtended/0
ckRange:
A.TotalTaxAdvantage BETWEEN {:LOW} and {:HIGH}
Dataset:
MAIN

TotalBases

Popiska:
Celkem základ daně (před uplatněním odpočtů)
Typ/Subtyp:
ctExtended/0
ckRange:
A.TotalBases BETWEEN {:LOW} and {:HIGH}
Dataset:
MAIN

CalculatedTax

Popiska:
Vypočtená daň před slevou
Typ/Subtyp:
ctExtended/0
ckRange:
A.CalculatedTax BETWEEN {:LOW} and {:HIGH}
Dataset:
MAIN

CalculatedTaxAfterTaxAdvantage

Popiska:
Vypočtená daň po slevě
Typ/Subtyp:
ctExtended/0
ckRange:
(SELECT X.Result FROM MaxValue(0, A.CalculatedTax - A.TotalTaxAdvantage) X) >= {:LOW} and
(SELECT X.Result FROM MaxValue(0, A.CalculatedTax - A.TotalTaxAdvantage) X) <= {:HIGH}
Dataset:
MAIN

PaidTax

Popiska:
Zaplacené zálohy
Typ/Subtyp:
ctExtended/0
ckRange:
A.PaidTax BETWEEN {:LOW} and {:HIGH}
Dataset:
MAIN

TotalTaxBonus

Popiska:
Vyplacený daňový bonus
Typ/Subtyp:
ctExtended/0
ckRange:
A.TotalTaxBonus BETWEEN {:LOW} and {:HIGH}
Dataset:
MAIN

AnnualClearing

Popiska:
Přeplatek(+)/nedoplatek(-) na dani
Typ/Subtyp:
ctExtended/0
ckRange:
(A.Paidtax - (SELECT X.Result FROM MaxValue(0, A.CalculatedTax - A.TotalTaxAdvantage) X)) >= {:LOW} and
(A.Paidtax - (SELECT X.Result FROM MaxValue(0, A.CalculatedTax - A.TotalTaxAdvantage) X)) <= {:HIGH}
Dataset:
MAIN

Transferred

Popiska:
Výsledek přenesen do ML
Typ/Subtyp:
ctBoolean/0
ckSingle:
((A.Transferred_ID = '0000000000' OR A.Transferred_ID is Null) AND ({:VALUE}='N')) OR
(NOT (A.Transferred_ID = '0000000000' OR A.Transferred_ID is Null) AND ({:VALUE}<>'N'))
Dataset:
MAIN

AnnualClearingClosed

Popiska:
Roční zúčtování uzavřeno
Typ/Subtyp:
ctBoolean/0
ckSingle:
((A.DateOfClosing$DATE <> 0) and ({:VALUE}='A'))
or
((A.DateOfClosing$DATE = 0) and ({:VALUE}='N'))
Dataset:
MAIN

Klíče

EmployeeName

Popiska:
Příjmení a jméno
SQL:
P.LastName Collate PXW_CSY {DIR},P.FirstName Collate PXW_CSY {DIR}, EMP.ID
Dataset:
MAIN

YearOfClearing

Popiska:
Rok zúčtování
SQL:
A.YearOfClearing
Dataset:
MAIN

PersonalNumber

Popiska:
Os. číslo
SQL:
P.PersonalNumber
Dataset:
MAIN

NumPersonalNumber

Popiska:
Os. číslo numericky
SQL:
%NumPersonalNumber%
Dataset:
MAIN

DisplayName

Popiska:
Příjmení a jméno
SQL:
PR.Code Collate PXW_CSY {DIR}, DQ.Code Collate PXW_CSY {DIR}, A.OrdNumber
Dataset:
MAIN

DocDate$DATE

Popiska:
Datum dokladu
SQL:
A.DocDate$DATE
Dataset:
MAIN

DateOfClosing$DATE

Popiska:
Datum uzavření
SQL:
A.DateOfClosing$DATE
Dataset:
MAIN

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