Data About Item Basket Transactions
In ScopeTechnical: ITEM_BASKET | ID: OR-STO-ITEM_BASKET-ITEM_BASKET
Stores data about Item 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
- ITEM_BASKET
Field Definitions(5)
Rules & Considerations(24)
constraint
validation
Sample Load Data(4)
| _scenario | IDRPK | STATUSR | DYNAMIC | STORE_ID | CREATE_DATE | CREATE_USER | DESCRIPTION | UPDATE_DATE | UPDATE_USER | ALTERNATE_ID | REFERENCE_ID | EXPIRATION_DATE | ITEM_BASKET_TYPE_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | S | 1 | 2026-01-01 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 1 | 1 | 2026-01-01 | 1 |
| default | 3 | 3 | N | 1000000003 | 2026-01-03 | Item Basket-002-ALT | Item Basket-002-ALT | 2026-01-03 | 2026-01-02-ALT | 1000000003 | 1000000003 | 2026-01-03 | 1000000003 |
| default | 5 | 5 | N | 1000000005 | 2026-01-05 | Item Basket-003-EDGE | — | 2026-01-05 | 2026-01-03-EDGE | 1000000005 | — | 2026-01-05 | 1000000005 |
Example values from field definitions
- IDRPK
- 1
- STATUSR
- 1
- DYNAMIC
- S
- STORE_ID
- 1
- CREATE_DATE
- 2026-01-01
- CREATE_USER
- SAMPLE
- DESCRIPTION
- SAMPLE
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- ALTERNATE_ID
- 1
- REFERENCE_ID
- 1
- EXPIRATION_DATE
- 2026-01-01
- ITEM_BASKET_TYPE_ID
- 1
default
- IDRPK
- 3
- STATUSR
- 3
- DYNAMIC
- N
- STORE_ID
- 1000000003
- CREATE_DATE
- 2026-01-03
- CREATE_USER
- Item Basket-002-ALT
- DESCRIPTION
- Item Basket-002-ALT
- UPDATE_DATE
- 2026-01-03
- UPDATE_USER
- 2026-01-02-ALT
- ALTERNATE_ID
- 1000000003
- REFERENCE_ID
- 1000000003
- EXPIRATION_DATE
- 2026-01-03
- ITEM_BASKET_TYPE_ID
- 1000000003
default
- IDRPK
- 5
- STATUSR
- 5
- DYNAMIC
- N
- STORE_ID
- 1000000005
- CREATE_DATE
- 2026-01-05
- CREATE_USER
- Item Basket-003-EDGE
- DESCRIPTION
- —
- UPDATE_DATE
- 2026-01-05
- UPDATE_USER
- 2026-01-03-EDGE
- ALTERNATE_ID
- 1000000005
- REFERENCE_ID
- —
- EXPIRATION_DATE
- 2026-01-05
- ITEM_BASKET_TYPE_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 37
- Governed Rule Count
- 24