| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP12: Fixed Assets |
| 1 | F1201 | Asset Master File | 93 | FA | FA3 | Category Code - F/A 13 | String | UDC | 3 | 0 |
| 2 | F1201P | Asset Master Purge Table | 93 | FA | FA3 | Category Code - F/A 13 | String | UDC | 3 | 0 |
| 3 | F1201Z1 | Unedited Asset Master Transactions | 102 | FA | FA3 | Category Code - F/A 13 | String | UDC | 3 | 0 |
| TOP13E: Equipment Cost Analysis |
| 4 | F1381 | Equipment Analysis Filters | 28 | EF | FA3 | Category Code - F/A 13 | 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 / F3 (Category Code 13) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | N |
| 2 | 09 | Nice | | N |
| 3 | 10 | Paris | | N |
| 4 | 11 | Frankfurt | | N |
| 5 | 12 | Hamburg | | N |
| 6 | 13 | Amsterdam | | N |
| 7 | 14 | Milan | | N |
| 8 | 15 | Rome | | N |
| 9 | 16 | Capetown | | N |
| 10 | 17 | Johannesburg | | N |
| 11 | 18 | Rio de Janeiro | | N |
| 12 | 19 | Sao Paulo | | N |
| 13 | 20 | Montreal | | N |
| 14 | 21 | Toronto | | N |
| 15 | 22 | Vancouver | | N |
| 16 | 23 | Guadalajara | | N |
| 17 | 24 | Mexico City | | N |
| 18 | 25 | Denver | | N |
| 19 | 26 | New York City | | N |
| 20 | 27 | San Francisco | | N |
