RPM Service Promo Offer Bak
In ScopeTechnical: RPM_SVC_PROMO_OFFER_BAK | ID: OR-PRC-RPM_SVC_PROMO_OFFER_BAK-RPM_SERVICE_PROMO_OFFER_BAK
This table is used in purge operation as a backup table for rpm_svc_promo_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_SVC_PROMO_OFFER_BAK
Field Definitions(5)
Rules & Considerations(33)
validation
constraint
Sample Load Data(4)
| _scenario | ACTIONR | ROW_SEQR | CHUNK_IDR | PROCESS_IDR | PROCESS$STATUSR | STATE | COMMENTS | CURRENCY | END_DATE | OFFER_ID | PROMO_ID | ERROR_MSG | CANCEL_IND | OFFER_DESC | START_DATE | COUPON_CODE | TEMPLATE_ID | OPS_END_DATE | CANCEL_REASON | PURCHASE_TYPE | OPS_START_DATE | CANCEL_DATETIME | NEW_OFFER_BATCH | NEW_PROMO_BATCH | OFFER_CUST_DESC | OFFER_DISPLAY_ID | PRIMARY_SUPPLIER | PROMO_DISPLAY_ID | DISTRIB_RULE_CODE | INCOMING_END_DATE | INCOMING_END_TIME | COUPON_CODE_REQ_IND | INCOMING_START_DATE | INCOMING_START_TIME | EXCLUSIVE_DISCOUNT_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1 | SAMPLE | 1 | SAMPLE | SAM | 2026-01-01 | 1 | 1 | SAMPLE | 1 | SAMPLE | 2026-01-01 | SAMPLE | 1 | 2026-01-01 | SAMPLE | 1 | 2026-01-01 | 2026-01-01 | 1 | 1 | SAMPLE | 1 | 1 | 1 | SAMPLE | 2026-01-01 | SAMPLE | 1 | 2026-01-01 | SAMPLE | 1 |
| default | RPM Svc Pr | 3 | 1000000003 | 1000000003 | PENDING-AL | 3 | RPM Svc Promo Offer Bak-002-ALT | RPM | 2026-01-03 | 1000000003 | 1000000003 | RPM Svc Promo Offer Bak-002-ALT | 3 | RPM Svc Promo Offer Bak-002-ALT | 2026-01-03 | ALT-RPM_SVC-002 | 100003 | 2026-01-03 | RPM Sv | 3 | 2026-01-03 | 2026-01-03 | 3 | 3 | RPM Svc Promo Offer Bak-002-ALT | 1000000003 | 3 | 1000000003 | ALT-RP | 2026-01-03 | RPM Svc Pr | 3 | 2026-01-03 | RPM Svc Pr | 3 |
| default | RPM Svc Pr | 5 | 1000000005 | 1000000005 | ACTIVE-EDG | 5 | RPM Svc Promo Offer Bak-003-EDGE | RPM | 2026-01-05 | 1000000005 | 1000000005 | RPM Svc Promo Offer Bak-003-EDGE | 5 | RPM Svc Promo Offer Bak-003-EDGE | 2026-01-05 | EDGE-RPM_SVC-003 | 100005 | 2026-01-05 | RPM Sv | 5 | 2026-01-05 | 2026-01-05 | 5 | 5 | RPM Svc Promo Offer Bak-003-EDGE | 1000000005 | 5 | 1000000005 | EDGE-R | 2026-01-05 | RPM Svc Pr | 5 | 2026-01-05 | RPM Svc Pr | 5 |
Example values from field definitions
- ACTIONR
- SAMPLE
- ROW_SEQR
- 1
- CHUNK_IDR
- 1
- PROCESS_IDR
- 1
- PROCESS$STATUSR
- SAMPLE
- STATE
- 1
- COMMENTS
- SAMPLE
- CURRENCY
- SAM
- END_DATE
- 2026-01-01
- OFFER_ID
- 1
- PROMO_ID
- 1
- ERROR_MSG
- SAMPLE
- CANCEL_IND
- 1
- OFFER_DESC
- SAMPLE
- START_DATE
- 2026-01-01
- COUPON_CODE
- SAMPLE
- TEMPLATE_ID
- 1
- OPS_END_DATE
- 2026-01-01
- CANCEL_REASON
- SAMPLE
- PURCHASE_TYPE
- 1
- OPS_START_DATE
- 2026-01-01
- CANCEL_DATETIME
- 2026-01-01
- NEW_OFFER_BATCH
- 1
- NEW_PROMO_BATCH
- 1
- OFFER_CUST_DESC
- SAMPLE
- OFFER_DISPLAY_ID
- 1
- PRIMARY_SUPPLIER
- 1
- PROMO_DISPLAY_ID
- 1
- DISTRIB_RULE_CODE
- SAMPLE
- INCOMING_END_DATE
- 2026-01-01
- INCOMING_END_TIME
- SAMPLE
- COUPON_CODE_REQ_IND
- 1
- INCOMING_START_DATE
- 2026-01-01
- INCOMING_START_TIME
- SAMPLE
- EXCLUSIVE_DISCOUNT_IND
- 1
default
- ACTIONR
- RPM Svc Pr
- ROW_SEQR
- 3
- CHUNK_IDR
- 1000000003
- PROCESS_IDR
- 1000000003
- PROCESS$STATUSR
- PENDING-AL
- STATE
- 3
- COMMENTS
- RPM Svc Promo Offer Bak-002-ALT
- CURRENCY
- RPM
- END_DATE
- 2026-01-03
- OFFER_ID
- 1000000003
- PROMO_ID
- 1000000003
- ERROR_MSG
- RPM Svc Promo Offer Bak-002-ALT
- CANCEL_IND
- 3
- OFFER_DESC
- RPM Svc Promo Offer Bak-002-ALT
- START_DATE
- 2026-01-03
- COUPON_CODE
- ALT-RPM_SVC-002
- TEMPLATE_ID
- 100003
- OPS_END_DATE
- 2026-01-03
- CANCEL_REASON
- RPM Sv
- PURCHASE_TYPE
- 3
- OPS_START_DATE
- 2026-01-03
- CANCEL_DATETIME
- 2026-01-03
- NEW_OFFER_BATCH
- 3
- NEW_PROMO_BATCH
- 3
- OFFER_CUST_DESC
- RPM Svc Promo Offer Bak-002-ALT
- OFFER_DISPLAY_ID
- 1000000003
- PRIMARY_SUPPLIER
- 3
- PROMO_DISPLAY_ID
- 1000000003
- DISTRIB_RULE_CODE
- ALT-RP
- INCOMING_END_DATE
- 2026-01-03
- INCOMING_END_TIME
- RPM Svc Pr
- COUPON_CODE_REQ_IND
- 3
- INCOMING_START_DATE
- 2026-01-03
- INCOMING_START_TIME
- RPM Svc Pr
- EXCLUSIVE_DISCOUNT_IND
- 3
default
- ACTIONR
- RPM Svc Pr
- ROW_SEQR
- 5
- CHUNK_IDR
- 1000000005
- PROCESS_IDR
- 1000000005
- PROCESS$STATUSR
- ACTIVE-EDG
- STATE
- 5
- COMMENTS
- RPM Svc Promo Offer Bak-003-EDGE
- CURRENCY
- RPM
- END_DATE
- 2026-01-05
- OFFER_ID
- 1000000005
- PROMO_ID
- 1000000005
- ERROR_MSG
- RPM Svc Promo Offer Bak-003-EDGE
- CANCEL_IND
- 5
- OFFER_DESC
- RPM Svc Promo Offer Bak-003-EDGE
- START_DATE
- 2026-01-05
- COUPON_CODE
- EDGE-RPM_SVC-003
- TEMPLATE_ID
- 100005
- OPS_END_DATE
- 2026-01-05
- CANCEL_REASON
- RPM Sv
- PURCHASE_TYPE
- 5
- OPS_START_DATE
- 2026-01-05
- CANCEL_DATETIME
- 2026-01-05
- NEW_OFFER_BATCH
- 5
- NEW_PROMO_BATCH
- 5
- OFFER_CUST_DESC
- RPM Svc Promo Offer Bak-003-EDGE
- OFFER_DISPLAY_ID
- 1000000005
- PRIMARY_SUPPLIER
- 5
- PROMO_DISPLAY_ID
- 1000000005
- DISTRIB_RULE_CODE
- EDGE-R
- INCOMING_END_DATE
- 2026-01-05
- INCOMING_END_TIME
- RPM Svc Pr
- COUPON_CODE_REQ_IND
- 5
- INCOMING_START_DATE
- 2026-01-05
- INCOMING_START_TIME
- RPM Svc Pr
- EXCLUSIVE_DISCOUNT_IND
- 5
Rule Validation Summary
- Source Rule Count
- 36
- Governed Rule Count
- 33