Store Order
In ScopeTechnical: STORE_ORDER | ID: OR-SIOCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- STORE_ORDER
Field Definitions(29)
Rules & Considerations(78)
Sample Load Data(4)
| _scenario | IDRPK | ORIGINR | STATUSR | STORE_IDRPK | ADD_ITEMSR | CREATE_DATER | CREATE_USERR | UPDATE_DATER | UPDATE_USERR | ROUND_QUANTITYR | DELIVERY_SLOT_IDPK | PRODUCT_GROUP_IDPK | STORE_ORDER_ONLYR | CONTEXT_ID | DESCRIPTION | APPROVE_DATE | APPROVE_USER | EXTERNAL_PO_ID | REQUESTED_DATE | PARENT_REFERENCE | RESTRICT_AREA_ID | AUTO_APPROVE_DATE | EXTERNAL_REFERENCE | CREATE_DATE_EXTERNAL | EXTERNAL_TRANSFER_ID | RESTRICT_SUPPLIER_ID | RESTRICT_ITEM_HIER_ID | RESTRICT_WAREHOUSE_ID | PRODUCT_GROUP_DESCRIPTION |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 01 | 01 | 1000000001 | Store Order-001 | 2026-01-01 | Store Order-001 | 2026-01-01 | 2026-01-01 | N | 1000000001 | 1000000001 | Y | 1000000001 | Store Order-001 | 2026-01-01 | Store Order-001 | STD-STORE_ORDE-001 | 2026-01-01 | 1 | 1000000001 | 2026-01-01 | Store Order-001 | 2026-01-01 | STD-STORE_ORDE-001 | 1000000001 | 1000000001 | 1000000001 | Store Order: Baseline migration row |
default
- IDRPK
- 1
- ORIGINR
- 01
- STATUSR
- 01
- STORE_IDRPK
- 1000000001
- ADD_ITEMSR
- Store Order-001
- CREATE_DATER
- 2026-01-01
- CREATE_USERR
- Store Order-001
- UPDATE_DATER
- 2026-01-01
- UPDATE_USERR
- 2026-01-01
- ROUND_QUANTITYR
- N
- DELIVERY_SLOT_IDPK
- 1000000001
- PRODUCT_GROUP_IDPK
- 1000000001
- STORE_ORDER_ONLYR
- Y
- CONTEXT_ID
- 1000000001
- DESCRIPTION
- Store Order-001
- APPROVE_DATE
- 2026-01-01
- APPROVE_USER
- Store Order-001
- EXTERNAL_PO_ID
- STD-STORE_ORDE-001
- REQUESTED_DATE
- 2026-01-01
- PARENT_REFERENCE
- 1
- RESTRICT_AREA_ID
- 1000000001
- AUTO_APPROVE_DATE
- 2026-01-01
- EXTERNAL_REFERENCE
- Store Order-001
- CREATE_DATE_EXTERNAL
- 2026-01-01
- EXTERNAL_TRANSFER_ID
- STD-STORE_ORDE-001
- RESTRICT_SUPPLIER_ID
- 1000000001
- RESTRICT_ITEM_HIER_ID
- 1000000001
- RESTRICT_WAREHOUSE_ID
- 1000000001
- PRODUCT_GROUP_DESCRIPTION
- Store Order: Baseline migration row