Store Warehouse Network
In ScopeTechnical: STORE_WAREHOUSE_NETWORK | ID: OR-STO-STORE_WAREHOUSE_NETWORK-STORE_WAREHOUSE_NETWORK
This table defines the warehouses that are excluded for return to warehouses and receive from warehouses.
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_WAREHOUSE_NETWORK
Field Definitions(5)
Rules & Considerations(14)
validation
constraint
Sample Load Data(4)
| _scenario | STORE_IDRPK | CREATE_USERR | WAREHOUSE_IDRPK | CREATE_DATE | UPDATE_DATE | UPDATE_USER | RETURN_EXCLUDED | RECEIVE_EXCLUDED |
|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 2026-01-01 | 2026-01-01 | SAMPLE | S | S |
| default | 1000000003 | Store Warehouse Network-002-ALT | 1000000003 | 2026-01-03 | 2026-01-03 | 2026-01-02-ALT | S | S |
| default | 1000000005 | Store Warehouse Network-003-EDGE | 1000000005 | 2026-01-05 | 2026-01-05 | 2026-01-03-EDGE | S | S |
Example values from field definitions
- STORE_IDRPK
- 1
- CREATE_USERR
- SAMPLE
- WAREHOUSE_IDRPK
- 1
- CREATE_DATE
- 2026-01-01
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- RETURN_EXCLUDED
- S
- RECEIVE_EXCLUDED
- S
default
- STORE_IDRPK
- 1000000003
- CREATE_USERR
- Store Warehouse Network-002-ALT
- WAREHOUSE_IDRPK
- 1000000003
- CREATE_DATE
- 2026-01-03
- UPDATE_DATE
- 2026-01-03
- UPDATE_USER
- 2026-01-02-ALT
- RETURN_EXCLUDED
- S
- RECEIVE_EXCLUDED
- S
default
- STORE_IDRPK
- 1000000005
- CREATE_USERR
- Store Warehouse Network-003-EDGE
- WAREHOUSE_IDRPK
- 1000000005
- CREATE_DATE
- 2026-01-05
- UPDATE_DATE
- 2026-01-05
- UPDATE_USER
- 2026-01-03-EDGE
- RETURN_EXCLUDED
- S
- RECEIVE_EXCLUDED
- S
Rule Validation Summary
- Source Rule Count
- 17
- Governed Rule Count
- 14