Promotion Offers
In ScopeTechnical: RPM_PROMO_OFFER | ID: OR-PRC-RPM_PROMO_OFFER-RPM_PROMO_OFFER
This holds promotion offers.
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
Field Definitions(5)
Rules & Considerations(43)
constraint
validation
Sample Load Data(4)
| _scenario | STATER | OFFER_IDRPK | PROMO_IDR | OFFER_DISPLAY_IDR | COMMENTS | CURRENCY | END_DATE | CANCEL_ID | CREATE_ID | TYPE_CODE | LEVEL_CODE | OFFER_DESC | START_DATE | APPROVAL_ID | COUPON_CODE | TEMPLATE_ID | CONFLICT_IND | CANCEL_REASON | PURCHASE_TYPE | LAST_UPDATE_ID | CANCEL_DATETIME | CREATE_DATETIME | OFFER_CUST_DESC | PRIMARY_SUPPLIER | APPROVAL_DATETIME | DISTRIB_RULE_CODE | OBJECT_VERSION_ID | IGNORE_CONSTRAINTS | COUPON_CODE_REQ_IND | LAST_UPDATE_DATETIME | EXCLUSIVE_DISCOUNT_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | SAMPLE | SAM | 2026-01-01 | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | 1 | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPLE | 1 | 2026-01-01 | SAMPLE | 1 | 1 | 1 | 2026-01-01 | 1 |
| default | 2 | 1000000003 | 1000000003 | 1000000003 | RPM Promo Offer-002-ALT | RPM | 2026-01-03 | ALT-RPM_PROMO-002 | APP_USER_ID | 1 | 1 | RPM Promo Offer-002-ALT | 2026-01-03 | ALT-RPM_PROMO-002 | ALT-RPM_PROMO-002 | 1 | 3 | RPM Pr | 1 | APP_USER_ID | 2026-01-03 | 2026-01-03 | RPM Promo Offer-002-ALT | 3 | 2026-01-03 | ALT-RP | 1000000003 | 3 | 3 | 2026-01-03 | 3 |
| default | 3 | 1000000005 | 1000000005 | 1000000005 | RPM Promo Offer-003-EDGE | RPM | 2026-01-05 | EDGE-RPM_PROMO-003 | USERENV | 2 | 0 | RPM Promo Offer-003-EDGE | 2026-01-05 | EDGE-RPM_PROMO-003 | EDGE-RPM_PROMO-003 | 2 | 5 | RPM Pr | 0 | USERENV | 2026-01-05 | 2026-01-05 | RPM Promo Offer-003-EDGE | 5 | 2026-01-05 | EDGE-R | 1000000005 | 5 | 5 | 2026-01-05 | 5 |
Example values from field definitions
- STATER
- 1
- OFFER_IDRPK
- 1
- PROMO_IDR
- 1
- OFFER_DISPLAY_IDR
- 1
- COMMENTS
- SAMPLE
- CURRENCY
- SAM
- END_DATE
- 2026-01-01
- CANCEL_ID
- SAMPLE
- CREATE_ID
- SAMPLE
- TYPE_CODE
- 1
- LEVEL_CODE
- 1
- OFFER_DESC
- SAMPLE
- START_DATE
- 2026-01-01
- APPROVAL_ID
- SAMPLE
- COUPON_CODE
- SAMPLE
- TEMPLATE_ID
- 1
- CONFLICT_IND
- 1
- CANCEL_REASON
- SAMPLE
- PURCHASE_TYPE
- 1
- LAST_UPDATE_ID
- SAMPLE
- CANCEL_DATETIME
- 2026-01-01
- CREATE_DATETIME
- 2026-01-01
- OFFER_CUST_DESC
- SAMPLE
- PRIMARY_SUPPLIER
- 1
- APPROVAL_DATETIME
- 2026-01-01
- DISTRIB_RULE_CODE
- SAMPLE
- OBJECT_VERSION_ID
- 1
- IGNORE_CONSTRAINTS
- 1
- COUPON_CODE_REQ_IND
- 1
- LAST_UPDATE_DATETIME
- 2026-01-01
- EXCLUSIVE_DISCOUNT_IND
- 1
default
- STATER
- 2
- OFFER_IDRPK
- 1000000003
- PROMO_IDR
- 1000000003
- OFFER_DISPLAY_IDR
- 1000000003
- COMMENTS
- RPM Promo Offer-002-ALT
- CURRENCY
- RPM
- END_DATE
- 2026-01-03
- CANCEL_ID
- ALT-RPM_PROMO-002
- CREATE_ID
- APP_USER_ID
- TYPE_CODE
- 1
- LEVEL_CODE
- 1
- OFFER_DESC
- RPM Promo Offer-002-ALT
- START_DATE
- 2026-01-03
- APPROVAL_ID
- ALT-RPM_PROMO-002
- COUPON_CODE
- ALT-RPM_PROMO-002
- TEMPLATE_ID
- 1
- CONFLICT_IND
- 3
- CANCEL_REASON
- RPM Pr
- PURCHASE_TYPE
- 1
- LAST_UPDATE_ID
- APP_USER_ID
- CANCEL_DATETIME
- 2026-01-03
- CREATE_DATETIME
- 2026-01-03
- OFFER_CUST_DESC
- RPM Promo Offer-002-ALT
- PRIMARY_SUPPLIER
- 3
- APPROVAL_DATETIME
- 2026-01-03
- DISTRIB_RULE_CODE
- ALT-RP
- OBJECT_VERSION_ID
- 1000000003
- IGNORE_CONSTRAINTS
- 3
- COUPON_CODE_REQ_IND
- 3
- LAST_UPDATE_DATETIME
- 2026-01-03
- EXCLUSIVE_DISCOUNT_IND
- 3
default
- STATER
- 3
- OFFER_IDRPK
- 1000000005
- PROMO_IDR
- 1000000005
- OFFER_DISPLAY_IDR
- 1000000005
- COMMENTS
- RPM Promo Offer-003-EDGE
- CURRENCY
- RPM
- END_DATE
- 2026-01-05
- CANCEL_ID
- EDGE-RPM_PROMO-003
- CREATE_ID
- USERENV
- TYPE_CODE
- 2
- LEVEL_CODE
- 0
- OFFER_DESC
- RPM Promo Offer-003-EDGE
- START_DATE
- 2026-01-05
- APPROVAL_ID
- EDGE-RPM_PROMO-003
- COUPON_CODE
- EDGE-RPM_PROMO-003
- TEMPLATE_ID
- 2
- CONFLICT_IND
- 5
- CANCEL_REASON
- RPM Pr
- PURCHASE_TYPE
- 0
- LAST_UPDATE_ID
- USERENV
- CANCEL_DATETIME
- 2026-01-05
- CREATE_DATETIME
- 2026-01-05
- OFFER_CUST_DESC
- RPM Promo Offer-003-EDGE
- PRIMARY_SUPPLIER
- 5
- APPROVAL_DATETIME
- 2026-01-05
- DISTRIB_RULE_CODE
- EDGE-R
- OBJECT_VERSION_ID
- 1000000005
- IGNORE_CONSTRAINTS
- 5
- COUPON_CODE_REQ_IND
- 5
- LAST_UPDATE_DATETIME
- 2026-01-05
- EXCLUSIVE_DISCOUNT_IND
- 5
Rule Validation Summary
- Source Rule Count
- 53
- Governed Rule Count
- 43