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	Valid Microsoft CRM values	Default Microsoft CRM value
Not on tab	ParentId	int	Required, Relationship
	CustomerAddressId	int (PK)	Required
	ObjectTypeCode	int (picklist)	Required	1	1
				2
	ObjectTypeCodeName2	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)
	AddressTypeCodeName2	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)
	ShippingMethodCodeName2	nvarchar (200) (picklist)		Airborne DHL FedEx UPS Postal Mail Full Load Will Call	Null
Freight Terms	FreightTermsCode	int (picklist)
	FreightTermsCodeName2	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

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

© 2005 Microsoft Corporation. All rights reserved.