RPM Rde Clearance Data
In ScopeTechnical: RPM_RDE_CLEARANCE_DATA | ID: OR-PRC-RPM_RDE_CLEARANCE_DATA-RPM_RDE_CLEARANCE_DATA
Stores clearance data that is replicated through Golden Gate to RDS.
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_RDE_CLEARANCE_DATA
Field Definitions(5)
Rules & Considerations(17)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMR | LOCATIONR | CLEARANCE_IDRPK | LOCATION_TYPER | EFFECTIVE_DATER | CREATE_DATE | DELETE_DATE | RECREATE_DATE | SELLING_RETAIL | RESET_INDICATOR | LAST_UPDATE_DATE | SELLING_RETAIL_UOM | SELLING_RETAIL_CURRENCY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | S | 2026-01-01 | 2026-01-01 | 2026-01-01 | 2026-01-01 | 1.0000 | 1 | 2026-01-01 | SAMP | SAM |
| default | RPM Rde Clearance Data-00 | 3 | 1000000003 | R | 2026-01-03 | 2026-01-03 | 2026-01-03 | 2026-01-03 | 12.5000 | 0 | 2026-01-03 | RPM | RPM |
| default | RPM Rde Clearance Data-00 | 5 | 1000000005 | R | 2026-01-05 | 2026-01-05 | 2026-01-05 | 2026-01-05 | 14.0000 | 1 | 2026-01-05 | RPM | RPM |
Example values from field definitions
- ITEMR
- SAMPLE
- LOCATIONR
- 1
- CLEARANCE_IDRPK
- 1
- LOCATION_TYPER
- S
- EFFECTIVE_DATER
- 2026-01-01
- CREATE_DATE
- 2026-01-01
- DELETE_DATE
- 2026-01-01
- RECREATE_DATE
- 2026-01-01
- SELLING_RETAIL
- 1.0000
- RESET_INDICATOR
- 1
- LAST_UPDATE_DATE
- 2026-01-01
- SELLING_RETAIL_UOM
- SAMP
- SELLING_RETAIL_CURRENCY
- SAM
default
- ITEMR
- RPM Rde Clearance Data-00
- LOCATIONR
- 3
- CLEARANCE_IDRPK
- 1000000003
- LOCATION_TYPER
- R
- EFFECTIVE_DATER
- 2026-01-03
- CREATE_DATE
- 2026-01-03
- DELETE_DATE
- 2026-01-03
- RECREATE_DATE
- 2026-01-03
- SELLING_RETAIL
- 12.5000
- RESET_INDICATOR
- 0
- LAST_UPDATE_DATE
- 2026-01-03
- SELLING_RETAIL_UOM
- RPM
- SELLING_RETAIL_CURRENCY
- RPM
default
- ITEMR
- RPM Rde Clearance Data-00
- LOCATIONR
- 5
- CLEARANCE_IDRPK
- 1000000005
- LOCATION_TYPER
- R
- EFFECTIVE_DATER
- 2026-01-05
- CREATE_DATE
- 2026-01-05
- DELETE_DATE
- 2026-01-05
- RECREATE_DATE
- 2026-01-05
- SELLING_RETAIL
- 14.0000
- RESET_INDICATOR
- 1
- LAST_UPDATE_DATE
- 2026-01-05
- SELLING_RETAIL_UOM
- RPM
- SELLING_RETAIL_CURRENCY
- RPM
Rule Validation Summary
- Source Rule Count
- 22
- Governed Rule Count
- 17