cdf_Competitor Table

Data in the cdf_Competitor 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_Competitor 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 Competitor 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	CompetitorId	int (PK)	Required
General tab
Name	Name	nvarchar (100)	Required
Ticker Symbol	StockExchange	nvarchar (20)
Key Product	KeyProduct	nvarchar (200)
Web Site	WebSiteUrl	nvarchar (200)
Reported Revenue ($)	ReportedRevenue	money
Street 1	Address1_Line1	nvarchar (50)
Street 2	Address1_Line2	nvarchar (50)
Street 3	Address1_Line3	nvarchar (50)
City	Address1_City	nvarchar (50)
State/Province	Address1_StateOrProvince	nvarchar (50)
ZIP/Postal Code	Address1_PostalCode	nvarchar (20)
Country/Region	Address1_Country	nvarchar (50)
Analysis tab
Overview	Overview	ntext
Strength	Strengths	ntext
Weakness	Weaknesses	ntext
Opportunity	Opportunities	ntext
Threat	Threats	ntext
Not on tab by default
	Address1_TypeCode	int (picklist)
	Address1_TypeCodeName1	nvarchar (200) (picklist)		Default Value	Default Value
	Address1_County	nvarchar (50)
	Address1_Fax	nvarchar (20)
	Address1_Latitude	float
	Address1_Longitude	float
	Address1_Name	nvarchar (200)
	Address1_PostOfficeBox	nvarchar (20)
	Address1_ShippingMethodCode	int (picklist)
	Address1_ShippingMethodCodeName1	nvarchar (200) (picklist)		Default Value	Default Value
	Address1_Telephone1	nvarchar (50)
	Address1_Telephone2	nvarchar (50)
	Address1_Telephone3	nvarchar (50)
	Address1_UPSZone	nvarchar (4)
	Address2_AddressTypeCode	int (picklist)
	Address2_AddressTypeCodeName1	nvarchar (200) (picklist)		Default Value	Default Value
	Address2_City	nvarchar (50)
	Address2_Country	nvarchar (50)
	Address2_County	nvarchar (50)
	Address2_StateOrProvince	nvarchar (50)
	Address2_Fax	nvarchar (20)
	Address2_Latitude	float
	Address2_Line1	nvarchar (50)
	Address2_Line2	nvarchar (50)
	Address2_Line3	nvarchar (50)
	Address2_Longitude	float
	Address2_Name	nvarchar (200)
	Address2_PostalCode	nvarchar (20)
	Address2_PostOfficeBox	nvarchar (20)
	Address2_ShippingMethodCode	int (picklist)		Default Value	Default Value
	Address2_ShippingMethodCodeName1	nvarchar (200) (picklist)
	Address2_Telephone1	nvarchar (50)
	Address2_Telephone2	nvarchar (50)
	Address2_Telephone3	nvarchar (50)
	Address2_UPSZone	nvarchar (4)
	ReferenceInfoUrl	nvarchar (200)
	ReportingQuarter	int
	ReportingYear	int
	TickerSymbol	nvarchar (10)
	WinPercentage	float
	Address1_UTCOffset	int
	Address1_FreightTermsCode	int
	Address1_PrimaryContactName	nvarchar (150)
	Address2_UTCOffset	int
	Address2_FreightTermsCode	int
	Address2_PrimaryContactName	nvarchar (150)
Not migrated
	Address1_AddressId
	Address2_AddressId
	CreatedBy
	CreatedOn
	DeletionStateCode
	ModifiedOn
	ModifiedBy
	SecurityDescriptor
	VersionNumber

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

© 2005 Microsoft Corporation. All rights reserved.