POS Transaction
In ScopeTechnical: POS_TRANSACTION | ID: OR-SIOCS-POS_TRANSACTION
this table will hold the details of the pos transaction header and the line items in the transaction.
See how this object fits into Store Operations
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- POS_TRANSACTION
Field Definitions(27)
Rules & Considerations(68)
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDR | STORE_IDR | REQUEST_IDR | EXTERNAL_IDR | TRANSACTION_EXTENDED_IDR | EPC | UIN | TYPE | REASON | COMMENTS | QUANTITY | DROP_SHIP | SOURCE_TYPE | ITEM_ID_TYPE | RESA_CREATED | CUST_ORDER_ID | EXTERNAL_USER | UNIT_OF_MEASURE | FILE_CREATE_DATE | UPDATE_DATE_TIME | PROCESSING_STATUS | CUST_ORDER_TYPE_ID | CUST_ORDER_COMMENTS | FUL_ORD_EXTERNAL_ID | FUL_ORD_LINE_NUMBER | TRANSACTION_DATE_TIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | STD-POS_TRANSA-001 | 1000000001 | 1000000001 | STD-POS_TRANSA-001 | STD-POS_TRANSA-001 | POS Transaction-001 | POS Transaction-001 | 01 | 0001 | POS Transaction-001 | 11.0000 | POS Transaction-001 | 1 | 1 | POS Transaction-001 | STD-POS_TRANSA-001 | POS Transaction-001 | POS Transaction-001 | 2026-01-01 | 2026-01-01 | 0 | 1 | POS Transaction-001 | STD-POS_TRANSA-001 | 1 | 2026-01-01 |
default
- IDRPK
- 1
- ITEM_IDR
- STD-POS_TRANSA-001
- STORE_IDR
- 1000000001
- REQUEST_IDR
- 1000000001
- EXTERNAL_IDR
- STD-POS_TRANSA-001
- TRANSACTION_EXTENDED_IDR
- STD-POS_TRANSA-001
- EPC
- POS Transaction-001
- UIN
- POS Transaction-001
- TYPE
- 01
- REASON
- 0001
- COMMENTS
- POS Transaction-001
- QUANTITY
- 11.0000
- DROP_SHIP
- POS Transaction-001
- SOURCE_TYPE
- 1
- ITEM_ID_TYPE
- 1
- RESA_CREATED
- POS Transaction-001
- CUST_ORDER_ID
- STD-POS_TRANSA-001
- EXTERNAL_USER
- POS Transaction-001
- UNIT_OF_MEASURE
- POS Transaction-001
- FILE_CREATE_DATE
- 2026-01-01
- UPDATE_DATE_TIME
- 2026-01-01
- PROCESSING_STATUS
- 0
- CUST_ORDER_TYPE_ID
- 1
- CUST_ORDER_COMMENTS
- POS Transaction-001
- FUL_ORD_EXTERNAL_ID
- STD-POS_TRANSA-001
- FUL_ORD_LINE_NUMBER
- 1
- TRANSACTION_DATE_TIME
- 2026-01-01