RPM Oi Pi Summary (GTT)

Out of Scope

Technical: RPM_OI_PI_SUMMARY_GTT | ID: OR-PRC-RPM_OI_PI_SUMMARY_GTT-RPM_OI_PI_SUMMARY_GTT

This table is used to hold data to be shown in price summary report.

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_OI_PI_SUMMARY_GTT

Field Definitions(5)

Rules & Considerations(14)

Sample Load Data(4)

_scenario	DEPT	ITEM	CLASS	DIFF_ID	LOCATION	LOC_TYPE	SUBCLASS	CLEAR_IND	ITEM_PARENT	SELLING_UOM	PRICING_COST	STANDARD_UOM	REGULAR_RETAIL	SELLING_RETAIL
Example values from field definitions	1	SAMPLE	1	SAMPLE	1	S	1	1	SAMPLE	SAMP	1.0000	SAMP	1.0000	1.0000
default	1003	RPM Oi Pi Summary Gtt-002	1103	ALT-RPM_OI	3	R	1113	3	RPM Oi Pi Summary Gtt-002	RPM	12.5000	RPM	12.5000	12.5000
default	1005	RPM Oi Pi Summary Gtt-003	1105	EDGE-RPM_O	5	R	1115	5	RPM Oi Pi Summary Gtt-003	RPM	14.0000	RPM	14.0000	14.0000

Example values from field definitions

DEPT: 1
ITEM: SAMPLE
CLASS: 1
DIFF_ID: SAMPLE
LOCATION: 1
LOC_TYPE: S
SUBCLASS: 1
CLEAR_IND: 1
ITEM_PARENT: SAMPLE
SELLING_UOM: SAMP
PRICING_COST: 1.0000
STANDARD_UOM: SAMP
REGULAR_RETAIL: 1.0000
SELLING_RETAIL: 1.0000

default

DEPT: 1003
ITEM: RPM Oi Pi Summary Gtt-002
CLASS: 1103
DIFF_ID: ALT-RPM_OI
LOCATION: 3
LOC_TYPE: R
SUBCLASS: 1113
CLEAR_IND: 3
ITEM_PARENT: RPM Oi Pi Summary Gtt-002
SELLING_UOM: RPM
PRICING_COST: 12.5000
STANDARD_UOM: RPM
REGULAR_RETAIL: 12.5000
SELLING_RETAIL: 12.5000

default

DEPT: 1005
ITEM: RPM Oi Pi Summary Gtt-003
CLASS: 1105
DIFF_ID: EDGE-RPM_O
LOCATION: 5
LOC_TYPE: R
SUBCLASS: 1115
CLEAR_IND: 5
ITEM_PARENT: RPM Oi Pi Summary Gtt-003
SELLING_UOM: RPM
PRICING_COST: 14.0000
STANDARD_UOM: RPM
REGULAR_RETAIL: 14.0000
SELLING_RETAIL: 14.0000

Rule Validation Summary

Source Rule Count: 17
Governed Rule Count: 14