SELECT {FIELDS} FROM
IssuedOrders A
{JOIN}
{WHERE}
{ORDERBY}
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | CDMK5QAWZZDL342X01C0CX3FCC | ||
| C | 4R5FINKNYNDL3C5P00CA141B44 | Currency | Měny |
| CT | 4J5FINKNYNDL3C5P00CA141B44 | Country | Země |
| DC | ISAXGZ5QTOKOVDRV2H15P0OTZK | DC | Schvalování dokladu |
| DQ | OFTMKVQH3ZD13ACL03KIU0CLP4 | DocQueue | Řady dokladů |
| F | 4K3EXM5PQBCL35CH000ILPWJF4 | Firm | Firmy |
| P | CAQPAYUOXVCL3ACL03KIU0CLP4 | Period | Období |
| PMS | 15ZXNPOHLIH4TG30HXYJX0CL3W | PMState | Procesní stav |
| SU1 | 22AHIVDVAVE13C5S00CA141B44 | SUCreatedBy | Uživatel |
| SU2 | 22AHIVDVAVE13C5S00CA141B44 | SUCorrectedBy | Uživatel |
| Jméno | Typ | Velikost | Výraz | CLSID | Popis |
|---|---|---|---|---|---|
| AwaitingAmount | dtFloat | 10 |
(case
when ((a.WithPrices = 'N') or (a.Closed = 'A')) then 0
else (
select
cast (sum (cast (x.TAmount / x.Quantity as numeric (18, 6)) * (cast (x.Quantity - x.DeliveredQuantity as numeric (18, 6)))) as numeric (18, 2))
from
IssuedOrders2 x
where
x.Parent_Id = a.Id and
x.RowType = 3 and
coalesce (x.DeliveredQuantity, 0) < coalesce (x.Quantity, 0) )
end)
|
Zbývá k vyřízení | |
| AwaitingAmountWithoutVAT | dtFloat | 10 |
(case
when ((a.WithPrices = 'N') or (a.Closed = 'A')) then 0
else (
select
cast (sum (cast (x.TAmountWithoutVAT / x.Quantity as numeric (18, 6)) * (cast (x.Quantity - x.DeliveredQuantity as numeric (18, 6)))) as numeric (18, 2))
from
IssuedOrders2 x
where
x.Parent_Id = a.Id and
x.RowType = 3 and
coalesce (x.DeliveredQuantity, 0) < coalesce (x.Quantity, 0) )
end)
|
Zbývá k vyřízení bez daně | |
| DocConfirmation_ID | dtString | 10 |
(SELECT ID FROM DocConfirmations WHERE Document_ID=A.ID AND DocType='IO') |
ISAXGZ5QTOKOVDRV2H15P0OTZK | Doklad schvalování |
| DocNumber | dtString | 16 |
DQ.Code || '-' || CAST(A.OrdNumber AS VARCHAR(10)) || '/' || P.Code |
Číslo dokladu | |
| LocalAwaitingAmount | dtFloat | 10 |
(case
when ((a.WithPrices = 'N') or (a.Closed = 'A')) then 0
else (
select
cast (sum (cast (x.LocalTAmount / x.Quantity as numeric (18, 6)) * (cast (x.Quantity - x.DeliveredQuantity as numeric (18, 6)))) as numeric (18, 2))
from
IssuedOrders2 x
where
x.Parent_Id = a.Id and
x.RowType = 3 and
coalesce (x.DeliveredQuantity, 0) < coalesce (x.Quantity, 0) )
end)
|
Zbývá k vyřízení (lok. měna) | |
| LocalAwaitingAmountWithoutVAT | dtFloat | 10 |
(case
when ((a.WithPrices = 'N') or (a.Closed = 'A')) then 0
else (
select
cast (sum (cast (x.LocalTAmountWithoutVAT / x.Quantity as numeric (18, 6)) * (cast (x.Quantity - x.DeliveredQuantity as numeric (18, 6)))) as numeric (18, 2))
from
IssuedOrders2 x
where
x.Parent_Id = a.Id and
x.RowType = 3 and
coalesce (x.DeliveredQuantity, 0) < coalesce (x.Quantity, 0) )
end)
|
Zbývá k vyřízení bez daně (lok. měna) | |
| VATRatesCount | dtInteger | 9 |
(SELECT COUNT(*) FROM VATRates XVR WHERE XVR.ID IN (SELECT VATRate_ID FROM IssuedOrders2 WHERE Parent_ID = A.ID AND VATRate_ID IS NOT NULL)) |
Počet DPH sazeb |
SELECT {FIELDS} FROM
IssuedOrders2 A
{JOIN}
WHERE
A.Parent_ID=:ID
ORDER BY
A.PosIndex
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | CHMK5QAWZZDL342X01C0CX3FCC | ||
| BO | K2WTYL304VD13ACL03KIU0CLP4 | BusOrder | Zakázka |
| BP | QOKMKIQUJF34L3DUICTBWEDQJC | BusProject | Projekt |
| BT | KAWTYL304VD13ACL03KIU0CLP4 | BusTransaction | Obch. případ |
| DV | O1X54EUXPZCL35CH000ILPWJF4 | Division | Středisko |
SELECT {FIELDS}
FROM
IssuedOrders2 A
JOIN VATRates VR ON VR.ID = A.VATRate_ID
WHERE
A.Parent_ID = :ID
GROUP BY
A.VATRate_ID
ORDER BY %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 | |
| VATRate | dtFloat | 6 |
MAX(VR.Tariff) |
%DPH | |
| VATRate_ID | dtString | 10 |
VATRate_ID |
ZSHD5MXH4Z24J0H2Y2R2VUZPEG | DPH sazba |
SELECT {FIELDS}
FROM DocConfirmations2 A
WHERE (A.Parent_ID = :DocConfirmation_ID)
ORDER BY ConfirmationRound, ConfirmatorOrder, ID
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | 2NQH4TZTWE3OV3WBIKM34NQC1S |
A.Confirmed = {:VALUE}
A.Closed = {:VALUE}
A.Issued = {:VALUE}
{:ANDWHERE}
TableName=IssuedOrders2
(({:Value} = 'A') AND ((A.IsAvailableForDelivery = 'A') AND (A.Closed = 'N')))
OR
(({:Value} = 'N') AND ((A.IsAvailableForDelivery = 'N') OR (A.Closed = 'A')))
( ({:VALUE} = 0) and (Y.ToIntrastat = 'N') )
or
( ({:VALUE} = 1) and (Y.ToIntrastat = 'A') )
{:VALUE}
(SELECT ID FROM DocConfirmations
WHERE Document_ID=A.ID AND DocType='IO'
)
IN
(SELECT Y.Parent_ID FROM DocConfirmations2 Y
WHERE Y.Parent_ID=
(SELECT ID FROM DocConfirmations
WHERE Document_ID=A.ID AND DocType='IO'
)
{:ANDWHERE}
)
A.DocDate$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_IDSU1.Name Collate PXW_CSY {DIR}, A.CreatedBy_IDSU2.Name Collate PXW_CSY {DIR}, A.CorrectedBy_IDCT.Code Collate PXW_CSY {DIR},A.Country_IDC.Code Collate PXW_CSY {DIR},A.Currency_IDDQ.Code Collate PXW_CSY {DIR},
P.Code Collate PXW_CSY {DIR},
A.OrdNumberA.ExternalNumber
A.Description Collate PXW_CSY
A.AmountWithoutVAT
A.LocalAmountWithoutVAT
A.LocalAmount
PMS.Code {DIR}, A.PMState_IDA.CreatedAt$DATE
A.CorrectedAt$DATE
Generated by ABRA Software a.s. 27.10.2021 16:36