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 | Microsoft CRM values |
Default Microsoft CRM value |
Not on tab | ProductId | int (PK) | Required | ||
StateCode* | int (state) | 0 (Active)
1 (Inactive) |
0 | ||
General tab | |||||
ID | ProductNumber | nvarchar (100) | Required | ||
Name | Name | nvarchar (100) | |||
Subject | SubjectId | int | Relationship | ||
SubjectIdName** | nvarchar (500) | ||||
Unit Group | DefaultUoMScheduleId | int | Relationship | ||
DefaultUoMScheduleIdName** | nvarchar (200) | ||||
Default Unit | DefaultUoMId | int | Relationship | ||
DefaultUoMIdName* | nvarchar (100) | ||||
Product Type | ProductTypeCode | int (picklist) | |||
ProductTypeCodeName** | 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 | ||
PriceLevelIdName** | nvarchar (100) | ||||
Decimals | QuantityDecimal | int | |||
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 | dec (18,5) | |||
Stock Volume | StockVolume | dec (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 | StatusCode* | 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 |
Table Footnotes
*See StateCode and StatusCode Values.
**The field is used only in the CDF database; it is not migrated.