Objects/Tables/Table 5343 CRM Opportunity

Table 5343 CRM Opportunity in 20

Jonas Paprotka, Base Application 20.5.45456.61928, checked 2026-09-20

App: Base Application

Versions17 18 192021 22 23 24 25 26 27 28 latest

Source29

Fields, 111

Id	Name	Type	Obsolete
1	OpportunityId	Guid	-
2	PriceLevelId	Guid	-
3	OpportunityRatingCode	Option	-
4	PriorityCode	Option	-
5	ContactId	Guid	-
6	AccountId	Guid	-
7	Name	Text[2048]	-
8	StepId	Guid	-
9	Description	Blob	-
10	EstimatedValue	Decimal	-
11	StepName	Text[200]	-
12	SalesStageCode	Option	-
13	ParticipatesInWorkflow	Boolean	-
14	PricingErrorCode	Option	-
15	EstimatedCloseDate	Date	-
16	CloseProbability	Integer	-
17	ActualValue	Decimal	-
18	ActualCloseDate	Date	-
19	OwningUser	Guid	-
20	OwningBusinessUnit	Guid	-
21	CreatedOn	DateTime	-
22	CreatedBy	Guid	-
23	ModifiedOn	DateTime	-
24	ModifiedBy	Guid	-
25	VersionNumber	BigInteger	-
26	StateCode	Option	-
27	StatusCode	Option	-
28	IsRevenueSystemCalculated	Boolean	-
29	ContactIdName	Text[160]	-
30	AccountIdName	Text[160]	-
31	PriceLevelIdName	Text[100]	-
32	CreatedByName	Text[200]	-
33	ModifiedByName	Text[200]	-
34	CustomerId	Guid	-
35	CustomerIdType	Option	-
36	OwnerId	Guid	-
37	OwnerIdType	Option	-
38	TransactionCurrencyId	Guid	-
39	ExchangeRate	Decimal	-
40	ImportSequenceNumber	Integer	-
41	UTCConversionTimeZoneCode	Integer	-
42	TimeZoneRuleVersionNumber	Integer	-
43	OverriddenCreatedOn	Date	-
44	TransactionCurrencyIdName	Text[100]	-
45	ActualValue_Base	Decimal	-
46	EstimatedValue_Base	Decimal	-
47	TotalTax	Decimal	-
48	DiscountPercentage	Decimal	-
49	TotalAmount	Decimal	-
50	DiscountAmount	Decimal	-
51	TotalAmountLessFreight	Decimal	-
52	FreightAmount	Decimal	-
53	TotalLineItemDiscountAmount	Decimal	-
54	TotalLineItemAmount	Decimal	-
55	TotalDiscountAmount	Decimal	-
56	TotalLineItemAmount_Base	Decimal	-
57	TotalDiscountAmount_Base	Decimal	-
58	TotalTax_Base	Decimal	-
59	DiscountAmount_Base	Decimal	-
60	TotalLineItemDiscountAmount_Ba	Decimal	-
61	TotalAmount_Base	Decimal	-
62	TotalAmountLessFreight_Base	Decimal	-
63	FreightAmount_Base	Decimal	-
64	CreatedOnBehalfBy	Guid	-
65	CreatedOnBehalfByName	Text[200]	-
66	ModifiedOnBehalfBy	Guid	-
67	ModifiedOnBehalfByName	Text[200]	-
68	OwningTeam	Guid	-
69	BudgetStatus	Option	-
70	DecisionMaker	Boolean	-
71	Need	Option	-
72	TimeLine	Option	-
73	BudgetAmount	Decimal	-
74	BudgetAmount_Base	Decimal	-
75	ParentAccountId	Guid	-
76	ParentAccountIdName	Text[160]	-
77	ParentContactId	Guid	-
78	ParentContactIdName	Text[160]	-
79	EvaluateFit	Boolean	-
80	InitialCommunication	Option	-
81	ConfirmInterest	Boolean	-
82	ScheduleFollowup_Prospect	Date	-
83	ScheduleFollowup_Qualify	Date	-
84	ScheduleProposalMeeting	Date	-
85	FinalDecisionDate	Date	-
86	DevelopProposal	Boolean	-
87	CompleteInternalReview	Boolean	-
88	CaptureProposalFeedback	Boolean	-
89	ResolveFeedback	Boolean	-
90	PresentProposal	Boolean	-
91	SendThankYouNote	Boolean	-
92	SalesStage	Option	-
93	TraversedPath	Text[250]	-
94	CompleteFinalProposal	Boolean	-
95	FileDebrief	Boolean	-
96	PursuitDecision	Boolean	-
97	CustomerPainPoints	Blob	-
98	CustomerNeed	Blob	-
99	ProposedSolution	Blob	-
100	QualificationComments	Blob	-
101	QuoteComments	Blob	-
102	PurchaseProcess	Option	-
103	PurchaseTimeframe	Option	-
104	IdentifyCustomerContacts	Boolean	-
105	IdentifyCompetitors	Boolean	-
106	IdentifyPursuitTeam	Boolean	-
107	CurrentSituation	Blob	-
108	PresentFinalProposal	Boolean	-
109	StageId	Guid	-
110	ProcessId	Guid	-
111	CompanyId	Guid	-

Keys, 2

Name	Fields	Obsolete
Key1, clustered	OpportunityId	-
Key2	Name	-