| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP31B: Blend Management |
| 1 | F31B02 | Staff Master | 8 | ST | EMTY | Employee Type | 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 31B / ET (Employee Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | BBL | Barrel Dept | | N |
| 2 | BTL | Bottlng Dept | | N |
| 3 | CEL | Cellar Dept | | N |
| 4 | LAB | Lab Dept | | N |
| 5 | MTN | Maintenance Dept | | N |
| 6 | WI | Wine Info | | N |
| 7 | WM | Winemaking Dept | | N |
