CRM Opportunity

Table

CRM Opportunity

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

#	Name	Type
1	OpportunityId (OpportunityId)	GUID	ExternalName: opportunityid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the opportunity.
2	PriceLevelId (PriceLevelId)	GUID	ExternalName: pricelevelid ExternalType: Lookup Description: Choose the price list associated with this record to make sure the products associated with the campaign are offered at the correct prices. TableRelation: "CRM Pricelevel".PriceLevelId
3	OpportunityRatingCode (OpportunityRatingCode)	Option	[Hot,Warm,Cold] OptionOrdinalValues: [1;2;3] InitValue: Warm ExternalName: opportunityratingcode ExternalType: Picklist Description: Select the expected value or priority of the opportunity based on revenue, customer status, or closing probability.
4	PriorityCode (PriorityCode)	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: prioritycode ExternalType: Picklist Description: Select the priority so that preferred customers or critical issues are handled quickly.
5	ContactId (ContactId)	GUID	ExternalName: contactid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the contact associated with the opportunity. TableRelation: "CRM Contact".ContactId
6	AccountId (AccountId)	GUID	ExternalName: accountid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the account with which the opportunity is associated. TableRelation: "CRM Account".AccountId
7	Name (Name)	Text250	ExternalName: name ExternalType: String Description: Type a subject or descriptive name, such as the expected order or company name, for the opportunity.
8	StepId (StepId)	GUID	ExternalName: stepid ExternalType: Uniqueidentifier Description: Shows the ID of the workflow step.
9	Description (Description)	BLOB [Memo]	ExternalName: description ExternalType: Memo Description: Type additional information to describe the opportunity, such as possible products to sell or past purchases from the customer.
10	EstimatedValue (EstimatedValue)	Decimal	ExternalName: estimatedvalue ExternalType: Money 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.
11	StepName (StepName)	Text200	ExternalName: stepname ExternalType: String Description: Shows the current phase in the sales pipeline for the opportunity. This is updated by a workflow.
12	SalesStageCode (SalesStageCode)	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: salesstagecode ExternalType: Picklist Description: Select the sales process stage for the opportunity to indicate the probability of closing the opportunity.
13	ParticipatesInWorkflow (ParticipatesInWorkflow)	Boolean	ExternalName: participatesinworkflow ExternalType: Boolean Description: Information about whether the opportunity participates in workflow rules.
14	PricingErrorCode (PricingErrorCode)	Option	[None,DetailError,MissingPriceLevel,InactivePriceLevel,MissingQuantity,MissingUnitPrice,MissingProduct,InvalidProduct,MissingPricingCode,InvalidPricingCode,MissingUOM,ProductNotInPriceLevel,MissingPriceLevelAmount,MissingPriceLevelPercentage,MissingPrice,MissingCurrentCost,MissingStandardCost,InvalidPriceLevelAmount,InvalidPriceLevelPercentage,InvalidPrice,InvalidCurrentCost,InvalidStandardCost,InvalidRoundingPolicy,InvalidRoundingOption,InvalidRoundingAmount,PriceCalculationError,InvalidDiscountType,DiscountTypeInvalidState,InvalidDiscount,InvalidQuantity,InvalidPricingPrecision,MissingProductDefaultUOM,MissingProductUOMSchedule,InactiveDiscountType,InvalidPriceLevelCurrency,PriceAttributeOutOfRange,BaseCurrencyAttributeOverflow,BaseCurrencyAttributeUnderflow] OptionOrdinalValues: [0;1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20;21;22;23;24;25;26;27;28;29;30;31;32;33;34;35;36;37] InitValue: None ExternalName: pricingerrorcode ExternalType: Picklist Description: Pricing error for the opportunity.
15	EstimatedCloseDate (EstimatedCloseDate)	Date	ExternalName: estimatedclosedate ExternalType: DateTime Description: Enter the expected closing date of the opportunity to help make accurate revenue forecasts.
16	CloseProbability (CloseProbability)	Integer	MaxValue: 100 ExternalName: closeprobability ExternalType: Integer 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.
17	ActualValue (ActualValue)	Decimal	ExternalName: actualvalue ExternalType: Money 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.
18	ActualCloseDate (ActualCloseDate)	Date	ExternalName: actualclosedate ExternalType: DateTime Description: Shows the date and time when the opportunity was closed or canceled.
19	OwningUser (OwningUser)	GUID	ExternalName: owninguser ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who owns the opportunity. TableRelation: "CRM Systemuser".SystemUserId
20	OwningBusinessUnit (OwningBusinessUnit)	GUID	ExternalName: owningbusinessunit ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the business unit that owns the opportunity. TableRelation: "CRM Businessunit".BusinessUnitId
21	CreatedOn (CreatedOn)	DateTime	ExternalName: createdon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options.
22	CreatedBy (CreatedBy)	GUID	ExternalName: createdby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record. TableRelation: "CRM Systemuser".SystemUserId
23	ModifiedOn (ModifiedOn)	DateTime	ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options.
24	ModifiedBy (ModifiedBy)	GUID	ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record. TableRelation: "CRM Systemuser".SystemUserId
25	VersionNumber (VersionNumber)	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the opportunity.
26	StateCode (StateCode)	Option	[Open,Won,Lost] OptionOrdinalValues: [0;1;2] InitValue: Open ExternalName: statecode ExternalType: State ExternalAccess: Modify 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.
27	StatusCode (StatusCode)	Option	[ ,InProgress,OnHold,Won,Canceled,Out-Sold] OptionOrdinalValues: [-1;1;2;3;4;5] InitValue: [ ] ExternalName: statuscode ExternalType: Status Description: Select the opportunity's status.
28	IsRevenueSystemCalculated (IsRevenueSystemCalculated)	Boolean	ExternalName: isrevenuesystemcalculated ExternalType: Boolean Description: Select whether the estimated revenue for the opportunity is calculated automatically based on the products entered or entered manually by a user.
29	ContactIdName (ContactIdName)	Text160	ExternalName: contactidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Contact".FullName WHERE (ContactId=FIELD(ContactId)))	FlowField
30	AccountIdName (AccountIdName)	Text160	ExternalName: accountidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Account".Name WHERE (AccountId=FIELD(AccountId)))	FlowField
31	PriceLevelIdName (PriceLevelIdName)	Text100	ExternalName: pricelevelidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Pricelevel".Name WHERE (PriceLevelId=FIELD(PriceLevelId)))	FlowField
32	CreatedByName (CreatedByName)	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
33	ModifiedByName (ModifiedByName)	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
34	CustomerId (CustomerId)	GUID	ExternalName: customerid ExternalType: Customer Description: Select the customer account or contact to provide a quick link to additional customer details, such as address, phone number, activities, and orders. TableRelation: IF (CustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (CustomerIdType=CONST(contact)) "CRM Contact".ContactId;
35	CustomerIdType (CustomerIdType)	Option	[ ,account,contact] ExternalName: customeridtype ExternalType: EntityName
36	OwnerId (OwnerId)	GUID	ExternalName: ownerid ExternalType: Owner Description: Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. TableRelation: IF (OwnerIdType=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (OwnerIdType=CONST(team)) "CRM Team".TeamId;
37	OwnerIdType (OwnerIdType)	Option	[ ,systemuser,team] ExternalName: owneridtype ExternalType: EntityName
38	TransactionCurrencyId (TransactionCurrencyId)	GUID	ExternalName: transactioncurrencyid ExternalType: Lookup Description: Choose the local currency for the record to make sure budgets are reported in the correct currency. TableRelation: "CRM Transactioncurrency".TransactionCurrencyId
39	ExchangeRate (ExchangeRate)	Decimal	ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read 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.
40	ImportSequenceNumber (ImportSequenceNumber)	Integer	ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert Description: Unique identifier of the data import or data migration that created this record.
41	UTCConversionTimeZoneCode (UTCConversionTimeZoneCode)	Integer	MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer Description: Time zone code that was in use when the record was created.
42	TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber)	Integer	MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer Description: For internal use only.
43	OverriddenCreatedOn (OverriddenCreatedOn)	Date	ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert Description: Date and time that the record was migrated.
44	TransactionCurrencyIdName (TransactionCurrencyIdName)	Text100	ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Transactioncurrency".CurrencyName WHERE (TransactionCurrencyId=FIELD(TransactionCurrencyId)))	FlowField
45	ActualValue_Base (ActualValue_Base)	Decimal	ExternalName: actualvalue_base ExternalType: Money ExternalAccess: Read Description: Shows the Actual Revenue field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
46	EstimatedValue_Base (EstimatedValue_Base)	Decimal	ExternalName: estimatedvalue_base ExternalType: Money ExternalAccess: Read Description: Shows the Actual Revenue field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
47	TotalTax (TotalTax)	Decimal	ExternalName: totaltax ExternalType: Money ExternalAccess: Modify 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.
48	DiscountPercentage (DiscountPercentage)	Decimal	ExternalName: discountpercentage ExternalType: Decimal Description: Type the discount rate that should be applied to the Product Totals field to include additional savings for the customer in the opportunity.
49	TotalAmount (TotalAmount)	Decimal	ExternalName: totalamount ExternalType: Money ExternalAccess: Modify Description: Shows the total amount due, calculated as the sum of the products, discounts, freight, and taxes for the opportunity.
50	DiscountAmount (DiscountAmount)	Decimal	ExternalName: discountamount ExternalType: Money Description: Type the discount amount for the opportunity if the customer is eligible for special savings.
51	TotalAmountLessFreight (TotalAmountLessFreight)	Decimal	ExternalName: totalamountlessfreight ExternalType: Money ExternalAccess: Modify 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.
52	FreightAmount (FreightAmount)	Decimal	ExternalName: freightamount ExternalType: Money Description: Type the cost of freight or shipping for the products included in the opportunity for use in calculating the Total Amount field.
53	TotalLineItemDiscountAmount (TotalLineItemDiscountAmount)	Decimal	ExternalName: totallineitemdiscountamount ExternalType: Money ExternalAccess: Modify 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.
54	TotalLineItemAmount (TotalLineItemAmount)	Decimal	ExternalName: totallineitemamount ExternalType: Money ExternalAccess: Modify Description: Shows the sum of all existing and write-in products included on the opportunity, based on the specified price list and quantities.
55	TotalDiscountAmount (TotalDiscountAmount)	Decimal	ExternalName: totaldiscountamount ExternalType: Money ExternalAccess: Modify Description: Shows the total discount amount, based on the discount price and rate entered on the opportunity.
56	TotalLineItemAmount_Base (TotalLineItemAmount_Base)	Decimal	ExternalName: totallineitemamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Total Detail Amount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
57	TotalDiscountAmount_Base (TotalDiscountAmount_Base)	Decimal	ExternalName: totaldiscountamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Total Discount Amount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
58	TotalTax_Base (TotalTax_Base)	Decimal	ExternalName: totaltax_base ExternalType: Money ExternalAccess: Read Description: Shows the Total Tax field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
59	DiscountAmount_Base (DiscountAmount_Base)	Decimal	ExternalName: discountamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Opportunity Discount Amount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
60	TotalLineItemDiscountAmount_Ba (TotalLineItemDiscountAmount_Ba)	Decimal	ExternalName: totallineitemdiscountamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Total Line Item Discount Amount field to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
61	TotalAmount_Base (TotalAmount_Base)	Decimal	ExternalName: totalamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Total Amount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
62	TotalAmountLessFreight_Base (TotalAmountLessFreight_Base)	Decimal	ExternalName: totalamountlessfreight_base ExternalType: Money ExternalAccess: Read Description: Shows the Total Pre-Freight Amount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
63	FreightAmount_Base (FreightAmount_Base)	Decimal	ExternalName: freightamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Freight Amount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
64	CreatedOnBehalfBy (CreatedOnBehalfBy)	GUID	ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
65	CreatedOnBehalfByName (CreatedOnBehalfByName)	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
66	ModifiedOnBehalfBy (ModifiedOnBehalfBy)	GUID	ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
67	ModifiedOnBehalfByName (ModifiedOnBehalfByName)	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
68	OwningTeam (OwningTeam)	GUID	ExternalName: owningteam ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the team who owns the opportunity. TableRelation: "CRM Team".TeamId
69	BudgetStatus (BudgetStatus)	Option	[ ,NoCommittedBudget,MayBuy,CanBuy,WillBuy] OptionOrdinalValues: [-1;0;1;2;3] InitValue: [ ] ExternalName: budgetstatus ExternalType: Picklist Description: Select the likely budget status for the lead's company. This may help determine the lead rating or your sales approach.
70	DecisionMaker (DecisionMaker)	Boolean	ExternalName: decisionmaker ExternalType: Boolean Description: Select whether your notes include information about who makes the purchase decisions at the lead's company.
71	Need (Need)	Option	[ ,Musthave,Shouldhave,Goodtohave,Noneed] OptionOrdinalValues: [-1;0;1;2;3] InitValue: [ ] ExternalName: need ExternalType: Picklist Description: Choose how high the level of need is for the lead's company.
72	TimeLine (TimeLine)	Option	[ ,Immediate,ThisQuarter,NextQuarter,ThisYear,Notknown] OptionOrdinalValues: [-1;0;1;2;3;4] InitValue: [ ] ExternalName: timeline ExternalType: Picklist Description: Select when the opportunity is likely to be closed.
73	BudgetAmount (BudgetAmount)	Decimal	ExternalName: budgetamount ExternalType: Money Description: Type a value between 0 and 1,000,000,000,000 to indicate the lead's potential available budget.
74	BudgetAmount_Base (BudgetAmount_Base)	Decimal	ExternalName: budgetamount_base ExternalType: Money ExternalAccess: Read Description: Shows the budget amount converted to the system's base currency.
75	ParentAccountId (ParentAccountId)	GUID	ExternalName: parentaccountid ExternalType: Lookup 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. TableRelation: "CRM Account".AccountId
76	ParentAccountIdName (ParentAccountIdName)	Text160	ExternalName: parentaccountidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Account".Name WHERE (AccountId=FIELD(ParentAccountId)))	FlowField
77	ParentContactId (ParentContactId)	GUID	ExternalName: parentcontactid ExternalType: Lookup Description: Choose a contact to connect this opportunity to, so that the relationship is visible in reports and analytics. TableRelation: "CRM Contact".ContactId
78	ParentContactIdName (ParentContactIdName)	Text160	ExternalName: parentcontactidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Contact".FullName WHERE (ContactId=FIELD(ParentContactId)))	FlowField
79	EvaluateFit (EvaluateFit)	Boolean	ExternalName: evaluatefit ExternalType: Boolean Description: Select whether the fit between the lead's requirements and your offerings was evaluated.
80	InitialCommunication (InitialCommunication)	Option	[ ,Contacted,NotContacted] OptionOrdinalValues: [-1;0;1] InitValue: [ ] ExternalName: initialcommunication ExternalType: Picklist Description: Choose whether someone from the sales team contacted this lead earlier.
81	ConfirmInterest (ConfirmInterest)	Boolean	ExternalName: confirminterest ExternalType: Boolean 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.
82	ScheduleFollowup_Prospect (ScheduleFollowup_Prospect)	Date	ExternalName: schedulefollowup_prospect ExternalType: DateTime Description: Enter the date and time of the prospecting follow-up meeting with the lead.
83	ScheduleFollowup_Qualify (ScheduleFollowup_Qualify)	Date	ExternalName: schedulefollowup_qualify ExternalType: DateTime Description: Enter the date and time of the qualifying follow-up meeting with the lead.
84	ScheduleProposalMeeting (ScheduleProposalMeeting)	Date	ExternalName: scheduleproposalmeeting ExternalType: DateTime Description: Enter the date and time of the proposal meeting for the opportunity.
85	FinalDecisionDate (FinalDecisionDate)	Date	ExternalName: finaldecisiondate ExternalType: DateTime Description: Enter the date and time when the final decision of the opportunity was made.
86	DevelopProposal (DevelopProposal)	Boolean	ExternalName: developproposal ExternalType: Boolean Description: Select whether a proposal has been developed for the opportunity.
87	CompleteInternalReview (CompleteInternalReview)	Boolean	ExternalName: completeinternalreview ExternalType: Boolean Description: Select whether an internal review has been completed for this opportunity.
88	CaptureProposalFeedback (CaptureProposalFeedback)	Boolean	ExternalName: captureproposalfeedback ExternalType: Boolean Description: Choose whether the proposal feedback has been captured for the opportunity.
89	ResolveFeedback (ResolveFeedback)	Boolean	ExternalName: resolvefeedback ExternalType: Boolean Description: Choose whether the proposal feedback has been captured and resolved for the opportunity.
90	PresentProposal (PresentProposal)	Boolean	ExternalName: presentproposal ExternalType: Boolean Description: Select whether a proposal for the opportunity has been presented to the account.
91	SendThankYouNote (SendThankYouNote)	Boolean	ExternalName: sendthankyounote ExternalType: Boolean Description: Select whether a thank you note has been sent to the account for considering the proposal.
92	SalesStage (SalesStage)	Option	[ ,Qualify,Develop,Propose,Close] OptionOrdinalValues: [-1;0;1;2;3] InitValue: [ ] ExternalName: salesstage ExternalType: Picklist Description: Select the sales stage of this opportunity to aid the sales team in their efforts to win this opportunity.
93	TraversedPath (TraversedPath)	Text250	ExternalName: traversedpath ExternalType: String Description: For internal use only.
94	CompleteFinalProposal (CompleteFinalProposal)	Boolean	ExternalName: completefinalproposal ExternalType: Boolean Description: Select whether a final proposal has been completed for the opportunity.
95	FileDebrief (FileDebrief)	Boolean	ExternalName: filedebrief ExternalType: Boolean Description: Choose whether the sales team has recorded detailed notes on the proposals and the account's responses.
96	PursuitDecision (PursuitDecision)	Boolean	ExternalName: pursuitdecision ExternalType: Boolean Description: Select whether the decision about pursuing the opportunity has been made.
97	CustomerPainPoints (CustomerPainPoints)	BLOB [Memo]	ExternalName: customerpainpoints ExternalType: Memo Description: Type notes about the customer's pain points to help the sales team identify products and services that could address these pain points.
98	CustomerNeed (CustomerNeed)	BLOB [Memo]	ExternalName: customerneed ExternalType: Memo Description: Type some notes about the customer's requirements, to help the sales team identify products and services that could meet their requirements.
99	ProposedSolution (ProposedSolution)	BLOB [Memo]	ExternalName: proposedsolution ExternalType: Memo Description: Type notes about the proposed solution for the opportunity.
100	QualificationComments (QualificationComments)	BLOB [Memo]	ExternalName: qualificationcomments ExternalType: Memo Description: Type comments about the qualification or scoring of the lead.
101	QuoteComments (QuoteComments)	BLOB [Memo]	ExternalName: quotecomments ExternalType: Memo Description: Type comments about the quotes associated with the opportunity.
102	PurchaseProcess (PurchaseProcess)	Option	[ ,Individual,Committee,Unknown] OptionOrdinalValues: [-1;0;1;2] InitValue: [ ] ExternalName: purchaseprocess ExternalType: Picklist Description: Choose whether an individual or a committee will be involved in the purchase process for the lead.
103	PurchaseTimeframe (PurchaseTimeframe)	Option	[ ,Immediate,ThisQuarter,NextQuarter,ThisYear,Unknown] OptionOrdinalValues: [-1;0;1;2;3;4] InitValue: [ ] ExternalName: purchasetimeframe ExternalType: Picklist Description: Choose how long the lead will likely take to make the purchase.
104	IdentifyCustomerContacts (IdentifyCustomerContacts)	Boolean	ExternalName: identifycustomercontacts ExternalType: Boolean Description: Select whether the customer contacts for this opportunity have been identified.
105	IdentifyCompetitors (IdentifyCompetitors)	Boolean	ExternalName: identifycompetitors ExternalType: Boolean Description: Select whether information about competitors is included.
106	IdentifyPursuitTeam (IdentifyPursuitTeam)	Boolean	ExternalName: identifypursuitteam ExternalType: Boolean Description: Choose whether you have recorded who will pursue the opportunity.
107	CurrentSituation (CurrentSituation)	BLOB [Memo]	ExternalName: currentsituation ExternalType: Memo Description: Type notes about the company or organization associated with the opportunity.
108	PresentFinalProposal (PresentFinalProposal)	Boolean	ExternalName: presentfinalproposal ExternalType: Boolean Description: Select whether the final proposal has been presented to the account.
109	StageId (StageId)	GUID	ExternalName: stageid ExternalType: Uniqueidentifier Description: Shows the ID of the stage.
110	ProcessId (ProcessId)	GUID	ExternalName: processid ExternalType: Uniqueidentifier Description: Shows the ID of the process.

Keys

#	Fields
0	OpportunityId (OpportunityId)		Clustered: Yes
1	Name (Name)

Table Relations To Other Tables

Field	Related Table	Related Field
ParentAccountId (ParentAccountId)	CRM Account	AccountId (AccountId)	TableRelation: "CRM Account".AccountId	1..n
OwningBusinessUnit (OwningBusinessUnit)	CRM Businessunit	BusinessUnitId (BusinessUnitId)	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
ParentContactId (ParentContactId)	CRM Contact	ContactId (ContactId)	TableRelation: "CRM Contact".ContactId	1..n
PriceLevelId (PriceLevelId)	CRM Pricelevel	PriceLevelId (PriceLevelId)	TableRelation: "CRM Pricelevel".PriceLevelId	1..n
ModifiedOnBehalfBy (ModifiedOnBehalfBy)	CRM Systemuser	SystemUserId (SystemUserId)	TableRelation: "CRM Systemuser".SystemUserId	1..n
OwningTeam (OwningTeam)	CRM Team	TeamId (TeamId)	TableRelation: "CRM Team".TeamId	1..n
TransactionCurrencyId (TransactionCurrencyId)	CRM Transactioncurrency	TransactionCurrencyId (TransactionCurrencyId)	TableRelation: "CRM Transactioncurrency".TransactionCurrencyId	1..n

Table Relations From Other Tables

From Table	From Field
CRM Invoice	OpportunityId (OpportunityId)	TableRelation: "CRM Opportunity".OpportunityId	1..n
CRM Post	RegardingObjectId (RegardingObjectId)	TableRelation: IF (RegardingObjectTypeCode=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (RegardingObjectTypeCode=CONST(account)) "CRM Account".AccountId ELSE IF (RegardingObjectTypeCode=CONST(contact)) "CRM Contact".ContactId ELSE IF (RegardingObjectTypeCode=CONST(opportunity)) "CRM Opportunity".OpportunityId ELSE IF (RegardingObjectTypeCode=CONST(post)) "CRM Post".PostId ELSE IF (RegardingObjectTypeCode=CONST(transactioncurrency)) "CRM Transactioncurrency".TransactionCurrencyId ELSE IF (RegardingObjectTypeCode=CONST(pricelevel)) "CRM Pricelevel".PriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(productpricelevel)) "CRM Productpricelevel".ProductPriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(product)) "CRM Product".ProductId ELSE IF (RegardingObjectTypeCode=CONST(incident)) "CRM Incident".IncidentId ELSE IF (RegardingObjectTypeCode=CONST(incidentresolution)) "CRM Incidentresolution".ActivityId ELSE IF (RegardingObjectTypeCode=CONST(quote)) "CRM Quote".QuoteId ELSE IF (RegardingObjectTypeCode=CONST(quotedetail)) "CRM Quotedetail".QuoteDetailId ELSE IF (RegardingObjectTypeCode=CONST(salesorder)) "CRM Salesorder".SalesOrderId ELSE IF (RegardingObjectTypeCode=CONST(salesorderdetail)) "CRM Salesorderdetail".SalesOrderDetailId ELSE IF (RegardingObjectTypeCode=CONST(invoice)) "CRM Invoice".InvoiceId ELSE IF (RegardingObjectTypeCode=CONST(invoicedetail)) "CRM Invoicedetail".InvoiceDetailId ELSE IF (RegardingObjectTypeCode=CONST(contract)) "CRM Contract".ContractId ELSE IF (RegardingObjectTypeCode=CONST(team)) "CRM Team".TeamId ELSE IF (RegardingObjectTypeCode=CONST(customeraddress)) "CRM Customeraddress".CustomerAddressId ELSE IF (RegardingObjectTypeCode=CONST(uom)) "CRM Uom".UoMId ELSE IF (RegardingObjectTypeCode=CONST(uomschedule)) "CRM Uomschedule".UoMScheduleId ELSE IF (RegardingObjectTypeCode=CONST(organization)) "CRM Organization".OrganizationId ELSE IF (RegardingObjectTypeCode=CONST(businessunit)) "CRM Businessunit".BusinessUnitId ELSE IF (RegardingObjectTypeCode=CONST(discount)) "CRM Discount".DiscountId ELSE IF (RegardingObjectTypeCode=CONST(discounttype)) "CRM Discounttype".DiscountTypeId;	1..n
CRM Quote	OpportunityId (OpportunityId)	TableRelation: "CRM Opportunity".OpportunityId	1..n
CRM Salesorder	OpportunityId (OpportunityId)	TableRelation: "CRM Opportunity".OpportunityId	1..n
CRM Team	RegardingObjectId (RegardingObjectId)	TableRelation: IF (RegardingObjectTypeCode=CONST(opportunity)) "CRM Opportunity".OpportunityId	1..n

Diagrams

Tables A-Z

a

b

c

d

e

f

g

h

i

j

l

m

n

o

p

q

r

s

t

u

v

w

x

z

Table

CRM Opportunity

Fields

Keys

Table Relations To Other Tables

Table Relations From Other Tables