| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP31B: Blend Management |
1 | F31B13 | Winery Constants | 50 | WC | TSTRSNM | Test Result Name | String | Generic Edit | 30 | 0 |
2 | F31B25 | QA History Results Workfile | 4 | TR | TSTRSNM | Test Result Name | String | Generic Edit | 30 | 0 |
3 | F31B62 | Sample Search Work Table | 30 | SS | TSTRSNM | Test Result Name | String | Generic Edit | 30 | 0 |
4 | F31B67 | Quality Assignments | 5 | QA | TSTRSNM | Test Result Name | String | Generic Edit | 30 | 0 |
5 | F31B95 | QA Test Result Blend Override for Operation Configuration | 2 | OV | TSTRSNM | Test Result Name | String | Generic Edit | 30 | 0 |
TOP37: Quality Management |
6 | F3701 | Test Definitions Master File | 63 | QA | TSTRSNM | Test Result Name | String | Generic Edit | 30 | 0 |
7 | F37013 | Test Result Name | 1 | TR | TSTRSNM | Test Result Name | String | Generic Edit | 30 | 0 |
8 | F3711 | Test Results | 100 | TR | TSTRSNM | Test Result Name | String | Generic Edit | 30 | 0 |
9 | F3711Z1 | Test Results Unedited Transaction Table | 138 | SZ | TSTRSNM | Test Result Name | String | Generic Edit | 30 | 0 |
10 | F37900 | Certificate of Analysis (COA) Extract | 102 | TR | TSTRSNM | Test Result Name | String | Generic Edit | 30 | 0 |
TOP40: Inventory/OP Base |
11 | F40UI74 | Price Adjustment History Work File | 81 | AW | TSTRSNM | Test Result Name | String | Generic Edit | 30 | 0 |
TOP40G: Grower Management |
12 | F40G151 | Quality Result Limits | 3 | QL | TSTRSNM | Test Result Name | String | Generic Edit | 30 | 0 |
TOP42: Sales Management |
13 | F4074 | Price Adjustment Ledger File | 70 | AL | TSTRSNM | Test Result Name | String | Generic Edit | 30 | 0 |
TOP45: Advanced Pricing |
14 | F4071 | Price Adjustment Type | 61 | AT | TSTRSNM | Test Result Name | String | Generic Edit | 30 | 0 |
15 | F4071P | Price Adjustment Type Purge | 62 | AT | TSTRSNM | Test Result Name | String | Generic Edit | 30 | 0 |