| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP12: Fixed Assets |
| 1 | F1201 | Asset Master File | 9 | FA | ACL3 | Manufacturer | String | UDC | 3 | 0 |
| 2 | F1201P | Asset Master Purge Table | 9 | FA | ACL3 | Manufacturer | String | UDC | 3 | 0 |
| 3 | F1201Z1 | Unedited Asset Master Transactions | 22 | FA | ACL3 | Manufacturer | String | UDC | 3 | 0 |
| TOP13: Plant/Equipment Management |
| 4 | F12071 | Equipment PM Schedule (Model) | 10 | FZ | ACL3 | Manufacturer | String | UDC | 3 | 0 |
| TOP13E: Equipment Cost Analysis |
| 5 | F1381 | Equipment Analysis Filters | 18 | EF | ACL3 | Manufacturer | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 12 / C3 (Manufacturer) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | |
| 2 | CAR | Carrier | | |
| 3 | CAT | Caterpillar | | |
| 4 | CHV | Chevrolet | | |
| 5 | DBC | D. Bek Phone Co. | | N |
| 6 | DEM | Demag | | |
| 7 | DRT | Dart (Pacar) | | |
| 8 | DUR | Durco | | |
| 9 | EAT | Eaton | | |
| 10 | FAR | Fairbanks | | |
| 11 | FAS | Fasco | | |
| 12 | FIA | Fiat-Allis | | |
| 13 | FMC | Farm Machinery Company | | |
| 14 | FRD | Ford Motor Company | | |
| 15 | GEN | General Electric | | |
| 16 | GLD | Gould | | |
| 17 | GMC | General Motors Corporation | | |
| 18 | HIT | Hitachi | | |
| 19 | HON | Honeywell | | |
| 20 | IBM | International Business Machine | | |
| 21 | JDR | John Deere | | |
| 22 | KEN | Kenworth | | |
| 23 | KOM | Komatzu | | |
| 24 | MAC | Mack Trucks | | |
| 25 | MCH | Michigan Equipment | | |
| 26 | MIT | Mitsubishi | | N |
| 27 | OTS | Otis Elevator | | |
| 28 | PAR | Parker | | |
| 29 | RIM | Rimpull | | |
| 30 | SMT | Smith | | |
| 31 | STM | Stemco | | |
| 32 | TER | Terex | | |
| 33 | TRI | Tridelta | | |
| 34 | WES | Westinghouse | | |
