RPM Clr Json Cache
In ScopeTechnical: RPM_CLR_JSON_CACHE | ID: OR-PRC-RPM_CLR_JSON_CACHE-RPM_CLR_JSON_CACHE
Stores pre-built, cached data for Clearance 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_CLR_JSON_CACHE
Field Definitions(5)
Rules & Considerations(15)
validation
constraint
Sample Load Data(4)
| _scenario | LOCR | ITEMR | RESET_INDR | CLEARANCE_IDR | EFFECTIVE_DATER | MESSAGE | VERSION | CREATE_DATEYTIMESTAMP(6)119RECREATE_DATENTIMESTAMP(6)1110UPDATE_DATEYTIMESTAMP(6)1111DELETED_DATENTIMESTAMP(6)1112PRICE_EVENT_PAYLOAD_ID |
|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | 2026-01-01 | 0x00 | SAMPLE | 1 |
| default | 3 | RPM Clr Json Cache-002-AL | 3 | 1000000003 | 2026-01-03 | RPM Clr Json Cache-002-ALT | RPM Clr Json Cache-002-ALT | 1000000003 |
| default | 5 | RPM Clr Json Cache-003-ED | 5 | 1000000005 | 2026-01-05 | RPM Clr Json Cache-003-EDGE | RPM Clr Json Cache-003-EDGE | 1000000005 |
Example values from field definitions
- LOCR
- 1
- ITEMR
- SAMPLE
- RESET_INDR
- 1
- CLEARANCE_IDR
- 1
- EFFECTIVE_DATER
- 2026-01-01
- MESSAGE
- 0x00
- VERSION
- SAMPLE
- CREATE_DATEYTIMESTAMP(6)119RECREATE_DATENTIMESTAMP(6)1110UPDATE_DATEYTIMESTAMP(6)1111DELETED_DATENTIMESTAMP(6)1112PRICE_EVENT_PAYLOAD_ID
- 1
default
- LOCR
- 3
- ITEMR
- RPM Clr Json Cache-002-AL
- RESET_INDR
- 3
- CLEARANCE_IDR
- 1000000003
- EFFECTIVE_DATER
- 2026-01-03
- MESSAGE
- RPM Clr Json Cache-002-ALT
- VERSION
- RPM Clr Json Cache-002-ALT
- CREATE_DATEYTIMESTAMP(6)119RECREATE_DATENTIMESTAMP(6)1110UPDATE_DATEYTIMESTAMP(6)1111DELETED_DATENTIMESTAMP(6)1112PRICE_EVENT_PAYLOAD_ID
- 1000000003
default
- LOCR
- 5
- ITEMR
- RPM Clr Json Cache-003-ED
- RESET_INDR
- 5
- CLEARANCE_IDR
- 1000000005
- EFFECTIVE_DATER
- 2026-01-05
- MESSAGE
- RPM Clr Json Cache-003-EDGE
- VERSION
- RPM Clr Json Cache-003-EDGE
- CREATE_DATEYTIMESTAMP(6)119RECREATE_DATENTIMESTAMP(6)1110UPDATE_DATEYTIMESTAMP(6)1111DELETED_DATENTIMESTAMP(6)1112PRICE_EVENT_PAYLOAD_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 18
- Governed Rule Count
- 15