Details Of Clearance Cadence Templates

In Scope

Technical: RPM_CADENCE | ID: OR-PRC-RPM_CADENCE-RPM_CADENCE

Stores the details of clearance cadence templates. This table has a many-to-one relation with RPM_CADENCE_TEMPLATE which acts as a master table for RPM_CADENCE.

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_CADENCE

Field Definitions(5)

Rules & Considerations(23)

validation

constraint

Sample Load Data(4)

_scenario	STEPR	CADENCE_IDRPK	TEMPLATE_IDR	CREATE_ID	PERCENT_OFF	REASON_CODE	MARKDOWN_NBR	LAST_UPDATE_ID	CREATE_DATETIME	DAYS_AFTER_FIRST	ROUNDING_RULE_ID	OBJECT_VERSION_ID	LAST_UPDATE_DATETIME
Example values from field definitions	1	1	1	SAMPLE	1.0000	SAMPLE	SAMPLE	SAMPLE	2026-01-01	1	1	1	2026-01-01
default	3	1000000003	1000000003	APP_USER_ID	12.5000	ALT-RP	RPM Ca	APP_USER_ID	2026-01-03	3	1000000003	1000000003	2026-01-03
default	5	1000000005	1000000005	USERENV	14.0000	EDGE-R	RPM Ca	USERENV	2026-01-05	5	1000000005	1000000005	2026-01-05

Example values from field definitions

STEPR: 1
CADENCE_IDRPK: 1
TEMPLATE_IDR: 1
CREATE_ID: SAMPLE
PERCENT_OFF: 1.0000
REASON_CODE: SAMPLE
MARKDOWN_NBR: SAMPLE
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
DAYS_AFTER_FIRST: 1
ROUNDING_RULE_ID: 1
OBJECT_VERSION_ID: 1
LAST_UPDATE_DATETIME: 2026-01-01

default

STEPR: 3
CADENCE_IDRPK: 1000000003
TEMPLATE_IDR: 1000000003
CREATE_ID: APP_USER_ID
PERCENT_OFF: 12.5000
REASON_CODE: ALT-RP
MARKDOWN_NBR: RPM Ca
LAST_UPDATE_ID: APP_USER_ID
CREATE_DATETIME: 2026-01-03
DAYS_AFTER_FIRST: 3
ROUNDING_RULE_ID: 1000000003
OBJECT_VERSION_ID: 1000000003
LAST_UPDATE_DATETIME: 2026-01-03