Document Suggestions (RecommendedDocument) table/entity reference (Microsoft Dataverse)

Document Suggestions

Messages

The following table lists the messages for the Document Suggestions (RecommendedDocument) table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
Associate Event: True	Associate records	Associate records
Disassociate Event: True	Disassociate records	Disassociate records
RetrieveMultiple Event: True	GET /recommendeddocuments See Query data	Query data

Properties

The following table lists selected properties for the Document Suggestions (RecommendedDocument) table.

Property	Value
DisplayName	Document Suggestions
DisplayCollectionName	Document Suggestions
SchemaName	RecommendedDocument
CollectionSchemaName	RecommendedDocuments
EntitySetName	recommendeddocuments
LogicalName	recommendeddocument
LogicalCollectionName	recommendeddocuments
PrimaryIdAttribute	recommendeddocumentid
PrimaryNameAttribute	title
TableType	Standard
OwnershipType	OrganizationOwned

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

• AssociatedRecordName
• Author
• ExternalDocumentId
• ExternalModifiedBy
• RecommendedDocumentId
• RegardingObjectId
• RegardingObjectTypeCode
• Source
• TimeZoneRuleVersionNumber
• Title
• TransactionCurrencyId
• UTCConversionTimeZoneCode

AssociatedRecordName

Property	Value
Description	Shows the associated record name of the recommended document.
DisplayName	Associated Record Name
IsValidForForm	False
IsValidForRead	True
LogicalName	associatedrecordname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

Author

Property	Value
Description	Shows the name of the author of the recommended document.
DisplayName	Author
IsValidForForm	False
IsValidForRead	True
LogicalName	author
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	256

ExternalDocumentId

Property	Value
Description	Shows the external document.
DisplayName	External Document ID
IsValidForForm	False
IsValidForRead	True
LogicalName	externaldocumentid
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

ExternalModifiedBy

Property	Value
Description	Shows who last updated the document record.
DisplayName	Modified by
IsValidForForm	False
IsValidForRead	True
LogicalName	externalmodifiedby
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	256

RecommendedDocumentId

Property	Value
Description	Shows the recommended document record.
DisplayName	Recommended Document
IsValidForForm	False
IsValidForRead	True
LogicalName	recommendeddocumentid
RequiredLevel	SystemRequired
Type	Uniqueidentifier

RegardingObjectId

Property	Value
Description	Choose the parent record that the recommended document record is associated with.
DisplayName	Regarding
IsValidForForm	False
IsValidForRead	True
LogicalName	regardingobjectid
RequiredLevel	None
Type	Lookup
Targets

RegardingObjectTypeCode

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	regardingobjecttypecode
RequiredLevel	None
Type	EntityName

Source

Property	Value
Description	Shows the source storage of the recommended document.
DisplayName	Source
IsValidForForm	False
IsValidForRead	True
LogicalName	source
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	256

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName	Time Zone Rule Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	timezoneruleversionnumber
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

Title

Property	Value
Description	Type a title for the entity.
DisplayName	Title
IsValidForForm	False
IsValidForRead	True
LogicalName	title
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

TransactionCurrencyId

Property	Value
Description	Shows the exchange rate for the currency associated with the recommended document with respect to the base currency.
DisplayName	Currency
IsValidForForm	False
IsValidForRead	True
LogicalName	transactioncurrencyid
RequiredLevel	None
Type	Lookup
Targets	transactioncurrency

UTCConversionTimeZoneCode

Property	Value
Description	Shows the time zone code that was in use when the record was created.
DisplayName	UTC Conversion Time Zone Code
IsValidForForm	False
IsValidForRead	True
LogicalName	utcconversiontimezonecode
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

• AbsoluteUrl
• ContentType
• CreatedBy
• CreatedOn
• CreatedOnBehalfBy
• EditUrl
• ExchangeRate
• FileSize
• FileType
• FullName
• IconClassName
• Location
• ModifiedBy
• ModifiedOn
• ModifiedOnBehalfBy
• OrganizationId
• ReadUrl
• Version
• VersionNumber

AbsoluteUrl

Property	Value
Description	Type the URL where the recommended document is located.
DisplayName	Absolute URL
IsValidForForm	False
IsValidForRead	True
LogicalName	absoluteurl
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

ContentType

Property	Value
Description	Select the document content type.
DisplayName	Content Type
IsValidForForm	False
IsValidForRead	True
LogicalName	contenttype
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

CreatedBy

