Customer Summary Columns Tab

Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats.

This report can contain two types of sections:

• Default sections — You select the default sections in Report Sections to Include on the General tab. Each default section contains a pre-defined set of columns. You do not select the columns for the default sections. The table below provides descriptions of the columns in the default sections.
• User-defined sections — If you set up user-defined sections for this report, use the Columns tab to select the columns for each of those sections and specify column attributes. The columns available for user-defined columns are the same as those available for the Customer List. Refer to the help topics for the Customer List for descriptions of the columns that you can select for user-defined columns.

You can include both default sections and user-defined sections on the same report.

Contents

The descriptions below are for columns in the default sections. For descriptions of the columns that you can select on the Columns tab for user-defined columns, see Customer List Columns tab.

Field	Description
Customer Name	This column displays the name of the customer.
Customer Number	This column displays the customer identifier.
Address 1, 2, 3, 4	Address 1 displays the customer's name. Address 2, Address 3, and Address 4 display the primary address information (street name and number, suite number, postal box number, and so on).
City, State, Zip	This column displays the city name, two-character state abbreviation, and zip code from the customer's primary address.
Country	This column displays the country from the customer's primary address.
Market	This column displays the market (type) of customer (for example, Commercial, Government, or Non-Profit).
Status	This column displays the status of your relationship with the customer: Active, Dormant, or Inactive.
Phone	This column displays the customer's phone number.
Fax	This column displays the customer's fax number.
Web Site	This column displays the customer's Web site address (for example, www.deltek.com).
Parent	This column displays the name of the customer that is the parent of the customer identified in Customer Name and Customer Number.
Notes	This column displays additional information about the customer.
Description	This column displays the description of the customer address (for example, Company Headquarters, Main Office, or Northeast Office).
Address 1 Address 2 Address 3 Address 4	Address 1 displays the customer's name. Address 2, Address 3, and Address 4 display the address information (street name and number, suite number, postal box number, and so on).
City, State, Zip	This column displays the city name, two-character state abbreviation, and zip code from the customer address.
Country	This column displays the country from the customer address.
Primary	This column contains Y or N (Yes or No) to indicate whether or not the address is the customer's primary address.
Phone	This column displays the phone number for the address.
Fax	This column displays the fax number for the address.
Contacts - Name	This column displays the full name of the contact (Salutation, First Name, Middle Name, Last Name, Suffix).
Contacts - Title	This column displays the contact's title (for example, Vice President or Principal).
Contacts - Phone	This column displays the contact's business phone number.
Contacts - Fax	This column displays the contact's fax number.
Contacts - Mobile	This column displays the contact's mobile (cellular) phone number.
Contacts - Home	This column displays the contact's home phone number.
Contacts - Pager	This column displays the contact's pager number.
Contacts - Email	This column displays the contact's email address.
Activities - Type	This column displays the activity type (for example, Phone Call, Meeting, or Email).
Activities - Subject	This column displays a brief description of the activity (for example, Initial Consultation, Planning Meeting, Customer Lunch, or Follow-up Visit).
Activities - Date	This column displays the date and time that the activity is scheduled to begin.
Activities - Contact	This column displays the contact associated with the activity. The contact can be a participant in the activity, or the activity can be a task your firm undertakes for the contact.
Activities - Notes	This column displays additional information about the activity.
Contracts - Number	This column displays the contract identifier.
Contracts - Name	This column displays the name of the contract.
Contracts - Role	This column displays the role of the customer in the contract (for example, Architect, Developer, or Owner).
Opportunities - Number	This column displays the opportunity identifier.
Opportunities - Name	This column displays the name of the opportunity.
Opportunities - Stage	This column displays the current stage of the opportunity (for example, Pending, Awarded, or Lost).
Opportunities - Weighted Revenue	This column displays the weighted revenue for the opportunity: Estimated revenue x Probability.
Associations - Name (Customer)	This column displays the name of a customer that is associated with the current customer.
Associations - Relationship (Customer)	This column displays a description of the relationship of the current customer to the associated customer (for example, Subsidiary, Parent Company, or Affiliate).
Associations - Description (Customer)	This column displays additional text describing the relationship of the current customer to the associated customer.
Associations - Name (Employee)	This column displays the full name of an employee associated with the customer.
Associations - Relationship (Employee)	This column displays the employee's relationship to the customer (for example, Customer Manager, Contact Manager, or Friend).
Associations - Description (Employee)	This column displays additional text describing the relationship between the customer and the employee.