Task table/entity reference (Microsoft Dataverse)

2025-08-28

Generic activity representing work needed to be done.

Messages

The following table lists the messages for the Task 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` /tasks(activityid) Update the `ownerid` property.	AssignRequest
`Associate` Event: True	Associate records	Associate records
`Create` Event: True	`POST` /tasks See Create	Create records
`CreateMultiple` Event: True	CreateMultiple	CreateMultipleRequest
`Delete` Event: True	`DELETE` /tasks(activityid) See Delete	Delete records
`Disassociate` Event: True	Disassociate records	Disassociate records
`GrantAccess` Event: True	GrantAccess	GrantAccessRequest
`ModifyAccess` Event: True	ModifyAccess	ModifyAccessRequest
`Retrieve` Event: True	`GET` /tasks(activityid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: True	`GET` /tasks See Query data	Query data
`RetrievePrincipalAccess` Event: True	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
`RetrieveSharedPrincipalsAndAccess` Event: True	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
`RevokeAccess` Event: True	RevokeAccess	RevokeAccessRequest
`SetState` Event: True	`PATCH` /tasks(activityid) Update the `statecode` and `statuscode` properties.	SetStateRequest
`Update` Event: True	`PATCH` /tasks(activityid) See Update	Update records
`UpdateMultiple` Event: True	UpdateMultiple	UpdateMultipleRequest
`Upsert` Event: False	`PATCH` /tasks(activityid) See Upsert a table row	UpsertRequest
`UpsertMultiple` Event: False	UpsertMultiple	UpsertMultipleRequest

Properties

The following table lists selected properties for the Task table.

Property	Value
DisplayName	Task
DisplayCollectionName	Tasks
SchemaName	`Task`
CollectionSchemaName	`Tasks`
EntitySetName	`tasks`
LogicalName	`task`
LogicalCollectionName	`tasks`
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
Category
CrmTaskAssignedUniqueId
Description
ImportSequenceNumber
IsBilled
IsWorkflowCreated
LastOnHoldTime
OverriddenCreatedOn
OwnerId
OwnerIdType
PercentComplete
PriorityCode
ProcessId
RegardingObjectId
RegardingObjectTypeCode
ScheduledEnd
ScheduledStart
SLAId
SortDate
StageId
StateCode
StatusCode
Subcategory
Subject
SubscriptionId
TimeZoneRuleVersionNumber
TransactionCurrencyId
TraversedPath
UTCConversionTimeZoneCode

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 task.
DisplayName	Task
IsValidForForm	False
IsValidForRead	True
LogicalName	`activityid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ActualDurationMinutes

Property	Value
Description	Type the number of minutes spent on the task. The duration is used in reporting.
DisplayName	Duration
IsValidForForm	True
IsValidForRead	True
LogicalName	`actualdurationminutes`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

ActualEnd

Property	Value
Description	Enter the actual end date and time of the task. By default, it displays when the activity was completed or canceled.
DisplayName	Actual End
IsValidForForm	True
IsValidForRead	True
LogicalName	`actualend`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

ActualStart

Property	Value
Description	Enter the actual start date and time for the task. By default, it displays when the task was created.
DisplayName	Actual Start
IsValidForForm	True
IsValidForRead	True
LogicalName	`actualstart`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

Property	Value
Description	Type a category to identify the task type, such as lead gathering or customer follow up, to tie the task to a business group or function.
DisplayName	Category
IsValidForForm	True
IsValidForRead	True
LogicalName	`category`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

CrmTaskAssignedUniqueId

Property	Value
Description	Assigned Task Unique Id
DisplayName	Assigned Task Unique Id
IsValidForForm	False
IsValidForRead	True
LogicalName	`crmtaskassigneduniqueid`
RequiredLevel	None
Type	Uniqueidentifier

Description

Property	Value
Description	Type additional information to describe the task.
DisplayName	Description
IsValidForForm	True
IsValidForRead	True
LogicalName	`description`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

ImportSequenceNumber

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

IsBilled

Property	Value
Description	Information which specifies whether the task was billed as part of resolving a case.
DisplayName	Is Billed
IsValidForForm	False
IsValidForRead	True
LogicalName	`isbilled`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`task_isbilled`
DefaultValue	False
True Label	Yes
False Label	No

IsWorkflowCreated

