編輯

共用方式為

Social Activity (SocialActivity) table/entity reference

  • 發行項

For internal use only.

Messages

The following table lists the messages for the Social Activity (SocialActivity) table. Messages represent operations that can be performed on the table. They may also be events.

Name
Is Event?		 Web API Operation SDK for .NET
Assign
Event: True		 PATCH /socialactivities(activityid)
Update the ownerid property.		 AssignRequest
Create
Event: True		 POST /socialactivities
See Create		 Create records
Delete
Event: True		 DELETE /socialactivities(activityid)
See Delete		 Delete records
GrantAccess
Event: True		 GrantAccess GrantAccessRequest
ModifyAccess
Event: True		 ModifyAccess ModifyAccessRequest
Retrieve
Event: True		 GET /socialactivities(activityid)
See Retrieve		 Retrieve records
RetrieveMultiple
Event: True		 GET /socialactivities
See Query data		 Query data
RetrievePrincipalAccess
Event: True		 RetrievePrincipalAccess RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess
Event: True		 RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess
Event: True		 RevokeAccess RevokeAccessRequest
SetState
Event: True		 PATCH /socialactivities(activityid)
Update the statecode and statuscode properties.		 SetStateRequest
Update
Event: True		 PATCH /socialactivities(activityid)
See Update		 Update records
Upsert
Event: False		 PATCH /socialactivities(activityid)
See Upsert a table row		 UpsertRequest

Properties

The following table lists selected properties for the Social Activity (SocialActivity) table.

Property Value
DisplayName Social Activity
DisplayCollectionName Social Activities
SchemaName SocialActivity
CollectionSchemaName SocialActivities
EntitySetName socialactivities
LogicalName socialactivity
LogicalCollectionName socialactivities
PrimaryIdAttribute activityid
PrimaryNameAttribute subject
TableType Standard
OwnershipType UserOwned

Writable columns/attributes

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

ActivityAdditionalParams

Property Value
Description For internal use only.
DisplayName Additional Parameters
IsValidForForm True
IsValidForRead True
LogicalName activityadditionalparams
RequiredLevel None
Type Memo
Format TextArea
FormatName TextArea
ImeMode Auto
IsLocalizable False
MaxLength 8192

ActivityId

Property Value
Description Unique identifier of the activity.
DisplayName Activity
IsValidForForm False
IsValidForRead True
LogicalName activityid
RequiredLevel SystemRequired
Type Uniqueidentifier

ActualDurationMinutes

Property Value
Description Actual duration of the activity in minutes.
DisplayName Actual Duration
IsValidForForm True
IsValidForRead True
LogicalName actualdurationminutes
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue 0

ActualEnd

Property Value
Description Actual end time of the activity.
DisplayName Actual End
IsValidForForm True
IsValidForRead True
LogicalName actualend
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

ActualStart

Property Value
Description Actual start time of the activity.
DisplayName Actual Start
IsValidForForm True
IsValidForRead True
LogicalName actualstart
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

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
DefaultFormValue 0
GlobalChoiceName socialprofile_community

Community Choices/Options

Value Label
0 Other
1 Facebook
2 Twitter

Description

Property Value
Description Shows information about the social post content. This field is read-only.
DisplayName Post Description
IsValidForForm True
IsValidForRead True
LogicalName description
RequiredLevel None
Type Memo
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 2000

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
GlobalChoiceName socialactivity_directioncode
DefaultValue False
True Label Outgoing
False Label Incoming

From

Property Value
Description Person who the activity is from.
DisplayName From
IsValidForForm True
IsValidForRead True
LogicalName from
RequiredLevel None
Type PartyList
Targets account, contact, systemuser

ImportSequenceNumber

Property Value
Description Sequence number of the import that created this record.
DisplayName Import Sequence Number
IsValidForForm False
IsValidForRead True
LogicalName importsequencenumber
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

InResponseTo

