| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP31B: Blend Management |
| 1 | F31B62 | Sample Search Work Table | 42 | SS | QTC1 | Test Category Code 1 | String | UDC | 3 | 0 |
| TOP37: Quality Management |
| 2 | F3701 | Test Definitions Master File | 27 | QA | QTC1 | Test Category Code 1 | String | UDC | 3 | 0 |
| 3 | F3711 | Test Results | 48 | TR | QTC1 | Test Category Code 1 | String | UDC | 3 | 0 |
| 4 | F3711Z1 | Test Results Unedited Transaction Table | 61 | SZ | QTC1 | Test Category Code 1 | String | UDC | 3 | 0 |
| 5 | F37900 | Certificate of Analysis (COA) Extract | 48 | TR | QTC1 | Test Category Code 1 | 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 / T1 (Test Code 1) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | N |
| 2 | 101 | Pre-Production | | N |
| 3 | 102 | During Production | | N |
| 4 | 103 | Completion/Receipt | | N |
| 5 | 104 | Packaging | | N |
| 6 | 105 | Shipping | | N |
