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(5)
Rules & Considerations(54)
constraint
validation
Sample Load Data(4)
| _scenario | CLEARANCE_IDRPK | CLEARANCE_DISPLAY_IDR | ITEM | STATE | DIFF_ID | ZONE_ID | LOCATION | CREATE_ID | APPROVAL_ID | CHANGE_TYPE | REASON_CODE | SOURCE_FILE | CONFLICT_IND | GENERATED_BY | MARKDOWN_NBR | APPROVAL_DATE | CHANGE_AMOUNT | ORIGINAL_ITEM | PURCHASE_TYPE | CHANGE_PERCENT | EFFECTIVE_DATE | LAST_UPDATE_ID | ZONE_NODE_TYPE | CHANGE_CURRENCY | CREATE_DATETIME | ORIGINAL_DIFF_ID | ORIGINAL_ZONE_ID | PRIMARY_SUPPLIER | ROUNDING_RULE_ID | OBJECT_VERSION_ID | ORIGINAL_EVENT_ID | CHANGE_SELLING_UOM | CLEARANCE_GROUP_ID | LAST_UPDATE_SOURCE | EXCEPTION_PARENT_ID | LAST_UPDATE_DATETIME | SYS_GENERATED_EXCLUSION | BATCH_GENERATED_EXCLUSION |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | 1 | S | SAMPLE | 2026-01-01 | 1.0000 | SAMPLE | 1 | 1.0000 | 2026-01-01 | SAMPLE | 1 | SAM | 2026-01-01 | SAMPLE | 1 | 1 | 1 | 1 | 1 | SAMP | 1 | SAMPLE | 1 | 2026-01-01 | 1 | 1 |
| default | 1000000003 | ALT-RPM_CLEARA- | RPM Clearance-002-ALT | 3 | ALT-RPM_CL | 1000000003 | 3 | APP_USER_ID | ALT-RPM_CLEARA-002 | 1 | ALT-RP | RPM Clearance-002-ALT | 3 | S | RPM Cl | 2026-01-03 | 12.5000 | RPM Clearance-002-ALT | 1 | 12.5000 | 2026-01-03 | APP_USER_ID | 1 | RPM | 2026-01-03 | ALT-RPM_CL | 1000000003 | 3 | 1000000003 | 1000000003 | 1000000003 | RPM | 1000000003 | 2026-01-02-ALT | 1000000003 | 2026-01-03 | 3 | 3 |
| default | 1000000005 | EDGE-RPM_CLEARA | RPM Clearance-003-EDGE | 5 | EDGE-RPM_C | 1000000005 | 5 | USERENV | EDGE-RPM_CLEARA-003 | 2 | EDGE-R | RPM Clearance-003-EDGE | 5 | S | RPM Cl | 2026-01-05 | 14.0000 | RPM Clearance-003-EDGE | 0 | 14.0000 | 2026-01-05 | USERENV | 2 | RPM | 2026-01-05 | EDGE-RPM_C | 1000000005 | 5 | 1000000005 | 1000000005 | 1000000005 | RPM | 1000000005 | 2026-01-03-EDGE | 1000000005 | 2026-01-05 | 5 | 5 |
Example values from field definitions
- CLEARANCE_IDRPK
- 1
- CLEARANCE_DISPLAY_IDR
- SAMPLE
- ITEM
- SAMPLE
- STATE
- 1
- DIFF_ID
- SAMPLE
- ZONE_ID
- 1
- LOCATION
- 1
- CREATE_ID
- SAMPLE
- APPROVAL_ID
- SAMPLE
- CHANGE_TYPE
- 1
- REASON_CODE
- SAMPLE
- SOURCE_FILE
- SAMPLE
- CONFLICT_IND
- 1
- 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
- EFFECTIVE_DATE
- 2026-01-01
- LAST_UPDATE_ID
- SAMPLE
- ZONE_NODE_TYPE
- 1
- CHANGE_CURRENCY
- SAM
- CREATE_DATETIME
- 2026-01-01
- 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
- CLEARANCE_GROUP_ID
- 1
- LAST_UPDATE_SOURCE
- SAMPLE
- EXCEPTION_PARENT_ID
- 1
- LAST_UPDATE_DATETIME
- 2026-01-01
- SYS_GENERATED_EXCLUSION
- 1
- BATCH_GENERATED_EXCLUSION
- 1
default
- CLEARANCE_IDRPK
- 1000000003
- CLEARANCE_DISPLAY_IDR
- ALT-RPM_CLEARA-
- ITEM
- RPM Clearance-002-ALT
- STATE
- 3
- DIFF_ID
- ALT-RPM_CL
- ZONE_ID
- 1000000003
- LOCATION
- 3
- CREATE_ID
- APP_USER_ID
- APPROVAL_ID
- ALT-RPM_CLEARA-002
- CHANGE_TYPE
- 1
- REASON_CODE
- ALT-RP
- SOURCE_FILE
- RPM Clearance-002-ALT
- CONFLICT_IND
- 3
- GENERATED_BY
- S
- MARKDOWN_NBR
- RPM Cl
- APPROVAL_DATE
- 2026-01-03
- CHANGE_AMOUNT
- 12.5000
- ORIGINAL_ITEM
- RPM Clearance-002-ALT
- PURCHASE_TYPE
- 1
- CHANGE_PERCENT
- 12.5000
- EFFECTIVE_DATE
- 2026-01-03
- LAST_UPDATE_ID
- APP_USER_ID
- ZONE_NODE_TYPE
- 1
- CHANGE_CURRENCY
- RPM
- CREATE_DATETIME
- 2026-01-03
- ORIGINAL_DIFF_ID
- ALT-RPM_CL
- ORIGINAL_ZONE_ID
- 1000000003
- PRIMARY_SUPPLIER
- 3
- ROUNDING_RULE_ID
- 1000000003
- OBJECT_VERSION_ID
- 1000000003
- ORIGINAL_EVENT_ID
- 1000000003
- CHANGE_SELLING_UOM
- RPM
- CLEARANCE_GROUP_ID
- 1000000003
- LAST_UPDATE_SOURCE
- 2026-01-02-ALT
- EXCEPTION_PARENT_ID
- 1000000003
- LAST_UPDATE_DATETIME
- 2026-01-03
- SYS_GENERATED_EXCLUSION
- 3
- BATCH_GENERATED_EXCLUSION
- 3
default
- CLEARANCE_IDRPK
- 1000000005
- CLEARANCE_DISPLAY_IDR
- EDGE-RPM_CLEARA
- ITEM
- RPM Clearance-003-EDGE
- STATE
- 5
- DIFF_ID
- EDGE-RPM_C
- ZONE_ID
- 1000000005
- LOCATION
- 5
- CREATE_ID
- USERENV
- APPROVAL_ID
- EDGE-RPM_CLEARA-003
- CHANGE_TYPE
- 2
- REASON_CODE
- EDGE-R
- SOURCE_FILE
- RPM Clearance-003-EDGE
- CONFLICT_IND
- 5
- GENERATED_BY
- S
- MARKDOWN_NBR
- RPM Cl
- APPROVAL_DATE
- 2026-01-05
- CHANGE_AMOUNT
- 14.0000
- ORIGINAL_ITEM
- RPM Clearance-003-EDGE
- PURCHASE_TYPE
- 0
- CHANGE_PERCENT
- 14.0000
- EFFECTIVE_DATE
- 2026-01-05
- LAST_UPDATE_ID
- USERENV
- ZONE_NODE_TYPE
- 2
- CHANGE_CURRENCY
- RPM
- CREATE_DATETIME
- 2026-01-05
- ORIGINAL_DIFF_ID
- EDGE-RPM_C
- ORIGINAL_ZONE_ID
- 1000000005
- PRIMARY_SUPPLIER
- 5
- ROUNDING_RULE_ID
- 1000000005
- OBJECT_VERSION_ID
- 1000000005
- ORIGINAL_EVENT_ID
- 1000000005
- CHANGE_SELLING_UOM
- RPM
- CLEARANCE_GROUP_ID
- 1000000005
- LAST_UPDATE_SOURCE
- 2026-01-03-EDGE
- EXCEPTION_PARENT_ID
- 1000000005
- LAST_UPDATE_DATETIME
- 2026-01-05
- SYS_GENERATED_EXCLUSION
- 5
- BATCH_GENERATED_EXCLUSION
- 5
Rule Validation Summary
- Source Rule Count
- 63
- Governed Rule Count
- 54