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(5)
Rules & Considerations(35)
Sample Load Data(4)
| _scenario | TERMSR | DUEDAYSR | SUPPLIERR | IB_ORDER_CTRLR | WH | DEPT | BUYER | COST_MONEY | RECORD_SRC | TARGET_ROI | PHYSICAL_WH | REPL_WH_LINK | STORAGE_TYPE | POOL_SUPPLIER | COST_WH_STORAGE | COST_OUT_STORAGE | MAX_WEEKS_SUPPLY | STORAGE_CURRENCY | SUPPLIER_CURRENCY | COST_WH_STORAGE_UOM | COST_OUT_STORAGE_UOM | COST_WH_STORAGE_MEAS | COST_OUT_STORAGE_MEAS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | SAMPLE | 1 | 1 | 1 | 1.0000 | SAMPLE | 1.0000 | 1 | 1 | SAMPLE | 1 | 1.0000 | 1.0000 | 1 | SAM | SAM | SAMP | SAMP | SAMPLE | SAMPLE |
| default | SIM Expl-002-AL | 3 | 3 | SIM Ex | 9003 | 1003 | 3 | 12.5000 | SIM Expl-0 | 12.5000 | 9003 | 3 | SIM Ex | 3 | 12.5000 | 12.5000 | 3 | SIM | SIM | SIM | SIM | SIM Ex | SIM Ex |
| default | SIM Expl-003-ED | 5 | 5 | SIM Ex | 9005 | 1005 | 5 | 14.0000 | SIM Expl-0 | 14.0000 | 9005 | 5 | SIM Ex | 5 | 14.0000 | 14.0000 | 5 | SIM | SIM | SIM | SIM | SIM Ex | SIM Ex |
Example values from field definitions
- TERMSR
- SAMPLE
- DUEDAYSR
- 1
- SUPPLIERR
- 1
- IB_ORDER_CTRLR
- SAMPLE
- WH
- 1
- DEPT
- 1
- BUYER
- 1
- COST_MONEY
- 1.0000
- RECORD_SRC
- SAMPLE
- TARGET_ROI
- 1.0000
- PHYSICAL_WH
- 1
- REPL_WH_LINK
- 1
- STORAGE_TYPE
- SAMPLE
- POOL_SUPPLIER
- 1
- COST_WH_STORAGE
- 1.0000
- COST_OUT_STORAGE
- 1.0000
- MAX_WEEKS_SUPPLY
- 1
- STORAGE_CURRENCY
- SAM
- SUPPLIER_CURRENCY
- SAM
- COST_WH_STORAGE_UOM
- SAMP
- COST_OUT_STORAGE_UOM
- SAMP
- COST_WH_STORAGE_MEAS
- SAMPLE
- COST_OUT_STORAGE_MEAS
- SAMPLE
default
- TERMSR
- SIM Expl-002-AL
- DUEDAYSR
- 3
- SUPPLIERR
- 3
- IB_ORDER_CTRLR
- SIM Ex
- WH
- 9003
- DEPT
- 1003
- BUYER
- 3
- COST_MONEY
- 12.5000
- RECORD_SRC
- SIM Expl-0
- TARGET_ROI
- 12.5000
- PHYSICAL_WH
- 9003
- REPL_WH_LINK
- 3
- STORAGE_TYPE
- SIM Ex
- POOL_SUPPLIER
- 3
- COST_WH_STORAGE
- 12.5000
- COST_OUT_STORAGE
- 12.5000
- MAX_WEEKS_SUPPLY
- 3
- STORAGE_CURRENCY
- SIM
- SUPPLIER_CURRENCY
- SIM
- COST_WH_STORAGE_UOM
- SIM
- COST_OUT_STORAGE_UOM
- SIM
- COST_WH_STORAGE_MEAS
- SIM Ex
- COST_OUT_STORAGE_MEAS
- SIM Ex
default
- TERMSR
- SIM Expl-003-ED
- DUEDAYSR
- 5
- SUPPLIERR
- 5
- IB_ORDER_CTRLR
- SIM Ex
- WH
- 9005
- DEPT
- 1005
- BUYER
- 5
- COST_MONEY
- 14.0000
- RECORD_SRC
- SIM Expl-0
- TARGET_ROI
- 14.0000
- PHYSICAL_WH
- 9005
- REPL_WH_LINK
- 5
- STORAGE_TYPE
- SIM Ex
- POOL_SUPPLIER
- 5
- COST_WH_STORAGE
- 14.0000
- COST_OUT_STORAGE
- 14.0000
- MAX_WEEKS_SUPPLY
- 5
- STORAGE_CURRENCY
- SIM
- SUPPLIER_CURRENCY
- SIM
- COST_WH_STORAGE_UOM
- SIM
- COST_OUT_STORAGE_UOM
- SIM
- COST_WH_STORAGE_MEAS
- SIM Ex
- COST_OUT_STORAGE_MEAS
- SIM Ex
Rule Validation Summary
- Source Rule Count
- 40
- Governed Rule Count
- 35