Ib Results
In ScopeTechnical: IB_RESULTS | ID: OR-FND-IB_RESULTS-IB_RESULTS
Stores the input parameters and resulting values of Investment Buy opportunity calculations.
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
- IB_RESULTS
Field Definitions(5)
Sample Load Data(4)
| _scenario | ITEMRPK | LOCATIONRPK | LOC_TYPER | CREATE_DATERPK | HI | TI | ROI | DEPT | BUYER | CLASS | TERMS | AUDSID | STATUS | DUEDAYS | RAW_ROQ | ORDER_NO | SUBCLASS | SUPPLIER | CASE_SIZE | COMP_ITEM | ITEM_TYPE | ORDER_ROQ | UNIT_COST | COST_MONEY | TARGET_ROI | FUTURE_COST | PHYSICAL_WH | SOURCE_TYPE | TARGET_DATE | CURRENT_COST | REPL_WH_LINK | DAYS_TO_EVENT | IB_ORDER_CTRL | POOL_SUPPLIER | SUPP_LEAD_TIME | SUPP_UNIT_COST | COST_WH_STORAGE | NEXT_EVENT_DATE | COST_OUT_STORAGE | LAST_ROUNDED_QTY | MAX_WEEKS_SUPPLY | PICKUP_LEAD_TIME | ORIGIN_COUNTRY_ID | COST_WH_STORAGE_UOM | COST_OUT_STORAGE_UOM | COST_WH_STORAGE_MEAS | LAST_GRP_ROUNDED_QTY | COST_OUT_STORAGE_MEAS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | S | 2026-01-01 | 1.0000 | 1.0000 | 1.0000 | 1 | 1 | 1 | SAMPLE | 1 | SAMPLE | 1 | 1.0000 | 1 | 1 | 1 | 1.0000 | SAMPLE | S | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1 | SAMPLE | 2026-01-01 | 1.0000 | 1 | 1 | SAMPLE | 1 | 1 | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 | 1.0000 | 1 | 1 | SAM | SAMP | SAMP | SAMPLE | 1.0000 | SAMPLE |
| default | Ib Results-002-ALT | 3 | I | 2026-01-03 | 12.5000 | 12.5000 | 12.5000 | 1003 | 3 | 1103 | Ib Results-002- | 3 | PENDIN | 3 | 12.5000 | 4 | 1113 | 3 | 12.5000 | Ib Results-002-ALT | I | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 9003 | Ib Res | 2026-01-03 | 12.5000 | 3 | 3 | Ib Res | 3 | 3 | 12.5000 | 12.5000 | 2026-01-03 | 12.5000 | 12.5000 | 3 | 3 | ALT | Ib R | Ib R | Ib Res | 12.5000 | Ib Res |
| default | Ib Results-003-EDGE | 5 | I | 2026-01-05 | 14.0000 | 14.0000 | 14.0000 | 1005 | 5 | 1105 | Ib Results-003- | 5 | ACTIVE | 5 | 14.0000 | 6 | 1115 | 5 | 14.0000 | Ib Results-003-EDGE | I | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 9005 | Ib Res | 2026-01-05 | 14.0000 | 5 | 5 | Ib Res | 5 | 5 | 14.0000 | 14.0000 | 2026-01-05 | 14.0000 | 14.0000 | 5 | 5 | EDG | Ib R | Ib R | Ib Res | 14.0000 | Ib Res |
Example values from field definitions
- ITEMRPK
- SAMPLE
- LOCATIONRPK
- 1
- LOC_TYPER
- S
- CREATE_DATERPK
- 2026-01-01
- HI
- 1.0000
- TI
- 1.0000
- ROI
- 1.0000
- DEPT
- 1
- BUYER
- 1
- CLASS
- 1
- TERMS
- SAMPLE
- AUDSID
- 1
- STATUS
- SAMPLE
- DUEDAYS
- 1
- RAW_ROQ
- 1.0000
- ORDER_NO
- 1
- SUBCLASS
- 1
- SUPPLIER
- 1
- CASE_SIZE
- 1.0000
- COMP_ITEM
- SAMPLE
- ITEM_TYPE
- S
- ORDER_ROQ
- 1.0000
- UNIT_COST
- 1.0000
- COST_MONEY
- 1.0000
- TARGET_ROI
- 1.0000
- FUTURE_COST
- 1.0000
- PHYSICAL_WH
- 1
- SOURCE_TYPE
- SAMPLE
- TARGET_DATE
- 2026-01-01
- CURRENT_COST
- 1.0000
- REPL_WH_LINK
- 1
- DAYS_TO_EVENT
- 1
- IB_ORDER_CTRL
- SAMPLE
- POOL_SUPPLIER
- 1
- SUPP_LEAD_TIME
- 1
- SUPP_UNIT_COST
- 1.0000
- COST_WH_STORAGE
- 1.0000
- NEXT_EVENT_DATE
- 2026-01-01
- COST_OUT_STORAGE
- 1.0000
- LAST_ROUNDED_QTY
- 1.0000
- MAX_WEEKS_SUPPLY
- 1
- PICKUP_LEAD_TIME
- 1
- ORIGIN_COUNTRY_ID
- SAM
- COST_WH_STORAGE_UOM
- SAMP
- COST_OUT_STORAGE_UOM
- SAMP
- COST_WH_STORAGE_MEAS
- SAMPLE
- LAST_GRP_ROUNDED_QTY
- 1.0000
- COST_OUT_STORAGE_MEAS
- SAMPLE
default
- ITEMRPK
- Ib Results-002-ALT
- LOCATIONRPK
- 3
- LOC_TYPER
- I
- CREATE_DATERPK
- 2026-01-03
- HI
- 12.5000
- TI
- 12.5000
- ROI
- 12.5000
- DEPT
- 1003
- BUYER
- 3
- CLASS
- 1103
- TERMS
- Ib Results-002-
- AUDSID
- 3
- STATUS
- PENDIN
- DUEDAYS
- 3
- RAW_ROQ
- 12.5000
- ORDER_NO
- 4
- SUBCLASS
- 1113
- SUPPLIER
- 3
- CASE_SIZE
- 12.5000
- COMP_ITEM
- Ib Results-002-ALT
- ITEM_TYPE
- I
- ORDER_ROQ
- 12.5000
- UNIT_COST
- 12.5000
- COST_MONEY
- 12.5000
- TARGET_ROI
- 12.5000
- FUTURE_COST
- 12.5000
- PHYSICAL_WH
- 9003
- SOURCE_TYPE
- Ib Res
- TARGET_DATE
- 2026-01-03
- CURRENT_COST
- 12.5000
- REPL_WH_LINK
- 3
- DAYS_TO_EVENT
- 3
- IB_ORDER_CTRL
- Ib Res
- POOL_SUPPLIER
- 3
- SUPP_LEAD_TIME
- 3
- SUPP_UNIT_COST
- 12.5000
- COST_WH_STORAGE
- 12.5000
- NEXT_EVENT_DATE
- 2026-01-03
- COST_OUT_STORAGE
- 12.5000
- LAST_ROUNDED_QTY
- 12.5000
- MAX_WEEKS_SUPPLY
- 3
- PICKUP_LEAD_TIME
- 3
- ORIGIN_COUNTRY_ID
- ALT
- COST_WH_STORAGE_UOM
- Ib R
- COST_OUT_STORAGE_UOM
- Ib R
- COST_WH_STORAGE_MEAS
- Ib Res
- LAST_GRP_ROUNDED_QTY
- 12.5000
- COST_OUT_STORAGE_MEAS
- Ib Res
default
- ITEMRPK
- Ib Results-003-EDGE
- LOCATIONRPK
- 5
- LOC_TYPER
- I
- CREATE_DATERPK
- 2026-01-05
- HI
- 14.0000
- TI
- 14.0000
- ROI
- 14.0000
- DEPT
- 1005
- BUYER
- 5
- CLASS
- 1105
- TERMS
- Ib Results-003-
- AUDSID
- 5
- STATUS
- ACTIVE
- DUEDAYS
- 5
- RAW_ROQ
- 14.0000
- ORDER_NO
- 6
- SUBCLASS
- 1115
- SUPPLIER
- 5
- CASE_SIZE
- 14.0000
- COMP_ITEM
- Ib Results-003-EDGE
- ITEM_TYPE
- I
- ORDER_ROQ
- 14.0000
- UNIT_COST
- 14.0000
- COST_MONEY
- 14.0000
- TARGET_ROI
- 14.0000
- FUTURE_COST
- 14.0000
- PHYSICAL_WH
- 9005
- SOURCE_TYPE
- Ib Res
- TARGET_DATE
- 2026-01-05
- CURRENT_COST
- 14.0000
- REPL_WH_LINK
- 5
- DAYS_TO_EVENT
- 5
- IB_ORDER_CTRL
- Ib Res
- POOL_SUPPLIER
- 5
- SUPP_LEAD_TIME
- 5
- SUPP_UNIT_COST
- 14.0000
- COST_WH_STORAGE
- 14.0000
- NEXT_EVENT_DATE
- 2026-01-05
- COST_OUT_STORAGE
- 14.0000
- LAST_ROUNDED_QTY
- 14.0000
- MAX_WEEKS_SUPPLY
- 5
- PICKUP_LEAD_TIME
- 5
- ORIGIN_COUNTRY_ID
- EDG
- COST_WH_STORAGE_UOM
- Ib R
- COST_OUT_STORAGE_UOM
- Ib R
- COST_WH_STORAGE_MEAS
- Ib Res
- LAST_GRP_ROUNDED_QTY
- 14.0000
- COST_OUT_STORAGE_MEAS
- Ib Res
Rule Validation Summary
- Source Rule Count
- 84
- Governed Rule Count
- 78