RPM Service Promo Offer Rwd M Bak
In ScopeTechnical: RPM_SVC_PROMO_OFFER_RWD_M_BAK | ID: OR-PRC-RPM_SVC_PROMO_OFFER_RWD_M_BAK-RPM_SERVICE_PROMO_OFFER_RWD_M_BAK
This table is used in purge operation as a backup table for rpm_svc_promo_offer_rwd_merch.
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_SVC_PROMO_OFFER_RWD_M_BAK
Field Definitions(5)
Rules & Considerations(28)
validation
constraint
Sample Load Data(4)
| _scenario | ACTIONR | ROW_SEQR | CHUNK_IDR | PROCESS_IDR | PROCESS$STATUSR | DEPT | ITEM | CLASS | DIFF_ID | OFFER_ID | SUBCLASS | ERROR_MSG | MERCH_LVL | BRAND_NAME | CANCEL_IND | EXCLUDE_IND | CANCEL_REASON | SUPPLIER_SITE | OFFER_END_DATE | CANCEL_DATETIME | NEW_OFFER_BATCH | OFFER_REWARD_ID | OFFER_DISPLAY_ID | OFFER_START_DATE | MERCH_LOWER_LVL_IND | OFFER_REWARD_MERCH_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1 | SAMPLE | 1 | SAMPLE | 1 | SAMPLE | 1 | 1 | SAMPLE | 1 | SAMPLE | 1 | 1 | SAMPLE | 1 | 2026-01-01 | 2026-01-01 | 1 | 1 | 1 | 2026-01-01 | 1 | 1 |
| default | RPM Svc Pr | 3 | 1000000003 | 1000000003 | PENDING-AL | 1003 | RPM Svc Promo Offer Rwd M | 1103 | ALT-RPM_SV | 1000000003 | 1113 | RPM Svc Promo Offer Rwd M Bak-002-ALT | 3 | RPM Svc Promo Offer Rwd M Bak | 3 | 3 | RPM Sv | 3 | 2026-01-03 | 2026-01-03 | 3 | 1000000003 | 1000000003 | 2026-01-03 | 3 | 1000000003 |
| default | RPM Svc Pr | 5 | 1000000005 | 1000000005 | ACTIVE-EDG | 1005 | RPM Svc Promo Offer Rwd M | 1105 | EDGE-RPM_S | 1000000005 | 1115 | RPM Svc Promo Offer Rwd M Bak-003-EDGE | 5 | RPM Svc Promo Offer Rwd M Bak | 5 | 5 | RPM Sv | 5 | 2026-01-05 | 2026-01-05 | 5 | 1000000005 | 1000000005 | 2026-01-05 | 5 | 1000000005 |
Example values from field definitions
- ACTIONR
- SAMPLE
- ROW_SEQR
- 1
- CHUNK_IDR
- 1
- PROCESS_IDR
- 1
- PROCESS$STATUSR
- SAMPLE
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- DIFF_ID
- SAMPLE
- OFFER_ID
- 1
- SUBCLASS
- 1
- ERROR_MSG
- SAMPLE
- MERCH_LVL
- 1
- BRAND_NAME
- SAMPLE
- CANCEL_IND
- 1
- EXCLUDE_IND
- 1
- CANCEL_REASON
- SAMPLE
- SUPPLIER_SITE
- 1
- OFFER_END_DATE
- 2026-01-01
- CANCEL_DATETIME
- 2026-01-01
- NEW_OFFER_BATCH
- 1
- OFFER_REWARD_ID
- 1
- OFFER_DISPLAY_ID
- 1
- OFFER_START_DATE
- 2026-01-01
- MERCH_LOWER_LVL_IND
- 1
- OFFER_REWARD_MERCH_ID
- 1
default
- ACTIONR
- RPM Svc Pr
- ROW_SEQR
- 3
- CHUNK_IDR
- 1000000003
- PROCESS_IDR
- 1000000003
- PROCESS$STATUSR
- PENDING-AL
- DEPT
- 1003
- ITEM
- RPM Svc Promo Offer Rwd M
- CLASS
- 1103
- DIFF_ID
- ALT-RPM_SV
- OFFER_ID
- 1000000003
- SUBCLASS
- 1113
- ERROR_MSG
- RPM Svc Promo Offer Rwd M Bak-002-ALT
- MERCH_LVL
- 3
- BRAND_NAME
- RPM Svc Promo Offer Rwd M Bak
- CANCEL_IND
- 3
- EXCLUDE_IND
- 3
- CANCEL_REASON
- RPM Sv
- SUPPLIER_SITE
- 3
- OFFER_END_DATE
- 2026-01-03
- CANCEL_DATETIME
- 2026-01-03
- NEW_OFFER_BATCH
- 3
- OFFER_REWARD_ID
- 1000000003
- OFFER_DISPLAY_ID
- 1000000003
- OFFER_START_DATE
- 2026-01-03
- MERCH_LOWER_LVL_IND
- 3
- OFFER_REWARD_MERCH_ID
- 1000000003
default
- ACTIONR
- RPM Svc Pr
- ROW_SEQR
- 5
- CHUNK_IDR
- 1000000005
- PROCESS_IDR
- 1000000005
- PROCESS$STATUSR
- ACTIVE-EDG
- DEPT
- 1005
- ITEM
- RPM Svc Promo Offer Rwd M
- CLASS
- 1105
- DIFF_ID
- EDGE-RPM_S
- OFFER_ID
- 1000000005
- SUBCLASS
- 1115
- ERROR_MSG
- RPM Svc Promo Offer Rwd M Bak-003-EDGE
- MERCH_LVL
- 5
- BRAND_NAME
- RPM Svc Promo Offer Rwd M Bak
- CANCEL_IND
- 5
- EXCLUDE_IND
- 5
- CANCEL_REASON
- RPM Sv
- SUPPLIER_SITE
- 5
- OFFER_END_DATE
- 2026-01-05
- CANCEL_DATETIME
- 2026-01-05
- NEW_OFFER_BATCH
- 5
- OFFER_REWARD_ID
- 1000000005
- OFFER_DISPLAY_ID
- 1000000005
- OFFER_START_DATE
- 2026-01-05
- MERCH_LOWER_LVL_IND
- 5
- OFFER_REWARD_MERCH_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 31
- Governed Rule Count
- 28