Property	Value
Description	Information which specifies if the task was created from a workflow rule.
DisplayName	Is Workflow Created
IsValidForForm	False
IsValidForRead	True
LogicalName	`isworkflowcreated`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`task_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	Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user.
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

PercentComplete

Property	Value
Description	Type the percentage complete value for the task to track tasks to completion.
DisplayName	Percent Complete
IsValidForForm	True
IsValidForRead	True
LogicalName	`percentcomplete`
RequiredLevel	None
Type	Integer
MaxValue	100
MinValue	0

PriorityCode

Property	Value
Description	Select 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	`task_prioritycode`

PriorityCode Choices/Options

Value	Label
0	Low
1	Normal
2	High

ProcessId

Property	Value
Description	Shows the ID of the process.
DisplayName	Process
IsValidForForm	False
IsValidForRead	True
LogicalName	`processid`
RequiredLevel	None
Type	Uniqueidentifier

RegardingObjectId

Property	Value
Description	Choose the record that the task relates to.
DisplayName	Regarding
IsValidForForm	True
IsValidForRead	True
LogicalName	`regardingobjectid`
RequiredLevel	None
Type	Lookup
Targets	account, adx_invitation, 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

ScheduledEnd

Property	Value
Description	Enter the expected due date and time.
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	Enter the expected due date and time.
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 Task 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	Shows the ID of the stage.
DisplayName	(Deprecated) Process Stage
IsValidForForm	False
IsValidForRead	True
LogicalName	`stageid`
RequiredLevel	None
Type	Uniqueidentifier

StateCode

Property	Value
Description	Shows whether the task is open, completed, or canceled. Completed and canceled tasks are read-only and can't be edited.
DisplayName	Activity Status
IsValidForForm	True
IsValidForRead	True
LogicalName	`statecode`
RequiredLevel	SystemRequired
Type	State
DefaultFormValue	0
GlobalChoiceName	`task_statecode`

StateCode Choices/Options

Value	Details
0	Label: Open DefaultStatus: 2 InvariantName: `Open`
1	Label: Completed DefaultStatus: 5 InvariantName: `Completed`
2	Label: Canceled DefaultStatus: 6 InvariantName: `Canceled`

StatusCode

Property	Value
Description	Select the task's status.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	`statuscode`
RequiredLevel	None
Type	Status
DefaultFormValue	-1
GlobalChoiceName	`task_statuscode`

StatusCode Choices/Options

Value	Details
2	Label: Not Started State:0 TransitionData: None
3	Label: In Progress State:0 TransitionData: None
4	Label: Waiting on someone else State:0 TransitionData: None
5	Label: Completed State:1 TransitionData: None
6	Label: Canceled State:2 TransitionData: None
7	Label: Deferred State:0 TransitionData: None

Subcategory

Property	Value
Description	Type a subcategory to identify the task type and relate the activity to a specific product, sales region, business group, or other function.
DisplayName	Sub-Category
IsValidForForm	True
IsValidForRead	True
LogicalName	`subcategory`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

Subject

Property	Value
Description	Type a short description about the objective or primary topic of the task.
DisplayName	Subject
IsValidForForm	True
IsValidForRead	True
LogicalName	`subject`
RequiredLevel	ApplicationRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

SubscriptionId

Property	Value
Description	For internal use only.
DisplayName	Subscription
IsValidForForm	False
IsValidForRead	False
LogicalName	`subscriptionid`
RequiredLevel	None
Type	Uniqueidentifier

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	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
CreatedBy
CreatedOn
CreatedOnBehalfBy
ExchangeRate
IsRegularActivity
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OnHoldTime
OwnerIdName
OwnerIdYomiName
OwningBusinessUnit
OwningTeam
OwningUser
ScheduledDurationMinutes
SLAInvokedId
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	Shows who created the record.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName	Created On
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

CreatedOnBehalfBy

Property	Value
Description	Shows who created the record on behalf of another user.
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	False
True Label	Yes
False Label	No

ModifiedBy

Property	Value
Description	Shows who last updated the record.
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	Modified On
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Shows who last updated the record on behalf of another user.
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	Shows the record owner's business unit.
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 task.
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 task.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	`owninguser`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ScheduledDurationMinutes

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

SLAInvokedId

Property	Value
Description	Last SLA that was applied to this Task. 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 task.
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_Tasks
activity_pointer_task
adx_invitation_Tasks
business_unit_task_activities
Contact_Tasks
KnowledgeArticle_Tasks
KnowledgeBaseRecord_Tasks
lk_task_createdby
lk_task_createdonbehalfby
lk_task_modifiedby
lk_task_modifiedonbehalfby
manualsla_task
mspp_adplacement_Tasks
mspp_pollplacement_Tasks
mspp_publishingstatetransitionrule_Tasks
mspp_redirect_Tasks
mspp_shortcut_Tasks
mspp_website_Tasks
owner_tasks
processstage_tasks
sla_task
team_task
TransactionCurrency_Task
user_task

Account_Tasks

One-To-Many Relationship: account Account_Tasks

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

activity_pointer_task

One-To-Many Relationship: activitypointer activity_pointer_task

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_Tasks

One-To-Many Relationship: adx_invitation adx_invitation_Tasks

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

business_unit_task_activities

One-To-Many Relationship: businessunit business_unit_task_activities

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

Contact_Tasks

One-To-Many Relationship: contact Contact_Tasks

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

KnowledgeArticle_Tasks

One-To-Many Relationship: knowledgearticle KnowledgeArticle_Tasks

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

KnowledgeBaseRecord_Tasks

One-To-Many Relationship: knowledgebaserecord KnowledgeBaseRecord_Tasks

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

lk_task_createdby

One-To-Many Relationship: systemuser lk_task_createdby

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

lk_task_createdonbehalfby

One-To-Many Relationship: systemuser lk_task_createdonbehalfby

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

lk_task_modifiedby

One-To-Many Relationship: systemuser lk_task_modifiedby

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

lk_task_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_task_modifiedonbehalfby

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

manualsla_task

One-To-Many Relationship: sla manualsla_task

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

mspp_adplacement_Tasks

One-To-Many Relationship: mspp_adplacement mspp_adplacement_Tasks

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

mspp_pollplacement_Tasks

One-To-Many Relationship: mspp_pollplacement mspp_pollplacement_Tasks

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

mspp_publishingstatetransitionrule_Tasks

One-To-Many Relationship: mspp_publishingstatetransitionrule mspp_publishingstatetransitionrule_Tasks

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

mspp_redirect_Tasks

One-To-Many Relationship: mspp_redirect mspp_redirect_Tasks

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

mspp_shortcut_Tasks

One-To-Many Relationship: mspp_shortcut mspp_shortcut_Tasks

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

mspp_website_Tasks

One-To-Many Relationship: mspp_website mspp_website_Tasks

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

owner_tasks

One-To-Many Relationship: owner owner_tasks

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

processstage_tasks

One-To-Many Relationship: processstage processstage_tasks

Property	Value
ReferencedEntity	`processstage`
ReferencedAttribute	`processstageid`
ReferencingAttribute	`stageid`
ReferencingEntityNavigationPropertyName	`stageid_processstage`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

sla_task

One-To-Many Relationship: sla sla_task

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

team_task

One-To-Many Relationship: team team_task

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

TransactionCurrency_Task

One-To-Many Relationship: transactioncurrency TransactionCurrency_Task

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

user_task

One-To-Many Relationship: systemuser user_task

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`owninguser`
ReferencingEntityNavigationPropertyName	`owninguser_task`
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_task
task_actioncard
task_activity_parties
Task_Annotation
Task_AsyncOperations
Task_BulkDeleteFailures
task_connections1
task_connections2
Task_DuplicateBaseRecord
Task_DuplicateMatchingRecord
task_PostFollows
task_PostRegardings
task_principalobjectattributeaccess
Task_ProcessSessions
Task_QueueItem
Task_SyncErrors

slakpiinstance_task

Many-To-One Relationship: slakpiinstance slakpiinstance_task

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

task_actioncard

Many-To-One Relationship: actioncard task_actioncard

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

task_activity_parties

Many-To-One Relationship: activityparty task_activity_parties

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

Task_Annotation

Many-To-One Relationship: annotation Task_Annotation

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

Task_AsyncOperations

Many-To-One Relationship: asyncoperation Task_AsyncOperations

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

Task_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure Task_BulkDeleteFailures

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

task_connections1

Many-To-One Relationship: connection task_connections1

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

task_connections2

Many-To-One Relationship: connection task_connections2

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

Task_DuplicateBaseRecord

Many-To-One Relationship: duplicaterecord Task_DuplicateBaseRecord

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

Task_DuplicateMatchingRecord

Many-To-One Relationship: duplicaterecord Task_DuplicateMatchingRecord

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

task_PostFollows

Many-To-One Relationship: postfollow task_PostFollows

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

task_PostRegardings

Many-To-One Relationship: postregarding task_PostRegardings

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

task_principalobjectattributeaccess

Many-To-One Relationship: principalobjectattributeaccess task_principalobjectattributeaccess

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

Task_ProcessSessions

Many-To-One Relationship: processsession Task_ProcessSessions

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

Task_QueueItem

Many-To-One Relationship: queueitem Task_QueueItem

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

Task_SyncErrors

Many-To-One Relationship: syncerror Task_SyncErrors

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

Feedback

Was this page helpful?