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	email
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.