RPM Promo
In ScopeTechnical: RPM_PROMO | ID: OR-PRC-RPM_PROMO-RPM_PROMO
This is the header level table for promotions.
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
Field Definitions(5)
Rules & Considerations(32)
constraint
validation
Sample Load Data(4)
| _scenario | PROMO_IDRPK | CREATE_IDR | CREATE_DATETIMER | PROMO_DISPLAY_IDR | NAME | COMMENTS | END_DATE | START_DATE | CAMPAIGN_ID | DESCRIPTION | CUST_ATTR_ID | GENERATED_BY | LOCK_VERSION | CURRENCY_CODE | SECONDARY_IND | LAST_UPDATE_ID | PROMO_EVENT_ID | OBJECT_VERSION_ID | LAST_UPDATE_DATETIME | CUST_ATTR_PROMO_DTL_IND | CUST_ATTR_PROMO_COMP_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 2026-01-01 | 1 | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | 1 | SAMPLE | 1 | S | 1 | SAM | 1 | SAMPLE | 1 | 1 | 2026-01-01 | 1 | 1 |
| default | 1000000003 | APP_USER_ID | 2026-01-03 | 1000000003 | — | — | — | — | 1000000003 | RPM Promo-002-ALT | — | S | — | — | — | APP_USER_ID | — | 1000000003 | 2026-01-03 | — | — |
| default | 1000000005 | USERENV | 2026-01-05 | 1000000005 | — | — | — | — | 1000000005 | — | — | S | — | — | — | USERENV | — | 1000000005 | 2026-01-05 | — | — |
Example values from field definitions
- PROMO_IDRPK
- 1
- CREATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- PROMO_DISPLAY_IDR
- 1
- NAME
- SAMPLE
- COMMENTS
- SAMPLE
- END_DATE
- 2026-01-01
- START_DATE
- 2026-01-01
- CAMPAIGN_ID
- 1
- DESCRIPTION
- SAMPLE
- CUST_ATTR_ID
- 1
- GENERATED_BY
- S
- LOCK_VERSION
- 1
- CURRENCY_CODE
- SAM
- SECONDARY_IND
- 1
- LAST_UPDATE_ID
- SAMPLE
- PROMO_EVENT_ID
- 1
- OBJECT_VERSION_ID
- 1
- LAST_UPDATE_DATETIME
- 2026-01-01
- CUST_ATTR_PROMO_DTL_IND
- 1
- CUST_ATTR_PROMO_COMP_IND
- 1
default
- PROMO_IDRPK
- 1000000003
- CREATE_IDR
- APP_USER_ID
- CREATE_DATETIMER
- 2026-01-03
- PROMO_DISPLAY_IDR
- 1000000003
- NAME
- —
- COMMENTS
- —
- END_DATE
- —
- START_DATE
- —
- CAMPAIGN_ID
- 1000000003
- DESCRIPTION
- RPM Promo-002-ALT
- CUST_ATTR_ID
- —
- GENERATED_BY
- S
- LOCK_VERSION
- —
- CURRENCY_CODE
- —
- SECONDARY_IND
- —
- LAST_UPDATE_ID
- APP_USER_ID
- PROMO_EVENT_ID
- —
- OBJECT_VERSION_ID
- 1000000003
- LAST_UPDATE_DATETIME
- 2026-01-03
- CUST_ATTR_PROMO_DTL_IND
- —
- CUST_ATTR_PROMO_COMP_IND
- —
default
- PROMO_IDRPK
- 1000000005
- CREATE_IDR
- USERENV
- CREATE_DATETIMER
- 2026-01-05
- PROMO_DISPLAY_IDR
- 1000000005
- NAME
- —
- COMMENTS
- —
- END_DATE
- —
- START_DATE
- —
- CAMPAIGN_ID
- 1000000005
- DESCRIPTION
- —
- CUST_ATTR_ID
- —
- GENERATED_BY
- S
- LOCK_VERSION
- —
- CURRENCY_CODE
- —
- SECONDARY_IND
- —
- LAST_UPDATE_ID
- USERENV
- PROMO_EVENT_ID
- —
- OBJECT_VERSION_ID
- 1000000005
- LAST_UPDATE_DATETIME
- 2026-01-05
- CUST_ATTR_PROMO_DTL_IND
- —
- CUST_ATTR_PROMO_COMP_IND
- —
Rule Validation Summary
- Source Rule Count
- 38
- Governed Rule Count
- 32