ADO.NET Provider for Sage Intacct

Build 26.0.9655

Task

Represents project tasks that define the work breakdown structure for a project, including planned and actual dates, duration tracking, billable settings, and associated resources.

Columns

Name Type ReadOnly Description
actualEndDate Date True

The actual end date of this task.

actualStartDate Date True

The actual start date of this task.

attachment_Href String True

The URL of the attachment associated with this task.

attachment_Id String False

The Id of the attachment associated with this task.

attachment_Key String False

The system-assigned key of the attachment associated with this task.

auditCreatedBy String True

The user who created the task.

auditCreatedDateTime Datetime True

The date and time when the task was created.

auditModifiedBy String True

The user who last modified the task.

auditModifiedDateTime Datetime True

The date and time when the task was last modified.

class_Href String True

The URL of the class associated with this task.

class_Id String False

The Id of the class associated with this task.

class_Key String False

The system-assigned key of the class associated with this task.

class_Name String True

The name of the class associated with this task.

customer_Href String True

The URL of the customer associated with this task.

customer_Id String True

The Id of the customer associated with this task.

customer_Key String True

The system-assigned key of the customer associated with this task.

customer_Name String True

The name of the customer associated with this task.

dependentOn_Href String True

The URL of the task that this task depends on.

dependentOn_Id String True

The Id of the task that this task depends on.

dependentOn_Key String False

The system-assigned key of the task that this task depends on.

dependentOn_Name String True

The name of the task that this task depends on.

description String False

The description of this task.

durationActual Decimal True

The actual hours recorded against this task.

durationActualBillable Decimal True

The actual billable hours recorded against this task.

durationApproved Decimal True

The approved hours for this task.

durationApprovedBillable Decimal True

The approved billable hours for this task.

durationEstimated Decimal False

The estimated total hours for this task.

durationEstimatedBillable Decimal True

The estimated billable hours for this task.

durationPlanned Decimal False

The planned total hours for this task.

durationPlannedBillable Decimal True

The planned billable hours for this task.

durationRemaining Decimal True

The remaining hours to complete this task.

href String True

The URL of the task resource.

id String False

The unique identifier of the task record.

isBillable Bool False

Indicates whether this task is billable to a customer.

isMilestone Bool False

Indicates whether this task represents a project milestone.

isUtilized Bool False

Indicates whether this task is included in utilization calculations.

item_Href String True

The URL of the item associated with this task.

item_Id String False

The Id of the item associated with this task.

item_Key String False

The system-assigned key of the item associated with this task.

item_Name String True

The name of the item associated with this task.

key [KEY] String True

The system-assigned key that uniquely identifies the task record.

name String False

The name of the task.

observedPercentComplete String True

The observed percentage of completion for this task.

overridePurchasingTaxSchedule Bool False

Indicates whether the purchasing tax schedule is overridden for this task.

parent_Href String True

The URL of the parent task associated with this task.

parent_Id String True

The Id of the parent task associated with this task.

parent_Key String False

The system-assigned key of the parent task associated with this task.

parent_Name String True

The name of the parent task associated with this task.

percentComplete String True

The calculated percentage of completion for this task.

plannedEndDate Date False

The planned end date for this task.

plannedStartDate Date False

The planned start date for this task.

priority Decimal False

The priority level assigned to this task.

productionUnitsDescription String False

The description of the production unit associated with this task.

productionUnitsEstimate Decimal False

The estimated number of production units for this task.

project_EndDate Date True

The end date of the project associated with this task.

project_Href String True

The URL of the project associated with this task.

project_Id String False

The Id of the project associated with this task.

project_Key String False

The system-assigned key of the project associated with this task.

project_Name String True

The name of the project associated with this task.

project_StartDate Date True

The start date of the project associated with this task.

root_Href String True

The URL of the root task in the hierarchy for this task.

root_Id String True

The Id of the root task in the hierarchy for this task.

root_Key String True

The system-assigned key of the root task in the hierarchy for this task.

root_Name String True

The name of the root task in the hierarchy for this task.

standardTask_Href String True

The URL of the standard task template associated with this task.

standardTask_Id String False

The Id of the standard task template associated with this task.

standardTask_Key String False

The system-assigned key of the standard task template associated with this task.

standardTask_Name String True

The name of the standard task template associated with this task.

taskStatus String False

The current status of this task, such as not started, in progress, or completed.

taxSchedule_Href String True

The URL of the tax schedule associated with this task.

taxSchedule_Id String False

The Id of the tax schedule associated with this task.

taxSchedule_Key String False

The system-assigned key of the tax schedule associated with this task.

taxSolution_Href String True

The URL of the tax solution associated with this task.

taxSolution_Id String True

The Id of the tax solution associated with this task.

taxSolution_Key String True

The system-assigned key of the tax solution associated with this task.

timeType_Href String True

The URL of the time type associated with this task.

timeType_Id String False

The Id of the time type associated with this task.

timeType_Key String False

The system-assigned key of the time type associated with this task.

wbsCode String False

The work breakdown structure (WBS) code assigned to this task.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655