Property Value
Description Unique identifier for the responses to a post. For internal use only.
DisplayName In Response To
IsValidForForm True
IsValidForRead True
LogicalName inresponseto
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Active
IsLocalizable False
MaxLength 160

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
GlobalChoiceName socialactivity_isbilled
DefaultValue False
True Label Yes
False Label No

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
GlobalChoiceName socialactivity_isworkflowcreated
DefaultValue False
True Label Yes
False Label No

LastOnHoldTime

Property Value
Description Contains the date and time stamp of the last on hold time.
DisplayName Last On Hold Time
IsValidForForm True
IsValidForRead True
LogicalName lastonholdtime
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

OverriddenCreatedOn

Property Value
Description Date and time that the record was migrated.
DisplayName Record Created On
IsValidForForm False
IsValidForRead True
LogicalName overriddencreatedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateOnly
ImeMode Inactive
SourceTypeMask 0

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
Type Owner
Targets systemuser, team

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
Type Customer
Targets account, contact

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
Type Customer
Targets account, contact

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
Description For internal use only.
DisplayName Created On
IsValidForForm True
IsValidForRead True
LogicalName postedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

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
Type Lookup
Targets socialprofile

PostId

Property Value
Description Unique identifier of the post. For internal use only.
DisplayName Post ID
IsValidForForm True
IsValidForRead True
LogicalName postid
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 160

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
DefaultFormValue -1
GlobalChoiceName socialactivity_postmessagetype

PostMessageType Choices/Options

Value Label
0 Public Message
1 Private Message

PostToProfileId

Property Value
Description Shows the recipients of the social post.
DisplayName Posted To
IsValidForForm True
IsValidForRead True
LogicalName posttoprofileid
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 200

PostURL

Property Value
Description Shows the URL of the post.
DisplayName Post URL
IsValidForForm True
IsValidForRead True
LogicalName posturl
RequiredLevel None
Type String
Format Url
FormatName Url
ImeMode Inactive
IsLocalizable False
MaxLength 200

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
DefaultFormValue 1
GlobalChoiceName socialactivity_prioritycode

PriorityCode Choices/Options

Value Label
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
Type Lookup
Targets account, adx_invitation, asyncoperation, contact, knowledgearticle, knowledgebaserecord, mspp_adplacement, mspp_pollplacement, mspp_publishingstatetransitionrule, mspp_redirect, mspp_shortcut, mspp_website

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
Type PartyList
Targets systemuser

ScheduledDurationMinutes

Property Value
Description Scheduled duration of the activity, specified in minutes.
DisplayName Scheduled Duration
IsValidForForm True
IsValidForRead True
LogicalName scheduleddurationminutes
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue 0

ScheduledEnd

Property Value
Description Scheduled end time of the activity.
DisplayName Due Date
IsValidForForm True
IsValidForRead True
LogicalName scheduledend
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

ScheduledStart

Property Value
Description Scheduled start time of the activity.
DisplayName Start Date
IsValidForForm True
IsValidForRead True
LogicalName scheduledstart
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

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
LogicalName sentimentvalue
RequiredLevel None
Type Double
ImeMode Disabled
MaxValue 100000000000
MinValue -100000000000
Precision 2

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
Type Lookup
Targets sla

SocialAdditionalParams

Property Value
Description For internal use only.
DisplayName Social Additional Parameters
IsValidForForm False
IsValidForRead True
LogicalName socialadditionalparams
RequiredLevel None
Type Memo
Format TextArea
FormatName TextArea
ImeMode Auto
IsLocalizable False
MaxLength 8192

SortDate

Property Value
Description Shows the date and time by which the activities are sorted.
DisplayName Sort Date
IsValidForForm True
IsValidForRead True
LogicalName sortdate
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

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
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State
DefaultFormValue 1
GlobalChoiceName socialactivity_statecode

StateCode Choices/Options

