| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP12: Fixed Assets |
| 1 | F1201 | Asset Master File | 19 | FA | EQST | Equipment Status | String | UDC | 2 | 0 |
| 2 | F1201P | Asset Master Purge Table | 19 | FA | EQST | Equipment Status | String | UDC | 2 | 0 |
| 3 | F1201Z1 | Unedited Asset Master Transactions | 32 | FA | EQST | Equipment Status | String | UDC | 2 | 0 |
| 4 | F1204 | Location Tracking Table | 13 | FM | EQST | Equipment Status | String | UDC | 2 | 0 |
| 5 | F1204P | Location Tracking Purge Table | 13 | FM | EQST | Equipment Status | String | UDC | 2 | 0 |
| 6 | F12141 | Disposal Account Rule Table | 2 | DT | EQST | Equipment Status | String | UDC | 2 | 0 |
| TOP13C: Condition-Base Maintenance |
| 7 | F1310 | Condition-Based Alerts | 9 | CA | EQST | Equipment Status | String | UDC | 2 | 0 |
| 8 | F1310Z1 | Unedited Condition-Based Alerts | 23 | CB | EQST | Equipment Status | String | UDC | 2 | 0 |
| TOP13E: Equipment Cost Analysis |
| 9 | F1381 | Equipment Analysis Filters | 9 | EF | EQST | Equipment Status | String | UDC | 2 | 0 |
| TOP75C: China - Reporting System Only |
| 10 | F75C204 | Asset Master History File - CHINA | 5 | AH | EQST | Equipment Status | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
