Condition Of Promotion Offers
In ScopeTechnical: RPM_PROMO_OFFER_COND | ID: OR-PRC-RPM_PROMO_OFFER_COND-RPM_PROMO_OFFER_COND
Stores the condition of 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_COND
Field Definitions(5)
Rules & Considerations(28)
validation
constraint
Sample Load Data(4)
| _scenario | COND_IDRPK | OFFER_IDRPK | BUY_SPEND_TYPER | BUY_SPEND_VALUER | BUY_UOM | CURRENCY | CREATE_ID | LAST_UPDATE_ID | COND_DISPLAY_ID | 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 | 1.0000 | SAMP | SAM | SAMPLE | SAMPLE | 1 | 2026-01-01 | 1 | SAMPLE | 2026-01-01 | 1.0000 | 1.0000 | 1 | SAM |
| default | 1000000003 | 1000000003 | 1 | 12.5000 | RPM | RPM | APP_USER_ID | APP_USER_ID | 1000000003 | 2026-01-03 | 3 | ALT-RP | 2026-01-03 | 12.5000 | 12.5000 | 3 | ALT |
| default | 1000000005 | 1000000005 | 0 | 14.0000 | RPM | RPM | USERENV | USERENV | 1000000005 | 2026-01-05 | 5 | EDGE-R | 2026-01-05 | 14.0000 | 14.0000 | 5 | EDG |
Example values from field definitions
- COND_IDRPK
- 1
- OFFER_IDRPK
- 1
- BUY_SPEND_TYPER
- 1
- BUY_SPEND_VALUER
- 1.0000
- BUY_UOM
- SAMP
- CURRENCY
- SAM
- CREATE_ID
- SAMPLE
- LAST_UPDATE_ID
- SAMPLE
- COND_DISPLAY_ID
- 1
- 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
- COND_IDRPK
- 1000000003
- OFFER_IDRPK
- 1000000003
- BUY_SPEND_TYPER
- 1
- BUY_SPEND_VALUER
- 12.5000
- BUY_UOM
- RPM
- CURRENCY
- RPM
- CREATE_ID
- APP_USER_ID
- LAST_UPDATE_ID
- APP_USER_ID
- COND_DISPLAY_ID
- 1000000003
- 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
- COND_IDRPK
- 1000000005
- OFFER_IDRPK
- 1000000005
- BUY_SPEND_TYPER
- 0
- BUY_SPEND_VALUER
- 14.0000
- BUY_UOM
- RPM
- CURRENCY
- RPM
- CREATE_ID
- USERENV
- LAST_UPDATE_ID
- USERENV
- COND_DISPLAY_ID
- 1000000005
- 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
- 28