Supplier Tolerance
In ScopeTechnical: SUP_TOLERANCE | ID: OR-SUP-SUP_TOLERANCE-SUPPLIER_TOLERANCE
This table will hold records for each invoice matching supplier tolerance that will be used by the system. Supplier tolerances will be used during the invoice matching process to determine...
See how this object fits into Supplier Management
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
- SUP_TOLERANCE
Field Definitions(5)
Rules & Considerations(21)
constraint
validation
Sample Load Data(4)
| _scenario | SUPPLIERRPK | LOWER_LIMITRPK | UPPER_LIMITRPK | TOLERANCE_FAVORRPK | TOLERANCE_LEVELRPK | TOLERANCE_TYPE | TOLERANCE_VALUE |
|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1.0000 | 1.0000 | S | SA | S | 1.0000 |
| Historical record for closed supplier tolerance | 2 | 1.0000 | 50.0000 | R | TC | P | 3.0000 |
| Current active supplier tolerance with minimal data | 3 | 0.0000 | 1000003.0000 | S | LC | A | 2.5000 |
Example values from field definitions
- SUPPLIERRPK
- 1
- LOWER_LIMITRPK
- 1.0000
- UPPER_LIMITRPK
- 1.0000
- TOLERANCE_FAVORRPK
- S
- TOLERANCE_LEVELRPK
- SA
- TOLERANCE_TYPE
- S
- TOLERANCE_VALUE
- 1.0000
Historical record for closed supplier tolerance
- SUPPLIERRPK
- 2
- LOWER_LIMITRPK
- 1.0000
- UPPER_LIMITRPK
- 50.0000
- TOLERANCE_FAVORRPK
- R
- TOLERANCE_LEVELRPK
- TC
- TOLERANCE_TYPE
- P
- TOLERANCE_VALUE
- 3.0000
Current active supplier tolerance with minimal data
- SUPPLIERRPK
- 3
- LOWER_LIMITRPK
- 0.0000
- UPPER_LIMITRPK
- 1000003.0000
- TOLERANCE_FAVORRPK
- S
- TOLERANCE_LEVELRPK
- LC
- TOLERANCE_TYPE
- A
- TOLERANCE_VALUE
- 2.5000
Rule Validation Summary
- Source Rule Count
- 21
- Governed Rule Count
- 21