| 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 | F01161DW | Customer Alternate Address Export | 15 | DW | COUN | County | String | UDC | 25 | 0 |
5 | F01161Z1 | Batch - Alternative Address | 24 | LB | COUN | County | String | UDC | 25 | 0 |
6 | F0117 | Postal Codes | 4 | A8 | COUN | County | String | UDC | 25 | 0 |
7 | F0118 | Postal Code Address | 13 | A7 | COUN | County | String | UDC | 25 | 0 |
TOP05: Time Accounting and HRM Base |
8 | F054101 | Employee Personal Profile Information History Table | 23 | EH | COUN | County | String | UDC | 25 | 0 |
9 | F054101W | Employee Personal Profile Information Work Table | 23 | EP | COUN | County | String | UDC | 25 | 0 |
TOP05A: PeopleSoft HR & PR Foundation |
10 | F060116Z | Unedited Quick Hire Transaction File | 133 | SZ | COUN | County | String | UDC | 25 | 0 |
TOP07: Payroll |
11 | F074001 | New Hire Reporting Workfile - OneWorld Only | 20 | NH | COUN | County | String | UDC | 25 | 0 |
12 | F07880 | SUI Magnetic Media Workfile | 36 | YW | COUN | County | String | UDC | 25 | 0 |
TOP08: Human Resources |
13 | F083305 | Mail Merge Header/Detail | 15 | MM | 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 | Equipment Master 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 | 33 | 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 |
30 | F49T50 | Order Release Location Staging | 22 | LO | COUN | County | String | UDC | 25 | 0 |
31 | F49T70 | Corporations Staging Table | 11 | CS | COUN | County | String | UDC | 25 | 0 |
32 | F49T80 | Locations Staging Table | 14 | LC | COUN | County | String | UDC | 25 | 0 |
TOP54HS: Health & Safety Incident Mgt |
33 | F54HS01 | Incident Master | 36 | S1 | COUN | County | String | UDC | 25 | 0 |
34 | F54HS01M | Incident Master Change History | 39 | I1 | COUN | County | String | UDC | 25 | 0 |
35 | F54HS02 | Incident People | 46 | S2 | COUN | County | String | UDC | 25 | 0 |
36 | F54HS02M | Incident People Change History | 49 | I2 | COUN | County | String | UDC | 25 | 0 |
TOP74: EMEA Localization |
37 | F7430031 | Legal Document Address (Print Info) - COMM - 03B | 13 | PI | COUN | County | String | UDC | 25 | 0 |
TOP76B: Brazil |
38 | F76B70 | Physical and Legal Person Table - IN68 - 42 | 12 | FJ | COUN | County | String | UDC | 25 | 0 |
TOP76H: Chile |
39 | F76H3B31 | Legal Document Header (Print Info) - CHI - 03B - 76H | 13 | PI | COUN | County | String | UDC | 25 | 0 |
TOP79A: Greenhouse Gas Accounting |
40 | F79A09 | GHG Energy Rates | 25 | ER | COUN | County | String | UDC | 25 | 0 |
41 | F79A10 | GHG Rates | 29 | ER | COUN | County | String | UDC | 25 | 0 |
42 | F79A11 | GHG Ledger | 32 | GR | COUN | County | String | UDC | 25 | 0 |
43 | F79A11Z1 | GHG Ledger - Batch File | 50 | GL | COUN | County | String | UDC | 25 | 0 |
44 | F79A12 | GHG Ledger Audit | 33 | GR | COUN | County | String | UDC | 25 | 0 |
45 | F79A75 | GHG Organization Name | 9 | GO | COUN | County | String | UDC | 25 | 0 |
46 | F79AU11 | GHG Ledger Work Table | 35 | GR | COUN | County | String | UDC | 25 | 0 |
TOP90CA: CRM Foundation |
47 | F90CA14D | Territory Zip Code Table | 4 | TD | COUN | County | String | UDC | 25 | 0 |
48 | F90CA14E | Territory City Table | 5 | TE | COUN | County | String | UDC | 25 | 0 |