Property	Value
Description	Shows the user who created the record.
DisplayName	Created By
IsValidForForm	False
IsValidForRead	True
LogicalName	createdby
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName	Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	createdon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

CreatedOnBehalfBy

Property	Value
Description	Shows who created the record on behalf of another user.
DisplayName	Created By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Type	Lookup
Targets	systemuser

EditUrl

Property	Value
Description	Shows the Edit URL of the recommended document.
DisplayName	Edit Web App URL
IsValidForForm	False
IsValidForRead	True
LogicalName	editurl
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

ExchangeRate

Property	Value
Description	Shows the exchange rate for the currency associated with the recommended document with respect to the base currency.
DisplayName	ExchangeRate
IsValidForForm	False
IsValidForRead	True
LogicalName	exchangerate
RequiredLevel	None
Type	Decimal
ImeMode	Disabled
MaxValue	100000000000
MinValue	1E-12
Precision	12
SourceTypeMask	0

FileSize

Property	Value
Description	Shows the file size.
DisplayName	File Size
IsValidForForm	False
IsValidForRead	True
LogicalName	filesize
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

FileType

Property	Value
Description	Shows the file type.
DisplayName	File Type
IsValidForForm	False
IsValidForRead	True
LogicalName	filetype
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

FullName

Property	Value
Description	Shows the full name of the recommended document.
DisplayName	Name
IsValidForForm	False
IsValidForRead	True
LogicalName	fullname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

IconClassName

Property	Value
Description	Stores the Icon Class name of the recommended document.
DisplayName	Icon Class Name
IsValidForForm	False
IsValidForRead	True
LogicalName	iconclassname
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

Location

Property	Value
Description	Shows the location of the recommended document.
DisplayName	Path
IsValidForForm	False
IsValidForRead	True
LogicalName	location
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

ModifiedBy

Property	Value
Description	Shows who last updated the record.
DisplayName	Modified By
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName	Modified On
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Shows who last updated the record on behalf of another user.
DisplayName	Modified By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	modifiedonbehalfby
RequiredLevel	None
Type	Lookup
Targets	systemuser

OrganizationId

Property	Value
Description	Shows the organization.
DisplayName	Organization ID
IsValidForForm	False
IsValidForRead	True
LogicalName	organizationid
RequiredLevel	None
Type	Lookup
Targets	organization

ReadUrl

Property	Value
Description	Shows the Read URL of the recommended document.
DisplayName	Read Web App URL
IsValidForForm	False
IsValidForRead	True
LogicalName	readurl
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

Version

Property	Value
Description	Shows the recommended document version.
DisplayName	Recommended Document Version
IsValidForForm	False
IsValidForRead	True
LogicalName	version
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

VersionNumber

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	versionnumber
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

• lk_recommendeddocument_createdby
• lk_recommendeddocument_createdonbehalfby
• lk_recommendeddocument_modifiedby
• lk_recommendeddocument_modifiedonbehalfby
• organization_recommendeddocument
• TransactionCurrency_recommendeddocument

lk_recommendeddocument_createdby

One-To-Many Relationship: systemuser lk_recommendeddocument_createdby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	createdby
ReferencingEntityNavigationPropertyName	createdbyname
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_recommendeddocument_createdonbehalfby

One-To-Many Relationship: systemuser lk_recommendeddocument_createdonbehalfby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	createdonbehalfby
ReferencingEntityNavigationPropertyName	createdonbehalfbyname
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_recommendeddocument_modifiedby

One-To-Many Relationship: systemuser lk_recommendeddocument_modifiedby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	modifiedby
ReferencingEntityNavigationPropertyName	modifiedbyname
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

lk_recommendeddocument_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_recommendeddocument_modifiedonbehalfby

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	modifiedonbehalfby
ReferencingEntityNavigationPropertyName	modifiedonbehalfbyname
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

organization_recommendeddocument

One-To-Many Relationship: organization organization_recommendeddocument

Property	Value
ReferencedEntity	organization
ReferencedAttribute	organizationid
ReferencingAttribute	organizationid
ReferencingEntityNavigationPropertyName	organizationid
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

TransactionCurrency_recommendeddocument

One-To-Many Relationship: transactioncurrency TransactionCurrency_recommendeddocument

Property	Value
ReferencedEntity	transactioncurrency
ReferencedAttribute	transactioncurrencyid
ReferencingAttribute	transactioncurrencyid
ReferencingEntityNavigationPropertyName	transactioncurrencyidname
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

See also

Dataverse table/entity reference
Dataverse Web API Reference
recommendeddocument