| 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 | Suplemental Data Base - Code | 5 | A2 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
8 | F01093 | Suplemental Data Base - 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 | F08092 | Human Resources General Description-User Def Codes | 6 | JZ | KY | User Defined Code | String | Generic Edit | 10 | 0 |
12 | F08093 | Human Resources General Description - Narration | 6 | JY | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOP08C: OW HR Canadian |
13 | F08021 | Canadian Employment Equity | 3 | YY | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOP10: Financial Reporting |
14 | F10005 | User Defined Code Control File | 3 | GO | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOP12: Fixed Assets |
15 | F12092 | Fixed Assets Supplemental Data Codes Type | 3 | F3 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOP13: Plant/Equipment Management |
16 | F1207 | Maintenance Schedule File | 7 | FW | KY | User Defined Code | String | Generic Edit | 10 | 0 |
17 | F12071 | Equipment PM Schedule (Model) | 21 | FZ | KY | User Defined Code | String | Generic Edit | 10 | 0 |
18 | F1207P | Maintenance Schedule Purge Table | 7 | FW | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOP34A: Advanced Planning & Scheduling |
19 | F34A30 | Order Status Definition Table | 4 | N0 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOP40R: Demand Scheduling |
20 | F471721 | EDI Demand Supplemental Data | 16 | EU | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOP41: Inventory Management |
21 | F4101H | Item Hierarchy (Web) | 7 | IH | KY | User Defined Code | String | Generic Edit | 10 | 0 |
22 | F41092 | Item Supplemental Data Base User Defined Codes | 5 | T2 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOP48: Work Order Processing |
23 | F48092 | WO Supplemental DB User Defined | 4 | W8 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOP53: Change Management |
24 | F53005 | Job Specific UDC's Master Table | 3 | D1 | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOP55: Reserved for Clients |
25 | F74H1001 | Hierarchical Summary Work Table | 3 | HW | KY | User Defined Code | String | Generic Edit | 10 | 0 |
26 | F74H1006 | BalanceandPL Work Table | 2 | BW | KY | User Defined Code | String | Generic Edit | 10 | 0 |
27 | F74HS006 | BalanceandPL Work Table Slovakian | 2 | BW | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOP74R: CIS |
28 | F74R0005 | User Defined Codes - RUS - 00 - 74R | 3 | DR | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOP76E: Ecuador |
29 | F76E0001 | Tax Person Code - ECU - 76E | 2 | TC | KY | User Defined Code | String | Generic Edit | 10 | 0 |
30 | F76E0002 | Additional Pair Tax - ECU - 76E | 2 | PE | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOP76V: Venezuela |
31 | F76V0401 | Relation Invoice/Retention Code - VEN - 76V | 6 | RE | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOP90CA: CRM Foundation |
32 | F90CA24D | Simple template alternate key | 6 | SK | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOPH79: CS - Forecasting |
33 | F00051 | User Defined Codes Language Status | 3 | LS | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOPH90: ONEWORLD TOOLS |
34 | F98882 | Composer Rough Cut Selections | 3 | RC | KY | User Defined Code | String | Generic Edit | 10 | 0 |
35 | F98885 | Composer Industry and Geographical Regions | 5 | GI | KY | User Defined Code | String | Generic Edit | 10 | 0 |
36 | F98887 | Composer Industry and Geograhpic Locations Xref | 2 | PC | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOPH93: Data Base and Communications |
37 | F9300 | Database Property Values | 1 | DP | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOPH95: Tech Resources/Applications |
38 | F0005 | User Defined Codes | 3 | DR | KY | User Defined Code | String | Generic Edit | 10 | 0 |
39 | F0005D | User Defined Codes - Alternate Language Descriptions | 3 | DR | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOPH96: Deployment |
40 | F960005 | Change Table - User Defined Codes | 5 | CR | KY | User Defined Code | String | Generic Edit | 10 | 0 |
41 | F9746 | Change Table - User Defined Codes | 3 | D$ | KY | User Defined Code | String | Generic Edit | 10 | 0 |
TOPH96U: Upgrade |
42 | F964725 | Special Instructions UDC Description | 4 | SI | KY | User Defined Code | String | Generic Edit | 10 | 0 |