Rewards For A Promotion Offer
In ScopeTechnical: RPM_PROMO_OFFER_REWARD | ID: OR-PRC-RPM_PROMO_OFFER_REWARD-RPM_PROMO_OFFER_REWARD
Stores the rewards for a promotion 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_REWARD
Field Definitions(5)
Rules & Considerations(30)
validation
constraint
Sample Load Data(4)
| _scenario | OFFER_IDRPK | REWARD_IDRPK | CHANGE_TYPER | CREATE_ID | QTY_TO_DISC | APPLY_TO_IND | CHANGE_AMOUNT | UNLIMITED_IND | CHANGE_PERCENT | LAST_UPDATE_ID | CHANGE_CURRENCY | CREATE_DATETIME | ALL_CURRENCY_IND | PRICE_RESTRICT_CODE | LAST_UPDATE_DATETIME | PRICE_RESTRICT_VALUE_1 | PRICE_RESTRICT_VALUE_2 | PRICE_RESTRICT_ALL_CURRENCY | PRICE_RESTRICT_CURRENCY_CODE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | SAMPLE | 1 | 1 | 1.0000 | 1 | 1.0000 | SAMPLE | SAM | 2026-01-01 | 1 | SAMPLE | 2026-01-01 | 1.0000 | 1.0000 | 1 | SAM |
| default | 1000000003 | 1000000003 | 3 | APP_USER_ID | 3 | 3 | 12.5000 | 3 | 12.5000 | APP_USER_ID | RPM | 2026-01-03 | 3 | ALT-RP | 2026-01-03 | 12.5000 | 12.5000 | 3 | ALT |
| default | 1000000005 | 1000000005 | 5 | USERENV | 5 | 5 | 14.0000 | 5 | 14.0000 | USERENV | RPM | 2026-01-05 | 5 | EDGE-R | 2026-01-05 | 14.0000 | 14.0000 | 5 | EDG |
Example values from field definitions
- OFFER_IDRPK
- 1
- REWARD_IDRPK
- 1
- CHANGE_TYPER
- 1
- CREATE_ID
- SAMPLE
- QTY_TO_DISC
- 1
- APPLY_TO_IND
- 1
- CHANGE_AMOUNT
- 1.0000
- UNLIMITED_IND
- 1
- CHANGE_PERCENT
- 1.0000
- LAST_UPDATE_ID
- SAMPLE
- CHANGE_CURRENCY
- SAM
- CREATE_DATETIME
- 2026-01-01
- ALL_CURRENCY_IND
- 1
- PRICE_RESTRICT_CODE
- SAMPLE
- LAST_UPDATE_DATETIME
- 2026-01-01
- PRICE_RESTRICT_VALUE_1
- 1.0000
- PRICE_RESTRICT_VALUE_2
- 1.0000
- PRICE_RESTRICT_ALL_CURRENCY
- 1
- PRICE_RESTRICT_CURRENCY_CODE
- SAM
default
- OFFER_IDRPK
- 1000000003
- REWARD_IDRPK
- 1000000003
- CHANGE_TYPER
- 3
- CREATE_ID
- APP_USER_ID
- QTY_TO_DISC
- 3
- APPLY_TO_IND
- 3
- CHANGE_AMOUNT
- 12.5000
- UNLIMITED_IND
- 3
- CHANGE_PERCENT
- 12.5000
- LAST_UPDATE_ID
- APP_USER_ID
- CHANGE_CURRENCY
- RPM
- CREATE_DATETIME
- 2026-01-03
- ALL_CURRENCY_IND
- 3
- PRICE_RESTRICT_CODE
- ALT-RP
- LAST_UPDATE_DATETIME
- 2026-01-03
- PRICE_RESTRICT_VALUE_1
- 12.5000
- PRICE_RESTRICT_VALUE_2
- 12.5000
- PRICE_RESTRICT_ALL_CURRENCY
- 3
- PRICE_RESTRICT_CURRENCY_CODE
- ALT
default
- OFFER_IDRPK
- 1000000005
- REWARD_IDRPK
- 1000000005
- CHANGE_TYPER
- 5
- CREATE_ID
- USERENV
- QTY_TO_DISC
- 5
- APPLY_TO_IND
- 5
- CHANGE_AMOUNT
- 14.0000
- UNLIMITED_IND
- 5
- CHANGE_PERCENT
- 14.0000
- LAST_UPDATE_ID
- USERENV
- CHANGE_CURRENCY
- RPM
- CREATE_DATETIME
- 2026-01-05
- ALL_CURRENCY_IND
- 5
- PRICE_RESTRICT_CODE
- EDGE-R
- LAST_UPDATE_DATETIME
- 2026-01-05
- PRICE_RESTRICT_VALUE_1
- 14.0000
- PRICE_RESTRICT_VALUE_2
- 14.0000
- PRICE_RESTRICT_ALL_CURRENCY
- 5
- PRICE_RESTRICT_CURRENCY_CODE
- EDG
Rule Validation Summary
- Source Rule Count
- 35
- Governed Rule Count
- 30