msdyn_SCIConversation table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Added by: Conversation Intelligence Solution
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
Assign | PATCH /msdyn_sciconversations(msdyn_sciconversationid) Update ownerid property. |
AssignRequest |
BulkRetain | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
Create | POST /msdyn_sciconversations See Create |
CreateRequest or Create |
CreateMultiple | CreateMultiple | CreateMultipleRequest |
Delete | DELETE /msdyn_sciconversations(msdyn_sciconversationid) See Delete |
DeleteRequest or Delete |
GrantAccess | GrantAccess | GrantAccessRequest |
IsValidStateTransition | IsValidStateTransition | IsValidStateTransitionRequest |
ModifyAccess | ModifyAccess | ModifyAccessRequest |
PurgeRetainedContent | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
Retain | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
Retrieve | GET /msdyn_sciconversations(msdyn_sciconversationid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET /msdyn_sciconversations See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
RetrievePrincipalAccess | RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess | RevokeAccess | RevokeAccessRequest |
RollbackRetain | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
SetState | PATCH /msdyn_sciconversations(msdyn_sciconversationid) Update statecode and statuscode properties. |
SetStateRequest |
Update | PATCH /msdyn_sciconversations(msdyn_sciconversationid) See Update |
UpdateRequest or Update |
UpdateMultiple | UpdateMultiple | UpdateMultipleRequest |
ValidateRetentionConfig | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. |
Properties
Property | Value |
---|---|
CollectionSchemaName | msdyn_SCIConversations |
DisplayCollectionName | SCI Conversations |
DisplayName | SCI Conversation |
EntitySetName | msdyn_sciconversations |
IsBPFEntity | False |
LogicalCollectionName | msdyn_sciconversations |
LogicalName | msdyn_sciconversation |
OwnershipType | UserOwned |
PrimaryIdAttribute | msdyn_sciconversationid |
PrimaryNameAttribute | msdyn_name |
SchemaName | msdyn_SCIConversation |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- ImportSequenceNumber
- msdyn_ChatId
- msdyn_ClientFileName
- msdyn_CommunicationType
- msdyn_ConsentModeId
- msdyn_ConversationAggregatedInsights
- msdyn_ConversationId
- msdyn_ConversationScope
- msdyn_ConversationStartTime
- msdyn_Direction
- msdyn_Name
- msdyn_OCRecording
- msdyn_RelatedActivity
- msdyn_RelatedActivityIdType
- msdyn_SCIConversationId
- msdyn_Transcript
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- statecode
- statuscode
- TimeZoneRuleVersionNumber
- UTCConversionTimeZoneCode
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 |
msdyn_ChatId
Property | Value |
---|---|
Description | |
DisplayName | ChatId |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_chatid |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
msdyn_ClientFileName
Property | Value |
---|---|
Description | |
DisplayName | Client File Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_clientfilename |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
msdyn_CommunicationType
Property | Value |
---|---|
Description | |
DisplayName | Communication Type |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_communicationtype |
RequiredLevel | ApplicationRequired |
Type | Picklist |
msdyn_CommunicationType Choices/Options
Value | Label | Description |
---|---|---|
0 | Phonecall | |
1 | Meeting |
msdyn_ConsentModeId
Property | Value |
---|---|
Description | |
DisplayName | Consent Mode |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_consentmodeid |
RequiredLevel | None |
Type | Picklist |
msdyn_ConsentModeId Choices/Options
Value | Label | Description |
---|---|---|
1 | All | |
2 | AgentsOnly | |
3 | CurrentUserOnly |
msdyn_ConversationAggregatedInsights
Property | Value |
---|---|
Description | |
DisplayName | ConversationAggregatedInsights |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_conversationaggregatedinsights |
RequiredLevel | None |
Targets | msdyn_conversationaggregatedinsights |
Type | Lookup |
msdyn_ConversationId
Property | Value |
---|---|
Description | |
DisplayName | ConversationId |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_conversationid |
MaxLength | 36 |
RequiredLevel | None |
Type | String |
msdyn_ConversationScope
Property | Value |
---|---|
Description | |
DisplayName | Conversation Scope |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_conversationscope |
RequiredLevel | None |
Type | Picklist |
msdyn_ConversationScope Choices/Options
Value | Label | Description |
---|---|---|
0 | Internal | |
1 | External |
msdyn_ConversationStartTime
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | |
DisplayName | ConversationStartTime |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_conversationstarttime |
RequiredLevel | ApplicationRequired |
Type | DateTime |
msdyn_Direction
Property | Value |
---|---|
Description | |
DisplayName | Direction |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_direction |
RequiredLevel | None |
Type | Picklist |
msdyn_Direction Choices/Options
Value | Label | Description |
---|---|---|
0 | Outgoing | |
1 | Incoming |
msdyn_Name
Property | Value |
---|---|
Description | |
DisplayName | Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_name |
MaxLength | 100 |
RequiredLevel | ApplicationRequired |
Type | String |
msdyn_OCRecording
Property | Value |
---|---|
Description | |
DisplayName | Recording |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_ocrecording |
RequiredLevel | None |
Targets | msdyn_ocrecording |
Type | Lookup |
msdyn_RelatedActivity
Property | Value |
---|---|
Description | |
DisplayName | RelatedActivity |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_relatedactivity |
RequiredLevel | None |
Targets | appointment,phonecall |
Type | Lookup |
msdyn_RelatedActivityIdType
Added by: Active Solution Solution
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_relatedactivityidtype |
RequiredLevel | None |
Type | EntityName |
msdyn_SCIConversationId
Property | Value |
---|---|
Description | Unique identifier for entity instances |
DisplayName | SCI Conversation |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | msdyn_sciconversationid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
msdyn_Transcript
Property | Value |
---|---|
Description | |
DisplayName | Transcript |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | msdyn_transcript |
RequiredLevel | None |
Targets | msdyn_transcript |
Type | Lookup |
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
Added by: Active Solution Solution
Property | Value |
---|---|
Description | Owner Id |
DisplayName | Owner |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | ownerid |
RequiredLevel | SystemRequired |
Targets | systemuser,team |
Type | Owner |
OwnerIdType
Added by: Active Solution Solution
Property | Value |
---|---|
Description | Owner Id Type |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
statecode
Property | Value |
---|---|
Description | Status of the SCI Conversation |
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 SCI Conversation |
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 |
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
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- msdyn_ConversationAggregatedInsightsName
- msdyn_OCRecordingName
- msdyn_RelatedActivityName
- msdyn_RelatedActivityYomiName
- msdyn_TranscriptName
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- VersionNumber
CreatedBy
Added by: Active Solution Solution
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
Added by: Active Solution Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedByYomiName
Added by: Active Solution Solution
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
Added by: Active Solution Solution
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
Added by: Active Solution Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOnBehalfByYomiName
Added by: Active Solution Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
ModifiedBy
Added by: Active Solution Solution
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
Added by: Active Solution Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedByYomiName
Added by: Active Solution Solution
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
Added by: Active Solution Solution
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
Added by: Active Solution Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOnBehalfByYomiName
Added by: Active Solution Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
msdyn_ConversationAggregatedInsightsName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_conversationaggregatedinsightsname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
msdyn_OCRecordingName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_ocrecordingname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
msdyn_RelatedActivityName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_relatedactivityname |
MaxLength | 1000 |
RequiredLevel | None |
Type | String |
msdyn_RelatedActivityYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_relatedactivityyominame |
MaxLength | 1000 |
RequiredLevel | None |
Type | String |
msdyn_TranscriptName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | msdyn_transcriptname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
OwnerIdName
Added by: Active Solution Solution
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
Added by: Active Solution Solution
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
Added by: Active Solution Solution
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
Added by: Active Solution Solution
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningbusinessunitname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
OwningTeam
Added by: Active Solution Solution
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
Added by: Active Solution Solution
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 |
VersionNumber
Added by: Active Solution Solution
Property | Value |
---|---|
Description | Version Number |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
msdyn_msdyn_conversationsystemtag_TagTarget_msd
Same as the msdyn_msdyn_conversationsystemtag_TagTarget_msd many-to-one relationship for the msdyn_conversationsystemtag table/entity.
Property | Value |
---|---|
ReferencingEntity | msdyn_conversationsystemtag |
ReferencingAttribute | msdyn_tagtarget |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | msdyn_msdyn_conversationsystemtag_tagtarget_msd |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
msdyn_msdyn_conversationtag_TagTarget_m
Same as the msdyn_msdyn_conversationtag_TagTarget_m many-to-one relationship for the msdyn_conversationtag table/entity.
Property | Value |
---|---|
ReferencingEntity | msdyn_conversationtag |
ReferencingAttribute | msdyn_tagtarget |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | msdyn_msdyn_conversationtag_tagtarget_m |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
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.
- msdyn_msdyn_sciconversation_ConversationAggrega
- msdyn_msdyn_sciconversation_OCRecording_msdyn_o
- msdyn_msdyn_sciconversation_Transcript_msdyn_tr
msdyn_msdyn_sciconversation_ConversationAggrega
See the msdyn_msdyn_sciconversation_ConversationAggrega one-to-many relationship for the msdyn_conversationaggregatedinsights table/entity.
msdyn_msdyn_sciconversation_OCRecording_msdyn_o
Added by: Omnichannel – Base Solution
See the msdyn_msdyn_sciconversation_OCRecording_msdyn_o one-to-many relationship for the msdyn_ocrecording table/entity.
msdyn_msdyn_sciconversation_Transcript_msdyn_tr
Added by: Omnichannel – Base Solution
See the msdyn_msdyn_sciconversation_Transcript_msdyn_tr one-to-many relationship for the msdyn_transcript table/entity.