Opportunity table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Potential revenue-generating event, or sale to an account, which needs to be tracked through a sales process to completion.
Added by: Sales Solution
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
Assign | PATCH /opportunities(opportunityid) Update ownerid property. |
AssignRequest |
CalculateActualValueOpportunity | CalculateActualValueOpportunityRequest | |
CalculatePrice | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
Create | POST /opportunities See Create |
CreateRequest or Create |
CreateMultiple | CreateMultiple | CreateMultipleRequest |
Delete | DELETE /opportunities(opportunityid) See Delete |
DeleteRequest or Delete |
GetQuantityDecimal | GetQuantityDecimalRequest | |
GrantAccess | GrantAccess | GrantAccessRequest |
IsValidStateTransition | IsValidStateTransition | IsValidStateTransitionRequest |
LoseOpportunity | LoseOpportunityRequest | |
ModifyAccess | ModifyAccess | ModifyAccessRequest |
Retrieve | GET /opportunities(opportunityid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET /opportunities See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
RetrievePrincipalAccess | RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess | RevokeAccess | RevokeAccessRequest |
Rollup | Rollup | RollupRequest |
SetState | PATCH /opportunities(opportunityid) Update statecode and statuscode properties. |
SetStateRequest |
Update | PATCH /opportunities(opportunityid) See Update |
UpdateRequest or Update |
UpdateMultiple | UpdateMultiple | UpdateMultipleRequest |
WinOpportunity | WinOpportunityRequest | |
WinQuote | WinQuoteRequest |
Properties
Property | Value |
---|---|
CollectionSchemaName | Opportunities |
DisplayCollectionName | Opportunities |
DisplayName | Opportunity |
EntitySetName | opportunities |
IsBPFEntity | False |
LogicalCollectionName | opportunities |
LogicalName | opportunity |
OwnershipType | UserOwned |
PrimaryIdAttribute | opportunityid |
PrimaryNameAttribute | name |
SchemaName | Opportunity |
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 |
---|---|
DateTimeBehavior | DateOnly |
Description | Shows the date and time when the opportunity was closed or canceled. |
DisplayName | Actual Close Date |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | actualclosedate |
RequiredLevel | None |
Type | DateTime |
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 |
MaxValue | 1000000000000 |
MinValue | -1000000000000 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
MaxValue | 1000000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
BudgetStatus Choices/Options
Value | Label | Description |
---|---|---|
0 | No Committed Budget | |
1 | May Buy | |
2 | Can Buy | |
3 | Will Buy |
CampaignId
Added by: Marketing Sales Solution
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 |
Targets | campaign |
Type | Lookup |
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 |
CaptureProposalFeedback Choices/Options
Value | Label | Description |
---|---|---|
1 | No | |
0 | Yes |
DefaultValue: 0
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 |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | closeprobability |
MaxValue | 100 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
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 |
CompleteFinalProposal Choices/Options
Value | Label | Description |
---|---|---|
1 | Completed | |
0 | Mark complete |
DefaultValue: 0
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 |
CompleteInternalReview Choices/Options
Value | Label | Description |
---|---|---|
1 | Completed | |
0 | Mark complete |
DefaultValue: 0
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 |
ConfirmInterest Choices/Options
Value | Label | Description |
---|---|---|
1 | No | |
0 | Yes |
DefaultValue: 0
CurrentSituation
Property | Value |
---|---|
Description | Type notes about the company or organization associated with the opportunity. |
DisplayName | Current Situation |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | currentsituation |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
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 |
Targets | account,contact |
Type | Customer |
CustomerIdType
Added by: Active Solution Solution
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 |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | customerneed |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
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 |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | customerpainpoints |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
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 |
DecisionMaker Choices/Options
Value | Label | Description |
---|---|---|
1 | completed | |
0 | mark complete |
DefaultValue: 0
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 |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | description |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
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 |
DevelopProposal Choices/Options
Value | Label | Description |
---|---|---|
1 | Completed | |
0 | Mark complete |
DefaultValue: 0
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 |
MaxValue | 1000000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
MaxValue | 100 |
MinValue | 0 |
Precision | 2 |
RequiredLevel | None |
Type | Decimal |
EmailAddress
Property | Value |
---|---|
Description | The primary email address for the entity. |
DisplayName | Email Address |
FormatName | |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | emailaddress |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
EstimatedCloseDate
Property | Value |
---|---|
DateTimeBehavior | DateOnly |
Description | Enter the expected closing date of the opportunity to help make accurate revenue forecasts. |
DisplayName | Est. close date |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | estimatedclosedate |
RequiredLevel | None |
Type | DateTime |
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 |
MaxValue | 1000000000000 |
MinValue | -1000000000000 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
EvaluateFit Choices/Options
Value | Label | Description |
---|---|---|
1 | No | |
0 | Yes |
DefaultValue: 0
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 |
FileDebrief Choices/Options
Value | Label | Description |
---|---|---|
1 | Completed | |
0 | Mark complete |
DefaultValue: 0
FinalDecisionDate
Property | Value |
---|---|
DateTimeBehavior | DateOnly |
Description | Enter the date and time when the final decision of the opportunity was made. |
DisplayName | Final Decision Date |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | finaldecisiondate |
RequiredLevel | None |
Type | DateTime |
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 |
MaxValue | 1000000000000 |
MinValue | 0 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
IdentifyCompetitors
Property | Value |
---|---|
Description | Select whether information about competitors is included. |
DisplayName | Identify Competitors |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | identifycompetitors |
RequiredLevel | None |
Type | Boolean |
IdentifyCompetitors Choices/Options
Value | Label | Description |
---|---|---|
1 | completed | |
0 | mark complete |
DefaultValue: 0
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 |
IdentifyCustomerContacts Choices/Options
Value | Label | Description |
---|---|---|
1 | completed | |
0 | mark complete |
DefaultValue: 0
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 |
IdentifyPursuitTeam Choices/Options
Value | Label | Description |
---|---|---|
1 | completed | |
0 | mark complete |
DefaultValue: 0
ImportSequenceNumber
Property | Value |
---|---|
Description | Sequence number of the import that created this record. |
DisplayName | Import Sequence Number |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | importsequencenumber |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
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 |
InitialCommunication Choices/Options
Value | Label | Description |
---|---|---|
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 |
IsRevenueSystemCalculated Choices/Options
Value | Label | Description |
---|---|---|
1 | System Calculated | |
0 | User Provided |
DefaultValue: 0
LastOnHoldTime
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Contains the date time stamp of the last on hold time. |
DisplayName | Last On Hold Time |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | lastonholdtime |
RequiredLevel | None |
Type | DateTime |
msdyn_forecastcategory
Added by: Forecasting Solution
Property | Value |
---|---|
Description | Categories used for forecasting. |
DisplayName | Forecast category |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_forecastcategory |
RequiredLevel | None |
Type | Picklist |
msdyn_forecastcategory Choices/Options
Value | Label | Description |
---|---|---|
100000001 | Pipeline | |
100000002 | Best case | |
100000003 | Committed | |
100000004 | Omitted | |
100000005 | Won | |
100000006 | Lost |
msdyn_gdproptout
Added by: Predictive Lead Scoring Solution
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 |
msdyn_gdproptout Choices/Options
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
msdyn_OpportunityGrade
Added by: Predictive Opportunity Scoring Solution
Property | Value |
---|---|
Description | |
DisplayName | (Deprecated) Opportunity Grade |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_opportunitygrade |
RequiredLevel | None |
Type | Picklist |
msdyn_OpportunityGrade Choices/Options
Value | Label | Description |
---|---|---|
0 | Grade A | |
1 | Grade B | |
2 | Grade C | |
3 | Grade D |
msdyn_opportunitykpiid
Added by: Relationship analytics Solution
Property | Value |
---|---|
Description | Maps to opportunity KPI records |
DisplayName | KPI |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_opportunitykpiid |
RequiredLevel | None |
Targets | msdyn_opportunitykpiitem |
Type | Lookup |
msdyn_OpportunityScore
Added by: Predictive Opportunity Scoring Solution
Property | Value |
---|---|
Description | |
DisplayName | (Deprecated) Opportunity Score |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_opportunityscore |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
msdyn_OpportunityScoreTrend
Added by: Predictive Opportunity Scoring Solution
Property | Value |
---|---|
Description | |
DisplayName | (Deprecated) Opportunity Score Trend |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_opportunityscoretrend |
RequiredLevel | None |
Type | Picklist |
msdyn_OpportunityScoreTrend Choices/Options
Value | Label | Description |
---|---|---|
0 | Improving | |
1 | Steady | |
2 | Declining | |
3 | Not enough info |
msdyn_PredictiveScoreId
Added by: Predictive Scoring Common Solution
Property | Value |
---|---|
Description | Predictive score |
DisplayName | Predictive Score |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_predictivescoreid |
RequiredLevel | None |
Targets | msdyn_predictivescore |
Type | Lookup |
msdyn_ScoreHistory
Added by: Predictive Opportunity Scoring Solution
Property | Value |
---|---|
Description | |
DisplayName | (Deprecated) Score History |
Format | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_scorehistory |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
msdyn_ScoreReasons
Added by: Predictive Opportunity Scoring Solution
Property | Value |
---|---|
Description | |
DisplayName | (Deprecated) Score Reasons |
Format | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_scorereasons |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
msdyn_segmentid
Added by: Segment solution Solution
Property | Value |
---|---|
Description | Unique identifier for Segment associated with Opportunity. |
DisplayName | Segment Id |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_segmentid |
RequiredLevel | None |
Targets | msdyn_segment |
Type | Lookup |
msdyn_similaropportunities
Added by: Relationship analytics Solution
Property | Value |
---|---|
Description | |
DisplayName | msdyn_similaropportunities |
Format | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_similaropportunities |
MaxLength | 65536 |
RequiredLevel | None |
Type | Memo |
Name
Property | Value |
---|---|
Description | Type a subject or descriptive name, such as the expected order or company name, for the opportunity. |
DisplayName | Topic |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | name |
MaxLength | 300 |
RequiredLevel | ApplicationRequired |
Type | String |
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 |
Need Choices/Options
Value | Label | Description |
---|---|---|
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 |
IsValidForUpdate | False |
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 |
OpportunityRatingCode Choices/Options
Value | Label | Description |
---|---|---|
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 |
Targets | lead |
Type | Lookup |
OverriddenCreatedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time that the record was migrated. |
DisplayName | Record Created On |
Format | DateOnly |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | overriddencreatedon |
RequiredLevel | None |
Type | DateTime |
OwnerId
Property | Value |
---|---|
Description | Owner Id |
DisplayName | Owner |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | ownerid |
RequiredLevel | SystemRequired |
Targets | systemuser,team |
Type | Owner |
OwnerIdType
Added by: Active Solution Solution
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 |
Targets | account |
Type | Lookup |
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 |
Targets | contact |
Type | Lookup |
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 |
ParticipatesInWorkflow Choices/Options
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
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 |
PresentFinalProposal Choices/Options
Value | Label | Description |
---|---|---|
1 | completed | |
0 | mark complete |
DefaultValue: 0
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 |
PresentProposal Choices/Options
Value | Label | Description |
---|---|---|
1 | Completed | |
0 | Mark complete |
DefaultValue: 0
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 |
Targets | pricelevel |
Type | Lookup |
PricingErrorCode
Property | Value |
---|---|
Description | Pricing error for the opportunity. |
DisplayName | Pricing Error |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | pricingerrorcode |
RequiredLevel | None |
Type | Picklist |
PricingErrorCode Choices/Options
Value | Label | Description |
---|---|---|
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 |
PriorityCode Choices/Options
Value | Label | Description |
---|---|---|
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 |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | proposedsolution |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
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 |
PurchaseProcess Choices/Options
Value | Label | Description |
---|---|---|
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 |
PurchaseTimeframe Choices/Options
Value | Label | Description |
---|---|---|
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 |
PursuitDecision Choices/Options
Value | Label | Description |
---|---|---|
1 | No | |
0 | Yes |
DefaultValue: 0
QualificationComments
Property | Value |
---|---|
Description | Type comments about the qualification or scoring of the lead. |
DisplayName | Qualification Comments |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | qualificationcomments |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
QuoteComments
Property | Value |
---|---|
Description | Type comments about the quotes associated with the opportunity. |
DisplayName | Quote Comments |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | quotecomments |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
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 |
ResolveFeedback Choices/Options
Value | Label | Description |
---|---|---|
1 | No | |
0 | Yes |
DefaultValue: 0
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 |
SalesStage Choices/Options
Value | Label | Description |
---|---|---|
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 |
SalesStageCode Choices/Options
Value | Label | Description |
---|---|---|
1 | Default Value |
ScheduleFollowup_Prospect
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Enter the date and time of the prospecting follow-up meeting with the lead. |
DisplayName | Scheduled Follow up (Prospect) |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | schedulefollowup_prospect |
RequiredLevel | None |
Type | DateTime |
ScheduleFollowup_Qualify
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Enter the date and time of the qualifying follow-up meeting with the lead. |
DisplayName | Scheduled Follow up (Qualify) |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | schedulefollowup_qualify |
RequiredLevel | None |
Type | DateTime |
ScheduleProposalMeeting
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Enter the date and time of the proposal meeting for the opportunity. |
DisplayName | Schedule Proposal Meeting |
Format | DateOnly |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | scheduleproposalmeeting |
RequiredLevel | None |
Type | DateTime |
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 |
SendThankYouNote Choices/Options
Value | Label | Description |
---|---|---|
1 | Completed | |
0 | Mark complete |
DefaultValue: 0
SkipPriceCalculation
Added by: Sales Patch Solution
Property | Value |
---|---|
Description | Skip Price Calculation (For Internal Use) |
DisplayName | Skip Price Calculation |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | skippricecalculation |
RequiredLevel | None |
Type | Picklist |
SkipPriceCalculation Choices/Options
Value | Label | Description |
---|---|---|
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 |
Targets | sla |
Type | Lookup |
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 |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
StateCode Choices/Options
Value | Label | DefaultStatus | InvariantName |
---|---|---|---|
0 | Open | 1 | Open |
1 | Won | 3 | Won |
2 | Lost | 4 | Lost |
StatusCode
Property | Value |
---|---|
Description | Select the opportunity's status. |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
StatusCode Choices/Options
Value | Label | State |
---|---|---|
1 | In Progress | 0 |
2 | On Hold | 0 |
3 | Won | 1 |
4 | Canceled | 2 |
5 | Out-Sold | 2 |
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 |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | stepname |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
TeamsFollowed
Added by: Sales Patch Solution
Property | Value |
---|---|
Description | Number of users or conversations followed the record |
DisplayName | TeamsFollowed |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | teamsfollowed |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
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 |
TimeLine Choices/Options
Value | Label | Description |
---|---|---|
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 |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | timezoneruleversionnumber |
MaxValue | 2147483647 |
MinValue | -1 |
RequiredLevel | None |
Type | Integer |
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 |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totalamount |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totalamountlessfreight |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TotalDiscountAmount
Property | Value |
---|---|
Description | Shows the total discount amount, based on the discount price and rate entered on the opportunity. |
DisplayName | Total Discount Amount |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totaldiscountamount |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totallineitemamount |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totallineitemdiscountamount |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 0 |
RequiredLevel | None |
Type | Money |
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 |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totaltax |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 2 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
Targets | transactioncurrency |
Type | Lookup |
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 |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | traversedpath |
MaxLength | 1250 |
RequiredLevel | None |
Type | String |
UTCConversionTimeZoneCode
Property | Value |
---|---|
Description | Time zone code that was in use when the record was created. |
DisplayName | UTC Conversion Time Zone Code |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | utcconversiontimezonecode |
MaxValue | 2147483647 |
MinValue | -1 |
RequiredLevel | None |
Type | Integer |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- AccountId
- AccountIdName
- AccountIdYomiName
- ActualValue_Base
- BudgetAmount_Base
- CampaignIdName
- ContactId
- ContactIdName
- ContactIdYomiName
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- CustomerIdName
- CustomerIdYomiName
- DiscountAmount_Base
- EstimatedValue_Base
- ExchangeRate
- FreightAmount_Base
- IsPrivate
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- msdyn_opportunitykpiidName
- msdyn_PredictiveScoreIdName
- msdyn_segmentidName
- OnHoldTime
- OriginatingLeadIdName
- OriginatingLeadIdYomiName
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- ParentAccountIdName
- ParentAccountIdYomiName
- ParentContactIdName
- ParentContactIdYomiName
- PriceLevelIdName
- SLAInvokedId
- SLAInvokedIdName
- SLAName
- TimeSpentByMeOnEmailAndMeetings
- TotalAmount_Base
- TotalAmountLessFreight_Base
- TotalDiscountAmount_Base
- TotalLineItemAmount_Base
- TotalLineItemDiscountAmount_Base
- TotalTax_Base
- TransactionCurrencyIdName
- 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 |
Targets | account |
Type | Lookup |
AccountIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | accountidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
AccountIdYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | accountidyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ActualValue_Base
Property | Value |
---|---|
Description | Value of the Actual Revenue in base currency. |
DisplayName | Actual Revenue (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | actualvalue_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
BudgetAmount_Base
Property | Value |
---|---|
Description | Value of the Budget Amount in base currency. |
DisplayName | Budget Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | budgetamount_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
CampaignIdName
Added by: Marketing Sales Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | campaignidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
Targets | contact |
Type | Lookup |
ContactIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | contactidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ContactIdYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | contactidyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedBy
Property | Value |
---|---|
Description | Shows who created the record. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
CreatedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the record was created. |
DisplayName | Created On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
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 |
Targets | systemuser |
Type | Lookup |
CreatedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CustomerIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | customeridname |
MaxLength | 160 |
RequiredLevel | ApplicationRequired |
Type | String |
CustomerIdYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | customeridyominame |
MaxLength | 450 |
RequiredLevel | ApplicationRequired |
Type | String |
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 |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
EstimatedValue_Base
Property | Value |
---|---|
Description | Value of the Est. Revenue in base currency. |
DisplayName | Est. Revenue (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | estimatedvalue_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
ExchangeRate
Added by: Active Solution Solution
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 |
MaxValue | 100000000000 |
MinValue | 0.000000000001 |
Precision | 12 |
RequiredLevel | None |
Type | Decimal |
FreightAmount_Base
Property | Value |
---|---|
Description | Value of the Freight Amount in base currency. |
DisplayName | Freight Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | freightamount_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
IsPrivate Choices/Options
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
ModifiedBy
Property | Value |
---|---|
Description | Shows who last updated the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
ModifiedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the record was modified. |
DisplayName | Modified On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
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 |
Targets | systemuser |
Type | Lookup |
ModifiedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
msdyn_opportunitykpiidName
Added by: Relationship analytics Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_opportunitykpiidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
msdyn_PredictiveScoreIdName
Added by: Predictive Scoring Common Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_predictivescoreidname |
MaxLength | 128 |
RequiredLevel | None |
Type | String |
msdyn_segmentidName
Added by: Segment solution Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_segmentidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
OnHoldTime
Property | Value |
---|---|
Description | Shows the duration in minutes for which the opportunity was on hold. |
DisplayName | On Hold Time (Minutes) |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | onholdtime |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
OriginatingLeadIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | originatingleadidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
OriginatingLeadIdYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | originatingleadidyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
OwnerIdName
Property | Value |
---|---|
Description | Name of the owner |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwnerIdYomiName
Property | Value |
---|---|
Description | Yomi name of the owner |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
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 |
Targets | businessunit |
Type | Lookup |
OwningBusinessUnitName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningbusinessunitname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwningTeam
Property | Value |
---|---|
Description | Unique identifier for the team that owns the record. |
DisplayName | Owning Team |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningteam |
RequiredLevel | None |
Targets | team |
Type | Lookup |
OwningUser
Property | Value |
---|---|
Description | Unique identifier for the user that owns the record. |
DisplayName | Owning User |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owninguser |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
ParentAccountIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | parentaccountidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ParentAccountIdYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | parentaccountidyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ParentContactIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | parentcontactidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ParentContactIdYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | parentcontactidyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
PriceLevelIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | pricelevelidname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
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 |
Targets | sla |
Type | Lookup |
SLAInvokedIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | slainvokedidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
SLAName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | slaname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | timespentbymeonemailandmeetings |
MaxLength | 1250 |
RequiredLevel | None |
Type | String |
TotalAmount_Base
Property | Value |
---|---|
Description | Value of the Total Amount in base currency. |
DisplayName | Total Amount (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totalamount_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
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 |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TotalTax_Base
Property | Value |
---|---|
Description | Value of the Total Tax in base currency. |
DisplayName | Total Tax (Base) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | totaltax_base |
MaxValue | 922337203685477 |
MinValue | -922337203685477 |
Precision | 4 |
PrecisionSource | 2 |
RequiredLevel | None |
Type | Money |
TransactionCurrencyIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | transactioncurrencyidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
VersionNumber
Property | Value |
---|---|
Description | Version Number |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
- opportunity_OpportunityCloses
- opportunity_OrderCloses
- opportunity_QuoteCloses
- lk_leadtoopportunitysalesprocess_opportunityid
- opportunity_invoices
- Opportunity_OpportunityClose
- opportunity_quotes
- opportunity_sales_orders
- lead_qualifying_opportunity
- lk_opportunitysalesprocess_opportunityid
- product_opportunities
- CreatedOpportunity_BulkOperationLogs
- msdyn_opportunity_msdyn_salesroutingrun_targetobject
opportunity_OpportunityCloses
Same as the opportunity_OpportunityCloses many-to-one relationship for the opportunityclose table/entity.
Property | Value |
---|---|
ReferencingEntity | opportunityclose |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | opportunity_OpportunityCloses |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
opportunity_OrderCloses
Same as the opportunity_OrderCloses many-to-one relationship for the orderclose table/entity.
Property | Value |
---|---|
ReferencingEntity | orderclose |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | opportunity_OrderCloses |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
opportunity_QuoteCloses
Same as the opportunity_QuoteCloses many-to-one relationship for the quoteclose table/entity.
Property | Value |
---|---|
ReferencingEntity | quoteclose |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | opportunity_QuoteCloses |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
lk_leadtoopportunitysalesprocess_opportunityid
Same as the lk_leadtoopportunitysalesprocess_opportunityid many-to-one relationship for the leadtoopportunitysalesprocess table/entity.
Property | Value |
---|---|
ReferencingEntity | leadtoopportunitysalesprocess |
ReferencingAttribute | opportunityid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | opportunity_leadtoopportunitysalesprocess |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
opportunity_invoices
Same as the opportunity_invoices many-to-one relationship for the invoice table/entity.
Property | Value |
---|---|
ReferencingEntity | invoice |
ReferencingAttribute | opportunityid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | opportunity_invoices |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Sales Label: Order: 30 |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Opportunity_OpportunityClose
Same as the Opportunity_OpportunityClose many-to-one relationship for the opportunityclose table/entity.
Property | Value |
---|---|
ReferencingEntity | opportunityclose |
ReferencingAttribute | opportunityid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | Opportunity_OpportunityClose |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
opportunity_quotes
Same as the opportunity_quotes many-to-one relationship for the quote table/entity.
Property | Value |
---|---|
ReferencingEntity | quote |
ReferencingAttribute | opportunityid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | opportunity_quotes |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Sales Label: Order: 10 |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
opportunity_sales_orders
Same as the opportunity_sales_orders many-to-one relationship for the salesorder table/entity.
Property | Value |
---|---|
ReferencingEntity | salesorder |
ReferencingAttribute | opportunityid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | opportunity_sales_orders |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Sales Label: Order: 20 |
CascadeConfiguration | Assign: Cascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
lead_qualifying_opportunity
Same as the lead_qualifying_opportunity many-to-one relationship for the lead table/entity.
Property | Value |
---|---|
ReferencingEntity | lead |
ReferencingAttribute | qualifyingopportunityid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | lead_qualifying_opportunity |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: Cascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
lk_opportunitysalesprocess_opportunityid
Same as the lk_opportunitysalesprocess_opportunityid many-to-one relationship for the opportunitysalesprocess table/entity.
Property | Value |
---|---|
ReferencingEntity | opportunitysalesprocess |
ReferencingAttribute | opportunityid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | opportunity_opportunitysalesprocess |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
product_opportunities
Same as the product_opportunities many-to-one relationship for the opportunityproduct table/entity.
Property | Value |
---|---|
ReferencingEntity | opportunityproduct |
ReferencingAttribute | opportunityid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | product_opportunities |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 10 |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
CreatedOpportunity_BulkOperationLogs
Added by: Marketing Solution
Same as the CreatedOpportunity_BulkOperationLogs many-to-one relationship for the bulkoperationlog table/entity.
Property | Value |
---|---|
ReferencingEntity | bulkoperationlog |
ReferencingAttribute | createdobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | CreatedOpportunity_BulkOperationLogs |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
msdyn_opportunity_msdyn_salesroutingrun_targetobject
Added by: Assignment Rules Solution
Same as the msdyn_opportunity_msdyn_salesroutingrun_targetobject many-to-one relationship for the msdyn_salesroutingrun table/entity.
Property | Value |
---|---|
ReferencingEntity | msdyn_salesroutingrun |
ReferencingAttribute | msdyn_targetobject |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | msdyn_opportunity_msdyn_salesroutingrun_targetobject |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- opportunity_originating_lead
- opportunity_parent_account
- price_level_opportunties
- opportunity_parent_contact
- opportunity_customer_accounts
- opportunity_customer_contacts
- campaign_opportunities
- msdyn_msdyn_predictivescore_opportunity
- msdyn_msdyn_segment_opportunity
opportunity_originating_lead
Added by: Lead Management Solution
See the opportunity_originating_lead one-to-many relationship for the lead table/entity.
opportunity_parent_account
Added by: System Solution Solution
See the opportunity_parent_account one-to-many relationship for the account table/entity.
price_level_opportunties
Added by: Product Management Solution
See the price_level_opportunties one-to-many relationship for the pricelevel table/entity.
opportunity_parent_contact
Added by: System Solution Solution
See the opportunity_parent_contact one-to-many relationship for the contact table/entity.
opportunity_customer_accounts
Added by: System Solution Solution
See the opportunity_customer_accounts one-to-many relationship for the account table/entity.
opportunity_customer_contacts
Added by: System Solution Solution
See the opportunity_customer_contacts one-to-many relationship for the contact table/entity.
campaign_opportunities
Added by: Marketing Solution
See the campaign_opportunities one-to-many relationship for the campaign table/entity.
msdyn_msdyn_predictivescore_opportunity
Added by: Predictive Scoring Common Solution
See the msdyn_msdyn_predictivescore_opportunity one-to-many relationship for the msdyn_predictivescore table/entity.
msdyn_msdyn_segment_opportunity
Added by: Segment solution Solution
See the msdyn_msdyn_segment_opportunity one-to-many relationship for the msdyn_segment table/entity.
Many-To-Many Relationships
Relationship details provided where the Opportunity table is the first table in the relationship. Listed by SchemaName.
opportunitycompetitors_association
IntersectEntityName: opportunitycompetitors
Table 1
Property | Value |
---|---|
IntersectAttribute | opportunityid |
IsCustomizable | False |
LogicalName | opportunity |
NavigationPropertyName | opportunitycompetitors_association |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
Table 2
Property | Value |
---|---|
LogicalName | competitor |
IntersectAttribute | competitorid |
NavigationPropertyName | opportunitycompetitors_association |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Sales Label: Order: 40 |
See also
คำติชม
https://aka.ms/ContentUserFeedback
เร็วๆ นี้: ตลอดปี 2024 เราจะขจัดปัญหา GitHub เพื่อเป็นกลไกคำติชมสำหรับเนื้อหา และแทนที่ด้วยระบบคำติชมใหม่ สำหรับข้อมูลเพิ่มเติม ให้ดู:ส่งและดูข้อคิดเห็นสำหรับ