biuan SAP® BUSINESS ONE SDK
API OZRD
OZRD - POS Daily Summary Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocDateDocument DateDate
8
POSEquipNoPOS Equipment No.nVarChar
20OPOS
POS Master Data
ResetCntrReset CounterInt
11
SummaryCntSummary CounterInt
11
OperCntrOperation CounterInt
11
TotalSumTotal SumNum
20
GrossSaleGross Sale SumNum
20
PISSumPIS SumNum
20
COFINSSumCOFINS SumNum
20

Table relationship map

SELECT statement

SELECT OZRD.AbsEntry AS 'Internal Number', OZRD.DocDate AS 'Document Date', OZRD.POSEquipNo AS 'POS Equipment No.', OZRD.ResetCntr AS 'Reset Counter', OZRD.SummaryCnt AS 'Summary Counter', OZRD.OperCntr AS 'Operation Counter', OZRD.TotalSum AS 'Total Sum', OZRD.GrossSale AS 'Gross Sale Sum', OZRD.PISSum AS 'PIS Sum', OZRD.COFINSSum AS 'COFINS Sum' FROM OZRD AS OZRD

Related information


OZRD SQL Table

POS Master Data OPOS SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates