Please enable JavaScript to view this site.

Navigation: Schema: Contracts > Tables

Contracts

Catalog: Autotask

Schema: Contracts

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

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

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

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

Field Selection Method: NotRequired

Base Path: items[*]

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

Table Columns

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

Name

Data Type

Label

Required

Documentation

billingPreference

int32

Billing Preference

 

billToCompanyContactID

int32

Bill-to Company Contact ID

 

billToCompanyID

int32

Bill-to Company ID

 

companyID

int32

Company ID

 

contactID

int32

Contact ID

 

contactName

string

Contact Name

 

contractCategory

int32

Contract Category

 

contractExclusionSetID

int32

Contract Exclusion Set ID

 

contractName

string

Contract Name

 

contractNumber

string

Contract Number

 

contractPeriodType

int32

Contract Period Type

 

contractType

int32

Contract Type

 

description

string

Description

 

endDate

datetime

End Date

 

estimatedCost

double

Estimated Cost

 

estimatedHours

double

Estimated Hours

 

estimatedRevenue

double

Estimated Revenue

 

exclusionContractID

int64

Exclusion Contract ID

 

id

int64

ID

 

internalCurrencyOverageBillingRate

double

Internal Currency Overage Billing Rate

 

internalCurrencySetupFee

double

Internal Currency Setup Fee

 

isCompliant

boolean

Is Compliant

 

isDefaultContract

boolean

Is Default Contract

 

opportunityID

int32

Opportunity ID

 

organizationalLevelAssociationID

int32

Organizational Level Association ID

 

overageBillingRate

double

Overage Billing Rate

 

purchaseOrderNumber

string

Purchase Order Number

 

renewedContractID

int64

Renewed Contract ID

 

serviceLevelAgreementID

int32

Service Level Agreement ID

 

setupFee

double

Setup Fee

 

setupFeeBillingCodeID

int64

Setup Fee Billing Code ID

 

startDate

datetime

Start Date

 

status

int32

Status

 

timeReportingRequiresStartAndStopTimes

int32

Time Reporting Requires Start and Stop Times

 

 

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