| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP12: Fixed Assets |
| 1 | F1201 | Asset Master File | 71 | FA | ACL7 | Category Code - F/A 7 | String | UDC | 3 | 0 |
| 2 | F1201P | Asset Master Purge Table | 71 | FA | ACL7 | Category Code - F/A 7 | String | UDC | 3 | 0 |
| 3 | F1201Z1 | Unedited Asset Master Transactions | 82 | FA | ACL7 | Category Code - F/A 7 | String | UDC | 3 | 0 |
| TOP13: Plant/Equipment Management |
| 4 | F12071 | Equipment PM Schedule (Model) | 14 | FZ | ACL7 | Category Code - F/A 7 | String | UDC | 3 | 0 |
| TOP13E: Equipment Cost Analysis |
| 5 | F1381 | Equipment Analysis Filters | 22 | EF | ACL7 | Category Code - F/A 7 | 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 / C7 (Category Code 7) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | N |
| 2 | 100 | General Government | | N |
| 3 | 200 | Public Safety | | N |
| 4 | 300 | Highways and Streets | | N |
| 5 | 350 | Sanitation | | N |
| 6 | 400 | Health and Welfare | | N |
| 7 | 500 | Culture and Recreation | | N |
| 8 | 600 | Conservation | | N |
| 9 | 630 | Urban Redevelopment & Housing | | N |
| 10 | 650 | Economic Development and Asst. | | N |
| 11 | 660 | Economic Opportunity | | N |
| 12 | 700 | Debt Service | | N |
| 13 | 800 | Intergovernmental Expenditures | | N |
| 14 | 850 | Other Government Expenditures | | N |
| 15 | 900 | Other Financing Uses | | N |
| 16 | 950 | Education | | N |
