Contact Table

Contains all your contacts, both companies and persons, for example prospective customers, customers, vendors, but also consultants, competitors, and so on.

Some of the fields in the Contact table are valid for companies only, while others are valid for persons only or for both companies and persons. Therefore, when entering a new contact it is important that you specify if it is a new company or a new person working for a company already recorded as a contact. Information from a company to a person in that company is automatically updated if you have selected the relevant Inherit field in the Marketing Setup window.

If a contact is already recorded as a customer, vendor, or bank account, you can link it with the related records in the relevant cards. If a contact becomes a customer, vendor, or bank account, you can create a record or card based on the information entered in the Contact table. If you have allowed customer, vendor, and bank account integration in the Marketing Setup window, you only have to update information in one place. For example, when you correct an address on the customer card, the information is automatically updated in the Contact table.

List of Fields in the Table

Field Location
No. of Opportunities Field, Contact Table Relationship Management
Telex Answer Back Field, Contact Table Relationship Management
No. of Industry Groups Field, Contact Table Relationship Management
Pager Field, Contact Table Relationship Management
Post Code Field, Contact Table Relationship Management
Search E-Mail Field, Contact Table Relationship Management
Name Field, Contact Table Relationship Management
External ID Field, Contact Table Relationship Management
Comment Field, Contact Table Relationship Management
Calcd. Current Value (LCY) Field, Contact Table Relationship Management
Last Time Modified Field, Contact Table Relationship Management
Currency Code Field, Contact Table Relationship Management
Extension No. Field, Contact Table Relationship Management
Telex No. Field, Contact Table Relationship Management
Initials Field, Contact Table Relationship Management
Correspondence Type Field, Contact Table Relationship Management
City Field, Contact Table Relationship Management
Salesperson Filter Field, Contact Table Relationship Management
No. Field, Contact Table Relationship Management
Company No. Field, Contact Table Relationship Management
Surname Field, Contact Table Relationship Management
To-do Closed Filter Field, Contact Table Relationship Management
Territory Code Field, Contact Table Relationship Management
Job Title Field, Contact Table Relationship Management
Close Opportunity Filter Field, Contact Table Relationship Management
Mobile Phone No. Field, Contact Table Relationship Management
Campaign Filter Field, Contact Table Relationship Management
Phone No. Field, Contact Table Relationship Management
Home Page Field, Contact Table Relationship Management
Chances of Success % Filter Field, Contact Table Relationship Management
Date of Last Interaction Field, Contact Table Relationship Management
To-do Entry Exists Field, Contact Table Relationship Management
Estimated Value Filter Field, Contact Table Relationship Management
Priority Filter Field, Contact Table Relationship Management
E-Mail Field, Contact Table Relationship Management
Last Date Modified Field, Contact Table Relationship Management
First Name Field, Contact Table Relationship Management
Estimated Value (LCY) Field, Contact Table Relationship Management
No. of Job Responsibilities Field, Contact Table Relationship Management
To-do Status Filter Field, Contact Table Relationship Management
Fax No. Field, Contact Table Relationship Management
Picture Field, Contact Table Relationship Management
Team Filter Field, Contact Table Relationship Management
No. of Mailing Groups Field, Contact Table Relationship Management
Action Taken Filter Field, Contact Table Relationship Management
Lookup Contact No. Field, Contact Table Relationship Management
Exclude from Segment Field, Contact Table Relationship Management
Opportunity Entry Exists Field, Contact Table Relationship Management
Cost (LCY) Field, Contact Table Relationship Management
Date Filter Field, Contact Table Relationship Management
Sales Cycle Stage Filter Field, Contact Table Relationship Management
Sales Cycle Filter Field, Contact Table Relationship Management
Country/Region Code Field, Contact Table Relationship Management
Completed % Filter Field, Contact Table Relationship Management
Search Name Field, Contact Table Relationship Management
Type Field, Contact Table Relationship Management
Company Name Field, Contact Table Relationship Management
Organizational Level Code Field, Contact Table Relationship Management
E-Mail 2 Field, Contact Table Relationship Management
Probability % Filter Field, Contact Table Relationship Management
Duration (Min.) Field, Contact Table Relationship Management
No. of Interactions Field, Contact Table Relationship Management
Middle Name Field, Contact Table Relationship Management
Fiscal Code Field, Contact Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Next To-do Date Field, Contact Table Relationship Management
Legal Form Field, Contact Table France Local Functionality
Address Field, Contact Table Relationship Management
Name 2 Field, Contact Table Relationship Management
Salesperson Code Field, Contact Table Relationship Management
County Field, Contact Table Relationship Management
Calcd. Current Value Filter Field, Contact Table Relationship Management
No. Series Field, Contact Table Relationship Management
Language Code Field, Contact Table Relationship Management
Last Date Attempted Field, Contact Table Relationship Management
VAT Registration No. Field, Contact Table Relationship Management
No. of Business Relations Field, Contact Table Relationship Management
Salutation Code Field, Contact Table Relationship Management
Address 2 Field, Contact Table Relationship Management
APE Code Field, Contact Table France Local Functionality
Trade Register Field, Contact Table France Local Functionality
Stock Capital Field, Contact Table France Local Functionality
Enterprise No. Field, Contact Table Belgium Local Functionality
Registered Field, Contact Table New Zealand Local Functionality
IRD No. Field, Contact Table New Zealand Local Functionality
ABN Field, Contact Table New Zealand Local Functionality
ABN Division Part No. Field, Contact Table New Zealand Local Functionality

See Also

Reference

Contact Card

Other Resources

Relationship Management Setup
Synchronizing Contacts with Customers, Vendors and Bank Accounts