Full and Exception Data 
MultiProvider: 0LPA_MP01
This MultiProvider is based on the Cashier Statistics (0RPA_C05) and LPA Exception Data (0LPA_C01) InfoCubes. This MultiProvider provides information to generate exception and summary reports for Loss Prevention Analytics (LPA). These reports show information at various hierarchical levels in a company, such as company, region, sales district, store, cashier, date, and transaction levels.
Data Modeling
Object Type | Name | Technical Name |
|---|---|---|
InfoObject | Calendar Day | 0CALDAY |
InfoObject | Change Run ID | 0CHNGID |
InfoObject | Document currency | 0DOC_CURRCY |
InfoCube | LPA Exception Data | 0LPA_C01 |
InfoObject | LPA: Number of POS Receipts | 0LPA_CNR |
InfoObject | No Sale Transaction Count | 0LPA_NSCNR |
InfoObject | Pattern ID | 0LPA_PTRN |
InfoObject | LPA: Transaction Discount | 0LPA_REA |
InfoObject | LPA: Item Discount | 0LPA_REAMER |
InfoObject | LPA: Tax Amount | 0LPA_TAM |
InfoObject | Transaction Discount Count | 0LPA_TDCNR |
InfoObject | Transaction Time | 0LPA_TTIM |
InfoObject | Record type | 0RECORDTP |
InfoObject | Request ID | 0REQUID |
InfoObject | Counted Amount | 0RPA_ACA |
InfoObject | Amount Transferred to Bank | 0RPA_BAM |
InfoCube | Cashier Statistics | 0RPA_C05 |
InfoObject | Number of Discount Items | 0RPA_CCO |
InfoObject | Value of Checks over Limit | 0RPA_CLA |
InfoObject | Number of Checks over Limit | 0RPA_CLC |
InfoObject | Number of POS Receipts | 0RPA_CNR |
InfoObject | Department (POS Controller) | 0RPA_DEP |
InfoObject | Discount Type | 0RPA_DTC |
InfoObject | Discount Type Group | 0RPA_DTG |
InfoObject | Number of Failed Logons | 0RPA_FLC |
InfoObject | Time Between Transactions When No Money Is Being Taken | 0RPA_IDT |
InfoObject | Number of Sales Items | 0RPA_LIC |
InfoObject | Time For Which Cash Desk Was Locked | 0RPA_LOT |
InfoObject | Logon Time | 0RPA_LTI |
InfoObject | Value of Line Cancellations | 0RPA_LVA |
InfoObject | Number of Line Cancellations | 0RPA_LVC |
InfoObject | Normal Sales Value | 0RPA_NSA |
InfoObject | Number of Void Receipts | 0RPA_NST |
InfoObject | Variance Over | 0RPA_OAM |
InfoObject | Value of Material Group Sales | 0RPA_ODA |
InfoObject | Number of Material Group Sales | 0RPA_ODC |
InfoObject | Cashier Number | 0RPA_OID |
InfoObject | Value of Transaction Cancellations | 0RPA_PVA |
InfoObject | Number of Transaction Cancellations | 0RPA_PVC |
InfoObject | Value Removed | 0RPA_RAM |
InfoObject | Number of Cash Removals | 0RPA_RCN |
InfoObject | Number of Reports | 0RPA_RCT |
InfoObject | Discount Value | 0RPA_REA |
InfoObject | Goods Discount Value | 0RPA_REAMER |
InfoObject | Return Sales | 0RPA_RETSAL |
InfoObject | Reversal Indicator (Reversal from PIPE) | 0RPA_RFL |
InfoObject | Classification of Sales Item: Category | 0RPA_RIC |
InfoObject | Classification of Sales Item: Subcategory | 0RPA_RISC |
InfoObject | POS: Returns Quantity (Sales Unit) | 0RPA_RQTYV |
InfoObject | Sales Item Type | 0RPA_RTC |
InfoObject | Cashier Time | 0RPA_RTI |
InfoObject | Variance Short | 0RPA_SAM |
InfoObject | Sales at Retail Value | 0RPA_SAT |
InfoObject | Value of Scanned Items | 0RPA_SIA |
InfoObject | Number of Scanned Items | 0RPA_SIC |
InfoObject | Tax Amount | 0RPA_TAM |
InfoObject | Tender Value | 0RPA_TAT |
InfoObject | Means of Payment | 0RPA_TCD |
InfoObject | Number of Transactions | 0RPA_TCN |
InfoObject | Number of Terminations | 0RPA_TCO |
InfoObject | Value of Terminations | 0RPA_TEA |
InfoObject | Tender Identifier | 0RPA_TID |
InfoObject | Transaction Index | 0RPA_TIX |
InfoObject | Transaction Type | 0RPA_TTC |
InfoObject | Value of Immediate Cancellations | 0RPA_VAM |
InfoObject | Indicator for Cancelled Items | 0RPA_VOIDFL |
InfoObject | POS Number | 0RPA_WID |
InfoObject | Retail location | 0RT_LOCATIO |
InfoObject | Sales unit | 0SALES_UNIT |