cdf_Contact Table

Data in the cdf_Contact 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_Contact 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 Contact 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	ContactId	int (PK)	Required
	StateCode1	int (state)		0 (Active) 1 (Inactive)	0
	StatusCode1	int (status)		1 (Active)	For StateCode 0, 1
				2 (Inactive)	For StateCode 1, 2
	ParentContactId		Relationship
	ParentContactIdName2	nvarchar (160)
General tab
Salutation	Salutation	nvarchar (100)
First Name	FirstName	nvarchar (50)
Middle Name	MiddleName	nvarchar (50)
Last Name	LastName	nvarchar (50)
Job Title	JobTitle	nvarchar (100)
Parent Account	AccountId	int	Relationship
	AccountIdName2	nvarchar (160)
Business Phone	Telephone1	nvarchar (50)
Home Phone	Telephone2	nvarchar (50)
Mobile Phone	MobilePhone	nvarchar (50)
Fax	Fax	nvarchar (50)
Pager	Pager	nvarchar (50)
E-mail	EmailAddress1	nvarchar (100)
Address Name	Address1_Name	nvarchar (200)
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/PostalCode	Address1_PostalCode	nvarchar (20)
Country/Region	Address1_Country	nvarchar (50)
Phone	Address1_Telephone	nvarchar (50)
Address Type	Address1_AddressTypeCode	int (picklist)
	Address1_AddressTypeCodeName2	nvarchar (200) (picklist)
Shipping Method	Address1_ShippingMethodCode	int (picklist)
	Address1_ShippingMethodCodeName2	nvarchar (200) (picklist)
Freight Terms	Address1_FreightTermsCode	int (picklist)
	Address1_FreightTermsCodeName2	nvarchar (200) (picklist)
Details tab
Department	Department	nvarchar (100)
Role	AccountRoleCode	int (picklist)
	AccountRoleCodeName2	nvarchar (200) (picklist)		Decision Maker Employee Influencer	Null
Manager	ManagerName	nvarchar (100)
Manager’s Phone	ManagerPhone	nvarchar (50)
Assistant	AssistantName	nvarchar (100)
Assistant’s Phone	AssistantPhone	nvarchar (50)
Gender	GenderCode	int (picklist)
	GenderCodeName2	nvarchar (200) (picklist)		Male Female	Null
Marital Status	FamilyStatusCode	int (picklist)			Null
	FamilyStatusCodeName2	nvarchar (200) (picklist)		Single Married Divorced Widowed	Null
Spouse’s Name	SpousesName	nvarchar (100)
Birthday	Birthdate3	datetime
Anniversary	Anniversary3	datetime
Description	Description	ntext
Administration tab
Owner	OwningUser	int	Required, Relationship
	OwningUserName2	nvarchar (255)
Originating Lead	OriginatingLeadId	int	Relationship
	OriginatingLeadIdName2	nvarchar (160)
Credit Limit ($)	CreditLimit	money
Credit Hold	CreditOnHold	bit		0 (No) 1 (Yes)	0
Payment Terms	PaymentTermsCode	int (picklist)
	PaymentTermsCodeName2	nvarchar (200) (picklist)		Net 30 2%10, Net 30 Net 45 Net 60	Null
Price List	DefaultPriceLevelId	int	Relationship
	DefaultPriceLevelIdName2	nvarchar (100)
Preferred	PreferredContactMethodCode	int (picklist)			1
	PreferredContactMethodCodeName2	nvarchar (200) (picklist)		Any E-mail Phone Fax Mail	Any
E-mail	DoNotEmail	bit		0 (Allow) 1 (Do Not Allow)	0
Phone	DoNotPhone	bit		0 (Allow) 1 (Do Not Allow)	0
Fax	DoNotFax	bit		0 (Allow) 1 (Do Not Allow)	0
Mail	DoNotPostalMail	bit		0 (Allow) 1 (Do Not Allow)	0
Not on tab by default	Address1_Fax	nvarchar (20)
	Address1_Latitude	float
	Address1_Longitude	float
	Address1_PostOfficebox	nvarchar (20)
	Address1_PrimaryContactName	nvarchar (150)
	Address1_Telephone2	nvarchar (50)
	Address1_Telephone3	nvarchar (50)
	Address1_UPSZone	nvarchar (4)
	Address1_County	nvarchar (50)
	Address2_AddressTypeCode	int (picklist)
	Address2_AddressTypeCodeName2	nvarchar (200) (picklist)		Default Value	Default Value
	Address2_City	nvarchar (50)
	Address2_Country	nvarchar (50)
	Address2_County	nvarchar (50)
	Address2_Fax	nvarchar (20)
	Address2_FreightTermsCode	int (picklist)
	Address2_FreightTermsCodeName2	nvarchar (200) (picklist)		Default Value	Default Value
	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_PrimaryContactName	nvarchar (150)
	Address2_ShippingMethodCode	int (picklist)
	Address2_ShippingMethodCodeName2	nvarchar (200) (picklist)		Default Value	Default Value
	Address2_StateOrProvince	nvarchar (50)
	Address2_Telephone1	nvarchar (50)
	Address2_Telephone2	nvarchar (50)
	Address2_Telephone3	nvarchar (50)
	Address2_UPSZone	nvarchar (4)
	Address1_UTCOffset	int
	Address2_UTCOffset	int
	AnnualIncome	money
	ChildrensNames	nvarchar (255)
	CustomerSizeCode	int (picklist)
	CustomerSizeCodeName2	nvarchar (200) (picklist)		Default Value	Default Value
	CustomerTypeCode	int (picklist)
	CustomerTypeCodeName2	nvarchar (200) (picklist)		Default Value	Default Value
	DoNotBulkEmail	bit		0 (False) 1 (True)	1
	DoNotBulkPostalMail	bit		0 (False) 1 (True)	1
	EducationCode	int (picklist)
	EducationCodeName2	nvarchar (200) (picklist)		Default Value	Default Value
	EmailAddress2	nvarchar (100)
	EmailAddress3	nvarchar (100)
	EmployeeId	nvarchar (50)
	FtpSiteUrl	nvarchar (200)
	FullName	nvarchar (160)
	GovernmentId	nvarchar (50)
	HasChildrenCode	int (picklist)
	HasChildrenCodeName2	nvarchar (200) (picklist)		Default Value	Default Value
	IsBackOfficeCustomer	bit		0 (False) 1 (True)	0
	LeadSourceCode	int (picklist)
	LeadSourceCodeName2	nvarchar (200) (picklist)		Default Value	Default Value
	NickName	nvarchar (50)
	NumberOfChildren	int
	ShippingMethodCode	int (picklist)
	ShippingMethodCodeName2	nvarchar (200) (picklist)		Default Value	Default Value
	Status Reason	int (status)
	Suffix	nvarchar (10)
	Telephone3	nvarchar (50)
	TerritoryCode	int (picklist)
	TerritoryCodeName2	nvarchar (200) (picklist)		Default Value	Default Value
	WebSiteUrl	nvarchar (200)
	YomiFirstName	nvarchar (150)
	YomiFullName	nvarchar (450)
	YomiLastName	nvarchar (150)
	YomiMiddleName	nvarchar (150)

¹ See StateCode and StatusCode Values.

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

³ Values for all attributes of the type datetime must be in the 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). An example is 2003-09-05. If a time is included, it is migrated as the Greenwich Mean Time (GMT) time.

© 2005 Microsoft Corporation. All rights reserved.