Companies: Autotask itgen_autotask_companies_plural
read only REST
- Catalog:
Autotask - Schema:
Companies - Label: itgen_autotask_companies_plural
Can only retrieve data.
API Source
- Endpoint:
/V1.0/Companies/query - Operation:
get /V1.0/Companies/query
Table Columns
The columns of the table Companies 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 |
|---|---|---|---|---|---|
additional |
varchar2 |
Additional Address Information | |||
address1 |
varchar2 |
Address 1 | |||
address2 |
varchar2 |
Address 2 | |||
alternate |
varchar2 |
Alternate Phone 1 | |||
alternate |
varchar2 |
Alternate Phone 2 | |||
api |
int32 |
API Vendor ID | |||
asset |
double |
Asset Value | |||
billing |
varchar2 |
Billing Address 1 | |||
billing |
varchar2 |
Billing Address 2 | |||
bill |
varchar2 |
Bill-to Additional Address Information | |||
bill |
int32 |
Bill-to Address to Use | |||
bill |
varchar2 |
Bill-to Attention | |||
bill |
varchar2 |
Bill-to City | |||
bill |
int32 |
Bill-to Company Location ID | |||
bill |
int32 |
Bill-to Country ID | |||
bill |
varchar2 |
Bill-to State | |||
bill |
varchar2 |
Bill-to ZIP Code | |||
city |
varchar2 |
City | |||
classification |
int32 |
Classification | |||
company |
int32 |
Company Category ID | |||
company |
varchar2 |
Company Name | |||
company |
varchar2 |
Company Number | |||
company |
int32 |
Company Type | |||
competitor |
int32 |
Competitor ID | |||
country |
int32 |
Country ID | |||
create |
datetime |
Created | |||
created |
int32 |
Created by Resource ID | |||
currency |
int32 |
Currency ID | |||
fax |
varchar2 |
Fax | |||
id |
int64 |
ID | |||
impersonator |
int32 |
Imperonsator Creator Resource ID | |||
invoice |
int32 |
Invoice Email Message ID | |||
invoice |
int32 |
Invoice Method | |||
invoice |
char |
Invoice Non-contract Items to Parent Company | |||
invoice |
int32 |
Invoice Template ID | |||
is |
char |
Is Active | |||
is |
char |
Is Client Portal Active | |||
is |
char |
Is Enabled for Co-managed | |||
is |
char |
Is Sample | |||
is |
char |
Is Task Fire Active | |||
is |
char |
Is Tax Exempt | |||
last |
datetime |
Last Activity Date | |||
last |
datetime |
Last Tracked Modified Date/Time | |||
market |
int32 |
Market Segment ID | |||
owner |
int32 |
Owner Resource ID | |||
parent |
int32 |
Parent Company ID | |||
phone |
varchar2 |
Phone | |||
postal |
varchar2 |
Postal Code | |||
purchase |
int32 |
Purchase Order Template ID | |||
quote |
int32 |
Quote Email Message ID | |||
quote |
int32 |
Quote Template ID | |||
sic |
varchar2 |
SIC Code | |||
state |
varchar2 |
State | |||
stock |
varchar2 |
Stock Market | |||
stock |
varchar2 |
Stock Symbol | |||
survey |
double |
Survey Company Rating | |||
taxID |
varchar2 |
Tax ID | |||
tax |
int32 |
Tax Region ID | |||
territory |
int32 |
Territory ID | |||
web |
varchar2 |
Web Address |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: