| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP17: Customer Service Management |
| 1 | F4801Z2 | Warranty Claim/Supplier Recovery processing | 17 | WS | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP31: Shop Floor Control |
| 2 | F4801Z1 | Outbound Work Order Header | 17 | SY | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP40: Inventory/OP Base |
| 3 | F4108 | Lot Master | 3 | IO | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP41: Inventory Management |
| 4 | F4101 | Item Master | 88 | IM | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 5 | F4101A | Item File | 59 | IM | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 6 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 103 | SZ | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 7 | F4102 | Item Branch File | 43 | IB | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 8 | F41021 | Item Location File | 7 | LI | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 9 | F41021WF | F41021 Transaction Workfile | 12 | LW | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 10 | F41021Z1 | Item Location Unedited Transaction File | 20 | SZ | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 11 | F41081 | Allowed Lot Status | 4 | LS | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 12 | F4111 | Item Ledger File | 14 | IL | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 13 | F41UI001 | Inventory Transactions Detail File | 32 | IT | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 14 | F41UI002 | Inventory Transactions Batch File | 15 | TI | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP41B: Bulk Stock Management |
| 15 | F41511 | Bulk Product Transaction File | 38 | PA | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP43: Procurement |
| 16 | F43121Z | Receiver workfile | 27 | PW | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 17 | F43121Z1 | Receipts Unedited Transaction Table | 120 | SZ | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP44H: Homebuilder Management |
| 18 | F4453 | Lot Master (World) | 20 | JB | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP46L: License Plating |
| 19 | F46LUI01 | Assign/Remove Items To LP Work File | 22 | WF | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP47: Electronic Commerce |
| 20 | F47032 | EDI Shipping Notice Detail - Inbound | 170 | SZ | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 21 | F47072 | EDI Receiving Advice Detail - Inbound | 243 | SZ | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 22 | F47122 | EDI Product Activity Data Detail - Inbound | 33 | MJ | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 23 | F47127 | EDI Product Activity Data Detail - Outbound | 33 | MJ | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP76H: Chile |
| 24 | F76H611 | Actual Item Ledger File - CHI - 41 - 76H | 14 | AL | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOPD3N: dcLINK (data collection) - DSI |
| 25 | FD3N4116 | dcLINK Interface - Inventory Reclassification | 11 | IR | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
