Opportunity Entity Metadata
[Applies to: Microsoft Dynamics CRM 2011]
The following information is for the opportunity entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class for this entity is Opportunity.
To view the entity metadata for your organization, install the Metadata Browser solution described in Browse the Metadata for Your Organization.
In This Topic
Entity Metadata
Privilege Metadata
Attribute Metadata
One-to-Many Relationships
Many-to-Many Relationships
Many-to-One Relationships
Entity Metadata
The following table shows the metadata for the opportunity entity.
Metadata property | Value |
---|---|
OTC |
3 |
EntityLogicalName |
opportunity |
DisplayName |
Opportunity |
OwnershipType |
UserOwned |
IsCustomizable |
True |
IsAvailableOffline |
True |
IsAuditEnabled |
False |
Description |
Potential revenue-generating event, or sale to an account, which needs to be tracked through a sales process to completion. |
AutoRouteToOwnerQueue |
False |
CanBeInManyToMany |
True |
CanBePrimaryEntityInRelationship |
True |
CanBeRelatedEntityInRelationship |
True |
CanCreateAttributes |
True |
CanCreateCharts |
True |
CanCreateForms |
True |
CanCreateViews |
True |
CanModifyAdditionalSettings |
True |
CanTriggerWorkflow |
True |
IsActivity |
False |
IsActivityParty |
True |
IsChildEntity |
False |
IsConnectionsEnabled |
canmodifyconnectionsettings |
IsCustomEntity |
False |
IsDocumentManagementEnabled |
True |
IsDuplicateDetectionEnabled |
True |
IsEnabledForCharts |
True |
IsImportable |
True |
IsIntersect |
False |
IsMailMergeEnabled |
True |
IsManaged |
True |
IsMappable |
True |
IsReadingPaneEnabled |
True |
IsRenameable |
True |
IsValidForAdvancedFind |
True |
IsValidForQueue |
False |
IsVisibleInMobile |
True |
PrimaryIdAttribute |
opportunityid |
PrimaryNameAttribute |
name |
ReportViewName |
FilteredOpportunity |
RecurrenceBaseEntityLogicalName |
x |
DisplayCollectionName |
Opportunities |
Privilege Metadata
The following table shows the privilege information for the opportunity entity.
PrivilegeName | Id | Type | CanBeBasic | CanBeDeep | CanBeGlobal | CanBeLocal |
---|---|---|---|---|---|---|
prvAppendOpportunity |
a2420282-24de-424b-8997-8d316091e310 |
Append |
True |
True |
True |
True |
prvAppendToOpportunity |
dae65da8-e481-410d-bfcc-16c37f894604 |
AppendTo |
True |
True |
True |
True |
prvAssignOpportunity |
8a4862a1-c88a-4be9-9a60-1e6d9258fa52 |
Assign |
True |
True |
True |
True |
prvCreateOpportunity |
6b882c27-9ed7-467f-be0f-213a605e0a13 |
Create |
True |
True |
True |
True |
prvDeleteOpportunity |
ec005ba2-ad88-4b96-962c-23bbeb41d2e1 |
Delete |
True |
True |
True |
True |
prvOverridePriceEngineOpportunity |
0fe2f754-3531-4670-8a8d-b3d7eb49321e |
None |
True |
True |
True |
True |
prvReadOpportunity |
f7767f74-628d-48b3-a79f-9c6e24fedb69 |
Read |
True |
True |
True |
True |
prvShareOpportunity |
240edd9b-83e1-46b4-aa25-576ad3c75186 |
Share |
True |
True |
True |
True |
prvWriteOpportunity |
eeeb5856-3f80-4886-8ae2-456ad9141244 |
Write |
True |
True |
True |
True |
Attribute Metadata
The following table shows the attribute metadata for the opportunity entity. For a list of attributes that are for internal use only, see Internal Attributes.
LogicalName | Description | Type | SchemaName | IsCustomAttribute | IsCustomizable | RequiredLevel | IsValidForCreate | IsValidForRead | IsValidForUpdate | CanBeSecuredForCreate | CanBeSecuredForRead | CanBeSecuredForUpdate | IsAuditEnabled | IsManaged | IsPrimaryId | IsPrimaryName | IsRenameable | IsSecured | IsValidForAdvancedFind | DisplayName | DeprecatedVersion |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
accountid |
Unique identifier of the account with which the opportunity is associated. |
Lookup |
AccountId |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
False |
False |
False |
Account |
|
actualclosedate |
Date when the opportunity was closed. |
DateTime |
ActualCloseDate |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Actual Close Date |
|
actualvalue |
Actual revenue for the opportunity. |
Money |
ActualValue |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Actual Revenue |
|
actualvalue_base |
Base currency equivalent of the actual revenue for the opportunity. |
Money |
ActualValue_Base |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Actual Revenue (Base) |
|
budgetamount |
Information about the budget amount of the lead's company or organization. |
Money |
BudgetAmount |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Budget Amount |
|
budgetamount_base |
Base currency equivalent of the estimated Budget of the lead. |
Money |
BudgetAmount_Base |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Budget Amount (Base) |
|
budgetstatus |
Information about the budget status of the lead's company or organization. |
Picklist |
BudgetStatus |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Budget |
|
campaignid |
Unique identifier for the source campaign associated with the opportunity. |
Lookup |
CampaignId |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Source Campaign |
|
captureproposalfeedback |
Information about whether proposal feedback was captured for the opportunity. |
Boolean |
CaptureProposalFeedback |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Proposal Feedback Captured |
|
closeprobability |
Likelihood of closing the opportunity. |
Integer |
CloseProbability |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Probability |
|
completefinalproposal |
Information about whether a final proposal was completed for the opportunity. |
Boolean |
CompleteFinalProposal |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Final Proposal Ready |
|
completeinternalreview |
Information about whether an internal review was completed for the opportunity. |
Boolean |
CompleteInternalReview |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Complete Internal Review |
|
confirminterest |
Information about whether the lead confirmed interest in our offerings. |
Boolean |
ConfirmInterest |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Confirm Interest |
|
contactid |
Unique identifier of the contact associated with the opportunity. |
Lookup |
ContactId |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
False |
False |
False |
Contact |
|
createdby |
Unique identifier of the user who created the opportunity. |
Lookup |
CreatedBy |
False |
True |
None |
False |
True |
False |
False |
False |
False |
False |
True |
False |
False |
True |
False |
True |
Created By |
|
createdon |
Date and time when the opportunity was created. |
DateTime |
CreatedOn |
False |
True |
None |
False |
True |
False |
False |
False |
False |
False |
True |
False |
False |
True |
False |
True |
Created On |
|
createdonbehalfby |
Unique identifier of the delegate user who created the opportunity. |
Lookup |
CreatedOnBehalfBy |
False |
True |
None |
False |
True |
False |
False |
False |
False |
False |
True |
False |
False |
True |
False |
True |
Created By (Delegate) |
|
currentsituation |
Information about the current situation of the company or organization associated with the opportunity. |
Memo |
CurrentSituation |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Current Situation |
|
customerid |
Unique identifier of the account or contact associated with the opportunity. |
Customer |
CustomerId |
False |
True |
Recommended |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Potential Customer |
|
customerneed |
Information about customer needs. |
Memo |
CustomerNeed |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Customer Need |
|
customerpainpoints |
Information about the pain points faced by the company or organization associated with the opportunity. |
Memo |
CustomerPainPoints |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Customer Pain Points |
|
decisionmaker |
Information about whether the lead is a decision maker. |
Boolean |
DecisionMaker |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Decision Maker? |
|
description |
Description of the opportunity. |
Memo |
Description |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Description |
|
developproposal |
Information about whether a proposal was developed for the opportunity. |
Boolean |
DevelopProposal |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Develop Proposal |
|
discountamount |
Discount specified as a monetary amount for the opportunity. |
Money |
DiscountAmount |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Opportunity Discount Amount |
|
discountamount_base |
Base currency equivalent of the discount specified as a monetary amount for the opportunity. |
Money |
DiscountAmount_Base |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Opportunity Discount Amount (Base) |
|
discountpercentage |
Discount specified as a percentage for the opportunity. |
Decimal |
DiscountPercentage |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Opportunity Discount (%) |
|
estimatedclosedate |
Estimated date on which the opportunity is expected to close. |
DateTime |
EstimatedCloseDate |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Est. Close Date |
|
estimatedvalue |
Estimated value of the opportunity. |
Money |
EstimatedValue |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Est. Revenue |
|
estimatedvalue_base |
Base currency equivalent of the estimated value of the opportunity. |
Money |
EstimatedValue_Base |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Est. Revenue (Base) |
|
evaluatefit |
Information about whether the fit between the lead's needs and our offerings was evaluated. |
Boolean |
EvaluateFit |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Evaluate Fit |
|
exchangerate |
Exchange rate for the currency associated with the opportunity with respect to the base currency. |
Decimal |
ExchangeRate |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Exchange Rate |
|
filedebrief |
Information about whether debriefing notes were filed for the opportunity. |
Boolean |
FileDebrief |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
File Debrief |
|
finaldecisiondate |
Final decision date for the opportunity. |
DateTime |
FinalDecisionDate |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Final Decision Date |
|
freightamount |
Cost of freight for the opportunity. |
Money |
FreightAmount |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Freight Amount |
|
freightamount_base |
Base currency equivalent of the cost of freight for the opportunity |
Money |
FreightAmount_Base |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Freight Amount (Base) |
|
identifycompetitors |
Identify Competitors |
Boolean |
IdentifyCompetitors |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Identify Competitors |
|
identifycustomercontacts |
Identify Customer Contacts |
Boolean |
IdentifyCustomerContacts |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Identify Customer Contacts |
|
identifypursuitteam |
Identify Pursuit Team |
Boolean |
IdentifyPursuitTeam |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Identify Pursuit Team |
|
importsequencenumber |
Unique identifier of the data import or data migration that created this record. |
Integer |
ImportSequenceNumber |
False |
True |
None |
True |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Import Sequence Number |
|
initialcommunication |
Information about whether initial communication was established. |
Picklist |
InitialCommunication |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Initial Communication |
|
isprivate |
Indicates whether the opportunity is private or visible to the entire organization. |
Boolean |
IsPrivate |
False |
False |
None |
False |
False |
False |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
Is Private |
|
isrevenuesystemcalculated |
Specifies whether estimated revenue is to be calculated by the system or provided by the user. |
Boolean |
IsRevenueSystemCalculated |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Revenue |
|
modifiedby |
Unique identifier of the user who last modified the opportunity. |
Lookup |
ModifiedBy |
False |
True |
None |
False |
True |
False |
False |
False |
False |
False |
True |
False |
False |
True |
False |
True |
Modified By |
|
modifiedon |
Date and time when the opportunity was last modified. |
DateTime |
ModifiedOn |
False |
True |
None |
False |
True |
False |
False |
False |
False |
False |
True |
False |
False |
True |
False |
True |
Modified On |
|
modifiedonbehalfby |
Unique identifier of the delegate user who last modified the opportunity. |
Lookup |
ModifiedOnBehalfBy |
False |
True |
None |
False |
True |
False |
False |
False |
False |
False |
True |
False |
False |
True |
False |
True |
Modified By (Delegate) |
|
name |
Name of the opportunity. |
String |
Name |
False |
True |
ApplicationRequired |
True |
True |
True |
False |
False |
False |
True |
True |
False |
True |
True |
False |
True |
Topic |
|
need |
Information about the needs of the lead's company or organization. |
Picklist |
Need |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Need |
|
opportunityid |
Unique identifier of the opportunity. |
Uniqueidentifier |
OpportunityId |
False |
True |
SystemRequired |
True |
True |
False |
False |
False |
False |
False |
True |
True |
False |
True |
False |
True |
Opportunity |
|
opportunityratingcode |
Quality of the opportunity, such as hot. |
Picklist |
OpportunityRatingCode |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Rating |
|
originatingleadid |
Unique identifier of the lead that originated the opportunity. |
Lookup |
OriginatingLeadId |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Originating Lead |
|
overriddencreatedon |
Date and time that the record was migrated. |
DateTime |
OverriddenCreatedOn |
False |
True |
None |
True |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Record Created On |
|
ownerid |
Unique identifier of the user or team who owns the opportunity. |
Owner |
OwnerId |
False |
True |
SystemRequired |
True |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Owner |
|
owningbusinessunit |
Unique identifier of the business unit that owns the opportunity. |
Lookup |
OwningBusinessUnit |
False |
True |
None |
False |
True |
False |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
Owning Business Unit |
|
owningteam |
Unique identifier of the team who owns the opportunity. |
Lookup |
OwningTeam |
False |
True |
None |
False |
True |
False |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
Owning Team |
|
owninguser |
Unique identifier of the user who owns the opportunity. |
Lookup |
OwningUser |
False |
True |
None |
False |
True |
False |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
Owning User |
|
parentaccountid |
Account that is matched to the opportunity. |
Lookup |
ParentAccountId |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
False |
False |
True |
Account |
|
parentcontactid |
Contact that is matched to the opportunity. |
Lookup |
ParentContactId |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
False |
False |
True |
Contact |
|
participatesinworkflow |
Information about whether the opportunity participates in workflow rules. |
Boolean |
ParticipatesInWorkflow |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
False |
False |
False |
Participates in Workflow |
|
presentfinalproposal |
Present Final Proposal |
Boolean |
PresentFinalProposal |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Present Final Proposal |
|
presentproposal |
Information about whether a final proposal was presented for the opportunity. |
Boolean |
PresentProposal |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Presented Proposal |
|
pricelevelid |
Unique identifier of the price list associated with the opportunity. |
Lookup |
PriceLevelId |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Price List |
|
pricingerrorcode |
Pricing error for the opportunity. |
Picklist |
PricingErrorCode |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
False |
False |
False |
Pricing Error |
|
prioritycode |
Priority of the opportunity. |
Picklist |
PriorityCode |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
False |
Priority |
|
proposedsolution |
Information about a proposed solution. |
Memo |
ProposedSolution |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Proposed Solution |
|
purchaseprocess |
Information about the purchase process of the lead's company or organization. |
Picklist |
PurchaseProcess |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Purchase Process |
|
purchasetimeframe |
Information about the purchase time frame of the opportunity's company or organization. |
Picklist |
PurchaseTimeframe |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Purchase Timeframe |
|
pursuitdecision |
Information about whether a Go/No-Go decision was made for the opportunity. |
Boolean |
PursuitDecision |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Decide Go/No-Go |
|
qualificationcomments |
Comments about the qualification of the lead. |
Memo |
QualificationComments |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Qualification Comments |
|
quotecomments |
Comments about quotes associated with the opportunity. |
Memo |
QuoteComments |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Quote Comments |
|
resolvefeedback |
Information about whether proposal feedback was resolved for the opportunity. |
Boolean |
ResolveFeedback |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Feedback Resolved |
|
salesstage |
Sales stage of the opportunity. |
Picklist |
SalesStage |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Sales Stage |
|
salesstagecode |
Customizable code that represents the current stage of an opportunity in a manual sales process. Designed to support manual sales processes upgraded from earlier versions of Microsoft Dynamics CRM. |
Picklist |
SalesStageCode |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Process Code |
|
schedulefollowup_prospect |
Information about whether a prospecting follow up meeting was scheduled with the lead. |
DateTime |
ScheduleFollowup_Prospect |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Scheduled Follow up (Prospect) |
|
schedulefollowup_qualify |
Information about whether a qualifying follow up meeting was scheduled with the lead. |
DateTime |
ScheduleFollowup_Qualify |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Scheduled Follow up (Qualify) |
|
scheduleproposalmeeting |
Information about whether a proposal meeting was scheduled for the opportunity. |
DateTime |
ScheduleProposalMeeting |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Schedule Proposal Meeting |
|
sendthankyounote |
Information about whether a thank you note was sent to the opportunity. |
Boolean |
SendThankYouNote |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Send Thank You Note |
|
statecode |
Status of the opportunity. |
State |
StateCode |
False |
True |
SystemRequired |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Status |
|
statuscode |
Reason for the status of the opportunity. |
Status |
StatusCode |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Status Reason |
|
stepid |
Unique identifier of the step in the sales process. |
Uniqueidentifier |
StepId |
False |
True |
None |
True |
True |
True |
False |
False |
False |
False |
True |
False |
False |
True |
False |
False |
Step |
|
stepname |
Current phase in the sales pipeline for the opportunity. Designed to be updated by using workflows. |
String |
StepName |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Pipeline Phase |
|
timeline |
Timeline |
Picklist |
TimeLine |
False |
True |
None |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Timeline |
|
timezoneruleversionnumber |
For internal use only. |
Integer |
TimeZoneRuleVersionNumber |
False |
True |
None |
True |
True |
True |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
Time Zone Rule Version Number |
|
totalamount |
Total amount for the opportunity. |
Money |
TotalAmount |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Total Amount |
|
totalamount_base |
Base currency equivalent of the total amount for the opportunity. |
Money |
TotalAmount_Base |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Total Amount (Base) |
|
totalamountlessfreight |
Total amount minus the freight charges for the opportunity. |
Money |
TotalAmountLessFreight |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Total Pre-Freight Amount |
|
totalamountlessfreight_base |
Base currency equivalent of the total amount minus the freight charges for the opportunity. |
Money |
TotalAmountLessFreight_Base |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Total Pre-Freight Amount (Base) |
|
totaldiscountamount |
Total discount for the opportunity. |
Money |
TotalDiscountAmount |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Total Discount Amount |
|
totaldiscountamount_base |
Base currency equivalent of the total discount for the opportunity. |
Money |
TotalDiscountAmount_Base |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Total Discount Amount (Base) |
|
totallineitemamount |
Total line item amount for the opportunity. |
Money |
TotalLineItemAmount |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Total Detail Amount |
|
totallineitemamount_base |
Base currency equivalent of the total line item amount for the opportunity. |
Money |
TotalLineItemAmount_Base |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Total Detail Amount (Base) |
|
totallineitemdiscountamount |
Total line item discount for the opportunity. |
Money |
TotalLineItemDiscountAmount |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Total Line Item Discount Amount |
|
totallineitemdiscountamount_base |
Base currency equivalent of the total line item discount for the opportunity. |
Money |
TotalLineItemDiscountAmount_Base |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Total Line Item Discount Amount (Base) |
|
totaltax |
Total tax for the opportunity. |
Money |
TotalTax |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Total Tax |
|
totaltax_base |
Base currency equivalent of the total tax for the opportunity. |
Money |
TotalTax_Base |
False |
True |
None |
False |
True |
False |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Total Tax (Base) |
|
transactioncurrencyid |
Unique identifier of the currency associated with the opportunity. |
Lookup |
TransactionCurrencyId |
False |
True |
ApplicationRequired |
True |
True |
True |
False |
False |
False |
True |
True |
False |
False |
True |
False |
True |
Currency |
|
utcconversiontimezonecode |
Time zone code that was in use when the record was created. |
Integer |
UTCConversionTimeZoneCode |
False |
True |
None |
True |
True |
True |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
UTC Conversion Time Zone Code |
|
versionnumber |
Version number of the opportunity. |
BigInt |
VersionNumber |
False |
False |
None |
False |
True |
False |
False |
False |
False |
False |
True |
False |
False |
False |
False |
False |
Version Number |
Internal Attributes
The following table contains the attributes that are intended for internal use only, if you have the Microsoft Dynamics CRM December 2012 Service Update without Product Updates installed or you have Microsoft Dynamics CRM 2011 Update Rollup 12 installed. For more information, see Updated User Experience for Sales and Customer Service and Product Update Functionality.
Attribute logical name |
---|
budgetamount |
budgetamount_base |
budgetstatus |
captureproposalfeedback |
completefinalproposal |
completeinternalreview |
confirminterest |
currentsituation |
customerid |
customerneed |
customerpainpoints |
decisionmaker |
developproposal |
evaluatefit |
filedebrief |
finaldecisiondate |
identifycompetitors |
identifycustomercontacts |
identifypursuitteam |
initialcommunication |
need |
parentaccountid |
parentcontactid |
presentfinalproposal |
presentproposal |
proposedsolution |
purchaseprocess |
purchasetimeframe |
pursuitdecision |
qualificationcomments |
quotecomments |
resolvefeedback |
salesstage |
schedulefollowup_prospect |
schedulefollowup_qualify |
scheduleproposalmeeting |
sendthankyounote |
timeline |
One-to-Many Relationships
The following table shows the entities that are the referencing entity in a one-to-many relationship with the opportunity entity.
Relationship schema name | Referencing Entity |
---|---|
CreatedOpportunity_BulkOperationLogs |
bulkoperationlog |
lead_qualifying_opportunity |
lead |
opportunity_activity_parties |
activityparty |
Opportunity_ActivityPointers |
activitypointer |
Opportunity_Annotation |
annotation |
Opportunity_Appointments |
appointment |
Opportunity_AsyncOperations |
asyncoperation |
Opportunity_BulkDeleteFailures |
bulkdeletefailure |
opportunity_connections1 |
connection |
opportunity_connections2 |
connection |
opportunity_customer_opportunity_roles |
customeropportunityrole |
Opportunity_DuplicateBaseRecord |
duplicaterecord |
Opportunity_DuplicateMatchingRecord |
duplicaterecord |
Opportunity_Emails |
|
Opportunity_Faxes |
fax |
opportunity_invoices |
invoice |
Opportunity_Letters |
letter |
Opportunity_OpportunityClose |
opportunityclose |
Opportunity_Phonecalls |
phonecall |
opportunity_PostFollows |
postfollow |
opportunity_PostRegardings |
postregarding |
opportunity_PostRoles |
postrole |
opportunity_principalobjectattributeaccess |
principalobjectattributeaccess |
Opportunity_ProcessSessions |
processsession |
opportunity_quotes |
quote |
Opportunity_RecurringAppointmentMasters |
recurringappointmentmaster |
opportunity_sales_orders |
salesorder |
Opportunity_ServiceAppointments |
serviceappointment |
Opportunity_SharepointDocumentLocation |
sharepointdocumentlocation |
Opportunity_Tasks |
task |
product_opportunities |
opportunityproduct |
userentityinstancedata_opportunity |
userentityinstancedata |
Many-to-Many Relationships
The following table shows the many-to-many relationships for the opportunity entity.
Relationship schema name | Entity 1 | Entity 2 | Intersect entity |
---|---|---|---|
opportunitycompetitors_association |
opportunity |
competitor |
opportunitycompetitors |
For information about using intersect entities, see Retrieve Records for Many-To-Many Relationships Using Intersect Entities.
Many-to-One Relationships
The following table shows the entities that are the referenced entity in a many-to-one relationship with the opportunity entity.
Relationship schema name | ReferencedEntity |
---|---|
business_unit_opportunities |
businessunit |
campaign_opportunities |
campaign |
lk_opportunity_createdonbehalfby |
systemuser |
lk_opportunity_modifiedonbehalfby |
systemuser |
lk_opportunitybase_createdby |
systemuser |
lk_opportunitybase_modifiedby |
systemuser |
opportunity_customer_accounts |
account |
opportunity_customer_contacts |
contact |
opportunity_originating_lead |
lead |
opportunity_owning_user |
systemuser |
opportunity_parent_account |
account |
opportunity_parent_contact |
contact |
owner_opportunitys |
owner |
price_level_opportunties |
pricelevel |
team_opportunities |
team |
transactioncurrency_opportunity |
transactioncurrency |
See Also
Reference
EntityMetadata
AttributeMetadata
OneToManyRelationshipMetadata
ManyToManyRelationshipMetadata
Concepts
Opportunity Entity Messages and Methods
Opportunity Entity OptionSet Attribute Metadata
Opportunity Entity Privileges
Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.