| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP31B: Blend Management |
| 1 | F31B62 | Sample Search Work Table | 43 | SS | QTC2 | Test Category Code 2 | String | UDC | 3 | 0 |
| TOP37: Quality Management |
| 2 | F3701 | Test Definitions Master File | 28 | QA | QTC2 | Test Category Code 2 | String | UDC | 3 | 0 |
| 3 | F3711 | Test Results | 49 | TR | QTC2 | Test Category Code 2 | String | UDC | 3 | 0 |
| 4 | F3711Z1 | Test Results Unedited Transaction Table | 62 | SZ | QTC2 | Test Category Code 2 | String | UDC | 3 | 0 |
| 5 | F37900 | Certificate of Analysis (COA) Extract | 49 | TR | QTC2 | Test Category Code 2 | 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 / T2 (Test Code 2) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | N |
| 2 | 201 | Staging | | N |
| 3 | 202 | Shop Floor | | N |
| 4 | 203 | Production Inspection | | N |
| 5 | 204 | Receiving Inspection | | N |
| 6 | 205 | Packaging | | N |
| 7 | 206 | Shipping | | N |
