Store Order Line Item Information
In ScopeTechnical: STORE_ORDER_LINE_ITEM | ID: OR-STO-STORE_ORDER_LINE_ITEM-STORE_ORDER_LINE_ITEM
Stores store order line item information.
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
- STORE_ORDER_LINE_ITEM
Field Definitions(5)
Rules & Considerations(18)
constraint
validation
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDRPK | STORE_ORDER_IDRPK | QUANTITY | CASE_SIZE | UNIT_COST_VALUE | DELIVERY_SLOT_ID | UNIT_COST_CURRENCY | QUANTITY_EXTERNAL_ORDER |
|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1.0000 | 1.00 | 1.0000 | 1 | SAM | 1.0000 |
| default | 3 | ALT-STORE_ORDE-002 | 1000000003 | 12.5000 | 12.50 | 12.5000 | 1000000003 | Sto | 12.5000 |
| default | 5 | EDGE-STORE_ORDE-003 | 1000000005 | 14.0000 | 14.00 | 14.0000 | 1000000005 | Sto | 14.0000 |
Example values from field definitions
- IDRPK
- 1
- ITEM_IDRPK
- SAMPLE
- STORE_ORDER_IDRPK
- 1
- QUANTITY
- 1.0000
- CASE_SIZE
- 1.00
- UNIT_COST_VALUE
- 1.0000
- DELIVERY_SLOT_ID
- 1
- UNIT_COST_CURRENCY
- SAM
- QUANTITY_EXTERNAL_ORDER
- 1.0000
default
- IDRPK
- 3
- ITEM_IDRPK
- ALT-STORE_ORDE-002
- STORE_ORDER_IDRPK
- 1000000003
- QUANTITY
- 12.5000
- CASE_SIZE
- 12.50
- UNIT_COST_VALUE
- 12.5000
- DELIVERY_SLOT_ID
- 1000000003
- UNIT_COST_CURRENCY
- Sto
- QUANTITY_EXTERNAL_ORDER
- 12.5000
default
- IDRPK
- 5
- ITEM_IDRPK
- EDGE-STORE_ORDE-003
- STORE_ORDER_IDRPK
- 1000000005
- QUANTITY
- 14.0000
- CASE_SIZE
- 14.00
- UNIT_COST_VALUE
- 14.0000
- DELIVERY_SLOT_ID
- 1000000005
- UNIT_COST_CURRENCY
- Sto
- QUANTITY_EXTERNAL_ORDER
- 14.0000
Rule Validation Summary
- Source Rule Count
- 26
- Governed Rule Count
- 18