Value Details
0 Label: Open
DefaultStatus: 4
InvariantName: Open
1 Label: Completed
DefaultStatus: 3
InvariantName: Completed
2 Label: Canceled
DefaultStatus: 5
InvariantName: 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
DefaultFormValue 3
GlobalChoiceName socialactivity_statuscode

StatusCode Choices/Options

Value Details
1 Label: Completed
State:1
TransitionData: None
2 Label: Failed
State:1
TransitionData: None
3 Label: Processing
State:1
TransitionData: None
4 Label: Open
State:0
TransitionData: None
5 Label: Canceled
State:2
TransitionData: None

Subject

Property Value
Description Subject associated with the activity.
DisplayName Subject
IsValidForForm True
IsValidForRead True
LogicalName subject
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 200

ThreadId

Property Value
Description Unique identifier of the social conversation. For internal use only.
DisplayName Thread ID
IsValidForForm True
IsValidForRead True
LogicalName threadid
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 160

TimeZoneRuleVersionNumber

Property Value
Description For internal use only.
DisplayName Time Zone Rule Version Number
IsValidForForm False
IsValidForRead True
LogicalName timezoneruleversionnumber
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -1

To

Property Value
Description Person who is the receiver of the activity.
DisplayName To
IsValidForForm True
IsValidForRead True
LogicalName to
RequiredLevel None
Type PartyList
Targets account, contact, systemuser

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
Type Lookup
Targets transactioncurrency

TraversedPath

Property Value
Description For internal use only.
DisplayName (Deprecated) Traversed Path
IsValidForForm False
IsValidForRead True
LogicalName traversedpath
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 1250

UTCConversionTimeZoneCode

Property Value
Description Time zone code that was in use when the record was created.
DisplayName UTC Conversion Time Zone Code
IsValidForForm False
IsValidForRead True
LogicalName utcconversiontimezonecode
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -1

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

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
Type Lookup
Targets systemuser

CreatedOn

Property Value
Description Date and time when the activity was created.
DisplayName Created Date
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

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
Type Lookup
Targets systemuser

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
RequiredLevel None
Type Decimal
ImeMode Disabled
MaxValue 100000000000
MinValue 1E-12
Precision 12
SourceTypeMask 0

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
GlobalChoiceName activitypointer_isregularactivity
DefaultValue True
True Label Yes
False Label No

ModifiedBy

Property Value
Description For internal use only.
DisplayName Modified By
IsValidForForm True
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Type Lookup
Targets systemuser

ModifiedOn

Property Value
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
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

ModifiedOnBehalfBy

Property Value
Description For internal use only.
DisplayName Modified By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

OnHoldTime

Property Value
Description Shows how long, in minutes, that the record was on hold.
DisplayName On Hold Time (Minutes)
IsValidForForm True
IsValidForRead True
LogicalName onholdtime
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

OwnerIdName

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridname
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100

OwnerIdYomiName

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridyominame
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 100

OwningBusinessUnit

Property Value
Description Unique identifier of the business unit that owns the activity.
DisplayName Owning Business Unit
IsValidForForm True
IsValidForRead True
LogicalName owningbusinessunit
RequiredLevel None
Type Lookup
Targets businessunit

OwningTeam

Property Value
Description Unique identifier of the team that owns the activity.
DisplayName Owning Team
IsValidForForm False
IsValidForRead True
LogicalName owningteam
RequiredLevel None
Type Lookup
Targets team

OwningUser

Property Value
Description Unique identifier of the user who owns the Activity.
DisplayName Owning User
IsValidForForm False
IsValidForRead True
LogicalName owninguser
RequiredLevel None
Type Lookup
Targets systemuser

PostAuthorAccountName

Property Value
Description Select the parent account or parent contact for post author.
DisplayName Post author parent
IsValidForForm False
IsValidForRead True
LogicalName postauthoraccountname
RequiredLevel ApplicationRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 160

PostAuthorAccountYomiName

