Activity (ActivityPointer) table/entity reference

Task performed, or to be performed, by a user. An activity is any action for which an entry can be made on a calendar.

Messages

The following table lists the messages for the Activity (ActivityPointer) 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
Retrieve Event: True	GET /activitypointers(activityid) See Retrieve	Retrieve records
RetrieveMultiple Event: True	GET /activitypointers See Query data	Query data
Rollup Event: False	Rollup	RollupRequest

Properties

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

Property	Value
DisplayName	Activity
DisplayCollectionName	Activities
SchemaName	ActivityPointer
CollectionSchemaName	ActivityPointers
EntitySetName	activitypointers
LogicalName	activitypointer
LogicalCollectionName	activitypointers
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
• ActivityId
• ActualDurationMinutes
• ActualEnd
• ActualStart
• Community
• DeliveryPriorityCode
• Description
• ExchangeItemId
• ExchangeWebLink
• IsBilled
• IsMapiPrivate
• IsWorkflowCreated
• LastOnHoldTime
• LeftVoiceMail
• OwnerId
• OwnerIdType
• PriorityCode
• ProcessId
• RegardingObjectId
• RegardingObjectTypeCode
• ScheduledDurationMinutes
• ScheduledEnd
• ScheduledStart
• SLAId
• SortDate
• StageId
• StateCode
• StatusCode
• Subject
• TimeZoneRuleVersionNumber
• TransactionCurrencyId
• TraversedPath
• UTCConversionTimeZoneCode

ActivityAdditionalParams

Property	Value
Description	Additional information provided by the external application as JSON. For internal use only.
DisplayName	Activity 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	-1
GlobalChoiceName	socialprofile_community

Community Choices/Options

Value	Label
0	Other
1	Facebook
2	Twitter

DeliveryPriorityCode

Property	Value
Description	Priority of delivery of the activity to the email server.
DisplayName	Delivery Priority
IsValidForForm	True
IsValidForRead	True
LogicalName	deliveryprioritycode
RequiredLevel	None
Type	Picklist
DefaultFormValue	1
GlobalChoiceName	activitypointer_deliveryprioritycode

DeliveryPriorityCode Choices/Options

Value	Label
0	Low
1	Normal
2	High

Description

Property	Value
Description	Description of the activity.
DisplayName	Description
IsValidForForm	True
IsValidForRead	True
LogicalName	description
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

ExchangeItemId

Property	Value
Description	The message id of activity which is returned from Exchange Server.
DisplayName	Exchange Item ID
IsValidForForm	False
IsValidForRead	True
LogicalName	exchangeitemid
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

ExchangeWebLink

Property	Value
Description	Shows the web link of Activity of type email.
DisplayName	Exchange WebLink
IsValidForForm	False
IsValidForRead	True
LogicalName	exchangeweblink
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1250

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

IsMapiPrivate

Property	Value
Description	For internal use only.
DisplayName	Is Private
IsValidForForm	False
IsValidForRead	True
LogicalName	ismapiprivate
RequiredLevel	None
Type	Boolean
GlobalChoiceName	activitypointer_ismapiprivate
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	activitypointer_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

LeftVoiceMail

Property	Value
Description	Left the voice mail
DisplayName	Left Voice Mail
IsValidForForm	True
IsValidForRead	True
LogicalName	leftvoicemail
RequiredLevel	None
Type	Boolean
GlobalChoiceName	activitypointer_leftvoicemail
DefaultValue	False
True Label	Yes
False Label	No

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

PriorityCode

Property	Value
Description	Priority of the activity.
DisplayName	Priority
IsValidForForm	True
IsValidForRead	True
LogicalName	prioritycode
RequiredLevel	None
Type	Picklist
DefaultFormValue	1
GlobalChoiceName	activitypointer_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	Unique identifier of the object with which the activity is associated.
DisplayName	Regarding
IsValidForForm	True
IsValidForRead	True
LogicalName	regardingobjectid
RequiredLevel	None
Type	Lookup
Targets	account, adx_invitation, contact, interactionforemail, 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

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

SLAId

Property	Value
Description	Choose the service level agreement (SLA) that you want to apply to the case record.
DisplayName	SLA
IsValidForForm	True
IsValidForRead	True
LogicalName	slaid
RequiredLevel	None
Type	Lookup
Targets	sla

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	Status of the activity.
DisplayName	Activity Status
IsValidForForm	True
IsValidForRead	True
LogicalName	statecode
RequiredLevel	SystemRequired
Type	State
DefaultFormValue	0
GlobalChoiceName	activitypointer_statecode

StateCode Choices/Options

Value	Details
0	Label: Open DefaultStatus: 1 InvariantName: Open
1	Label: Completed DefaultStatus: 2 InvariantName: Completed
2	Label: Canceled DefaultStatus: 3 InvariantName: Canceled
3	Label: Scheduled DefaultStatus: 4 InvariantName: Scheduled

StatusCode

Property	Value
Description	Reason for the status of the activity.
DisplayName	Status Reason
IsValidForForm	False
IsValidForRead	True
LogicalName	statuscode
RequiredLevel	None
Type	Status
DefaultFormValue	-1
GlobalChoiceName	activitypointer_statuscode

StatusCode Choices/Options

Value	Details
1	Label: Open State:0 TransitionData: None
2	Label: Completed State:1 TransitionData: None
3	Label: Canceled State:2 TransitionData: None
4	Label: Scheduled State:3 TransitionData: None

Subject

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

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

TransactionCurrencyId

Property	Value
Description	Unique identifier of the currency associated with the activitypointer.
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
• allparties
• CreatedBy
• CreatedOn
• CreatedOnBehalfBy
• DeliveryLastAttemptedOn
• DescriptionBlobId
• DescriptionBlobId_Name
• ExchangeRate
• FormattedScheduledEnd
• FormattedScheduledStart
• InstanceTypeCode
• IsRegularActivity
• ModifiedBy
• ModifiedOn
• ModifiedOnBehalfBy
• OnHoldTime
• OwnerIdName
• OwnerIdYomiName
• OwningBusinessUnit
• OwningTeam
• OwningUser
• PostponeActivityProcessingUntil
• SenderMailboxId
• SentOn
• SeriesId
• SLAInvokedId
• VersionNumber

ActivityTypeCode

Property	Value
Description	Type of activity.
DisplayName	Activity Type
IsValidForForm	False
IsValidForRead	True
LogicalName	activitytypecode
RequiredLevel	SystemRequired
Type	EntityName

allparties

Property	Value
Description	All activity parties associated with this activity.
DisplayName	All Activity Parties
IsValidForForm	False
IsValidForRead	True
LogicalName	allparties
RequiredLevel	None
Type	PartyList
Targets	account, contact, queue, systemuser, team

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	Date Created
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

DeliveryLastAttemptedOn

Property	Value
Description	Date and time when the delivery of the activity was last attempted.
DisplayName	Date Delivery Last Attempted
IsValidForForm	True
IsValidForRead	True
LogicalName	deliverylastattemptedon
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

DescriptionBlobId

Property	Value
Description	File that contains description content.
DisplayName	Description File Id
IsValidForForm	False
IsValidForRead	True
LogicalName	descriptionblobid
RequiredLevel	None
Type	File
MaxSizeInKB	128000

DescriptionBlobId_Name

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	descriptionblobid_name
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Disabled
IsLocalizable	False
MaxLength	200

ExchangeRate

Property	Value
Description	Exchange rate for the currency associated with the activitypointer with respect to the base 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

FormattedScheduledEnd

Property	Value
Description	Formatted scheduled end time of the activity.
DisplayName	Formatted End Date
IsValidForForm	True
IsValidForRead	True
LogicalName	formattedscheduledend
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	True
DateTimeBehavior	TimeZoneIndependent
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

FormattedScheduledStart

Property	Value
Description	Formatted scheduled start time of the activity.
DisplayName	Formatted Start Date
IsValidForForm	True
IsValidForRead	True
LogicalName	formattedscheduledstart
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	True
DateTimeBehavior	TimeZoneIndependent
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

InstanceTypeCode

Property	Value
Description	Type of instance of a recurring series.
DisplayName	Recurring Instance Type
IsValidForForm	False
IsValidForRead	True
LogicalName	instancetypecode
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	0
GlobalChoiceName	activitypointer_instancetypecode

InstanceTypeCode Choices/Options

Value	Label
0	Not Recurring
1	Recurring Master
2	Recurring Instance
3	Recurring Exception
4	Recurring Future Exception

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	Unique identifier of user who last modified the activity.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedby
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Date and time when activity was last modified.
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	Unique identifier of the delegate user who last modified the activitypointer.
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 that owns the activity.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	owninguser
RequiredLevel	None
Type	Lookup
Targets	systemuser

PostponeActivityProcessingUntil

Property	Value
Description	For internal use only.
DisplayName	Delay activity processing until
IsValidForForm	False
IsValidForRead	True
LogicalName	postponeactivityprocessinguntil
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

SenderMailboxId

Property	Value
Description	Unique identifier of the mailbox associated with the sender of the email message.
DisplayName	Sender's Mailbox
IsValidForForm	False
IsValidForRead	True
LogicalName	sendermailboxid
RequiredLevel	None
Type	Lookup
Targets	mailbox

SentOn

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

SeriesId

Property	Value
Description	Uniqueidentifier specifying the id of recurring series of an instance.
DisplayName	Series Id
IsValidForForm	False
IsValidForRead	True
LogicalName	seriesid
RequiredLevel	None
Type	Uniqueidentifier

SLAInvokedId

Property	Value
Description	Last SLA that was applied to this case. 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 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_ActivityPointers
• activitypointer_sendermailboxid_mailbox
• adx_invitation_ActivityPointers
• business_unit_activitypointer
• Contact_ActivityPointers
• FileAttachment_ActivityPointer_DescriptionBlobId
• interactionforemail_ActivityPointers
• KnowledgeArticle_ActivityPointers
• KnowledgeBaseRecord_ActivityPointers
• lk_activitypointer_createdby
• lk_activitypointer_createdonbehalfby
• lk_activitypointer_modifiedby
• lk_activitypointer_modifiedonbehalfby
• manualsla_activitypointer
• mspp_adplacement_ActivityPointers
• mspp_pollplacement_ActivityPointers
• mspp_publishingstatetransitionrule_ActivityPointers
• mspp_redirect_ActivityPointers
• mspp_shortcut_ActivityPointers
• mspp_website_ActivityPointers
• owner_activitypointers
• sla_activitypointer
• team_activity
• TransactionCurrency_ActivityPointer
• user_activity

Account_ActivityPointers

One-To-Many Relationship: account Account_ActivityPointers

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

activitypointer_sendermailboxid_mailbox

One-To-Many Relationship: mailbox activitypointer_sendermailboxid_mailbox

Property	Value
ReferencedEntity	mailbox
ReferencedAttribute	mailboxid
ReferencingAttribute	sendermailboxid
ReferencingEntityNavigationPropertyName	sendermailboxid
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

adx_invitation_ActivityPointers

One-To-Many Relationship: adx_invitation adx_invitation_ActivityPointers

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

business_unit_activitypointer

One-To-Many Relationship: businessunit business_unit_activitypointer

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

Contact_ActivityPointers

One-To-Many Relationship: contact Contact_ActivityPointers

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

FileAttachment_ActivityPointer_DescriptionBlobId

One-To-Many Relationship: fileattachment FileAttachment_ActivityPointer_DescriptionBlobId

Property	Value
ReferencedEntity	fileattachment
ReferencedAttribute	fileattachmentid
ReferencingAttribute	descriptionblobid
ReferencingEntityNavigationPropertyName	descriptionblobid
IsHierarchical
CascadeConfiguration	Archive: RemoveLink Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

interactionforemail_ActivityPointers

One-To-Many Relationship: interactionforemail interactionforemail_ActivityPointers

Property	Value
ReferencedEntity	interactionforemail
ReferencedAttribute	interactionforemailid
ReferencingAttribute	regardingobjectid
ReferencingEntityNavigationPropertyName	regardingobjectid_new_interactionforemail
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

KnowledgeArticle_ActivityPointers

One-To-Many Relationship: knowledgearticle KnowledgeArticle_ActivityPointers

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

KnowledgeBaseRecord_ActivityPointers

One-To-Many Relationship: knowledgebaserecord KnowledgeBaseRecord_ActivityPointers

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

lk_activitypointer_createdby

One-To-Many Relationship: systemuser lk_activitypointer_createdby

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

lk_activitypointer_createdonbehalfby

One-To-Many Relationship: systemuser lk_activitypointer_createdonbehalfby

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

lk_activitypointer_modifiedby

One-To-Many Relationship: systemuser lk_activitypointer_modifiedby

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

lk_activitypointer_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_activitypointer_modifiedonbehalfby

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

manualsla_activitypointer

One-To-Many Relationship: sla manualsla_activitypointer

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

mspp_adplacement_ActivityPointers

One-To-Many Relationship: mspp_adplacement mspp_adplacement_ActivityPointers

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

mspp_pollplacement_ActivityPointers

