Store Fulfillment Order Line Items
In ScopeTechnical: FUL_ORD_LINE_ITEM | ID: OR-STO-FUL_ORD_LINE_ITEM-FULFILLMENT_ORDER_LINE_ITEM
Stores store fulfillment order line items.
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
- FUL_ORD_LINE_ITEM
Field Definitions(5)
Rules & Considerations(32)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDR | FUL_ORD_IDR | COMMENTS | CREATE_DATE | LINE_NUMBER | UPDATE_DATE | PREFERRED_UOM | QUANTITY_PICKED | UNIT_COST_VALUE | QUANTITY_ORDERED | QUANTITY_CANCELED | QUANTITY_RESERVED | ALLOW_SUBSTITUTION | QUANTITY_DELIVERED | UNIT_COST_CURRENCY | SUBSTITUTE_LINE_ITEM_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | SAMPLE | 2026-01-01 | 1 | 2026-01-01 | SAMP | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | S | 1.0000 | SAM | 1 |
| default | 3 | ALT-FUL_ORD-002 | 1000000003 | Ful Ord Line Item-002-ALT | 2026-01-03 | 3 | 2026-01-03 | Ful | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | F | 12.5000 | Ful | 1000000003 |
| default | 5 | EDGE-FUL_ORD-003 | 1000000005 | Ful Ord Line Item-003-EDGE | 2026-01-05 | 5 | 2026-01-05 | Ful | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | F | 14.0000 | Ful | 1000000005 |
Example values from field definitions
- IDRPK
- 1
- ITEM_IDR
- SAMPLE
- FUL_ORD_IDR
- 1
- COMMENTS
- SAMPLE
- CREATE_DATE
- 2026-01-01
- LINE_NUMBER
- 1
- UPDATE_DATE
- 2026-01-01
- PREFERRED_UOM
- SAMP
- QUANTITY_PICKED
- 1.0000
- UNIT_COST_VALUE
- 1.0000
- QUANTITY_ORDERED
- 1.0000
- QUANTITY_CANCELED
- 1.0000
- QUANTITY_RESERVED
- 1.0000
- ALLOW_SUBSTITUTION
- S
- QUANTITY_DELIVERED
- 1.0000
- UNIT_COST_CURRENCY
- SAM
- SUBSTITUTE_LINE_ITEM_ID
- 1
default
- IDRPK
- 3
- ITEM_IDR
- ALT-FUL_ORD-002
- FUL_ORD_IDR
- 1000000003
- COMMENTS
- Ful Ord Line Item-002-ALT
- CREATE_DATE
- 2026-01-03
- LINE_NUMBER
- 3
- UPDATE_DATE
- 2026-01-03
- PREFERRED_UOM
- Ful
- QUANTITY_PICKED
- 12.5000
- UNIT_COST_VALUE
- 12.5000
- QUANTITY_ORDERED
- 12.5000
- QUANTITY_CANCELED
- 12.5000
- QUANTITY_RESERVED
- 12.5000
- ALLOW_SUBSTITUTION
- F
- QUANTITY_DELIVERED
- 12.5000
- UNIT_COST_CURRENCY
- Ful
- SUBSTITUTE_LINE_ITEM_ID
- 1000000003
default
- IDRPK
- 5
- ITEM_IDR
- EDGE-FUL_ORD-003
- FUL_ORD_IDR
- 1000000005
- COMMENTS
- Ful Ord Line Item-003-EDGE
- CREATE_DATE
- 2026-01-05
- LINE_NUMBER
- 5
- UPDATE_DATE
- 2026-01-05
- PREFERRED_UOM
- Ful
- QUANTITY_PICKED
- 14.0000
- UNIT_COST_VALUE
- 14.0000
- QUANTITY_ORDERED
- 14.0000
- QUANTITY_CANCELED
- 14.0000
- QUANTITY_RESERVED
- 14.0000
- ALLOW_SUBSTITUTION
- F
- QUANTITY_DELIVERED
- 14.0000
- UNIT_COST_CURRENCY
- Ful
- SUBSTITUTE_LINE_ITEM_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 48
- Governed Rule Count
- 32