Store Fulfillment Orders
In ScopeTechnical: FUL_ORD | ID: OR-STO-FUL_ORD-FULFILLMENT_ORDER
Stores store fulfillment orders.
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
Field Definitions(5)
Rules & Considerations(42)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | STORE_IDR | CUST_ORDER_IDR | STATUS | COMMENTS | FLOW_TYPE | ORDER_TYPE | CREATE_DATE | CUSTOMER_ID | EXTERNAL_ID | UPDATE_DATE | RELEASE_DATE | UNDER_REVIEW | DELIVERY_DATE | DELIVERY_TYPE | HOLD_LOCATION | CUST_ORDER_DATE | SHIP_CARRIER_ID | SHIP_COST_VALUE | CUST_ARRIVE_DATE | INTEGRATION_TYPE | SHIP_COST_CURRENCY | DELIVERY_COMMENTS_1 | DELIVERY_COMMENTS_2 | DELIVERY_COMMENTS_3 | ALLOW_PARTIAL_DELIVERY | SHIP_CARRIER_SERVICE_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 1 | SAMPLE | 1 | 1 | 2026-01-01 | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | S | 2026-01-01 | 1 | SAMPLE | 2026-01-01 | 1 | 1.0000 | 2026-01-01 | 1 | SAM | SAMPLE | SAMPLE | SAMPLE | S | 1 |
| default | 3 | 1000000003 | ALT-FUL_ORD-002 | 2 | Ful Ord-002-ALT | 2 | 2 | 2026-01-03 | ALT-FUL_ORD-00 | ALT-FUL_ORD-002 | 2026-01-03 | 2026-01-03 | N | 2026-01-03 | 2 | Ful Ord-002-ALT | 2026-01-03 | 1000000003 | 12.5000 | 2026-01-03 | 3 | Ful | Ful Ord-002-ALT | Ful Ord-002-ALT | Ful Ord-002-ALT | F | 1000000003 |
| default | 5 | 1000000005 | EDGE-FUL_ORD-003 | 3 | Ful Ord-003-EDGE | 1 | 3 | 2026-01-05 | EDGE-FUL_ORD-0 | EDGE-FUL_ORD-003 | 2026-01-05 | 2026-01-05 | N | 2026-01-05 | 3 | Ful Ord-003-EDGE | 2026-01-05 | 1000000005 | 14.0000 | 2026-01-05 | 5 | Ful | Ful Ord-003-EDGE | Ful Ord-003-EDGE | Ful Ord-003-EDGE | F | 1000000005 |
Example values from field definitions
- IDRPK
- 1
- STORE_IDR
- 1
- CUST_ORDER_IDR
- SAMPLE
- STATUS
- 1
- COMMENTS
- SAMPLE
- FLOW_TYPE
- 1
- ORDER_TYPE
- 1
- CREATE_DATE
- 2026-01-01
- CUSTOMER_ID
- SAMPLE
- EXTERNAL_ID
- SAMPLE
- UPDATE_DATE
- 2026-01-01
- RELEASE_DATE
- 2026-01-01
- UNDER_REVIEW
- S
- DELIVERY_DATE
- 2026-01-01
- DELIVERY_TYPE
- 1
- HOLD_LOCATION
- SAMPLE
- CUST_ORDER_DATE
- 2026-01-01
- SHIP_CARRIER_ID
- 1
- SHIP_COST_VALUE
- 1.0000
- CUST_ARRIVE_DATE
- 2026-01-01
- INTEGRATION_TYPE
- 1
- SHIP_COST_CURRENCY
- SAM
- DELIVERY_COMMENTS_1
- SAMPLE
- DELIVERY_COMMENTS_2
- SAMPLE
- DELIVERY_COMMENTS_3
- SAMPLE
- ALLOW_PARTIAL_DELIVERY
- S
- SHIP_CARRIER_SERVICE_ID
- 1
default
- IDRPK
- 3
- STORE_IDR
- 1000000003
- CUST_ORDER_IDR
- ALT-FUL_ORD-002
- STATUS
- 2
- COMMENTS
- Ful Ord-002-ALT
- FLOW_TYPE
- 2
- ORDER_TYPE
- 2
- CREATE_DATE
- 2026-01-03
- CUSTOMER_ID
- ALT-FUL_ORD-00
- EXTERNAL_ID
- ALT-FUL_ORD-002
- UPDATE_DATE
- 2026-01-03
- RELEASE_DATE
- 2026-01-03
- UNDER_REVIEW
- N
- DELIVERY_DATE
- 2026-01-03
- DELIVERY_TYPE
- 2
- HOLD_LOCATION
- Ful Ord-002-ALT
- CUST_ORDER_DATE
- 2026-01-03
- SHIP_CARRIER_ID
- 1000000003
- SHIP_COST_VALUE
- 12.5000
- CUST_ARRIVE_DATE
- 2026-01-03
- INTEGRATION_TYPE
- 3
- SHIP_COST_CURRENCY
- Ful
- DELIVERY_COMMENTS_1
- Ful Ord-002-ALT
- DELIVERY_COMMENTS_2
- Ful Ord-002-ALT
- DELIVERY_COMMENTS_3
- Ful Ord-002-ALT
- ALLOW_PARTIAL_DELIVERY
- F
- SHIP_CARRIER_SERVICE_ID
- 1000000003
default
- IDRPK
- 5
- STORE_IDR
- 1000000005
- CUST_ORDER_IDR
- EDGE-FUL_ORD-003
- STATUS
- 3
- COMMENTS
- Ful Ord-003-EDGE
- FLOW_TYPE
- 1
- ORDER_TYPE
- 3
- CREATE_DATE
- 2026-01-05
- CUSTOMER_ID
- EDGE-FUL_ORD-0
- EXTERNAL_ID
- EDGE-FUL_ORD-003
- UPDATE_DATE
- 2026-01-05
- RELEASE_DATE
- 2026-01-05
- UNDER_REVIEW
- N
- DELIVERY_DATE
- 2026-01-05
- DELIVERY_TYPE
- 3
- HOLD_LOCATION
- Ful Ord-003-EDGE
- CUST_ORDER_DATE
- 2026-01-05
- SHIP_CARRIER_ID
- 1000000005
- SHIP_COST_VALUE
- 14.0000
- CUST_ARRIVE_DATE
- 2026-01-05
- INTEGRATION_TYPE
- 5
- SHIP_COST_CURRENCY
- Ful
- DELIVERY_COMMENTS_1
- Ful Ord-003-EDGE
- DELIVERY_COMMENTS_2
- Ful Ord-003-EDGE
- DELIVERY_COMMENTS_3
- Ful Ord-003-EDGE
- ALLOW_PARTIAL_DELIVERY
- F
- SHIP_CARRIER_SERVICE_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 64
- Governed Rule Count
- 42