| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP31B: Blend Management |
1 | F31B62 | Sample Search Work Table | 45 | SS | QTC4 | Test Category Code 4 | String | UDC | 3 | 0 |
TOP37: Quality Management |
2 | F3701 | Test Definitions Master File | 30 | QA | QTC4 | Test Category Code 4 | String | UDC | 3 | 0 |
3 | F3711 | Test Results | 51 | TR | QTC4 | Test Category Code 4 | String | UDC | 3 | 0 |
4 | F3711Z1 | Test Results Unedited Transaction Table | 64 | SZ | QTC4 | Test Category Code 4 | String | UDC | 3 | 0 |
5 | F37900 | Certificate of Analysis (COA) Extract | 51 | TR | QTC4 | Test Category Code 4 | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 37 / T4 (Test Code 4) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | . | | N |
2 | 401 | Mechanical | | N |
3 | 402 | Electrical | | N |
4 | 403 | Chemical | | N |
5 | 404 | Visual | | N |