RPM Promo Offer Custom Flex Attribute Extension

In Scope

Technical: RPM_PROMO_OFFER_CFA_EXT | ID: OR-PRC-RPM_PROMO_OFFER_CFA_EXT-RPM_PROMO_OFFER_CUSTOM_FLEX_ATTRIBUTE_EXTENSION

This is the custom attribute extension table for the entity RPM_PROMO_OFFER.

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_PROMO_OFFER_CFA_EXT

Field Definitions(5)

Rules & Considerations(26)

validation

constraint

Sample Load Data(4)

_scenario	GROUP_IDR	OFFER_IDRPK	DATE_21	DATE_22	DATE_23	DATE_24	DATE_25	NUMBER_11	NUMBER_12	NUMBER_13	NUMBER_14	NUMBER_15	NUMBER_16	NUMBER_17	NUMBER_18	NUMBER_19	NUMBER_20	VARCHAR2_1	VARCHAR2_2	VARCHAR2_3	VARCHAR2_4	VARCHAR2_5	VARCHAR2_6	VARCHAR2_7	VARCHAR2_8	VARCHAR2_9	VARCHAR2_10
Example values from field definitions	1	1	2026-01-01	2026-01-01	2026-01-01	2026-01-01	2026-01-01	1	1	1	1	1	1	1	1	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE
default	1000000003	1000000003	2026-01-03	2026-01-03	2026-01-03	2026-01-03	2026-01-03	3	3	3	3	3	3	3	3	3	3	RPM Promo Offer Cfa Ext-002-ALT	RPM Promo Offer Cfa Ext-002-ALT	RPM Promo Offer Cfa Ext-002-ALT	RPM Promo Offer Cfa Ext-002-ALT	RPM Promo Offer Cfa Ext-002-ALT	RPM Promo Offer Cfa Ext-002-ALT	RPM Promo Offer Cfa Ext-002-ALT	RPM Promo Offer Cfa Ext-002-ALT	RPM Promo Offer Cfa Ext-002-ALT	RPM Promo Offer Cfa Ext-002-ALT
default	1000000005	1000000005	2026-01-05	2026-01-05	2026-01-05	2026-01-05	2026-01-05	5	5	5	5	5	5	5	5	5	5	RPM Promo Offer Cfa Ext-003-EDGE	RPM Promo Offer Cfa Ext-003-EDGE	RPM Promo Offer Cfa Ext-003-EDGE	RPM Promo Offer Cfa Ext-003-EDGE	RPM Promo Offer Cfa Ext-003-EDGE	RPM Promo Offer Cfa Ext-003-EDGE	RPM Promo Offer Cfa Ext-003-EDGE	RPM Promo Offer Cfa Ext-003-EDGE	RPM Promo Offer Cfa Ext-003-EDGE	RPM Promo Offer Cfa Ext-003-EDGE

Example values from field definitions

GROUP_IDR: 1
OFFER_IDRPK: 1
DATE_21: 2026-01-01
DATE_22: 2026-01-01
DATE_23: 2026-01-01
DATE_24: 2026-01-01
DATE_25: 2026-01-01
NUMBER_11: 1
NUMBER_12: 1
NUMBER_13: 1
NUMBER_14: 1
NUMBER_15: 1
NUMBER_16: 1
NUMBER_17: 1
NUMBER_18: 1
NUMBER_19: 1
NUMBER_20: 1
VARCHAR2_1: SAMPLE
VARCHAR2_2: SAMPLE
VARCHAR2_3: SAMPLE
VARCHAR2_4: SAMPLE
VARCHAR2_5: SAMPLE
VARCHAR2_6: SAMPLE
VARCHAR2_7: SAMPLE
VARCHAR2_8: SAMPLE
VARCHAR2_9: SAMPLE
VARCHAR2_10: SAMPLE

default

GROUP_IDR: 1000000003
OFFER_IDRPK: 1000000003
DATE_21: 2026-01-03
DATE_22: 2026-01-03
DATE_23: 2026-01-03
DATE_24: 2026-01-03
DATE_25: 2026-01-03
NUMBER_11: 3
NUMBER_12: 3
NUMBER_13: 3
NUMBER_14: 3
NUMBER_15: 3
NUMBER_16: 3
NUMBER_17: 3
NUMBER_18: 3
NUMBER_19: 3
NUMBER_20: 3
VARCHAR2_1: RPM Promo Offer Cfa Ext-002-ALT
VARCHAR2_2: RPM Promo Offer Cfa Ext-002-ALT
VARCHAR2_3: RPM Promo Offer Cfa Ext-002-ALT
VARCHAR2_4: RPM Promo Offer Cfa Ext-002-ALT
VARCHAR2_5: RPM Promo Offer Cfa Ext-002-ALT
VARCHAR2_6: RPM Promo Offer Cfa Ext-002-ALT
VARCHAR2_7: RPM Promo Offer Cfa Ext-002-ALT
VARCHAR2_8: RPM Promo Offer Cfa Ext-002-ALT
VARCHAR2_9: RPM Promo Offer Cfa Ext-002-ALT
VARCHAR2_10: RPM Promo Offer Cfa Ext-002-ALT

default

GROUP_IDR: 1000000005
OFFER_IDRPK: 1000000005
DATE_21: 2026-01-05
DATE_22: 2026-01-05
DATE_23: 2026-01-05
DATE_24: 2026-01-05
DATE_25: 2026-01-05
NUMBER_11: 5
NUMBER_12: 5
NUMBER_13: 5
NUMBER_14: 5
NUMBER_15: 5
NUMBER_16: 5
NUMBER_17: 5
NUMBER_18: 5
NUMBER_19: 5
NUMBER_20: 5
VARCHAR2_1: RPM Promo Offer Cfa Ext-003-EDGE
VARCHAR2_2: RPM Promo Offer Cfa Ext-003-EDGE
VARCHAR2_3: RPM Promo Offer Cfa Ext-003-EDGE
VARCHAR2_4: RPM Promo Offer Cfa Ext-003-EDGE
VARCHAR2_5: RPM Promo Offer Cfa Ext-003-EDGE
VARCHAR2_6: RPM Promo Offer Cfa Ext-003-EDGE
VARCHAR2_7: RPM Promo Offer Cfa Ext-003-EDGE
VARCHAR2_8: RPM Promo Offer Cfa Ext-003-EDGE
VARCHAR2_9: RPM Promo Offer Cfa Ext-003-EDGE
VARCHAR2_10: RPM Promo Offer Cfa Ext-003-EDGE

Rule Validation Summary

Source Rule Count: 29
Governed Rule Count: 26