RPM Price Change Json Cache
In ScopeTechnical: RPM_PC_JSON_CACHE | ID: OR-PRC-RPM_PC_JSON_CACHE-RPM_PRICE_CHANGE_JSON_CACHE
Stores pre-built, cached data for Price Change JSON messages. It is used by the Pricing Rest Service for Item:Price 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_PC_JSON_CACHE
Field Definitions(5)
Rules & Considerations(13)
validation
constraint
Sample Load Data(4)
| _scenario | LOCR | ITEMR | VERSIONR | EFFECTIVE_DATER | PRICE_CHANGE_IDR | MESSAGE | CREATE_DATEYTIMESTAMP(6)118RECREATE_DATENTIMESTAMP(6)119UPDATE_DATEYTIMESTAMP(6)1110DELETED_DATENTIMESTAMP(6)1111PRICE_EVENT_PAYLOAD_ID |
|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | 2026-01-01 | 1 | 0x00 | 1 |
| default | 3 | RPM Pc Json Cache-002-ALT | RPM Pc Json Cache-002-ALT | 2026-01-03 | 1000000003 | RPM Pc Json Cache-002-ALT | 1000000003 |
| default | 5 | RPM Pc Json Cache-003-EDG | RPM Pc Json Cache-003-EDGE | 2026-01-05 | 1000000005 | RPM Pc Json Cache-003-EDGE | 1000000005 |
Example values from field definitions
- LOCR
- 1
- ITEMR
- SAMPLE
- VERSIONR
- SAMPLE
- EFFECTIVE_DATER
- 2026-01-01
- PRICE_CHANGE_IDR
- 1
- MESSAGE
- 0x00
- CREATE_DATEYTIMESTAMP(6)118RECREATE_DATENTIMESTAMP(6)119UPDATE_DATEYTIMESTAMP(6)1110DELETED_DATENTIMESTAMP(6)1111PRICE_EVENT_PAYLOAD_ID
- 1
default
- LOCR
- 3
- ITEMR
- RPM Pc Json Cache-002-ALT
- VERSIONR
- RPM Pc Json Cache-002-ALT
- EFFECTIVE_DATER
- 2026-01-03
- PRICE_CHANGE_IDR
- 1000000003
- MESSAGE
- RPM Pc Json Cache-002-ALT
- CREATE_DATEYTIMESTAMP(6)118RECREATE_DATENTIMESTAMP(6)119UPDATE_DATEYTIMESTAMP(6)1110DELETED_DATENTIMESTAMP(6)1111PRICE_EVENT_PAYLOAD_ID
- 1000000003
default
- LOCR
- 5
- ITEMR
- RPM Pc Json Cache-003-EDG
- VERSIONR
- RPM Pc Json Cache-003-EDGE
- EFFECTIVE_DATER
- 2026-01-05
- PRICE_CHANGE_IDR
- 1000000005
- MESSAGE
- RPM Pc Json Cache-003-EDGE
- CREATE_DATEYTIMESTAMP(6)118RECREATE_DATENTIMESTAMP(6)119UPDATE_DATEYTIMESTAMP(6)1110DELETED_DATENTIMESTAMP(6)1111PRICE_EVENT_PAYLOAD_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 16
- Governed Rule Count
- 13