| 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 |
TOP10: Financial Reporting |
4 | F1003 | Multi-Site Consolidation Transfer File - Category Codes | 20 | GR | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
5 | F10UI002 | Dynamically Created Business Units | 19 | BU | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
TOP34A: Advanced Planning & Scheduling |
6 | F34A40 | APS Integration Group Setup Table | 39 | N0 | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
TOP48S: Service Billing |
7 | F48096 | Billing Rate / Mark up Table | 18 | WQ | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
8 | F4812 | Billing Detail Workfile | 46 | WD | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
9 | F4812H | Billing Workfile - History | 46 | WD | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
10 | F4812HS | Billing Workfile History Purged Save | 46 | WD | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
11 | F48SUI01 | Billing Detail Print Workfile | 46 | WD | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
TOP52: Contract Billing |
12 | F5212 | T and M - Unit Price and Lumpsum Cross Reference Accounts | 20 | G5 | RP12 | Category Code - Business Unit 12 | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.