| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F00091 | Supplemental Database Data Types | 25 | T2 | AT1 | Search Type | String | UDC | 3 | 0 |
| 2 | F17001 | Service/Warranty Constants Table - F17001 | 12 | CS | AT1 | Search Type | String | UDC | 3 | 0 |
| TOP01: Address Book |
| 3 | F0101 | Address Book Master | 9 | AB | AT1 | Search Type | String | UDC | 3 | 0 |
| 4 | F0101Z2 | Address Book - Interoperability | 22 | SZ | AT1 | Search Type | String | UDC | 3 | 0 |
| 5 | F01090 | Supplemental Database - Core | 2 | A1 | AT1 | Search Type | String | UDC | 3 | 0 |
| 6 | F01092 | Supplemental Database - Code | 3 | A2 | AT1 | Search Type | String | UDC | 3 | 0 |
| 7 | F01093 | Supplemental Database - Narrative | 2 | A3 | AT1 | Search Type | String | UDC | 3 | 0 |
| 8 | F01138 | AB Data Permission List Definitions | 3 | DS | AT1 | Search Type | String | UDC | 3 | 0 |
| TOP03: Accounts Receivable |
| 9 | F0311 | Accounts Receivable Ledger | 121 | RP | AT1 | Search Type | String | UDC | 3 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 10 | F03B465 | A/R Netting Workfile | 45 | RO | AT1 | Search Type | String | UDC | 3 | 0 |
| TOP04: Accounts Payable |
| 11 | F04514 | 1099 Merged Worktables (F045141:F045143) | 6 | G1 | AT1 | Search Type | String | UDC | 3 | 0 |
| 12 | F045141 | 1099 G/L Worktable | 6 | G1 | AT1 | Search Type | String | UDC | 3 | 0 |
| 13 | F045143 | 1099 A/P Worktable | 6 | G1 | AT1 | Search Type | String | UDC | 3 | 0 |
| TOP05A: OW HR & PR Foundation |
| 14 | F060116Z | Unedited Quick Hire Transaction File | 20 | SZ | AT1 | Search Type | String | UDC | 3 | 0 |
| TOP08: Human Resources |
| 15 | F08090 | HRM Supplemental Data Types | 21 | JX | AT1 | Search Type | String | UDC | 3 | 0 |
| TOP43Q: Strategic Sourcing |
| 16 | F43Q30 | Event Invited Bidders | 12 | EV | AT1 | Search Type | String | UDC | 3 | 0 |
| 17 | F43Q90 | Sourcing Constants | 4 | SC | AT1 | Search Type | String | UDC | 3 | 0 |
| TOP47: Electronic Commerce |
| 18 | F47056 | EDI Payment Order Header - Outbound | 54 | D1 | AT1 | Search Type | String | UDC | 3 | 0 |
| 19 | F47056W | EDI Payment Order Header - Work | 54 | D1 | AT1 | Search Type | String | UDC | 3 | 0 |
| TOP49: Transportation Management |
| 20 | F49T80 | Locations Staging Table | 2 | LC | AT1 | Search Type | String | UDC | 3 | 0 |
| TOP76B: Brazil - Reporting System Only |
| 21 | F76B20 | Account Payable and Receivable Table - IN68 - 03B | 2 | PR | AT1 | Search Type | String | UDC | 3 | 0 |
| 22 | F76B30 | Nota Fiscal Header/Table for Goods - IN68 - 42 | 7 | MM | AT1 | Search Type | String | UDC | 3 | 0 |
| 23 | F76B31 | Nota Fiscal Detail/Table for Goods - IN68 - 42 | 5 | IM | AT1 | Search Type | String | UDC | 3 | 0 |
| 24 | F76B40 | Nota Fiscal Header/Table for Services - IN68 - 42 | 7 | MS | AT1 | Search Type | String | UDC | 3 | 0 |
| 25 | F76B41 | Nota Fiscal Detail/Table for Services - IN68 - 42 | 5 | IS | AT1 | Search Type | String | UDC | 3 | 0 |
| 26 | F76B70 | Physical and Legal Person Table - IN68 - 42 | 2 | FJ | AT1 | Search Type | String | UDC | 3 | 0 |
| TOP89: Conversion Programs |
| 27 | F01111 | Contact Information | 3 | WN | AT1 | Search Type | String | UDC | 3 | 0 |
| 28 | F01111Z1 | Batch - Contact Information | 31 | CB | AT1 | Search Type | String | UDC | 3 | 0 |
| TOP90CA: CRM Foundation |
| 29 | F90CA50B | MEMBER PERSON Table | 5 | ME | AT1 | Search Type | String | UDC | 3 | 0 |