One-To-Many Relationship: mspp_pollplacement mspp_pollplacement_ActivityPointers

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

mspp_publishingstatetransitionrule_ActivityPointers

One-To-Many Relationship: mspp_publishingstatetransitionrule mspp_publishingstatetransitionrule_ActivityPointers

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

mspp_redirect_ActivityPointers

One-To-Many Relationship: mspp_redirect mspp_redirect_ActivityPointers

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

mspp_shortcut_ActivityPointers

One-To-Many Relationship: mspp_shortcut mspp_shortcut_ActivityPointers

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

mspp_website_ActivityPointers

One-To-Many Relationship: mspp_website mspp_website_ActivityPointers

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

owner_activitypointers

One-To-Many Relationship: owner owner_activitypointers

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

sla_activitypointer

One-To-Many Relationship: sla sla_activitypointer

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

team_activity

One-To-Many Relationship: team team_activity

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

TransactionCurrency_ActivityPointer

One-To-Many Relationship: transactioncurrency TransactionCurrency_ActivityPointer

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

user_activity

One-To-Many Relationship: systemuser user_activity

Property	Value
ReferencedEntity	systemuser
ReferencedAttribute	systemuserid
ReferencingAttribute	owninguser
ReferencingEntityNavigationPropertyName	owninguser
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.

• activity_pointer_activity_mime_attachment
• activity_pointer_adx_inviteredemption
• activity_pointer_adx_portalcomment
• activity_pointer_appointment
• activity_pointer_chat
• activity_pointer_email
• activity_pointer_fax
• activity_pointer_letter
• activity_pointer_phonecall
• activity_pointer_recurrencerule
• activity_pointer_recurringappointmentmaster
• activity_pointer_socialactivity
• activity_pointer_task
• activitypointer_activity_parties
• ActivityPointer_AsyncOperations
• ActivityPointer_BulkDeleteFailures
• activitypointer_connections1
• activitypointer_connections2
• activitypointer_FileAttachments
• ActivityPointer_QueueItem
• slakpiinstance_activitypointer

activity_pointer_activity_mime_attachment

Many-To-One Relationship: activitymimeattachment activity_pointer_activity_mime_attachment

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

activity_pointer_adx_inviteredemption

Many-To-One Relationship: adx_inviteredemption activity_pointer_adx_inviteredemption

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

activity_pointer_adx_portalcomment

Many-To-One Relationship: adx_portalcomment activity_pointer_adx_portalcomment

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

activity_pointer_appointment

Many-To-One Relationship: appointment activity_pointer_appointment

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

activity_pointer_chat

Many-To-One Relationship: chat activity_pointer_chat

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

activity_pointer_email

Many-To-One Relationship: email activity_pointer_email

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

activity_pointer_fax

Many-To-One Relationship: fax activity_pointer_fax

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

activity_pointer_letter

Many-To-One Relationship: letter activity_pointer_letter

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

activity_pointer_phonecall

Many-To-One Relationship: phonecall activity_pointer_phonecall

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

activity_pointer_recurrencerule

Many-To-One Relationship: recurrencerule activity_pointer_recurrencerule

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

activity_pointer_recurringappointmentmaster

Many-To-One Relationship: recurringappointmentmaster activity_pointer_recurringappointmentmaster

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

activity_pointer_socialactivity

Many-To-One Relationship: socialactivity activity_pointer_socialactivity

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

activity_pointer_task

Many-To-One Relationship: task activity_pointer_task

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

activitypointer_activity_parties

Many-To-One Relationship: activityparty activitypointer_activity_parties

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

ActivityPointer_AsyncOperations

Many-To-One Relationship: asyncoperation ActivityPointer_AsyncOperations

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

ActivityPointer_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure ActivityPointer_BulkDeleteFailures

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

activitypointer_connections1

Many-To-One Relationship: connection activitypointer_connections1

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

activitypointer_connections2

Many-To-One Relationship: connection activitypointer_connections2

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

activitypointer_FileAttachments

Many-To-One Relationship: fileattachment activitypointer_FileAttachments

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

ActivityPointer_QueueItem

Many-To-One Relationship: queueitem ActivityPointer_QueueItem

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

slakpiinstance_activitypointer

Many-To-One Relationship: slakpiinstance slakpiinstance_activitypointer

Property	Value
ReferencingEntity	slakpiinstance
ReferencingAttribute	regarding
ReferencedEntityNavigationPropertyName	slakpiinstance_activitypointer
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
activitypointer