SELECT {FIELDS} FROM
CashPaid A
{JOIN}
{WHERE}
{ORDERBY}
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | 0RXJZGDLBBDL3ACR03KIU0CLP4 | ||
| ADQ | OBTMKVQH3ZD13ACL03KIU0CLP4 | AccDocQueue | Účetní řada dokladů |
| C | 4R5FINKNYNDL3C5P00CA141B44 | Currency | Měna |
| CD | SDDAHWVT5ND133N4010DELDFKK | CashDesk | Pokladny |
| CT | 4J5FINKNYNDL3C5P00CA141B44 | Country | Země |
| DC | ISAXGZ5QTOKOVDRV2H15P0OTZK | DC | Schvalování dokladu |
| DQ | OFTMKVQH3ZD13ACL03KIU0CLP4 | DocQueue | Řada dokladů |
| F | 4K3EXM5PQBCL35CH000ILPWJF4 | Firm | Firma |
| P | CAQPAYUOXVCL3ACL03KIU0CLP4 | Period | Období |
| Jméno | Typ | Velikost | Výraz | CLSID | Popis |
|---|---|---|---|---|---|
| AccountingType | dtInteger | 1 |
(select Max(IValue) from SYS$DECIDETable where IValue = 0 or A.AccDocQueue_ID is not Null) + (select Max(IValue) from SYS$DECIDETable where IValue = 0 or (A.AccDocQueue_ID is not Null and ADQ.SummaryAccounted <> 'N')) |
Typ účtování | |
| DocConfirmation_ID | dtString | 10 |
(SELECT ID FROM DocConfirmations WHERE Document_ID=A.ID AND DocType='06') |
ISAXGZ5QTOKOVDRV2H15P0OTZK | Doklad schvalování |
| DocNumber | dtString | 16 |
DQ.Code || '-' || CAST(A.OrdNumber AS VARCHAR(10)) || '/' || P.Code |
Číslo dokladu | |
| IsAccounted | dtBoolean | 1 |
(select BoolValue from SYS$DECIDETABLEBOOL where IValue =
(select Max(IValue) from SYS$DECIDETable where IValue = 0 or
((select Count(*) from Relations where
Rel_Def={$RELDEF} and LeftSide_ID=A.ID) > 0)
))
|
Účtováno | |
| VATRatesCount | dtInteger | 9 |
(SELECT COUNT(*) FROM VATRates XVR WHERE XVR.ID IN (SELECT VATRate_ID FROM CashPaid2 WHERE Parent_ID = A.ID AND VATRate_ID IS NOT NULL)) |
Počet DPH sazeb | |
| VATRatesCountMode0 | dtInteger | 9 |
(SELECT COUNT(*) FROM VATRates XVR WHERE XVR.ID IN (SELECT VATRate_ID FROM CashPaid2 WHERE Parent_ID = A.ID AND VATRate_Id IS NOT NULL AND VATMode <> 1)) |
Počet DPH sazeb v režimu 0 | |
| VATRatesCountMode1 | dtInteger | 9 |
(SELECT COUNT(*) FROM VATRates XVR WHERE XVR.ID IN (SELECT VATRate_ID FROM CashPaid2 WHERE Parent_ID = A.ID AND VATRate_Id IS NOT NULL AND VATMode = 1)) |
Počet DPH sazeb v režimu 1 |
SELECT {FIELDS} FROM
CashPaid2 A
{JOIN}
WHERE
A.Parent_ID=:ID
ORDER BY
A.PosIndex
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | 0NXJZGDLBBDL3ACR03KIU0CLP4 | ||
| BO | K2WTYL304VD13ACL03KIU0CLP4 | BusOrder | Zakázka |
| BP | QOKMKIQUJF34L3DUICTBWEDQJC | BusProject | Projekt |
| BT | KAWTYL304VD13ACL03KIU0CLP4 | BusTransaction | Obch. případ |
| DV | O1X54EUXPZCL35CH000ILPWJF4 | Division | Středisko |
SELECT {FIELDS}
FROM
GeneralLedger A
{JOIN}
WHERE
R.REL_DEF=8 AND
R.LEFTSIDE_ID=:ID
ORDER BY %Text% ASC, %AccDate$DATE% ASC
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | C3S1BMBT4RD13ACL03KIU0CLP4 | ||
| R | 01ZXNDSYDVD135SA02K2CQM5AW | Vazba mezi doklady |
SELECT {FIELDS}
FROM
CashPaid2 A
JOIN VATRates VR ON VR.ID = A.VATRate_ID
WHERE
A.Parent_ID = :ID
GROUP BY
A.VATMode, A.VATRate_ID
ORDER BY %VATMode% ASC, %VATRate% DESC
| Jméno | Typ | Velikost | Výraz | CLSID | Popis |
|---|---|---|---|---|---|
| Amount | dtFloat | 14 |
SUM(TAmount) |
Částka s daní | |
| AmountWithoutVAT | dtFloat | 14 |
SUM(TAmountWithoutVAT) |
Částka bez daně | |
| LocalAmount | dtFloat | 14 |
SUM(LocalTAmount) |
Částka s daní lok. | |
| LocalAmountWithoutVAT | dtFloat | 14 |
SUM(LocalTAmountWithoutVAT) |
Částka bez daně lok. | |
| Name | dtString | 20 |
MAX(VR.Name) |
Název | |
| VATMode | dtInteger | 10 |
MAX(VATMode) |
Režim DPH | |
| VATRate | dtFloat | 6 |
MAX(VR.Tariff) |
%DPH | |
| VATRate_ID | dtString | 10 |
VATRate_ID |
ZSHD5MXH4Z24J0H2Y2R2VUZPEG | DPH sazba |
SELECT {FIELDS}
FROM ReverseChargeDeclarations A
WHERE A.SDocument_ID = :ID
and A.SDocumentType = '06'
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | XCBZKJFXQOR4B41FSW0E3SIGNO |
SELECT {FIELDS}
FROM DocConfirmations2 A
WHERE (A.Parent_ID = :DocConfirmation_ID)
ORDER BY ConfirmationRound, ConfirmatorOrder, ID
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | 2NQH4TZTWE3OV3WBIKM34NQC1S |
0 {:VALUE} (select Count(*) from Relations where
Rel_Def={$RELDEF} and LeftSide_ID=A.ID)
(((select Count(*) from ReverseChargeDeclarations where SDocument_ID = A.ID and SDocumentType = '06') > 0) and ({:VALUE} = 'A'))
or
((((select Count(*) from ReverseChargeDeclarations where SDocument_ID = A.ID and SDocumentType = '06') = 0) and (A.IsReverseChargeDeclared = 'A') and (A.TradeType = 2)) and ({:VALUE} = 'N'))
A.IsFiscalized = {:VALUE}
##CASEOR {:VALUE} #
##1#A.FiscalizationMode = '0'
##2#A.FiscalizationMode = '1'
##3#A.FiscalizationMode = '2'
##4#A.FiscalizationMode = '3'
##5#A.FiscalizationMode = '99'
##END#
{:ANDWHERE}
TableName=CashPaid2
(SELECT ID FROM DocConfirmations
WHERE Document_ID=A.ID AND DocType='06'
)
IN
(SELECT Y.Parent_ID FROM DocConfirmations2 Y
WHERE Y.Parent_ID=
(SELECT ID FROM DocConfirmations
WHERE Document_ID=A.ID AND DocType='06'
)
{:ANDWHERE}
)
A.DocDate$DATE
A.VATDate$DATE
A.OrdNumber
A.Amount
F.Name Collate PXW_CSY {DIR},A.Firm_IDP.Code Collate PXW_CSY {DIR},A.Period_IDDQ.Code Collate PXW_CSY {DIR},A.DocQueue_IDA.CreatedBy_ID
A.CorrectedBy_ID
CT.Code Collate PXW_CSY {DIR},A.Country_IDC.Code Collate PXW_CSY {DIR},A.Currency_IDA.ExternalNumber
CD.Name {DIR},A.CashDesk_IDDQ.Code Collate PXW_CSY {DIR},
P.Code Collate PXW_CSY {DIR},
A.OrdNumberA.Description Collate PXW_CSY
A.AmountWithoutVAT
A.CreditAmount
A.LocalAmountWithoutVAT
A.LocalAmount
A.LocalCreditAmount
A.FiscalizationMode
A.AccDate$DATE
Generated by ABRA Software a.s. 27.10.2021 16:36