cdf_Product Table

Data in the cdf_Product 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_Product 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 Product 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	ProductId	int (PK)	Required
	StateCode1	int (state)		0 (Active) 1 (Inactive)	0
General tab
ID	ProductNumber	nvarchar (100)	Required
Name	Name	nvarchar (100)	Required
Subject	SubjectId	int	Relationship
	SubjectIdName2	nvarchar (500)
Unit Group	DefaultUoMScheduleId	int	Relationship
	DefaultUoMScheduleIdName2	nvarchar (200)
Default Unit	DefaultUoMId	int	Relationship
	DefaultUoMIdName1	nvarchar (100)
Product Type	ProductTypeCode	int (picklist)			1
	ProductTypeCodeName2	nvarchar (200) (picklist)		Sales Inventory Miscellaneous Charges Services Flat Fees	Sales Inventory
Quantity on Hand	QuantityonHand	decimal 9 (18,5)
URL	ProductURL	nvarchar (255)
Default Price List	PriceLevelId	int	Relationship
	PriceLevelIdName2	nvarchar (100)
Decimals Supported	QuantityDecimal	int			0
List Price	Price	money
Standard Cost	StandardCost	money
Current Cost	CurrentCost	money
Description tab
Vendor	VendorName	nvarchar (100)
Vendor Part Number	VendorPartNumber	nvarchar (100)
Stock Weight	StockWeight	decimal 9 (18,5)
Stock Volume	StockVolume	decimal 9 (18,5)
Description	Description	ntext
Not on tab by default	IsStockItem	bit		0 (False) 1 (True)	1
	Size	nvarchar (200)
	IsKit	bit		0 (False) 1 (True)	1
Status Reason	StatusCode1	int (status)		1 (Active)	For StateCode 0, 1
				2 (Inactive)	For StateCode 1, 2
	SupplierName	nvarchar (100)
Not migrated
	CreatedBy
	CreatedOn
	DeletionStateCode
	ModifiedBy
	ModifiedOn
	SecurityDescriptor
	VersionNumber

¹ See StateCode and StatusCode Values.

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

© 2005 Microsoft Corporation. All rights reserved.