|
|
SQL Finance / POS Daily Summary
API OZRD
OZRD - POS Daily Summary Table
OZRD SQL Table
POS Master Data OPOS SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | 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
POS Master Data OPOS SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates