| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP12: Fixed Assets |
| 1 | F1201 | Asset Master File | 70 | FA | ACL6 | Category Code - F/A 6 | String | UDC | 3 | 0 |
| 2 | F1201P | Asset Master Purge Table | 70 | FA | ACL6 | Category Code - F/A 6 | String | UDC | 3 | 0 |
| 3 | F1201Z1 | Unedited Asset Master Transactions | 81 | FA | ACL6 | Category Code - F/A 6 | String | UDC | 3 | 0 |
| TOP13: Plant/Equipment Management |
| 4 | F12071 | Equipment PM Schedule (Model) | 13 | FZ | ACL6 | Category Code - F/A 6 | String | UDC | 3 | 0 |
| TOP13E: Equipment Cost Analysis |
| 5 | F1381 | Equipment Analysis Filters | 21 | EF | ACL6 | Category Code - F/A 6 | 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 / C6 (Equipment Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | N |
| 2 | M | ----MOTORS---- | | N |
| 3 | MA | 5 hp | | N |
| 4 | MB | 10 hp | | N |
| 5 | MC | 30 hp | | N |
| 6 | MD | 150 hp | | N |
| 7 | ME | 250 hp | | N |
| 8 | MF | 500 hp | | N |
| 9 | MG | 1000 hp | | N |
| 10 | MH | 2000 hp | | N |
| 11 | P | ----PUMPS---- | | N |
| 12 | PA | Centrifical | | N |
| 13 | PB | Positive Displacement | | N |
| 14 | V | ----VALVES---- | | N |
| 15 | VA | Butterfly | | N |
| 16 | VB | Ball | | N |
| 17 | VC | Gate | | N |
| 18 | VD | Pressure Relief | | N |
