| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP01: Address Book |
| 1 | F0101Z2 | Address Book - Interoperability | 111 | SZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 2 | F0150 | Address Organization Structure Master File - OSTP - PA8 - AN8 | 2 | MA | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOP03: Accounts Receivable |
| 3 | F0311 | Accounts Receivable Ledger | 19 | RP | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 4 | F03B11 | Customer Ledger | 17 | RP | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 5 | F03B112 | Invoice Revisions | 21 | RW | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 6 | F03B112P | Invoice Revisions Purge File | 21 | RW | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 7 | F03B11P | Customer Ledger Purge File | 17 | RP | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 8 | F03B11Z1 | Invoice Transactions - Batch File | 35 | VJ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 9 | F03B11Z2 | F03B11 Interoperability Table | 30 | SY | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 10 | F03B13 | Receipts Header File | 21 | RY | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 11 | F03B13P | Receipts Header Purge File | 21 | RY | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 12 | F03B13Z2 | F03B13 Interoperability Table | 34 | SY | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 13 | F03B14 | A/R Check Detail File | 22 | RZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 14 | F03B14P | Receipts Detail Purge File | 22 | RZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 15 | F03B14Z2 | F03B14 Interoperability Table | 35 | SZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 16 | F03B15 | Credit and Cash Management | 5 | RT | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 17 | F03B22 | A/R Fee Journal History | 8 | RS | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 18 | F03B575 | Auto Debit Invoice Select and Build | 20 | RD | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 19 | F03B672 | Draft Remittance Work File - One World Only | 24 | RD | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOP05: Time Accounting and HRM Base |
| 20 | F069086 | Payroll Corporate Tax Identification | 10 | YI | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOP07: Payroll |
| 21 | F06720 | W-2/1099 Processing Control | 43 | JE | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOP12: Fixed Assets |
| 22 | F1217 | Equipment Master Extension | 13 | WR | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 23 | F1217P | Equipment Master Extension Purge Table | 13 | WR | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 24 | F1217Z1 | Unedited Equipment Tag Transactions | 26 | WR | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 25 | F1217Z2 | Unedited Equipment Tag Transactions | 26 | WR | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOP15: Property Management |
| 26 | F15525W | PM Statements Credit/Cash Build Workfile | 5 | RT | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOP31P: Engineer To Order |
| 27 | F31P01 | Project Attributes | 25 | PA | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOP40: Inventory/OP Base |
| 28 | F4001Z | Batch Receiver File - Order Headings | 38 | SY | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 29 | F4011Z | Batch Receiver File - Order Details | 34 | SZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 30 | F40300R | Preference Resolution History - Master | 31 | PM | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 31 | F4201Z1 | Sales Order Header Unedited Transaction File | 28 | SY | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 32 | F4209 | Held Orders | 26 | HO | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 33 | F4211AU | Sales Order Detail Audit File | 15 | AU | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 34 | F4211Z1 | Sales Order Detail Unedited Transaction File | 33 | SZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOP41: Inventory Management |
| 35 | F41182 | Container Serial | 3 | CS | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOP42: Sales Management |
| 36 | F4201 | Sales Order Header File | 15 | SH | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 37 | F42019 | Sales Order Header History File | 15 | SH | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 38 | F4211 | Sales Order Detail File | 20 | SD | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 39 | F42119 | Sales Order History File | 20 | SD | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 40 | F42199 | S.O. Detail Ledger File | 20 | SL | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 41 | F42565 | Invoice Print File | 77 | IW | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 42 | F42CSS | Customer Self Service Workfile | 7 | CS | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 43 | F42UI01 | SO Header Cache File (MBF) | 20 | ZH | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 44 | F42UI11 | SO Detail Cache File (MBF) | 24 | ZD | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 45 | F42UI521 | Pick Slips Detail File | 18 | S9 | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOP45: Advanced Pricing |
| 46 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 134 | Z1 | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOP47: Electronic Commerce |
| 47 | F47011 | EDI Purchase Order Header - Inbound | 33 | SY | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 48 | F47012 | EDI Purchase Order Detail - Inbound | 34 | SZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 49 | F47026 | EDI P.O. Acknowledgment Header - Outbound | 30 | SY | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 50 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 34 | SZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 51 | F47037 | EDI Shipping Notice Detail - Outbound | 35 | SZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 52 | F470371 | EDI Shipping Notice Detail - Outbound | 35 | SZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 53 | F47041 | EDI Invoice Header - Inbound | 28 | SY | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 54 | F47046 | EDI Invoice Header (Sales) - Outbound | 30 | SY | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 55 | F47047 | EDI Invoice Detail (Sales) - Outbound | 34 | SZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 56 | F47056W | EDI Payment Order Header - Work | 27 | D1 | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 57 | F47091 | EDI Request for Quote Header - Inbound | 33 | SY | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 58 | F47092 | EDI Request for Quote Detail - Inbound | 34 | SZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 59 | F47106 | EDI Response to RFQ Header - Outbound | 30 | SY | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 60 | F47107 | EDI Response to RFQ Detail - Outbound | 34 | SZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 61 | F47131 | EDI Purchase Order Change Header - Inbound | 30 | SY | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 62 | F47132 | EDI Purchase Order Change Detail - Inbound | 35 | SZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 63 | F47146 | EDI P.O. Change Acknowledgment Header - Outbound | 31 | SY | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 64 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 36 | SZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOP74: EMEA Localization |
| 65 | F74412 | Customer / Supplier Balance Workfile (A/R and A/P) | 7 | RP | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 66 | F74900 | Foreign Receivables and Payables - EMEA | 23 | RP | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOP76C: Colombia |
| 67 | F76C031A | A/R Customer ledger As Of - F76C031A - COL - 04 | 17 | RP | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 68 | F76C034A | A/R Check Detail file As Of - COL - 76C | 22 | RZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOP90CA: CRM Foundation |
| 69 | F90CA042 | Flat Employee Hierarchy | 2 | EM | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| TOPH90: ONEWORLD TOOLS |
| 70 | F01131 | PPAT Message Control File | 14 | ZZ | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 71 | F01131M | JDEM Multi Level Message | 7 | ZM | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 72 | F01136 | JDEM Mail Filters | 1 | ZP | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 73 | F98840 | Organizational Structure Master | 15 | OM | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
| 74 | F98840N | Organizational Structure Master - Net Change | 3 | OM | PA8 | Address Number - Parent | Numeric | Generic Edit | 8 | 0 |
