cdf_CustomerAddress Table
Data in the cdf_CustomerAddress 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_CustomerAddress 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 CustomerAddress 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 | ParentId | int (PK) | Required, Relationship | ||
CustomerAddressId | int (PK) | Required | |||
ObjectTypeCode | int (picklist) | Required | 1 | * | |
2 | |||||
ObjectTypeCodeName** | nvarchar (150) (picklist) | Account (1)
Contact (2) |
|||
General tab | |||||
Address Name | Name | nvarchar (200) | |||
Street 1 | Line1 | nvarchar (50) | |||
Street 2 | Line2 | nvarchar (50) | |||
Street 3 | Line3 | nvarchar (50) | |||
City | City | nvarchar (50) | |||
State/Province | StateOrProvince | nvarchar (50) | |||
ZIP/Postal Code | PostalCode | nvarchar (20) | |||
Country/Region | Country | nvarchar (50) | |||
Address Type | AddressTypeCode | int (picklist) | |||
AddressTypeCodeName** | nvarchar (150) (picklist) | Bill To
Ship To Primary Other |
Null | ||
Main Phone | Telephone1 | nvarchar (50) | |||
Phone 2 | Telephone2 | nvarchar (50) | |||
Fax | Fax | nvarchar (50) | |||
Shipping Method | ShippingMethodCode | int (picklist) | |||
ShippingMethodCodeName** | nvarchar (200) (picklist) | Airborne
DHL FedEx UPS Postal Mail Full Load Will Call |
Null | ||
Freight Terms | FreightTermsCode | int (picklist) | |||
FreightTermsCodeName** | nvarchar (150) (picklist) | FOB
No Charge |
Null | ||
Address Contact | PrimaryContactName | nvarchar (150) | |||
Not on tab by default | AddressNumber | int | |||
County | nvarchar (50) | ||||
Latitude | float | ||||
Longitude | float | ||||
PostOfficeBox | nvarchar (20) | ||||
Telephone3 | nvarchar (50) | ||||
UTCOffset | int | ||||
UPSZone | nvarchar (4) | ||||
Not migrated | |||||
CreatedBy | |||||
CreatedOn | |||||
DeletionStateCode | |||||
ModifiedBy | |||||
ModifiedOn | |||||
VersionNumber |
Table Footnotes
*ObjectTypeCode data is not in the cdf_StringMapCrm table; you must cleanse the data manually.
**The field is used only in the CDF databse; it is not migrated.