cdf_Annotation Table

Data in the cdf_Annotation 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_Annotation 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 Annotation 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	AnnotationId	int (PK)	Required
	ObjectTypeCode1	int (picklist)		See ObjectTypeCode Values
	ObjectTypeCodeName2	nvarchar (200) (picklist)		Fax (136) Phone Call (137) Task (134) E-mail (138) Letter (141) Appointment (142) Lead (4) Opportunity (3) Account (1) Contact (2) Competitor (123) Product (1024) Quote (1084) Order (1088) Invoice (1090) Incident (112)
	ObjectId	int	Relationship
	OwningUser	int	Required, Relationship
	OwningUserName2	nvarchar (255)
	IsDocument	bit	Required	0 (False) 1 (True)3	1
Notes
Title	Subject	nvarchar (500)
Description	NoteText	ntext
Not migrated	MimeType4
	LangId4
	FileSize4
	FileName4
	IsPrivate
	CreatedBy
	CreatedOn
	DeletionStateCode
	ModifiedBy
	ModifiedOn
	OwnerId
	OwnerIdType
	OwningTeam
	SecurityDescriptor
	VersionNumber

¹ ObjectTypeCode data is not in the cdf_StringMapCrm table; you must cleanse the data manually.

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

³ Must be set to 0 in the CDF database. The Microsoft CRM Data Migration Framework does not migrate attachments.

⁴ This data applies to attached files, which are not migrated.

© 2005 Microsoft Corporation. All rights reserved.