Export (0) Print
Expand All

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

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

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.

Community Additions

Show:
© 2014 Microsoft