Data About Product Basket Transactions
In ScopeTechnical: PRODUCT_BASKET | ID: OR-STO-PRODUCT_BASKET-PRODUCT_BASKET
Stores data about product basket transactions.
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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- PRODUCT_BASKET
Field Definitions(5)
Rules & Considerations(18)
constraint
validation
Sample Load Data(4)
| _scenario | IDRPK | STATUSR | CREATE_STORE_IDR | TYPE | CREATE_DATE | CREATE_USER | DESCRIPTION | UPDATE_DATE | UPDATE_USER | ITEM_BASKET_ID |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 2026-01-01 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 1 |
| default | 3 | 3 | 1000000003 | 3 | 2026-01-03 | Product Basket-002-ALT | Product Basket-002-ALT | 2026-01-03 | 2026-01-02-ALT | 1000000003 |
| default | 5 | 5 | 1000000005 | 5 | 2026-01-05 | Product Basket-003-EDGE | — | 2026-01-05 | 2026-01-03-EDGE | 1000000005 |
Example values from field definitions
- IDRPK
- 1
- STATUSR
- 1
- CREATE_STORE_IDR
- 1
- TYPE
- 1
- CREATE_DATE
- 2026-01-01
- CREATE_USER
- SAMPLE
- DESCRIPTION
- SAMPLE
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- ITEM_BASKET_ID
- 1
default
- IDRPK
- 3
- STATUSR
- 3
- CREATE_STORE_IDR
- 1000000003
- TYPE
- 3
- CREATE_DATE
- 2026-01-03
- CREATE_USER
- Product Basket-002-ALT
- DESCRIPTION
- Product Basket-002-ALT
- UPDATE_DATE
- 2026-01-03
- UPDATE_USER
- 2026-01-02-ALT
- ITEM_BASKET_ID
- 1000000003
default
- IDRPK
- 5
- STATUSR
- 5
- CREATE_STORE_IDR
- 1000000005
- TYPE
- 5
- CREATE_DATE
- 2026-01-05
- CREATE_USER
- Product Basket-003-EDGE
- DESCRIPTION
- —
- UPDATE_DATE
- 2026-01-05
- UPDATE_USER
- 2026-01-03-EDGE
- ITEM_BASKET_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 26
- Governed Rule Count
- 18