Share via

cdf_Lead Table

  • Article

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
Microsoft CRM values		 Default Microsoft CRM value
Not on tab LeadId   Required    
  StateCode* int (state)   0 (Open)

1 (Qualified)

2 (Disqualified)

 0
General tab          
Topic Subject nvarchar (100) Required    
First Name FirstName nvarchar (50)      
Last Name LastName nvarchar (50) Required    
Company Name CompanyName nvarchar (100) Required    
Salutation Salutation nvarchar (100)      
Job Title JobTitle nvarchar (100)      
Rating LeadQualityCode int (picklist)      
  LeadQualityCodeName** 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 No. of Employees int      
SIC Code SIC nvarchar (20)      
Industry IndustryCode int (picklist)      
  IndustryCodeName** nvarchar (200) (picklist)     Null
Lead Source LeadSourceCode int (picklist)   Null Null
  LeadSourceCodeName** 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    
  OwningUserName** nvarchar (255)      
Status Reason StatusCode* 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)      
  PreferredContactMethodCodeName** 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_AddressTypeCodeName** 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_ShippingMethodCodeName** nvarchar (200) (picklist)      
  Address1_Telephone1 nvarchar (50)      
  Address1_Telephone2 nvarchar (50)      
  Address1_Telephone3 nvarchar (50)      
  Address1_UpsZone nvarchar (4)      
  Address2_AddressTypeCode int (picklist)      
  Address2_AddressTypeCodeName** 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_ShippingMethodCodeName** nvarchar (200) (picklist)      
  Address2_Telephone1 nvarchar (50)      
  Address2_Telephone2 nvarchar (50)      
  Address2_Telephone3 nvarchar (50)      
  Address2_UPSZone nvarchar (4)      
CustomerId ContactId int Relationship    
  ContactIdName** nvarchar (160)      
  AccountId int Relationship    
  AccountIdName** nvarchar (160)      
  EmailAddress2 nvarchar (100)      
  EmailAddress3 nvarchar (100)      
  EstimatedCloseDate*** datetime      
  EstimatedValue float      
  MiddleName nvarchar (50)      
  FullName nvarchar (160)      
  PriorityCode int (picklist)      
  PriorityCodeName** nvarchar (200) (picklist)   Default Value Default Value
  SalesStageCode int (picklist)      
  SalesStageCodeName** 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        

Table Footnotes

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

© 2003 Microsoft Corporation. All rights reserved.