| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP01: Address Book |
| 1 | F0101Z2 | Address Book - Interoperability | 91 | SZ | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 2 | F0116 | Address by Date | 8 | AL | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 3 | F01161 | Alternate Address | 9 | WL | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 4 | F01161DW | Customer Alternate Address Export | 14 | DW | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 5 | F01161Z1 | Batch - Alternative Address | 22 | LB | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 6 | F0117 | Postal Codes | 1 | A8 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 7 | F0118 | Postal Code Address | 2 | A7 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP05: Time Accounting and HRM Base |
| 8 | F054101 | Employee Personal Profile Information History Table | 20 | EH | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 9 | F054101W | Employee Personal Profile Information Work Table | 20 | EP | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 10 | F054111 | Employee Emergency Contact History Table | 11 | CH | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 11 | F054111W | Employee Emergency Contact Work Table | 11 | EC | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP05A: PeopleSoft HR & PR Foundation |
| 12 | F05003 | Verification of Employment Data | 17 | EV | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 13 | F060116Z | Unedited Quick Hire Transaction File | 75 | SZ | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP07: Payroll |
| 14 | F074001 | New Hire Reporting Workfile - OneWorld Only | 17 | NH | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 15 | F07830 | Employee Federal Control Table | 62 | Y0 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 16 | F07831 | Employee State/Local Control Table | 38 | YB | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 17 | F07832 | Employee Special Handling Control Table | 24 | YH | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 18 | F07880 | SUI Magnetic Media Workfile | 13 | YW | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 19 | F8907422 | New Hire Detail File - Massachusetts (22) | 8 | MA | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 20 | F8907427 | New Hire Detail File - Montana (27) | 38 | MT | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 21 | F8907428 | New Hire Detail File - Nebraska(28) | 15 | NE | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 22 | F8907444 | New Hire Detail File Transfer - Texas (44) | 13 | TX | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP08: Human Resources |
| 23 | F083305 | Mail Merge Header/Detail | 14 | MM | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP08AD: ADP Integration |
| 24 | F05137 | ADP Employee Master Information | 59 | AD | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP08B: Benefits Administration |
| 25 | F0833WF | Benefit Statement Work file | 11 | WF | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP13C: Condition-Base Maintenance |
| 26 | F1310 | Condition-Based Alerts | 53 | CA | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 27 | F1310Z1 | Unedited Condition-Based Alerts | 67 | CB | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP15: Real Estate Management |
| 28 | F1507 | Unit Master | 20 | NH | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP17C: Call Management |
| 29 | F17311 | Equipment Master Location Details | 20 | LD | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP31B: Blend Management |
| 30 | F31B01 | Winery Master | 8 | WI | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP40: Inventory/OP Base |
| 31 | F4006 | Order Address Information | 10 | OA | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 32 | F4006Z | Batch Order Receiver - Order Address Information | 10 | OY | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 33 | F4215 | Shipment Header | 37 | XH | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP44H: Homebuilder Management |
| 34 | F44H201 | Lot Master | 6 | LM | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 35 | F44H201H | Lot Master History | 7 | LM | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 36 | F44H201Z | HB Lot Master Unedited Transaction File | 19 | SZ | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 37 | F44H501H | Lot Sales History | 172 | LS | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP47: Electronic Commerce |
| 38 | F47037 | EDI Shipping Notice Detail - Outbound | 213 | SZ | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 39 | F470561 | EDI Payment Order Bank N & A - Outbound | 31 | D2 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 40 | F470561W | EDI Payment Order Bank N & A - Work | 31 | D2 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 41 | F470562 | EDI Payment Order Vendor N & A - Outbound | 31 | D4 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 42 | F470562W | EDI Payment Order Vendor N & A - Work | 31 | D4 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 43 | F470563 | EDI Payment Order Payee N & A - Outbound | 31 | D5 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 44 | F470563W | EDI Payment Order Payee N & A - Work | 31 | D5 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 45 | F4706 | EDI Order Address Information | 20 | ZA | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 46 | F47081 | EDI Price Sales Catalog Header - Inbound | 27 | FV | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP49: Transportation Management |
| 47 | F4950 | Routing Entries | 11 | RT | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 48 | F4960 | Load Header | 11 | TM | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 49 | F4981 | Freight Audit History | 56 | FH | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 50 | F49T50 | Order Release Location Staging | 20 | LO | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 51 | F49T80 | Locations Staging Table | 16 | LC | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP54HS: Health & Safety Incident Mgt |
| 52 | F54HS01 | Incident Master | 35 | S1 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 53 | F54HS01M | Incident Master Change History | 38 | I1 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 54 | F54HS02 | Incident People | 45 | S2 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 55 | F54HS02M | Incident People Change History | 48 | I2 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP74: EMEA Localization |
| 56 | F7430031 | Legal Document Address (Print Info) - COMM - 03B | 15 | PI | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP74B: Begium Localization |
| 57 | F7403B11 | Belgium - Work File Yearly Vat Declaration Data | 4 | QA | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 58 | F74B200 | Yearly/Quarterly VAT Listing - Belgium | 4 | VT | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP75A: Australia |
| 59 | F75A0010 | Australian Employee Termination Details | 61 | A0 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 60 | F75A0220 | Payment Summary Workfile | 12 | PS | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP75I: India |
| 61 | F75I100Q | TDS Form 26Q - WorkFile (Quarterly) | 22 | EF | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 62 | F75I100W | TDS Form 26 - WorkFile | 22 | EF | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP76A: Argentina |
| 63 | F76A0209 | Header & Footer Invoice/ShipmentNote History WF - ARG - 76A | 94 | HF | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 64 | F76A020P | Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A | 94 | HF | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 65 | F76A8002 | SICORE RG738 Withholding Entity - ARG - 04 - 76A | 6 | V3 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 66 | F76A82 | A/P Payment Control Group File - ARG - 04 - 76A | 28 | C6 | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 67 | F76AUI20 | Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A | 94 | HF | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP76B: Brazil |
| 68 | F76101B | Nota Fiscal - Header (Fiscal Books) - 42 | 26 | QX | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 69 | F76B70 | Physical and Legal Person Table - IN68 - 42 | 15 | FJ | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 70 | F76B8601 | IN86-Work Table for Individuals and Legal Entities - 04 | 12 | FJ | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP76H: Chile |
| 71 | F76H3B31 | Legal Document Header (Print Info) - CHI - 03B - 76H | 15 | PI | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP79A: Greenhouse Gas Accounting |
| 72 | F79A75 | GHG Organization Name | 11 | GO | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| TOP90CA: CRM Foundation |
| 73 | F90CA14D | Territory Zip Code Table | 2 | TD | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
| 74 | F90CA14E | Territory City Table | 4 | TE | ADDZ | Postal Code | String | Generic Edit | 12 | 0 |
