RPM Rollup (GTT)

Out of Scope

Technical: RPM_ROLLUP_GTT | ID: OR-PRC-RPM_ROLLUP_GTT-RPM_ROLLUP_GTT

This helper table is used to assist the process that aggregates lower level data on RPM_FUTURE_RETAIL to higher levels.

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_ROLLUP_GTT

Field Definitions(5)

Rules & Considerations(12)

Sample Load Data(4)

_scenario	DEPT	ITEM	CLASS	DIFF_ID	LOCATION	SUBCLASS	ROLLUP_TYPE	TARGET_ITEM	TARGET_DIFF_ID	ZONE_NODE_TYPE	CHILD_TL_REC_COUNT	PARENT_TL_REC_COUNT
Example values from field definitions	1	SAMPLE	1	SAMPLE	1	1	SAMPLE	SAMPLE	SAMPLE	1	1	1
default	1003	RPM Rollup Gtt-002-ALT	1103	ALT-RPM_RO	3	1113	RPM Rollup	RPM Rollup Gtt-002-ALT	ALT-RPM_RO	3	3	3
default	1005	RPM Rollup Gtt-003-EDGE	1105	EDGE-RPM_R	5	1115	RPM Rollup	RPM Rollup Gtt-003-EDGE	EDGE-RPM_R	5	5	5

Example values from field definitions

DEPT: 1
ITEM: SAMPLE
CLASS: 1
DIFF_ID: SAMPLE
LOCATION: 1
SUBCLASS: 1
ROLLUP_TYPE: SAMPLE
TARGET_ITEM: SAMPLE
TARGET_DIFF_ID: SAMPLE
ZONE_NODE_TYPE: 1
CHILD_TL_REC_COUNT: 1
PARENT_TL_REC_COUNT: 1

default

DEPT: 1003
ITEM: RPM Rollup Gtt-002-ALT
CLASS: 1103
DIFF_ID: ALT-RPM_RO
LOCATION: 3
SUBCLASS: 1113
ROLLUP_TYPE: RPM Rollup
TARGET_ITEM: RPM Rollup Gtt-002-ALT
TARGET_DIFF_ID: ALT-RPM_RO
ZONE_NODE_TYPE: 3
CHILD_TL_REC_COUNT: 3
PARENT_TL_REC_COUNT: 3

default

DEPT: 1005
ITEM: RPM Rollup Gtt-003-EDGE
CLASS: 1105
DIFF_ID: EDGE-RPM_R
LOCATION: 5
SUBCLASS: 1115
ROLLUP_TYPE: RPM Rollup
TARGET_ITEM: RPM Rollup Gtt-003-EDGE
TARGET_DIFF_ID: EDGE-RPM_R
ZONE_NODE_TYPE: 5
CHILD_TL_REC_COUNT: 5
PARENT_TL_REC_COUNT: 5

Rule Validation Summary

Source Rule Count: 15
Governed Rule Count: 12