| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP01: Address Book |
1 | F0111 | Address Book - Who's Who | 2 | WW | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
2 | F01112 | Related Person | 2 | CP | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
3 | F01112Z1 | Batch - Related Person | 15 | PB | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
4 | F0111Z1 | Batch Who's Who Information | 15 | BW | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
5 | F0115 | Address Book - Phone Numbers | 2 | WP | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
6 | F01151 | Electronic Address | 2 | EA | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
7 | F01151Z1 | Batch - Electronic Address | 15 | EB | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
8 | F0115Z1 | Phones - Interoperability | 16 | PI | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
9 | F01161 | Alternate Address | 2 | WL | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
10 | F01161DW | Customer Alternate Address Export | 2 | DW | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
11 | F01161Z1 | Batch - Alternative Address | 15 | LB | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
12 | F011901 | Contacts Subscriptions Table | 4 | CS | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
13 | F01501 | Enhanced Parent Child | 4 | PR | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
14 | F01815 | AB Word Search Master | 2 | AS | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
TOP05: Time Accounting and HRM Base |
15 | F054111 | Employee Emergency Contact History Table | 2 | CH | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
16 | F054111W | Employee Emergency Contact Work Table | 2 | EC | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
TOP08: Human Resources |
17 | F054115 | Employee Phone Number History Table | 3 | HP | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
18 | F054115W | Employee Phone Number Work Table | 2 | PN | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
TOP17C: Call Management |
19 | F1755 | Case Master | 27 | ZA | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
TOP43Q: Strategic Sourcing |
20 | F43Q30 | Event Invited Bidders | 11 | EV | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
21 | F43Q35 | Event Bidder Password Temp Table | 2 | PT | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
TOP89: Conversion Programs |
22 | F01111 | Contact Information | 2 | WN | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
23 | F01111Z1 | Batch - Contact Information | 15 | CB | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
24 | F89AD020 | Person_Address cross reference table | 3 | PE | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
25 | F89CA020 | Lookup Table for CRM and EOne Person Ids | 3 | PS | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
26 | F89LUADD | Address lookup table | 3 | AD | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
TOP90CA: CRM Foundation |
27 | F90CA50B | MEMBER PERSON Table | 2 | ME | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
28 | F90CA50D | EMAIL CONTACT Table | 3 | EM | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
TOP90CB: CRM Sales Force Automation |
29 | F90CB02D | Opportunity_Contact Table | 3 | OD | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
30 | F90CB02M | Cost Table | 41 | OM | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |
31 | F90CB060 | Forecast | 4 | FC | IDLN | Who's Who Line Number - ID | Numeric | Generic Edit | 5 | 0 |