| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP12: Fixed Assets |
| 1 | F1204 | Location Tracking Table | 24 | FM | RTGR | Equipment Rate Group | String | UDC | 3 | 0 |
| 2 | F1204P | Location Tracking Purge Table | 24 | FM | RTGR | Equipment Rate Group | String | UDC | 3 | 0 |
| 3 | F1301 | Equipment Rates | 2 | FG | RTGR | Equipment Rate Group | String | UDC | 3 | 0 |
| 4 | F1301P | Equipment Rates Purge Table | 2 | FG | RTGR | Equipment Rate Group | String | UDC | 3 | 0 |
| TOP13: Plant/Equipment Management |
| 5 | F1305 | Equipment Distribution Rules | 3 | FV | RTGR | Equipment Rate Group | 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 / C0 (Rate Group) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | | N |
| 2 | 01 | Crane | | N |
| 3 | 02 | Grader | | N |
| 4 | CAD | CAD/CAM | | N |
| 5 | CIR | Circular Saw | | N |
| 6 | DRL | Drill Motor | | N |
| 7 | FRM | Curb Form | | N |
| 8 | HOE | Backhoe | | N |
| 9 | PLT | Plotter | | N |
| 10 | PU | Pickup Truck | | N |
| 11 | SCA | Scaffolding | | N |
| 12 | SCR | Scrapper | | N |
