Task table/entity reference
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 |
Create Event: True |
POST /tasksSee Create |
Create records |
Delete Event: True |
DELETE /tasks(activityid)See Delete |
Delete 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 /tasksSee 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 |
Upsert Event: False |
PATCH /tasks(activityid)See Upsert a table row |
UpsertRequest |
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 |
Category
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 |
See also
Dataverse table/entity reference
Dataverse Web API Reference
task