SELECT {FIELDS} FROM
POSDocuments A
{JOIN}
{WHERE}
{ORDERBY}
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | G2D500MLAJEL3JY400C5PPZRN0 | ||
| C | 4R5FINKNYNDL3C5P00CA141B44 | Currency | Měna |
| DQ | OFTMKVQH3ZD13ACL03KIU0CLP4 | DocQueue | Řada dokladů |
| DU | 22AHIVDVAVE13C5S00CA141B44 | DiscountUser | Slevu povolil |
| F | 4K3EXM5PQBCL35CH000ILPWJF4 | Firm | Firma |
| P | CAQPAYUOXVCL3ACL03KIU0CLP4 | Period | Období |
| PS | EFIAYR5CJY2O1FBRZRNRFSBQO0 | POSShift | Směna |
| SS | 140XNDLBOOZO3AW4BJHU0NRVKO | POSShopSellingStands | Prodejní místa |
| VP | 43QOWY2O53EL3JY400C5PPZRN0 | VirtualPOS | Pokladní místa |
SELECT {FIELDS} FROM
POSDocuments2 A
{JOIN}
WHERE
A.Parent_ID=:ID
ORDER BY
A.PosIndex
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | GED500MLAJEL3JY400C5PPZRN0 | ||
| S | SFMSB5W15BDL3CL100C4RHECN0 | Store | Sklad |
| SC | C3V5QDVZ5BDL342M01C0CX3FCC | StoreCard | Karta |
SELECT {FIELDS} FROM
POSDocuments3 A
{JOIN}
WHERE
A.Parent_ID=:ID
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | PS4MF1VTJV5433YKVCS4VMUYDC | ||
| C | 4R5FINKNYNDL3C5P00CA141B44 | Currency | Měna |
| PT | 535FINKNYNDL3C5P00CA141B44 | PT | Typ platby |
SELECT {FIELDS} FROM
POSDocuments4 A
{JOIN}
WHERE
A.Parent_ID=:ID
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | SHQDLRVGGYB4X5G2XZCZ32XD40 | ||
| C | 4R5FINKNYNDL3C5P00CA141B44 | Currency | Měna |
SELECT {FIELDS} FROM
POSDocuments5 A
WHERE
A.Parent_ID=:ID
ORDER BY
A.VATRate ASC
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | BBGMCOIN2GA4N5SDQK0SWYUWZS |
SELECT {FIELDS} FROM
POSDocuments6 A
WHERE
A.Parent_ID=:ID
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | YCSHRVQRPI445HIP31S3PTCRMK |
SELECT {FIELDS} FROM
POSDocuments4 A
{JOIN}
WHERE
A.ROW_ID=:ID
ORDER BY
A.Code
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | SHQDLRVGGYB4X5G2XZCZ32XD40 | Slevy k řádku |
SELECT {FIELDS} FROM
(
SELECT MIN(A.ID) AS GroupFirstRowID, SUM(A.Quantity) AS SumQuantity, SUM(A.Quantity / A.UnitRate) AS SumUnitQuantity, SUM(A.TotalPrice) AS SumTotalPrice, SUM(A.TAmount) AS SumTAmount, SUM(A.TAmountWithoutVAT) as SumTAmountWithoutVAT FROM
POSDocuments2 A
JOIN StoreCards SC ON SC.ID = A.StoreCard_ID
WHERE
A.Parent_ID=:ID
GROUP BY
A.StoreCard_ID,
A.QUnit,
A.TAmount/(CASE WHEN A.Quantity=0 THEN 1.0 ELSE A.Quantity END),
CASE WHEN SC.Category in (1, 2) THEN A.PosIndex ELSE 0 END,
CASE WHEN A.IsDiscount='A' THEN A.PosIndex ELSE 0 END,
CASE WHEN SC.IsScalable='A' THEN A.PosIndex ELSE 0 END
) B
JOIN POSDocuments2 A ON A.ID = B.GroupFirstRowID
{JOIN}
WHERE
A.Parent_ID=:ID
ORDER BY
A.PosIndex
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | GED500MLAJEL3JY400C5PPZRN0 | ||
| S | SFMSB5W15BDL3CL100C4RHECN0 | Store | Sklad |
| SC | C3V5QDVZ5BDL342M01C0CX3FCC | StoreCard | Karta |
SELECT {FIELDS} FROM
POSDocuments4 A
{JOIN}
WHERE
A.ROW_ID=:ID
ORDER BY
A.Code
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | SHQDLRVGGYB4X5G2XZCZ32XD40 | Slevy k řádku |
##CASEOR {:VALUE} #
##1#A.BillKind = ''
##2#A.BillKind = 'I'
##END#
A.BillKind IN ({:LIST})
A.POSReceipt_ID = {:VALUE}
A.POSReceipt_ID IN ({:LIST})
A.POSStation_ID = {:VALUE}
A.POSStation_ID IN ({:LIST})
A.POSShift_ID = {:VALUE}
A.POSShift_ID IN ({:LIST})
##CASEOR {:VALUE} #
##1#(A.POSSummaredDocument_ID is not Null)
##2#(A.POSSummaredDocument_ID is Null) and (A.IsOnStore <> 'X')
##3#(A.POSSummaredDocument_ID is Null) and (A.IsOnStore = 'X')
##END#
##CASEOR {:VALUE} #
##1#A.IsOnLine = 'A'
##2#A.IsOnLine = 'E'
##3#A.IsOnLine = '-'
##END#
##CASEOR {:VALUE} #
##1#A.IsOnStore = 'A'
##2#A.IsOnStore = 'N'
##3#A.IsOnStore = 'X'
##END#
A.POSSummaredDocument_ID = {:VALUE}
A.POSSummaredDocument_ID IN ({:LIST})
A.IsDiscount = {:VALUE}
A.DiscountUser_ID = {:VALUE}
A.DiscountUser_ID IN ({:LIST})
A.DocumentDiscount BETWEEN {:LOW} and {:HIGH}
A.RowDiscount BETWEEN {:LOW} and {:HIGH}
A.ActionDiscount BETWEEN {:LOW} and {:HIGH}
A.DealerDiscount BETWEEN {:LOW} and {:HIGH}
A.FinancialDocumentDiscount BETWEEN {:LOW} and {:HIGH}
A.Opened = {:VALUE}
A.CorrectedBy_ID = {:VALUE}
A.CorrectedBy_ID IN ({:LIST})
(A.CreatedDate$DATE >= {:LOW}) and
(A.CreatedDate$DATE < {:HIGH})
(A.ClosedDate$DATE >= {:LOW}) and
(A.ClosedDate$DATE < {:HIGH})
(A.RefundedDocDate$DATE >= {:LOW}) and
(A.RefundedDocDate$DATE < {:HIGH})
<<A.RefundedDocName>> LIKE {:VALUE} ESCAPE '~'
A.RefundedDoc_ID = {:VALUE}
A.RefundedDoc_ID IN ({:LIST})
<<A.Description>> LIKE {:VALUE} ESCAPE '~'
{:ANDWHERE}
TableName=POSDocuments2
Y.Quantity BETWEEN {:LOW} and {:HIGH}
Y.QUnit LIKE {:VALUE} ESCAPE '~'
Y.TotalPrice BETWEEN {:LOW} and {:HIGH}
Y.SerialNumber = {:VALUE}
##CASEOR {:VALUE} #
##1#Y.MethodOfWeighing = 0
##2#Y.MethodOfWeighing = 1
##3#Y.MethodOfWeighing = 2
##4#Y.MethodOfWeighing = 3
##END#
A.ID IN (SELECT Z.Parent_ID
FROM POSDocuments3 Z WHERE Z.PARENT_ID=A.ID
{:ANDWHERE})
Z.Payment BETWEEN {:LOW} and {:HIGH}
Z.Refund BETWEEN {:LOW} and {:HIGH}
A.ID IN (SELECT X.Parent_ID
FROM POSDocuments4 X WHERE X.PARENT_ID=A.ID
{:ANDWHERE})
X.Code LIKE {:VALUE} ESCAPE '~'
##CASEOR {:VALUE} #
##0#X.DiscountKind = 0
##1#X.DiscountKind = 1
##2#X.DiscountKind = 2
##3#X.DiscountKind = 3
##4#X.DiscountKind = 4
##5#X.DiscountKind = 5
##6#X.DiscountKind = 6
##7#X.DiscountKind = 7
##8#X.DiscountKind = 8
##END#
X.Automatic = {:VALUE}
X.TAmount BETWEEN {:LOW} and {:HIGH}
X.DiscountPercent BETWEEN {:LOW} and {:HIGH}
X.Finacial BETWEEN {:LOW} and {:HIGH}
SS.Code || '/' || A.Chair LIKE {:VALUE}
A.IsFiscalized = {:VALUE}
A.SimplifiedVATDocument = {:VALUE}
A.CreatedDate$DATE
P.Code Collate PXW_CSY {DIR},A.Period_IDA.OrdNumber
A.Amount
DQ.Code Collate PXW_CSY {DIR},A.DocQueue_IDA.CreatedBy_ID
A.CorrectedBy_ID
C.Code Collate PXW_CSY {DIR},A.Currency_IDVP.Name {DIR},A.VirtualPOS_IDDQ.Code Collate PXW_CSY {DIR},
P.Code Collate PXW_CSY {DIR},
A.OrdNumberGenerated by ABRA Software a.s. 27.10.2021 16:36