RPM Clearance
In ScopeTechnical: RPM_CLEARANCE | ID: OR-PRC-RPM_CLEARANCE-RPM_CLEARANCE
Stores one row for each clearance event stored within Pricing. It stores item information, location information, and the retail change information.
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
Field Definitions(38)
Rules & Considerations(52)
constraint
validation
Sample Load Data(4)
| _scenario | STATER | CREATE_IDR | CHANGE_TYPER | CLEARANCE_IDRPK | CONFLICT_INDR | EFFECTIVE_DATER | LAST_UPDATE_IDR | ZONE_NODE_TYPER | CREATE_DATETIMER | CLEARANCE_GROUP_IDRPK | EXCEPTION_PARENT_IDRPK | CLEARANCE_DISPLAY_IDR | LAST_UPDATE_DATETIMER | SYS_GENERATED_EXCLUSIONR | BATCH_GENERATED_EXCLUSIONR | ITEM | DIFF_ID | ZONE_ID | LOCATION | APPROVAL_ID | REASON_CODE | SOURCE_FILE | GENERATED_BY | MARKDOWN_NBR | APPROVAL_DATE | CHANGE_AMOUNT | ORIGINAL_ITEM | PURCHASE_TYPE | CHANGE_PERCENT | CHANGE_CURRENCY | ORIGINAL_DIFF_ID | ORIGINAL_ZONE_ID | PRIMARY_SUPPLIER | ROUNDING_RULE_ID | OBJECT_VERSION_ID | ORIGINAL_EVENT_ID | CHANGE_SELLING_UOM | LAST_UPDATE_SOURCE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | 1 | 2026-01-01 | SAMPLE | 1 | 2026-01-01 | 1 | 1 | SAMPLE | 2026-01-01 | 1 | 1 | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | S | SAMPLE | 2026-01-01 | 1.0000 | SAMPLE | 1 | 1.0000 | SAM | SAMPLE | 1 | 1 | 1 | 1 | 1 | SAMP | SAMPLE |
Example values from field definitions
- STATER
- 1
- CREATE_IDR
- SAMPLE
- CHANGE_TYPER
- 1
- CLEARANCE_IDRPK
- 1
- CONFLICT_INDR
- 1
- EFFECTIVE_DATER
- 2026-01-01
- LAST_UPDATE_IDR
- SAMPLE
- ZONE_NODE_TYPER
- 1
- CREATE_DATETIMER
- 2026-01-01
- CLEARANCE_GROUP_IDRPK
- 1
- EXCEPTION_PARENT_IDRPK
- 1
- CLEARANCE_DISPLAY_IDR
- SAMPLE
- LAST_UPDATE_DATETIMER
- 2026-01-01
- SYS_GENERATED_EXCLUSIONR
- 1
- BATCH_GENERATED_EXCLUSIONR
- 1
- ITEM
- SAMPLE
- DIFF_ID
- SAMPLE
- ZONE_ID
- 1
- LOCATION
- 1
- APPROVAL_ID
- SAMPLE
- REASON_CODE
- SAMPLE
- SOURCE_FILE
- SAMPLE
- GENERATED_BY
- S
- MARKDOWN_NBR
- SAMPLE
- APPROVAL_DATE
- 2026-01-01
- CHANGE_AMOUNT
- 1.0000
- ORIGINAL_ITEM
- SAMPLE
- PURCHASE_TYPE
- 1
- CHANGE_PERCENT
- 1.0000
- CHANGE_CURRENCY
- SAM
- ORIGINAL_DIFF_ID
- SAMPLE
- ORIGINAL_ZONE_ID
- 1
- PRIMARY_SUPPLIER
- 1
- ROUNDING_RULE_ID
- 1
- OBJECT_VERSION_ID
- 1
- ORIGINAL_EVENT_ID
- 1
- CHANGE_SELLING_UOM
- SAMP
- LAST_UPDATE_SOURCE
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 61
- Governed Rule Count
- 52