Warehouse Department Expl
In ScopeTechnical: WH_DEPT_EXPL | ID: OR-FND-WH_DEPT_EXPL-WAREHOUSE_DEPARTMENT_EXPL
Stores investment buy information exploded to the wh/dept level for all investment buy eligible wh locations in the system. It takes the system_options and wh level wh_dept records and fills...
See how this object fits into Foundation Data
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
- WH_DEPT_EXPL
Field Definitions(5)
Rules & Considerations(24)
Sample Load Data(4)
| _scenario | WHR | DEPTR | PHYSICAL_WHR | BUYER | COST_MONEY | RECORD_SRC | TARGET_ROI | REPL_WH_LINK | STORAGE_TYPE | COST_WH_STORAGE | COST_OUT_STORAGE | MAX_WEEKS_SUPPLY | STORAGE_CURRENCY | COST_WH_STORAGE_UOM | COST_OUT_STORAGE_UOM | COST_WH_STORAGE_MEAS | COST_OUT_STORAGE_MEAS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 1.0000 | SAMPLE | 1.0000 | 1 | SAMPLE | 1.0000 | 1.0000 | 1 | SAM | SAMP | SAMP | SAMPLE | SAMPLE |
| default | 9003 | 1003 | 9003 | 3 | 12.5000 | Wh Dept Ex | 12.5000 | 3 | Wh Dep | 12.5000 | 12.5000 | 3 | Wh | Wh D | Wh D | Wh Dep | Wh Dep |
| default | 9005 | 1005 | 9005 | 5 | 14.0000 | Wh Dept Ex | 14.0000 | 5 | Wh Dep | 14.0000 | 14.0000 | 5 | Wh | Wh D | Wh D | Wh Dep | Wh Dep |
Example values from field definitions
- WHR
- 1
- DEPTR
- 1
- PHYSICAL_WHR
- 1
- BUYER
- 1
- COST_MONEY
- 1.0000
- RECORD_SRC
- SAMPLE
- TARGET_ROI
- 1.0000
- REPL_WH_LINK
- 1
- STORAGE_TYPE
- SAMPLE
- COST_WH_STORAGE
- 1.0000
- COST_OUT_STORAGE
- 1.0000
- MAX_WEEKS_SUPPLY
- 1
- STORAGE_CURRENCY
- SAM
- COST_WH_STORAGE_UOM
- SAMP
- COST_OUT_STORAGE_UOM
- SAMP
- COST_WH_STORAGE_MEAS
- SAMPLE
- COST_OUT_STORAGE_MEAS
- SAMPLE
default
- WHR
- 9003
- DEPTR
- 1003
- PHYSICAL_WHR
- 9003
- BUYER
- 3
- COST_MONEY
- 12.5000
- RECORD_SRC
- Wh Dept Ex
- TARGET_ROI
- 12.5000
- REPL_WH_LINK
- 3
- STORAGE_TYPE
- Wh Dep
- COST_WH_STORAGE
- 12.5000
- COST_OUT_STORAGE
- 12.5000
- MAX_WEEKS_SUPPLY
- 3
- STORAGE_CURRENCY
- Wh
- COST_WH_STORAGE_UOM
- Wh D
- COST_OUT_STORAGE_UOM
- Wh D
- COST_WH_STORAGE_MEAS
- Wh Dep
- COST_OUT_STORAGE_MEAS
- Wh Dep
default
- WHR
- 9005
- DEPTR
- 1005
- PHYSICAL_WHR
- 9005
- BUYER
- 5
- COST_MONEY
- 14.0000
- RECORD_SRC
- Wh Dept Ex
- TARGET_ROI
- 14.0000
- REPL_WH_LINK
- 5
- STORAGE_TYPE
- Wh Dep
- COST_WH_STORAGE
- 14.0000
- COST_OUT_STORAGE
- 14.0000
- MAX_WEEKS_SUPPLY
- 5
- STORAGE_CURRENCY
- Wh
- COST_WH_STORAGE_UOM
- Wh D
- COST_OUT_STORAGE_UOM
- Wh D
- COST_WH_STORAGE_MEAS
- Wh Dep
- COST_OUT_STORAGE_MEAS
- Wh Dep
Rule Validation Summary
- Source Rule Count
- 34
- Governed Rule Count
- 24