cdf_PriceLevel Table

Data in the cdf_PriceLevel 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_PriceLevel 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 PriceLevel 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	PriceLevelId	int (PK)	Required
	StateCode1	int (state)		0 (Active) 1 (Inactive)	0
General tab
Name	Name	nvarchar (100)	Required
Description	Description	ntext
Start Date	BeginDate2	datetime
End Date	EndDate2	datetime
Not on tab by default	ShippingMethodCode	int
	ShippingMethodCodeName3	nvarchar (200)
	PaymentMethodCode	int
	PaymentMethodCodeName3	nvarchar (200)
	FreightTermsCode	int
	FreightTermsCodeName3	nvarchar (200)
Not migrated	StatusCode
	CreatedBy
	CreatedOn
	DeletionStateCode
	ModifiedBy
	ModifiedOn
	SecurityDescriptor
	VersionNumber

¹ See StateCode and StatusCode Values.

² Values for all attributes of type datetime must be in Coordinated Universal Time (UTC) format CCYY-MM-DD, where CC is the century (00-99), YY is the year (00-99), MM is the month (01-12), and DD is the day of month (01-31), for example, 2003-09-05. If a time is included, it is migrated as the Greenwich Mean Time (GMT) time.

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

© 2005 Microsoft Corporation. All rights reserved.