BillingItems: Autotask itgen_autotask_billingitems_plural
read only REST
- Catalog:
Autotask - Schema:
BillingItems - Label: itgen_autotask_billingitems_plural
Can only retrieve data.
API Source
- Endpoint:
/V1.0/BillingItems/query - Operation:
get /V1.0/BillingItems/query
Table Columns
The columns of the table BillingItems 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 |
|---|---|---|---|---|---|
account |
int32 |
Account Manager When Approved ID | |||
billing |
int32 |
Billing Code ID | |||
billing |
int32 |
Billing Item Type | |||
company |
int32 |
Company ID | |||
configuration |
int64 |
Configuration Item ID | |||
contract |
int64 |
Contract Charge ID | |||
contract |
int32 |
Contract ID | |||
contract |
int32 |
Contract Service Adjustment ID | |||
contract |
int32 |
Contract Service Bundle Adjustment ID | |||
contract |
int32 |
Contract Service Bundle ID | |||
contract |
int32 |
Contract Service Bundle Period ID | |||
contract |
int32 |
Contract Service ID | |||
contract |
int32 |
Contract Service Period ID | |||
description |
varchar2 |
Description | |||
expense |
int32 |
Expense Item ID | |||
extended |
double |
Extended Price | |||
id |
int64 |
ID | |||
internal |
double |
Internal Currency Extended Price | |||
internal |
double |
Internal Currency Rate | |||
internal |
double |
Internal Currency Tax Dollars | |||
internal |
double |
Internal Currency Total Amount | |||
invoice |
int32 |
Invoice ID | |||
item |
int32 |
Item Approver ID | |||
item |
datetime |
Item Date | |||
item |
varchar2 |
Item Name | |||
line |
varchar2 |
Line Item Full Description | |||
line |
varchar2 |
Line Item Group Description | |||
milestone |
int64 |
Milestone ID | |||
non |
int32 |
Non-billable | |||
organizational |
int32 |
Organisational Level Association ID | |||
our |
double |
Our Cost | |||
posted |
datetime |
Posted | |||
posted |
datetime |
Posted on-time | |||
project |
int64 |
Project Charge ID | |||
project |
int32 |
Project ID | |||
purchase |
varchar2 |
Purchase Order Number | |||
quantity |
double |
Quantity | |||
rate |
double |
Rate | |||
roleID |
int32 |
Role ID | |||
service |
int64 |
Service Bundle ID | |||
service |
int64 |
Service ID | |||
sort |
int64 |
Sort Order ID | |||
sub |
int32 |
Sub-type | |||
taskID |
int32 |
Task ID | |||
tax |
double |
Tax Dollars | |||
ticket |
int64 |
Ticket Charge ID | |||
ticket |
int32 |
Ticket ID | |||
time |
int32 |
Time Entry ID | |||
total |
double |
Total Amount | |||
vendor |
int64 |
Vendor ID | |||
web |
datetime |
Webservice Date |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: