| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0006 | Business Unit Master | 26 | MC | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
2 | F0006S | Date Effective Business Unit Master | 28 | MC | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
3 | F0006Z1 | Cost Center Unedited Transaction Table | 39 | SZ | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
4 | F0006Z2 | Business Unit Master Z File | 39 | SZ | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
TOP10: Financial Reporting |
5 | F1003 | Multi-Site Consolidation Transfer File - Category Codes | 20 | GR | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
6 | F10UI002 | Dynamically Created Business Units | 19 | BU | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
TOP34A: Advanced Planning & Scheduling |
7 | F34A40 | APS Integration Group Setup Table | 39 | N0 | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
TOP48S: Service Billing |
8 | F48096 | Billing Rate / Mark up Table | 18 | WQ | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
9 | F4812 | Billing Detail Workfile | 46 | WD | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
10 | F4812H | Billing Workfile History | 46 | WD | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
11 | F4812HS | Billing Workfile History Purged Save | 46 | WD | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
12 | F48SUI01 | Billing Detail Print Workfile | 46 | WD | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
TOP51X: In-Memory Project Management |
13 | F51X10 | Project Advisor Console Worktable | 89 | EX | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
TOP52: Contract Billing |
14 | F5212 | T and M, Unit Price and Lumpsum Cross Reference Accounts | 20 | G5 | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
TOP52G: Proj & Gov Contract Accounting |
15 | F52G21 | Contract Specific Labor Category Cross Reference | 15 | LR | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
TOP54R: Rental Management |
16 | F54R099 | Rental Contract Header Ledger | 123 | HL | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
17 | F54R10 | Rental Contract Header | 121 | CH | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
18 | F54R11 | Rental Contract Detail | 166 | CD | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
19 | F54R199 | Rental Contract Detail Ledger | 162 | DL | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |