cdf_Invoice Table

Data in the cdf_Invoice 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_Invoice 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 Invoice 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	InvoiceId	int (PK)	Required
	StateCode1	int (state)		0 (Active) 1 (Closed)	0
General tab
Invoice ID	InvoiceNumber	nvarchar (100)	Required
Name	Name	nvarchar (300)
Customer	ContactId	int	Required2 , Relationship
	ContactIdName	nvarchar (160)
	AccountId	int	Required2 , Relationship
	AccountIdName	nvarchar (160)
Price List	PriceLevelId	int	Relationship
	PriceLevelIdName3	nvarchar (100)
Detail Amount ($)	TotalLineItemAmount4	money
Invoice Discount (%)	DiscountPercentage	decimal 9 (10,5)
Invoice Discount ($)	DiscountAmount	money
Pre-Freight Amount ($)	TotalAmountLessFreight4	money
Freight Amount ($)	FreightAmount	money
Total Tax ($)	TotalTax4	money
Total Amount ($)	TotalAmount4	money
Shipping tab
Shipping Method	ShippingMethodCode	int (picklist)
	ShippingMethodCodeName3	nvarchar (200) (picklist)		Airborne DHL FedEx UPS Postal Mail Full Load Will Call	Null
Payment Terms	PaymentTermsCode	int (picklist)			Null
	PaymentTermsCodeName3	nvarchar (200) (picklist)		Net 30 2% 10, Net 30 Net 45 Net 60	Null
Description	Description	ntext
Addresses tab
Bill To Name	BillTo_Name	nvarchar (200)
Bill To Street 1	BillTo_Line1	nvarchar (50)
Bill To Street 2	BillTo_Line2	nvarchar (50)
Bill To Street 3	BillTo_Line3	nvarchar (50)
Bill To City	BillTo_City	nvarchar (50)
Bill To State/Province	BillTo_StateOrProvince	nvarchar (50)
Bill To ZIP/Postal Code	BillTo_PostalCode	nvarchar (20)
Bill To Country/Region	BillTo_Country	nvarchar (50)
Bill To Phone	BillTo_Telephone	nvarchar (50)
Bill To Fax	BillTo_Fax	nvarchar (20)
Ship To	WillCall	bit		0 (Address) 1 (Will Call)
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)
Administration tab
Owner	OwningUser	int	Required, Relationship
	OwningUserName3	nvarchar (255)
Status Reason	StatusCode1	int (status)		1 (New) 2 (Partially Shipped) 4 (Billed) 5 (Booked (applies to services) 6 (Installed (applies to services)	For StateCode 0, 1
				3 (Canceled) 7 (Paid in Full)	For StateCode 1, 3
Opportunity	OpportunityId	int	Relationship
	OpportunityIdName3	nvarchar (300)
Order	SalesOrderId	int	Relationship
	SalesOrderIdName3	nvarchar (300)
Not on tab by default	LastBackofficeSubmit5	datetime
	PricingErrorCode	int (picklist)
	PricingErrorCodeName3	nvarchar (200) (picklist)
	PriorityCode	int (picklist)
	PriorityCodeName3	nvarchar (200) (picklist)
	ShipTo_FreightTermsCode	int (picklist)
	ShipTo_FreightTermsCodeName3	nvarchar (200) (picklist)		Default Value	Default Value
	TotalDiscountAmount4	money
	TotalLineItemDiscountAmount4	money
Not migrated
	CreatedBy
	CreatedOn
	DeletionStateCode
	ModifiedBy
	ModifiedOn
	VersionNumber
	CustomerId
	CustomerIdType
	OwnerId
	OwnerIdType
	OwningTeam

¹ See StateCode and StatusCode Values.

² Either AccountId or ContactId is required.

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