RPM Oi Summary (GTT)
Out of ScopeTechnical: RPM_OI_SUMMARY_GTT | ID: OR-PRC-RPM_OI_SUMMARY_GTT-RPM_OI_SUMMARY_GTT
Helper table to hold and manipulate data for Pricing Contextual report.
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_SUMMARY_GTT
Field Definitions(5)
Rules & Considerations(16)
Sample Load Data(4)
| _scenario | LOC | DEPT | ITEM | CLASS | DIFF_ID | LOC_TYPE | SUBCLASS | CLEAR_IND | ITEM_PARENT | SELLING_UOM | PRICING_COST | STANDARD_UOM | REGULAR_RETAIL | SELLING_RETAIL | SELLING_UOM_CNT | MAINT_ITEM_WS_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 1 | SAMPLE | 1 | 1 | S | SAMPLE | SAMP | 1.0000 | SAMP | 1.0000 | 1.0000 | 1 | 1 |
| default | 3 | 1003 | RPM Oi Summary Gtt-002-AL | 1103 | ALT-RPM_OI | 3 | 1113 | R | RPM Oi Summary Gtt-002-AL | RPM | 12.5000 | RPM | 12.5000 | 12.5000 | 3 | 1000000003 |
| default | 5 | 1005 | RPM Oi Summary Gtt-003-ED | 1105 | EDGE-RPM_O | 5 | 1115 | R | RPM Oi Summary Gtt-003-ED | RPM | 14.0000 | RPM | 14.0000 | 14.0000 | 5 | 1000000005 |
Example values from field definitions
- LOC
- 1
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- DIFF_ID
- SAMPLE
- LOC_TYPE
- 1
- SUBCLASS
- 1
- CLEAR_IND
- S
- ITEM_PARENT
- SAMPLE
- SELLING_UOM
- SAMP
- PRICING_COST
- 1.0000
- STANDARD_UOM
- SAMP
- REGULAR_RETAIL
- 1.0000
- SELLING_RETAIL
- 1.0000
- SELLING_UOM_CNT
- 1
- MAINT_ITEM_WS_ID
- 1
default
- LOC
- 3
- DEPT
- 1003
- ITEM
- RPM Oi Summary Gtt-002-AL
- CLASS
- 1103
- DIFF_ID
- ALT-RPM_OI
- LOC_TYPE
- 3
- SUBCLASS
- 1113
- CLEAR_IND
- R
- ITEM_PARENT
- RPM Oi Summary Gtt-002-AL
- SELLING_UOM
- RPM
- PRICING_COST
- 12.5000
- STANDARD_UOM
- RPM
- REGULAR_RETAIL
- 12.5000
- SELLING_RETAIL
- 12.5000
- SELLING_UOM_CNT
- 3
- MAINT_ITEM_WS_ID
- 1000000003
default
- LOC
- 5
- DEPT
- 1005
- ITEM
- RPM Oi Summary Gtt-003-ED
- CLASS
- 1105
- DIFF_ID
- EDGE-RPM_O
- LOC_TYPE
- 5
- SUBCLASS
- 1115
- CLEAR_IND
- R
- ITEM_PARENT
- RPM Oi Summary Gtt-003-ED
- SELLING_UOM
- RPM
- PRICING_COST
- 14.0000
- STANDARD_UOM
- RPM
- REGULAR_RETAIL
- 14.0000
- SELLING_RETAIL
- 14.0000
- SELLING_UOM_CNT
- 5
- MAINT_ITEM_WS_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 19
- Governed Rule Count
- 16