Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Potential revenue-generating event, or sale to an account, which needs to be tracked through a sales process to completion.
Messages
The following table lists the messages for the Opportunity table. Messages represent operations that can be performed on the table. They may also be events.
| Name Is Event? |
Web API Operation | SDK for .NET |
|---|---|---|
AssignEvent: True |
PATCH /opportunities(opportunityid)Update the ownerid property. |
AssignRequest |
AssociateEvent: True |
Associate records | Associate records |
CalculateActualValueOpportunityEvent: False |
CalculateActualValueOpportunity action | CalculateActualValueOpportunityRequest |
CreateEvent: True |
POST /opportunitiesSee Create |
Create records |
CreateMultipleEvent: True |
CreateMultiple | CreateMultipleRequest |
DeleteEvent: True |
DELETE /opportunities(opportunityid)See Delete |
Delete records |
DisassociateEvent: True |
Disassociate records | Disassociate records |
GetQuantityDecimalEvent: False |
GetQuantityDecimal function | GetQuantityDecimalRequest |
GrantAccessEvent: True |
GrantAccess | GrantAccessRequest |
IsValidStateTransitionEvent: False |
IsValidStateTransition | IsValidStateTransitionRequest |
LoseOpportunityEvent: True |
LoseOpportunity action | LoseOpportunityRequest |
ModifyAccessEvent: True |
ModifyAccess | ModifyAccessRequest |
RestoreEvent: True |
Restore | Learn to use messages with the SDK for .NET |
RetrieveEvent: True |
GET /opportunities(opportunityid)See Retrieve |
Retrieve records |
RetrieveMultipleEvent: True |
GET /opportunitiesSee Query data |
Query data |
RetrievePrincipalAccessEvent: True |
RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccessEvent: True |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccessEvent: True |
RevokeAccess | RevokeAccessRequest |
RollupEvent: False |
Rollup | RollupRequest |
SetStateEvent: True |
PATCH /opportunities(opportunityid)Update the statecode and statuscode properties. |
SetStateRequest |
UpdateEvent: True |
PATCH /opportunities(opportunityid)See Update |
Update records |
UpdateMultipleEvent: True |
UpdateMultiple | UpdateMultipleRequest |
UpsertEvent: False |
PATCH /opportunities(opportunityid)See Upsert a table row |
UpsertRequest |
UpsertMultipleEvent: False |
UpsertMultiple | UpsertMultipleRequest |
WinOpportunityEvent: True |
WinOpportunity action | WinOpportunityRequest |
WinQuoteEvent: True |
WinQuote action | WinQuoteRequest |
Events
The following table lists the events for the Opportunity table. Events are messages that exist so that you can subscribe to them. Unless you added the event, you shouldn't invoke the message, only subscribe to it.
| Name | Web API Operation | SDK for .NET |
|---|---|---|
CalculatePrice |
CalculatePrice | CalculatePriceRequest |
Properties
The following table lists selected properties for the Opportunity table.
| Property | Value |
|---|---|
| DisplayName | Opportunity |
| DisplayCollectionName | Opportunities |
| SchemaName | Opportunity |
| CollectionSchemaName | Opportunities |
| EntitySetName | opportunities |
| LogicalName | opportunity |
| LogicalCollectionName | opportunities |
| PrimaryIdAttribute | opportunityid |
| PrimaryNameAttribute | name |
| TableType | Standard |
| OwnershipType | UserOwned |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- ActualCloseDate
- ActualValue
- BudgetAmount
- BudgetStatus
- CampaignId
- CaptureProposalFeedback
- CloseProbability
- CompleteFinalProposal
- CompleteInternalReview
- ConfirmInterest
- CurrentSituation
- CustomerId
- CustomerIdType
- CustomerNeed
- CustomerPainPoints
- DecisionMaker
- Description
- DevelopProposal
- DiscountAmount
- DiscountPercentage
- EmailAddress
- EstimatedCloseDate
- EstimatedValue
- EvaluateFit
- FileDebrief
- FinalDecisionDate
- FreightAmount
- IdentifyCompetitors
- IdentifyCustomerContacts
- IdentifyPursuitTeam
- ImportSequenceNumber
- InitialCommunication
- IsRevenueSystemCalculated
- LastOnHoldTime
- msdyn_forecastcategory
- msdyn_gdproptout
- msdyn_OpportunityGrade
- msdyn_opportunitykpiid
- msdyn_OpportunityScore
- msdyn_OpportunityScoreTrend
- msdyn_PredictiveScoreId
- msdyn_ScoreHistory
- msdyn_ScoreReasons
- msdyn_segmentid
- msdyn_similaropportunities
- Name
- Need
- OpportunityId
- OpportunityRatingCode
- OriginatingLeadId
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- ParentAccountId
- ParentContactId
- ParticipatesInWorkflow
- PresentFinalProposal
- PresentProposal
- PriceLevelId
- PricingErrorCode
- PriorityCode
- ProcessId
- ProposedSolution
- PurchaseProcess
- PurchaseTimeframe
- PursuitDecision
- QualificationComments
- QuoteComments
- ResolveFeedback
- SalesStage
- SalesStageCode
- ScheduleFollowup_Prospect
- ScheduleFollowup_Qualify
- ScheduleProposalMeeting
- SendThankYouNote
- SkipPriceCalculation
- SLAId
- StageId
- StateCode
- StatusCode
- StepId
- StepName
- TeamsFollowed
- TimeLine
- TimeZoneRuleVersionNumber
- TotalAmount
- TotalAmountLessFreight
- TotalDiscountAmount
- TotalLineItemAmount
- TotalLineItemDiscountAmount
- TotalTax
- TransactionCurrencyId
- TraversedPath
- UTCConversionTimeZoneCode
ActualCloseDate
| Property | Value |
|---|---|
| Description | Shows the date and time when the opportunity was closed or canceled. |
| DisplayName | Actual Close Date |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | actualclosedate |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | DateOnly |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ActualValue
| Property | Value |
|---|---|
| Description | Type the actual revenue amount for the opportunity for reporting and analysis of estimated versus actual sales. Field defaults to the Est. Revenue value when an opportunity is won. |
| DisplayName | Actual Revenue |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | actualvalue |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 1000000000000 |
| MinValue | -1000000000000 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
BudgetAmount
| Property | Value |
|---|---|
| Description | Type a value between 0 and 1,000,000,000,000 to indicate the lead's potential available budget. |
| DisplayName | Budget amount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | budgetamount |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 1000000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
BudgetStatus
| Property | Value |
|---|---|
| Description | Select the likely budget status for the lead's company. This may help determine the lead rating or your sales approach. |
| DisplayName | Budget |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | budgetstatus |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | budgetstatus |
BudgetStatus Choices/Options
| Value | Label |
|---|---|
| 0 | No Committed Budget |
| 1 | May Buy |
| 2 | Can Buy |
| 3 | Will Buy |
CampaignId
| Property | Value |
|---|---|
| Description | Shows the campaign that the opportunity was created from. The ID is used for tracking the success of the campaign. |
| DisplayName | Source Campaign |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | campaignid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | campaign |
CaptureProposalFeedback
| Property | Value |
|---|---|
| Description | Choose whether the proposal feedback has been captured for the opportunity. |
| DisplayName | Proposal Feedback Captured |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | captureproposalfeedback |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | opportunity_captureproposalfeedback |
| DefaultValue | False |
| True Label | No |
| False Label | Yes |
CloseProbability
| Property | Value |
|---|---|
| Description | Type a number from 0 to 100 that represents the likelihood of closing the opportunity. This can aid the sales team in their efforts to convert the opportunity in a sale. |
| DisplayName | Probability |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | closeprobability |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 100 |
| MinValue | 0 |
CompleteFinalProposal
| Property | Value |
|---|---|
| Description | Select whether a final proposal has been completed for the opportunity. |
| DisplayName | Final Proposal Ready |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | completefinalproposal |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | opportunity_completefinalproposal |
| DefaultValue | False |
| True Label | Completed |
| False Label | Mark complete |
CompleteInternalReview
| Property | Value |
|---|---|
| Description | Select whether an internal review has been completed for this opportunity. |
| DisplayName | Complete Internal Review |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | completeinternalreview |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | opportunity_completeinternalreview |
| DefaultValue | False |
| True Label | Completed |
| False Label | Mark complete |
ConfirmInterest
| Property | Value |
|---|---|
| Description | Select whether the lead confirmed interest in your offerings. This helps in determining the lead quality and the probability of it turning into an opportunity. |
| DisplayName | Confirm Interest |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | confirminterest |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | confirminterest |
| DefaultValue | False |
| True Label | No |
| False Label | Yes |
CurrentSituation
| Property | Value |
|---|---|
| Description | Type notes about the company or organization associated with the opportunity. |
| DisplayName | Current Situation |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | currentsituation |
| RequiredLevel | None |
| Type | Memo |
| Format | TextArea |
| FormatName | TextArea |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 2000 |
CustomerId
| Property | Value |
|---|---|
| Description | Select the customer account or contact to provide a quick link to additional customer details, such as address, phone number, activities, and orders. |
| DisplayName | Potential Customer |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | customerid |
| RequiredLevel | ApplicationRequired |
| Type | Customer |
| Targets | account, contact |
CustomerIdType
| Property | Value |
|---|---|
| Description | |
| DisplayName | Potential Customer Type |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | customeridtype |
| RequiredLevel | ApplicationRequired |
| Type | EntityName |
CustomerNeed
| Property | Value |
|---|---|
| Description | Type some notes about the customer's requirements, to help the sales team identify products and services that could meet their requirements. |
| DisplayName | Customer Need |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | customerneed |
| RequiredLevel | None |
| Type | Memo |
| Format | TextArea |
| FormatName | TextArea |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 2000 |
CustomerPainPoints
| Property | Value |
|---|---|
| Description | Type notes about the customer's pain points to help the sales team identify products and services that could address these pain points. |
| DisplayName | Customer Pain Points |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | customerpainpoints |
| RequiredLevel | None |
| Type | Memo |
| Format | TextArea |
| FormatName | TextArea |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 2000 |
DecisionMaker
| Property | Value |
|---|---|
| Description | Select whether your notes include information about who makes the purchase decisions at the lead's company. |
| DisplayName | Decision Maker? |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | decisionmaker |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | decisionmaker |
| DefaultValue | False |
| True Label | completed |
| False Label | mark complete |
Description
| Property | Value |
|---|---|
| Description | Type additional information to describe the opportunity, such as possible products to sell or past purchases from the customer. |
| DisplayName | Description |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | description |
| RequiredLevel | None |
| Type | Memo |
| Format | TextArea |
| FormatName | TextArea |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 2000 |
DevelopProposal
| Property | Value |
|---|---|
| Description | Select whether a proposal has been developed for the opportunity. |
| DisplayName | Develop Proposal |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | developproposal |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | opportunity_developproposal |
| DefaultValue | False |
| True Label | Completed |
| False Label | Mark complete |
DiscountAmount
| Property | Value |
|---|---|
| Description | Type the discount amount for the opportunity if the customer is eligible for special savings. |
| DisplayName | Opportunity Discount Amount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | discountamount |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 1000000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
DiscountPercentage
| Property | Value |
|---|---|
| Description | Type the discount rate that should be applied to the Product Totals field to include additional savings for the customer in the opportunity. |
| DisplayName | Opportunity Discount (%) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | discountpercentage |
| RequiredLevel | None |
| Type | Decimal |
| ImeMode | Disabled |
| MaxValue | 100 |
| MinValue | 0 |
| Precision | 2 |
| SourceTypeMask | 0 |
EmailAddress
| Property | Value |
|---|---|
| Description | The primary email address for the entity. |
| DisplayName | Email Address |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | emailaddress |
| RequiredLevel | None |
| Type | String |
| Format | |
| FormatName | |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
EstimatedCloseDate
| Property | Value |
|---|---|
| Description | Enter the expected closing date of the opportunity to help make accurate revenue forecasts. |
| DisplayName | Est. close date |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | estimatedclosedate |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | DateOnly |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
EstimatedValue
| Property | Value |
|---|---|
| Description | Type the estimated revenue amount to indicate the potential sale or value of the opportunity for revenue forecasting. This field can be either system-populated or editable based on the selection in the Revenue field. |
| DisplayName | Est. revenue |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | estimatedvalue |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 1000000000000 |
| MinValue | -1000000000000 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
EvaluateFit
| Property | Value |
|---|---|
| Description | Select whether the fit between the lead's requirements and your offerings was evaluated. |
| DisplayName | Evaluate Fit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | evaluatefit |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | evaluatefit |
| DefaultValue | False |
| True Label | No |
| False Label | Yes |
FileDebrief
| Property | Value |
|---|---|
| Description | Choose whether the sales team has recorded detailed notes on the proposals and the account's responses. |
| DisplayName | File Debrief |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | filedebrief |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | opportunity_filedebrief |
| DefaultValue | False |
| True Label | Completed |
| False Label | Mark complete |
FinalDecisionDate
| Property | Value |
|---|---|
| Description | Enter the date and time when the final decision of the opportunity was made. |
| DisplayName | Final Decision Date |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | finaldecisiondate |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | DateOnly |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
FreightAmount
| Property | Value |
|---|---|
| Description | Type the cost of freight or shipping for the products included in the opportunity for use in calculating the Total Amount field. |
| DisplayName | Freight Amount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | freightamount |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 1000000000000 |
| MinValue | 0 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
IdentifyCompetitors
| Property | Value |
|---|---|
| Description | Select whether information about competitors is included. |
| DisplayName | Identify Competitors |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | identifycompetitors |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | identifycompetitors |
| DefaultValue | False |
| True Label | completed |
| False Label | mark complete |
IdentifyCustomerContacts
| Property | Value |
|---|---|
| Description | Select whether the customer contacts for this opportunity have been identified. |
| DisplayName | Identify Customer Contacts |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | identifycustomercontacts |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | identifycustomercontacts |
| DefaultValue | False |
| True Label | completed |
| False Label | mark complete |
IdentifyPursuitTeam
| Property | Value |
|---|---|
| Description | Choose whether you have recorded who will pursue the opportunity. |
| DisplayName | Identify Sales Team |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | identifypursuitteam |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | identifypursuitteam |
| DefaultValue | False |
| True Label | completed |
| False Label | mark complete |
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Sequence number of the import that created this record. |
| DisplayName | Import Sequence Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | importsequencenumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
InitialCommunication
| Property | Value |
|---|---|
| Description | Choose whether someone from the sales team contacted this lead earlier. |
| DisplayName | Initial Communication |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | initialcommunication |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | initialcommunication |
InitialCommunication Choices/Options
| Value | Label |
|---|---|
| 0 | Contacted |
| 1 | Not Contacted |
IsRevenueSystemCalculated
| Property | Value |
|---|---|
| Description | Select whether the estimated revenue for the opportunity is calculated automatically based on the products entered or entered manually by a user. |
| DisplayName | Revenue |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | isrevenuesystemcalculated |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | opportunity_isrevenuesystemcalculated |
| DefaultValue | False |
| True Label | System Calculated |
| False Label | User Provided |
LastOnHoldTime
| Property | Value |
|---|---|
| Description | Contains the date time stamp of the last on hold time. |
| DisplayName | Last On Hold Time |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | lastonholdtime |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
msdyn_forecastcategory
| Property | Value |
|---|---|
| Description | Categories used for forecasting. |
| DisplayName | Forecast category |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_forecastcategory |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 100000001 |
| GlobalChoiceName | msdyn_opportunity_msdyn_forecastcategory |
msdyn_forecastcategory Choices/Options
| Value | Label |
|---|---|
| 100000001 | Pipeline |
| 100000002 | Best case |
| 100000003 | Committed |
| 100000004 | Omitted |
| 100000005 | Won |
| 100000006 | Lost |
msdyn_gdproptout
| Property | Value |
|---|---|
| Description | Describes whether opportunity is opted out or not |
| DisplayName | GDPR Optout |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_gdproptout |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | msdyn_opportunity_msdyn_gdproptout |
| DefaultValue | False |
| True Label | Yes |
| False Label | No |
msdyn_OpportunityGrade
| Property | Value |
|---|---|
| Description | |
| DisplayName | (Deprecated) Opportunity Grade |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_opportunitygrade |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | msdyn_opportunitygradeoptset |
msdyn_OpportunityGrade Choices/Options
| Value | Label |
|---|---|
| 0 | Grade A |
| 1 | Grade B |
| 2 | Grade C |
| 3 | Grade D |
msdyn_opportunitykpiid
| Property | Value |
|---|---|
| Description | Maps to opportunity KPI records |
| DisplayName | KPI |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_opportunitykpiid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | msdyn_opportunitykpiitem |
msdyn_OpportunityScore
| Property | Value |
|---|---|
| Description | |
| DisplayName | (Deprecated) Opportunity Score |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_opportunityscore |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
msdyn_OpportunityScoreTrend
| Property | Value |
|---|---|
| Description | |
| DisplayName | (Deprecated) Opportunity Score Trend |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_opportunityscoretrend |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | msdyn_opportunityscoretrendoptset |
msdyn_OpportunityScoreTrend Choices/Options
| Value | Label |
|---|---|
| 0 | Improving |
| 1 | Steady |
| 2 | Declining |
| 3 | Not enough info |
msdyn_PredictiveScoreId
| Property | Value |
|---|---|
| Description | Predictive score |
| DisplayName | Predictive Score |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_predictivescoreid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | msdyn_predictivescore |
msdyn_ScoreHistory
| Property | Value |
|---|---|
| Description | |
| DisplayName | (Deprecated) Score History |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_scorehistory |
| RequiredLevel | None |
| Type | Memo |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 2000 |
msdyn_ScoreReasons
| Property | Value |
|---|---|
| Description | |
| DisplayName | (Deprecated) Score Reasons |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_scorereasons |
| RequiredLevel | None |
| Type | Memo |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 2000 |
msdyn_segmentid
| Property | Value |
|---|---|
| Description | Unique identifier for Segment associated with Opportunity. |
| DisplayName | Segment Id |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_segmentid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | msdyn_segment |
msdyn_similaropportunities
| Property | Value |
|---|---|
| Description | |
| DisplayName | msdyn_similaropportunities |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | msdyn_similaropportunities |
| RequiredLevel | None |
| Type | Memo |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 65536 |
Name
| Property | Value |
|---|---|
| Description | Type a subject or descriptive name, such as the expected order or company name, for the opportunity. |
| DisplayName | Topic |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | name |
| RequiredLevel | ApplicationRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 300 |
Need
| Property | Value |
|---|---|
| Description | Choose how high the level of need is for the lead's company. |
| DisplayName | Need |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | need |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | need |
Need Choices/Options
| Value | Label |
|---|---|
| 0 | Must have |
| 1 | Should have |
| 2 | Good to have |
| 3 | No need |
OpportunityId
| Property | Value |
|---|---|
| Description | Unique identifier of the opportunity. |
| DisplayName | Opportunity |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | opportunityid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
OpportunityRatingCode
| Property | Value |
|---|---|
| Description | Select the expected value or priority of the opportunity based on revenue, customer status, or closing probability. |
| DisplayName | Rating |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | opportunityratingcode |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 2 |
| GlobalChoiceName | opportunity_opportunityratingcode |
OpportunityRatingCode Choices/Options
| Value | Label |
|---|---|
| 1 | Hot |
| 2 | Warm |
| 3 | Cold |
OriginatingLeadId
| Property | Value |
|---|---|
| Description | Choose the lead that the opportunity was created from for reporting and analytics. The field is read-only after the opportunity is created and defaults to the correct lead when an opportunity is created from a converted lead. |
| DisplayName | Originating Lead |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | originatingleadid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | lead |
OverriddenCreatedOn
| Property | Value |
|---|---|
| Description | Date and time that the record was migrated. |
| DisplayName | Record Created On |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | overriddencreatedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
OwnerId
| Property | Value |
|---|---|
| Description | Owner Id |
| DisplayName | Owner |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | SystemRequired |
| Type | Owner |
| Targets | systemuser, team |
OwnerIdType
| Property | Value |
|---|---|
| Description | Owner Id Type |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
ParentAccountId
| Property | Value |
|---|---|
| Description | Choose an account to connect this opportunity to, so that the relationship is visible in reports and analytics, and to provide a quick link to additional details, such as financial information and activities. |
| DisplayName | Account |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | parentaccountid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | account |
ParentContactId
| Property | Value |
|---|---|
| Description | Choose a contact to connect this opportunity to, so that the relationship is visible in reports and analytics. |
| DisplayName | Contact |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | parentcontactid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | contact |
ParticipatesInWorkflow
| Property | Value |
|---|---|
| Description | Information about whether the opportunity participates in workflow rules. |
| DisplayName | Participates in Workflow |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | participatesinworkflow |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | opportunity_participatesinworkflow |
| DefaultValue | False |
| True Label | Yes |
| False Label | No |
PresentFinalProposal
| Property | Value |
|---|---|
| Description | Select whether the final proposal has been presented to the account. |
| DisplayName | Present Final Proposal |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | presentfinalproposal |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | identifypursuitteam |
| DefaultValue | False |
| True Label | completed |
| False Label | mark complete |
PresentProposal
| Property | Value |
|---|---|
| Description | Select whether a proposal for the opportunity has been presented to the account. |
| DisplayName | Presented Proposal |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | presentproposal |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | opportunity_presentproposal |
| DefaultValue | False |
| True Label | Completed |
| False Label | Mark complete |
PriceLevelId
| Property | Value |
|---|---|
| Description | Choose the price list associated with this record to make sure the products associated with the campaign are offered at the correct prices. |
| DisplayName | Price List |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | pricelevelid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | pricelevel |
PricingErrorCode
| Property | Value |
|---|---|
| Description | Pricing error for the opportunity. |
| DisplayName | Pricing Error |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | pricingerrorcode |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 0 |
| GlobalChoiceName | qooi_pricingerrorcode |
PricingErrorCode Choices/Options
| Value | Label |
|---|---|
| 0 | None |
| 1 | Detail Error |
| 2 | Missing Price Level |
| 3 | Inactive Price Level |
| 4 | Missing Quantity |
| 5 | Missing Unit Price |
| 6 | Missing Product |
| 7 | Invalid Product |
| 8 | Missing Pricing Code |
| 9 | Invalid Pricing Code |
| 10 | Missing UOM |
| 11 | Product Not In Price Level |
| 12 | Missing Price Level Amount |
| 13 | Missing Price Level Percentage |
| 14 | Missing Price |
| 15 | Missing Current Cost |
| 16 | Missing Standard Cost |
| 17 | Invalid Price Level Amount |
| 18 | Invalid Price Level Percentage |
| 19 | Invalid Price |
| 20 | Invalid Current Cost |
| 21 | Invalid Standard Cost |
| 22 | Invalid Rounding Policy |
| 23 | Invalid Rounding Option |
| 24 | Invalid Rounding Amount |
| 25 | Price Calculation Error |
| 26 | Invalid Discount Type |
| 27 | Discount Type Invalid State |
| 28 | Invalid Discount |
| 29 | Invalid Quantity |
| 30 | Invalid Pricing Precision |
| 31 | Missing Product Default UOM |
| 32 | Missing Product UOM Schedule |
| 33 | Inactive Discount Type |
| 34 | Invalid Price Level Currency |
| 35 | Price Attribute Out Of Range |
| 36 | Base Currency Attribute Overflow |
| 37 | Base Currency Attribute Underflow |
| 38 | Transaction currency is not set for the product price list item |
PriorityCode
| Property | Value |
|---|---|
| Description | Select the priority so that preferred customers or critical issues are handled quickly. |
| DisplayName | Priority |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | prioritycode |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 1 |
| GlobalChoiceName | opportunity_prioritycode |
PriorityCode Choices/Options
| Value | Label |
|---|---|
| 1 | Default Value |
ProcessId
| Property | Value |
|---|---|
| Description | Contains the id of the process associated with the entity. |
| DisplayName | Process Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | processid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
ProposedSolution
| Property | Value |
|---|---|
| Description | Type notes about the proposed solution for the opportunity. |
| DisplayName | Proposed Solution |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | proposedsolution |
| RequiredLevel | None |
| Type | Memo |
| Format | TextArea |
| FormatName | TextArea |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 2000 |
PurchaseProcess
| Property | Value |
|---|---|
| Description | Choose whether an individual or a committee will be involved in the purchase process for the lead. |
| DisplayName | Purchase Process |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | purchaseprocess |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | purchaseprocess |
PurchaseProcess Choices/Options
| Value | Label |
|---|---|
| 0 | Individual |
| 1 | Committee |
| 2 | Unknown |
PurchaseTimeframe
| Property | Value |
|---|---|
| Description | Choose how long the lead will likely take to make the purchase. |
| DisplayName | Purchase Timeframe |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | purchasetimeframe |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | purchasetimeframe |
PurchaseTimeframe Choices/Options
| Value | Label |
|---|---|
| 0 | Immediate |
| 1 | This Quarter |
| 2 | Next Quarter |
| 3 | This Year |
| 4 | Unknown |
PursuitDecision
| Property | Value |
|---|---|
| Description | Select whether the decision about pursuing the opportunity has been made. |
| DisplayName | Decide Go/No-Go |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | pursuitdecision |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | opportunity_pursuitdecision |
| DefaultValue | False |
| True Label | No |
| False Label | Yes |
QualificationComments
| Property | Value |
|---|---|
| Description | Type comments about the qualification or scoring of the lead. |
| DisplayName | Qualification Comments |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | qualificationcomments |
| RequiredLevel | None |
| Type | Memo |
| Format | TextArea |
| FormatName | TextArea |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 2000 |
QuoteComments
| Property | Value |
|---|---|
| Description | Type comments about the quotes associated with the opportunity. |
| DisplayName | Quote Comments |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | quotecomments |
| RequiredLevel | None |
| Type | Memo |
| Format | TextArea |
| FormatName | TextArea |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 2000 |
ResolveFeedback
| Property | Value |
|---|---|
| Description | Choose whether the proposal feedback has been captured and resolved for the opportunity. |
| DisplayName | Feedback Resolved |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | resolvefeedback |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | opportunity_resolvefeedback |
| DefaultValue | False |
| True Label | No |
| False Label | Yes |
SalesStage
| Property | Value |
|---|---|
| Description | Select the sales stage of this opportunity to aid the sales team in their efforts to win this opportunity. |
| DisplayName | Sales Stage |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | salesstage |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | opportunity_salesstage |
SalesStage Choices/Options
| Value | Label |
|---|---|
| 0 | Qualify |
| 1 | Develop |
| 2 | Propose |
| 3 | Close |
SalesStageCode
| Property | Value |
|---|---|
| Description | Select the sales process stage for the opportunity to indicate the probability of closing the opportunity. |
| DisplayName | Process Code |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | salesstagecode |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 1 |
| GlobalChoiceName | opportunity_salesstagecode |
SalesStageCode Choices/Options
| Value | Label |
|---|---|
| 1 | Default Value |
ScheduleFollowup_Prospect
| Property | Value |
|---|---|
| Description | Enter the date and time of the prospecting follow-up meeting with the lead. |
| DisplayName | Scheduled Follow up (Prospect) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | schedulefollowup_prospect |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ScheduleFollowup_Qualify
| Property | Value |
|---|---|
| Description | Enter the date and time of the qualifying follow-up meeting with the lead. |
| DisplayName | Scheduled Follow up (Qualify) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | schedulefollowup_qualify |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ScheduleProposalMeeting
| Property | Value |
|---|---|
| Description | Enter the date and time of the proposal meeting for the opportunity. |
| DisplayName | Schedule Proposal Meeting |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | scheduleproposalmeeting |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateOnly |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
SendThankYouNote
| Property | Value |
|---|---|
| Description | Select whether a thank you note has been sent to the account for considering the proposal. |
| DisplayName | Send Thank You Note |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | sendthankyounote |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | opportunity_sendthankyounote |
| DefaultValue | False |
| True Label | Completed |
| False Label | Mark complete |
SkipPriceCalculation
| Property | Value |
|---|---|
| Description | Skip Price Calculation (For Internal Use) |
| DisplayName | Skip Price Calculation |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | skippricecalculation |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | 0 |
| GlobalChoiceName | qooi_skippricecalculation |
SkipPriceCalculation Choices/Options
| Value | Label |
|---|---|
| 0 | DoPriceCalcAlways |
| 1 | SkipPriceCalcOnRetrieve |
SLAId
| Property | Value |
|---|---|
| Description | Choose the service level agreement (SLA) that you want to apply to the opportunity record. |
| DisplayName | SLA |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | slaid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | sla |
StageId
| Property | Value |
|---|---|
| Description | Contains the id of the stage where the entity is located. |
| DisplayName | (Deprecated) Stage Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | stageid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
StateCode
| Property | Value |
|---|---|
| Description | Shows whether the opportunity is open, won, or lost. Won and lost opportunities are read-only and can't be edited until they are reactivated. |
| DisplayName | Status |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
| DefaultFormValue | 0 |
| GlobalChoiceName | opportunity_statecode |
StateCode Choices/Options
| Value | Details |
|---|---|
| 0 | Label: Open DefaultStatus: 1 InvariantName: Open |
| 1 | Label: Won DefaultStatus: 3 InvariantName: Won |
| 2 | Label: Lost DefaultStatus: 4 InvariantName: Lost |
StatusCode
| Property | Value |
|---|---|
| Description | Select the opportunity's status. |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
| DefaultFormValue | -1 |
| GlobalChoiceName | opportunity_statuscode |
StatusCode Choices/Options
| Value | Details |
|---|---|
| 1 | Label: In Progress State:0 TransitionData: None |
| 2 | Label: On Hold State:0 TransitionData: None |
| 3 | Label: Won State:1 TransitionData: None |
| 4 | Label: Canceled State:2 TransitionData: None |
| 5 | Label: Out-Sold State:2 TransitionData: None |
StepId
| Property | Value |
|---|---|
| Description | Shows the ID of the workflow step. |
| DisplayName | Step |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | stepid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
StepName
| Property | Value |
|---|---|
| Description | Shows the current phase in the sales pipeline for the opportunity. |
| DisplayName | Pipeline Phase |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | stepname |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 200 |
TeamsFollowed
| Property | Value |
|---|---|
| Description | Number of users or conversations followed the record |
| DisplayName | TeamsFollowed |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | teamsfollowed |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
TimeLine
| Property | Value |
|---|---|
| Description | Select when the opportunity is likely to be closed. |
| DisplayName | Timeline |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | timeline |
| RequiredLevel | None |
| Type | Picklist |
| DefaultFormValue | -1 |
| GlobalChoiceName | opportunity_timeline |
TimeLine Choices/Options
| Value | Label |
|---|---|
| 0 | Immediate |
| 1 | This Quarter |
| 2 | Next Quarter |
| 3 | This Year |
| 4 | Not known |
TimeZoneRuleVersionNumber
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Time Zone Rule Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timezoneruleversionnumber |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
TotalAmount
| Property | Value |
|---|---|
| Description | Shows the total amount due, calculated as the sum of the products, discounts, freight, and taxes for the opportunity. |
| DisplayName | Total Amount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | totalamount |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
TotalAmountLessFreight
| Property | Value |
|---|---|
| Description | Shows the total product amount for the opportunity, minus any discounts. This value is added to freight and tax amounts in the calculation for the total amount of the opportunity. |
| DisplayName | Total Pre-Freight Amount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | totalamountlessfreight |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
TotalDiscountAmount
| Property | Value |
|---|---|
| Description | Shows the total discount amount, based on the discount price and rate entered on the opportunity. |
| DisplayName | Total Discount Amount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | totaldiscountamount |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
TotalLineItemAmount
| Property | Value |
|---|---|
| Description | Shows the sum of all existing and write-in products included on the opportunity, based on the specified price list and quantities. |
| DisplayName | Total Detail Amount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | totallineitemamount |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
TotalLineItemDiscountAmount
| Property | Value |
|---|---|
| Description | Shows the total of the Manual Discount amounts specified on all products included in the opportunity. This value is reflected in the Total Detail Amount field on the opportunity and is added to any discount amount or rate specified on the opportunity. |
| DisplayName | Total Line Item Discount Amount |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | totallineitemdiscountamount |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 2 |
| PrecisionSource | 0 (Precision property) |
TotalTax
| Property | Value |
|---|---|
| Description | Shows the total of the Tax amounts specified on all products included in the opportunity, included in the Total Amount field calculation for the opportunity. |
| DisplayName | Total Tax |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | totaltax |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | False |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 2 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
TransactionCurrencyId
| Property | Value |
|---|---|
| Description | Choose the local currency for the record to make sure budgets are reported in the correct currency. |
| DisplayName | Currency |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | transactioncurrencyid |
| RequiredLevel | ApplicationRequired |
| Type | Lookup |
| Targets | transactioncurrency |
TraversedPath
| Property | Value |
|---|---|
| Description | A comma separated list of string values representing the unique identifiers of stages in a Business Process Flow Instance in the order that they occur. |
| DisplayName | (Deprecated) Traversed Path |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | traversedpath |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1250 |
UTCConversionTimeZoneCode
| Property | Value |
|---|---|
| Description | Time zone code that was in use when the record was created. |
| DisplayName | UTC Conversion Time Zone Code |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | utcconversiontimezonecode |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -1 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
- AccountId
- ActualValue_Base
- BudgetAmount_Base
- ContactId
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- CustomerIdName
- CustomerIdYomiName
- DiscountAmount_Base
- EstimatedValue_Base
- ExchangeRate
- FreightAmount_Base
- IsPrivate
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- OnHoldTime
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- SLAInvokedId
- TimeSpentByMeOnEmailAndMeetings
- TotalAmount_Base
- TotalAmountLessFreight_Base
- TotalDiscountAmount_Base
- TotalLineItemAmount_Base
- TotalLineItemDiscountAmount_Base
- TotalTax_Base
- VersionNumber
AccountId
| Property | Value |
|---|---|
| Description | Internal attribute for storing customerid. Do not use this attribute directly; use parentaccountid instead. |
| DisplayName | Account |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | accountid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | account |
ActualValue_Base
| Property | Value |
|---|---|
| Description | Value of the Actual Revenue in base currency. |
| DisplayName | Actual Revenue (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | actualvalue_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
BudgetAmount_Base
| Property | Value |
|---|---|
| Description | Value of the Budget Amount in base currency. |
| DisplayName | Budget Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | budgetamount_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
ContactId
| Property | Value |
|---|---|
| Description | Internal attribute for storing customerid. Do not use this attribute directly; use parentcontactid instead. |
| DisplayName | Contact |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | contactid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | contact |
CreatedBy
| Property | Value |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
CreatedOn
| Property | Value |
|---|---|
| Description | Date and time when the record was created. |
| DisplayName | Created On |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
CreatedOnBehalfBy
| Property | Value |
|---|---|
| Description | Shows who created the record on behalf of another user. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
CustomerIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | customeridname |
| RequiredLevel | ApplicationRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 160 |
CustomerIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | customeridyominame |
| RequiredLevel | ApplicationRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 450 |
DiscountAmount_Base
| Property | Value |
|---|---|
| Description | Value of the Opportunity Discount Amount in base currency. |
| DisplayName | Opportunity Discount Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | discountamount_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
EstimatedValue_Base
| Property | Value |
|---|---|
| Description | Value of the Est. Revenue in base currency. |
| DisplayName | Est. Revenue (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | estimatedvalue_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
ExchangeRate
| Property | Value |
|---|---|
| Description | Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency. |
| DisplayName | Exchange Rate |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | exchangerate |
| RequiredLevel | None |
| Type | Decimal |
| ImeMode | Disabled |
| MaxValue | 100000000000 |
| MinValue | 1E-12 |
| Precision | 12 |
| SourceTypeMask | 0 |
FreightAmount_Base
| Property | Value |
|---|---|
| Description | Value of the Freight Amount in base currency. |
| DisplayName | Freight Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | freightamount_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
IsPrivate
| Property | Value |
|---|---|
| Description | Indicates whether the opportunity is private or visible to the entire organization. |
| DisplayName | Is Private |
| IsValidForForm | False |
| IsValidForRead | False |
| LogicalName | isprivate |
| RequiredLevel | None |
| Type | Boolean |
| GlobalChoiceName | opportunity_isprivate |
| DefaultValue | False |
| True Label | Yes |
| False Label | No |
ModifiedBy
| Property | Value |
|---|---|
| Description | Shows who last updated the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
ModifiedOn
| Property | Value |
|---|---|
| Description | Date and time when the record was modified. |
| DisplayName | Modified On |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
| CanChangeDateTimeBehavior | False |
| DateTimeBehavior | UserLocal |
| Format | DateAndTime |
| ImeMode | Inactive |
| SourceTypeMask | 0 |
ModifiedOnBehalfBy
| Property | Value |
|---|---|
| Description | Shows who last updated the record on behalf of another user. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
OnHoldTime
| Property | Value |
|---|---|
| Description | Shows the duration in minutes for which the opportunity was on hold. |
| DisplayName | On Hold Time (Minutes) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | onholdtime |
| RequiredLevel | None |
| Type | Integer |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
OwnerIdName
| Property | Value |
|---|---|
| Description | Name of the owner |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
OwnerIdYomiName
| Property | Value |
|---|---|
| Description | Yomi name of the owner |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| RequiredLevel | SystemRequired |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 100 |
OwningBusinessUnit
| Property | Value |
|---|---|
| Description | Unique identifier for the business unit that owns the record |
| DisplayName | Owning Business Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | None |
| Type | Lookup |
| Targets | businessunit |
OwningTeam
| Property | Value |
|---|---|
| Description | Unique identifier for the team that owns the record. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Type | Lookup |
| Targets | team |
OwningUser
| Property | Value |
|---|---|
| Description | Unique identifier for the user that owns the record. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | None |
| Type | Lookup |
| Targets | systemuser |
SLAInvokedId
| Property | Value |
|---|---|
| Description | Last SLA that was applied to this opportunity. This field is for internal use only. |
| DisplayName | Last SLA applied |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | slainvokedid |
| RequiredLevel | None |
| Type | Lookup |
| Targets | sla |
TimeSpentByMeOnEmailAndMeetings
| Property | Value |
|---|---|
| Description | Total time spent for emails (read and write) and meetings by me in relation to the opportunity record. |
| DisplayName | Time Spent by me |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timespentbymeonemailandmeetings |
| RequiredLevel | None |
| Type | String |
| Format | Text |
| FormatName | Text |
| ImeMode | Auto |
| IsLocalizable | False |
| MaxLength | 1250 |
TotalAmount_Base
| Property | Value |
|---|---|
| Description | Value of the Total Amount in base currency. |
| DisplayName | Total Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | totalamount_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
TotalAmountLessFreight_Base
| Property | Value |
|---|---|
| Description | Value of the Total Pre-Freight Amount in base currency. |
| DisplayName | Total Pre-Freight Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | totalamountlessfreight_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
TotalDiscountAmount_Base
| Property | Value |
|---|---|
| Description | Value of the Total Discount Amount in base currency. |
| DisplayName | Total Discount Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | totaldiscountamount_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
TotalLineItemAmount_Base
| Property | Value |
|---|---|
| Description | Value of the Total Detail Amount in base currency. |
| DisplayName | Total Detail Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | totallineitemamount_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
TotalLineItemDiscountAmount_Base
| Property | Value |
|---|---|
| Description | Value of the Total Line Item Discount Amount in base currency. |
| DisplayName | Total Line Item Discount Amount (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | totallineitemdiscountamount_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
TotalTax_Base
| Property | Value |
|---|---|
| Description | Value of the Total Tax in base currency. |
| DisplayName | Total Tax (Base) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | totaltax_base |
| RequiredLevel | None |
| Type | Money |
| ImeMode | Disabled |
| IsBaseCurrency | True |
| MaxValue | 922337203685477 |
| MinValue | -922337203685477 |
| Precision | 4 |
| PrecisionSource | 2 (TransactionCurrency.CurrencyPrecision) |
VersionNumber
| Property | Value |
|---|---|
| Description | Version Number |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| RequiredLevel | None |
| Type | BigInt |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
Many-to-One relationships
These relationships are many-to-one. Listed by SchemaName.
- business_unit_opportunities
- campaign_opportunities
- lk_opportunity_createdonbehalfby
- lk_opportunity_modifiedonbehalfby
- lk_opportunitybase_createdby
- lk_opportunitybase_modifiedby
- manualsla_opportunity
- msdyn_msdyn_opportunitykpiitem_opportunity_opportunitykpiid
- msdyn_msdyn_predictivescore_opportunity
- msdyn_msdyn_segment_opportunity
- opportunity_customer_accounts
- opportunity_customer_contacts
- opportunity_originating_lead
- opportunity_owning_user
- opportunity_parent_account
- opportunity_parent_contact
- owner_opportunitys
- price_level_opportunties
- processstage_opportunity
- sla_opportunity
- team_opportunities
- transactioncurrency_opportunity
business_unit_opportunities
One-To-Many Relationship: businessunit business_unit_opportunities
| Property | Value |
|---|---|
| ReferencedEntity | businessunit |
| ReferencedAttribute | businessunitid |
| ReferencingAttribute | owningbusinessunit |
| ReferencingEntityNavigationPropertyName | owningbusinessunit |
| IsHierarchical | |
| CascadeConfiguration | Archive: RestrictAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
campaign_opportunities
One-To-Many Relationship: campaign campaign_opportunities
| Property | Value |
|---|---|
| ReferencedEntity | campaign |
| ReferencedAttribute | campaignid |
| ReferencingAttribute | campaignid |
| ReferencingEntityNavigationPropertyName | campaignid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_opportunity_createdonbehalfby
One-To-Many Relationship: systemuser lk_opportunity_createdonbehalfby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | createdonbehalfby |
| ReferencingEntityNavigationPropertyName | createdonbehalfby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_opportunity_modifiedonbehalfby
One-To-Many Relationship: systemuser lk_opportunity_modifiedonbehalfby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | modifiedonbehalfby |
| ReferencingEntityNavigationPropertyName | modifiedonbehalfby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_opportunitybase_createdby
One-To-Many Relationship: systemuser lk_opportunitybase_createdby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | createdby |
| ReferencingEntityNavigationPropertyName | createdby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
lk_opportunitybase_modifiedby
One-To-Many Relationship: systemuser lk_opportunitybase_modifiedby
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | modifiedby |
| ReferencingEntityNavigationPropertyName | modifiedby |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
manualsla_opportunity
One-To-Many Relationship: sla manualsla_opportunity
| Property | Value |
|---|---|
| ReferencedEntity | sla |
| ReferencedAttribute | slaid |
| ReferencingAttribute | slaid |
| ReferencingEntityNavigationPropertyName | sla_opportunity_sla |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
msdyn_msdyn_opportunitykpiitem_opportunity_opportunitykpiid
One-To-Many Relationship: msdyn_opportunitykpiitem msdyn_msdyn_opportunitykpiitem_opportunity_opportunitykpiid
| Property | Value |
|---|---|
| ReferencedEntity | msdyn_opportunitykpiitem |
| ReferencedAttribute | msdyn_opportunitykpiitemid |
| ReferencingAttribute | msdyn_opportunitykpiid |
| ReferencingEntityNavigationPropertyName | msdyn_opportunitykpiid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
msdyn_msdyn_predictivescore_opportunity
One-To-Many Relationship: msdyn_predictivescore msdyn_msdyn_predictivescore_opportunity
| Property | Value |
|---|---|
| ReferencedEntity | msdyn_predictivescore |
| ReferencedAttribute | msdyn_predictivescoreid |
| ReferencingAttribute | msdyn_predictivescoreid |
| ReferencingEntityNavigationPropertyName | msdyn_PredictiveScoreId |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
msdyn_msdyn_segment_opportunity
One-To-Many Relationship: msdyn_segment msdyn_msdyn_segment_opportunity
| Property | Value |
|---|---|
| ReferencedEntity | msdyn_segment |
| ReferencedAttribute | msdyn_segmentid |
| ReferencingAttribute | msdyn_segmentid |
| ReferencingEntityNavigationPropertyName | msdyn_segmentid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
opportunity_customer_accounts
One-To-Many Relationship: account opportunity_customer_accounts
| Property | Value |
|---|---|
| ReferencedEntity | account |
| ReferencedAttribute | accountid |
| ReferencingAttribute | customerid |
| ReferencingEntityNavigationPropertyName | customerid_account |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: CascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
opportunity_customer_contacts
One-To-Many Relationship: contact opportunity_customer_contacts
| Property | Value |
|---|---|
| ReferencedEntity | contact |
| ReferencedAttribute | contactid |
| ReferencingAttribute | customerid |
| ReferencingEntityNavigationPropertyName | customerid_contact |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: CascadeDelete: CascadeMerge: CascadeReparent: CascadeRollupView: NoCascadeShare: CascadeUnshare: Cascade |
opportunity_originating_lead
One-To-Many Relationship: lead opportunity_originating_lead
| Property | Value |
|---|---|
| ReferencedEntity | lead |
| ReferencedAttribute | leadid |
| ReferencingAttribute | originatingleadid |
| ReferencingEntityNavigationPropertyName | originatingleadid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: CascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
opportunity_owning_user
One-To-Many Relationship: systemuser opportunity_owning_user
| Property | Value |
|---|---|
| ReferencedEntity | systemuser |
| ReferencedAttribute | systemuserid |
| ReferencingAttribute | owninguser |
| ReferencingEntityNavigationPropertyName | owninguser |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
opportunity_parent_account
One-To-Many Relationship: account opportunity_parent_account
| Property | Value |
|---|---|
| ReferencedEntity | account |
| ReferencedAttribute | accountid |
| ReferencingAttribute | parentaccountid |
| ReferencingEntityNavigationPropertyName | parentaccountid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: CascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
opportunity_parent_contact
One-To-Many Relationship: contact opportunity_parent_contact
| Property | Value |
|---|---|
| ReferencedEntity | contact |
| ReferencedAttribute | contactid |
| ReferencingAttribute | parentcontactid |
| ReferencingEntityNavigationPropertyName | parentcontactid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: CascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
owner_opportunitys
One-To-Many Relationship: owner owner_opportunitys
| Property | Value |
|---|---|
| ReferencedEntity | owner |
| ReferencedAttribute | ownerid |
| ReferencingAttribute | ownerid |
| ReferencingEntityNavigationPropertyName | ownerid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
price_level_opportunties
One-To-Many Relationship: pricelevel price_level_opportunties
| Property | Value |
|---|---|
| ReferencedEntity | pricelevel |
| ReferencedAttribute | pricelevelid |
| ReferencingAttribute | pricelevelid |
| ReferencingEntityNavigationPropertyName | pricelevelid |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
processstage_opportunity
One-To-Many Relationship: processstage processstage_opportunity
| Property | Value |
|---|---|
| ReferencedEntity | processstage |
| ReferencedAttribute | processstageid |
| ReferencingAttribute | stageid |
| ReferencingEntityNavigationPropertyName | stageid_processstage |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
sla_opportunity
One-To-Many Relationship: sla sla_opportunity
| Property | Value |
|---|---|
| ReferencedEntity | sla |
| ReferencedAttribute | slaid |
| ReferencingAttribute | slainvokedid |
| ReferencingEntityNavigationPropertyName | slainvokedid_opportunity_sla |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: RemoveLinkMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
team_opportunities
One-To-Many Relationship: team team_opportunities
| Property | Value |
|---|---|
| ReferencedEntity | team |
| ReferencedAttribute | teamid |
| ReferencingAttribute | owningteam |
| ReferencingEntityNavigationPropertyName | owningteam |
| IsHierarchical | |
| CascadeConfiguration | Archive: NoCascadeAssign: NoCascadeDelete: NoCascadeMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
transactioncurrency_opportunity
One-To-Many Relationship: transactioncurrency transactioncurrency_opportunity
| Property | Value |
|---|---|
| ReferencedEntity | transactioncurrency |
| ReferencedAttribute | transactioncurrencyid |
| ReferencingAttribute | transactioncurrencyid |
| ReferencingEntityNavigationPropertyName | transactioncurrencyid |
| IsHierarchical | |
| CascadeConfiguration | Archive: RestrictAssign: NoCascadeDelete: RestrictMerge: NoCascadeReparent: NoCascadeRollupView: NoCascadeShare: NoCascadeUnshare: NoCascade |
One-to-Many relationships
These relationships are one-to-many. Listed by SchemaName.
- CreatedOpportunity_BulkOperationLogs
- lead_qualifying_opportunity
- lk_leadtoopportunitysalesprocess_opportunityid
- lk_opportunitysalesprocess_opportunityid
- msdyn_activitymapping_opportunity
- msdyn_msdyn_salescopilotinsight_opportunity_msdyn_targetentityid
- msdyn_opportunity_dailyopportunitykpiitem_entityid
- msdyn_opportunity_msdyn_mostcontacted_regardingObjectId
- msdyn_opportunity_msdyn_mostcontactedby_regardingObjectId
- msdyn_opportunity_msdyn_opportunitykpiitem_opportunityid
- msdyn_opportunity_msdyn_salesroutingrun_targetobject
- msdyn_opportunity_msdyn_timespent_opplookup
- msdyn_sabackupdiagnostic_opportunity_msdyn_target
- msdyn_salesagentrun_opportunity
- msdyn_salesroutingdiagnostic_opportunity_msdyn_target
- msdyn_salessuggestion_opportunity_qualifiedrecord
- msdyn_sequencetarget_opportunity_msdyn_target
- msdyn_summarysynthesizerinput_referenceobjectid_opportunity
- msdyn_summarysynthesizeroutput_ReferenceObjectId_opportunity
- opportunity_actioncard
- opportunity_activity_parties
- Opportunity_ActivityPointers
- opportunity_adx_inviteredemptions
- opportunity_adx_portalcomments
- Opportunity_Annotation
- Opportunity_Appointments
- Opportunity_AsyncOperations
- Opportunity_BulkDeleteFailures
- opportunity_chats
- opportunity_connections1
- opportunity_connections2
- Opportunity_DuplicateBaseRecord
- Opportunity_DuplicateMatchingRecord
- Opportunity_Emails
- Opportunity_Faxes
- opportunity_invoices
- Opportunity_Letters
- Opportunity_MailboxTrackingFolder
- opportunity_msdyn_copilottranscripts
- opportunity_msdyn_ocliveworkitems
- opportunity_msdyn_ocsessions
- opportunity_msfp_alerts
- opportunity_msfp_surveyinvites
- opportunity_msfp_surveyresponses
- Opportunity_OpportunityClose
- opportunity_OpportunityCloses
- opportunity_OrderCloses
- Opportunity_Phonecalls
- opportunity_PostFollows
- opportunity_PostRegardings
- opportunity_Posts
- opportunity_principalobjectattributeaccess
- Opportunity_ProcessSessions
- opportunity_QuoteCloses
- opportunity_quotes
- Opportunity_RecurringAppointmentMasters
- opportunity_sales_orders
- Opportunity_ServiceAppointments
- Opportunity_SharepointDocumentLocation
- Opportunity_SocialActivities
- Opportunity_SyncErrors
- Opportunity_Tasks
- opportunity_Teams
- product_opportunities
- slakpiinstance_opportunity
CreatedOpportunity_BulkOperationLogs
Many-To-One Relationship: bulkoperationlog CreatedOpportunity_BulkOperationLogs
| Property | Value |
|---|---|
| ReferencingEntity | bulkoperationlog |
| ReferencingAttribute | createdobjectid |
| ReferencedEntityNavigationPropertyName | CreatedOpportunity_BulkOperationLogs |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
lead_qualifying_opportunity
Many-To-One Relationship: lead lead_qualifying_opportunity
| Property | Value |
|---|---|
| ReferencingEntity | lead |
| ReferencingAttribute | qualifyingopportunityid |
| ReferencedEntityNavigationPropertyName | lead_qualifying_opportunity |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
lk_leadtoopportunitysalesprocess_opportunityid
Many-To-One Relationship: leadtoopportunitysalesprocess lk_leadtoopportunitysalesprocess_opportunityid
| Property | Value |
|---|---|
| ReferencingEntity | leadtoopportunitysalesprocess |
| ReferencingAttribute | opportunityid |
| ReferencedEntityNavigationPropertyName | opportunity_leadtoopportunitysalesprocess |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
lk_opportunitysalesprocess_opportunityid
Many-To-One Relationship: opportunitysalesprocess lk_opportunitysalesprocess_opportunityid
| Property | Value |
|---|---|
| ReferencingEntity | opportunitysalesprocess |
| ReferencingAttribute | opportunityid |
| ReferencedEntityNavigationPropertyName | opportunity_opportunitysalesprocess |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_activitymapping_opportunity
Many-To-One Relationship: msdyn_activitymapping msdyn_activitymapping_opportunity
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_activitymapping |
| ReferencingAttribute | msdyn_regardingobjectid |
| ReferencedEntityNavigationPropertyName | msdyn_activitymapping_opportunity |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_msdyn_salescopilotinsight_opportunity_msdyn_targetentityid
Many-To-One Relationship: msdyn_salescopilotinsight msdyn_msdyn_salescopilotinsight_opportunity_msdyn_targetentityid
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_salescopilotinsight |
| ReferencingAttribute | msdyn_targetentityid |
| ReferencedEntityNavigationPropertyName | msdyn_msdyn_salescopilotinsight_opportunity_msdyn_targetentityid |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_opportunity_dailyopportunitykpiitem_entityid
Many-To-One Relationship: msdyn_dailyopportunitykpiitem msdyn_opportunity_dailyopportunitykpiitem_entityid
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_dailyopportunitykpiitem |
| ReferencingAttribute | msdyn_entityid |
| ReferencedEntityNavigationPropertyName | msdyn_opportunity_dailyopportunitykpiitem_entityid |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_opportunity_msdyn_mostcontacted_regardingObjectId
Many-To-One Relationship: msdyn_mostcontacted msdyn_opportunity_msdyn_mostcontacted_regardingObjectId
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_mostcontacted |
| ReferencingAttribute | msdyn_opportunity_regardingobjectid |
| ReferencedEntityNavigationPropertyName | msdyn_opportunity_msdyn_mostcontacted_regardingObjectId |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_opportunity_msdyn_mostcontactedby_regardingObjectId
Many-To-One Relationship: msdyn_mostcontactedby msdyn_opportunity_msdyn_mostcontactedby_regardingObjectId
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_mostcontactedby |
| ReferencingAttribute | msdyn_opportunity_regardingobjectid |
| ReferencedEntityNavigationPropertyName | msdyn_opportunity_msdyn_mostcontactedby_regardingObjectId |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_opportunity_msdyn_opportunitykpiitem_opportunityid
Many-To-One Relationship: msdyn_opportunitykpiitem msdyn_opportunity_msdyn_opportunitykpiitem_opportunityid
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_opportunitykpiitem |
| ReferencingAttribute | msdyn_opportunityid |
| ReferencedEntityNavigationPropertyName | msdyn_opportunity_msdyn_opportunitykpiitem_opportunityid |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_opportunity_msdyn_salesroutingrun_targetobject
Many-To-One Relationship: msdyn_salesroutingrun msdyn_opportunity_msdyn_salesroutingrun_targetobject
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_salesroutingrun |
| ReferencingAttribute | msdyn_targetobject |
| ReferencedEntityNavigationPropertyName | msdyn_opportunity_msdyn_salesroutingrun_targetobject |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_opportunity_msdyn_timespent_opplookup
Many-To-One Relationship: msdyn_timespent msdyn_opportunity_msdyn_timespent_opplookup
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_timespent |
| ReferencingAttribute | msdyn_opplookup |
| ReferencedEntityNavigationPropertyName | msdyn_opportunity_msdyn_timespent_opplookup |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_sabackupdiagnostic_opportunity_msdyn_target
Many-To-One Relationship: msdyn_sabackupdiagnostic msdyn_sabackupdiagnostic_opportunity_msdyn_target
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_sabackupdiagnostic |
| ReferencingAttribute | msdyn_target |
| ReferencedEntityNavigationPropertyName | msdyn_sabackupdiagnostic_opportunity_msdyn_target |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_salesagentrun_opportunity
Many-To-One Relationship: msdyn_salesagentrun msdyn_salesagentrun_opportunity
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_salesagentrun |
| ReferencingAttribute | msdyn_regardingid |
| ReferencedEntityNavigationPropertyName | msdyn_salesagentrun_opportunity |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_salesroutingdiagnostic_opportunity_msdyn_target
Many-To-One Relationship: msdyn_salesroutingdiagnostic msdyn_salesroutingdiagnostic_opportunity_msdyn_target
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_salesroutingdiagnostic |
| ReferencingAttribute | msdyn_target |
| ReferencedEntityNavigationPropertyName | msdyn_salesroutingdiagnostic_opportunity_msdyn_target |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_salessuggestion_opportunity_qualifiedrecord
Many-To-One Relationship: msdyn_salessuggestion msdyn_salessuggestion_opportunity_qualifiedrecord
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_salessuggestion |
| ReferencingAttribute | msdyn_qualifiedrecord |
| ReferencedEntityNavigationPropertyName | msdyn_salessuggestion_opportunity_qualifiedrecord |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_sequencetarget_opportunity_msdyn_target
Many-To-One Relationship: msdyn_sequencetarget msdyn_sequencetarget_opportunity_msdyn_target
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_sequencetarget |
| ReferencingAttribute | msdyn_target |
| ReferencedEntityNavigationPropertyName | msdyn_sequencetarget_opportunity_msdyn_target |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_summarysynthesizerinput_referenceobjectid_opportunity
Many-To-One Relationship: msdyn_summarysynthesizerinput msdyn_summarysynthesizerinput_referenceobjectid_opportunity
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_summarysynthesizerinput |
| ReferencingAttribute | msdyn_referenceobjectid |
| ReferencedEntityNavigationPropertyName | msdyn_summarysynthesizerinput_referenceobjectid_opportunity |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
msdyn_summarysynthesizeroutput_ReferenceObjectId_opportunity
Many-To-One Relationship: msdyn_summarysynthesizeroutput msdyn_summarysynthesizeroutput_ReferenceObjectId_opportunity
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_summarysynthesizeroutput |
| ReferencingAttribute | msdyn_referenceobjectid |
| ReferencedEntityNavigationPropertyName | msdyn_summarysynthesizeroutput_ReferenceObjectId_opportunity |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 10000 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_actioncard
Many-To-One Relationship: actioncard opportunity_actioncard
| Property | Value |
|---|---|
| ReferencingEntity | actioncard |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_actioncard |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_activity_parties
Many-To-One Relationship: activityparty opportunity_activity_parties
| Property | Value |
|---|---|
| ReferencingEntity | activityparty |
| ReferencingAttribute | partyid |
| ReferencedEntityNavigationPropertyName | opportunity_activity_parties |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Opportunity_ActivityPointers
Many-To-One Relationship: activitypointer Opportunity_ActivityPointers
| Property | Value |
|---|---|
| ReferencingEntity | activitypointer |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_ActivityPointers |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 20 QueryApi: CRMActivity.RollupByPartyViewId: 00000000-0000-0000-00aa-000010001903 |
opportunity_adx_inviteredemptions
Many-To-One Relationship: adx_inviteredemption opportunity_adx_inviteredemptions
| Property | Value |
|---|---|
| ReferencingEntity | adx_inviteredemption |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_adx_inviteredemptions |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_adx_portalcomments
Many-To-One Relationship: adx_portalcomment opportunity_adx_portalcomments
| Property | Value |
|---|---|
| ReferencingEntity | adx_portalcomment |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_adx_portalcomments |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Opportunity_Annotation
Many-To-One Relationship: annotation Opportunity_Annotation
| Property | Value |
|---|---|
| ReferencingEntity | annotation |
| ReferencingAttribute | objectid |
| ReferencedEntityNavigationPropertyName | Opportunity_Annotation |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Opportunity_Appointments
Many-To-One Relationship: appointment Opportunity_Appointments
| Property | Value |
|---|---|
| ReferencingEntity | appointment |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_Appointments |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Opportunity_AsyncOperations
Many-To-One Relationship: asyncoperation Opportunity_AsyncOperations
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_AsyncOperations |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Opportunity_BulkDeleteFailures
Many-To-One Relationship: bulkdeletefailure Opportunity_BulkDeleteFailures
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_BulkDeleteFailures |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_chats
Many-To-One Relationship: chat opportunity_chats
| Property | Value |
|---|---|
| ReferencingEntity | chat |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_chats |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_connections1
Many-To-One Relationship: connection opportunity_connections1
| Property | Value |
|---|---|
| ReferencingEntity | connection |
| ReferencingAttribute | record1id |
| ReferencedEntityNavigationPropertyName | opportunity_connections1 |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 100 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_connections2
Many-To-One Relationship: connection opportunity_connections2
| Property | Value |
|---|---|
| ReferencingEntity | connection |
| ReferencingAttribute | record2id |
| ReferencedEntityNavigationPropertyName | opportunity_connections2 |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 100 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Opportunity_DuplicateBaseRecord
Many-To-One Relationship: duplicaterecord Opportunity_DuplicateBaseRecord
| Property | Value |
|---|---|
| ReferencingEntity | duplicaterecord |
| ReferencingAttribute | baserecordid |
| ReferencedEntityNavigationPropertyName | Opportunity_DuplicateBaseRecord |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Opportunity_DuplicateMatchingRecord
Many-To-One Relationship: duplicaterecord Opportunity_DuplicateMatchingRecord
| Property | Value |
|---|---|
| ReferencingEntity | duplicaterecord |
| ReferencingAttribute | duplicaterecordid |
| ReferencedEntityNavigationPropertyName | Opportunity_DuplicateMatchingRecord |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Opportunity_Emails
Many-To-One Relationship: email Opportunity_Emails
| Property | Value |
|---|---|
| ReferencingEntity | email |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_Emails |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Opportunity_Faxes
Many-To-One Relationship: fax Opportunity_Faxes
| Property | Value |
|---|---|
| ReferencingEntity | fax |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_Faxes |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_invoices
Many-To-One Relationship: invoice opportunity_invoices
| Property | Value |
|---|---|
| ReferencingEntity | invoice |
| ReferencingAttribute | opportunityid |
| ReferencedEntityNavigationPropertyName | opportunity_invoices |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: SalesLabel: MenuId: null Order: 30 QueryApi: CRMInvoice.RetrieveByObjectViewId: a84eb3ff-6dc5-4f57-bbf0-7b664c11fb62 |
Opportunity_Letters
Many-To-One Relationship: letter Opportunity_Letters
| Property | Value |
|---|---|
| ReferencingEntity | letter |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_Letters |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Opportunity_MailboxTrackingFolder
Many-To-One Relationship: mailboxtrackingfolder Opportunity_MailboxTrackingFolder
| Property | Value |
|---|---|
| ReferencingEntity | mailboxtrackingfolder |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_MailboxTrackingFolder |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_msdyn_copilottranscripts
Many-To-One Relationship: msdyn_copilottranscript opportunity_msdyn_copilottranscripts
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_copilottranscript |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_msdyn_copilottranscripts |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: CRMActivity.RollupByPartyViewId: 00000000-0000-0000-00aa-000010001903 |
opportunity_msdyn_ocliveworkitems
Many-To-One Relationship: msdyn_ocliveworkitem opportunity_msdyn_ocliveworkitems
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_ocliveworkitem |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_msdyn_ocliveworkitems |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: CRMActivity.RollupByPartyViewId: 00000000-0000-0000-00aa-000010001903 |
opportunity_msdyn_ocsessions
Many-To-One Relationship: msdyn_ocsession opportunity_msdyn_ocsessions
| Property | Value |
|---|---|
| ReferencingEntity | msdyn_ocsession |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_msdyn_ocsessions |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: CRMActivity.RollupByPartyViewId: 00000000-0000-0000-00aa-000010001903 |
opportunity_msfp_alerts
Many-To-One Relationship: msfp_alert opportunity_msfp_alerts
| Property | Value |
|---|---|
| ReferencingEntity | msfp_alert |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_msfp_alerts |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: CRMActivity.RollupByPartyViewId: 00000000-0000-0000-00aa-000010001903 |
opportunity_msfp_surveyinvites
Many-To-One Relationship: msfp_surveyinvite opportunity_msfp_surveyinvites
| Property | Value |
|---|---|
| ReferencingEntity | msfp_surveyinvite |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_msfp_surveyinvites |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: CRMActivity.RollupByPartyViewId: 00000000-0000-0000-00aa-000010001903 |
opportunity_msfp_surveyresponses
Many-To-One Relationship: msfp_surveyresponse opportunity_msfp_surveyresponses
| Property | Value |
|---|---|
| ReferencingEntity | msfp_surveyresponse |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_msfp_surveyresponses |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: CRMActivity.RollupByPartyViewId: 00000000-0000-0000-00aa-000010001903 |
Opportunity_OpportunityClose
Many-To-One Relationship: opportunityclose Opportunity_OpportunityClose
| Property | Value |
|---|---|
| ReferencingEntity | opportunityclose |
| ReferencingAttribute | opportunityid |
| ReferencedEntityNavigationPropertyName | Opportunity_OpportunityClose |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_OpportunityCloses
Many-To-One Relationship: opportunityclose opportunity_OpportunityCloses
| Property | Value |
|---|---|
| ReferencingEntity | opportunityclose |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_OpportunityCloses |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: CRMActivity.RollupByPartyViewId: 00000000-0000-0000-00aa-000010001903 |
opportunity_OrderCloses
Many-To-One Relationship: orderclose opportunity_OrderCloses
| Property | Value |
|---|---|
| ReferencingEntity | orderclose |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_OrderCloses |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: CRMActivity.RollupByPartyViewId: 00000000-0000-0000-00aa-000010001903 |
Opportunity_Phonecalls
Many-To-One Relationship: phonecall Opportunity_Phonecalls
| Property | Value |
|---|---|
| ReferencingEntity | phonecall |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_Phonecalls |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_PostFollows
Many-To-One Relationship: postfollow opportunity_PostFollows
| Property | Value |
|---|---|
| ReferencingEntity | postfollow |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_PostFollows |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_PostRegardings
Many-To-One Relationship: postregarding opportunity_PostRegardings
| Property | Value |
|---|---|
| ReferencingEntity | postregarding |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_PostRegardings |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_Posts
Many-To-One Relationship: post opportunity_Posts
| Property | Value |
|---|---|
| ReferencingEntity | post |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_Posts |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_principalobjectattributeaccess
Many-To-One Relationship: principalobjectattributeaccess opportunity_principalobjectattributeaccess
| Property | Value |
|---|---|
| ReferencingEntity | principalobjectattributeaccess |
| ReferencingAttribute | objectid |
| ReferencedEntityNavigationPropertyName | opportunity_principalobjectattributeaccess |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Opportunity_ProcessSessions
Many-To-One Relationship: processsession Opportunity_ProcessSessions
| Property | Value |
|---|---|
| ReferencingEntity | processsession |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_ProcessSessions |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: 110 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_QuoteCloses
Many-To-One Relationship: quoteclose opportunity_QuoteCloses
| Property | Value |
|---|---|
| ReferencingEntity | quoteclose |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_QuoteCloses |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: CRMActivity.RollupByPartyViewId: 00000000-0000-0000-00aa-000010001903 |
opportunity_quotes
Many-To-One Relationship: quote opportunity_quotes
| Property | Value |
|---|---|
| ReferencingEntity | quote |
| ReferencingAttribute | opportunityid |
| ReferencedEntityNavigationPropertyName | opportunity_quotes |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: SalesLabel: MenuId: null Order: 10 QueryApi: CRMQuote.RetrieveByObjectViewId: 642095db-91dd-4813-bb31-665a3a2bae61 |
Opportunity_RecurringAppointmentMasters
Many-To-One Relationship: recurringappointmentmaster Opportunity_RecurringAppointmentMasters
| Property | Value |
|---|---|
| ReferencingEntity | recurringappointmentmaster |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_RecurringAppointmentMasters |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_sales_orders
Many-To-One Relationship: salesorder opportunity_sales_orders
| Property | Value |
|---|---|
| ReferencingEntity | salesorder |
| ReferencingAttribute | opportunityid |
| ReferencedEntityNavigationPropertyName | opportunity_sales_orders |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: SalesLabel: MenuId: null Order: 20 QueryApi: CRMSalesOrder.RetrieveByObjectViewId: 71f7da6e-2772-4097-89d1-3670ff8348bb |
Opportunity_ServiceAppointments
Many-To-One Relationship: serviceappointment Opportunity_ServiceAppointments
| Property | Value |
|---|---|
| ReferencingEntity | serviceappointment |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_ServiceAppointments |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Opportunity_SharepointDocumentLocation
Many-To-One Relationship: sharepointdocumentlocation Opportunity_SharepointDocumentLocation
| Property | Value |
|---|---|
| ReferencingEntity | sharepointdocumentlocation |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_SharepointDocumentLocation |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Opportunity_SocialActivities
Many-To-One Relationship: socialactivity Opportunity_SocialActivities
| Property | Value |
|---|---|
| ReferencingEntity | socialactivity |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_SocialActivities |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Opportunity_SyncErrors
Many-To-One Relationship: syncerror Opportunity_SyncErrors
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_SyncErrors |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Opportunity_Tasks
Many-To-One Relationship: task Opportunity_Tasks
| Property | Value |
|---|---|
| ReferencingEntity | task |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | Opportunity_Tasks |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
opportunity_Teams
Many-To-One Relationship: team opportunity_Teams
| Property | Value |
|---|---|
| ReferencingEntity | team |
| ReferencingAttribute | regardingobjectid |
| ReferencedEntityNavigationPropertyName | opportunity_Teams |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionNameGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
product_opportunities
Many-To-One Relationship: opportunityproduct product_opportunities
| Property | Value |
|---|---|
| ReferencingEntity | opportunityproduct |
| ReferencingAttribute | opportunityid |
| ReferencedEntityNavigationPropertyName | product_opportunities |
| IsCustomizable | True |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: 10 QueryApi: CRMOpportunityProduct.RetrieveByObjectViewId: 57e13b8f-1788-4c77-9bd4-427a0f71e986 |
slakpiinstance_opportunity
Many-To-One Relationship: slakpiinstance slakpiinstance_opportunity
| Property | Value |
|---|---|
| ReferencingEntity | slakpiinstance |
| ReferencingAttribute | regarding |
| ReferencedEntityNavigationPropertyName | slakpiinstance_opportunity |
| IsCustomizable | False |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-to-Many relationships
These relationships are many-to-many. Listed by SchemaName.
opportunitycompetitors_association
See competitor opportunitycompetitors_association Many-To-Many Relationship
| Property | Value |
|---|---|
| IntersectEntityName | opportunitycompetitors |
| IsCustomizable | False |
| SchemaName | opportunitycompetitors_association |
| IntersectAttribute | opportunityid |
| NavigationPropertyName | opportunitycompetitors_association |
| AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplayGroup: DetailsLabel: MenuId: null Order: QueryApi: CRMOpportunity.RetrieveByObjectViewId: 00000000-0000-0000-00aa-000010001203 |
See also
Dataverse table/entity reference
Dataverse Web API Reference