Deliveries For Store Fulfillment Orders
In ScopeTechnical: FUL_ORD_DLV | ID: OR-STO-FUL_ORD_DLV-FULFILLMENT_ORDER_DELIVERY
Stores deliveries for 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_DLV
Field Definitions(5)
Rules & Considerations(32)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | STATUSR | FUL_ORD_IDR | CREATE_DATER | STORE_ID | FLOW_TYPE | CREATE_USER | EXTERNAL_ID | SUBMIT_DATE | SUBMIT_USER | UPDATE_DATE | UPDATE_USER | DISPATCH_DATE | DISPATCH_USER | SHIPMENT_BOL_ID | FISCAL_DOC_NUMBER | FISCAL_DOC_REF_ID | FISCAL_DOC_STATUS | FISCAL_DOC_PRINT_URL | FISCAL_DOC_REQUEST_ID | FISCAL_DOC_REJECT_REASON |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 2026-01-01 | 1 | 1 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 1 | SAMPLE | 1 | 1 | SAMPLE | 1 | SAMPLE |
| default | 3 | 2 | 1000000003 | 2026-01-03 | 1000000003 | 2 | Ful Ord Dlv-002-ALT | ALT-FUL_ORD-002 | 2026-01-03 | Ful Ord Dlv-002-ALT | 2026-01-03 | 2026-01-02-ALT | 2026-01-03 | Ful Ord Dlv-002-ALT | 1000000003 | Ful Ord Dlv-002-ALT | 1000000003 | 2 | Ful Ord Dlv-002-ALT | 1000000003 | Ful Ord Dlv-002-ALT |
| default | 5 | 3 | 1000000005 | 2026-01-05 | 1000000005 | 1 | Ful Ord Dlv-003-EDGE | EDGE-FUL_ORD-003 | 2026-01-05 | Ful Ord Dlv-003-EDGE | 2026-01-05 | 2026-01-03-EDGE | 2026-01-05 | Ful Ord Dlv-003-EDGE | 1000000005 | Ful Ord Dlv-003-EDGE | 1000000005 | 3 | Ful Ord Dlv-003-EDGE | 1000000005 | Ful Ord Dlv-003-EDGE |
Example values from field definitions
- IDRPK
- 1
- STATUSR
- 1
- FUL_ORD_IDR
- 1
- CREATE_DATER
- 2026-01-01
- STORE_ID
- 1
- FLOW_TYPE
- 1
- CREATE_USER
- SAMPLE
- EXTERNAL_ID
- SAMPLE
- SUBMIT_DATE
- 2026-01-01
- SUBMIT_USER
- SAMPLE
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- DISPATCH_DATE
- 2026-01-01
- DISPATCH_USER
- SAMPLE
- SHIPMENT_BOL_ID
- 1
- FISCAL_DOC_NUMBER
- SAMPLE
- FISCAL_DOC_REF_ID
- 1
- FISCAL_DOC_STATUS
- 1
- FISCAL_DOC_PRINT_URL
- SAMPLE
- FISCAL_DOC_REQUEST_ID
- 1
- FISCAL_DOC_REJECT_REASON
- SAMPLE
default
- IDRPK
- 3
- STATUSR
- 2
- FUL_ORD_IDR
- 1000000003
- CREATE_DATER
- 2026-01-03
- STORE_ID
- 1000000003
- FLOW_TYPE
- 2
- CREATE_USER
- Ful Ord Dlv-002-ALT
- EXTERNAL_ID
- ALT-FUL_ORD-002
- SUBMIT_DATE
- 2026-01-03
- SUBMIT_USER
- Ful Ord Dlv-002-ALT
- UPDATE_DATE
- 2026-01-03
- UPDATE_USER
- 2026-01-02-ALT
- DISPATCH_DATE
- 2026-01-03
- DISPATCH_USER
- Ful Ord Dlv-002-ALT
- SHIPMENT_BOL_ID
- 1000000003
- FISCAL_DOC_NUMBER
- Ful Ord Dlv-002-ALT
- FISCAL_DOC_REF_ID
- 1000000003
- FISCAL_DOC_STATUS
- 2
- FISCAL_DOC_PRINT_URL
- Ful Ord Dlv-002-ALT
- FISCAL_DOC_REQUEST_ID
- 1000000003
- FISCAL_DOC_REJECT_REASON
- Ful Ord Dlv-002-ALT
default
- IDRPK
- 5
- STATUSR
- 3
- FUL_ORD_IDR
- 1000000005
- CREATE_DATER
- 2026-01-05
- STORE_ID
- 1000000005
- FLOW_TYPE
- 1
- CREATE_USER
- Ful Ord Dlv-003-EDGE
- EXTERNAL_ID
- EDGE-FUL_ORD-003
- SUBMIT_DATE
- 2026-01-05
- SUBMIT_USER
- Ful Ord Dlv-003-EDGE
- UPDATE_DATE
- 2026-01-05
- UPDATE_USER
- 2026-01-03-EDGE
- DISPATCH_DATE
- 2026-01-05
- DISPATCH_USER
- Ful Ord Dlv-003-EDGE
- SHIPMENT_BOL_ID
- 1000000005
- FISCAL_DOC_NUMBER
- Ful Ord Dlv-003-EDGE
- FISCAL_DOC_REF_ID
- 1000000005
- FISCAL_DOC_STATUS
- 3
- FISCAL_DOC_PRINT_URL
- Ful Ord Dlv-003-EDGE
- FISCAL_DOC_REQUEST_ID
- 1000000005
- FISCAL_DOC_REJECT_REASON
- Ful Ord Dlv-003-EDGE
Rule Validation Summary
- Source Rule Count
- 47
- Governed Rule Count
- 32