Supplier Available
In ScopeTechnical: SUP_AVAIL | ID: OR-PUR-SUP_AVAIL-SUPPLIER_AVAILABLE
This table is used by the Contract Module. It is populated only for contract types A and D.
See how this object fits into Purchasing
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_AVAIL
Field Definitions(5)
Rules & Considerations(12)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMRPK | SUPPLIERRPK | QTY_AVAILR | LAST_UPDATE_DATER | REF_ITEM | LAST_DECLARED_DATE |
|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1.0000 | 2026-01-01 | SAMPLE | 2026-01-01 |
| default | Sup Avail-002-ALT | 3 | 12.5000 | 2026-01-03 | Sup Avail-002-ALT | 2026-01-03 |
| default | Sup Avail-003-EDGE | 5 | 14.0000 | 2026-01-05 | Sup Avail-003-EDGE | 2026-01-05 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- SUPPLIERRPK
- 1
- QTY_AVAILR
- 1.0000
- LAST_UPDATE_DATER
- 2026-01-01
- REF_ITEM
- SAMPLE
- LAST_DECLARED_DATE
- 2026-01-01
default
- ITEMRPK
- Sup Avail-002-ALT
- SUPPLIERRPK
- 3
- QTY_AVAILR
- 12.5000
- LAST_UPDATE_DATER
- 2026-01-03
- REF_ITEM
- Sup Avail-002-ALT
- LAST_DECLARED_DATE
- 2026-01-03
default
- ITEMRPK
- Sup Avail-003-EDGE
- SUPPLIERRPK
- 5
- QTY_AVAILR
- 14.0000
- LAST_UPDATE_DATER
- 2026-01-05
- REF_ITEM
- Sup Avail-003-EDGE
- LAST_DECLARED_DATE
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 18
- Governed Rule Count
- 12