RPM Rounding Rule
In ScopeTechnical: RPM_ROUNDING_RULE | ID: OR-PRC-RPM_ROUNDING_RULE-RPM_ROUNDING_RULE
Stores the rounding rules used to aid the retailer in providing consistent pricing points.
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_ROUNDING_RULE
Field Definitions(5)
Rules & Considerations(34)
validation
constraint
Sample Load Data(4)
| _scenario | NAMER | DESCRIPTIONR | EFFECTIVE_DATER | ROUNDING_RULE_IDRPK | STATUS | CREATE_ID | APPLIES_TO_CR | APPLIES_TO_PC | APPLIES_TO_PR | DEFAULTS_TO_CR | DEFAULTS_TO_PC | DEFAULTS_TO_PR | LAST_UPDATE_ID | RETAIL_ENDS_IN | CREATE_DATETIME | EXCEPTION_LEVEL | LONG_DESCRIPTION | OBJECT_VERSION_ID | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | 2026-01-01 | 1 | 1 | SAMPLE | 1 | 1 | 1 | 1 | 1 | 1 | SAMPLE | SAMP | 2026-01-01 | 1 | SAMPLE | 1 | 2026-01-01 |
| default | RPM Rounding Rule-002-ALT | RPM Rounding Rule-002-ALT | 2026-01-03 | 1000000003 | 3 | APP_USER_ID | 3 | 3 | 3 | 3 | 3 | 3 | APP_USER_ID | RPM | 2026-01-03 | 1 | RPM Rounding Rule: Alternate source profile | 1000000003 | 2026-01-03 |
| default | RPM Rounding Rule-003-EDGE | RPM Rounding Rule-003-EDGE | 2026-01-05 | 1000000005 | 5 | USERENV | 5 | 5 | 5 | 5 | 5 | 5 | USERENV | RPM | 2026-01-05 | 1 | — | 1000000005 | 2026-01-05 |
Example values from field definitions
- NAMER
- SAMPLE
- DESCRIPTIONR
- SAMPLE
- EFFECTIVE_DATER
- 2026-01-01
- ROUNDING_RULE_IDRPK
- 1
- STATUS
- 1
- CREATE_ID
- SAMPLE
- APPLIES_TO_CR
- 1
- APPLIES_TO_PC
- 1
- APPLIES_TO_PR
- 1
- DEFAULTS_TO_CR
- 1
- DEFAULTS_TO_PC
- 1
- DEFAULTS_TO_PR
- 1
- LAST_UPDATE_ID
- SAMPLE
- RETAIL_ENDS_IN
- SAMP
- CREATE_DATETIME
- 2026-01-01
- EXCEPTION_LEVEL
- 1
- LONG_DESCRIPTION
- SAMPLE
- OBJECT_VERSION_ID
- 1
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- NAMER
- RPM Rounding Rule-002-ALT
- DESCRIPTIONR
- RPM Rounding Rule-002-ALT
- EFFECTIVE_DATER
- 2026-01-03
- ROUNDING_RULE_IDRPK
- 1000000003
- STATUS
- 3
- CREATE_ID
- APP_USER_ID
- APPLIES_TO_CR
- 3
- APPLIES_TO_PC
- 3
- APPLIES_TO_PR
- 3
- DEFAULTS_TO_CR
- 3
- DEFAULTS_TO_PC
- 3
- DEFAULTS_TO_PR
- 3
- LAST_UPDATE_ID
- APP_USER_ID
- RETAIL_ENDS_IN
- RPM
- CREATE_DATETIME
- 2026-01-03
- EXCEPTION_LEVEL
- 1
- LONG_DESCRIPTION
- RPM Rounding Rule: Alternate source profile
- OBJECT_VERSION_ID
- 1000000003
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- NAMER
- RPM Rounding Rule-003-EDGE
- DESCRIPTIONR
- RPM Rounding Rule-003-EDGE
- EFFECTIVE_DATER
- 2026-01-05
- ROUNDING_RULE_IDRPK
- 1000000005
- STATUS
- 5
- CREATE_ID
- USERENV
- APPLIES_TO_CR
- 5
- APPLIES_TO_PC
- 5
- APPLIES_TO_PR
- 5
- DEFAULTS_TO_CR
- 5
- DEFAULTS_TO_PC
- 5
- DEFAULTS_TO_PR
- 5
- LAST_UPDATE_ID
- USERENV
- RETAIL_ENDS_IN
- RPM
- CREATE_DATETIME
- 2026-01-05
- EXCEPTION_LEVEL
- 1
- LONG_DESCRIPTION
- —
- OBJECT_VERSION_ID
- 1000000005
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 40
- Governed Rule Count
- 34