Please enable JavaScript to view this site.

Navigation: Schema: Invoices > Tables

Invoices

Catalog: Autotask

Schema: Invoices

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

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

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

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

Field Selection Method: NotRequired

Base Path: items[*]

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

Table Columns

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

Name

Data Type

Label

Required

Documentation

batchID

int32

Batch ID

 

comments

string

Comments

 

companyID

int32

Company ID

 

createDateTime

datetime

Created

 

creatorResourceID

int32

Creator Resource ID

 

dueDate

datetime

Due Date

 

fromDate

datetime

From Date

 

id

int64

ID

 

invoiceDateTime

datetime

Invoice Date/Time

 

invoiceEditorTemplateID

int32

Invoice Editor Template ID

 

invoiceNumber

string

Invoice Number

 

invoiceTotal

double

Invoice Total

 

isVoided

boolean

Is Voided

 

orderNumber

string

Order Number

 

paidDate

datetime

Paid Date

 

paymentTerm

int32

Payment Term

 

taxGroup

int32

Tax Group

 

taxRegionName

string

Tax Region Name

 

toDate

datetime

To Date

 

totalTaxValue

double

Total Tax Value

 

voidedByResourceID

int32

Voided by Resource ID

 

voidedDate

datetime

Voided Date

 

webServiceDate

datetime

Webservice Date

 

 

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