Wh Dept Expl
In ScopeTechnical: WH_DEPT_EXPL | ID: OR-MFCS-WH_DEPT_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
Target Structure
- Load Approach
- Table
- Target Objects
- WH_DEPT_EXPL
Field Definitions(17)
Rules & Considerations(10)
Sample Load Data(4)
| _scenario | WHR | DEPTR | TARGET_ROIR | PHYSICAL_WHR | STORAGE_TYPER | MAX_WEEKS_SUPPLYR | STORAGE_CURRENCYR | BUYER | COST_MONEY | RECORD_SRC | REPL_WH_LINK | COST_WH_STORAGE | COST_OUT_STORAGE | COST_WH_STORAGE_UOM | COST_OUT_STORAGE_UOM | COST_WH_STORAGE_MEAS | COST_OUT_STORAGE_MEAS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 9001 | 1001 | 11.0000 | 9001 | Wh Dept Expl-001 | 001 | Wh Dept Expl-001 | 0001 | 11.0000 | Wh Dept Expl-001 | 1 | 11.0000 | 11.0000 | Wh Dept Expl-001 | Wh Dept Expl-001 | Wh Dept Expl-001 | Wh Dept Expl-001 |
default
- WHR
- 9001
- DEPTR
- 1001
- TARGET_ROIR
- 11.0000
- PHYSICAL_WHR
- 9001
- STORAGE_TYPER
- Wh Dept Expl-001
- MAX_WEEKS_SUPPLYR
- 001
- STORAGE_CURRENCYR
- Wh Dept Expl-001
- BUYER
- 0001
- COST_MONEY
- 11.0000
- RECORD_SRC
- Wh Dept Expl-001
- REPL_WH_LINK
- 1
- COST_WH_STORAGE
- 11.0000
- COST_OUT_STORAGE
- 11.0000
- COST_WH_STORAGE_UOM
- Wh Dept Expl-001
- COST_OUT_STORAGE_UOM
- Wh Dept Expl-001
- COST_WH_STORAGE_MEAS
- Wh Dept Expl-001
- COST_OUT_STORAGE_MEAS
- Wh Dept Expl-001