| 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 |
TOP54R: Rental Management |
6 | F54R11 | Rental Contract Detail | 44 | CD | ACL3 | Manufacturer | String | UDC | 3 | 0 |
7 | F54R199 | Rental Contract Detail Ledger | 40 | DL | 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 | | . | | N |
2 | CAR | Carrier | | N |
3 | CAT | Caterpillar | | N |
4 | CHV | Chevrolet | | N |
5 | CMN | Cummins | | N |
6 | DBC | D. Bek Phone Co. | | N |
7 | DEM | Demag | | N |
8 | DRT | Dart (Pacar) | | N |
9 | DUR | Durco | | N |
10 | EAT | Eaton | | N |
11 | FAR | Fairbanks | | N |
12 | FAS | Fasco | | N |
13 | FIA | Fiat-Allis | | N |
14 | FMC | Farm Machinery Company | | N |
15 | FRD | Ford Motor Company | | N |
16 | GEN | General Electric | | N |
17 | GLD | Gould | | N |
18 | GMC | General Motors Corporation | | N |
19 | HIT | Hitachi | | N |
20 | HON | Honeywell | | N |
21 | IBM | International Business Machine | | N |
22 | JDR | John Deere | | N |
23 | KEN | Kenworth | | N |
24 | KOM | Komatzu | | N |
25 | MAC | Mack Trucks | | N |
26 | MCH | Michigan Equipment | | N |
27 | MIT | Mitsubishi | | N |
28 | OTS | Otis Elevator | | N |
29 | PAR | Parker | | N |
30 | RIM | Rimpull | | N |
31 | SMT | Smith | | N |
32 | STM | Stemco | | N |
33 | TER | Terex | | N |
34 | TRI | Tridelta | | N |
35 | WES | Westinghouse | | N |