Table 5343 "CRM Opportunity"

Base Application · Microsoft.Integration.D365Sales · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	CRM Opportunity
TableType	CRM
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	OpportunityId	Guid	Opportunity caption
2	PriceLevelId	Guid	Price List caption	TableRelation Table 5346 “CRM Pricelevel” (“CRM Pricelevel”.PriceLevelId)
3	OpportunityRatingCode Δ BC28	Option	Specifies data from a corresponding field in a Dynamics 365 Sales entity. For more information about Dynamics 365 Sales, see Dynamics 365 Sales Help Center.	OptionCaption: Hot,Warm,Cold
4	PriorityCode	Option	Priority caption	OptionCaption: Default Value
5	ContactId	Guid	—	TableRelation Table 5342 “CRM Contact” (“CRM Contact”.ContactId)
6	AccountId	Guid	—	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
7	Name Δ BC28	Text[2048]	Specifies data from a corresponding field in a Dynamics 365 Sales entity. For more information about Dynamics 365 Sales, see Dynamics 365 Sales Help Center.
8	StepId	Guid	Step caption
9	Description	BLOB	—
10	EstimatedValue Δ BC28	Decimal	Specifies data from a corresponding field in a Dynamics 365 Sales entity. For more information about Dynamics 365 Sales, see Dynamics 365 Sales Help Center.
11	StepName	Text[200]	Pipeline Phase caption
12	SalesStageCode	Option	Process Code caption	OptionCaption: Default Value
13	ParticipatesInWorkflow	Boolean	Participates in Workflow caption
14	PricingErrorCode	Option	Pricing Error caption	OptionCaption: None,Detail Error,Missing Price Level,Inactive Price Level,Missing Quantity,Missing Unit Price,Missing Product,Invalid Product,Missing Pricing Code,Invalid Pricing Code,Missing UOM,Product Not In Price Level,Missing Price Level Amount,Missing Price Level Percentage,Missing Price,Missing Current Cost…
15	EstimatedCloseDate Δ BC28	Date	Specifies data from a corresponding field in a Dynamics 365 Sales entity. For more information about Dynamics 365 Sales, see Dynamics 365 Sales Help Center.
16	CloseProbability Δ BC28	Integer	Specifies data from a corresponding field in a Dynamics 365 Sales entity. For more information about Dynamics 365 Sales, see Dynamics 365 Sales Help Center.
17	ActualValue Δ BC28	Decimal	Actual Revenue caption
18	ActualCloseDate	Date	Actual Close Date caption
19	OwningUser	Guid	Owning User caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
20	OwningBusinessUnit	Guid	Owning Business Unit caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
21	CreatedOn	DateTime	Created On caption
22	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
23	ModifiedOn	DateTime	Modified On caption
24	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
25	VersionNumber	BigInteger	Version Number caption
26	StateCode Δ BC28	Option	Specifies data from a corresponding field in a Dynamics 365 Sales entity. For more information about Dynamics 365 Sales, see Dynamics 365 Sales Help Center.	OptionCaption: Open,Won,Lost
27	StatusCode Δ BC28	Option	Specifies data from a corresponding field in a Dynamics 365 Sales entity. For more information about Dynamics 365 Sales, see Dynamics 365 Sales Help Center.	OptionCaption: ,In Progress,On Hold,Won,Canceled,Out-Sold
28	IsRevenueSystemCalculated	Boolean	Revenue caption
29	ContactIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Contact”.FullName where(ContactId = field(ContactId)))
30	AccountIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Account”.Name where(AccountId = field(AccountId)))
31	PriceLevelIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Pricelevel”.Name where(PriceLevelId = field(PriceLevelId)))
32	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
33	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
34	CustomerId	Guid	Potential Customer caption	TableRelation Table 5341 “CRM Account”, Table 5342 “CRM Contact” (if (CustomerIdType = const(account)) “CRM Account”.AccountId else if (CustomerIdType = const(contact)) “CRM Contact”.ContactId)
35	CustomerIdType	Option	Potential Customer Type caption	OptionCaption: ,account,contact
36	OwnerId	Guid	Owner caption	TableRelation Table 5340 “CRM Systemuser”, Table 5359 “CRM Team” (if (OwnerIdType = const(systemuser)) “CRM Systemuser”.SystemUserId else if (OwnerIdType = const(team)) “CRM Team”.TeamId)
37	OwnerIdType	Option	—	OptionCaption: ,systemuser,team
38	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
39	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
40	ImportSequenceNumber	Integer	Import Sequence Number caption
41	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
42	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
43	OverriddenCreatedOn	Date	Record Created On caption
44	TransactionCurrencyIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
45	ActualValue_Base Δ BC28	Decimal	Actual Revenue (Base) caption
46	EstimatedValue_Base Δ BC28	Decimal	Est. Revenue (Base) caption
47	TotalTax Δ BC28	Decimal	Total Tax caption
48	DiscountPercentage Δ BC28	Decimal	Opportunity Discount (%) caption
49	TotalAmount Δ BC28	Decimal	Specifies data from a corresponding field in a Dynamics 365 Sales entity. For more information about Dynamics 365 Sales, see Dynamics 365 Sales Help Center.
50	DiscountAmount Δ BC28	Decimal	Opportunity Discount Amount caption
51	TotalAmountLessFreight Δ BC28	Decimal	Total Pre-Freight Amount caption
52	FreightAmount Δ BC28	Decimal	Freight Amount caption
53	TotalLineItemDiscountAmount Δ BC28	Decimal	Total Line Item Discount Amount caption
54	TotalLineItemAmount Δ BC28	Decimal	Total Detail Amount caption
55	TotalDiscountAmount Δ BC28	Decimal	Total Discount Amount caption
56	TotalLineItemAmount_Base Δ BC28	Decimal	Total Detail Amount (Base) caption
57	TotalDiscountAmount_Base Δ BC28	Decimal	Total Discount Amount (Base) caption
58	TotalTax_Base Δ BC28	Decimal	Total Tax (Base) caption
59	DiscountAmount_Base Δ BC28	Decimal	Opportunity Discount Amount (Base) caption
60	TotalLineItemDiscountAmount_Ba Δ BC28	Decimal	Total Line Item Discount Amount (Base) caption
61	TotalAmount_Base Δ BC28	Decimal	Total Amount (Base) caption
62	TotalAmountLessFreight_Base Δ BC28	Decimal	Total Pre-Freight Amount (Base) caption
63	FreightAmount_Base Δ BC28	Decimal	Freight Amount (Base) caption
64	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
65	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
66	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
67	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
68	OwningTeam	Guid	Owning Team caption	TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId)
69	BudgetStatus	Option	Budget caption	OptionCaption: ,No Committed Budget,May Buy,Can Buy,Will Buy
70	DecisionMaker	Boolean	Decision Maker? caption
71	Need Δ BC28	Option	Specifies data from a corresponding field in a Dynamics 365 Sales entity. For more information about Dynamics 365 Sales, see Dynamics 365 Sales Help Center.	OptionCaption: ,Must have,Should have,Good to have,No need
72	TimeLine	Option	Timeline caption	OptionCaption: ,Immediate,This Quarter,Next Quarter,This Year,Not known
73	BudgetAmount Δ BC28	Decimal	Budget Amount caption
74	BudgetAmount_Base Δ BC28	Decimal	Budget Amount (Base) caption
75	ParentAccountId	Guid	Account caption	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
76	ParentAccountIdName Δ BC24 Δ BC28	Text[160]	Specifies data from a corresponding field in a Dynamics 365 Sales entity. For more information about Dynamics 365 Sales, see Dynamics 365 Sales Help Center.	FlowField: lookup(“CRM Account”.Name where(AccountId = field(ParentAccountId)))
77	ParentContactId	Guid	Contact caption	TableRelation Table 5342 “CRM Contact” (“CRM Contact”.ContactId)
78	ParentContactIdName Δ BC24 Δ BC28	Text[160]	Specifies data from a corresponding field in a Dynamics 365 Sales entity. For more information about Dynamics 365 Sales, see Dynamics 365 Sales Help Center.	FlowField: lookup(“CRM Contact”.FullName where(ContactId = field(ParentContactId)))
79	EvaluateFit	Boolean	Evaluate Fit caption
80	InitialCommunication	Option	Initial Communication caption	OptionCaption: ,Contacted,Not Contacted
81	ConfirmInterest	Boolean	Confirm Interest caption
82	ScheduleFollowup_Prospect	Date	Scheduled Follow up (Prospect) caption
83	ScheduleFollowup_Qualify	Date	Scheduled Follow up (Qualify) caption
84	ScheduleProposalMeeting	Date	Schedule Proposal Meeting caption
85	FinalDecisionDate	Date	Final Decision Date caption
86	DevelopProposal	Boolean	Develop Proposal caption
87	CompleteInternalReview	Boolean	Complete Internal Review caption
88	CaptureProposalFeedback	Boolean	Proposal Feedback Captured caption
89	ResolveFeedback	Boolean	Feedback Resolved caption
90	PresentProposal	Boolean	Presented Proposal caption
91	SendThankYouNote	Boolean	Send Thank You Note caption
92	SalesStage	Option	Sales Stage caption	OptionCaption: ,Qualify,Develop,Propose,Close
93	TraversedPath	Text[250]	Traversed Path caption
94	CompleteFinalProposal	Boolean	Final Proposal Ready caption
95	FileDebrief	Boolean	File Debrief caption
96	PursuitDecision	Boolean	Decide Go/No-Go caption
97	CustomerPainPoints	BLOB	Customer Pain Points caption
98	CustomerNeed	BLOB	Customer Need caption
99	ProposedSolution	BLOB	Proposed Solution caption
100	QualificationComments	BLOB	Qualification Comments caption
101	QuoteComments	BLOB	Quote Comments caption
102	PurchaseProcess	Option	Purchase Process caption	OptionCaption: ,Individual,Committee,Unknown
103	PurchaseTimeframe	Option	Purchase Timeframe caption	OptionCaption: ,Immediate,This Quarter,Next Quarter,This Year,Unknown
104	IdentifyCustomerContacts	Boolean	Identify Customer Contacts caption
105	IdentifyCompetitors	Boolean	Identify Competitors caption
106	IdentifyPursuitTeam	Boolean	Identify Sales Team caption
107	CurrentSituation	BLOB	Current Situation caption
108	PresentFinalProposal	Boolean	Present Final Proposal caption
109	StageId	Guid	Process Stage caption
110	ProcessId	Guid	Process caption
111	CompanyId	Guid	Company Id caption	TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)

