| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP31B: Blend Management |
1 | F31B03 | Barrel Master Table | 1 | BM | BATP | Barrel Type | String | UDC | 4 | 0 |
2 | F31B031 | Barrel Profile Table | 2 | BP | BATP | Barrel Type | String | UDC | 4 | 0 |
3 | F31B032 | Barrel Types and Capacities | 1 | BT | BATP | Barrel Type | String | UDC | 4 | 0 |
4 | F31B03E | Barrel Inquiry Work File | 7 | BE | BATP | Barrel Type | String | UDC | 4 | 0 |
5 | F31B10 | VBT Header | 4 | VB | BATP | Barrel Type | String | UDC | 4 | 0 |
6 | F31B110 | Mass Barrel Update | 4 | MB | BATP | Barrel Type | String | UDC | 4 | 0 |
7 | F31B13 | Winery Constants | 26 | WC | BATP | Barrel Type | String | UDC | 4 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 31B / BT (Barrel Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | BDX | Bordeaux | | N |
2 | BIN | Bins | 1 | N |
3 | BOR | Bourbon | | N |
4 | BRL | Barrels | 1 | N |
5 | BTT | Bottles | 1 | N |
6 | BUR | French Burgundian | | N |
7 | CHT | French Chateau | | N |
8 | LYR | Layer | 1 | N |
9 | ORE | American Oregon | | N |
10 | PLT | Pallet | 1 | N |
11 | RCK | Rack | 1 | N |
12 | TRN | Transport | | N |