| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F00090 | Supplemental Database Setup | 21 | T1 | FILE | File Name | String | Generic Edit | 10 | 0 |
| 2 | F0040Z1 | Error Message Log Table | 8 | ZB | FILE | File Name | String | Generic Edit | 10 | 0 |
| 3 | F0080 | Supplemental Data Type Security File | 1 | S2 | FILE | File Name | String | Generic Edit | 10 | 0 |
| 4 | F0085 | Audit Record Y/N File - Euro | 2 | YN | FILE | File Name | String | Generic Edit | 10 | 0 |
| 5 | F4096 | Sales Flex Accounting | 16 | FA | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOP01: Address Book |
| 6 | F01090 | Supplemental Database - Core | 11 | A1 | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOP04: Accounts Payable |
| 7 | F0457 | A/P Payment Tape | 1 | KM | FILE | File Name | String | Generic Edit | 10 | 0 |
| 8 | F04572 | A/P Payment Processing - Summary | 49 | KK | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOP05A: PeopleSoft HR & PR Foundation |
| 9 | F06041 | Specify Future Data Fields | 1 | JK | FILE | File Name | String | Generic Edit | 10 | 0 |
| 10 | F08041 | Select Data Items for History Tracking | 1 | JU | FILE | File Name | String | Generic Edit | 10 | 0 |
| 11 | F08042 | HR History | 1 | JW | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOP06: Payroll (old) - Obsolete-do not reuse |
| 12 | F06042 | Future Data EE Master Revisions | 1 | JO | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOP08: Human Resources |
| 13 | F08090 | HRM Supplemental Data Types | 26 | JX | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOP12: Fixed Assets |
| 14 | F1215 | Specification Cross Reference | 14 | GV | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOP15: Real Estate Management |
| 15 | F8915CV1 | Property Management Table Conversion Master Audit | 2 | N7 | FILE | File Name | String | Generic Edit | 10 | 0 |
| 16 | F8915CV2 | Property Management Table Conversion Detail Audit | 1 | N9 | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOP16: Profit Management (EPS) |
| 17 | F1620 | Cost Object Types | 4 | CT | FILE | File Name | String | Generic Edit | 10 | 0 |
| 18 | F1630 | Driver Definitions | 4 | CD | FILE | File Name | String | Generic Edit | 10 | 0 |
| 19 | F1690 | Enables Tables by Application | 2 | CK | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOP17C: Call Management |
| 20 | F1759 | Case Required Fields | 1 | CL | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOP39: Advanced Stock Valuation |
| 21 | F39121W | Additional Quantity Work File | 14 | AQ | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOP40: Inventory/OP Base |
| 22 | F40UI801 | Generic Error Table | 8 | ZB | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOP41: Inventory Management |
| 23 | F41090 | Item Supplemental Data Types | 11 | T1 | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOP47: Electronic Commerce |
| 24 | F47002 | Flat File Cross-Reference Table | 4 | SV | FILE | File Name | String | Generic Edit | 10 | 0 |
| 25 | F47003 | EDI Discrepancy Report Work File | 3 | SX | FILE | File Name | String | Generic Edit | 10 | 0 |
| 26 | F47006 | EDI Order Header - Outbound Tax Table | 15 | ST | FILE | File Name | String | Generic Edit | 10 | 0 |
| 27 | F47007 | EDI Order Detail - Outbound Tax Table | 15 | DT | FILE | File Name | String | Generic Edit | 10 | 0 |
| 28 | F4706 | EDI Order Address Information | 9 | ZA | FILE | File Name | String | Generic Edit | 10 | 0 |
| 29 | F4714 | EDI Order Text Lines - Header | 9 | ZT | FILE | File Name | String | Generic Edit | 10 | 0 |
| 30 | F4715 | EDI Order Text Lines - Detail | 9 | ZD | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOP77: Payroll (Canadian) |
| 31 | F77703 | Payroll History Audit Report - Worktable | 12 | AR | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOP89: Conversion Programs |
| 32 | F0086 | Conversion Audit File for Euro Conversion | 2 | AU | FILE | File Name | String | Generic Edit | 10 | 0 |
| TOPH95: Object and Environment Tech |
| 33 | F82195 | World Writer Query Logical Files | 6 | A4 | FILE | File Name | String | Generic Edit | 10 | 0 |
| 34 | F82196 | World Writer Query Join Files | 4 | A4 | FILE | File Name | String | Generic Edit | 10 | 0 |
