Please enable JavaScript to view this site.

Navigation: Schema: Tasks > Tables

Tasks_ItemsUserDefinedFields

Catalog: Autotask

Schema: Tasks

This is a read-only table. The Autotask API may not support changing the data or the Invantive SQL driver for Autotask does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Autotask API.

Select Autotask API URL: /V1.0/Tasks/query

Insert Autotask API URL: /V1.0/Tasks/query

Update Autotask API URL: /V1.0/Tasks/query

Delete Autotask API URL: /V1.0/Tasks/query

Field Selection Method: NotRequired

Base Path: items[*].userDefinedFields[*]

Select Autotask API Operation: get /V1.0/Tasks/query

Table Columns

The columns of the Table Tasks_ItemsUserDefinedFields are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

assignedResourceID

int32

Assigned Resource ID

 

assignedResourceRoleID

int32

Assigned Resource Role ID

 

billingCodeID

int32

Billing Code ID

 

canClientPortalUserCompleteTask

boolean

Can Client Portal User Complete Task

 

companyLocationID

int32

Company Location ID

 

completedByResourceID

int32

Completed by Resource ID

 

completedByType

int32

Completed by Type

 

completedDateTime

datetime

Completed

 

createDateTime

datetime

Created

 

creatorResourceID

int32

Creator Resource ID

 

creatorType

int32

Creator Type

 

departmentID

int32

Department ID

 

description

string

Description

 

endDateTime

datetime

End Date/Time

 

estimatedHours

double

Estimated Hours

 

externalID

string

External ID

 

hoursToBeScheduled

double

Hours to be Scheduled

 

id

int64

ID

 

isTaskBillable

boolean

Is Task Billable

 

isVisibleInClientPortal

boolean

Is Visible in Client Portal

 

lastActivityDateTime

datetime

Last Activity Date/Time

 

lastActivityPersonType

int32

Last Acitvity Person Type

 

lastActivityResourceID

int32

Last Activity Resource ID

 

name

string

Name

 

phaseID

int32

Phase ID

 

priority

int32

Priority

 

priorityLabel

int32

Priority Label

 

projectID

int32

Project ID

 

purchaseOrderNumber

string

Purchase Order Number

 

remainingHours

double

Remaining Hours

 

soapParentPropertyId_body_canReduce

boolean

 

 

soapParentPropertyId_body_nodeType

string

 

 

soapParentPropertyId_body_type

string

 

 

soapParentPropertyId_canReduce

boolean

 

 

soapParentPropertyId_name

string

 

 

soapParentPropertyId_nodeType

string

 

 

soapParentPropertyId_returnType

string

 

 

soapParentPropertyId_tailCall

boolean

 

 

soapParentPropertyId_type

string

 

 

startDateTime

datetime

Start Date/Time

 

status

int32

Status

 

taskCategoryID

int32

Task Category ID

 

taskNumber

string

Task Number

 

taskType

int32

Task Type

 

title

string

Title

 

value

string

Value

 

 

22-09-2022 21:52 Version 22.0.355-PROD+3587