SocialActivity table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
For internal use only.
Messages
| Message | Web API Operation | SDK Assembly |
|---|---|---|
| Assign | PATCH [org URI]/api/data/v9.0/socialactivities(activityid) Update ownerid property. |
AssignRequest |
| Create | POST [org URI]/api/data/v9.0/socialactivities See Create |
CreateRequest or Create |
| Delete | DELETE [org URI]/api/data/v9.0/socialactivities(activityid) See Delete |
DeleteRequest or Delete |
| GrantAccess | GrantAccess Action | GrantAccessRequest |
| ModifyAccess | ModifyAccess Action | ModifyAccessRequest |
| Retrieve | GET [org URI]/api/data/v9.0/socialactivities(activityid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/socialactivities See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| RetrievePrincipalAccess | RetrievePrincipalAccess Function | RetrievePrincipalAccessRequest |
| RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess Function | RetrieveSharedPrincipalsAndAccessRequest |
| RevokeAccess | RevokeAccess Action | RevokeAccessRequest |
| SetState | PATCH [org URI]/api/data/v9.0/socialactivities(activityid) Update statecode and statuscode properties. |
SetStateRequest |
| Update | PATCH [org URI]/api/data/v9.0/socialactivities(activityid) See Update |
UpdateRequest or Update |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | SocialActivities |
| DisplayCollectionName | Social Activities |
| DisplayName | Social Activity |
| EntitySetName | socialactivities |
| IsBPFEntity | False |
| LogicalCollectionName | socialactivities |
| LogicalName | socialactivity |
| OwnershipType | UserOwned |
| PrimaryIdAttribute | activityid |
| PrimaryNameAttribute | subject |
| SchemaName | SocialActivity |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- ActivityAdditionalParams
- ActivityId
- ActualDurationMinutes
- ActualEnd
- ActualStart
- Community
- Description
- DirectionCode
- From
- ImportSequenceNumber
- InResponseTo
- IsBilled
- IsWorkflowCreated
- LastOnHoldTime
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- PostAuthor
- PostAuthorAccount
- PostAuthorAccountType
- PostAuthorType
- PostedOn
- PostFromProfileId
- PostId
- PostMessageType
- PostToProfileId
- PostURL
- PriorityCode
- ProcessId
- RegardingObjectId
- RegardingObjectIdName
- RegardingObjectIdYomiName
- RegardingObjectTypeCode
- Resources
- ScheduledDurationMinutes
- ScheduledEnd
- ScheduledStart
- SentimentValue
- SLAId
- SocialAdditionalParams
- SortDate
- StageId
- StateCode
- StatusCode
- Subject
- ThreadId
- TimeZoneRuleVersionNumber
- To
- TransactionCurrencyId
- TraversedPath
- UTCConversionTimeZoneCode
ActivityAdditionalParams
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Additional Parameters |
| Format | TextArea |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | activityadditionalparams |
| MaxLength | 8192 |
| RequiredLevel | None |
| Type | Memo |
ActivityId
| Property | Value |
|---|---|
| Description | Unique identifier of the activity. |
| DisplayName | Activity |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | activityid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ActualDurationMinutes
| Property | Value |
|---|---|
| Description | Actual duration of the activity in minutes. |
| DisplayName | Actual Duration |
| Format | Duration |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | actualdurationminutes |
| MaxValue | 2147483647 |
| MinValue | 0 |
| RequiredLevel | None |
| Type | Integer |
ActualEnd
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Actual end time of the activity. |
| DisplayName | Actual End |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | actualend |
| RequiredLevel | None |
| Type | DateTime |
ActualStart
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Actual start time of the activity. |
| DisplayName | Actual Start |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | actualstart |
| RequiredLevel | None |
| Type | DateTime |
Community
| Property | Value |
|---|---|
| Description | Shows how contact about the social activity originated, such as from Twitter or Facebook. This field is read-only. |
| DisplayName | Social Channel |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | community |
| RequiredLevel | None |
| Type | Picklist |
Community Choices/Options
| Value | Label | Description |
|---|---|---|
| 0 | Other | Other default |
| 1 | Facebook item. | |
| 2 | Twitter. |
Description
| Property | Value |
|---|---|
| Description | Shows information about the social post content. This field is read-only. |
| DisplayName | Post Description |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | description |
| MaxLength | 2000 |
| RequiredLevel | None |
| Type | Memo |
DirectionCode
| Property | Value |
|---|---|
| Description | Select the direction of the post as incoming or outbound. |
| DisplayName | Direction |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | directioncode |
| RequiredLevel | None |
| Type | Boolean |
DirectionCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Outgoing | |
| 0 | Incoming |
DefaultValue: False
From
| Property | Value |
|---|---|
| Description | Person who the activity is from. |
| DisplayName | From |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | from |
| RequiredLevel | None |
| Targets | account,contact,systemuser |
| Type | PartyList |
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 |
InResponseTo
| Property | Value |
|---|---|
| Description | Unique identifier for the responses to a post. For internal use only. |
| DisplayName | In Response To |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | inresponseto |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
IsBilled
| Property | Value |
|---|---|
| Description | Information regarding whether the activity was billed as part of resolving a case. |
| DisplayName | Is Billed |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | isbilled |
| RequiredLevel | None |
| Type | Boolean |
IsBilled Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: False
IsWorkflowCreated
| Property | Value |
|---|---|
| Description | Information regarding whether the activity was created from a workflow rule. |
| DisplayName | Is Workflow Created |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | isworkflowcreated |
| RequiredLevel | None |
| Type | Boolean |
IsWorkflowCreated Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: False
LastOnHoldTime
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Contains the date and time stamp of the last on hold time. |
| DisplayName | Last On Hold Time |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | lastonholdtime |
| RequiredLevel | None |
| Type | DateTime |
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 activity. |
| DisplayName | Owner |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | SystemRequired |
| Targets | systemuser,team |
| Type | Owner |
OwnerIdType
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
PostAuthor
| Property | Value |
|---|---|
| Description | Shows the contact or account that authored the post. |
| DisplayName | Post Author |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | postauthor |
| RequiredLevel | None |
| Targets | account,contact |
| Type | Customer |
PostAuthorAccount
| Property | Value |
|---|---|
| Description | Shows the parent account of the author of the post. |
| DisplayName | Post Author Account |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | postauthoraccount |
| RequiredLevel | ApplicationRequired |
| Targets | account,contact |
| Type | Customer |
PostAuthorAccountType
| Property | Value |
|---|---|
| Description | Select the parent account or parent contact for the post author |
| DisplayName | Post author parent |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postauthoraccounttype |
| RequiredLevel | None |
| Type | EntityName |
PostAuthorType
| Property | Value |
|---|---|
| Description | Select the parent account or parent contact for the social profile of the social activity |
| DisplayName | Post Author Type |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postauthortype |
| RequiredLevel | None |
| Type | EntityName |
PostedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | For internal use only. |
| DisplayName | Created On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | postedon |
| RequiredLevel | None |
| Type | DateTime |
PostFromProfileId
| Property | Value |
|---|---|
| Description | Shows the author of the post on the corresponding social channel. |
| DisplayName | Posted By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | postfromprofileid |
| RequiredLevel | None |
| Targets | socialprofile |
| Type | Lookup |
PostId
| Property | Value |
|---|---|
| Description | Unique identifier of the post. For internal use only. |
| DisplayName | Post ID |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | postid |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
PostMessageType
| Property | Value |
|---|---|
| Description | Shows if the social post originated as a private or public message. |
| DisplayName | Received As |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postmessagetype |
| RequiredLevel | None |
| Type | Picklist |
PostMessageType Choices/Options
| Value | Label | Description |
|---|---|---|
| 0 | Public Message | |
| 1 | Private Message |
PostToProfileId
| Property | Value |
|---|---|
| Description | Shows the recipients of the social post. |
| DisplayName | Posted To |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | posttoprofileid |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
PostURL
| Property | Value |
|---|---|
| Description | Shows the URL of the post. |
| DisplayName | Post URL |
| FormatName | Url |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | posturl |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
PriorityCode
| Property | Value |
|---|---|
| Description | Shows the priority so that preferred customers or critical issues are handled quickly. |
| DisplayName | Priority |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | prioritycode |
| RequiredLevel | None |
| Type | Picklist |
PriorityCode Choices/Options
| Value | Label | Description |
|---|---|---|
| 0 | Low | |
| 1 | Normal | |
| 2 | High |
ProcessId
| Property | Value |
|---|---|
| Description | Unique identifier of the Process. |
| DisplayName | Process |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | processid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
RegardingObjectId
| Property | Value |
|---|---|
| Description | Shows the record that the social activity relates to. |
| DisplayName | Regarding |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | regardingobjectid |
| RequiredLevel | None |
| Targets | account,asyncoperation,contact,knowledgearticle,knowledgebaserecord |
| Type | Lookup |
RegardingObjectIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | regardingobjectidname |
| MaxLength | 400 |
| RequiredLevel | None |
| Type | String |
RegardingObjectIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | regardingobjectidyominame |
| MaxLength | 400 |
| RequiredLevel | None |
| Type | String |
RegardingObjectTypeCode
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | regardingobjecttypecode |
| RequiredLevel | None |
| Type | EntityName |
Resources
| Property | Value |
|---|---|
| Description | Users or facility/equipment that are required for the activity. |
| DisplayName | Resources |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | resources |
| RequiredLevel | None |
| Targets | systemuser |
| Type | PartyList |
ScheduledDurationMinutes
| Property | Value |
|---|---|
| Description | Scheduled duration of the activity, specified in minutes. |
| DisplayName | Scheduled Duration |
| Format | Duration |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | scheduleddurationminutes |
| MaxValue | 2147483647 |
| MinValue | 0 |
| RequiredLevel | None |
| Type | Integer |
ScheduledEnd
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Scheduled end time of the activity. |
| DisplayName | Due Date |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | scheduledend |
| RequiredLevel | None |
| Type | DateTime |
ScheduledStart
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Scheduled start time of the activity. |
| DisplayName | Start Date |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | scheduledstart |
| RequiredLevel | None |
| Type | DateTime |
SentimentValue
| Property | Value |
|---|---|
| Description | Value derived after assessing words commonly associated with a negative, neutral, or positive sentiment that occurs in a social post. Sentiment information can also be reported as numeric values. |
| DisplayName | Sentiment Value |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | sentimentvalue |
| MaxValue | 100000000000 |
| MinValue | -100000000000 |
| Precision | 2 |
| RequiredLevel | None |
| Type | Double |
SLAId
| Property | Value |
|---|---|
| Description | Choose the service level agreement (SLA) that you want to apply to the Social Activity record. |
| DisplayName | SLA |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | slaid |
| RequiredLevel | None |
| Targets | sla |
| Type | Lookup |
SocialAdditionalParams
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Social Additional Parameters |
| Format | TextArea |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | socialadditionalparams |
| MaxLength | 8192 |
| RequiredLevel | None |
| Type | Memo |
SortDate
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Shows the date and time by which the activities are sorted. |
| DisplayName | Sort Date |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | sortdate |
| RequiredLevel | None |
| Type | DateTime |
StageId
| Property | Value |
|---|---|
| Description | Unique identifier of the Stage. |
| DisplayName | (Deprecated) Process Stage |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | stageid |
| RequiredLevel | None |
| Type | Uniqueidentifier |
StateCode
| Property | Value |
|---|---|
| Description | Shows whether the social activity completed. This field is read-only. |
| DisplayName | Status |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
StateCode Choices/Options
| Value | Label | DefaultStatus | InvariantName |
|---|---|---|---|
| 0 | Open | 4 | Open |
| 1 | Completed | 3 | Completed |
| 2 | Canceled | 5 | Canceled |
StatusCode
| Property | Value |
|---|---|
| Description | Shows whether the social activity is completed, failed, or processing. This field is read-only. |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
StatusCode Choices/Options
| Value | Label | State |
|---|---|---|
| 1 | Completed | 1 |
| 2 | Failed | 1 |
| 3 | Processing | 1 |
| 4 | Open | 0 |
| 5 | Canceled | 2 |
Subject
| Property | Value |
|---|---|
| Description | Subject associated with the activity. |
| DisplayName | Subject |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | subject |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
ThreadId
| Property | Value |
|---|---|
| Description | Unique identifier of the social conversation. For internal use only. |
| DisplayName | Thread ID |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | threadid |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
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 |
To
| Property | Value |
|---|---|
| Description | Person who is the receiver of the activity. |
| DisplayName | To |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | to |
| RequiredLevel | None |
| Targets | account,contact,systemuser |
| Type | PartyList |
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 |
| Targets | transactioncurrency |
| Type | Lookup |
TraversedPath
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | (Deprecated) Traversed Path |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | traversedpath |
| MaxLength | 1250 |
| RequiredLevel | None |
| Type | String |
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.
- ActivityTypeCode
- CreatedBy
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ExchangeRate
- IsRegularActivity
- ModifiedBy
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OnHoldTime
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- PostAuthorAccountName
- PostAuthorAccountYomiName
- PostAuthorName
- PostAuthorYomiName
- PostFromProfileIdName
- SLAInvokedId
- SLAInvokedIdName
- SLAName
- TransactionCurrencyIdName
- VersionNumber
ActivityTypeCode
| Property | Value |
|---|---|
| Description | Type of activity. |
| DisplayName | Activity Type |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | activitytypecode |
| RequiredLevel | SystemRequired |
| Type | EntityName |
CreatedBy
| Property | Value |
|---|---|
| Description | Unique identifier of the user who created the activity. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the activity was created. |
| DisplayName | Created Date |
| 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 activitypointer. |
| 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 | None |
| Type | String |
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 |
| MaxValue | 100000000000 |
| MinValue | 0.000000000001 |
| Precision | 12 |
| RequiredLevel | None |
| Type | Decimal |
IsRegularActivity
| Property | Value |
|---|---|
| Description | Information regarding 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 |
IsRegularActivity Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: True
ModifiedBy
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| 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 | Last Updated |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
ModifiedOnBehalfBy
| Property | Value |
|---|---|
| Description | For internal use only. |
| 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 | None |
| Type | String |
OnHoldTime
| Property | Value |
|---|---|
| Description | Shows how long, in minutes, that the record was on hold. |
| DisplayName | On Hold Time (Minutes) |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | onholdtime |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
OwnerIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwnerIdYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwningBusinessUnit
| Property | Value |
|---|---|
| Description | Unique identifier of the business unit that owns the activity. |
| DisplayName | Owning Business Unit |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | None |
| Targets | businessunit |
| Type | Lookup |
OwningTeam
| Property | Value |
|---|---|
| Description | Unique identifier of the team that owns the activity. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Targets | team |
| Type | Lookup |
OwningUser
| Property | Value |
|---|---|
| Description | Unique identifier of the user who owns the Activity. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
PostAuthorAccountName
| Property | Value |
|---|---|
| Description | Select the parent account or parent contact for post author. |
| DisplayName | Post author parent |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postauthoraccountname |
| MaxLength | 160 |
| RequiredLevel | ApplicationRequired |
| Type | String |
PostAuthorAccountYomiName
| Property | Value |
|---|---|
| Description | Select the parent account or parent contact for the post author |
| DisplayName | Post author parent |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postauthoraccountyominame |
| MaxLength | 450 |
| RequiredLevel | ApplicationRequired |
| Type | String |
PostAuthorName
| Property | Value |
|---|---|
| Description | Account or contact associated with the social profile or author of the post. |
| DisplayName | Post Author Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postauthorname |
| MaxLength | 160 |
| RequiredLevel | ApplicationRequired |
| Type | String |
PostAuthorYomiName
| Property | Value |
|---|---|
| Description | Parent account or parent contact for the social profile of the social activity |
| DisplayName | Post Author Yomi Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postauthoryominame |
| MaxLength | 450 |
| RequiredLevel | ApplicationRequired |
| Type | String |
PostFromProfileIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | postedbyname |
| MaxLength | 100 |
| RequiredLevel | ApplicationRequired |
| Type | String |
SLAInvokedId
| Property | Value |
|---|---|
| Description | Last SLA that was applied to this Social Activity. This field is for internal use only. |
| DisplayName | Last SLA applied |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | slainvokedid |
| RequiredLevel | None |
| Targets | sla |
| Type | Lookup |
SLAInvokedIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | slainvokedidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
SLAName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | slaname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
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 | Version number of the social activity. |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
- socialactivity_principalobjectattributeaccess
- socialactivity_activity_parties
- SocialActivity_BulkDeleteFailures
- SocialActivity_QueueItem
- SocialActivity_SyncErrors
- slakpiinstance_socialactivity
- SocialActivity_DuplicateBaseRecord
- SocialActivity_AsyncOperations
- SocialActivity_ProcessSessions
- SocialActivity_DuplicateMatchingRecord
- socialactivity_connections1
- SocialActivity_Annotation
- socialactivity_connections2
socialactivity_principalobjectattributeaccess
Same as principalobjectattributeaccess table socialactivity_principalobjectattributeaccess Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | principalobjectattributeaccess |
| ReferencingAttribute | objectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | socialactivity_principalobjectattributeaccess |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
socialactivity_activity_parties
Same as activityparty table socialactivity_activity_parties Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | activityparty |
| ReferencingAttribute | activityid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | socialactivity_activity_parties |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_BulkDeleteFailures
Same as bulkdeletefailure table SocialActivity_BulkDeleteFailures Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | SocialActivity_BulkDeleteFailures |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_QueueItem
Same as queueitem table SocialActivity_QueueItem Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | queueitem |
| ReferencingAttribute | objectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | SocialActivity_QueueItem |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_SyncErrors
Same as syncerror table SocialActivity_SyncErrors Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | SocialActivity_SyncErrors |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
slakpiinstance_socialactivity
Same as slakpiinstance table slakpiinstance_socialactivity Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | slakpiinstance |
| ReferencingAttribute | regarding |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | slakpiinstance_socialactivity |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_DuplicateBaseRecord
Same as duplicaterecord table SocialActivity_DuplicateBaseRecord Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | duplicaterecord |
| ReferencingAttribute | baserecordid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | SocialActivity_DuplicateBaseRecord |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_AsyncOperations
Same as asyncoperation table SocialActivity_AsyncOperations Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | SocialActivity_AsyncOperations |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_ProcessSessions
Same as processsession table SocialActivity_ProcessSessions Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | processsession |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | SocialActivity_ProcessSessions |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_DuplicateMatchingRecord
Same as duplicaterecord table SocialActivity_DuplicateMatchingRecord Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | duplicaterecord |
| ReferencingAttribute | duplicaterecordid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | SocialActivity_DuplicateMatchingRecord |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
socialactivity_connections1
Same as connection table socialactivity_connections1 Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | connection |
| ReferencingAttribute | record1id |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | socialactivity_connections1 |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 100 |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
SocialActivity_Annotation
Same as annotation table SocialActivity_Annotation Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | annotation |
| ReferencingAttribute | objectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | SocialActivity_Annotation |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
socialactivity_connections2
Same as connection table socialactivity_connections2 Many-To-One relationship.
| Property | Value |
|---|---|
| ReferencingEntity | connection |
| ReferencingAttribute | record2id |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | socialactivity_connections2 |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 100 |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
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.
- KnowledgeBaseRecord_SocialActivities
- socialactivity_postauthoraccount_contacts
- KnowledgeArticle_SocialActivities
- activity_pointer_socialactivity
- SocialActivity_PostAuthorAccount_accounts
- lk_socialactivity_createdby
- Account_SocialActivities
- transactioncurrency_socialactivity
- sla_socialactivity
- user_socialactivity
- business_unit_socialactivity
- socialactivity_postauthor_contacts
- team_socialactivity
- manualsla_socialactivity
- SocialActivity_PostAuthor_accounts
- Socialprofile_SocialActivities
- AsyncOperation_SocialActivities
- lk_socialactivity_modifiedby
- lk_socialactivitybase_createdonbehalfby
- lk_socialactivitybase_modifiedonbehalfby
- Contact_SocialActivities
KnowledgeBaseRecord_SocialActivities
See knowledgebaserecord Table KnowledgeBaseRecord_SocialActivities One-To-Many relationship.
socialactivity_postauthoraccount_contacts
See contact Table socialactivity_postauthoraccount_contacts One-To-Many relationship.
KnowledgeArticle_SocialActivities
See knowledgearticle Table KnowledgeArticle_SocialActivities One-To-Many relationship.
activity_pointer_socialactivity
See activitypointer Table activity_pointer_socialactivity One-To-Many relationship.
SocialActivity_PostAuthorAccount_accounts
See account Table SocialActivity_PostAuthorAccount_accounts One-To-Many relationship.
lk_socialactivity_createdby
See systemuser Table lk_socialactivity_createdby One-To-Many relationship.
Account_SocialActivities
See account Table Account_SocialActivities One-To-Many relationship.
transactioncurrency_socialactivity
See transactioncurrency Table transactioncurrency_socialactivity One-To-Many relationship.
sla_socialactivity
See sla Table sla_socialactivity One-To-Many relationship.
user_socialactivity
See systemuser Table user_socialactivity One-To-Many relationship.
business_unit_socialactivity
See businessunit Table business_unit_socialactivity One-To-Many relationship.
socialactivity_postauthor_contacts
See contact Table socialactivity_postauthor_contacts One-To-Many relationship.
team_socialactivity
See team Table team_socialactivity One-To-Many relationship.
manualsla_socialactivity
See sla Table manualsla_socialactivity One-To-Many relationship.
SocialActivity_PostAuthor_accounts
See account Table SocialActivity_PostAuthor_accounts One-To-Many relationship.
Socialprofile_SocialActivities
See socialprofile Table Socialprofile_SocialActivities One-To-Many relationship.
AsyncOperation_SocialActivities
See asyncoperation Table AsyncOperation_SocialActivities One-To-Many relationship.
lk_socialactivity_modifiedby
See systemuser Table lk_socialactivity_modifiedby One-To-Many relationship.
lk_socialactivitybase_createdonbehalfby
See systemuser Table lk_socialactivitybase_createdonbehalfby One-To-Many relationship.
lk_socialactivitybase_modifiedonbehalfby
See systemuser Table lk_socialactivitybase_modifiedonbehalfby One-To-Many relationship.
Contact_SocialActivities
See contact Table Contact_SocialActivities One-To-Many relationship.
See also
About the table reference
Web API Reference
socialactivity EntityType