Property Value
Description Select the parent account or parent contact for the post author
DisplayName Post author parent
IsValidForForm False
IsValidForRead True
LogicalName postauthoraccountyominame
RequiredLevel ApplicationRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 450

PostAuthorName

Property Value
Description Account or contact associated with the social profile or author of the post.
DisplayName Post Author Name
IsValidForForm False
IsValidForRead True
LogicalName postauthorname
RequiredLevel ApplicationRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 160

PostAuthorYomiName

Property Value
Description Parent account or parent contact for the social profile of the social activity
DisplayName Post Author Yomi Name
IsValidForForm False
IsValidForRead True
LogicalName postauthoryominame
RequiredLevel ApplicationRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 450

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
Type Lookup
Targets sla

VersionNumber

Property Value
Description Version number of the social activity.
DisplayName Version Number
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
RequiredLevel None
Type BigInt
MaxValue 9223372036854775807
MinValue -9223372036854775808

Many-to-One relationships

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

Account_SocialActivities

One-To-Many Relationship: account Account_SocialActivities

Property Value
ReferencedEntity account
ReferencedAttribute accountid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_account_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

activity_pointer_socialactivity

One-To-Many Relationship: activitypointer activity_pointer_socialactivity

Property Value
ReferencedEntity activitypointer
ReferencedAttribute activityid
ReferencingAttribute activityid
ReferencingEntityNavigationPropertyName activityid_activitypointer
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

adx_invitation_SocialActivities

One-To-Many Relationship: adx_invitation adx_invitation_SocialActivities

Property Value
ReferencedEntity adx_invitation
ReferencedAttribute adx_invitationid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_adx_invitation_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

AsyncOperation_SocialActivities

One-To-Many Relationship: asyncoperation AsyncOperation_SocialActivities

Property Value
ReferencedEntity asyncoperation
ReferencedAttribute asyncoperationid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_asyncoperation
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

business_unit_socialactivity

One-To-Many Relationship: businessunit business_unit_socialactivity

Property Value
ReferencedEntity businessunit
ReferencedAttribute businessunitid
ReferencingAttribute owningbusinessunit
ReferencingEntityNavigationPropertyName owningbusinessunit_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

Contact_SocialActivities

One-To-Many Relationship: contact Contact_SocialActivities

Property Value
ReferencedEntity contact
ReferencedAttribute contactid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_contact_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

KnowledgeArticle_SocialActivities

One-To-Many Relationship: knowledgearticle KnowledgeArticle_SocialActivities

Property Value
ReferencedEntity knowledgearticle
ReferencedAttribute knowledgearticleid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_knowledgearticle_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

KnowledgeBaseRecord_SocialActivities

One-To-Many Relationship: knowledgebaserecord KnowledgeBaseRecord_SocialActivities

Property Value
ReferencedEntity knowledgebaserecord
ReferencedAttribute knowledgebaserecordid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_knowledgebaserecord_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_socialactivity_createdby

One-To-Many Relationship: systemuser lk_socialactivity_createdby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdby
ReferencingEntityNavigationPropertyName createdby_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_socialactivity_modifiedby

One-To-Many Relationship: systemuser lk_socialactivity_modifiedby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedby
ReferencingEntityNavigationPropertyName modifiedby_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_socialactivitybase_createdonbehalfby

One-To-Many Relationship: systemuser lk_socialactivitybase_createdonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdonbehalfby
ReferencingEntityNavigationPropertyName createdonbehalfby_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_socialactivitybase_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_socialactivitybase_modifiedonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedonbehalfby
ReferencingEntityNavigationPropertyName modifiedonbehalfby_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

manualsla_socialactivity

One-To-Many Relationship: sla manualsla_socialactivity

Property Value
ReferencedEntity sla
ReferencedAttribute slaid
ReferencingAttribute slaid
ReferencingEntityNavigationPropertyName sla_socialactivity_sla
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_adplacement_SocialActivities

One-To-Many Relationship: mspp_adplacement mspp_adplacement_SocialActivities

