RPM Clearance
In ScopeTechnical: RPM_CLEARANCE | ID: OR-RPCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- RPM_CLEARANCE
Field Definitions(38)
Rules & Considerations(102)
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_IDPK | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 01 | RETAIL_C TX | 0 | 1000000001 | 1 | 2026-01-01 | RETAIL_C TX | 0 | 2026-01-01 | 1000000001 | 1000000001 | STD-RPM_CLEARA-001 | 2026-01-01 | 1 | 1 | RPM Clearance-001 | STD-RPM_CLEARA-001 | 1000000001 | 1 | STD-RPM_CLEARA-001 | STD-RPM_CLEARA-001 | RPM Clearance-001 | S | RPM Clearance-001 | 2026-01-01 | 11.0000 | RPM Clearance-001 | 0 | 11.0000 | RPM Clearance-001 | STD-RPM_CLEARA-001 | 1000000001 | 1 | 1000000001 | 1000000001 | 1000000001 | RPM Clearance-001 | 2026-01-01 |
default
- STATER
- 01
- CREATE_IDR
- RETAIL_C TX
- CHANGE_TYPER
- 0
- CLEARANCE_IDRPK
- 1000000001
- CONFLICT_INDR
- 1
- EFFECTIVE_DATER
- 2026-01-01
- LAST_UPDATE_IDR
- RETAIL_C TX
- ZONE_NODE_TYPER
- 0
- CREATE_DATETIMER
- 2026-01-01
- CLEARANCE_GROUP_IDRPK
- 1000000001
- EXCEPTION_PARENT_IDPK
- 1000000001
- CLEARANCE_DISPLAY_IDR
- STD-RPM_CLEARA-001
- LAST_UPDATE_DATETIMER
- 2026-01-01
- SYS_GENERATED_EXCLUSIONR
- 1
- BATCH_GENERATED_EXCLUSIONR
- 1
- ITEM
- RPM Clearance-001
- DIFF_ID
- STD-RPM_CLEARA-001
- ZONE_ID
- 1000000001
- LOCATION
- 1
- APPROVAL_ID
- STD-RPM_CLEARA-001
- REASON_CODE
- STD-RPM_CLEARA-001
- SOURCE_FILE
- RPM Clearance-001
- GENERATED_BY
- S
- MARKDOWN_NBR
- RPM Clearance-001
- APPROVAL_DATE
- 2026-01-01
- CHANGE_AMOUNT
- 11.0000
- ORIGINAL_ITEM
- RPM Clearance-001
- PURCHASE_TYPE
- 0
- CHANGE_PERCENT
- 11.0000
- CHANGE_CURRENCY
- RPM Clearance-001
- ORIGINAL_DIFF_ID
- STD-RPM_CLEARA-001
- ORIGINAL_ZONE_ID
- 1000000001
- PRIMARY_SUPPLIER
- 1
- ROUNDING_RULE_ID
- 1000000001
- OBJECT_VERSION_ID
- 1000000001
- ORIGINAL_EVENT_ID
- 1000000001
- CHANGE_SELLING_UOM
- RPM Clearance-001
- LAST_UPDATE_SOURCE
- 2026-01-01