SIM Expl
In ScopeTechnical: SIM_EXPL | ID: OR-FND-SIM_EXPL-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- SIM_EXPL
Field Definitions(23)
Rules & Considerations(35)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 1 | 1 | 1.0000 | 1 | SAMPLE | SAMPLE | 1 | SAM | SAM | 1 | 1.0000 | SAMPLE | 1 | 1 | 1.0000 | 1.0000 | SAMP | SAMP | SAMPLE | SAMPLE |
Example values from field definitions
- WHR
- 1
- DEPTR
- 1
- TERMSR
- SAMPLE
- DUEDAYSR
- 1
- SUPPLIERR
- 1
- TARGET_ROIR
- 1.0000
- PHYSICAL_WHR
- 1
- STORAGE_TYPER
- SAMPLE
- IB_ORDER_CTRLR
- SAMPLE
- MAX_WEEKS_SUPPLYR
- 1
- STORAGE_CURRENCYR
- SAM
- SUPPLIER_CURRENCYR
- SAM
- BUYER
- 1
- COST_MONEY
- 1.0000
- RECORD_SRC
- SAMPLE
- REPL_WH_LINK
- 1
- POOL_SUPPLIER
- 1
- COST_WH_STORAGE
- 1.0000
- COST_OUT_STORAGE
- 1.0000
- COST_WH_STORAGE_UOM
- SAMP
- COST_OUT_STORAGE_UOM
- SAMP
- COST_WH_STORAGE_MEAS
- SAMPLE
- COST_OUT_STORAGE_MEAS
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 40
- Governed Rule Count
- 35