title | description | ms.date | ms.service | ms.topic | ms.assetid | author | ms.author | search.audienceType | |
---|---|---|---|---|---|---|---|---|---|
Email Template (Template) table/entity reference (Microsoft Dataverse) | Microsoft Docs |
Includes schema information and supported messages for the Email Template (Template) table/entity. |
02/22/2024 |
powerapps |
reference |
3948cc48-07c8-7f60-0608-71c37158ad7c |
phecke |
pehecke |
|
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Template for an email message that contains the standard attributes of an email message.
Message | Web API Operation | SDK class or method |
---|---|---|
Assign | PATCH /templates(templateid) Update ownerid property. |
xref:Microsoft.Crm.Sdk.Messages.AssignRequest |
Create | POST /templates See Create |
xref:Microsoft.Xrm.Sdk.Messages.CreateRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Create* |
Delete | DELETE /templates(templateid) See Delete |
xref:Microsoft.Xrm.Sdk.Messages.DeleteRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Delete* |
GrantAccess | <xref:Microsoft.Dynamics.CRM.GrantAccess?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.GrantAccessRequest |
InstantiateTemplate | <xref:Microsoft.Dynamics.CRM.InstantiateTemplate?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.InstantiateTemplateRequest |
ModifyAccess | <xref:Microsoft.Dynamics.CRM.ModifyAccess?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.ModifyAccessRequest |
Retrieve | GET /templates(templateid) See Retrieve |
xref:Microsoft.Xrm.Sdk.Messages.RetrieveRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Retrieve* |
RetrieveMultiple | GET /templates See Query Data |
xref:Microsoft.Xrm.Sdk.Messages.RetrieveMultipleRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.RetrieveMultiple* |
RetrievePrincipalAccess | <xref:Microsoft.Dynamics.CRM.RetrievePrincipalAccess?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess | <xref:Microsoft.Dynamics.CRM.RetrieveSharedPrincipalsAndAccess?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess | <xref:Microsoft.Dynamics.CRM.RevokeAccess?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.RevokeAccessRequest |
SendEmail | <xref:Microsoft.Dynamics.CRM.SendEmail?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.SendEmailRequest |
SendFax | <xref:Microsoft.Dynamics.CRM.SendFax?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.SendFaxRequest |
SendTemplate | <xref:Microsoft.Dynamics.CRM.SendTemplate?displayProperty=nameWithType /> | xref:Microsoft.Crm.Sdk.Messages.SendTemplateRequest |
Update | PATCH /templates(templateid) See Update |
xref:Microsoft.Xrm.Sdk.Messages.UpdateRequest or xref:Microsoft.Xrm.Sdk.IOrganizationService.Update* |
Property | Value |
---|---|
CollectionSchemaName | Templates |
DisplayCollectionName | Email Templates |
DisplayName | Email Template |
EntitySetName | templates |
IsBPFEntity | False |
LogicalCollectionName | templates |
LogicalName | template |
OwnershipType | UserOwned |
PrimaryIdAttribute | templateid |
PrimaryNameAttribute | title |
SchemaName | Template |
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- Body
- Description
- EntityImage
- GenerationTypeCode
- ImportSequenceNumber
- IntroducedVersion
- IsCustomizable
- IsPersonal
- LanguageCode
- MimeType
- OwnerId
- OwnerIdType
- PresentationXml
- SafeHtml
- Subject
- SubjectPresentationXml
- SubjectSafeHtml
- TemplateId
- TemplateTypeCode
- Title
Property | Value |
---|---|
Description | Body text of the email template. |
DisplayName | Body |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | body |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | Memo |
Property | Value |
---|---|
Description | Description of the email template. |
DisplayName | Description |
Format | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | description |
MaxLength | 2000 |
RequiredLevel | None |
Type | Memo |
Added by: Active Solution Solution
Property | Value |
---|---|
Description | Shows the default image for the record. |
DisplayName | Default Image |
IsPrimaryImage | True |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage |
MaxHeight | 144 |
MaxWidth | 144 |
RequiredLevel | None |
Type | Image |
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Generation Type Code |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | generationtypecode |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
Property | Value |
---|---|
Description | Unique identifier of the data import or data migration that created this record. |
DisplayName | Import Sequence Number |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | importsequencenumber |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
Property | Value |
---|---|
Description | Version in which the form is introduced. |
DisplayName | Introduced Version |
FormatName | VersionNumber |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | introducedversion |
MaxLength | 48 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | Information that specifies whether this component can be customized. |
DisplayName | Customizable |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | iscustomizable |
RequiredLevel | SystemRequired |
Type | ManagedProperty |
Property | Value |
---|---|
Description | Information about whether the template is personal or is available to all users. |
DisplayName | Viewable By |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | ispersonal |
RequiredLevel | None |
Type | Boolean |
Value | Label | Description |
---|---|---|
1 | Individual | |
0 | Organization |
DefaultValue: 1
Property | Value |
---|---|
Description | Language of the email template. |
DisplayName | Language |
Format | Language |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | languagecode |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | ApplicationRequired |
Type | Integer |
Property | Value |
---|---|
Description | MIME type of the email template. |
DisplayName | Mime Type |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | mimetype |
MaxLength | 256 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | Unique identifier of the user or team who owns the template for the email activity. |
DisplayName | Owner |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | ownerid |
RequiredLevel | SystemRequired |
Targets | systemuser,team |
Type | Owner |
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
Property | Value |
---|---|
Description | XML data for the body of the email template. |
DisplayName | Presentation XML |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | presentationxml |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | Memo |
Added by: Activities Patch Solution
Property | Value |
---|---|
Description | Safe html of email template. |
DisplayName | Safe HTML of email template |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | safehtml |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | Memo |
Property | Value |
---|---|
Description | Subject associated with the email template. |
DisplayName | Subject |
Format | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | subject |
MaxLength | 5000 |
RequiredLevel | ApplicationRequired |
Type | Memo |
Property | Value |
---|---|
Description | XML data for the subject of the email template. |
DisplayName | Subject XML |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | subjectpresentationxml |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | Memo |
Added by: Activities Patch Solution
Property | Value |
---|---|
Description | Safe html of email template subject. |
DisplayName | Safe HTML of email template subject |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | subjectsafehtml |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | Memo |
Property | Value |
---|---|
Description | Unique identifier of the template. |
DisplayName | Email Template |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | templateid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
Property | Value |
---|---|
Description | Type of email template. |
DisplayName | Template Type |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | templatetypecode |
RequiredLevel | SystemRequired |
Type | EntityName |
Property | Value |
---|---|
Description | Title of the template. |
DisplayName | Title |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | title |
MaxLength | 200 |
RequiredLevel | ApplicationRequired |
Type | String |
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- ComponentState
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- EntityImage_Timestamp
- EntityImage_URL
- EntityImageId
- IsManaged
- IsRecommended
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OpenCount
- OpenRate
- OverwriteTime
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- ReplyCount
- ReplyRate
- SolutionId
- SupportingSolutionId
- TemplateIdUnique
- UsedCount
- VersionNumber
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Component State |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | componentstate |
RequiredLevel | SystemRequired |
Type | Picklist |
Value | Label | Description |
---|---|---|
0 | Published | |
1 | Unpublished | |
2 | Deleted | |
3 | Deleted Unpublished |
Property | Value |
---|---|
Description | Unique identifier of the user who created the email template. |
DisplayName | Created By |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | Name of the user who created the email template. |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | YomiName of the user who created the email template. |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the email template was created. |
DisplayName | Created On |
Format | DateAndTime |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
Property | Value |
---|---|
Description | Unique identifier of the delegate user who created the template. |
DisplayName | Created By (Delegate) |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Added by: Activities Patch Solution
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage_timestamp |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
Added by: Activities Patch Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Url |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimage_url |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
Added by: Activities Patch Solution
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | entityimageid |
RequiredLevel | None |
Type | Uniqueidentifier |
Property | Value |
---|---|
Description | Indicates whether the solution component is part of a managed solution. |
DisplayName | Is Managed |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | ismanaged |
RequiredLevel | SystemRequired |
Type | Boolean |
Value | Label | Description |
---|---|---|
1 | Managed | |
0 | Unmanaged |
DefaultValue: 0
Property | Value |
---|---|
Description | Indicates if a template is recommended by Dynamics 365. |
DisplayName | Recommended |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | isrecommended |
RequiredLevel | None |
Type | Boolean |
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
Property | Value |
---|---|
Description | Unique identifier of the user who last modified the template. |
DisplayName | Modified By |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the email template was last modified. |
DisplayName | Modified On |
Format | DateAndTime |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
Property | Value |
---|---|
Description | Unique identifier of the delegate user who last modified the template. |
DisplayName | Modified By (Delegate) |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | For internal use only. Shows the number of times emails that use this template have been opened. |
DisplayName | Open Count |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | opencount |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
Property | Value |
---|---|
Description | Shows the open rate of this template. This is based on number of opens on followed emails that use this template. |
DisplayName | Open Rate |
Format | None |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | openrate |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | For internal use only. |
DisplayName | Record Overwrite Time |
Format | DateOnly |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | overwritetime |
RequiredLevel | SystemRequired |
Type | DateTime |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
Property | Value |
---|---|
Description | Unique identifier of the business unit that owns the template. |
DisplayName | Owning Business Unit |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | owningbusinessunit |
RequiredLevel | None |
Targets | businessunit |
Type | Lookup |
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningbusinessunitname |
MaxLength | 160 |
RequiredLevel | None |
Type | String |
Property | Value |
---|---|
Description | Unique identifier of the team who owns the template. |
DisplayName | Owning Team |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningteam |
RequiredLevel | None |
Targets | team |
Type | Lookup |
Property | Value |
---|---|
Description | Unique identifier of the user who owns the template. |
DisplayName | Owning User |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owninguser |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Property | Value |
---|---|
Description | For internal use only. Shows the number of times emails that use this template have received replies. |
DisplayName | Reply Count |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | replycount |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
Property | Value |
---|---|
Description | Shows the reply rate for this template. This is based on number of replies received on followed emails that use this template. |
DisplayName | Reply Rate |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | replyrate |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
Property | Value |
---|---|
Description | Unique identifier of the associated solution. |
DisplayName | Solution |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | solutionid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Solution |
IsValidForForm | False |
IsValidForRead | False |
LogicalName | supportingsolutionid |
RequiredLevel | None |
Type | Uniqueidentifier |
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | templateidunique |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
Property | Value |
---|---|
Description | Shows the number of sent emails that use this template. |
DisplayName | Sent email count |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | usedcount |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
Property | Value |
---|---|
Description | Version number of the template. |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
Listed by SchemaName.
- template_activity_mime_attachments
- Template_SyncErrors
- Template_AsyncOperations
- Email_EmailTemplate
- Template_Organization
- Template_ProcessSessions
- Template_BulkDeleteFailures
Same as the template_activity_mime_attachments many-to-one relationship for the activitymimeattachment table/entity.
Property | Value |
---|---|
ReferencingEntity | activitymimeattachment |
ReferencingAttribute | objectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | template_activity_mime_attachments |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Same as the Template_SyncErrors many-to-one relationship for the syncerror table/entity.
Property | Value |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | Template_SyncErrors |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Same as the Template_AsyncOperations many-to-one relationship for the asyncoperation table/entity.
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | Template_AsyncOperations |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Same as the Email_EmailTemplate many-to-one relationship for the email table/entity.
Property | Value |
---|---|
ReferencingEntity | |
ReferencingAttribute | templateid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | Email_EmailTemplate |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Same as the Template_Organization many-to-one relationship for the organization table/entity.
Property | Value |
---|---|
ReferencingEntity | organization |
ReferencingAttribute | acknowledgementtemplateid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | Template_Organization |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Same as the Template_ProcessSessions many-to-one relationship for the processsession table/entity.
Property | Value |
---|---|
ReferencingEntity | processsession |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | Template_ProcessSessions |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Same as the Template_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure table/entity.
Property | Value |
---|---|
ReferencingEntity | bulkdeletefailure |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | Template_BulkDeleteFailures |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- lk_templatebase_createdby
- lk_templatebase_modifiedby
- team_email_templates
- business_unit_templates
- system_user_email_templates
- lk_templatebase_modifiedonbehalfby
- lk_templatebase_createdonbehalfby
See the lk_templatebase_createdby one-to-many relationship for the systemuser table/entity.
See the lk_templatebase_modifiedby one-to-many relationship for the systemuser table/entity.
See the team_email_templates one-to-many relationship for the team table/entity.
See the business_unit_templates one-to-many relationship for the businessunit table/entity.
See the system_user_email_templates one-to-many relationship for the systemuser table/entity.
See the lk_templatebase_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
See the lk_templatebase_createdonbehalfby one-to-many relationship for the systemuser table/entity.