Exceptions And Exclusion Of Rounding Rules
In ScopeTechnical: RPM_ROUNDING_RULE_EXC | ID: OR-PRC-RPM_ROUNDING_RULE_EXC-RPM_ROUNDING_RULE_EXC
Stores the exceptions and exclusion of rounding rules.
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_EXC
Field Definitions(5)
Rules & Considerations(22)
constraint
validation
Sample Load Data(4)
| _scenario | RULE_TYPER | ROUNDING_RULE_IDRPK | ROUNDING_RULE_EXC_IDRPK | DEPT | CLASS | CURRENCY | SUBCLASS | CREATE_ID | MERCH_LEVEL | LAST_UPDATE_ID | RETAIL_ENDS_IN | CREATE_DATETIME | OBJECT_VERSION_ID | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 1 | SAM | 1 | SAMPLE | 1 | SAMPLE | SAMP | 2026-01-01 | 1 | 2026-01-01 |
| default | 1 | 1000000003 | 1000000003 | 1003 | 1103 | RPM | 1113 | APP_USER_ID | 1 | APP_USER_ID | RPM | 2026-01-03 | 1000000003 | 2026-01-03 |
| default | 1 | 1000000005 | 1000000005 | 1005 | 1105 | RPM | 1115 | USERENV | 1 | USERENV | RPM | 2026-01-05 | 1000000005 | 2026-01-05 |
Example values from field definitions
- RULE_TYPER
- 1
- ROUNDING_RULE_IDRPK
- 1
- ROUNDING_RULE_EXC_IDRPK
- 1
- DEPT
- 1
- CLASS
- 1
- CURRENCY
- SAM
- SUBCLASS
- 1
- CREATE_ID
- SAMPLE
- MERCH_LEVEL
- 1
- LAST_UPDATE_ID
- SAMPLE
- RETAIL_ENDS_IN
- SAMP
- CREATE_DATETIME
- 2026-01-01
- OBJECT_VERSION_ID
- 1
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- RULE_TYPER
- 1
- ROUNDING_RULE_IDRPK
- 1000000003
- ROUNDING_RULE_EXC_IDRPK
- 1000000003
- DEPT
- 1003
- CLASS
- 1103
- CURRENCY
- RPM
- SUBCLASS
- 1113
- CREATE_ID
- APP_USER_ID
- MERCH_LEVEL
- 1
- LAST_UPDATE_ID
- APP_USER_ID
- RETAIL_ENDS_IN
- RPM
- CREATE_DATETIME
- 2026-01-03
- OBJECT_VERSION_ID
- 1000000003
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- RULE_TYPER
- 1
- ROUNDING_RULE_IDRPK
- 1000000005
- ROUNDING_RULE_EXC_IDRPK
- 1000000005
- DEPT
- 1005
- CLASS
- 1105
- CURRENCY
- RPM
- SUBCLASS
- 1115
- CREATE_ID
- USERENV
- MERCH_LEVEL
- 1
- LAST_UPDATE_ID
- USERENV
- RETAIL_ENDS_IN
- RPM
- CREATE_DATETIME
- 2026-01-05
- OBJECT_VERSION_ID
- 1000000005
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 29
- Governed Rule Count
- 22