| 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 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 12 / ES (Status or Disposal Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | |
| 2 | 1C | Disposed - Charity | | |
| 3 | 1D | Disposed - Destroyed | | |
| 4 | 1O | Disposed - Outright Sale | | |
| 5 | 1S | Disposed - Scrapped | | |
| 6 | 1T | Disposed - Sale w/ Trade In | | |
| 7 | 1X | Disposed - Theft | | |
| 8 | AV | Available - On Job Site | | |
| 9 | DM | Demobilization | | |
| 10 | DN | Down - On Site | | |
| 11 | DS | Down - In Shop | | |
| 12 | MB | Mobilization | | |
| 13 | SB | Standby | | |
| 14 | WK | Working | | |
