RPM Item Zone Price

In Scope

Technical: RPM_ITEM_ZONE_PRICE | ID: OR-PRC-RPM_ITEM_ZONE_PRICE-RPM_ITEM_ZONE_PRICE

This table will store the retail information for an item/zone where the zone is within the primary zone group of the item. The information in this table will be updated...

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: dictionary

Target Structure

Load Approach: Table
Target Objects: RPM_ITEM_ZONE_PRICE

Field Definitions(5)

Rules & Considerations(20)

validation

constraint

Sample Load Data(4)

_scenario	ITEMR	ZONE_IDR	STANDARD_RETAILR	ITEM_ZONE_PRICE_IDRPK	MULTI_UNITS	SELLING_UOM	LOCK_VERSION	STANDARD_UOM	SELLING_RETAIL	MULTI_SELLING_UOM	MULTI_UNIT_RETAIL	SELLING_RETAIL_CURRENCY	STANDARD_RETAIL_CURRENCY	MULTI_UNIT_RETAIL_CURRENCY
Example values from field definitions	SAMPLE	1	1.0000	1	1.0000	SAMP	1	SAMP	1.0000	SAMP	1.0000	SAM	SAM	SAM
default	RPM Item Zone Price-002-A	1000000003	12.5000	1000000003	12.5000	RPM	—	RPM	12.5000	RPM	12.5000	RPM	RPM	RPM
default	RPM Item Zone Price-003-E	1000000005	14.0000	1000000005	14.0000	RPM	—	RPM	14.0000	RPM	14.0000	RPM	RPM	RPM

Example values from field definitions

ITEMR: SAMPLE
ZONE_IDR: 1
STANDARD_RETAILR: 1.0000
ITEM_ZONE_PRICE_IDRPK: 1
MULTI_UNITS: 1.0000
SELLING_UOM: SAMP
LOCK_VERSION: 1
STANDARD_UOM: SAMP
SELLING_RETAIL: 1.0000
MULTI_SELLING_UOM: SAMP
MULTI_UNIT_RETAIL: 1.0000
SELLING_RETAIL_CURRENCY: SAM
STANDARD_RETAIL_CURRENCY: SAM
MULTI_UNIT_RETAIL_CURRENCY: SAM

default

ITEMR: RPM Item Zone Price-002-A
ZONE_IDR: 1000000003
STANDARD_RETAILR: 12.5000
ITEM_ZONE_PRICE_IDRPK: 1000000003
MULTI_UNITS: 12.5000
SELLING_UOM: RPM
LOCK_VERSION: —
STANDARD_UOM: RPM
SELLING_RETAIL: 12.5000
MULTI_SELLING_UOM: RPM
MULTI_UNIT_RETAIL: 12.5000
SELLING_RETAIL_CURRENCY: RPM
STANDARD_RETAIL_CURRENCY: RPM
MULTI_UNIT_RETAIL_CURRENCY: RPM