Store Order Header Information
In ScopeTechnical: STORE_ORDER | ID: OR-STO-STORE_ORDER-STORE_ORDER
Stores store order header 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
Field Definitions(5)
Rules & Considerations(43)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | STORE_IDR | ORIGIN | STATUS | ADD_ITEMS | CONTEXT_ID | CREATE_DATE | CREATE_USER | DESCRIPTION | UPDATE_DATE | UPDATE_USER | APPROVE_DATE | APPROVE_USER | EXTERNAL_PO_ID | REQUESTED_DATE | ROUND_QUANTITY | DELIVERY_SLOT_ID | PARENT_REFERENCE | PRODUCT_GROUP_ID | RESTRICT_AREA_ID | STORE_ORDER_ONLY | AUTO_APPROVE_DATE | EXTERNAL_REFERENCE | CREATE_DATE_EXTERNAL | EXTERNAL_TRANSFER_ID | RESTRICT_SUPPLIER_ID | RESTRICT_ITEM_HIER_ID | RESTRICT_WAREHOUSE_ID | PRODUCT_GROUP_DESCRIPTION |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | S | 1 | 2026-01-01 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | 2026-01-01 | S | 1 | 1 | 1 | 1 | S | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 1 | 1 | 1 | SAMPLE |
| default | 3 | 1000000003 | 3 | 3 | S | 1000000003 | 2026-01-03 | Store Order-002-ALT | Store Order-002-ALT | 2026-01-03 | 2026-01-02-ALT | 2026-01-03 | Store Order-002-ALT | ALT-STORE_ORDE-002 | 2026-01-03 | N | 1000000003 | 3 | 1000000003 | 1000000003 | Y | 2026-01-03 | Store Order-002-ALT | 2026-01-03 | ALT-STORE_ORDE-002 | 1000000003 | 1000000003 | 1000000003 | Store Order: Alternate source profile |
| default | 5 | 1000000005 | 5 | 5 | S | 1000000005 | 2026-01-05 | Store Order-003-EDGE | — | 2026-01-05 | 2026-01-03-EDGE | 2026-01-05 | Store Order-003-EDGE | EDGE-STORE_ORDE-003 | 2026-01-05 | N | 1000000005 | — | 1000000005 | 1000000005 | Y | 2026-01-05 | — | 2026-01-05 | EDGE-STORE_ORDE-003 | 1000000005 | 1000000005 | 1000000005 | — |
Example values from field definitions
- IDRPK
- 1
- STORE_IDR
- 1
- ORIGIN
- 1
- STATUS
- 1
- ADD_ITEMS
- S
- CONTEXT_ID
- 1
- CREATE_DATE
- 2026-01-01
- CREATE_USER
- SAMPLE
- DESCRIPTION
- SAMPLE
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- APPROVE_DATE
- 2026-01-01
- APPROVE_USER
- SAMPLE
- EXTERNAL_PO_ID
- SAMPLE
- REQUESTED_DATE
- 2026-01-01
- ROUND_QUANTITY
- S
- DELIVERY_SLOT_ID
- 1
- PARENT_REFERENCE
- 1
- PRODUCT_GROUP_ID
- 1
- RESTRICT_AREA_ID
- 1
- STORE_ORDER_ONLY
- S
- AUTO_APPROVE_DATE
- 2026-01-01
- EXTERNAL_REFERENCE
- SAMPLE
- CREATE_DATE_EXTERNAL
- 2026-01-01
- EXTERNAL_TRANSFER_ID
- SAMPLE
- RESTRICT_SUPPLIER_ID
- 1
- RESTRICT_ITEM_HIER_ID
- 1
- RESTRICT_WAREHOUSE_ID
- 1
- PRODUCT_GROUP_DESCRIPTION
- SAMPLE
default
- IDRPK
- 3
- STORE_IDR
- 1000000003
- ORIGIN
- 3
- STATUS
- 3
- ADD_ITEMS
- S
- CONTEXT_ID
- 1000000003
- CREATE_DATE
- 2026-01-03
- CREATE_USER
- Store Order-002-ALT
- DESCRIPTION
- Store Order-002-ALT
- UPDATE_DATE
- 2026-01-03
- UPDATE_USER
- 2026-01-02-ALT
- APPROVE_DATE
- 2026-01-03
- APPROVE_USER
- Store Order-002-ALT
- EXTERNAL_PO_ID
- ALT-STORE_ORDE-002
- REQUESTED_DATE
- 2026-01-03
- ROUND_QUANTITY
- N
- DELIVERY_SLOT_ID
- 1000000003
- PARENT_REFERENCE
- 3
- PRODUCT_GROUP_ID
- 1000000003
- RESTRICT_AREA_ID
- 1000000003
- STORE_ORDER_ONLY
- Y
- AUTO_APPROVE_DATE
- 2026-01-03
- EXTERNAL_REFERENCE
- Store Order-002-ALT
- CREATE_DATE_EXTERNAL
- 2026-01-03
- EXTERNAL_TRANSFER_ID
- ALT-STORE_ORDE-002
- RESTRICT_SUPPLIER_ID
- 1000000003
- RESTRICT_ITEM_HIER_ID
- 1000000003
- RESTRICT_WAREHOUSE_ID
- 1000000003
- PRODUCT_GROUP_DESCRIPTION
- Store Order: Alternate source profile
default
- IDRPK
- 5
- STORE_IDR
- 1000000005
- ORIGIN
- 5
- STATUS
- 5
- ADD_ITEMS
- S
- CONTEXT_ID
- 1000000005
- CREATE_DATE
- 2026-01-05
- CREATE_USER
- Store Order-003-EDGE
- DESCRIPTION
- —
- UPDATE_DATE
- 2026-01-05
- UPDATE_USER
- 2026-01-03-EDGE
- APPROVE_DATE
- 2026-01-05
- APPROVE_USER
- Store Order-003-EDGE
- EXTERNAL_PO_ID
- EDGE-STORE_ORDE-003
- REQUESTED_DATE
- 2026-01-05
- ROUND_QUANTITY
- N
- DELIVERY_SLOT_ID
- 1000000005
- PARENT_REFERENCE
- —
- PRODUCT_GROUP_ID
- 1000000005
- RESTRICT_AREA_ID
- 1000000005
- STORE_ORDER_ONLY
- Y
- AUTO_APPROVE_DATE
- 2026-01-05
- EXTERNAL_REFERENCE
- —
- CREATE_DATE_EXTERNAL
- 2026-01-05
- EXTERNAL_TRANSFER_ID
- EDGE-STORE_ORDE-003
- RESTRICT_SUPPLIER_ID
- 1000000005
- RESTRICT_ITEM_HIER_ID
- 1000000005
- RESTRICT_WAREHOUSE_ID
- 1000000005
- PRODUCT_GROUP_DESCRIPTION
- —
Rule Validation Summary
- Source Rule Count
- 59
- Governed Rule Count
- 43