| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP04: Accounts Payable |
1 | F0411 | Accounts Payable Ledger | 135 | RP | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
2 | F0411A | WF - As Of Accounts Payable Ledger | 135 | RP | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
3 | F0411P | Purge - Accounts Payable Ledger | 135 | RP | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
4 | F0411Z3 | F0411 Interoperability Table | 189 | SZ | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
5 | F0413 | Accounts Payable - Matching Document | 39 | RM | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
6 | F0413A | WF - As Of Accounts Payable Payment Register | 39 | RM | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
7 | F0413P | Purge - Accounts Payable Matching Documents | 39 | RM | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
8 | F0413Z1 | F0413 Interoperability Table | 60 | SY | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
9 | F0414 | Accounts Payable Matching Document Detail | 48 | RN | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
10 | F0414A | WF - As Of Accounts Payable Payment Detail | 49 | RN | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
11 | F0414P | Purge - Accounts Payable Matching Document Detail | 48 | RN | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
12 | F0414Z1 | F0414 Interoperability Table | 68 | SZ | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
13 | F04573 | A/P Payment Processing - Detail | 53 | KI | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
TOP40G: Grower Management |
14 | F31B77BW | Work File for Weigh Tag Summary Report | 4 | WS | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
15 | F40G03 | Grower Harvest | 61 | GH | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
16 | F40G032 | Harvest Estimate Freeze Detail | 23 | FD | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
17 | F40G30S | Assessments / Donations Workfile | 5 | AD | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
18 | F40G95 | Pay On Proceeds Log File | 24 | PP | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
TOP43: Procurement |
19 | F4311 | Purchase Order Detail File | 216 | PD | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
20 | F4311Z | Purchase Order Generator File | 241 | PW | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
21 | F43121 | Purchase Order Receiver File | 147 | PR | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
22 | F43121Z | Receiver workfile | 186 | PW | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
23 | F43199 | P.O. Detail Ledger File - Flexible Version | 218 | OL | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
TOP43C: Contracts |
24 | F43C01 | Contract Header | 1 | CH | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
25 | F43C05 | Contract Action Dates | 1 | CA | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
26 | F43C10 | Contract Block | 1 | CB | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
27 | F43C11 | Contract Detail | 1 | CD | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
28 | F43C20 | Contract Payee | 1 | CP | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
29 | F43C40 | Contract Assessments Donations | 1 | AC | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |
30 | F43C60 | Contract Clauses | 1 | CC | CNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 |