RPM Price Change
In ScopeTechnical: RPM_PRICE_CHANGE | ID: OR-RPCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- RPM_PRICE_CHANGE
Field Definitions(43)
Rules & Considerations(112)
Sample Load Data(4)
| _scenario | STATER | CREATE_IDR | CHANGE_TYPER | CONFLICT_INDR | EFFECTIVE_DATER | LAST_UPDATE_IDR | CREATE_DATETIMER | PRICE_CHANGE_IDRPK | MULTI_UNIT_IMPACTR | IGNORE_CONSTRAINTSR | EXCEPTION_PARENT_IDPK | LAST_UPDATE_DATETIMER | PRICE_CHANGE_GROUP_IDRPK | PRICE_CHANGE_DISPLAY_IDR | SYS_GENERATED_EXCLUSIONR | BATCH_GENERATED_EXCLUSIONR | ITEM | DIFF_ID | ZONE_ID | LOCATION | APPROVAL_ID | MULTI_UNITS | REASON_CODE | SOURCE_FILE | GENERATED_BY | APPROVAL_DATE | CHANGE_AMOUNT | ORIGINAL_ITEM | PURCHASE_TYPE | CHANGE_PERCENT | ZONE_NODE_TYPE | CHANGE_CURRENCY | ORIGINAL_DIFF_ID | ORIGINAL_ZONE_ID | PRIMARY_SUPPLIER | ROUNDING_RULE_ID | MULTI_UNIT_RETAIL | OBJECT_VERSION_ID | ORIGINAL_EVENT_ID | CHANGE_SELLING_UOM | LAST_UPDATE_SOURCE | MULTI_UNIT_SELLING_UOM | MULTI_UNIT_RETAIL_CURRENCY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 01 | RETAIL_C TX | 1 | 1 | 2026-01-01 | RETAIL_C TX | 2026-01-01 | 1000000001 | N | 1 | 1000000001 | 2026-01-01 | 1000000001 | STD-RPM_PRICE-001 | 1 | 1 | RPM Price Change-001 | STD-RPM_PRICE-001 | 1000000001 | 1 | STD-RPM_PRICE-001 | 11.0000 | STD-RPM_PRICE-001 | RPM Price Change-001 | S | 2026-01-01 | 11.0000 | RPM Price Change-001 | 0 | 11.0000 | 000001 | RPM Price Change-001 | STD-RPM_PRICE-001 | 1000000001 | 1 | 1000000001 | 11.0000 | 1000000001 | 1000000001 | RPM Price Change-001 | 2026-01-01 | RPM Price Change-001 | RPM Price Change-001 |
default
- STATER
- 01
- CREATE_IDR
- RETAIL_C TX
- CHANGE_TYPER
- 1
- CONFLICT_INDR
- 1
- EFFECTIVE_DATER
- 2026-01-01
- LAST_UPDATE_IDR
- RETAIL_C TX
- CREATE_DATETIMER
- 2026-01-01
- PRICE_CHANGE_IDRPK
- 1000000001
- MULTI_UNIT_IMPACTR
- N
- IGNORE_CONSTRAINTSR
- 1
- EXCEPTION_PARENT_IDPK
- 1000000001
- LAST_UPDATE_DATETIMER
- 2026-01-01
- PRICE_CHANGE_GROUP_IDRPK
- 1000000001
- PRICE_CHANGE_DISPLAY_IDR
- STD-RPM_PRICE-001
- SYS_GENERATED_EXCLUSIONR
- 1
- BATCH_GENERATED_EXCLUSIONR
- 1
- ITEM
- RPM Price Change-001
- DIFF_ID
- STD-RPM_PRICE-001
- ZONE_ID
- 1000000001
- LOCATION
- 1
- APPROVAL_ID
- STD-RPM_PRICE-001
- MULTI_UNITS
- 11.0000
- REASON_CODE
- STD-RPM_PRICE-001
- SOURCE_FILE
- RPM Price Change-001
- GENERATED_BY
- S
- APPROVAL_DATE
- 2026-01-01
- CHANGE_AMOUNT
- 11.0000
- ORIGINAL_ITEM
- RPM Price Change-001
- PURCHASE_TYPE
- 0
- CHANGE_PERCENT
- 11.0000
- ZONE_NODE_TYPE
- 000001
- CHANGE_CURRENCY
- RPM Price Change-001
- ORIGINAL_DIFF_ID
- STD-RPM_PRICE-001
- ORIGINAL_ZONE_ID
- 1000000001
- PRIMARY_SUPPLIER
- 1
- ROUNDING_RULE_ID
- 1000000001
- MULTI_UNIT_RETAIL
- 11.0000
- OBJECT_VERSION_ID
- 1000000001
- ORIGINAL_EVENT_ID
- 1000000001
- CHANGE_SELLING_UOM
- RPM Price Change-001
- LAST_UPDATE_SOURCE
- 2026-01-01
- MULTI_UNIT_SELLING_UOM
- RPM Price Change-001
- MULTI_UNIT_RETAIL_CURRENCY
- RPM Price Change-001