| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F40205 | Line Type Control Constants File | 5 | LF | IVI | Inventory Interface Y/N - Distribution | Character | UDC | 1 | 0 |
TOP42: Sales Management |
2 | F42565 | Invoice Print File | 35 | IW | IVI | Inventory Interface Y/N - Distribution | Character | UDC | 1 | 0 |
3 | F42UI11 | SO Detail Cache File (MBF) | 123 | ZD | IVI | Inventory Interface Y/N - Distribution | Character | UDC | 1 | 0 |
4 | F42UI521 | Pick Slips Detail File | 41 | S9 | IVI | Inventory Interface Y/N - Distribution | Character | UDC | 1 | 0 |
TOP43: Procurement |
5 | F4311Z | Purchase Order Generator File | 190 | PW | IVI | Inventory Interface Y/N - Distribution | Character | UDC | 1 | 0 |
6 | F43121Z | Receiver workfile | 28 | PW | IVI | Inventory Interface Y/N - Distribution | Character | UDC | 1 | 0 |
7 | F43147 | Freight Distribution Workfile | 16 | FD | IVI | Inventory Interface Y/N - Distribution | Character | UDC | 1 | 0 |
8 | F4314Z | Voucher Match Selection File | 14 | PN | IVI | Inventory Interface Y/N - Distribution | Character | UDC | 1 | 0 |
9 | F4371 | Suggested Reorder Stock Items | 23 | PD | IVI | Inventory Interface Y/N - Distribution | Character | UDC | 1 | 0 |
TOP43Q: Strategic Sourcing |
10 | F43Q11 | Event Detail | 58 | ED | IVI | Inventory Interface Y/N - Distribution | Character | UDC | 1 | 0 |
TOP44H: Homebuilder Management |
11 | F44H73W1 | Lot Start - P.O. / Committment Generation Work File | 65 | CG | IVI | Inventory Interface Y/N - Distribution | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.