RPM Price Change
In ScopeTechnical: RPM_PRICE_CHANGE | ID: OR-PRC-RPM_PRICE_CHANGE-RPM_PRICE_CHANGE
Table to hold price changes. Price changes consist of items (transaction or parent level), locations (single locations or zone) retail changes, multi unit changes, and vendor funding 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_PRICE_CHANGE
Field Definitions(5)
Rules & Considerations(60)
constraint
validation
Sample Load Data(4)
| _scenario | PRICE_CHANGE_IDRPK | PRICE_CHANGE_DISPLAY_IDR | ITEM | STATE | DIFF_ID | ZONE_ID | LOCATION | CREATE_ID | APPROVAL_ID | CHANGE_TYPE | MULTI_UNITS | REASON_CODE | SOURCE_FILE | CONFLICT_IND | GENERATED_BY | 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 | MULTI_UNIT_IMPACT | MULTI_UNIT_RETAIL | OBJECT_VERSION_ID | ORIGINAL_EVENT_ID | CHANGE_SELLING_UOM | IGNORE_CONSTRAINTS | LAST_UPDATE_SOURCE | EXCEPTION_PARENT_ID | LAST_UPDATE_DATETIME | PRICE_CHANGE_GROUP_ID | MULTI_UNIT_SELLING_UOM | SYS_GENERATED_EXCLUSION | BATCH_GENERATED_EXCLUSION | MULTI_UNIT_RETAIL_CURRENCY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | 1 | 1.0000 | SAMPLE | SAMPLE | 1 | S | 2026-01-01 | 1.0000 | SAMPLE | 1 | 1.0000 | 2026-01-01 | SAMPLE | 1 | SAM | 2026-01-01 | SAMPLE | 1 | 1 | 1 | SA | 1.0000 | 1 | 1 | SAMP | 1 | SAMPLE | 1 | 2026-01-01 | 1 | SAMP | 1 | 1 | SAM |
| default | 1000000003 | ALT-RPM_PRICE-0 | RPM Price Change-002-ALT | 3 | ALT-RPM_PR | 1000000003 | 3 | APP_USER_ID | ALT-RPM_PRICE-002 | 3 | 12.5000 | ALT-RP | RPM Price Change-002-ALT | 3 | S | 2026-01-03 | 12.5000 | RPM Price Change-002-ALT | 1 | 12.5000 | 2026-01-03 | APP_USER_ID | 3 | RPM | 2026-01-03 | ALT-RPM_PR | 1000000003 | 3 | 1000000003 | AU | 12.5000 | 1000000003 | 1000000003 | RPM | 3 | 2026-01-02-ALT | 1000000003 | 2026-01-03 | 1000000003 | RPM | 3 | 3 | RPM |
| default | 1000000005 | EDGE-RPM_PRICE- | RPM Price Change-003-EDGE | 5 | EDGE-RPM_P | 1000000005 | 5 | USERENV | EDGE-RPM_PRICE-003 | 5 | 14.0000 | EDGE-R | RPM Price Change-003-EDGE | 5 | S | 2026-01-05 | 14.0000 | RPM Price Change-003-EDGE | 0 | 14.0000 | 2026-01-05 | USERENV | 5 | RPM | 2026-01-05 | EDGE-RPM_P | 1000000005 | 5 | 1000000005 | R | 14.0000 | 1000000005 | 1000000005 | RPM | 5 | 2026-01-03-EDGE | 1000000005 | 2026-01-05 | 1000000005 | RPM | 5 | 5 | RPM |
Example values from field definitions
- PRICE_CHANGE_IDRPK
- 1
- PRICE_CHANGE_DISPLAY_IDR
- SAMPLE
- ITEM
- SAMPLE
- STATE
- 1
- DIFF_ID
- SAMPLE
- ZONE_ID
- 1
- LOCATION
- 1
- CREATE_ID
- SAMPLE
- APPROVAL_ID
- SAMPLE
- CHANGE_TYPE
- 1
- MULTI_UNITS
- 1.0000
- REASON_CODE
- SAMPLE
- SOURCE_FILE
- SAMPLE
- CONFLICT_IND
- 1
- GENERATED_BY
- S
- 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
- MULTI_UNIT_IMPACT
- SA
- MULTI_UNIT_RETAIL
- 1.0000
- OBJECT_VERSION_ID
- 1
- ORIGINAL_EVENT_ID
- 1
- CHANGE_SELLING_UOM
- SAMP
- IGNORE_CONSTRAINTS
- 1
- LAST_UPDATE_SOURCE
- SAMPLE
- EXCEPTION_PARENT_ID
- 1
- LAST_UPDATE_DATETIME
- 2026-01-01
- PRICE_CHANGE_GROUP_ID
- 1
- MULTI_UNIT_SELLING_UOM
- SAMP
- SYS_GENERATED_EXCLUSION
- 1
- BATCH_GENERATED_EXCLUSION
- 1
- MULTI_UNIT_RETAIL_CURRENCY
- SAM
default
- PRICE_CHANGE_IDRPK
- 1000000003
- PRICE_CHANGE_DISPLAY_IDR
- ALT-RPM_PRICE-0
- ITEM
- RPM Price Change-002-ALT
- STATE
- 3
- DIFF_ID
- ALT-RPM_PR
- ZONE_ID
- 1000000003
- LOCATION
- 3
- CREATE_ID
- APP_USER_ID
- APPROVAL_ID
- ALT-RPM_PRICE-002
- CHANGE_TYPE
- 3
- MULTI_UNITS
- 12.5000
- REASON_CODE
- ALT-RP
- SOURCE_FILE
- RPM Price Change-002-ALT
- CONFLICT_IND
- 3
- GENERATED_BY
- S
- APPROVAL_DATE
- 2026-01-03
- CHANGE_AMOUNT
- 12.5000
- ORIGINAL_ITEM
- RPM Price Change-002-ALT
- PURCHASE_TYPE
- 1
- CHANGE_PERCENT
- 12.5000
- EFFECTIVE_DATE
- 2026-01-03
- LAST_UPDATE_ID
- APP_USER_ID
- ZONE_NODE_TYPE
- 3
- CHANGE_CURRENCY
- RPM
- CREATE_DATETIME
- 2026-01-03
- ORIGINAL_DIFF_ID
- ALT-RPM_PR
- ORIGINAL_ZONE_ID
- 1000000003
- PRIMARY_SUPPLIER
- 3
- ROUNDING_RULE_ID
- 1000000003
- MULTI_UNIT_IMPACT
- AU
- MULTI_UNIT_RETAIL
- 12.5000
- OBJECT_VERSION_ID
- 1000000003
- ORIGINAL_EVENT_ID
- 1000000003
- CHANGE_SELLING_UOM
- RPM
- IGNORE_CONSTRAINTS
- 3
- LAST_UPDATE_SOURCE
- 2026-01-02-ALT
- EXCEPTION_PARENT_ID
- 1000000003
- LAST_UPDATE_DATETIME
- 2026-01-03
- PRICE_CHANGE_GROUP_ID
- 1000000003
- MULTI_UNIT_SELLING_UOM
- RPM
- SYS_GENERATED_EXCLUSION
- 3
- BATCH_GENERATED_EXCLUSION
- 3
- MULTI_UNIT_RETAIL_CURRENCY
- RPM
default
- PRICE_CHANGE_IDRPK
- 1000000005
- PRICE_CHANGE_DISPLAY_IDR
- EDGE-RPM_PRICE-
- ITEM
- RPM Price Change-003-EDGE
- STATE
- 5
- DIFF_ID
- EDGE-RPM_P
- ZONE_ID
- 1000000005
- LOCATION
- 5
- CREATE_ID
- USERENV
- APPROVAL_ID
- EDGE-RPM_PRICE-003
- CHANGE_TYPE
- 5
- MULTI_UNITS
- 14.0000
- REASON_CODE
- EDGE-R
- SOURCE_FILE
- RPM Price Change-003-EDGE
- CONFLICT_IND
- 5
- GENERATED_BY
- S
- APPROVAL_DATE
- 2026-01-05
- CHANGE_AMOUNT
- 14.0000
- ORIGINAL_ITEM
- RPM Price Change-003-EDGE
- PURCHASE_TYPE
- 0
- CHANGE_PERCENT
- 14.0000
- EFFECTIVE_DATE
- 2026-01-05
- LAST_UPDATE_ID
- USERENV
- ZONE_NODE_TYPE
- 5
- CHANGE_CURRENCY
- RPM
- CREATE_DATETIME
- 2026-01-05
- ORIGINAL_DIFF_ID
- EDGE-RPM_P
- ORIGINAL_ZONE_ID
- 1000000005
- PRIMARY_SUPPLIER
- 5
- ROUNDING_RULE_ID
- 1000000005
- MULTI_UNIT_IMPACT
- R
- MULTI_UNIT_RETAIL
- 14.0000
- OBJECT_VERSION_ID
- 1000000005
- ORIGINAL_EVENT_ID
- 1000000005
- CHANGE_SELLING_UOM
- RPM
- IGNORE_CONSTRAINTS
- 5
- LAST_UPDATE_SOURCE
- 2026-01-03-EDGE
- EXCEPTION_PARENT_ID
- 1000000005
- LAST_UPDATE_DATETIME
- 2026-01-05
- PRICE_CHANGE_GROUP_ID
- 1000000005
- MULTI_UNIT_SELLING_UOM
- RPM
- SYS_GENERATED_EXCLUSION
- 5
- BATCH_GENERATED_EXCLUSION
- 5
- MULTI_UNIT_RETAIL_CURRENCY
- RPM
Rule Validation Summary
- Source Rule Count
- 68
- Governed Rule Count
- 60