| 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 |
| TOP40: Inventory/OP Base |
| 2 | F4108 | Lot Master | 3 | IO | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP41: Inventory Management |
| 3 | F4101 | Item Master | 88 | IM | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 4 | F4101A | Item File | 59 | IM | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 5 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 103 | SZ | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 6 | F4102 | Item Branch File | 43 | IB | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 7 | F41021 | Item Location File | 7 | LI | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 8 | F41021WF | F41021 Transaction Workfile | 12 | LW | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 9 | F41021Z1 | Item Location Unedited Transaction File | 20 | SZ | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 10 | F41025 | Consignment Sites (FUTURE) | 7 | CS | 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 |
| TOP41F: Apparel Management |
| 16 | FCW09 | Item Revisions Work File | 21 | WR | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 17 | FCW10 | Item Branch Work File | 16 | WB | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 18 | FCW13 | Item Location Work File | 8 | WL | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 19 | FCW22 | Lot Master Work File | 7 | WL | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP43: Procurement |
| 20 | F43121Z | Receiver workfile | 27 | PW | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 21 | F43121Z1 | Receipts Unedited Transaction Table | 120 | SZ | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP44H: Homebuilder Management |
| 22 | F4453 | Lot Master (World) | 20 | JB | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP46L: License Plating |
| 23 | F46LUI01 | Assign/Remove Items To LP Work File | 22 | WF | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP47: Electronic Commerce |
| 24 | F47032 | EDI Shipping Notice Detail - Inbound | 170 | SZ | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 25 | F47072 | EDI Receiving Advice Detail - Inbound | 243 | SZ | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 26 | F47122 | EDI Product Activity Data Detail - Inbound | 33 | MJ | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| 27 | F47127 | EDI Product Activity Data Detail - Outbound | 33 | MJ | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP48: Work Order Processing |
| 28 | F4801Z1 | Outbound Work Order Header | 17 | SY | LOTS | Lot Status Code | Character | UDC | 1 | 0 |
| TOP76H: Chile |
| 29 | F76H611 | Actual Item Ledger File - CHI - 41 - 76H | 14 | AL | 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.
