| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP01: Address Book |
1 | F0101Z2 | Address Book - Interoperability | 95 | SZ | COUN | County | String | UDC | 25 | 0 |
2 | F0116 | Address by Date | 10 | AL | COUN | County | String | UDC | 25 | 0 |
3 | F01161 | Alternate Address | 11 | WL | COUN | County | String | UDC | 25 | 0 |
4 | F01161Z1 | Batch - Alternative Address | 24 | LB | COUN | County | String | UDC | 25 | 0 |
5 | F0117 | Postal Code Transactions | 4 | A8 | COUN | County | String | UDC | 25 | 0 |
6 | F0118 | Postal Code Address | 13 | A7 | COUN | County | String | UDC | 25 | 0 |
TOP05: Time Accounting and HRM Base |
7 | F054101 | Employee Personal Profile Information History Table | 23 | EH | COUN | County | String | UDC | 25 | 0 |
8 | F054101W | Employee Personal Profile Information Work Table | 23 | EP | COUN | County | String | UDC | 25 | 0 |
TOP05A: OW HR & PR Foundation |
9 | F060116Z | Unedited Quick Hire Transaction File | 133 | SZ | COUN | County | String | UDC | 25 | 0 |
TOP07: Payroll |
10 | F074001 | New Hire Reporting Workfile - OneWorld Only | 20 | NH | COUN | County | String | UDC | 25 | 0 |
11 | F07880 | SUI Magnetic Media Workfile | 36 | YW | COUN | County | String | UDC | 25 | 0 |
TOP08: Human Resources |
12 | F083305 | Mail Merge Header/Detail | 15 | MM | COUN | County | String | UDC | 25 | 0 |
TOP08A: eRecruit |
13 | F08490 | Recruitment Information | 12 | RI | COUN | County | String | UDC | 25 | 0 |
TOP13C: Condition-Base Maintenance |
14 | F1310 | Condition-Based Alerts | 54 | CA | COUN | County | String | UDC | 25 | 0 |
15 | F1310Z1 | Unedited Condition-Based Alerts | 68 | CB | COUN | County | String | UDC | 25 | 0 |
TOP17C: Call Management |
16 | F17311 | Installed Base Location Details | 18 | LD | COUN | County | String | UDC | 25 | 0 |
TOP40: Inventory/OP Base |
17 | F4006 | Order Address Information | 12 | OA | COUN | County | String | UDC | 25 | 0 |
18 | F4006Z | Batch Order Receiver - Order Address Information | 12 | OY | COUN | County | String | UDC | 25 | 0 |
TOP40G: Grower Management |
19 | F31B77BW | Work File for Weigh Tag Summary Report | 16 | WS | COUN | County | String | UDC | 25 | 0 |
20 | F40G03 | Grower Harvest | 31 | GH | COUN | County | String | UDC | 25 | 0 |
21 | F40G0300 | Grower Harvest Update Profile | 46 | HU | COUN | County | String | UDC | 25 | 0 |
TOP40R: Demand Scheduling |
22 | F40R14 | Demand Addresses | 12 | DA | COUN | County | String | UDC | 25 | 0 |
23 | F40R143 | Demand Address History | 11 | DS | COUN | County | String | UDC | 25 | 0 |
24 | F471722 | EDI Demand Addresses | 25 | EA | COUN | County | String | UDC | 25 | 0 |
TOP47: Electronic Commerce |
25 | F47037 | EDI Shipping Notice Detail - Outbound | 210 | SZ | COUN | County | String | UDC | 25 | 0 |
26 | F470374 | EDI ASN Demand Addresses | 27 | AM | COUN | County | String | UDC | 25 | 0 |
27 | F4706 | EDI Order Address Information | 22 | ZA | COUN | County | String | UDC | 25 | 0 |
TOP49: Transportation Management |
28 | F4950 | Routing Entries | 9 | RT | COUN | County | String | UDC | 25 | 0 |
29 | F4951 | Carrier Zone Definitions | 7 | ZN | COUN | County | String | UDC | 25 | 0 |
TOP74: EMEA Localization |
30 | F7430031 | Legal Document Address (Print Info) - COMM - 03B | 13 | PI | COUN | County | String | UDC | 25 | 0 |
TOP76B: Brazil - Reporting System Only |
31 | F76B70 | Physical and Legal Person Table - IN68 - 42 | 12 | FJ | COUN | County | String | UDC | 25 | 0 |
TOP76H: Chile |
32 | F76H3B31 | Legal Document Header (Print Info) - CHI - 03B - 76H | 13 | PI | COUN | County | String | UDC | 25 | 0 |
TOP90CA: CRM Foundation |
33 | F90CA14D | Territory Zip Code Table | 4 | TD | COUN | County | String | UDC | 25 | 0 |
34 | F90CA14E | Territory City Table | 5 | TE | COUN | County | String | UDC | 25 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.