cdf_InvoiceDetail Table

Data in the cdf_InvoiceDetail 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_InvoiceDetail 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 InvoiceDetail 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	InvoiceDetailId	int (PK)	Required, Relationship
	InvoiceId		Required, Relationship
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 (Overrride 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
Delivered On	ActualDeliveryOn3	datetime
Salesperson	SalesRepId	int	Relationship
	SalesRepIdName1	nvarchar (160)
Shipped	QuantityShipped	decimal 9 (18,5)
Back Ordered	QuantityBackOrdered	decimal 9 (18,5)
Fulfilled	QuantityCancelled	decimal 9 (18,5)
Address tab
Ship To	WillCall	bit		0 (Address)/ 1 (Will call)	0
Ship To Name	ShipTo_Name	nvarchar (200)
Ship To Street 1	ShipTo_Line1	nvarchar (50)
Ship To Street 2	ShipTo_Line2	nvarchar (50)
Ship To Street 3	ShipTo_Line3	nvarchar (50)
Ship To City	ShipTo_City	nvarchar (50)
Ship To State/Province	ShipTo_StateOrProvince	nvarchar (50)
Ship To ZIP/Postal Code	ShipTo_PostalCode	nvarchar (20)
Ship To Country/Region	ShipTo_Country	nvarchar (50)
Ship To Phone	ShipTo_Telephone	nvarchar (50)
Ship To 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
	LineItemNumber	int
	InvoiceStateName	nvarchar (200)
	PricingErrorCode	int (picklist)
	PricingErrorCodeName1	nvarchar (200)
	ShippingTrackingNumber	nvarchar (100)
Not migrated
	CreatedBy
	CreatedOn
	DeletionStateCode
	ModifiedBy
	ModifiedOn
	VersionNumber

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