cdf_SalesOrderDetail Table

Data in the cdf_SalesOrderDetail 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_SalesOrderDetail 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 SalesOrderDetail 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	SalesOrderDetailId	int (PK)	Required
	SalesOrderId	int	Required, Relationship
	SalesOrderStateCode	int
	SalesOrderStateCodeName1	nvarchar (200)
General tab
Select Product	IsProductOverridden	bit		0 (Existing) 1 (Write In)	0
Product	ProductId	int	Relationship
	ProductIdName1	nvarchar (100)
Product Description	ProductDescription	nvarchar (500)
Unit	UoMId	int	Relationship
	UoMIdName1	nvarchar (100)
Pricing	IsPriceOverridden	bit		0 (Use Default) 1 (Override Price)	0
Price Per Unit	PricePerUnit	money
Volume Discount ($)	VolumeDiscountAmount2	money
Quantity	Quantity	decimal 9 (18,5)
Amount	BaseAmount2	money
Manual Discount ($)	ManualDiscountAmount	money
Tax	Tax	money
Extended Amount ($)	ExtendedAmount2	money
Delivery tab
Requested Date	RequestDeliveryBy3	datetime
Salesperson	SalesRepId	int	Relationship
	SalesRepIdName1	nvarchar (160)
Shipped	QuantityShipped	decimal 9 (18,5)
Back Ordered	QuantityBackOrdered	decimal 9 (18,5)
Cancelled	QuantityCancelled	decimal 9 (18,5)
Address tab
Ship To	WillCall	bit		0 (Address) 1 (Will Call)	0
Name	ShipTo_Name	nvarchar (200)
Street 1	ShipTo_Line1	nvarchar (50)
Street 2	ShipTo_Line2	nvarchar (50)
Street 3	ShipTo_Line3	nvarchar (50)
City	ShipTo_City	nvarchar (50)
State/Province	ShipTo_StateOrProvince	nvarchar (50)
ZIP/Postal Code	ShipTo_PostalCode	nvarchar (20)
Country/Region	ShipTo_Country	nvarchar (50)
Phone	ShipTo_Telephone	nvarchar (50)
Fax	ShipTo_Fax	nvarchar (20)
Freight Terms	ShipTo_FreightTermsCode	int (picklist)
	ShipTo_FreightTermsCodeName1	nvarchar (200) (picklist)		FOB No Charge	Null
Not on tab by default
	Description	ntext
	IsCopied	bit		0 (False) 1 (True)	1
	PricingErrorCode	int (picklist)
	PricingErrorCodeName1	nvarchar (200) (picklist)
	LineItemNumber	int
Not migrated
	CreatedBy
	CreatedOn
	DeletionStateCode
	ModifiedBy
	ModifiedOn

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

² This is a calculated attribute in Microsoft CRM. Because Microsoft CRM calculates the value, data in this attribute is not migrated.

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

© 2005 Microsoft Corporation. All rights reserved.