Contact Export
Use the Contact Export report to download contact data to a Microsoft Excel spreadsheet file or other file format.
Contents
| Column | Description |
|---|---|
| Full Name | This column displays the contact's full name: Prefix, First Name, Middle Name, Last Name, Suffix. |
| Title | This column displays the contact's title (for example, Director, Project Manager, or CEO). |
| Type | This column displays the contact type: Customer or Subcontractor. |
| Status | This column displays the contact's current status: Active or Inactive. |
| Source | This column displays the source of the contact (for example, specific conferences, trade shows, or the names of referring customers). |
| Other Phone | This column displays the contact's business telephone number. |
| Other Fax | This column displays the contact's business fax number. |
| Prefix | This column displays the contact's salutation (for example, Mr., Mrs., or Dr.). |
| First Name | This column displays the contact's first name. |
| Middle Name | This column displays the contact's middle name or initial. |
| Last Name | This column displays the contact's last name. |
| Suffix | This column displays the suffix from the contact's name (for example, Jr., Sr., Esq.). |
| Preferred Name | This column displays the name by which the contact prefers to be addressed. |
| Customer Name | If the contact is a customer, this column displays the customer name. |
| Customer Status | If the contact is a customer, this column displays the current status of your relationship with the customer: Active, Dormant, or Inactive. |
| Customer Relationship | If the contact is a customer, this column displays your relationship with the customer (for example, Consultant, Prospective, or Existing). |
| Subcontractor Name | If the contact is a subcontractor, this column displays the subcontractor name. |
| This column displays the contact's email address. | |
| Is Mailing Address | This column indicates if the address is the contact's mailing address.
If the column contains Y (Yes), the address is the contact's other address or home address. If the column contains N (No), the address is one of the following:
|
| Mail Address 1 - 4 | This column displays the contact's address (street name and number, suite number, P.O. Box number). |
| Mail City | This column displays the city from the contact's address. |
| Mail State | This column displays the state from the contact's address. |
| Mail ZIP | This column displays the ZIP code from the contact's address. |
| Mail Country | This column displays the country from the contact's address. |
| Concatenated Address | This column displays the contact's other or home street address, city, state, and ZIP code. The report shows this information in a single column. |
| Other Address 1 - 4 | This column displays the contact's other or home address (street name and number, suite number, P.O. box number, and so on). |
| Other City | This column displays the city from the contact's other address or home address. |
| Other State | This column displays the two-character abbreviation for the state from the contact's other address or home address. |
| Other Zip | This column displays the ZIP code from the contact's other address or home address. |
| Other Country | This column displays the country from the contact's other address or home address. |
| Pager | This column displays the contact's pager number. |
| Cell Phone | This column displays the contact's cellular phone number. |
| Home Phone | This column displays the contact's home telephone number. |
| Customer Address Desc | If the contact is a customer, this column displays the description of the customer's address (for example, Company Headquarters, Main Office, or Northeast Office). |
| Concatenated Customer Address | If the contact is a customer, this column displays the customer's street address, city, state, and ZIP code. The report shows this information in a single column. |
| Customer Address 1 - 4 | If the contact is a customer, this column displays the customer's address information.
Customer Address 1displays the customer's name. Customer Address 2, Customer Address 3, and Customer Address 4 display the customer's address information (street name and number, suite number, postal box number, and so on). |
| Customer City | If the contact is a customer, this column displays the city from the customer's address. |
| Customer State | If the contact is a customer, this column displays the two-character abbreviation for the state from the customer's address. |
| Customer Zip | If the contact is a customer, this column displays the ZIP code from the customer's address. |
| Customer Country | If the contact is a customer, this column displays the country from the customer's address. |
| Customer Phone | If the contact is a customer, this column displays the customer's telephone number. |
| Customer Fax | If the contact is a customer, this column displays the customer's fax number. |
| Customer Website | If the contact is a customer, this column displays the customer's website address (for example, www.deltek.com). |
| Vendor/Partner Address Desc | If the contact is a vendor/partner, this column displays the description of the vendor/partner's address (for example, Company Headquarters, Main Office, or Northeast Office). |
| Concatenated Vendor/Partner Address | If the contact is a vendor/partner, this column displays the vendor/partner's street address, city, state, and ZIP code. The report shows this information in a single column. |
| Vendor/Partner Address 1 - 4 | If the contact is a vendor/partner, these columns display the vendor/partner's address information (street name and number, suite number, postal box number, and so on). |
| Vendor/Partnre City | If the contact is a vendor/partner, this column displays the city from the vendor/partner's address. |
| Vendor/Partner State | If the contact is a vendor/partner, this column displays the two-character abbreviation for the state from the vendor/partner's address. |
| Vendor/Partner Zip | If the contact is a vendor/partner, this column displays the ZIP code from the vendor/partner's address. |
| Vendor/Partner Country | If the contact is a vendor/partner, this column displays the country from the vendor/partner's address. |
| Vendor/Partner Phone | If the contact is a vendor/partner, this column displays the vendor/partner's telephone number. |
| Vendor/Partner Fax | If the contact is a vendor/partner, this column displays the vendor/partner's fax number. |
| Vendor/Partner Website | If the contact is a vendor/partner, this column displays the vendor/partner's website address (for example, www.deltek.com). |
| Create User | This column displays the user ID of the person who created the contact record in the Contact Info Center. |
| Create Date | This column displays the date on which the contact record was created. |
| Modify User | This column displays the user ID of the person who most recently modified the contact record. |
| Modify Date | This column displays the date on which the contact record was most recently modified. |
| Contact Notes | This column displays the text entered in the Notes field on the General tab of the Contact Info Center. |
| Customer Memo | If the contact is a customer, this column displays the text entered in the Notes field on the General tab of the Customer Info Center for the customer. |
| Vendor/Partner Specialty Desc | If the contact is a vendor/partner, this column displays the description of the vendor/partner's business specialty, or any other information related to the vendor/partner, as specified on the vendor/partner record. |