SIM Expl
In ScopeTechnical: SIM_EXPL | ID: OR-MFCS-SIM_EXPL
Sup_inv_mgmt hold investment buy information for sup/dept/loc combinations that are investment buy eligible. It combines sup_inv_mgmt records exploded down to the sup/dept/loc level for all wh/dept combinations on wh_dept_sim.
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
- SIM_EXPL
Field Definitions(23)
Rules & Considerations(15)
Sample Load Data(4)
| _scenario | WHR | DEPTR | TERMSR | DUEDAYSR | SUPPLIERR | TARGET_ROIR | PHYSICAL_WHR | STORAGE_TYPER | IB_ORDER_CTRLR | MAX_WEEKS_SUPPLYR | STORAGE_CURRENCYR | SUPPLIER_CURRENCYR | BUYER | COST_MONEY | RECORD_SRC | REPL_WH_LINK | POOL_SUPPLIER | 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 | SIM Expl-001 | 001 | 1 | 11.0000 | 9001 | SIM Expl-001 | SIM Expl-001 | 001 | SIM Expl-001 | SIM Expl-001 | 0001 | 11.0000 | SIM Expl-001 | 1 | 1 | 11.0000 | 11.0000 | SIM Expl-001 | SIM Expl-001 | SIM Expl-001 | SIM Expl-001 |
default
- WHR
- 9001
- DEPTR
- 1001
- TERMSR
- SIM Expl-001
- DUEDAYSR
- 001
- SUPPLIERR
- 1
- TARGET_ROIR
- 11.0000
- PHYSICAL_WHR
- 9001
- STORAGE_TYPER
- SIM Expl-001
- IB_ORDER_CTRLR
- SIM Expl-001
- MAX_WEEKS_SUPPLYR
- 001
- STORAGE_CURRENCYR
- SIM Expl-001
- SUPPLIER_CURRENCYR
- SIM Expl-001
- BUYER
- 0001
- COST_MONEY
- 11.0000
- RECORD_SRC
- SIM Expl-001
- REPL_WH_LINK
- 1
- POOL_SUPPLIER
- 1
- COST_WH_STORAGE
- 11.0000
- COST_OUT_STORAGE
- 11.0000
- COST_WH_STORAGE_UOM
- SIM Expl-001
- COST_OUT_STORAGE_UOM
- SIM Expl-001
- COST_WH_STORAGE_MEAS
- SIM Expl-001
- COST_OUT_STORAGE_MEAS
- SIM Expl-001