Please enable JavaScript to view this site.

Navigation: » No topics above this level «

ChangeOrderCharges_ItemsUserDefinedFields

Catalog: Autotask

Schema: ChangeOrderCharges

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/ChangeOrderCharges/query

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

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

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

Field Selection Method: NotRequired

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

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

Table Columns

The columns of the table ChangeOrderCharges_ItemsUserDefinedFields are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

billableAmount

double

Billable Amount

 

billingCodeID

int32

Billing Code ID

 

changeOrderHours

double

Change Order Hours

 

chargeType

int32

Charge Type

 

contractServiceBundleID

int32

Contract Service Bundle ID

 

contractServiceID

int32

Contract Service ID

 

createDate

datetime

Created

 

creatorResourceID

int32

Creator Resource ID

 

datePurchased

datetime

Purchase Date

 

description

string

Description

 

extendedCost

double

Extended Cost

 

id

int64

ID

 

internalCurrencyBillableAmount

double

Internal Currency Billable Amount

 

internalCurrencyUnitPrice

double

Internal Currency Unit Price

 

internalPurchaseOrderNumber

string

Internal Purchase Order Number

 

isBillableToCompany

boolean

Is Billable to Company

 

isBilled

boolean

Is Billed

 

name_1

string

Name

 

name

string

Name

 

notes

string

Notes

 

organizationalLevelAssociationID

int32

Organizational Level Association ID

 

productID

int32

Product ID

 

purchaseOrderNumber

string

Purchase Order Number

 

status

int32

Status

 

statusLastModifiedBy

int32

Status Last Modified by

 

statusLastModifiedDate

datetime

Status Last Modified Date

 

taskID

int32

Task ID

 

unitCost

double

Unit Cost

 

unitPrice

double

Unit Price

 

unitQuantity

double

Unit Quantity

 

value

string

Value

 

 

19-03-2022 11:56 Version 22.0.85-PROD+3263