Dynamický dotaz - Doklady reverse charge

ID:
OYXFSXUBDV54NBUMNX0NM2VPEW

Datasety

MAIN

Popis:
Doklady reverse charge
SQL definice:
SELECT {FIELDS} FROM 
  ReverseChargeDeclarations A
  {JOIN}
{WHERE} 
{ORDERBY}
Aliasy:
Alias CLSID objektu Prefix Popis
A XCBZKJFXQOR4B41FSW0E3SIGNO
DQ OFTMKVQH3ZD13ACL03KIU0CLP4 DocQueue Řada dokladů
F 4K3EXM5PQBCL35CH000ILPWJF4 Firm Firma
P CAQPAYUOXVCL3ACL03KIU0CLP4 Period Období
SU2 22AHIVDVAVE13C5S00CA141B44 SUCorrectedBy Uživatel
SU1 22AHIVDVAVE13C5S00CA141B44 SUCreatedBy Uživatel
Fields:
Jméno Typ Velikost Výraz CLSID Popis
DocNumber dtString 16 
DQ.Code || '-' || CAST(A.OrdNumber AS VARCHAR(10)) || '/' || P.Code
 Číslo dokladu

ROWS

Popis:
Řádky
SQL definice:
SELECT {FIELDS} FROM
  ReverseChargeDeclarations2 A
  {JOIN}
WHERE
  A.Parent_ID=:ID 
ORDER BY
  A.PosIndex
Aliasy:
Alias CLSID objektu Prefix Popis
A DZXHVYD4EYG43H4XOC512DGQVW
BO K2WTYL304VD13ACL03KIU0CLP4 BusOrder Zakázka
BP QOKMKIQUJF34L3DUICTBWEDQJC BusProject Projekt
BT KAWTYL304VD13ACL03KIU0CLP4 BusTransaction Obch. případ
DV O1X54EUXPZCL35CH000ILPWJF4 Division Středisko

BOOK

Popis:
Účetní deník
SQL definice:
SELECT {FIELDS} FROM
  GeneralLedger A
  {JOIN}
WHERE
  R.REL_DEF=46 AND
  R.LEFTSIDE_ID=:ID
Aliasy:
Alias CLSID objektu Prefix Popis
A C3S1BMBT4RD13ACL03KIU0CLP4
R 01ZXNDSYDVD135SA02K2CQM5AW Relation Vazba mezi doklady

Podmínky

ID

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

DocumentType

Popiska:
Typ zdroj.dokladu
Typ/Subtyp:
ctSpecial/0
ckSingle:
A.SDocumentType = {:VALUE}
ckList:
A.SDocumentType IN ({:LIST})
Dataset:
MAIN
Speciální parametry:
CLASSID=WBFHFPM0V3CL33N2010DELDFKK
FilterDocumentType=04;61;06;08;64;65;12
DisplayField=Name

DocQueue_ID

Šablona:
DocQueue_ID
Dataset:
MAIN
Speciální parametry:
FilterDocumentType=RC

Period_ID

Šablona:
Period_ID
Dataset:
MAIN

OrdNumber

Šablona:
OrdNumber
Dataset:
MAIN

DocDate

Šablona:
DocDate
Dataset:
MAIN

Description

Šablona:
Description
Dataset:
MAIN

CreatedBy_ID

Šablona:
CreatedBy_ID
Dataset:
MAIN

CorrectedBy_ID

Šablona:
CorrectedBy_ID
Dataset:
MAIN

Firm_ID

Šablona:
Firm_ID (joined)
Dataset:
MAIN

FirmOffice_ID

Šablona:
FirmOffice_ID
Dataset:
MAIN

Person_ID

Šablona:
Person_ID
Dataset:
MAIN

Amount

Popiska:
Částka odvodu DPH
Typ/Subtyp:
ctExtended/0
ckRange:
A.Amount BETWEEN {:LOW} and {:HIGH}
Dataset:
MAIN

LocalAmount

Popiska:
Částka odvodu DPH (v lokální měně)
Typ/Subtyp:
ctExtended/0
ckRange:
A.LocalAmount BETWEEN {:LOW} and {:HIGH}
Dataset:
MAIN

AccDate

Šablona:
AccDate
Dataset:
MAIN

VATDate

Popiska:
Datum přiznání DPH
Typ/Subtyp:
ctDateTime/0
ckRange:
A.VATDate$DATE >= {:LOW} and
A.VATDate$DATE < {:HIGH}
Dataset:
MAIN

VATDeductionDate

Popiska:
Datum odpočtu DPH
Typ/Subtyp:
ctDateTime/0
ckRange:
A.VATDeductionDate$DATE >= {:LOW} and
A.VATDeductionDate$DATE < {:HIGH}
Dataset:
MAIN

SourceDocState

