| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F00092 | Supplemental Data | 14 | T3 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 2 | F00191 | Generic Message/Rates | 3 | CE | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 3 | F00192 | General Message Detail | 3 | CF | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 4 | F0048 | Code Mappings Master | 6 | CM | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 5 | F00692 | Cost Center Supplemental Data Codes | 3 | M2 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 6 | F00693 | Cost Center Supplemental Data Text | 3 | M3 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP01: Address Book |
| 7 | F01092 | Supplemental Database - Code | 5 | A2 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 8 | F01093 | Supplemental Database - Narrative | 4 | A3 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP05: Time Accounting and HRM Base |
| 9 | F051424 | Competency Detail UDC Words | 3 | CD | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP08: Human Resources |
| 10 | F05410 | Employee E-Signature | 8 | ES | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 11 | F080701 | Fusion Lookup Map | 14 | LU | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 12 | F080702 | Fusion Entity Map | 21 | EM | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 13 | F08092 | Human Resources General Description-User Def Codes | 6 | JZ | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 14 | F08093 | Human Resources General Description - Narration | 6 | JY | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP08C: OW HR Canadian |
| 15 | F08021 | Canadian Employment Equity | 3 | YY | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP10: Financial Reporting |
| 16 | F10005 | User Defined Code Control File | 3 | GO | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP12: Fixed Assets |
| 17 | F12092 | Fixed Assets Supplemental Data Codes Type | 3 | F3 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP13: Plant/Equipment Management |
| 18 | F1207 | Maintenance Schedule File | 7 | FW | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 19 | F12071 | Equipment PM Schedule (Model) | 21 | FZ | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 20 | F1207P | Maintenance Schedule Purge Table | 7 | FW | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP32: Configuration Management |
| 21 | F3210W | Segment Value Workfile | 1 | SW | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP34A: Advanced Planning & Scheduling |
| 22 | F34A30 | Order Status Definition Table | 4 | N0 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP40R: Demand Scheduling |
| 23 | F471721 | EDI Demand Supplemental Data | 16 | EU | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP41: Inventory Management |
| 24 | F4101H | Item Hierarchy (Web) | 7 | IH | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 25 | F41092 | Item Supplemental Data Base User Defined Codes | 5 | T2 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP48: Work Order Processing |
| 26 | F48092 | WO Supplemental DB User Defined | 4 | W8 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP53: Change Management |
| 27 | F53005 | Job Specific UDCs Master Table | 3 | D1 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP55: Reserved for Clients |
| 28 | F74H1001 | Hierarchical Summary Work Table | 3 | HW | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 29 | F74H1006 | Balance&PL Work Table | 2 | BW | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 30 | F74HS006 | Balance&PL Work Table Slovakian | 2 | BW | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP74R: CIS |
| 31 | F74R0005 | User Defined Codes - RUS - 00 - 74R | 3 | DR | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP76B: Brazil - Reporting System Only |
| 32 | F76B054 | Messages Information - SPED Fiscal Brazilian WF - BRA - 76B | 6 | WM | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 33 | F76B0540 | Brazil Electronic Reporting Block B Worktable | 10 | BW | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 34 | F76B0806 | Messages information - SPED Fiscal Brazilian Workfile | 4 | MI | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP76E: Ecuador |
| 35 | F76E0001 | Tax Person Code - ECU - 76E | 2 | TC | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 36 | F76E0002 | Additional Pair Tax - ECU - 76E | 2 | PE | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP76V: Venezuela |
| 37 | F76V0401 | Relation Invoice/Retention Code - VEN - 76V | 6 | RE | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOP90CA: CRM Foundation |
| 38 | F90CA24D | Simple template alternate key | 6 | SK | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOPH90: ONEWORLD TOOLS |
| 39 | F98882 | Composer Rough Cut Selections | 3 | RC | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 40 | F98885 | Composer Industry and Geographical Regions | 5 | GI | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 41 | F98887 | Composer Industry and Geograhpic Locations Xref | 2 | PC | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOPH93: Data Base and Communications |
| 42 | F9300 | Database Property Values | 1 | DP | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOPH95: Tech Resources/Applications |
| 43 | F0005 | User Defined Code Values | 3 | DR | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 44 | F0005D | User Defined Codes - Alternate Language Descriptions | 3 | DR | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| TOPH96U: Upgrade |
| 45 | F960005 | Change Table - User Defined Codes | 5 | CR | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 46 | F964725 | Special Instructions UDC Description | 4 | SI | KY | User Defined Code | String | Generic Edit | 10 | 0 |
| 47 | F9746 | Change Table - User Defined Codes | 3 | D$ | KY | User Defined Code | String | Generic Edit | 10 | 0 |