Keys

Key1: OpportunityId (clustered)
Key2: Name

Relations

CreatedByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
OwnerId: TableRelation Table 5340 “CRM Systemuser” (conditional)
OwningUser: TableRelation Table 5340 “CRM Systemuser”
AccountIdName: CalcFormula Table 5341 “CRM Account”
ParentAccountIdName: CalcFormula Table 5341 “CRM Account”
AccountId: TableRelation Table 5341 “CRM Account”
CustomerId: TableRelation Table 5341 “CRM Account” (conditional)
ParentAccountId: TableRelation Table 5341 “CRM Account”
ContactIdName: CalcFormula Table 5342 “CRM Contact”
ParentContactIdName: CalcFormula Table 5342 “CRM Contact”
ContactId: TableRelation Table 5342 “CRM Contact”
CustomerId: TableRelation Table 5342 “CRM Contact” (conditional)
ParentContactId: TableRelation Table 5342 “CRM Contact”
TransactionCurrencyIdName: CalcFormula Table 5345 “CRM Transactioncurrency”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
PriceLevelIdName: CalcFormula Table 5346 “CRM Pricelevel”
PriceLevelId: TableRelation Table 5346 “CRM Pricelevel”
OwnerId: TableRelation Table 5359 “CRM Team” (conditional)
OwningTeam: TableRelation Table 5359 “CRM Team”
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”
CompanyId: TableRelation Table 5393 “CDS Company”

Referenced by

10 fields in 7 objects relate to this table (TableRelation or CalcFormula).

Table 5351 “CRM Quote”: OpportunityIdName, OpportunityId
Table 5353 “CRM Salesorder”: OpportunityIdName, OpportunityId
Table 5355 “CRM Invoice”: OpportunityIdName, OpportunityId
Table 5359 “CRM Team”: RegardingObjectId
Table 5385 “CRM Annotation”: ObjectId
Table 6400 “FS Work Order”: OpportunityId
Table 6617 “FS Work Order”: OpportunityId

Pages and codeunits on this table

Page 5343 “CRM Opportunity List” (source table)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "CRM Opportunity"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.