RPM Promo Json Cache
In ScopeTechnical: RPM_PROMO_JSON_CACHE | ID: OR-PRC-RPM_PROMO_JSON_CACHE-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- RPM_PROMO_JSON_CACHE
Field Definitions(5)
Rules & Considerations(11)
validation
constraint
Sample Load Data(4)
| _scenario | VERSIONR | OFFER_IDR | NODE_LEVELR | LOC | MESSAGE | END_DATE | CREATE_DATEYTIMESTAMP(6)118RECREATE_DATENTIMESTAMP(6)119UPDATE_DATEYTIMESTAMP(6)1110DELETED_DATENTIMESTAMP(6)1111PROMO_ID |
|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | S | 1 | 0x00 | 2026-01-01 | 1 |
| default | RPM Promo Json Cache-002-ALT | 1000000003 | R | 3 | RPM Promo Json Cache-002-ALT | 2026-01-03 | 1000000003 |
| default | RPM Promo Json Cache-003-EDGE | 1000000005 | R | 5 | RPM Promo Json Cache-003-EDGE | 2026-01-05 | 1000000005 |
Example values from field definitions
- VERSIONR
- SAMPLE
- OFFER_IDR
- 1
- NODE_LEVELR
- S
- LOC
- 1
- MESSAGE
- 0x00
- END_DATE
- 2026-01-01
- CREATE_DATEYTIMESTAMP(6)118RECREATE_DATENTIMESTAMP(6)119UPDATE_DATEYTIMESTAMP(6)1110DELETED_DATENTIMESTAMP(6)1111PROMO_ID
- 1
default
- VERSIONR
- RPM Promo Json Cache-002-ALT
- OFFER_IDR
- 1000000003
- NODE_LEVELR
- R
- LOC
- 3
- MESSAGE
- RPM Promo Json Cache-002-ALT
- END_DATE
- 2026-01-03
- CREATE_DATEYTIMESTAMP(6)118RECREATE_DATENTIMESTAMP(6)119UPDATE_DATEYTIMESTAMP(6)1110DELETED_DATENTIMESTAMP(6)1111PROMO_ID
- 1000000003
default
- VERSIONR
- RPM Promo Json Cache-003-EDGE
- OFFER_IDR
- 1000000005
- NODE_LEVELR
- R
- LOC
- 5
- MESSAGE
- RPM Promo Json Cache-003-EDGE
- END_DATE
- 2026-01-05
- CREATE_DATEYTIMESTAMP(6)118RECREATE_DATENTIMESTAMP(6)119UPDATE_DATEYTIMESTAMP(6)1110DELETED_DATENTIMESTAMP(6)1111PROMO_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 14
- Governed Rule Count
- 11