| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0006 | Business Unit Master | 112 | MC | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 2 | F0006S | Date Effective Business Unit Master | 114 | MC | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 3 | F0006Z1 | Cost Center Unedited Transaction Table | 125 | SZ | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| TOP05: Time Accounting and HRM Base |
| 4 | F06106 | Employee Pay Instructions | 65 | YM | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 5 | F0618 | Employee Transaction History | 79 | YT | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| TOP05T: Time Entry |
| 6 | F06116 | Employee Transaction Detail File | 79 | YT | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 7 | F06116Z1 | Employee Transactions - Batch File | 93 | VL | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 8 | F06116Z2 | ESS Timecard History | 93 | VM | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 9 | F06278 | Retro Timecard Detail File | 79 | YT | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| TOP07: Payroll |
| 10 | F0716701 | Employee Assignment T/E Template Information | 42 | EA | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 11 | F0716709 | Employee Assignment T/E Template Info History | 42 | EA | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 12 | F07UI200 | Timecard History Work File | 82 | TH | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| TOP08AD: ADP Integration |
| 13 | F051371 | ADP Employee DBA Instructions | 70 | AD | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| TOP09: General Accounting |
| 14 | F0901 | Account Master | 41 | GM | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| TOP12: Fixed Assets |
| 15 | F1204 | Location Tracking Table | 11 | FM | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 16 | F1204P | Location Tracking Purge Table | 11 | FM | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 17 | F1301 | Equipment Rates | 6 | FG | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 18 | F1301P | Equipment Rates Purge Table | 6 | FG | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| TOP13: Plant/Equipment Management |
| 19 | F1302 | Rental Rules | 14 | FK | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 20 | F1304 | Equipment Location Billing | 12 | FN | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 21 | F1390 | Equipment Rate Code Definition | 1 | FV | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| TOP18: Resource Scheduling |
| 22 | F186602 | Labor Rules Tag File | 88 | TF | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| TOP48S: Service Billing |
| 23 | F48096 | Billing Rate / Mark up Table | 25 | WQ | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 24 | F4812 | Billing Detail Workfile | 41 | WD | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 25 | F4812H | Billing Workfile History | 41 | WD | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 26 | F4812HS | Billing Workfile History Purged Save | 41 | WD | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 27 | F48S0618 | Payroll Reclassification Workfile | 79 | YT | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| 28 | F48SUI01 | Billing Detail Print Workfile | 41 | WD | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
| TOP51: Job Costing |
| 29 | F5109 | Chart Type Master | 18 | GJ | ERC | Equipment Rate Code | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
