| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0006 | Business Unit Master | 25 | MC | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
2 | F0006S | Date Effective Business Unit Master | 27 | MC | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
3 | F0006Z1 | Cost Center Unedited Transaction Table | 38 | SZ | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
4 | F0006Z2 | Business Unit Master Z File | 38 | SZ | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
TOP10: Financial Reporting |
5 | F1003 | Multi-Site Consolidation Transfer File - Category Codes | 19 | GR | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
6 | F10UI002 | Dynamically Created Business Units | 18 | BU | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
TOP34A: Advanced Planning & Scheduling |
7 | F34A40 | APS Integration Group Setup Table | 38 | N0 | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
TOP48S: Service Billing |
8 | F4812 | Billing Detail Workfile | 8 | WD | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
9 | F4812H | Billing Workfile History | 8 | WD | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
10 | F4812HS | Billing Workfile History Purged Save | 8 | WD | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
11 | F48426 | Service Billing Trigger Configuration | 9 | ST | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
12 | F48S910 | Billing Detail Journal Workfile | 67 | W2 | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
13 | F48SUI01 | Billing Detail Print Workfile | 8 | WD | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
TOP51X: In-Memory Project Management |
14 | F51X10 | Project Advisor Console Worktable | 88 | EX | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
TOP52: Contract Billing |
15 | F5280W | Contract Revenue Summary Work File | 24 | GY | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
TOP54R: Rental Management |
16 | F54R099 | Rental Contract Header Ledger | 122 | HL | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
17 | F54R10 | Rental Contract Header | 120 | CH | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
18 | F54R11 | Rental Contract Detail | 165 | CD | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
19 | F54R199 | Rental Contract Detail Ledger | 161 | DL | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |