Note (Annotation) table/entity reference (Microsoft Dataverse)

Article
01/21/2025

Note that is attached to one or more objects, including other notes.

Messages

The following table lists the messages for the Note (Annotation) 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
`Assign` Event: True	`PATCH` /annotations(annotationid) Update the `ownerid` property.	AssignRequest
`Associate` Event: True	Associate records	Associate records
`Create` Event: True	`POST` /annotations See Create	Create records
`Delete` Event: True	`DELETE` /annotations(annotationid) See Delete	Delete records
`Disassociate` Event: True	Disassociate records	Disassociate records
`GrantAccess` Event: True	GrantAccess	GrantAccessRequest
`ModifyAccess` Event: True	ModifyAccess	ModifyAccessRequest
`Retrieve` Event: True	`GET` /annotations(annotationid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: True	`GET` /annotations See Query data	Query data
`RetrievePrincipalAccess` Event: True	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
`RetrieveSharedPrincipalsAndAccess` Event: True	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
`RevokeAccess` Event: True	RevokeAccess	RevokeAccessRequest
`Rollup` Event: False	Rollup	RollupRequest
`Update` Event: True	`PATCH` /annotations(annotationid) See Update	Update records
`Upsert` Event: False	`PATCH` /annotations(annotationid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Note (Annotation) table.

Property	Value
DisplayName	Note
DisplayCollectionName	Notes
SchemaName	`Annotation`
CollectionSchemaName	`Annotations`
EntitySetName	`annotations`
LogicalName	`annotation`
LogicalCollectionName	`annotations`
PrimaryIdAttribute	`annotationid`
PrimaryNameAttribute	`subject`
TableType	`Standard`
OwnershipType	`UserOwned`

Writable columns/attributes

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

AnnotationId
DocumentBody
FileName
ImportSequenceNumber
IsDocument
LangId
MimeType
NoteText
ObjectId
ObjectIdTypeCode
ObjectTypeCode
OverriddenCreatedOn
OwnerId
OwnerIdType
StepId
Subject

AnnotationId

Property	Value
Description	Unique identifier of the note.
DisplayName	Note
IsValidForForm	False
IsValidForRead	True
LogicalName	`annotationid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

DocumentBody

Property	Value
Description	Contents of the note's attachment.
DisplayName	Document
IsValidForForm	False
IsValidForRead	True
LogicalName	`documentbody`
RequiredLevel	None
Type	String
Format	TextArea
FormatName	TextArea
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

FileName

Property	Value
Description	File name of the note.
DisplayName	File Name
IsValidForForm	False
IsValidForRead	True
LogicalName	`filename`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	255

ImportSequenceNumber

Property	Value
Description	Unique identifier of the data import or data migration that created this record.
DisplayName	Import Sequence Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`importsequencenumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

IsDocument

Property	Value
Description	Specifies whether the note is an attachment.
DisplayName	Is Document
IsValidForForm	False
IsValidForRead	True
LogicalName	`isdocument`
RequiredLevel	SystemRequired
Type	Boolean
GlobalChoiceName	`annotation_isdocument`
DefaultValue	False
True Label	Yes
False Label	No

LangId

Property	Value
Description	Language identifier for the note.
DisplayName	Language ID
IsValidForForm	False
IsValidForRead	True
LogicalName	`langid`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2

MimeType

Property	Value
Description	MIME type of the note's attachment.
DisplayName	Mime Type
IsValidForForm	False
IsValidForRead	True
LogicalName	`mimetype`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	256

NoteText

Property	Value
Description	Text of the note.
DisplayName	Description
IsValidForForm	False
IsValidForRead	True
LogicalName	`notetext`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	RichText
ImeMode	Auto
IsLocalizable	False
MaxLength	100000

ObjectId

Property	Value
Description	Unique identifier of the object with which the note is associated.
DisplayName	Regarding
IsValidForForm	False
IsValidForRead	True
LogicalName	`objectid`
RequiredLevel	None
Type	Lookup
Targets	account, adx_invitation, adx_inviteredemption, adx_portalcomment, appointment, approvalprocess, approvalstageapproval, calendar, channelaccessprofile, channelaccessprofilerule, channelaccessprofileruleitem, chat, contact, convertrule, duplicaterule, email, emailserverprofile, fax, goal, kbarticle, knowledgearticle, knowledgebaserecord, letter, mailbox, msdyn_aifptrainingdocument, msdyn_aimodel, msdyn_aiodimage, msdyn_flow_approval, mspcat_catalogsubmissionfiles, phonecall, recurringappointmentmaster, routingrule, routingruleitem, sharepointdocument, sla, socialactivity, task, workflow

ObjectIdTypeCode

Property	Value
Description
DisplayName	Regarding Object Type
IsValidForForm	False
IsValidForRead	True
LogicalName	`objectidtypecode`
RequiredLevel	None
Type	EntityName

ObjectTypeCode

Property	Value
Description	Type of entity with which the note is associated.
DisplayName	Object Type
IsValidForForm	False
IsValidForRead	True
LogicalName	`objecttypecode`
RequiredLevel	None
Type	EntityName

OverriddenCreatedOn

Property	Value
Description	Date and time that the record was migrated.
DisplayName	Record Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	`overriddencreatedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

OwnerId

Property	Value
Description	Unique identifier of the user or team who owns the note.
DisplayName	Owner
IsValidForForm	False
IsValidForRead	True
LogicalName	`ownerid`
RequiredLevel	SystemRequired
Type	Owner
Targets	systemuser, team

OwnerIdType

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owneridtype`
RequiredLevel	SystemRequired
Type	EntityName

StepId

Property	Value
Description	workflow step id associated with the note.
DisplayName	Step Id
IsValidForForm	False
IsValidForRead	True
LogicalName	`stepid`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	32

Subject

Property	Value
Description	Subject associated with the note.
DisplayName	Title
IsValidForForm	False
IsValidForRead	True
LogicalName	`subject`
RequiredLevel	ApplicationRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	500

Read-only columns/attributes

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

CreatedBy
CreatedOn
CreatedOnBehalfBy
DummyFileName
DummyRegarding
FilePointer
FileSize
IsPrivate
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OwnerIdName
OwnerIdYomiName
OwningBusinessUnit
OwningTeam
OwningUser
Prefix
StoragePointer
VersionNumber

CreatedBy

Property	Value
Description	Unique identifier of the user who created the note.
DisplayName	Created By
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Date and time when the note was created.
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	Unique identifier of the delegate user who created the annotation.
DisplayName	Created By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

DummyFileName

Property	Value
Description	Dummy attribute associated with the note attachment
DisplayName	File Name(deprecated)
IsValidForForm	True
IsValidForRead	False
LogicalName	`dummyfilename`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	500

DummyRegarding

Property	Value
Description	Dummy attribute associated with the note regarding
DisplayName	Regarding(deprecated)
IsValidForForm	True
IsValidForRead	False
LogicalName	`dummyregarding`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	500

FilePointer

Property	Value
Description	File pointer of the attachment.
DisplayName	File Pointer
IsValidForForm	False
IsValidForRead	False
LogicalName	`filepointer`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	255

FileSize

Property	Value
Description	File size of the note.
DisplayName	File Size (Bytes)
IsValidForForm	False
IsValidForRead	True
LogicalName	`filesize`
RequiredLevel	None
Type	Integer
MaxValue	1000000000
MinValue	0

IsPrivate

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	False
LogicalName	`isprivate`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`annotation_isprivate`
DefaultValue	False
True Label	Yes
False Label	No

ModifiedBy

Property	Value
Description	Unique identifier of the user who last modified the note.
DisplayName	Modified By
IsValidForForm	False
IsValidForRead	True
LogicalName	`modifiedby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Date and time when the note was last modified.
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	Unique identifier of the delegate user who last modified the annotation.
DisplayName	Modified By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	`modifiedonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

OwnerIdName

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owneridname`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OwnerIdYomiName

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owneridyominame`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OwningBusinessUnit

Property	Value
Description	Unique identifier of the business unit that owns the note.
DisplayName	Owning Business Unit
IsValidForForm	True
IsValidForRead	True
LogicalName	`owningbusinessunit`
RequiredLevel	None
Type	Lookup
Targets	businessunit

OwningTeam

Property	Value
Description	Unique identifier of the team who owns the note.
DisplayName	Owning Team
IsValidForForm	False
IsValidForRead	True
LogicalName	`owningteam`
RequiredLevel	None
Type	Lookup
Targets	team

OwningUser

Property	Value
Description	Unique identifier of the user who owns the note.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	`owninguser`
RequiredLevel	None
Type	Lookup
Targets	systemuser

Prefix

Property	Value
Description	Prefix of the file pointer in blob storage.
DisplayName	Prefix
IsValidForForm	False
IsValidForRead	True
LogicalName	`prefix`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	10

StoragePointer

Property	Value
Description	Storage pointer.
DisplayName	Storage Pointer
IsValidForForm	False
IsValidForRead	False
LogicalName	`storagepointer`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	10

VersionNumber

Property	Value
Description	Version number of the note.
DisplayName	Version Number
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.

Account_Annotation
adx_invitation_Annotations
adx_inviteredemption_Annotations
adx_portalcomment_Annotations
annotation_owning_user
Appointment_Annotation
approvalprocess_Annotations
approvalstageapproval_Annotations
business_unit_annotations
Calendar_Annotation
chat_Annotations
Contact_Annotation
DuplicateRule_Annotation
Email_Annotation
EmailServerProfile_Annotation
Fax_Annotation
Goal_Annotation
KbArticle_Annotation
knowledgearticle_Annotations
KnowledgeBaseRecord_Annotations
Letter_Annotation
lk_annotationbase_createdby
lk_annotationbase_createdonbehalfby
lk_annotationbase_modifiedby
lk_annotationbase_modifiedonbehalfby
Mailbox_Annotation
msdyn_aifptrainingdocument_Annotations
msdyn_aimodel_Annotations
msdyn_aiodimage_Annotations
msdyn_flow_approval_Annotations
mspcat_catalogsubmissionfiles_Annotations
owner_annotations
PhoneCall_Annotation
RecurringAppointmentMaster_Annotation
sla_Annotation
SocialActivity_Annotation
Task_Annotation
team_annotations
Workflow_Annotation

Account_Annotation

One-To-Many Relationship: account Account_Annotation

Property	Value
ReferencedEntity	`account`
ReferencedAttribute	`accountid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_account`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `Cascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

adx_invitation_Annotations

One-To-Many Relationship: adx_invitation adx_invitation_Annotations

Property	Value
ReferencedEntity	`adx_invitation`
ReferencedAttribute	`adx_invitationid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_adx_invitation`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

adx_inviteredemption_Annotations

One-To-Many Relationship: adx_inviteredemption adx_inviteredemption_Annotations

Property	Value
ReferencedEntity	`adx_inviteredemption`
ReferencedAttribute	`activityid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_adx_inviteredemption`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

adx_portalcomment_Annotations

One-To-Many Relationship: adx_portalcomment adx_portalcomment_Annotations

Property	Value
ReferencedEntity	`adx_portalcomment`
ReferencedAttribute	`activityid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_adx_portalcomment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

annotation_owning_user

One-To-Many Relationship: systemuser annotation_owning_user

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

Appointment_Annotation

One-To-Many Relationship: appointment Appointment_Annotation

Property	Value
ReferencedEntity	`appointment`
ReferencedAttribute	`activityid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_appointment`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

approvalprocess_Annotations

One-To-Many Relationship: approvalprocess approvalprocess_Annotations

Property	Value
ReferencedEntity	`approvalprocess`
ReferencedAttribute	`approvalprocessid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_approvalprocess`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

approvalstageapproval_Annotations

One-To-Many Relationship: approvalstageapproval approvalstageapproval_Annotations

Property	Value
ReferencedEntity	`approvalstageapproval`
ReferencedAttribute	`approvalstageapprovalid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_approvalstageapproval`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

business_unit_annotations

One-To-Many Relationship: businessunit business_unit_annotations

Property	Value
ReferencedEntity	`businessunit`
ReferencedAttribute	`businessunitid`
ReferencingAttribute	`owningbusinessunit`
ReferencingEntityNavigationPropertyName	`owningbusinessunit`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

Calendar_Annotation

One-To-Many Relationship: calendar Calendar_Annotation

Property	Value
ReferencedEntity	`calendar`
ReferencedAttribute	`calendarid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_calendar`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

chat_Annotations

One-To-Many Relationship: chat chat_Annotations

Property	Value
ReferencedEntity	`chat`
ReferencedAttribute	`activityid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_chat`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Contact_Annotation

One-To-Many Relationship: contact Contact_Annotation

Property	Value
ReferencedEntity	`contact`
ReferencedAttribute	`contactid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_contact`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `Cascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

DuplicateRule_Annotation

One-To-Many Relationship: duplicaterule DuplicateRule_Annotation

Property	Value
ReferencedEntity	`duplicaterule`
ReferencedAttribute	`duplicateruleid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_duplicaterule`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Email_Annotation

One-To-Many Relationship: email Email_Annotation

Property	Value
ReferencedEntity	`email`
ReferencedAttribute	`activityid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_email`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

EmailServerProfile_Annotation

One-To-Many Relationship: emailserverprofile EmailServerProfile_Annotation

Property	Value
ReferencedEntity	`emailserverprofile`
ReferencedAttribute	`emailserverprofileid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_emailserverprofile`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `Cascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Fax_Annotation

One-To-Many Relationship: fax Fax_Annotation

Property	Value
ReferencedEntity	`fax`
ReferencedAttribute	`activityid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_fax`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Goal_Annotation

One-To-Many Relationship: goal Goal_Annotation

Property	Value
ReferencedEntity	`goal`
ReferencedAttribute	`goalid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_goal`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `Cascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

KbArticle_Annotation

One-To-Many Relationship: kbarticle KbArticle_Annotation

Property	Value
ReferencedEntity	`kbarticle`
ReferencedAttribute	`kbarticleid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_kbarticle`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `Cascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

knowledgearticle_Annotations

One-To-Many Relationship: knowledgearticle knowledgearticle_Annotations

Property	Value
ReferencedEntity	`knowledgearticle`
ReferencedAttribute	`knowledgearticleid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_knowledgearticle`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

KnowledgeBaseRecord_Annotations

One-To-Many Relationship: knowledgebaserecord KnowledgeBaseRecord_Annotations

Property	Value
ReferencedEntity	`knowledgebaserecord`
ReferencedAttribute	`knowledgebaserecordid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_knowledgebaserecord`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

Letter_Annotation

One-To-Many Relationship: letter Letter_Annotation

Property	Value
ReferencedEntity	`letter`
ReferencedAttribute	`activityid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

lk_annotationbase_createdby

One-To-Many Relationship: systemuser lk_annotationbase_createdby

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

lk_annotationbase_createdonbehalfby

One-To-Many Relationship: systemuser lk_annotationbase_createdonbehalfby

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

lk_annotationbase_modifiedby

One-To-Many Relationship: systemuser lk_annotationbase_modifiedby

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

lk_annotationbase_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_annotationbase_modifiedonbehalfby

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

Mailbox_Annotation

One-To-Many Relationship: mailbox Mailbox_Annotation

Property	Value
ReferencedEntity	`mailbox`
ReferencedAttribute	`mailboxid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_mailbox`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `Cascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_aifptrainingdocument_Annotations

One-To-Many Relationship: msdyn_aifptrainingdocument msdyn_aifptrainingdocument_Annotations

Property	Value
ReferencedEntity	`msdyn_aifptrainingdocument`
ReferencedAttribute	`msdyn_aifptrainingdocumentid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_msdyn_aifptrainingdocument`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_aimodel_Annotations

One-To-Many Relationship: msdyn_aimodel msdyn_aimodel_Annotations

Property	Value
ReferencedEntity	`msdyn_aimodel`
ReferencedAttribute	`msdyn_aimodelid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_msdyn_aimodel`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_aiodimage_Annotations

One-To-Many Relationship: msdyn_aiodimage msdyn_aiodimage_Annotations

Property	Value
ReferencedEntity	`msdyn_aiodimage`
ReferencedAttribute	`msdyn_aiodimageid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_msdyn_aiodimage`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_flow_approval_Annotations

One-To-Many Relationship: msdyn_flow_approval msdyn_flow_approval_Annotations

Property	Value
ReferencedEntity	`msdyn_flow_approval`
ReferencedAttribute	`msdyn_flow_approvalid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_msdyn_flow_approval`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

mspcat_catalogsubmissionfiles_Annotations

One-To-Many Relationship: mspcat_catalogsubmissionfiles mspcat_catalogsubmissionfiles_Annotations

Property	Value
ReferencedEntity	`mspcat_catalogsubmissionfiles`
ReferencedAttribute	`mspcat_catalogsubmissionfilesid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_mspcat_catalogsubmissionfiles`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

owner_annotations

One-To-Many Relationship: owner owner_annotations

Property	Value
ReferencedEntity	`owner`
ReferencedAttribute	`ownerid`
ReferencingAttribute	`ownerid`
ReferencingEntityNavigationPropertyName	`ownerid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

PhoneCall_Annotation

One-To-Many Relationship: phonecall PhoneCall_Annotation

Property	Value
ReferencedEntity	`phonecall`
ReferencedAttribute	`activityid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_phonecall`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

RecurringAppointmentMaster_Annotation

One-To-Many Relationship: recurringappointmentmaster RecurringAppointmentMaster_Annotation

Property	Value
ReferencedEntity	`recurringappointmentmaster`
ReferencedAttribute	`activityid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_recurringappointmentmaster`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

sla_Annotation

One-To-Many Relationship: sla sla_Annotation

Property	Value
ReferencedEntity	`sla`
ReferencedAttribute	`slaid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_sla`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `Cascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

SocialActivity_Annotation

One-To-Many Relationship: socialactivity SocialActivity_Annotation

Property	Value
ReferencedEntity	`socialactivity`
ReferencedAttribute	`activityid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_socialactivity`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Task_Annotation

One-To-Many Relationship: task Task_Annotation

Property	Value
ReferencedEntity	`task`
ReferencedAttribute	`activityid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_task`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

team_annotations

One-To-Many Relationship: team team_annotations

Property	Value
ReferencedEntity	`team`
ReferencedAttribute	`teamid`
ReferencingAttribute	`owningteam`
ReferencingEntityNavigationPropertyName	`owningteam`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

Workflow_Annotation

One-To-Many Relationship: workflow Workflow_Annotation

Property	Value
ReferencedEntity	`workflow`
ReferencedAttribute	`workflowid`
ReferencingAttribute	`objectid`
ReferencingEntityNavigationPropertyName	`objectid_workflow`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

One-to-Many relationships

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

Annotation_AsyncOperations
Annotation_BulkDeleteFailures
Annotation_ProcessSessions
Annotation_SyncErrors

Annotation_AsyncOperations

Many-To-One Relationship: asyncoperation Annotation_AsyncOperations

Property	Value
ReferencingEntity	`asyncoperation`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`Annotation_AsyncOperations`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Annotation_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure Annotation_BulkDeleteFailures

Property	Value
ReferencingEntity	`bulkdeletefailure`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`Annotation_BulkDeleteFailures`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Annotation_ProcessSessions

Many-To-One Relationship: processsession Annotation_ProcessSessions

Property	Value
ReferencingEntity	`processsession`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`Annotation_ProcessSessions`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 110 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Annotation_SyncErrors

Many-To-One Relationship: syncerror Annotation_SyncErrors

Property	Value
ReferencingEntity	`syncerror`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`Annotation_SyncErrors`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Additional resources

Training

Learning path

Use advance techniques in canvas apps to perform custom updates and optimization - Training

Use advance techniques in canvas apps to perform custom updates and optimization

Events

Join AI Skills Fest Challenge

Apr 8, 3 PM - May 28, 7 AM

Sharpen your AI skills and enter the sweepstakes to win a free Certification exam