RPM Pee Item Zone (GTT)

Out of Scope

Technical: RPM_PEE_ITEM_ZONE_GTT | ID: OR-PRC-RPM_PEE_ITEM_ZONE_GTT-RPM_PEE_ITEM_ZONE_GTT

This is a temporary table that is used to manipulate data before updating rpm_item_zone_price table.

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_PEE_ITEM_ZONE_GTT

Field Definitions(5)

Rules & Considerations(13)

Sample Load Data(4)

_scenario	ITEM	ZONE	STD_UOM	STD_RETAIL	MULTI_UNITS	SELLING_UOM	SELLING_RETAIL	NEED_UOM_CONVERT	MULTI_UNIT_RETAIL	STD_RETAIL_CURRENCY	MULTI_UNIT_SELLING_UOM	SELLING_RETAIL_CURRENCY	MULTI_UNIT_RETAIL_CURRENCY
Example values from field definitions	SAMPLE	1	SAMP	1.0000	1.0000	SAMP	1.0000	S	1.0000	SAM	SAMP	SAM	SAM
default	RPM Pee Item Zone Gtt-002	3	RPM	12.5000	12.5000	RPM	12.5000	R	12.5000	RPM	RPM	RPM	RPM
default	RPM Pee Item Zone Gtt-003	5	RPM	14.0000	14.0000	RPM	14.0000	R	14.0000	RPM	RPM	RPM	RPM

Example values from field definitions

ITEM: SAMPLE
ZONE: 1
STD_UOM: SAMP
STD_RETAIL: 1.0000
MULTI_UNITS: 1.0000
SELLING_UOM: SAMP
SELLING_RETAIL: 1.0000
NEED_UOM_CONVERT: S
MULTI_UNIT_RETAIL: 1.0000
STD_RETAIL_CURRENCY: SAM
MULTI_UNIT_SELLING_UOM: SAMP
SELLING_RETAIL_CURRENCY: SAM
MULTI_UNIT_RETAIL_CURRENCY: SAM

default

ITEM: RPM Pee Item Zone Gtt-002
ZONE: 3
STD_UOM: RPM
STD_RETAIL: 12.5000
MULTI_UNITS: 12.5000
SELLING_UOM: RPM
SELLING_RETAIL: 12.5000
NEED_UOM_CONVERT: R
MULTI_UNIT_RETAIL: 12.5000
STD_RETAIL_CURRENCY: RPM
MULTI_UNIT_SELLING_UOM: RPM
SELLING_RETAIL_CURRENCY: RPM
MULTI_UNIT_RETAIL_CURRENCY: RPM

default

ITEM: RPM Pee Item Zone Gtt-003
ZONE: 5
STD_UOM: RPM
STD_RETAIL: 14.0000
MULTI_UNITS: 14.0000
SELLING_UOM: RPM
SELLING_RETAIL: 14.0000
NEED_UOM_CONVERT: R
MULTI_UNIT_RETAIL: 14.0000
STD_RETAIL_CURRENCY: RPM
MULTI_UNIT_SELLING_UOM: RPM
SELLING_RETAIL_CURRENCY: RPM
MULTI_UNIT_RETAIL_CURRENCY: RPM

Rule Validation Summary

Source Rule Count: 16
Governed Rule Count: 13