Table 5343 CRM Opportunity

Base Application, Microsoft.Integration.D365Sales

111 fields

IdNameTypeVersions
1OpportunityIdGuid17-29
2PriceLevelIdGuid17-29
3OpportunityRatingCodeOption17-29
4PriorityCodeOption17-29
5ContactIdGuid17-29
6AccountIdGuid17-29
7NameText[2048]17-29changed in 18
8StepIdGuid17-29
9DescriptionBlob17-29
10EstimatedValueDecimal17-29
11StepNameText[200]17-29
12SalesStageCodeOption17-29
13ParticipatesInWorkflowBoolean17-29
14PricingErrorCodeOption17-29
15EstimatedCloseDateDate17-29
16CloseProbabilityInteger17-29
17ActualValueDecimal17-29
18ActualCloseDateDate17-29
19OwningUserGuid17-29
20OwningBusinessUnitGuid17-29
21CreatedOnDateTime17-29
22CreatedByGuid17-29
23ModifiedOnDateTime17-29
24ModifiedByGuid17-29
25VersionNumberBigInteger17-29
26StateCodeOption17-29
27StatusCodeOption17-29
28IsRevenueSystemCalculatedBoolean17-29
29ContactIdNameText[160]17-29
30AccountIdNameText[160]17-29
31PriceLevelIdNameText[100]17-29
32CreatedByNameText[200]17-29
33ModifiedByNameText[200]17-29
34CustomerIdGuid17-29
35CustomerIdTypeOption17-29
36OwnerIdGuid17-29
37OwnerIdTypeOption17-29
38TransactionCurrencyIdGuid17-29
39ExchangeRateDecimal17-29
40ImportSequenceNumberInteger17-29
41UTCConversionTimeZoneCodeInteger17-29
42TimeZoneRuleVersionNumberInteger17-29
43OverriddenCreatedOnDate17-29
44TransactionCurrencyIdNameText[100]17-29
45ActualValue_BaseDecimal17-29
46EstimatedValue_BaseDecimal17-29
47TotalTaxDecimal17-29
48DiscountPercentageDecimal17-29
49TotalAmountDecimal17-29
50DiscountAmountDecimal17-29
51TotalAmountLessFreightDecimal17-29
52FreightAmountDecimal17-29
53TotalLineItemDiscountAmountDecimal17-29
54TotalLineItemAmountDecimal17-29
55TotalDiscountAmountDecimal17-29
56TotalLineItemAmount_BaseDecimal17-29
57TotalDiscountAmount_BaseDecimal17-29
58TotalTax_BaseDecimal17-29
59DiscountAmount_BaseDecimal17-29
60TotalLineItemDiscountAmount_BaDecimal17-29
61TotalAmount_BaseDecimal17-29
62TotalAmountLessFreight_BaseDecimal17-29
63FreightAmount_BaseDecimal17-29
64CreatedOnBehalfByGuid17-29
65CreatedOnBehalfByNameText[200]17-29
66ModifiedOnBehalfByGuid17-29
67ModifiedOnBehalfByNameText[200]17-29
68OwningTeamGuid17-29
69BudgetStatusOption17-29
70DecisionMakerBoolean17-29
71NeedOption17-29
72TimeLineOption17-29
73BudgetAmountDecimal17-29
74BudgetAmount_BaseDecimal17-29
75ParentAccountIdGuid17-29
76ParentAccountIdNameText[160]17-29
77ParentContactIdGuid17-29
78ParentContactIdNameText[160]17-29
79EvaluateFitBoolean17-29
80InitialCommunicationOption17-29
81ConfirmInterestBoolean17-29
82ScheduleFollowup_ProspectDate17-29
83ScheduleFollowup_QualifyDate17-29
84ScheduleProposalMeetingDate17-29
85FinalDecisionDateDate17-29
86DevelopProposalBoolean17-29
87CompleteInternalReviewBoolean17-29
88CaptureProposalFeedbackBoolean17-29
89ResolveFeedbackBoolean17-29
90PresentProposalBoolean17-29
91SendThankYouNoteBoolean17-29
92SalesStageOption17-29
93TraversedPathText[250]17-29
94CompleteFinalProposalBoolean17-29
95FileDebriefBoolean17-29
96PursuitDecisionBoolean17-29
97CustomerPainPointsBlob17-29
98CustomerNeedBlob17-29
99ProposedSolutionBlob17-29
100QualificationCommentsBlob17-29
101QuoteCommentsBlob17-29
102PurchaseProcessOption17-29
103PurchaseTimeframeOption17-29
104IdentifyCustomerContactsBoolean17-29
105IdentifyCompetitorsBoolean17-29
106IdentifyPursuitTeamBoolean17-29
107CurrentSituationBlob17-29
108PresentFinalProposalBoolean17-29
109StageIdGuid17-29
110ProcessIdGuid17-29
111CompanyIdGuid17-29