cdf_Lead Table

Data in the cdf_Lead 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_Lead 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 Lead 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	LeadId	int (PK)	Required
	StateCode1	int (state)		0 (Open) 1 (Qualified) 2 (Disqualified)	0
General tab
Topic	Subject	nvarchar (100)
First Name	FirstName	nvarchar (50)
Last Name	LastName	nvarchar (50)
Company Name	CompanyName	nvarchar (100)
Salutation	Salutation	nvarchar (100)
Job Title	JobTitle	nvarchar (100)
Rating	LeadQualityCode	int (picklist)			2
	LeadQualityCodeName2	nvarchar (200) (picklist)		Hot Warm Cold	Warm
Business Phone	Telephone1	nvarchar (50)
Home Phone	Telephone2	nvarchar (50)
Other Phone	Telephone3	nvarchar (50)
Mobile Phone	MobilePhone	nvarchar (50)
Fax	Fax	nvarchar (50)
Pager	Pager	nvarchar (50+G96)
E-mail	EmailAddress1	nvarchar (100)
Web Site	WebSiteUrl	nvarchar (200)
Description	Description	ntext
Details tab
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)
Annual Revenue ($)	Revenue	money
No. of Employees	NumberofEmployees	int
SIC Code	SIC	nvarchar (20)
Industry	IndustryCode	int (picklist)
	IndustryCodeName2	nvarchar (200) (picklist)			Null
Lead Source	LeadSourceCode	int (picklist)			Null
	LeadSourceCodeName2	nvarchar (200) (picklist)		Advertisement Employee Referral External Referral Partner Public Relations Seminar Trade Show Web Word of Mouth Other	Null
Administration tab
Owner	OwningUser	int	Required, Relationship
	OwningUserName2	nvarchar (255)
Status Reason	StatusCode1	int (status)		1 (New)	For StateCode 0, 1
				2 (Contacted)
				3 (Qualified)	For StateCode 1, 3
				4 (Lost) 5 (Cannot Contact) 6 (No Longer Interested) 7 (Canceled)	For StateCode 2, 4
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_AddressTypeCode	int (picklist)
	Address1_AddressTypeCodeName2	nvarchar (200) (picklist)
	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_ShippingMethodCodeName2	nvarchar (200) (picklist)
	Address1_Telephone1	nvarchar (50)
	Address1_Telephone2	nvarchar (50)
	Address1_Telephone3	nvarchar (50)
	Address1_UPSZone	nvarchar (4)
	Address2_AddressTypeCode	int (picklist)
	Address2_AddressTypeCodeName2	nvarchar (200) (picklist)
	Address2_County	nvarchar (50)
	Address2_Fax	nvarchar (20)
	Address2_Latitude	float
	Address2_Longitude	float
	Address2_Name	nvarchar (200)
	Address2_PostOfficeBox	nvarchar (20)
	Address2_ShippingMethodCode	int (picklist)
	Address2_ShippingMethodCodeName2	nvarchar (200) (picklist)
	Address2_Telephone1	nvarchar (50)
	Address2_Telephone2	nvarchar (50)
	Address2_Telephone3	nvarchar (50)
	Address2_UPSZone	nvarchar (4)
CustomerId	ContactId	int	Relationship
	ContactIdName2	nvarchar (160)
	AccountId	int	Relationship
	AccountIdName2	nvarchar (160)
	EmailAddress2	nvarchar (100)
	EmailAddress3	nvarchar (100)
	EstimatedCloseDate3	datetime
	EstimatedValue	float
	MiddleName	nvarchar (50)
	FullName	nvarchar (160)
	PriorityCode	int (picklist)
	PriorityCodeName2	nvarchar (200) (picklist)		Default Value	Default Value
	SalesStageCode	int (picklist)
	SalesStageCodeName2	nvarchar (200) (picklist)		Default Value	Default Value
	Address1_UTCOffset	int
	Address2_UTCOffset	int
	YomiFirstName	nvarchar (150)
	YomiFullName	nvarchar (450)
	YomiLastName	nvarchar (150)
	YomiMiddleName	nvarchar (150)
Not migrated	IsPrivate
	Address1_AddressId
	Address2_AddressId
	CreatedBy
	CreatedOn
	DeletionStateCode
	ModifiedBy
	ModifiedOn
	VersionNumber
	CustomerId
	CustomerIdType
	OwnerId
	OwnerIdType
	OwningTeam
	ParticipatesInWorkflow
	SecurityDescriptor

¹ See StateCode and StatusCode Values.

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

³ 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.