Please enable JavaScript to view this site.

Navigation: Schema: Companies > Tables

Companies

Catalog: Autotask

Schema: Companies

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

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

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

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

Field Selection Method: NotRequired

Base Path: items[*]

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

Table Columns

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

Name

Data Type

Label

Required

Documentation

additionalAddressInformation

string

Additional Address Information

 

address1

string

Address 1

 

address2

string

Address 2

 

alternatePhone1

string

Alternate Phone 1

 

alternatePhone2

string

Alternate Phone 2

 

apiVendorID

int32

API Vendor ID

 

assetValue

double

Asset Value

 

billingAddress1

string

Billing Address 1

 

billingAddress2

string

Billing Address 2

 

billToAdditionalAddressInformation

string

Bill-to Additional Address Information

 

billToAddressToUse

int32

Bill-to Address to Use

 

billToAttention

string

Bill-to Attention

 

billToCity

string

Bill-to City

 

billToCompanyLocationID

int32

Bill-to Company Location ID

 

billToCountryID

int32

Bill-to Country ID

 

billToState

string

Bill-to State

 

billToZipCode

string

Bill-to ZIP Code

 

city

string

City

 

classification

int32

Classification

 

companyCategoryID

int32

Company Category ID

 

companyName

string

Company Name

 

companyNumber

string

Company Number

 

companyType

int32

Company Type

 

competitorID

int32

Competitor ID

 

countryID

int32

Country ID

 

createDate

datetime

Created

 

createdByResourceID

int32

Created by Resource ID

 

currencyID

int32

Currency ID

 

fax

string

Fax

 

id

int64

ID

 

impersonatorCreatorResourceID

int32

Imperonator Creator Resource ID

 

invoiceEmailMessageID

int32

Invoice Email Message ID

 

invoiceMethod

int32

Invoice Method

 

invoiceNonContractItemsToParentCompany

boolean

Invoice Non-contract Items to Parent Company

 

invoiceTemplateID

int32

Invoice Template ID

 

isActive

boolean

Is Active

 

isClientPortalActive

boolean

Is Client Portal Active

 

isEnabledForComanaged

boolean

Is Enabled for Co-managed

 

isSample

boolean

Is Sample

 

isTaskFireActive

boolean

Is Task Fire Active

 

isTaxExempt

boolean

Is Tax Exempt

 

lastActivityDate

datetime

Last Activity Date

 

lastTrackedModifiedDateTime

datetime

Last Tracked Modified Date/Time

 

marketSegmentID

int32

Market Segment ID

 

ownerResourceID

int32

Owner Resource ID

 

parentCompanyID

int32

Parent Company ID

 

phone

string

Phone

 

postalCode

string

Postal Code

 

purchaseOrderTemplateID

int32

Purchase Order Template ID

 

quoteEmailMessageID

int32

Quote Email Message ID

 

quoteTemplateID

int32

Quote Template ID

 

sicCode

string

SIC Code

 

state

string

State

 

stockMarket

string

Stock Market

 

stockSymbol

string

Stock Symbol

 

surveyCompanyRating

double

Survey Company Rating

 

taxID

string

Tax ID

 

taxRegionID

int32

Tax Region ID

 

territoryID

int32

Territory ID

 

webAddress

string

Web Address

 

 

21-06-2022 08:54 Version 22.1.46-BETA+3385