Popiska:
Jen chybně či neúplně vystavené
Typ/Subtyp:
ctSpecial/14
ckSingle:
##CASEOR {:VALUE} #
##1# (A.ID in (
select A.ID from ReverseChargeDeclarations A
 where
  ((select SUM(RI.AmountWithoutVAT) from ReceivedInvoices RI where
    A.SDocumentType = '04' and RI.ID = A.SDocument_ID) >
   (select SUM(R.SourceAmount) from ReverseChargeDeclarations2 R where Parent_ID = A.ID))
  or
  ((select SUM(RCN.AmountWithoutVAT) from ReceivedCreditNotes RCN where
    A.SDocumentType = '61' and RCN.ID = A.SDocument_ID) >
   (select SUM(R.SourceAmount) from ReverseChargeDeclarations2 R where Parent_ID = A.ID))
  or
  ((select SUM(CP.AmountWithoutVAT) from CashPaid CP where
    A.SDocumentType = '06' and CP.ID = A.SDocument_ID) >
   (select SUM(R.SourceAmount) from ReverseChargeDeclarations2 R where Parent_ID = A.ID))
  or
  ((select SUM(RCP.AmountWithoutVAT) from RefundedCashPaid RCP where
    A.SDocumentType = '08' and RCP.ID = A.SDocument_ID) >
   (select SUM(R.SourceAmount) from ReverseChargeDeclarations2 R where Parent_ID = A.ID))
  or
  ((select SUM(CD2.CustomsAmount + CD2.ImportTax + CD2.SpendingTax
    + CD2.VATAmount + CD2.VATBaseAmount + CD2.VATBaseCorrection)
    from CustomsDeclarations2 CD2
    inner join CustomsDeclarations CD on CD.ID = CD2.Parent_ID
    where A.SDocumentType = '12' and CD.ID = A.SDocument_ID) >
   (select SUM(R.SourceAmount) from ReverseChargeDeclarations2 R where Parent_ID = A.ID))))
##2# (A.ID in (
select A.ID from ReverseChargeDeclarations A
 where
  ((select SUM(RI.AmountWithoutVAT) from ReceivedInvoices RI where
    A.SDocumentType = '04' and RI.ID = A.SDocument_ID) <
   (select SUM(R.SourceAmount) from ReverseChargeDeclarations2 R where Parent_ID = A.ID))
  or
  ((select SUM(RCN.AmountWithoutVAT) from ReceivedCreditNotes RCN where
    A.SDocumentType = '61' and RCN.ID = A.SDocument_ID) <
   (select SUM(R.SourceAmount) from ReverseChargeDeclarations2 R where Parent_ID = A.ID))
  or
  ((select SUM(CP.AmountWithoutVAT) from CashPaid CP where
    A.SDocumentType = '06' and CP.ID = A.SDocument_ID) <
   (select SUM(R.SourceAmount) from ReverseChargeDeclarations2 R where Parent_ID = A.ID))
  or
  ((select SUM(RCP.AmountWithoutVAT) from RefundedCashPaid RCP where
    A.SDocumentType = '08' and RCP.ID = A.SDocument_ID) <
   (select SUM(R.SourceAmount) from ReverseChargeDeclarations2 R where Parent_ID = A.ID))
  or
  ((select SUM(CD2.CustomsAmount + CD2.ImportTax + CD2.SpendingTax
    + CD2.VATAmount + CD2.VATBaseAmount + CD2.VATBaseCorrection)
    from CustomsDeclarations2 CD2
    inner join CustomsDeclarations CD on CD.ID = CD2.Parent_ID
    where A.SDocumentType = '12' and CD.ID = A.SDocument_ID) <
   (select SUM(R.SourceAmount) from ReverseChargeDeclarations2 R where Parent_ID = A.ID))))
##END#
Dataset:
MAIN
Speciální parametry:
Names=DPH přiznána částečně (neúplné DRC);Přiznána vyšší částka DPH (chybné DRC)
Values=1;2

VATCountry_ID

Šablona:
VATCountry_ID
Dataset:
MAIN

CreatedAt

Šablona:
CreatedAt
Dataset:
MAIN

CorrectedAt

Šablona:
CorrectedAt
Dataset:
MAIN

VATReportPreference

Šablona:
VATReportPreference
Dataset:
MAIN

Rows

Popiska:
Řádky
Typ/Subtyp:
ctSpecial/3
ckLink:
{:ANDWHERE}
TableName=ReverseChargeDeclarations2
Dataset:
MAIN
Speciální parametry:
CLASSID=DZXHVYD4EYG43H4XOC512DGQVW

RowsText

Šablona:
Text
Dataset:
MAIN
Nadřízený:
Rows

RowsDivision_ID

Šablona:
Division_ID
Dataset:
MAIN
Nadřízený:
Rows

RowsBusOrder_ID

Šablona:
BusOrder_ID
Dataset:
MAIN
Nadřízený:
Rows

RowsBusProject_ID

Šablona:
BusProject_ID
Dataset:
MAIN
Nadřízený:
Rows

RowsBusTransaction_ID

Šablona:
BusTransaction_ID
Dataset:
MAIN
Nadřízený:
Rows

RowsVATIndex_ID

Šablona:
VATIndex_ID
Dataset:
MAIN
Nadřízený:
Rows

Source_ID

Popiska:
Zdrojový doklad
Typ/Subtyp:
ctString/0
ckSingle:
A.SDocument_ID = {:VALUE}
ckList:
A.SDocument_ID IN ({:LIST})
Dataset:
MAIN
Speciální parametry:
Hidden=True

Klíče

DocDate

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

OrdNumber

Popiska:
Číslo dokladu
SQL:
A.OrdNumber
Dataset:
MAIN

LocalAmount

Popiska:
Částka lok.
SQL:
A.LocalAmount
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

DocQueue

Popiska:
Zkratka řady
SQL:
DQ.Code Collate PXW_CSY {DIR},A.DocQueue_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

DocumentNumber

Popiska:
Číslo dokladu (složené)
SQL:
DQ.Code Collate PXW_CSY {DIR}, 

P.Code Collate PXW_CSY {DIR},

A.OrdNumber
Dataset:
MAIN

Description

Popiska:
Popis
SQL:
A.Description Collate PXW_CSY
Dataset:
MAIN

AccDate

Popiska:
Datum účtování
SQL:
A.AccDate$DATE
Dataset:
MAIN

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