Letter table/entity reference (Microsoft Dynamics 365)

Article
2025-02-08

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

Note

The Microsoft Dynamics 365 Letter table extends the Microsoft Dataverse Letter table.

Writable columns/attributes

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

ServiceId

Property	Value
Description	Unique identifier for an associated service.
DisplayName	Service
IsValidForForm	False
IsValidForRead	True
LogicalName	`serviceid`
RequiredLevel	None
Type	Lookup
Targets	service

Customized columns/attributes

Microsoft Dynamics 365 modifies the definition of columns/attributes defined in other solutions. Listed by SchemaName.

bcc
cc
from
RegardingObjectId
to

bcc

Changes from bcc (Microsoft Dataverse)

Property	Value
Targets	lead

cc

Changes from cc (Microsoft Dataverse)

Property	Value
Targets	lead

from

Changes from from (Microsoft Dataverse)

Property	Value
Targets	lead

RegardingObjectId

Changes from RegardingObjectId (Microsoft Dataverse)

Property	Value
Targets	bookableresourcebooking, bookableresourcebookingheader, bulkoperation, campaign, campaignactivity, contract, entitlement, entitlementtemplate, incident, invoice, lead, msdyn_customerasset, msdyn_playbookinstance, msdyn_postalbum, msdyn_salessuggestion, msdyn_swarm, opportunity, quote, salesorder, site

to

Changes from to (Microsoft Dataverse)

Property	Value
Targets	lead

Many-to-One relationships

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

bookableresourcebooking_Letters
bookableresourcebookingheader_Letters
BulkOperation_Letter
Campaign_Letters
CampaignActivity_Letters
Contract_Letters
entitlement_Letters
entitlementtemplate_Letters
Incident_Letters
Invoice_Letters
Lead_Letters
msdyn_customerasset_Letters
msdyn_postalbum_Letters
msdyn_salessuggestion_Letters
msdyn_swarm_Letters
Opportunity_Letters
Quote_Letters
SalesOrder_Letters
service_letters
site_Letters

bookableresourcebooking_Letters

One-To-Many Relationship: bookableresourcebooking bookableresourcebooking_Letters

Property	Value
ReferencedEntity	`bookableresourcebooking`
ReferencedAttribute	`bookableresourcebookingid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_bookableresourcebooking_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

bookableresourcebookingheader_Letters

One-To-Many Relationship: bookableresourcebookingheader bookableresourcebookingheader_Letters

Property	Value
ReferencedEntity	`bookableresourcebookingheader`
ReferencedAttribute	`bookableresourcebookingheaderid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_bookableresourcebookingheader_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

BulkOperation_Letter

One-To-Many Relationship: bulkoperation BulkOperation_Letter

Property	Value
ReferencedEntity	`bulkoperation`
ReferencedAttribute	`activityid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_bulkoperation_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Campaign_Letters

One-To-Many Relationship: campaign Campaign_Letters

Property	Value
ReferencedEntity	`campaign`
ReferencedAttribute	`campaignid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_campaign_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

CampaignActivity_Letters

One-To-Many Relationship: campaignactivity CampaignActivity_Letters

Property	Value
ReferencedEntity	`campaignactivity`
ReferencedAttribute	`activityid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_campaignactivity_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Contract_Letters

One-To-Many Relationship: contract Contract_Letters

Property	Value
ReferencedEntity	`contract`
ReferencedAttribute	`contractid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_contract_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

entitlement_Letters

One-To-Many Relationship: entitlement entitlement_Letters

Property	Value
ReferencedEntity	`entitlement`
ReferencedAttribute	`entitlementid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_entitlement_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

entitlementtemplate_Letters

One-To-Many Relationship: entitlementtemplate entitlementtemplate_Letters

Property	Value
ReferencedEntity	`entitlementtemplate`
ReferencedAttribute	`entitlementtemplateid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_entitlementtemplate_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Incident_Letters

One-To-Many Relationship: incident Incident_Letters

Property	Value
ReferencedEntity	`incident`
ReferencedAttribute	`incidentid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_incident_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `Cascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Invoice_Letters

One-To-Many Relationship: invoice Invoice_Letters

Property	Value
ReferencedEntity	`invoice`
ReferencedAttribute	`invoiceid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_invoice_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Lead_Letters

One-To-Many Relationship: lead Lead_Letters

Property	Value
ReferencedEntity	`lead`
ReferencedAttribute	`leadid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_lead_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `Cascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_customerasset_Letters

One-To-Many Relationship: msdyn_customerasset msdyn_customerasset_Letters

Property	Value
ReferencedEntity	`msdyn_customerasset`
ReferencedAttribute	`msdyn_customerassetid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_msdyn_customerasset_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_postalbum_Letters

One-To-Many Relationship: msdyn_postalbum msdyn_postalbum_Letters

Property	Value
ReferencedEntity	`msdyn_postalbum`
ReferencedAttribute	`msdyn_postalbumid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_msdyn_postalbum_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_salessuggestion_Letters

One-To-Many Relationship: msdyn_salessuggestion msdyn_salessuggestion_Letters

Property	Value
ReferencedEntity	`msdyn_salessuggestion`
ReferencedAttribute	`msdyn_salessuggestionid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_msdyn_salessuggestion_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_swarm_Letters

One-To-Many Relationship: msdyn_swarm msdyn_swarm_Letters

Property	Value
ReferencedEntity	`msdyn_swarm`
ReferencedAttribute	`msdyn_swarmid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_msdyn_swarm_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Opportunity_Letters

One-To-Many Relationship: opportunity Opportunity_Letters

Property	Value
ReferencedEntity	`opportunity`
ReferencedAttribute	`opportunityid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_opportunity_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Quote_Letters

One-To-Many Relationship: quote Quote_Letters

Property	Value
ReferencedEntity	`quote`
ReferencedAttribute	`quoteid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_quote_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

SalesOrder_Letters

One-To-Many Relationship: salesorder SalesOrder_Letters

Property	Value
ReferencedEntity	`salesorder`
ReferencedAttribute	`salesorderid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_salesorder_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

service_letters

One-To-Many Relationship: service service_letters

Property	Value
ReferencedEntity	`service`
ReferencedAttribute	`serviceid`
ReferencingAttribute	`serviceid`
ReferencingEntityNavigationPropertyName	`serviceid_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

site_Letters

One-To-Many Relationship: site site_Letters

Property	Value
ReferencedEntity	`site`
ReferencedAttribute	`siteid`
ReferencingAttribute	`regardingobjectid`
ReferencingEntityNavigationPropertyName	`regardingobjectid_site_letter`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

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

letter_campaignresponse

Many-To-One Relationship: campaignresponse letter_campaignresponse

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

Share via