InteractionForEmail table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
Delete | DELETE /interactionforemails(interactionforemailid) See Delete |
DeleteRequest or Delete |
RetrieveMultiple | GET /interactionforemails See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
Properties
Property | Value |
---|---|
CollectionSchemaName | InteractionForEmails |
DisplayCollectionName | Interactions for Email |
DisplayName | Interaction for Email |
EntitySetName | interactionforemails |
IsBPFEntity | False |
LogicalCollectionName | interactionforemails |
LogicalName | interactionforemail |
OwnershipType | UserOwned |
PrimaryIdAttribute | interactionforemailid |
PrimaryNameAttribute | name |
SchemaName | InteractionForEmail |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- EmailAddress
- ImportSequenceNumber
- InteractedComponentText
- InteractionForEmailId
- InteractionLocation
- InteractionRepliedBy
- InteractionReplyId
- InteractionUserAgent
- name
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- statecode
- statuscode
- TimeZoneRuleVersionNumber
- TransactionCurrencyId
- UTCConversionTimeZoneCode
EmailAddress
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Email Interaction Component Related Text |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | emailaddress |
MaxLength | 1250 |
RequiredLevel | None |
Type | String |
ImportSequenceNumber
Property | Value |
---|---|
Description | Sequence number of the import 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 |
InteractedComponentText
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Email Interaction Component Related Text |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | interactedcomponenttext |
MaxLength | 1250 |
RequiredLevel | None |
Type | String |
InteractionForEmailId
Property | Value |
---|---|
Description | Unique identifier for entity instances |
DisplayName | Interaction for Email |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | interactionforemailid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
InteractionLocation
Property | Value |
---|---|
Description | Shows the location for an Interaction |
DisplayName | Location for an Interaction |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | interactionlocation |
MaxLength | 1250 |
RequiredLevel | None |
Type | String |
InteractionRepliedBy
Property | Value |
---|---|
Description | Shows the Name who replied to email if interaction is reply |
DisplayName | Name who replied to email if interaction is reply |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | interactionrepliedby |
MaxLength | 1250 |
RequiredLevel | None |
Type | String |
InteractionReplyId
Property | Value |
---|---|
Description | InteractionReplyId |
DisplayName | InteractionReplyId |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | interactionreplyid |
MaxLength | 1250 |
RequiredLevel | None |
Type | String |
InteractionUserAgent
Property | Value |
---|---|
Description | Shows the User Agent for an Interaction if available |
DisplayName | User Agent for an Interaction |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | interactionuseragent |
MaxLength | 1250 |
RequiredLevel | None |
Type | String |
name
Property | Value |
---|---|
Description | The name of the custom entity. |
DisplayName | Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | name |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OverriddenCreatedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time that the record was migrated. |
DisplayName | Record Created On |
Format | DateOnly |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | overriddencreatedon |
RequiredLevel | None |
Type | DateTime |
OwnerId
Property | Value |
---|---|
Description | Unique identifier of the user or team who owns the record. |
DisplayName | Owner |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | ownerid |
RequiredLevel | SystemRequired |
Targets | systemuser,team |
Type | Owner |
OwnerIdType
Property | Value |
---|---|
Description | Owner Id Type |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
statecode
Property | Value |
---|---|
Description | Status of the Interaction for Email |
DisplayName | Status |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
statecode Choices/Options
Value | Label | DefaultStatus | InvariantName |
---|---|---|---|
0 | Active | 1 | Active |
1 | Inactive | 2 | Inactive |
statuscode
Property | Value |
---|---|
Description | Reason for the status of the Interaction for Email |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
statuscode Choices/Options
Value | Label | State |
---|---|---|
1 | Active | 0 |
2 | Inactive | 1 |
TimeZoneRuleVersionNumber
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Time Zone Rule Version Number |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | timezoneruleversionnumber |
MaxValue | 2147483647 |
MinValue | -1 |
RequiredLevel | None |
Type | Integer |
TransactionCurrencyId
Property | Value |
---|---|
Description | Exchange rate for the currency associated with the InteractionForEmail with respect to the base currency. |
DisplayName | Currency |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | transactioncurrencyid |
RequiredLevel | None |
Targets | transactioncurrency |
Type | Lookup |
UTCConversionTimeZoneCode
Property | Value |
---|---|
Description | Time zone code that was in use when the record was created. |
DisplayName | UTC Conversion Time Zone Code |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | utcconversiontimezonecode |
MaxValue | 2147483647 |
MinValue | -1 |
RequiredLevel | None |
Type | Integer |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- EmailActivityId
- EmailInteractionReplyId
- EmailInteractionTime
- ExchangeRate
- InteractionPartyId
- InteractionPartyTypecode
- InteractionType
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- TransactionCurrencyIdName
- VersionNumber
CreatedBy
Property | Value |
---|---|
Description | Unique identifier of the user who created the record. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
CreatedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
CreatedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the record was created. |
DisplayName | Created On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
CreatedOnBehalfBy
Property | Value |
---|---|
Description | Unique identifier of the delegate user who created the record. |
DisplayName | Created By (Delegate) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
CreatedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
EmailActivityId
Property | Value |
---|---|
Description | Email Activity Id. |
DisplayName | Email Activity Id |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | emailactivityid |
RequiredLevel | None |
Type | Uniqueidentifier |
EmailInteractionReplyId
Property | Value |
---|---|
Description | Email Activity Id. |
DisplayName | Email Activity Id |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | emailinteractionreplyid |
RequiredLevel | None |
Type | Uniqueidentifier |
EmailInteractionTime
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Shows the Interaction date and time of the an email. |
DisplayName | Interaction date and time of the an email |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | emailinteractiontime |
RequiredLevel | None |
Type | DateTime |
ExchangeRate
Property | Value |
---|---|
Description | Exchange rate for the currency associated with the InteractionForEmail with respect to the base currency. |
DisplayName | ExchangeRate |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | exchangerate |
MaxValue | 100000000000 |
MinValue | 0.000000000001 |
Precision | 12 |
RequiredLevel | None |
Type | Decimal |
InteractionPartyId
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Interaction party id. |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | interactionpartyid |
RequiredLevel | None |
Type | Uniqueidentifier |
InteractionPartyTypecode
Property | Value |
---|---|
Description | For internal use only |
DisplayName | Interaction party type code. |
Format | None |
IsValidForForm | False |
IsValidForRead | False |
LogicalName | interactionpartytypecode |
MaxValue | 2147483647 |
MinValue | 0 |
RequiredLevel | None |
Type | Integer |
InteractionType
Property | Value |
---|---|
Description | Shows the type of Interaction. |
DisplayName | Interaction Type |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | interactiontype |
RequiredLevel | SystemRequired |
Type | Picklist |
InteractionType Choices/Options
Value | Label | Description |
---|---|---|
0 | EmailOpen | |
1 | LinkOpen | |
2 | AttachmentOpen | |
3 | EmailReply |
ModifiedBy
Property | Value |
---|---|
Description | Unique identifier of the user who modified the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
ModifiedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
ModifiedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the record was modified. |
DisplayName | Modified On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
ModifiedOnBehalfBy
Property | Value |
---|---|
Description | Unique identifier of the delegate user who modified the record. |
DisplayName | Modified By (Delegate) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
ModifiedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwnerIdName
Property | Value |
---|---|
Description | Name of the owner |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwnerIdYomiName
Property | Value |
---|---|
Description | Yomi name of the owner |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwningBusinessUnit
Property | Value |
---|---|
Description | Unique identifier for the business unit that owns the record |
DisplayName | Owning Business Unit |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | owningbusinessunit |
RequiredLevel | None |
Targets | businessunit |
Type | Lookup |
OwningBusinessUnitName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningbusinessunitname |
MaxLength | 160 |
RequiredLevel | None |
Type | String |
OwningTeam
Property | Value |
---|---|
Description | Unique identifier for the team that owns the record. |
DisplayName | Owning Team |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningteam |
RequiredLevel | None |
Targets | team |
Type | Lookup |
OwningUser
Property | Value |
---|---|
Description | Unique identifier for the user that owns the record. |
DisplayName | Owning User |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owninguser |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
TransactionCurrencyIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | transactioncurrencyidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
VersionNumber
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
- interactionforemail_ActivityPointers
- interactionforemail_AsyncOperations
- interactionforemail_chats
- interactionforemail_adx_inviteredemptions
- interactionforemail_adx_portalcomments
interactionforemail_ActivityPointers
Same as the interactionforemail_ActivityPointers many-to-one relationship for the activitypointer table/entity.
Property | Value |
---|---|
ReferencingEntity | activitypointer |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | new_interactionforemail_ActivityPointers |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
interactionforemail_AsyncOperations
Same as the interactionforemail_AsyncOperations many-to-one relationship for the asyncoperation table/entity.
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | new_interactionforemail_AsyncOperations |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
interactionforemail_chats
Added by: Activities Patch Solution
Same as the interactionforemail_chats many-to-one relationship for the chat table/entity.
Property | Value |
---|---|
ReferencingEntity | chat |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | interactionforemail_chats |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
interactionforemail_adx_inviteredemptions
Added by: Active Solution Solution
Same as the interactionforemail_adx_inviteredemptions many-to-one relationship for the adx_inviteredemption table/entity.
Property | Value |
---|---|
ReferencingEntity | adx_inviteredemption |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | interactionforemail_adx_inviteredemptions |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
interactionforemail_adx_portalcomments
Added by: Active Solution Solution
Same as the interactionforemail_adx_portalcomments many-to-one relationship for the adx_portalcomment table/entity.
Property | Value |
---|---|
ReferencingEntity | adx_portalcomment |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | interactionforemail_adx_portalcomments |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- lk_interactionforemail_createdby
- lk_interactionforemail_createdonbehalfby
- lk_interactionforemail_modifiedby
- lk_interactionforemail_modifiedonbehalfby
- user_interactionforemail
- team_interactionforemail
- business_unit_interactionforemail
- TransactionCurrency_InteractionForEmail
lk_interactionforemail_createdby
See the lk_interactionforemail_createdby one-to-many relationship for the systemuser table/entity.
lk_interactionforemail_createdonbehalfby
See the lk_interactionforemail_createdonbehalfby one-to-many relationship for the systemuser table/entity.
lk_interactionforemail_modifiedby
See the lk_interactionforemail_modifiedby one-to-many relationship for the systemuser table/entity.
lk_interactionforemail_modifiedonbehalfby
See the lk_interactionforemail_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
user_interactionforemail
See the user_interactionforemail one-to-many relationship for the systemuser table/entity.
team_interactionforemail
See the team_interactionforemail one-to-many relationship for the team table/entity.
business_unit_interactionforemail
See the business_unit_interactionforemail one-to-many relationship for the businessunit table/entity.
TransactionCurrency_InteractionForEmail
See the TransactionCurrency_InteractionForEmail one-to-many relationship for the transactioncurrency table/entity.
See also
Dataverse table/entity reference
Web API Reference
interactionforemail EntityType
Кері байланыс
https://aka.ms/ContentUserFeedback.
Жақында қолжетімді болады: 2024 жыл бойы біз GitHub Issues жүйесін мазмұнға арналған кері байланыс механизмі ретінде біртіндеп қолданыстан шығарамыз және оны жаңа кері байланыс жүйесімен ауыстырамыз. Қосымша ақпаратты мұнда қараңыз:Жіберу және пікірді көру