RPM Fr Item Location Expl (GTT)
Out of ScopeTechnical: RPM_FR_ITEM_LOC_EXPL_GTT | ID: OR-PRC-RPM_FR_ITEM_LOC_EXPL_GTT-RPM_FR_ITEM_LOC_EXPL_GTT
Stores the exploded data at the Transaction Item /Location level based on the data from rpm_future_retail_gtt / rpm_cust_segment_promo_fr at IL or higher level.
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_FR_ITEM_LOC_EXPL_GTT
Field Definitions(5)
Rules & Considerations(53)
validation
constraint
Sample Load Data(4)
| _scenario | DEPTR | ITEMR | PRICE_EVENT_IDR | CLASS | LOCATION | SUBCLASS | CLEAR_UOM | ACTION_DATE | MULTI_UNITS | PC_MSG_TYPE | SELLING_UOM | CLEARANCE_ID | CLEAR_RETAIL | CLEAR_MSG_TYPE | PC_CHANGE_TYPE | PC_MULTI_UNITS | SELLING_RETAIL | ZONE_NODE_TYPE | CLEAR_START_IND | PRICE_CHANGE_ID | STEP_IDENTIFIER | CLEAR_MKDN_INDEX | FUTURE_RETAIL_ID | PC_CHANGE_AMOUNT | CLEAR_CHANGE_TYPE | MULTI_UNIT_RETAIL | PC_CHANGE_PERCENT | PC_CHANGE_CURRENCY | CLEAR_CHANGE_AMOUNT | PC_ROUNDING_RULE_ID | CLEARANCE_DISPLAY_ID | CLEAR_CHANGE_PERCENT | PC_MULTI_UNIT_IMPACT | PC_MULTI_UNIT_RETAIL | CLEAR_CHANGE_CURRENCY | CLEAR_RETAIL_CURRENCY | PC_CHANGE_SELLING_UOM | PC_SELLING_RETAIL_IND | CLEAR_ROUNDING_RULE_ID | MULTI_UNIT_SELLING_UOM | PC_EXCEPTION_PARENT_ID | PRICE_CHANGE_DISPLAY_ID | SELLING_RETAIL_CURRENCY | CLEAR_CHANGE_SELLING_UOM | CLEAR_EXCEPTION_PARENT_ID | PC_MULTI_UNIT_SELLING_UOM | MULTI_UNIT_RETAIL_CURRENCY | PC_MULTI_UNIT_RETAIL_CURRENCY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | 1 | 1 | SAMP | 2026-01-01 | 1.0000 | SAMPLE | SAMP | 1 | 1.0000 | SAMPLE | 1 | 1.0000 | 1.0000 | 1 | 1 | 1 | 1 | 1 | 1 | 1.0000 | 1 | 1.0000 | 1.0000 | SAM | 1.0000 | 1 | SAMPLE | 1.0000 | SA | 1.0000 | SAM | SAM | SAMP | 1 | 1 | SAMP | 1 | SAMPLE | SAM | SAMP | 1 | SAMP | SAM | SAM |
| default | 1003 | RPM Fr Item Loc Expl Gtt- | 1000000003 | 1103 | 3 | 1113 | RPM | 2026-01-03 | 12.5000 | RPM Fr Item Loc Expl Gtt-002-A | RPM | 1000000003 | 12.5000 | RPM Fr Item Loc Expl Gtt-002-A | 3 | 12.5000 | 12.5000 | 1 | 3 | 1000000003 | 3 | 3 | 1000000003 | 12.5000 | 3 | 12.5000 | 12.5000 | RPM | 12.5000 | 1000000003 | ALT-RPM_FR-002 | 12.5000 | R | 12.5000 | RPM | RPM | RPM | 3 | 1000000003 | RPM | 1000000003 | ALT-RPM_FR-002 | RPM | RPM | 1000000003 | RPM | RPM | RPM |
| default | 1005 | RPM Fr Item Loc Expl Gtt- | 1000000005 | 1105 | 5 | 1115 | RPM | 2026-01-05 | 14.0000 | RPM Fr Item Loc Expl Gtt-003-E | RPM | 1000000005 | 14.0000 | RPM Fr Item Loc Expl Gtt-003-E | 5 | 14.0000 | 14.0000 | 0 | 5 | 1000000005 | 5 | 5 | 1000000005 | 14.0000 | 5 | 14.0000 | 14.0000 | RPM | 14.0000 | 1000000005 | EDGE-RPM_FR-003 | 14.0000 | AU | 14.0000 | RPM | RPM | RPM | 5 | 1000000005 | RPM | 1000000005 | EDGE-RPM_FR-003 | RPM | RPM | 1000000005 | RPM | RPM | RPM |
Example values from field definitions
- DEPTR
- 1
- ITEMR
- SAMPLE
- PRICE_EVENT_IDR
- 1
- CLASS
- 1
- LOCATION
- 1
- SUBCLASS
- 1
- CLEAR_UOM
- SAMP
- ACTION_DATE
- 2026-01-01
- MULTI_UNITS
- 1.0000
- PC_MSG_TYPE
- SAMPLE
- SELLING_UOM
- SAMP
- CLEARANCE_ID
- 1
- CLEAR_RETAIL
- 1.0000
- CLEAR_MSG_TYPE
- SAMPLE
- PC_CHANGE_TYPE
- 1
- PC_MULTI_UNITS
- 1.0000
- SELLING_RETAIL
- 1.0000
- ZONE_NODE_TYPE
- 1
- CLEAR_START_IND
- 1
- PRICE_CHANGE_ID
- 1
- STEP_IDENTIFIER
- 1
- CLEAR_MKDN_INDEX
- 1
- FUTURE_RETAIL_ID
- 1
- PC_CHANGE_AMOUNT
- 1.0000
- CLEAR_CHANGE_TYPE
- 1
- MULTI_UNIT_RETAIL
- 1.0000
- PC_CHANGE_PERCENT
- 1.0000
- PC_CHANGE_CURRENCY
- SAM
- CLEAR_CHANGE_AMOUNT
- 1.0000
- PC_ROUNDING_RULE_ID
- 1
- CLEARANCE_DISPLAY_ID
- SAMPLE
- CLEAR_CHANGE_PERCENT
- 1.0000
- PC_MULTI_UNIT_IMPACT
- SA
- PC_MULTI_UNIT_RETAIL
- 1.0000
- CLEAR_CHANGE_CURRENCY
- SAM
- CLEAR_RETAIL_CURRENCY
- SAM
- PC_CHANGE_SELLING_UOM
- SAMP
- PC_SELLING_RETAIL_IND
- 1
- CLEAR_ROUNDING_RULE_ID
- 1
- MULTI_UNIT_SELLING_UOM
- SAMP
- PC_EXCEPTION_PARENT_ID
- 1
- PRICE_CHANGE_DISPLAY_ID
- SAMPLE
- SELLING_RETAIL_CURRENCY
- SAM
- CLEAR_CHANGE_SELLING_UOM
- SAMP
- CLEAR_EXCEPTION_PARENT_ID
- 1
- PC_MULTI_UNIT_SELLING_UOM
- SAMP
- MULTI_UNIT_RETAIL_CURRENCY
- SAM
- PC_MULTI_UNIT_RETAIL_CURRENCY
- SAM
default
- DEPTR
- 1003
- ITEMR
- RPM Fr Item Loc Expl Gtt-
- PRICE_EVENT_IDR
- 1000000003
- CLASS
- 1103
- LOCATION
- 3
- SUBCLASS
- 1113
- CLEAR_UOM
- RPM
- ACTION_DATE
- 2026-01-03
- MULTI_UNITS
- 12.5000
- PC_MSG_TYPE
- RPM Fr Item Loc Expl Gtt-002-A
- SELLING_UOM
- RPM
- CLEARANCE_ID
- 1000000003
- CLEAR_RETAIL
- 12.5000
- CLEAR_MSG_TYPE
- RPM Fr Item Loc Expl Gtt-002-A
- PC_CHANGE_TYPE
- 3
- PC_MULTI_UNITS
- 12.5000
- SELLING_RETAIL
- 12.5000
- ZONE_NODE_TYPE
- 1
- CLEAR_START_IND
- 3
- PRICE_CHANGE_ID
- 1000000003
- STEP_IDENTIFIER
- 3
- CLEAR_MKDN_INDEX
- 3
- FUTURE_RETAIL_ID
- 1000000003
- PC_CHANGE_AMOUNT
- 12.5000
- CLEAR_CHANGE_TYPE
- 3
- MULTI_UNIT_RETAIL
- 12.5000
- PC_CHANGE_PERCENT
- 12.5000
- PC_CHANGE_CURRENCY
- RPM
- CLEAR_CHANGE_AMOUNT
- 12.5000
- PC_ROUNDING_RULE_ID
- 1000000003
- CLEARANCE_DISPLAY_ID
- ALT-RPM_FR-002
- CLEAR_CHANGE_PERCENT
- 12.5000
- PC_MULTI_UNIT_IMPACT
- R
- PC_MULTI_UNIT_RETAIL
- 12.5000
- CLEAR_CHANGE_CURRENCY
- RPM
- CLEAR_RETAIL_CURRENCY
- RPM
- PC_CHANGE_SELLING_UOM
- RPM
- PC_SELLING_RETAIL_IND
- 3
- CLEAR_ROUNDING_RULE_ID
- 1000000003
- MULTI_UNIT_SELLING_UOM
- RPM
- PC_EXCEPTION_PARENT_ID
- 1000000003
- PRICE_CHANGE_DISPLAY_ID
- ALT-RPM_FR-002
- SELLING_RETAIL_CURRENCY
- RPM
- CLEAR_CHANGE_SELLING_UOM
- RPM
- CLEAR_EXCEPTION_PARENT_ID
- 1000000003
- PC_MULTI_UNIT_SELLING_UOM
- RPM
- MULTI_UNIT_RETAIL_CURRENCY
- RPM
- PC_MULTI_UNIT_RETAIL_CURRENCY
- RPM
default
- DEPTR
- 1005
- ITEMR
- RPM Fr Item Loc Expl Gtt-
- PRICE_EVENT_IDR
- 1000000005
- CLASS
- 1105
- LOCATION
- 5
- SUBCLASS
- 1115
- CLEAR_UOM
- RPM
- ACTION_DATE
- 2026-01-05
- MULTI_UNITS
- 14.0000
- PC_MSG_TYPE
- RPM Fr Item Loc Expl Gtt-003-E
- SELLING_UOM
- RPM
- CLEARANCE_ID
- 1000000005
- CLEAR_RETAIL
- 14.0000
- CLEAR_MSG_TYPE
- RPM Fr Item Loc Expl Gtt-003-E
- PC_CHANGE_TYPE
- 5
- PC_MULTI_UNITS
- 14.0000
- SELLING_RETAIL
- 14.0000
- ZONE_NODE_TYPE
- 0
- CLEAR_START_IND
- 5
- PRICE_CHANGE_ID
- 1000000005
- STEP_IDENTIFIER
- 5
- CLEAR_MKDN_INDEX
- 5
- FUTURE_RETAIL_ID
- 1000000005
- PC_CHANGE_AMOUNT
- 14.0000
- CLEAR_CHANGE_TYPE
- 5
- MULTI_UNIT_RETAIL
- 14.0000
- PC_CHANGE_PERCENT
- 14.0000
- PC_CHANGE_CURRENCY
- RPM
- CLEAR_CHANGE_AMOUNT
- 14.0000
- PC_ROUNDING_RULE_ID
- 1000000005
- CLEARANCE_DISPLAY_ID
- EDGE-RPM_FR-003
- CLEAR_CHANGE_PERCENT
- 14.0000
- PC_MULTI_UNIT_IMPACT
- AU
- PC_MULTI_UNIT_RETAIL
- 14.0000
- CLEAR_CHANGE_CURRENCY
- RPM
- CLEAR_RETAIL_CURRENCY
- RPM
- PC_CHANGE_SELLING_UOM
- RPM
- PC_SELLING_RETAIL_IND
- 5
- CLEAR_ROUNDING_RULE_ID
- 1000000005
- MULTI_UNIT_SELLING_UOM
- RPM
- PC_EXCEPTION_PARENT_ID
- 1000000005
- PRICE_CHANGE_DISPLAY_ID
- EDGE-RPM_FR-003
- SELLING_RETAIL_CURRENCY
- RPM
- CLEAR_CHANGE_SELLING_UOM
- RPM
- CLEAR_EXCEPTION_PARENT_ID
- 1000000005
- PC_MULTI_UNIT_SELLING_UOM
- RPM
- MULTI_UNIT_RETAIL_CURRENCY
- RPM
- PC_MULTI_UNIT_RETAIL_CURRENCY
- RPM
Rule Validation Summary
- Source Rule Count
- 63
- Governed Rule Count
- 53