| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0006 | Business Unit Master | 7 | MC | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
2 | F0006S | Date Effective Business Unit Master | 9 | MC | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
3 | F0006Z1 | Cost Center Unedited Transaction Table | 20 | SZ | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
4 | F0006Z2 | Business Unit Master Z File | 20 | SZ | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
TOP48S: Service Billing |
5 | F4812 | Billing Detail Workfile | 124 | WD | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
6 | F4812H | Billing Workfile History | 124 | WD | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
7 | F4812HS | Billing Workfile History Purged Save | 124 | WD | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
8 | F4822 | Invoice Summary Work File | 14 | W4 | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
9 | F48221 | Service Billing Retention Release Cross Reference File | 2 | WH | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
10 | F4823 | Voucher Summary | 12 | W0 | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
11 | F48426 | Service Billing Trigger Configuration | 5 | ST | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
12 | F48S910 | Billing Detail Journal Workfile | 56 | W2 | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
13 | F48SUI01 | Billing Detail Print Workfile | 124 | WD | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
TOP51X: In-Memory Project Management |
14 | F51X10 | Project Advisor Console Worktable | 64 | EX | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
TOP52: Contract Billing |
15 | F5201 | Contract Master | 12 | G4 | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
TOP52G: Proj & Gov Contract Accounting |
16 | F4822H | Invoice Summary History | 14 | IH | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
17 | F52G01M | Advanced Contracts Modifications | 17 | CM | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
TOP53: Change Management |
18 | F5302 | F5302 World Specs | 43 | DK | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
19 | F5311 | Change Request Details Table | 134 | DK | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
20 | F5311Z1 | Change Request Details Table Workfile | 139 | DK | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
21 | F5314 | Planned Change Order Master Table | 34 | D2 | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
22 | F5315 | Change Order Master Table | 33 | D3 | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
TOP74U: United Kingdom Localizations |
23 | F74U0412 | Application Commitment Workfile - UK - 43 | 9 | AC | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
24 | F74U0414 | Certificate Commitment Workfile - UK - 43 | 9 | CC | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |
25 | F74U0416 | Purchase Order Commitment Workfile - UK - 43 | 9 | PC | AN8O | Address Number - Job A/R | Numeric | Generic Edit | 8 | 0 |