RPM Clearance Payload
In ScopeTechnical: RPM_CLEARANCE_PAYLOAD | ID: OR-PRC-RPM_CLEARANCE_PAYLOAD-RPM_CLEARANCE_PAYLOAD
table to hold clearance specific price event informationtable is only populated for clearance price events.
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_CLEARANCE_PAYLOAD
Field Definitions(5)
Rules & Considerations(17)
constraint
validation
Sample Load Data(4)
| _scenario | CLEARANCE_IDR | CLEARANCE_PAYLOAD_IDRPK | PRICE_EVENT_PAYLOAD_IDR | ITEM | LOCATION | BULK_CC_PE_ID | LOCATION_TYPE | EFFECTIVE_DATE | SELLING_RETAIL | RESET_INDICATOR | RESET_CLEARANCE_ID | SELLING_RETAIL_UOM | SELLING_RETAIL_CURRENCY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | SAMPLE | 1 | 1 | SAMPLE | 2026-01-01 | 1.0000 | 1 | 1 | SAMPLE | SAMPLE |
| default | 1000000003 | 1000000003 | 1000000003 | RPM Clearance Payload-002 | 3 | 1000000003 | RPM Clearance Payload-002-ALT | 2026-01-03 | 12.5000 | 3 | 1000000003 | RPM Clearance Payload-002 | RPM Clearance Payload-002 |
| default | 1000000005 | 1000000005 | 1000000005 | RPM Clearance Payload-003 | 5 | 1000000005 | RPM Clearance Payload-003-EDGE | 2026-01-05 | 14.0000 | 5 | 1000000005 | RPM Clearance Payload-003 | RPM Clearance Payload-003 |
Example values from field definitions
- CLEARANCE_IDR
- 1
- CLEARANCE_PAYLOAD_IDRPK
- 1
- PRICE_EVENT_PAYLOAD_IDR
- 1
- ITEM
- SAMPLE
- LOCATION
- 1
- BULK_CC_PE_ID
- 1
- LOCATION_TYPE
- SAMPLE
- EFFECTIVE_DATE
- 2026-01-01
- SELLING_RETAIL
- 1.0000
- RESET_INDICATOR
- 1
- RESET_CLEARANCE_ID
- 1
- SELLING_RETAIL_UOM
- SAMPLE
- SELLING_RETAIL_CURRENCY
- SAMPLE
default
- CLEARANCE_IDR
- 1000000003
- CLEARANCE_PAYLOAD_IDRPK
- 1000000003
- PRICE_EVENT_PAYLOAD_IDR
- 1000000003
- ITEM
- RPM Clearance Payload-002
- LOCATION
- 3
- BULK_CC_PE_ID
- 1000000003
- LOCATION_TYPE
- RPM Clearance Payload-002-ALT
- EFFECTIVE_DATE
- 2026-01-03
- SELLING_RETAIL
- 12.5000
- RESET_INDICATOR
- 3
- RESET_CLEARANCE_ID
- 1000000003
- SELLING_RETAIL_UOM
- RPM Clearance Payload-002
- SELLING_RETAIL_CURRENCY
- RPM Clearance Payload-002
default
- CLEARANCE_IDR
- 1000000005
- CLEARANCE_PAYLOAD_IDRPK
- 1000000005
- PRICE_EVENT_PAYLOAD_IDR
- 1000000005
- ITEM
- RPM Clearance Payload-003
- LOCATION
- 5
- BULK_CC_PE_ID
- 1000000005
- LOCATION_TYPE
- RPM Clearance Payload-003-EDGE
- EFFECTIVE_DATE
- 2026-01-05
- SELLING_RETAIL
- 14.0000
- RESET_INDICATOR
- 5
- RESET_CLEARANCE_ID
- 1000000005
- SELLING_RETAIL_UOM
- RPM Clearance Payload-003
- SELLING_RETAIL_CURRENCY
- RPM Clearance Payload-003
Rule Validation Summary
- Source Rule Count
- 20
- Governed Rule Count
- 17