Property Value
ReferencedEntity mspp_adplacement
ReferencedAttribute mspp_adplacementid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_mspp_adplacement_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_pollplacement_SocialActivities

One-To-Many Relationship: mspp_pollplacement mspp_pollplacement_SocialActivities

Property Value
ReferencedEntity mspp_pollplacement
ReferencedAttribute mspp_pollplacementid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_mspp_pollplacement_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_publishingstatetransitionrule_SocialActivities

One-To-Many Relationship: mspp_publishingstatetransitionrule mspp_publishingstatetransitionrule_SocialActivities

Property Value
ReferencedEntity mspp_publishingstatetransitionrule
ReferencedAttribute mspp_publishingstatetransitionruleid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_mspp_publishingstatetransitionrule_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_redirect_SocialActivities

One-To-Many Relationship: mspp_redirect mspp_redirect_SocialActivities

Property Value
ReferencedEntity mspp_redirect
ReferencedAttribute mspp_redirectid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_mspp_redirect_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_shortcut_SocialActivities

One-To-Many Relationship: mspp_shortcut mspp_shortcut_SocialActivities

Property Value
ReferencedEntity mspp_shortcut
ReferencedAttribute mspp_shortcutid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_mspp_shortcut_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_website_SocialActivities

One-To-Many Relationship: mspp_website mspp_website_SocialActivities

Property Value
ReferencedEntity mspp_website
ReferencedAttribute mspp_websiteid
ReferencingAttribute regardingobjectid
ReferencingEntityNavigationPropertyName regardingobjectid_mspp_website_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

owner_socialactivities

One-To-Many Relationship: owner owner_socialactivities

Property Value
ReferencedEntity owner
ReferencedAttribute ownerid
ReferencingAttribute ownerid
ReferencingEntityNavigationPropertyName ownerid_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

sla_socialactivity

One-To-Many Relationship: sla sla_socialactivity

Property Value
ReferencedEntity sla
ReferencedAttribute slaid
ReferencingAttribute slainvokedid
ReferencingEntityNavigationPropertyName slainvokedid_socialactivity_sla
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

SocialActivity_PostAuthor_accounts

One-To-Many Relationship: account SocialActivity_PostAuthor_accounts

Property Value
ReferencedEntity account
ReferencedAttribute accountid
ReferencingAttribute postauthor
ReferencingEntityNavigationPropertyName postauthor_account
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

socialactivity_postauthor_contacts

One-To-Many Relationship: contact socialactivity_postauthor_contacts

Property Value
ReferencedEntity contact
ReferencedAttribute contactid
ReferencingAttribute postauthor
ReferencingEntityNavigationPropertyName postauthor_contact
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

SocialActivity_PostAuthorAccount_accounts

One-To-Many Relationship: account SocialActivity_PostAuthorAccount_accounts

Property Value
ReferencedEntity account
ReferencedAttribute accountid
ReferencingAttribute postauthoraccount
ReferencingEntityNavigationPropertyName postauthoraccount_account
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

socialactivity_postauthoraccount_contacts

One-To-Many Relationship: contact socialactivity_postauthoraccount_contacts

Property Value
ReferencedEntity contact
ReferencedAttribute contactid
ReferencingAttribute postauthoraccount
ReferencingEntityNavigationPropertyName postauthoraccount_contact
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

Socialprofile_SocialActivities

One-To-Many Relationship: socialprofile Socialprofile_SocialActivities

Property Value
ReferencedEntity socialprofile
ReferencedAttribute socialprofileid
ReferencingAttribute postfromprofileid
ReferencingEntityNavigationPropertyName postfromprofileid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

team_socialactivity

One-To-Many Relationship: team team_socialactivity

Property Value
ReferencedEntity team
ReferencedAttribute teamid
ReferencingAttribute owningteam
ReferencingEntityNavigationPropertyName owningteam_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

transactioncurrency_socialactivity

