| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP04: Accounts Payable |
1 | F0411 | Accounts Payable Ledger | 137 | RP | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
2 | F0411A | WF - As Of - Accounts Payable Ledger | 137 | RP | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
3 | F0411P | Purge - Accounts Payable Ledger | 137 | RP | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
4 | F0411Z3 | F0411 Interoperability Table | 191 | SZ | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
5 | F0413 | Accounts Payable - Matching Document | 41 | RM | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
6 | F0413A | WF - As Of - Accounts Payable Payment Register | 41 | RM | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
7 | F0413P | Purge - Accounts Payable Matching Documents | 41 | RM | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
8 | F0413Z1 | F0413 Interoperability Table | 62 | SY | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
9 | F0414 | Accounts Payable Matching Document Detail | 50 | RN | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
10 | F0414A | WF - As Of - Accounts Payable Payment Detail | 51 | RN | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
11 | F0414P | Purge - Accounts Payable Matching Document Detail | 50 | RN | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
12 | F0414Z1 | F0414 Interoperability Table | 70 | SZ | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
13 | F04573 | A/P Payment Processing - Detail File | 54 | KI | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
TOP31B: Blend Management |
14 | F31B03 | Barrel Master Table | 116 | BM | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
15 | F31B03E | Barrel Inquiry Work File | 19 | BE | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
16 | F31B0800 | F31B0800 Recalculation Error Handling | 2 | RE | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
17 | F31B100 | Bill Of Lading Composition Details | 1 | BC | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
18 | F31B101 | VBT Detail | 5 | VD | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
19 | F31B103 | Unknown Vessel Master | 1 | UV | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
20 | F31B115 | Trial Blend Lot Details | 6 | BD | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
21 | F31B115W | Trial Blend Input Lot Workfile | 6 | LW | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
22 | F31B130 | Container Master Table | 1 | CM | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
23 | F31B33 | Operation Dependency | 1 | OD | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
24 | F31B33DC | Dependency Chain Cache Structure | 4 | DT | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
25 | F31B33W | Related TB Report Workfile | 4 | RW | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
26 | F31B61 | End Wine Lots Workfile | 2 | EL | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
27 | F31B68 | Reversed Operations | 2 | RO | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
28 | F31B70 | Operation Vessel Assignments | 5 | VA | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
29 | F31B85 | Weigh Tag Master | 1 | WT | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
30 | F31B85T | Weigh Tag Master Tag Table | 1 | WT | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
31 | F31B86 | Inventory By Vessel WorkFile | 3 | IV | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
32 | F31B88 | Inventory By Vessel Workfile | 3 | IV | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
33 | F31B91 | Bill Of Lading Master | 1 | BL | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
34 | F31B96 | Bill Of Lading Details | 1 | BD | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
35 | F31B98 | Bottling Master | 1 | BM | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
36 | F31B99 | Decant Detail | 2 | DD | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
TOP37: Quality Management |
37 | F3703 | Non-Conforming Material | 33 | QE | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
38 | F3711 | Test Results | 98 | TR | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
39 | F3711Z1 | Test Results Unedited Transaction Table | 136 | SZ | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
40 | F37900 | Certificate of Analysis (COA) Extract | 107 | TR | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
TOP40G: Grower Management |
41 | F40G03 | Grower Harvest | 1 | GH | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
42 | F40G031 | Harvest Estimate Freeze Hdr | 3 | FH | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
43 | F40G032 | Harvest Estimate Freeze Detail | 3 | FD | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
44 | F40G033 | Continous Harvest Estimates | 1 | CH | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
45 | F40G150 | Crush and Purchase Report Details | 1 | CP | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
46 | F40G70 | Harvest Operation Withholding Date | 2 | WH | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
47 | F40G80 | Farming Operation Configuration Values Entry | 2 | CV | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
TOP43: Procurement |
48 | F4311 | Purchase Order Detail File | 215 | PD | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
49 | F4311Z | Purchase Order Generator File | 240 | PW | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
50 | F43121 | Purchase Order Receiver File | 146 | PR | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
51 | F43121Z | Receiver workfile | 185 | PW | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
52 | F43199 | P.O. Detail Ledger File - Flexible Version | 217 | OL | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |
TOP43C: Contracts |
53 | F43C11 | Contract Detail | 31 | CD | WVID | Vessel ID | Numeric | Generic Edit | 8 | 0 |