Detail Level Information For Matching Tolerances
In ScopeTechnical: IM_TOLERANCE_DETAIL | ID: OR-IM-IM_TOLERANCE_DETAIL-IM_TOLERANCE_DETAIL
Stores the detail level information for matching tolerances.
See how this object fits into Invoice Matching
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
- IM_TOLERANCE_DETAIL
Field Definitions(5)
Rules & Considerations(31)
constraint
validation
Sample Load Data(4)
| _scenario | FAVOR_OFR | MATCH_TYPER | MATCH_LEVELR | TOLERANCE_IDR | TOLERANCE_DETAIL_IDRPK | CREATED_BY | LOWER_LIMIT | UPPER_LIMIT | CREATION_DATE | AUTO_RES_VALUE | REASON_CODE_ID | LAST_UPDATED_BY | TOLERANCE_VALUE | LAST_UPDATE_DATE | OBJECT_VERSION_ID | TOLERANCE_VALUE_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | S | S | S | 1 | 1 | SAMPLE | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 | SAMPLE | SAMPLE | 1.0000 | 2026-01-01 | 1 | S |
| default | R | Q | A | 1000000003 | 1000000003 | APP_USER_ID | 12.5000 | 12.5000 | 2026-01-03 | 12.5000 | ALT-IM_TOLERAN-002 | APP_USER_ID | 12.5000 | 2026-01-03 | 1000000003 | A |
| default | S | C | S | 1000000005 | 1000000005 | USERENV | 14.0000 | 14.0000 | 2026-01-05 | 14.0000 | EDGE-IM_TOLERAN-003 | USERENV | 14.0000 | 2026-01-05 | 1000000005 | P |
Example values from field definitions
- FAVOR_OFR
- S
- MATCH_TYPER
- S
- MATCH_LEVELR
- S
- TOLERANCE_IDR
- 1
- TOLERANCE_DETAIL_IDRPK
- 1
- CREATED_BY
- SAMPLE
- LOWER_LIMIT
- 1.0000
- UPPER_LIMIT
- 1.0000
- CREATION_DATE
- 2026-01-01
- AUTO_RES_VALUE
- 1.0000
- REASON_CODE_ID
- SAMPLE
- LAST_UPDATED_BY
- SAMPLE
- TOLERANCE_VALUE
- 1.0000
- LAST_UPDATE_DATE
- 2026-01-01
- OBJECT_VERSION_ID
- 1
- TOLERANCE_VALUE_TYPE
- S
default
- FAVOR_OFR
- R
- MATCH_TYPER
- Q
- MATCH_LEVELR
- A
- TOLERANCE_IDR
- 1000000003
- TOLERANCE_DETAIL_IDRPK
- 1000000003
- CREATED_BY
- APP_USER_ID
- LOWER_LIMIT
- 12.5000
- UPPER_LIMIT
- 12.5000
- CREATION_DATE
- 2026-01-03
- AUTO_RES_VALUE
- 12.5000
- REASON_CODE_ID
- ALT-IM_TOLERAN-002
- LAST_UPDATED_BY
- APP_USER_ID
- TOLERANCE_VALUE
- 12.5000
- LAST_UPDATE_DATE
- 2026-01-03
- OBJECT_VERSION_ID
- 1000000003
- TOLERANCE_VALUE_TYPE
- A
default
- FAVOR_OFR
- S
- MATCH_TYPER
- C
- MATCH_LEVELR
- S
- TOLERANCE_IDR
- 1000000005
- TOLERANCE_DETAIL_IDRPK
- 1000000005
- CREATED_BY
- USERENV
- LOWER_LIMIT
- 14.0000
- UPPER_LIMIT
- 14.0000
- CREATION_DATE
- 2026-01-05
- AUTO_RES_VALUE
- 14.0000
- REASON_CODE_ID
- EDGE-IM_TOLERAN-003
- LAST_UPDATED_BY
- USERENV
- TOLERANCE_VALUE
- 14.0000
- LAST_UPDATE_DATE
- 2026-01-05
- OBJECT_VERSION_ID
- 1000000005
- TOLERANCE_VALUE_TYPE
- P
Rule Validation Summary
- Source Rule Count
- 51
- Governed Rule Count
- 31