| 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: OW 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: Property 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: Tech Resources/Applications |
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 |