| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP31B: Blend Management |
1 | F31B03E | Barrel Inquiry Work File | 60 | BE | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
2 | F31B0790 | Specification Validation | 2 | SV | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
3 | F31B08 | Tank Master | 14 | TM | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
4 | F31B101 | VBT Detail | 1 | VD | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
5 | F31B115 | Trial Blend Lot Details | 4 | BD | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
6 | F31B115W | Trial Blend Input Lot Workfile | 4 | LW | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
7 | F31B31 | Blend Lot Master | 2 | WL | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
8 | F31B311 | Lot Composition | 2 | LC | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
9 | F31B314 | Lot Style | 2 | LS | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
10 | F31B315 | Lot Owners | 1 | LO | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
11 | F31B316 | Lot EUR | 1 | LE | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
12 | F31B317 | Lot Comments | 2 | LC | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
13 | F31B318 | Lot Accumulated Additives | 2 | AC | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
14 | F31B31C | Blend Lot Costs | 2 | BC | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
15 | F31B33W | Related TB Report Workfile | 1 | RW | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
16 | F31B61 | End Wine Lots Workfile | 9 | EL | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
17 | F31B66 | Blend Transactions | 6 | BT | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
18 | F31B85 | Weigh Tag Master | 66 | WT | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
19 | F31B88 | Inventory By Vessel Workfile | 56 | IV | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
TOP37: Quality Management |
20 | F3703 | Non-Conforming Material | 32 | QE | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
21 | F3711 | Test Results | 95 | TR | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
22 | F3711Z1 | Test Results Unedited Transaction Table | 133 | SZ | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
23 | F37900 | Certificate of Analysis (COA) Extract | 104 | TR | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |
TOP40G: Grower Management |
24 | F40G03 | Grower Harvest | 75 | GH | WLOTN | Blend Lot Number | String | Generic Edit | 30 | 0 |