| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40G: Grower Management |
1 | F40G150 | Crush and Purchase Report Details | 42 | CP | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
TOP41: Inventory Management |
2 | F4101 | Item Master | 45 | IM | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
3 | F4101A | Item File | 26 | IM | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
4 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 60 | SZ | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
TOP43: Procurement |
5 | F43080 | Approvals Fields Constants | 114 | PD | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
6 | F4311 | Purchase Order Detail File | 110 | PD | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
7 | F4311Z | Purchase Order Generator File | 114 | PW | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
8 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 123 | SZ | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
9 | F43121 | Purchase Order Receiver File | 77 | PR | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
10 | F43121Z | Receiver workfile | 50 | PW | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
11 | F43121Z1 | Receipts Unedited Transaction Table | 94 | SZ | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
12 | F4314Z | Voucher Match Selection File | 177 | PN | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
13 | F43199 | P.O. Detail Ledger File - Flexible Version | 110 | OL | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
14 | F4343 | Purchase Rebate History | 17 | RH | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
15 | F4371 | Suggested Reorder Stock Items | 17 | PD | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
16 | F43UI50D | PO Print Detail Work File | 13 | PW | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
TOP43C: Contracts |
17 | F43C10 | Contract Block | 19 | CB | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
18 | F43C11 | Contract Detail | 20 | CD | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
TOP44H: Homebuilder Management |
19 | F44H603 | Material Item Pricing | 7 | MP | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
TOP47: Electronic Commerce |
20 | F47017 | EDI Purchase Order Detail - Outbound | 124 | SZ | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
21 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 124 | SZ | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
22 | F47032 | EDI Shipping Notice Detail - Inbound | 92 | SZ | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
23 | F47072 | EDI Receiving Advice Detail - Inbound | 125 | SZ | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
24 | F47077 | EDI Receiving Advice Detail - Outbound | 125 | SZ | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
25 | F47097 | EDI Request for Quote Detail - Outbound | 124 | SZ | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
26 | F47102 | EDI Response to RFQ Detail - Inbound | 124 | SZ | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
27 | F47137 | EDI Purchase Order Change Detail - Outbound | 125 | SZ | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
28 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 126 | SZ | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
29 | F47157 | EDI Shipping Schedule Detail - Outbound | 133 | SZ | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
TOP76B: Brazil - Reporting System Only |
30 | F7611B | Nota Fiscal Detail - Brazil | 35 | FD | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
31 | F761BA | AS Fiscal file book | 39 | FB | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
TOP89: Conversion Programs |
32 | F43199A | Temp F43199 for ERP 9.0 Upgrade | 110 | OL | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |
TOPF30L: DFM Line Design |
33 | FF30L501 | DFM Item Definition Master | 95 | IB | UOM3 | Unit of Measure - Purchasing | String | UDC | 2 | 0 |