RPM Merchandising Retail Def

In Scope

Technical: RPM_MERCH_RETAIL_DEF | ID: OR-PRC-RPM_MERCH_RETAIL_DEF-RPM_MERCHANDISING_RETAIL_DEF

used to define the primary zone group for a given merchandise hierarchy level in rpm. the primary zone group can be defined at the department, class or subclass level.

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_MERCH_RETAIL_DEF

Field Definitions(5)

Rules & Considerations(25)

constraint

validation

Sample Load Data(4)

_scenario	DEPTR	MERCH_TYPER	MERCH_RETAIL_DEF_IDRPK	CLASS	SUBCLASS	CREATE_ID	LOCK_VERSION	LAST_UPDATE_ID	MARKUP_PERCENT	CREATE_DATETIME	MARKUP_CALC_TYPE	ROUNDING_RULE_ID	OBJECT_VERSION_ID	REGULAR_ZONE_GROUP	CLEARANCE_ZONE_GROUP	LAST_UPDATE_DATETIME
Example values from field definitions	1	1	1	1	1	SAMPLE	1	SAMPLE	1.0000	2026-01-01	1	1	1	1	1	2026-01-01
default	1003	3	100003	1103	1113	APP_USER_ID	—	APP_USER_ID	12.5000	2026-01-03	3	1000000003	1000000003	203	—	2026-01-03
default	1005	5	100005	1105	1115	USERENV	—	USERENV	14.0000	2026-01-05	5	1000000005	1000000005	205	—	2026-01-05

Example values from field definitions

DEPTR: 1
MERCH_TYPER: 1
MERCH_RETAIL_DEF_IDRPK: 1
CLASS: 1
SUBCLASS: 1
CREATE_ID: SAMPLE
LOCK_VERSION: 1
LAST_UPDATE_ID: SAMPLE
MARKUP_PERCENT: 1.0000
CREATE_DATETIME: 2026-01-01
MARKUP_CALC_TYPE: 1
ROUNDING_RULE_ID: 1
OBJECT_VERSION_ID: 1
REGULAR_ZONE_GROUP: 1
CLEARANCE_ZONE_GROUP: 1
LAST_UPDATE_DATETIME: 2026-01-01

default

DEPTR: 1003
MERCH_TYPER: 3
MERCH_RETAIL_DEF_IDRPK: 100003
CLASS: 1103
SUBCLASS: 1113
CREATE_ID: APP_USER_ID
LOCK_VERSION: —
LAST_UPDATE_ID: APP_USER_ID
MARKUP_PERCENT: 12.5000
CREATE_DATETIME: 2026-01-03
MARKUP_CALC_TYPE: 3
ROUNDING_RULE_ID: 1000000003
OBJECT_VERSION_ID: 1000000003
REGULAR_ZONE_GROUP: 203
CLEARANCE_ZONE_GROUP: —
LAST_UPDATE_DATETIME: 2026-01-03