One-To-Many Relationship: transactioncurrency transactioncurrency_socialactivity

Property Value
ReferencedEntity transactioncurrency
ReferencedAttribute transactioncurrencyid
ReferencingAttribute transactioncurrencyid
ReferencingEntityNavigationPropertyName transactioncurrencyid_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: Restrict
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

user_socialactivity

One-To-Many Relationship: systemuser user_socialactivity

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute owninguser
ReferencingEntityNavigationPropertyName owninguser_socialactivity
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

One-to-Many relationships

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

slakpiinstance_socialactivity

Many-To-One Relationship: slakpiinstance slakpiinstance_socialactivity

Property Value
ReferencingEntity slakpiinstance
ReferencingAttribute regarding
ReferencedEntityNavigationPropertyName slakpiinstance_socialactivity
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

socialactivity_activity_parties

Many-To-One Relationship: activityparty socialactivity_activity_parties

Property Value
ReferencingEntity activityparty
ReferencingAttribute activityid
ReferencedEntityNavigationPropertyName socialactivity_activity_parties
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

SocialActivity_Annotation

Many-To-One Relationship: annotation SocialActivity_Annotation

Property Value
ReferencingEntity annotation
ReferencingAttribute objectid
ReferencedEntityNavigationPropertyName SocialActivity_Annotation
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

SocialActivity_AsyncOperations

Many-To-One Relationship: asyncoperation SocialActivity_AsyncOperations

Property Value
ReferencingEntity asyncoperation
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName SocialActivity_AsyncOperations
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

SocialActivity_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure SocialActivity_BulkDeleteFailures

Property Value
ReferencingEntity bulkdeletefailure
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName SocialActivity_BulkDeleteFailures
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

socialactivity_connections1

Many-To-One Relationship: connection socialactivity_connections1

Property Value
ReferencingEntity connection
ReferencingAttribute record1id
ReferencedEntityNavigationPropertyName socialactivity_connections1
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 100
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

socialactivity_connections2

Many-To-One Relationship: connection socialactivity_connections2

Property Value
ReferencingEntity connection
ReferencingAttribute record2id
ReferencedEntityNavigationPropertyName socialactivity_connections2
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order: 100
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

SocialActivity_DuplicateBaseRecord

Many-To-One Relationship: duplicaterecord SocialActivity_DuplicateBaseRecord

Property Value
ReferencingEntity duplicaterecord
ReferencingAttribute baserecordid
ReferencedEntityNavigationPropertyName SocialActivity_DuplicateBaseRecord
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

SocialActivity_DuplicateMatchingRecord

Many-To-One Relationship: duplicaterecord SocialActivity_DuplicateMatchingRecord

Property Value
ReferencingEntity duplicaterecord
ReferencingAttribute duplicaterecordid
ReferencedEntityNavigationPropertyName SocialActivity_DuplicateMatchingRecord
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

socialactivity_principalobjectattributeaccess

Many-To-One Relationship: principalobjectattributeaccess socialactivity_principalobjectattributeaccess

Property Value
ReferencingEntity principalobjectattributeaccess
ReferencingAttribute objectid
ReferencedEntityNavigationPropertyName socialactivity_principalobjectattributeaccess
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

SocialActivity_ProcessSessions

Many-To-One Relationship: processsession SocialActivity_ProcessSessions

Property Value
ReferencingEntity processsession
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName SocialActivity_ProcessSessions
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: UseCollectionName
Group: Details
Label:
MenuId: null
Order: 110
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

SocialActivity_QueueItem

Many-To-One Relationship: queueitem SocialActivity_QueueItem

Property Value
ReferencingEntity queueitem
ReferencingAttribute objectid
ReferencedEntityNavigationPropertyName SocialActivity_QueueItem
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

SocialActivity_SyncErrors

Many-To-One Relationship: syncerror SocialActivity_SyncErrors

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName SocialActivity_SyncErrors
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
socialactivity