RPM Oi Inventory (GTT)
Out of ScopeTechnical: RPM_OI_INVENTORY_GTT | ID: OR-PRC-RPM_OI_INVENTORY_GTT-RPM_OI_INVENTORY_GTT
Helper table to hold the Contextual BI Inventory Report data for pricing.
See how this object fits into Pricing & Promotions
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- gtt
Target Structure
- Load Approach
- Table
- Target Objects
- RPM_OI_INVENTORY_GTT
Field Definitions(5)
Rules & Considerations(12)
validation
constraint
Sample Load Data(4)
| _scenario | LOCR | ITEMR | LOC_TYPER | ITEM_PARENT | SELLING_UOM | ON_ORDER_QTY | STOCK_ON_HAND | EFFECTIVE_DATE | IN_TRANSIT_QTY |
|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | SAMPLE | SAMP | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 |
| default | 3 | RPM Oi Inventory Gtt-002- | 2 | RPM Oi Inventory Gtt-002- | RPM | 12.5000 | 12.5000 | 2026-01-03 | 12.5000 |
| default | 5 | RPM Oi Inventory Gtt-003- | 0 | RPM Oi Inventory Gtt-003- | RPM | 14.0000 | 14.0000 | 2026-01-05 | 14.0000 |
Example values from field definitions
- LOCR
- 1
- ITEMR
- SAMPLE
- LOC_TYPER
- 1
- ITEM_PARENT
- SAMPLE
- SELLING_UOM
- SAMP
- ON_ORDER_QTY
- 1.0000
- STOCK_ON_HAND
- 1.0000
- EFFECTIVE_DATE
- 2026-01-01
- IN_TRANSIT_QTY
- 1.0000
default
- LOCR
- 3
- ITEMR
- RPM Oi Inventory Gtt-002-
- LOC_TYPER
- 2
- ITEM_PARENT
- RPM Oi Inventory Gtt-002-
- SELLING_UOM
- RPM
- ON_ORDER_QTY
- 12.5000
- STOCK_ON_HAND
- 12.5000
- EFFECTIVE_DATE
- 2026-01-03
- IN_TRANSIT_QTY
- 12.5000
default
- LOCR
- 5
- ITEMR
- RPM Oi Inventory Gtt-003-
- LOC_TYPER
- 0
- ITEM_PARENT
- RPM Oi Inventory Gtt-003-
- SELLING_UOM
- RPM
- ON_ORDER_QTY
- 14.0000
- STOCK_ON_HAND
- 14.0000
- EFFECTIVE_DATE
- 2026-01-05
- IN_TRANSIT_QTY
- 14.0000
Rule Validation Summary
- Source Rule Count
- 17
- Governed Rule Count
- 12