| 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 |
TOP10: Financial Reporting |
4 | F1003 | Multi-Site Consolidation Transfer File - Category Codes | 19 | GR | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
5 | F10UI002 | Dynamically Created Business Units | 18 | BU | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
TOP34A: Advanced Planning & Scheduling |
6 | F34A40 | APS Integration Group Setup Table | 38 | N0 | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
TOP48S: Service Billing |
7 | F4812 | Billing Detail Workfile | 8 | WD | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
8 | F4812H | Billing Workfile History | 8 | WD | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
9 | F4812HS | Billing Workfile History Purged Save | 8 | WD | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
10 | F48S910 | Billing Detail Journal Workfile | 67 | W2 | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
11 | F48SUI01 | Billing Detail Print Workfile | 8 | WD | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
TOP52: Contract Billing |
12 | F5280W | Contract Revenue Summary Work File | 24 | GY | RP11 | Category Code - Business Unit 11 | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.