cdf_Opportunity Table

Data in the cdf_Opportunity table must meet the migration criteria specified in Data Requirements for Migration. The following table shows all of the attributes in Microsoft CRM that can be migrated from the cdf_Opportunity table and the respective attribute names and types in the CDF database. The table also shows whether the attribute is required and whether it is used to create a relationship with other entities. For drop-down lists and Boolean attributes, the table shows the valid values and the default value in Microsoft CRM. The last rows of the table list the Microsoft CRM Opportunity attributes that cannot be migrated using the Microsoft CRM Data Migration Framework.

Microsoft CRM tab name and attribute label	CDF attribute name	CDF type	Required or Relationship in CDF	Valid Microsoft CRM values	Default Microsoft CRM value
Not on tab	OpportunityId	int (PK)	Required
	StateCode1	int (state)		0 (Open) 1 (Won) 2 (Lost)	0
General tab
Price List	PriceLevelId	int	Relationship
	PriceLevelIdName1	nvarchar (100)
Topic	Name	nvarchar (300)
Potential Customer	ContactId	int	Required 2 , Relationship
	ContactIdName1	nvarchar (160)
	AccountId	int	Required 2 , Relationship
	AccountIdName1	nvarchar (160)
Revenue	IsRevenueSystemCalculated	bit		0 (User Provided)/ 1 (System Calculated)	1
Est. Revenue	EstimatedValue	money
Est. Close Date	EstimatedCloseDate3	datetime
Probability	CloseProbability	int
Rating	OpportunityRatingCode	int (picklist)			2
	OpportunityRatingCodeName1	nvarchar (200) picklist		Hot Warm Cold	Warm
Description	Description	ntext
Administration tab
Owner	OwningUser	int	Required, Relationship
	OwningUserName1	nvarchar (255)
Status Reason	StatusCode	int (status)		1 (In Progress) 2 (On Hold) 3 (Won) 4 (Canceled) 5 (Out-Sold)	For StateCode 0, 1 For StateCode 1,3 For StateCode 2, 4
Originating Lead	OriginatingLeadId	int	Relationship
	OriginatingLeadIdName1	nvarchar (160)
Not on tab by default
Actual Close Date	ActualCloseDate3	datetime
Actual Revenue	ActualRevenue	money
Priority Code	PriorityCode	int (picklist)
	PriorityCodeName1	nvarchar (200) picklist
Sales Stage Code	SalesStageCode	int (picklist)
	SalesStageCodeName1	nvarchar (200) picklist
Step Name	StepName	nvarchar (300)
Not migrated
	DiscountPercentage
	IsPrivate
	CreatedBy
	CreatedOn
	CustomerId
	CustomerIdType
	DeletionStateCode
	ModifiedBy
	ModifiedOn
	OwnerId
	OwnerIdType
	OwningTeam
	ParticipatesInWorkflow
	StepId
	SecurityDescriptor
	VersionNumber

¹ The field is used only in the CDF database; it is not migrated.

² Either AccountId or ContactId is required.

³ Values for all attributes of type datetime must be in Coordinated Universal Time (UTC) format CCYY-MM-DD, where CC is the century (00-99), YY is the year (00-99), MM is the month (01-12), and DD is the day of month (01-31), for example, 2003-09-05. If a time is included, it is migrated as the Greenwich Mean Time (GMT) time.

© 2005 Microsoft Corporation. All rights reserved.