---
title: "Contracts (Autotask)"
description: "itgen_autotask_contracts_plural"
language: en
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/it/datamodels/autotask/Autotask.Contracts.Contracts
original: https://documentation.invantive.eu/en/datamodels/autotask/Autotask.Contracts.Contracts
updated: 2024-06-10T18:39:25Z
license: https://documentation.invantive.eu/it/
---

# Contracts: Autotask itgen_autotask_contracts_plural

`read only` `REST`

- Catalog: `Autotask`
- Schema: `Contracts`
- Label: itgen_autotask_contracts_plural

Can only retrieve data.

## API Source

- Endpoint: `/V1.0/Contracts/query`
- Operation: `get /V1.0/Contracts/query`

## Table Columns

The columns of the table `Contracts` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | 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` | `varchar2` | Contact Name | [ ] |  |  |
| `contractCategory` | `int32` | Contract Category | [ ] |  |  |
| `contractExclusionSetID` | `int32` | Contract Exclusion Set ID | [ ] |  |  |
| `contractName` | `varchar2` | Contract Name | [ ] |  |  |
| `contractNumber` | `varchar2` | Contract Number | [ ] |  |  |
| `contractPeriodType` | `int32` | Contract Period Type | [ ] |  |  |
| `contractType` | `int32` | Contract Type | [ ] |  |  |
| `description` | `varchar2` | 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` | `char` | Is Compliant | [ ] |  |  |
| `isDefaultContract` | `char` | Is Default Contract | [ ] |  |  |
| `opportunityID` | `int32` | Opportunity ID | [ ] |  |  |
| `organizationalLevelAssociationID` | `int32` | Organisational Level Association ID | [ ] |  |  |
| `overageBillingRate` | `double` | Overage Billing Rate | [ ] |  |  |
| `purchaseOrderNumber` | `varchar2` | 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 | [ ] |  |  |



## Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

- [Autotask](/it/release-notes/drivers?driver=autotask)
