RPM Promo Json Cache
In ScopeTechnical: RPM_PROMO_JSON_CACHE | ID: OR-RPCS-RPM_PROMO_JSON_CACHE
Stores pre-built, cached data for Promotion Offer JSON messages. It is used by the Pricing Rest Service for Item:Promotion data.
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
Target Structure
- Load Approach
- Table
- Target Objects
- RPM_PROMO_JSON_CACHE
Field Definitions(7)
Rules & Considerations(22)
Sample Load Data(4)
| _scenario | MESSAGER | VERSIONR | OFFER_IDR | NODE_LEVELR | CREATE_DATEYTIMESTAMP(6)118RECREATE_DATENTIMESTAMP(6)119UPDATE_DATEYTIMESTAMP(6)1110DELETED_DATENTIMESTAMP(6)1111PROMO_IDR | LOC | END_DATE |
|---|---|---|---|---|---|---|---|
| default | RPM Promo Json Cache-001 | RPM Promo Json Cache-001 | 1000000001 | RPM Promo Json Cache-001 | 1000000001 | 1 | 2026-01-01 |
default
- MESSAGER
- RPM Promo Json Cache-001
- VERSIONR
- RPM Promo Json Cache-001
- OFFER_IDR
- 1000000001
- NODE_LEVELR
- RPM Promo Json Cache-001
- CREATE_DATEYTIMESTAMP(6)118RECREATE_DATENTIMESTAMP(6)119UPDATE_DATEYTIMESTAMP(6)1110DELETED_DATENTIMESTAMP(6)1111PROMO_IDR
- 1000000001
- LOC
- 1
- END_DATE
- 2026-01-01