RPM Future Retail (GTT)

Out of Scope

Technical: RPM_FUTURE_RETAIL_GTT | ID: OR-PRC-RPM_FUTURE_RETAIL_GTT-RPM_FUTURE_RETAIL_GTT

this global temporary table will store a subset of rpm_future_retail table that will be affected by the price event that is in the conflict checking process. the conflict checking process...

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_FUTURE_RETAIL_GTT

Field Definitions(5)

Rules & Considerations(66)

validation

constraint

Sample Load Data(4)

_scenario	DEPTR	ITEMR	CLASSR	PRICE_EVENT_IDR	FUTURE_RETAIL_IDR	DIFF_ID	LOCATION	SUBCLASS	CLEAR_UOM	ACTION_DATE	MULTI_UNITS	PC_MSG_TYPE	SELLING_UOM	CLEARANCE_ID	CLEAR_RETAIL	TIMELINE_SEQ	CLEAR_MSG_TYPE	CUR_HIER_LEVEL	MAX_HIER_LEVEL	ORIGINAL_FR_ID	PC_CHANGE_TYPE	PC_MULTI_UNITS	SELLING_RETAIL	ZONE_NODE_TYPE	CLEAR_START_IND	PRICE_CHANGE_ID	STEP_IDENTIFIER	CLEAR_MKDN_INDEX	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	CLEAR_CONDITION_CODE	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	RFR_ROWIDNROWID1051ITEM_PARENT
Example values from field definitions	1	SAMPLE	1	1	1	SAMPLE	1	1	SAMP	2026-01-01	1.0000	SAMPLE	SAMP	1	1.0000	1	SAMPLE	SA	SA	1	1	1.0000	1.0000	1	1	1	1	1	1.0000	1	1.0000	1.0000	SAM	1.0000	1	SAMPLE	1.0000	1	SA	1.0000	SAM	SAM	SAMP	1	1	SAMP	1	SAMPLE	SAM	SAMP	1	SAMP	SAM	SAM	SAMPLE
default	1003	RPM Future Retail Gtt-002	1103	1000000003	1000000003	ALT-RPM_FU	3	1113	RPM	2026-01-03	12.5000	RPM Future Retail Gtt-002-ALT	RPM	1000000003	12.5000	3	RPM Future Retail Gtt-002-ALT	RP	RP	1000000003	3	12.5000	12.5000	3	3	1000000003	3	3	12.5000	3	12.5000	12.5000	RPM	12.5000	1000000003	ALT-RPM_FUTURE-	12.5000	3	R	12.5000	RPM	RPM	RPM	3	1000000003	RPM	1000000003	ALT-RPM_FUTURE-	RPM	RPM	1000000003	RPM	RPM	RPM	RPM Future Retail Gtt-002
default	1005	RPM Future Retail Gtt-003	1105	1000000005	1000000005	EDGE-RPM_F	5	1115	RPM	2026-01-05	14.0000	RPM Future Retail Gtt-003-EDGE	RPM	1000000005	14.0000	5	RPM Future Retail Gtt-003-EDGE	RP	RP	1000000005	5	14.0000	14.0000	5	5	1000000005	5	5	14.0000	5	14.0000	14.0000	RPM	14.0000	1000000005	EDGE-RPM_FUTURE	14.0000	5	AU	14.0000	RPM	RPM	RPM	5	1000000005	RPM	1000000005	EDGE-RPM_FUTURE	RPM	RPM	1000000005	RPM	RPM	RPM	RPM Future Retail Gtt-003

Example values from field definitions

DEPTR: 1
ITEMR: SAMPLE
CLASSR: 1
PRICE_EVENT_IDR: 1
FUTURE_RETAIL_IDR: 1
DIFF_ID: SAMPLE
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
TIMELINE_SEQ: 1
CLEAR_MSG_TYPE: SAMPLE
CUR_HIER_LEVEL: SA
MAX_HIER_LEVEL: SA
ORIGINAL_FR_ID: 1
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
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
CLEAR_CONDITION_CODE: 1
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
RFR_ROWIDNROWID1051ITEM_PARENT: SAMPLE

default

DEPTR: 1003
ITEMR: RPM Future Retail Gtt-002
CLASSR: 1103
PRICE_EVENT_IDR: 1000000003
FUTURE_RETAIL_IDR: 1000000003
DIFF_ID: ALT-RPM_FU
LOCATION: 3
SUBCLASS: 1113
CLEAR_UOM: RPM
ACTION_DATE: 2026-01-03
MULTI_UNITS: 12.5000
PC_MSG_TYPE: RPM Future Retail Gtt-002-ALT
SELLING_UOM: RPM
CLEARANCE_ID: 1000000003
CLEAR_RETAIL: 12.5000
TIMELINE_SEQ: 3
CLEAR_MSG_TYPE: RPM Future Retail Gtt-002-ALT
CUR_HIER_LEVEL: RP
MAX_HIER_LEVEL: RP
ORIGINAL_FR_ID: 1000000003
PC_CHANGE_TYPE: 3
PC_MULTI_UNITS: 12.5000
SELLING_RETAIL: 12.5000
ZONE_NODE_TYPE: 3
CLEAR_START_IND: 3
PRICE_CHANGE_ID: 1000000003
STEP_IDENTIFIER: 3
CLEAR_MKDN_INDEX: 3
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_FUTURE-
CLEAR_CHANGE_PERCENT: 12.5000
CLEAR_CONDITION_CODE: 3
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_FUTURE-
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
RFR_ROWIDNROWID1051ITEM_PARENT: RPM Future Retail Gtt-002