| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP12: Fixed Assets |
1 | F1201 | Asset Master File | 74 | FA | ACL0 | Category Code - F/A 10 (Rate Group) | String | UDC | 3 | 0 |
2 | F1201P | Asset Master Purge Table | 74 | FA | ACL0 | Category Code - F/A 10 (Rate Group) | String | UDC | 3 | 0 |
3 | F1201Z1 | Unedited Asset Master Transactions | 85 | FA | ACL0 | Category Code - F/A 10 (Rate Group) | String | UDC | 3 | 0 |
TOP13: Plant/Equipment Management |
4 | F12071 | Equipment PM Schedule (Model) | 7 | FZ | ACL0 | Category Code - F/A 10 (Rate Group) | String | UDC | 3 | 0 |
TOP13E: Equipment Cost Analysis |
5 | F1381 | Equipment Analysis Filters | 25 | EF | ACL0 | Category Code - F/A 10 (Rate Group) | String | UDC | 3 | 0 |
TOP48S: Service Billing |
6 | F48096 | Billing Rate / Mark up Table | 21 | WQ | ACL0 | Category Code - F/A 10 (Rate Group) | String | UDC | 3 | 0 |
7 | F4812 | Billing Detail Workfile | 40 | WD | ACL0 | Category Code - F/A 10 (Rate Group) | String | UDC | 3 | 0 |
8 | F4812H | Billing Workfile History | 40 | WD | ACL0 | Category Code - F/A 10 (Rate Group) | String | UDC | 3 | 0 |
9 | F4812HS | Billing Workfile History Purged Save | 40 | WD | ACL0 | Category Code - F/A 10 (Rate Group) | String | UDC | 3 | 0 |
10 | F48SUI01 | Billing Detail Print Workfile | 40 | WD | ACL0 | Category Code - F/A 10 (Rate Group) | String | UDC | 3 | 0 |
TOP52: Contract Billing |
11 | F5212 | T and M - Unit Price and Lumpsum Cross Reference Accounts | 17 | G5 | ACL0 | Category Code - F/A 10 (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.