| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP12: Fixed Assets |
| 1 | F1201 | Asset Master File | 72 | FA | ACL8 | Category Code - F/A 8 | String | UDC | 3 | 0 |
| 2 | F1201P | Asset Master Purge Table | 72 | FA | ACL8 | Category Code - F/A 8 | String | UDC | 3 | 0 |
| 3 | F1201Z1 | Unedited Asset Master Transactions | 83 | FA | ACL8 | Category Code - F/A 8 | String | UDC | 3 | 0 |
| TOP13: Plant/Equipment Management |
| 4 | F12071 | Equipment PM Schedule (Model) | 15 | FZ | ACL8 | Category Code - F/A 8 | String | UDC | 3 | 0 |
| TOP13E: Equipment Cost Analysis |
| 5 | F1381 | Equipment Analysis Filters | 23 | EF | ACL8 | Category Code - F/A 8 | 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 / C8 (Division) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | N |
| 2 | 110 | Legislative | | N |
| 3 | 120 | Judicial | | N |
| 4 | 130 | Executive | | N |
| 5 | 150 | Financial | | N |
| 6 | 190 | Other - Unclassified | | N |
| 7 | 210 | Police | | N |
| 8 | 220 | Fire | | N |
| 9 | 230 | Corrections | | N |
| 10 | 240 | Protective Inspection | | N |
| 11 | 310 | Streets | | N |
| 12 | 320 | Bridges, Viaducts & Grade Sep. | | N |
| 13 | 330 | Sanitary Administration | | N |
| 14 | 331 | Street Cleaning | | N |
| 15 | 332 | Waste Collection | | N |
| 16 | 333 | Waste Disposal | | N |
| 17 | 340 | Sewage Collection & Disposal | | N |
| 18 | 345 | Weed Control | | N |
| 19 | 510 | Recreation | | N |
| 20 | 520 | Parks | | N |
| 21 | 530 | Libraries | | N |
