Sups Minimum Fail
In ScopeTechnical: SUPS_MIN_FAIL | ID: OR-SUP-SUPS_MIN_FAIL-SUPS_MINIMUM_FAIL
Stores a record of orders and locations purged because they did not meet vendor minimums. This table is used for reporting purposes only.
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
- SUPS_MIN_FAIL
Field Definitions(5)
Rules & Considerations(21)
validation
constraint
Sample Load Data(4)
| _scenario | WHR | STORER | ORDER_NOR | SUPPLIERR | ID | DEPT | ITEM | ERROR_MSG | MAX_VALUE | MIN_VALUE | CREATE_DATE | ORDER_VALUE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 1 | 1 | SAMPLE | SAMPLE | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 |
| default | 9003 | 1003 | 4 | 3 | 3 | 1003 | Sups Min Fail-002-ALT | Sups Min Fail-002-ALT | 12.5000 | 12.5000 | 2026-01-03 | 12.5000 |
| default | 9005 | 1005 | 6 | 5 | 5 | 1005 | Sups Min Fail-003-EDGE | Sups Min Fail-003-EDGE | 14.0000 | 14.0000 | 2026-01-05 | 14.0000 |
Example values from field definitions
- WHR
- 1
- STORER
- 1
- ORDER_NOR
- 1
- SUPPLIERR
- 1
- ID
- 1
- DEPT
- 1
- ITEM
- SAMPLE
- ERROR_MSG
- SAMPLE
- MAX_VALUE
- 1.0000
- MIN_VALUE
- 1.0000
- CREATE_DATE
- 2026-01-01
- ORDER_VALUE
- 1.0000
default
- WHR
- 9003
- STORER
- 1003
- ORDER_NOR
- 4
- SUPPLIERR
- 3
- ID
- 3
- DEPT
- 1003
- ITEM
- Sups Min Fail-002-ALT
- ERROR_MSG
- Sups Min Fail-002-ALT
- MAX_VALUE
- 12.5000
- MIN_VALUE
- 12.5000
- CREATE_DATE
- 2026-01-03
- ORDER_VALUE
- 12.5000
default
- WHR
- 9005
- STORER
- 1005
- ORDER_NOR
- 6
- SUPPLIERR
- 5
- ID
- 5
- DEPT
- 1005
- ITEM
- Sups Min Fail-003-EDGE
- ERROR_MSG
- Sups Min Fail-003-EDGE
- MAX_VALUE
- 14.0000
- MIN_VALUE
- 14.0000
- CREATE_DATE
- 2026-01-05
- ORDER_VALUE
- 14.0000
Rule Validation Summary
- Source Rule Count
- 43
- Governed Rule Count
- 21