| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP12: Fixed Assets |
| 1 | F1201 | Asset Master File | 10 | FA | ACL4 | Model Year | String | UDC | 3 | 0 |
| 2 | F1201P | Asset Master Purge Table | 10 | FA | ACL4 | Model Year | String | UDC | 3 | 0 |
| 3 | F1201Z1 | Unedited Asset Master Transactions | 23 | FA | ACL4 | Model Year | String | UDC | 3 | 0 |
| TOP13: Plant/Equipment Management |
| 4 | F12071 | Equipment PM Schedule (Model) | 11 | FZ | ACL4 | Model Year | String | UDC | 3 | 0 |
| TOP13E: Equipment Cost Analysis |
| 5 | F1381 | Equipment Analysis Filters | 19 | EF | ACL4 | Model Year | String | UDC | 3 | 0 |
| TOP54R: Rental Management |
| 6 | F54R11 | Rental Contract Detail | 45 | CD | ACL4 | Model Year | String | UDC | 3 | 0 |
| 7 | F54R199 | Rental Contract Detail Ledger | 41 | DL | ACL4 | Model Year | 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 / C4 (Model Year) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | N |
| 2 | 00 | 2000 | | N |
| 3 | 01 | 2001 | | N |
| 4 | 02 | 2002 | | N |
| 5 | 03 | 2003 | | N |
| 6 | 04 | 2004 | | N |
| 7 | 05 | 2005 | | N |
| 8 | 97 | 1997 | | N |
| 9 | 98 | 1998 | | N |
| 10 | 99 | 1999 | | N |
