| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP05: Time Accounting and HRM Base |
| 1 | F050116W | Employee Master Integrations Work File | 2 | EM | AN8 | Address Number | Numeric | UDC | 8 | 0 |
| TOP17: Customer Service Management |
| 2 | F1791 | Entitlement Dates | 5 | EM | AN8 | Address Number | Numeric | UDC | 8 | 0 |
| TOP75C: China - Reporting System Only |
| 3 | F75C008 | Employee Record Information - China | 1 | EM | AN8 | Address Number | Numeric | UDC | 8 | 0 |
| TOP90CA: CRM Foundation |
| 4 | F90CA004 | F42150 and F42160 Aggregate table for sync filtering. | 2 | AG | EMAN8 | Employee Address Number | Numeric | Generic Edit | 8 | 0 |
| 5 | F90CA040 | Employee Table | 1 | EE | EMAN8 | Employee Address Number | Numeric | Generic Edit | 8 | 0 |
| 6 | F90CA041 | Employee and Subordinates | 2 | ES | EMAN8 | Employee Address Number | Numeric | Generic Edit | 8 | 0 |
| 7 | F90CA042 | Flat Employee Hierarchy | 1 | EM | AN8 | Address Number | Numeric | UDC | 8 | 0 |
| 8 | F90CA05A | Partner_Employee Table | 2 | PA | EMAN8 | Employee Address Number | Numeric | Generic Edit | 8 | 0 |
| 9 | F90CA08A | Customer_Employee Table | 2 | UA | EMAN8 | Employee Address Number | Numeric | Generic Edit | 8 | 0 |
| 10 | F90CA12B | Industry Grouping Employee Table | 2 | IB | EMAN8 | Employee Address Number | Numeric | Generic Edit | 8 | 0 |
| 11 | F90CA14A | Territory Employee Table | 2 | TE | EMAN8 | Employee Address Number | Numeric | Generic Edit | 8 | 0 |
| 12 | F90CA50D | EMAIL CONTACT Table | 2 | EM | AN8 | Address Number | Numeric | UDC | 8 | 0 |
| TOP90CB: CRM Sales Force Automation |
| 13 | F90CB010 | Lead Table | 19 | LD | EMAN8 | Employee Address Number | Numeric | Generic Edit | 8 | 0 |
| 14 | F90CB02E | Opportunity_Employee Table | 2 | OE | EMAN8 | Employee Address Number | Numeric | Generic Edit | 8 | 0 |
