OZRD - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Finance /

POS Daily Summary

API OZRD

OZRD - POS Daily Summary Table

SBO SQL database table details

Field	Description	Type	Size	Related	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Number	Int	11		PRIMARY	Yes
DocDate	Document Date	Date	8
POSEquipNo	POS Equipment No.	nVarChar	20	OPOS POS Master Data
ResetCntr	Reset Counter	Int	11
SummaryCnt	Summary Counter	Int	11
OperCntr	Operation Counter	Int	11
TotalSum	Total Sum	Num	20
GrossSale	Gross Sale Sum	Num	20
PISSum	PIS Sum	Num	20
COFINSSum	COFINS Sum	Num	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

OPOS SQL Table

biuan SAP® BUSINESS ONE

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