cdf_Discount Table

Data in the cdf_Discount 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_Discount 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 Discount 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	DiscountId	int (PK)	Required
	DiscountTypeId	int	Required, Relationship
	DiscountTypeIdName1	nvarchar (100)
	IsAmountType	bit	Required	0 (Percentage) 1 (Amount)	0
General tab
Begin Quantity	LowQuantity	decimal 9 (18,5)	Required
End Quantity	HighQuantity	decimal 9 (18,5)	Required
Amount ($)	Amount3	money
Percentage	Percentage3	decimal 9 (10,5)
Not migrated	StateCode2
	StatusCode2
	CreatedBy
	CreatedOn
	DeletionStateCode
	ModifiedBy
	ModifiedOn
	VersionNumber

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

² The values of StateCode and StatusCode are controlled by the associated cdf_DiscountType record. These attributes are not brought into the cdf_StringMapCrm table, and data in these fields is not migrated.

³ Each record should include either a Percentage or an Amount, but not both.

© 2005 Microsoft Corporation. All rights reserved.