| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40G: Grower Management |
1 | F40G03 | Grower Harvest | 62 | GH | CNTRTDID | Contract Detail ID | Numeric | Generic Edit | 15 | 0 |
2 | F40G032 | Harvest Estimate Freeze Detail | 24 | FD | CNTRTDID | Contract Detail ID | Numeric | Generic Edit | 15 | 0 |
3 | F40G30S | Assessments / Donations Workfile | 6 | AD | CNTRTDID | Contract Detail ID | Numeric | Generic Edit | 15 | 0 |
4 | F40G95 | Pay On Proceeds Log File | 25 | PP | CNTRTDID | Contract Detail ID | Numeric | Generic Edit | 15 | 0 |
TOP43: Procurement |
5 | F4311 | Purchase Order Detail File | 217 | PD | CNTRTDID | Contract Detail ID | Numeric | Generic Edit | 15 | 0 |
6 | F4311Z | Purchase Order Generator File | 242 | PW | CNTRTDID | Contract Detail ID | Numeric | Generic Edit | 15 | 0 |
7 | F43121 | Purchase Order Receiver File | 148 | PR | CNTRTDID | Contract Detail ID | Numeric | Generic Edit | 15 | 0 |
8 | F43121Z | Receiver workfile | 187 | PW | CNTRTDID | Contract Detail ID | Numeric | Generic Edit | 15 | 0 |
9 | F43199 | P.O. Detail Ledger File - Flexible Version | 219 | OL | CNTRTDID | Contract Detail ID | Numeric | Generic Edit | 15 | 0 |
TOP43C: Contracts |
10 | F43C11 | Contract Detail | 2 | CD | CNTRTDID | Contract Detail ID | Numeric | Generic Edit | 15 | 0 |
11 | F43C20 | Contract Payee | 3 | CP | CNTRTDID | Contract Detail ID | Numeric | Generic Edit | 15 | 0 |
12 | F43C40 | Contract Assessments Donations | 3 | AC | CNTRTDID | Contract Detail ID | Numeric | Generic Edit | 15 | 0 |
13 | F43C60 | Contract Clauses | 3 | CC | CNTRTDID | Contract Detail ID | Numeric | Generic Edit | 15 | 0 |