RPM Zone Future Retail (GTT)

Out of Scope

Technical: RPM_ZONE_FUTURE_RETAIL_GTT | ID: OR-PRC-RPM_ZONE_FUTURE_RETAIL_GTT-RPM_ZONE_FUTURE_RETAIL_GTT

this global temporary table stores a subset of rpm_zone_future_retail table that are affected by the price change conflict checking process. the price change conflict checking process will work against this...

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_ZONE_FUTURE_RETAIL_GTT

Field Definitions(5)

Rules & Considerations(30)

validation

constraint

Sample Load Data(4)

_scenario	ITEMR	ZONER	ACTION_DATER	PRICE_EVENT_IDR	ZONE_FUTURE_RETAIL_IDR	MULTI_UNITS	SELLING_UOM	PC_CHANGE_TYPE	PC_MULTI_UNITS	SELLING_RETAIL	PRICE_CHANGE_ID	PC_CHANGE_AMOUNT	MULTI_UNIT_RETAIL	PC_CHANGE_PERCENT	PC_CHANGE_CURRENCY	PC_ROUNDING_RULE_ID	PC_MULTI_UNIT_IMPACT	PC_MULTI_UNIT_RETAIL	PC_CHANGE_SELLING_UOM	MULTI_UNIT_SELLING_UOM	PRICE_CHANGE_DISPLAY_ID	SELLING_RETAIL_CURRENCY	PC_MULTI_UNIT_SELLING_UOM	MULTI_UNIT_RETAIL_CURRENCY	PC_MULTI_UNIT_RETAIL_CURRENCY	RZFR_ROWIDNROWID1027TIMELINE_SEQ
Example values from field definitions	SAMPLE	1	2026-01-01	1	1	1.0000	SAMP	1	1.0000	1.0000	1	1.0000	1.0000	1.0000	SAM	1	SA	1.0000	SAMP	SAMP	SAMPLE	SAM	SAMP	SAM	SAM	1
default	RPM Zone Future Retail Gt	3	2026-01-03	1000000003	1000000003	12.5000	RPM	3	12.5000	12.5000	1000000003	12.5000	12.5000	12.5000	RPM	1000000003	R	12.5000	RPM	RPM	ALT-RPM_ZONE-00	RPM	RPM	RPM	RPM	3
default	RPM Zone Future Retail Gt	5	2026-01-05	1000000005	1000000005	14.0000	RPM	5	14.0000	14.0000	1000000005	14.0000	14.0000	14.0000	RPM	1000000005	AU	14.0000	RPM	RPM	EDGE-RPM_ZONE-0	RPM	RPM	RPM	RPM	5

Example values from field definitions

ITEMR: SAMPLE
ZONER: 1
ACTION_DATER: 2026-01-01
PRICE_EVENT_IDR: 1
ZONE_FUTURE_RETAIL_IDR: 1
MULTI_UNITS: 1.0000
SELLING_UOM: SAMP
PC_CHANGE_TYPE: 1
PC_MULTI_UNITS: 1.0000
SELLING_RETAIL: 1.0000
PRICE_CHANGE_ID: 1
PC_CHANGE_AMOUNT: 1.0000
MULTI_UNIT_RETAIL: 1.0000
PC_CHANGE_PERCENT: 1.0000
PC_CHANGE_CURRENCY: SAM
PC_ROUNDING_RULE_ID: 1
PC_MULTI_UNIT_IMPACT: SA
PC_MULTI_UNIT_RETAIL: 1.0000
PC_CHANGE_SELLING_UOM: SAMP
MULTI_UNIT_SELLING_UOM: SAMP
PRICE_CHANGE_DISPLAY_ID: SAMPLE
SELLING_RETAIL_CURRENCY: SAM
PC_MULTI_UNIT_SELLING_UOM: SAMP
MULTI_UNIT_RETAIL_CURRENCY: SAM
PC_MULTI_UNIT_RETAIL_CURRENCY: SAM
RZFR_ROWIDNROWID1027TIMELINE_SEQ: 1

default

ITEMR: RPM Zone Future Retail Gt
ZONER: 3
ACTION_DATER: 2026-01-03
PRICE_EVENT_IDR: 1000000003
ZONE_FUTURE_RETAIL_IDR: 1000000003
MULTI_UNITS: 12.5000
SELLING_UOM: RPM
PC_CHANGE_TYPE: 3
PC_MULTI_UNITS: 12.5000
SELLING_RETAIL: 12.5000
PRICE_CHANGE_ID: 1000000003
PC_CHANGE_AMOUNT: 12.5000
MULTI_UNIT_RETAIL: 12.5000
PC_CHANGE_PERCENT: 12.5000
PC_CHANGE_CURRENCY: RPM
PC_ROUNDING_RULE_ID: 1000000003
PC_MULTI_UNIT_IMPACT: R
PC_MULTI_UNIT_RETAIL: 12.5000
PC_CHANGE_SELLING_UOM: RPM
MULTI_UNIT_SELLING_UOM: RPM
PRICE_CHANGE_DISPLAY_ID: ALT-RPM_ZONE-00
SELLING_RETAIL_CURRENCY: RPM
PC_MULTI_UNIT_SELLING_UOM: RPM
MULTI_UNIT_RETAIL_CURRENCY: RPM
PC_MULTI_UNIT_RETAIL_CURRENCY: RPM
RZFR_ROWIDNROWID1027TIMELINE_SEQ: 3