Opportunity Summary Columns Tab

Use the Columns tab to select the columns to display on the Opportunity Summary report, 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 Opportunity List. Refer to the help topics for the Opportunity 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 following are the columns listed in the Column Name field in the grid on the Columns tab that you can add to the Opportunity Summary report.

Field	Description
Name	This column displays the name of the opportunity.
Number	This column displays the opportunity identifier.
Description	This column displays the description of the opportunity.
Contract	If you created a contract record from the opportunity record, this column displays the contract number and name.
Promotional Contract	If you created a promotional contract record from the opportunity record to track and bill charges for proposal generation, this column displays the promotional contract number and name.
Customer	This column displays the name of the primary customer associated with the opportunity.
Team	If you use teams in GovWin Capture Management, this column displays the identifier for the team that is responsible for pursuing the opportunity.
Est. Revenue	This column displays the estimated revenue you expect to earn from the opportunity.
Probability	This column displays the probability that the opportunity will become a contract. For example, if that probability is 80%, this column displays 80.
Weighted Revenue	This column displays the weighted revenue for the opportunity: estimated revenue x probability / 100.
Est. Start Date	This column displays the date you expect to begin work if you are awarded the contract.
Est. Completion Date	This column displays the date you expect to complete the work if you are awarded the contract.
Type	This column displays the type of the opportunity (for example, Educational, Municipal, or Medical).
Stage	This column displays the current stage of the opportunity (for example, Pending, Proposal Submitted, or Awarded).
Source	This column displays the source of the opportunity (for example, Customer Referral, Consultant Job, or Marketing Campaign).
Open Date	This column displays the date on which you identified the opportunity and began pursuing the job
Closed Reason	This is a drop-down list that lists pre-defined reasons why the opportunity closed. The options in the list are defined in the code tables found in Configuration.
Close Date	This column displays the date on which you closed the opportunity (for example, the date you stopped pursuing the opportunity or the date you were awarded the job).
Closed Notes	This is a memo field that you can use to fill in any description that relates to the closing of the opportunity.
Days Open	This column displays the number of days the opportunity has been open. For a closed opportunity, this column displays the number of days from the date it was opened to the date it was closed.
Location	This column displays the city, state, zip code, and country in which the opportunity is located.
Team Grid - Employee	This column displays the name of the employee associated with the opportunity.
Team Grid - Title (Employee)	This column displays the employee's job title or job function.
Team Grid - Role (Employee)	This column displays the employee's role in the opportunity (for example, Lead Architect or Structural Engineer).
Team Grid - Role Description (Employee)	This column displays additional information about the employee's role in the opportunity.
Team Grid - Vendor/Partner	This column displays the name of the vendor/partner or consultant working on the opportunity
Team Grid - Role (Vendor/Partner)	This column displays the vendor/partner's role in the opportunity (for example, Surveying, Printing, or Security).
Customers - Name	This column displays the name of the customer associated with the opportunity.
Customers - Role	This column displays the customer's role in the opportunity (for example, Owner, Developer, or Partner).
Customers - Address Description	This column displays the street address, city, state, and ZIP code of the customer. It also displays the description of the address (for example, Company Headquarters or Northeast Sales Office).
Contacts - Contact	This column displays the name of the contact associated with the opportunity using the format Last Name, First Name.
Contacts - Customer	This column displays the name of the customer associated with the contact.
Contacts - Role	This column displays the contact's role in the opportunity (for example, Owner or Capture Manager).
Contacts - Phone	This column displays the contact's business telephone number.
Activities - Completed	The activity can be Pending or Completed.
Activities - Start Date	This column displays the date and time that the activity is scheduled to begin.
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 - Priority	This column displays the priority ranking that indicates the relative importance of individual activities: High, Medium, or Low.
Activities - Owner	This column displays the name of the employee who is responsible for the activity.
Activities - Customer Contact	This column displays the name of the customer contact associated with the activity.
Activities - Customer Contact Bus. Phone	This column displays the customer contact's work telephone number.
Activities - Vendor/Partner	This column displays the name of the vendor/partner associated with the activity
Activities - Vendor/Partner Contact	This column displays the name of the vendor/partner contact associated with the activity.
Activities - Vendor/Partner Contact Bus. Phone	This column displays the vendor/partner contact's work telephone number.
Activities - Contract	This column displays the name of the contract associated with the activity.
Activities - Lead	This column displays the lead associated with the activity.
Activities - Location	This column displays the location where the activity occurred or will occur.
Activities - Notes	This column displays additional text that describes the activity.
Proposals - Name	This column displays the name of the proposal.
Proposals - Number	This column displays the proposal identifier.
Proposals - Type	This column displays the proposal type (for example, Draft Proposal or Technical Proposal).
Proposals - Status	This column displays the status of the proposal (for example, Pending, Won, Lost, Go/No Go, or Delayed).
Proposals - Submit Date	This column displays the actual date on which you submitted the proposal or expect to submit it.
Proposals - Due Date	This column displays the date by which you must submit the proposal.
Proposals - Award Date	This column displays the date on which your firm was awarded the contract for the proposed job.
Proposals - Fee	This column displays the fee associated with the proposal.
Proposals - Linked SF330	If you have created an SF330 proposal, this column displays the name of the SF330 proposal linked to the opportunity.
Contract Codes - Code	This column displays the contract code associated with the opportunity. Contract codes enable you to identify the types of work or stages of work that you expect to perform and to enter estimated fees for each one.
Contract Codes - SF330 Code	This column displays the SF330 code for the project code.
Contract Codes - Description	This column displays the description of the contract code.
Contract Codes - Fee	This column displays the estimated fee for the work that the contract code represents.
Marketing Campaigns - Name	This column displays the name of the marketing campaign associated with the opportunity.
Marketing Campaigns - Number	This column displays the identifier for the marketing campaign associated with the opportunity.
Master Contract	This column displays the master contract that is associated with the opportunity.
Duration	This column displays the total expected duration of the contract (for example, 1 year base plus 4 x 1 year option).
Competition Columns	If you selected the Competition check box in the Report Sections To Include section on the General tab of the Opportunity Summary Options dialog box, the following competition fields from the Competition tab in the Opportunities Info Center display in the Column Name field on the Columns tab. Select a column to add it to the report. Competition - Incumbent Competition - Name Competition - Notes Competition - Strengths Competition - Weaknesses