Letter table/entity reference (Microsoft Dataverse)

2025-08-28

Activity that tracks the delivery of a letter. The activity can contain the electronic copy of the letter.

Messages

The following table lists the messages for the Letter 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` /letters(activityid) Update the `ownerid` property.	AssignRequest
`Associate` Event: True	Associate records	Associate records
`Create` Event: True	`POST` /letters See Create	Create records
`Delete` Event: True	`DELETE` /letters(activityid) 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` /letters(activityid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: True	`GET` /letters See Query data	Query data
`RetrievePrincipalAccess` Event: True	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
`RetrieveSharedPrincipalsAndAccess` Event: True	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
`RevokeAccess` Event: True	RevokeAccess	RevokeAccessRequest
`SetState` Event: True	`PATCH` /letters(activityid) Update the `statecode` and `statuscode` properties.	SetStateRequest
`Update` Event: True	`PATCH` /letters(activityid) See Update	Update records
`Upsert` Event: False	`PATCH` /letters(activityid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Letter table.

Property	Value
DisplayName	Letter
DisplayCollectionName	Letters
SchemaName	`Letter`
CollectionSchemaName	`Letters`
EntitySetName	`letters`
LogicalName	`letter`
LogicalCollectionName	`letters`
PrimaryIdAttribute	`activityid`
PrimaryNameAttribute	`subject`
TableType	`Standard`
OwnershipType	`UserOwned`

Writable columns/attributes

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

ActivityId
ActualDurationMinutes
ActualEnd
ActualStart
Address
bcc
Category
cc
Description
DirectionCode
from
ImportSequenceNumber
IsBilled
IsWorkflowCreated
LastOnHoldTime
OverriddenCreatedOn
OwnerId
OwnerIdType
PriorityCode
ProcessId
RegardingObjectId
RegardingObjectTypeCode
ScheduledEnd
ScheduledStart
SLAId
SortDate
StageId
StateCode
StatusCode
Subcategory
Subject
SubscriptionId
TimeZoneRuleVersionNumber
to
TransactionCurrencyId
TraversedPath
UTCConversionTimeZoneCode

ActivityId

Property	Value
Description	Unique identifier of the letter activity.
DisplayName	Letter
IsValidForForm	False
IsValidForRead	True
LogicalName	`activityid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ActualDurationMinutes

Property	Value
Description	Type the number of minutes spent creating and sending the letter. The duration is used in reporting.
DisplayName	Duration
IsValidForForm	True
IsValidForRead	True
LogicalName	`actualdurationminutes`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

ActualEnd

Property	Value
Description	Enter the actual end date and time of the letter. By default, it displays the date and time when the activity was completed or canceled, but can be edited to capture the actual time to create and send the letter.
DisplayName	Actual End
IsValidForForm	True
IsValidForRead	True
LogicalName	`actualend`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

ActualStart

Property	Value
Description	Enter the actual start date and time for the letter. By default, it displays the date and time when the activity was created, but can be edited to capture the actual time to create and send the letter.
DisplayName	Actual Start
IsValidForForm	True
IsValidForRead	True
LogicalName	`actualstart`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

Address

Property	Value
Description	Type the complete recipient address for the letter to ensure timely delivery.
DisplayName	Address
IsValidForForm	True
IsValidForRead	True
LogicalName	`address`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

bcc

Property	Value
Description	Enter the recipients that are included in the letter distribution, but are not displayed to other recipients.
DisplayName	Bcc
IsValidForForm	True
IsValidForRead	True
LogicalName	`bcc`
RequiredLevel	None
Type	PartyList
Targets	account, contact, systemuser

Property	Value
Description	Type a category to identify the letter type, such as sales offer or past due notice, to tie the letter to a business group or function.
DisplayName	Category
IsValidForForm	True
IsValidForRead	True
LogicalName	`category`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

cc

Property	Value
Description	Enter the recipients that should be copied on the letter.
DisplayName	Cc
IsValidForForm	True
IsValidForRead	True
LogicalName	`cc`
RequiredLevel	None
Type	PartyList
Targets	account, contact, systemuser

Description

Property	Value
Description	Type the letter body or additional information to describe the letter, such as the primary message or the products and services described.
DisplayName	Description
IsValidForForm	True
IsValidForRead	True
LogicalName	`description`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

DirectionCode

Property	Value
Description	Select the direction of the letter as incoming or outbound.
DisplayName	Direction
IsValidForForm	True
IsValidForRead	True
LogicalName	`directioncode`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`letter_directioncode`
DefaultValue	True
True Label	Outgoing
False Label	Incoming

from

Property	Value
Description	Enter the account, contact, lead, or user who sent the letter.
DisplayName	From
IsValidForForm	True
IsValidForRead	True
LogicalName	`from`
RequiredLevel	None
Type	PartyList
Targets	account, contact, systemuser

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

IsBilled

Property	Value
Description	Shows whether the letter activity was billed as part of resolving a case.
DisplayName	Is Billed
IsValidForForm	False
IsValidForRead	True
LogicalName	`isbilled`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`letter_isbilled`
DefaultValue	False
True Label	Yes
False Label	No

IsWorkflowCreated

Property	Value
Description	Shows whether the letter activity was created by a workflow rule.
DisplayName	Is Workflow Created
IsValidForForm	False
IsValidForRead	True
LogicalName	`isworkflowcreated`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`letter_isworkflowcreated`
DefaultValue	False
True Label	Yes
False Label	No

LastOnHoldTime

Property	Value
Description	Contains the date and time stamp of the last on hold time.
DisplayName	Last On Hold Time
IsValidForForm	True
IsValidForRead	True
LogicalName	`lastonholdtime`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

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	Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user.
DisplayName	Owner
IsValidForForm	True
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

PriorityCode

Property	Value
Description	Select the priority so that preferred customers or critical issues are handled quickly.
DisplayName	Priority
IsValidForForm	True
IsValidForRead	True
LogicalName	`prioritycode`
RequiredLevel	None
Type	Picklist
DefaultFormValue	1
GlobalChoiceName	`letter_prioritycode`

PriorityCode Choices/Options

Value	Label
0	Low
1	Normal
2	High

ProcessId

Property	Value
Description	Shows the ID of the process.
DisplayName	Process
IsValidForForm	False
IsValidForRead	True
LogicalName	`processid`
RequiredLevel	None
Type	Uniqueidentifier

RegardingObjectId

Property	Value
Description	Choose the record that the letter relates to.
DisplayName	Regarding
IsValidForForm	True
IsValidForRead	True
LogicalName	`regardingobjectid`
RequiredLevel	None
Type	Lookup
Targets	account, adx_invitation, contact, knowledgearticle, knowledgebaserecord, mspp_adplacement, mspp_pollplacement, mspp_publishingstatetransitionrule, mspp_redirect, mspp_shortcut, mspp_website

RegardingObjectTypeCode

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

ScheduledEnd

Property	Value
Description	Enter the expected due date and time.
DisplayName	Due Date
IsValidForForm	True
IsValidForRead	True
LogicalName	`scheduledend`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ScheduledStart

Property	Value
Description	Enter the expected due date and time.
DisplayName	Start Date
IsValidForForm	True
IsValidForRead	True
LogicalName	`scheduledstart`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

SLAId

Property	Value
Description	Choose the service level agreement (SLA) that you want to apply to the Letter record.
DisplayName	SLA
IsValidForForm	True
IsValidForRead	True
LogicalName	`slaid`
RequiredLevel	None
Type	Lookup
Targets	sla

SortDate

Property	Value
Description	Shows the date and time by which the activities are sorted.
DisplayName	Sort Date
IsValidForForm	True
IsValidForRead	True
LogicalName	`sortdate`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

StageId

Property	Value
Description	Shows the ID of the stage.
DisplayName	(Deprecated) Process Stage
IsValidForForm	False
IsValidForRead	True
LogicalName	`stageid`
RequiredLevel	None
Type	Uniqueidentifier

StateCode

Property	Value
Description	Shows whether the letter is open, completed, or canceled. Completed and canceled letters are read-only and can't be edited.
DisplayName	Activity Status
IsValidForForm	True
IsValidForRead	True
LogicalName	`statecode`
RequiredLevel	SystemRequired
Type	State
DefaultFormValue	0
GlobalChoiceName	`letter_statecode`

StateCode Choices/Options

Value	Details
0	Label: Open DefaultStatus: 2 InvariantName: `Open`
1	Label: Completed DefaultStatus: 4 InvariantName: `Completed`
2	Label: Canceled DefaultStatus: 5 InvariantName: `Canceled`

StatusCode

Property	Value
Description	Select the letter's status.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	`statuscode`
RequiredLevel	None
Type	Status
DefaultFormValue	-1
GlobalChoiceName	`letter_statuscode`

StatusCode Choices/Options

Value	Details
1	Label: Open State:0 TransitionData: None
2	Label: Draft State:0 TransitionData: None
3	Label: Received State:1 TransitionData: None
4	Label: Sent State:1 TransitionData: None
5	Label: Canceled State:2 TransitionData: None

Subcategory

Property	Value
Description	Type a subcategory to identify the letter type and relate the activity to a specific product, sales region, business group, or other function.
DisplayName	Sub-Category
IsValidForForm	True
IsValidForRead	True
LogicalName	`subcategory`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

Subject

Property	Value
Description	Type a short description about the objective or primary topic of the letter.
DisplayName	Subject
IsValidForForm	True
IsValidForRead	True
LogicalName	`subject`
RequiredLevel	ApplicationRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

SubscriptionId

Property	Value
Description	For internal use only.
DisplayName	Subscription
IsValidForForm	False
IsValidForRead	False
LogicalName	`subscriptionid`
RequiredLevel	None
Type	Uniqueidentifier

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

to

Property	Value
Description	Enter the account, contact, lead, or user recipients for the letter.
DisplayName	To
IsValidForForm	True
IsValidForRead	True
LogicalName	`to`
RequiredLevel	None
Type	PartyList
Targets	account, contact, systemuser

TransactionCurrencyId

Property	Value
Description	Choose the local currency for the record to make sure budgets are reported in the correct currency.
DisplayName	Currency
IsValidForForm	True
IsValidForRead	True
LogicalName	`transactioncurrencyid`
RequiredLevel	None
Type	Lookup
Targets	transactioncurrency

TraversedPath

Property	Value
Description	For internal use only.
DisplayName	(Deprecated) Traversed Path
IsValidForForm	False
IsValidForRead	True
LogicalName	`traversedpath`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1250

UTCConversionTimeZoneCode

Property	Value
Description	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.

ActivityTypeCode
CreatedBy
CreatedOn
CreatedOnBehalfBy
ExchangeRate
IsRegularActivity
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OnHoldTime
OwnerIdName
OwnerIdYomiName
OwningBusinessUnit
OwningTeam
OwningUser
ScheduledDurationMinutes
SLAInvokedId
VersionNumber

ActivityTypeCode

Property	Value
Description	Shows the type of activity.
DisplayName	Activity Type
IsValidForForm	False
IsValidForRead	True
LogicalName	`activitytypecode`
RequiredLevel	SystemRequired
Type	EntityName

CreatedBy

Property	Value
Description	Shows who created the record.
DisplayName	Created By
IsValidForForm	True
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	True
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	True
IsValidForRead	True
LogicalName	`createdonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ExchangeRate

Property	Value
Description	Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
DisplayName	Exchange Rate
IsValidForForm	True
IsValidForRead	True
LogicalName	`exchangerate`
RequiredLevel	None
Type	Decimal
ImeMode	Disabled
MaxValue	100000000000
MinValue	1E-12
Precision	12
SourceTypeMask	0

IsRegularActivity

Property	Value
Description	Shows whether the activity is a regular activity type or event type.
DisplayName	Is Regular Activity
IsValidForForm	False
IsValidForRead	True
LogicalName	`isregularactivity`
RequiredLevel	SystemRequired
Type	Boolean
GlobalChoiceName	`activitypointer_isregularactivity`
DefaultValue	False
True Label	Yes
False Label	No

ModifiedBy

Property	Value
Description	Shows who last updated the record.
DisplayName	Modified By
IsValidForForm	True
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	True
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	True
IsValidForRead	True
LogicalName	`modifiedonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

OnHoldTime

Property	Value
Description	Shows how long, in minutes, that the record was on hold.
DisplayName	On Hold Time (Minutes)
IsValidForForm	True
IsValidForRead	True
LogicalName	`onholdtime`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

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 letter activity.
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 that owns the letter activity.
DisplayName	Owning Team
IsValidForForm	False
IsValidForRead	True
LogicalName	`owningteam`
RequiredLevel	None
Type	Lookup
Targets	team

OwningUser

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

ScheduledDurationMinutes

Property	Value
Description	Scheduled duration of the letter activity, specified in minutes.
DisplayName	Scheduled Duration
IsValidForForm	False
IsValidForRead	True
LogicalName	`scheduleddurationminutes`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

SLAInvokedId

Property	Value
Description	Last SLA that was applied to this Letter. This field is for internal use only.
DisplayName	Last SLA applied
IsValidForForm	False
IsValidForRead	True
LogicalName	`slainvokedid`
RequiredLevel	None
Type	Lookup
Targets	sla

VersionNumber

Property	Value
Description	Version number of the letter.
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_Letters
activity_pointer_letter
adx_invitation_Letters
business_unit_letter_activities
Contact_Letters
KnowledgeArticle_Letters
KnowledgeBaseRecord_Letters
lk_letter_createdby
lk_letter_createdonbehalfby
lk_letter_modifiedby
lk_letter_modifiedonbehalfby
manualsla_letter
mspp_adplacement_Letters
mspp_pollplacement_Letters
mspp_publishingstatetransitionrule_Letters
mspp_redirect_Letters
mspp_shortcut_Letters
mspp_website_Letters
owner_letters
processstage_letters
sla_letter
team_letter
TransactionCurrency_Letter
user_letter

Account_Letters

One-To-Many Relationship: account Account_Letters

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

activity_pointer_letter

One-To-Many Relationship: activitypointer activity_pointer_letter

Property	Value
ReferencedEntity	`activitypointer`
ReferencedAttribute	`activityid`
ReferencingAttribute	`activityid`
ReferencingEntityNavigationPropertyName	`activityid_activitypointer`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

adx_invitation_Letters

One-To-Many Relationship: adx_invitation adx_invitation_Letters

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

business_unit_letter_activities

One-To-Many Relationship: businessunit business_unit_letter_activities

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

Contact_Letters

One-To-Many Relationship: contact Contact_Letters

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

KnowledgeArticle_Letters

One-To-Many Relationship: knowledgearticle KnowledgeArticle_Letters

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

KnowledgeBaseRecord_Letters

One-To-Many Relationship: knowledgebaserecord KnowledgeBaseRecord_Letters

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

lk_letter_createdby

One-To-Many Relationship: systemuser lk_letter_createdby

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

lk_letter_createdonbehalfby

One-To-Many Relationship: systemuser lk_letter_createdonbehalfby

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

lk_letter_modifiedby

One-To-Many Relationship: systemuser lk_letter_modifiedby

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

lk_letter_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_letter_modifiedonbehalfby

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

manualsla_letter

One-To-Many Relationship: sla manualsla_letter

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

mspp_adplacement_Letters

One-To-Many Relationship: mspp_adplacement mspp_adplacement_Letters

Property	Value
ReferencedEntity	`mspp_adplacement`
ReferencedAttribute	`mspp_adplacementid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_mspp_adplacement_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

mspp_pollplacement_Letters

One-To-Many Relationship: mspp_pollplacement mspp_pollplacement_Letters

Property	Value
ReferencedEntity	`mspp_pollplacement`
ReferencedAttribute	`mspp_pollplacementid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_mspp_pollplacement_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

mspp_publishingstatetransitionrule_Letters

One-To-Many Relationship: mspp_publishingstatetransitionrule mspp_publishingstatetransitionrule_Letters

Property	Value
ReferencedEntity	`mspp_publishingstatetransitionrule`
ReferencedAttribute	`mspp_publishingstatetransitionruleid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_mspp_publishingstatetransitionrule_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

mspp_redirect_Letters

One-To-Many Relationship: mspp_redirect mspp_redirect_Letters

Property	Value
ReferencedEntity	`mspp_redirect`
ReferencedAttribute	`mspp_redirectid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_mspp_redirect_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

mspp_shortcut_Letters

One-To-Many Relationship: mspp_shortcut mspp_shortcut_Letters

Property	Value
ReferencedEntity	`mspp_shortcut`
ReferencedAttribute	`mspp_shortcutid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_mspp_shortcut_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

mspp_website_Letters

One-To-Many Relationship: mspp_website mspp_website_Letters

Property	Value
ReferencedEntity	`mspp_website`
ReferencedAttribute	`mspp_websiteid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_mspp_website_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

owner_letters

One-To-Many Relationship: owner owner_letters

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

processstage_letters

One-To-Many Relationship: processstage processstage_letters

Property	Value
ReferencedEntity	`processstage`
ReferencedAttribute	`processstageid`
ReferencingAttribute	`stageid`
ReferencingEntityNavigationPropertyName	`stageid_processstage`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

sla_letter

One-To-Many Relationship: sla sla_letter

Property	Value
ReferencedEntity	`sla`
ReferencedAttribute	`slaid`
ReferencingAttribute	`slainvokedid`
ReferencingEntityNavigationPropertyName	`slainvokedid_letter_sla`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

team_letter

One-To-Many Relationship: team team_letter

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

TransactionCurrency_Letter

One-To-Many Relationship: transactioncurrency TransactionCurrency_Letter

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

user_letter

One-To-Many Relationship: systemuser user_letter

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

One-to-Many relationships

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

letter_actioncard
letter_activity_parties
Letter_Annotation
Letter_AsyncOperations
Letter_BulkDeleteFailures
letter_connections1
letter_connections2
Letter_DuplicateBaseRecord
Letter_DuplicateMatchingRecord
letter_principalobjectattributeaccess
Letter_ProcessSessions
Letter_QueueItem
Letter_SyncErrors
slakpiinstance_letter

letter_actioncard

Many-To-One Relationship: actioncard letter_actioncard

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

letter_activity_parties

Many-To-One Relationship: activityparty letter_activity_parties

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

Letter_Annotation

Many-To-One Relationship: annotation Letter_Annotation

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

Letter_AsyncOperations

Many-To-One Relationship: asyncoperation Letter_AsyncOperations

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

Letter_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure Letter_BulkDeleteFailures

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

letter_connections1

Many-To-One Relationship: connection letter_connections1

Property	Value
ReferencingEntity	`connection`
ReferencingAttribute	`record1id`
ReferencedEntityNavigationPropertyName	`letter_connections1`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 100 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

letter_connections2

Many-To-One Relationship: connection letter_connections2

Property	Value
ReferencingEntity	`connection`
ReferencingAttribute	`record2id`
ReferencedEntityNavigationPropertyName	`letter_connections2`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: 100 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Letter_DuplicateBaseRecord

Many-To-One Relationship: duplicaterecord Letter_DuplicateBaseRecord

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

Letter_DuplicateMatchingRecord

Many-To-One Relationship: duplicaterecord Letter_DuplicateMatchingRecord

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

letter_principalobjectattributeaccess

Many-To-One Relationship: principalobjectattributeaccess letter_principalobjectattributeaccess

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

Letter_ProcessSessions

Many-To-One Relationship: processsession Letter_ProcessSessions

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

Letter_QueueItem

Many-To-One Relationship: queueitem Letter_QueueItem

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

Letter_SyncErrors

Many-To-One Relationship: syncerror Letter_SyncErrors

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

slakpiinstance_letter

Many-To-One Relationship: slakpiinstance slakpiinstance_letter

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

Feedback

Was this page helpful?