QuoteItems |
Catalog: Autotask
Schema: QuoteItems
This is a read-only table. The Autotask API may not support changing the data or the Invantive UniversalSQL driver for Autotask does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Autotask API.
Table Columns
The columns of the table QuoteItems are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
averageCost |
double |
Average Cost |
☐ |
|
chargeID |
int32 |
Charge ID |
☐ |
|
description |
string |
Description |
☐ |
|
expenseID |
int32 |
Expense ID |
☐ |
|
highestCost |
double |
Highest Cost |
☐ |
|
id |
int64 |
ID |
☐ |
|
internalCurrencyLineDiscount |
double |
Internal Currency Line Discount |
☐ |
|
internalCurrencyUnitDiscount |
double |
Internal Currency Unit Discount |
☐ |
|
internalCurrencyUnitPrice |
double |
Internal Currency Unit Price |
☐ |
|
isOptional |
boolean |
Is Optional |
☐ |
|
isTaxable |
boolean |
Is Taxable |
☐ |
|
laborID |
int32 |
Labor ID |
☐ |
|
lineDiscount |
double |
Line Discount |
☐ |
|
markupRate |
double |
Mark-up Rate |
☐ |
|
name |
string |
Name |
☐ |
|
percentageDiscount |
double |
Discount Percentage |
☐ |
|
periodType |
int32 |
Period Type |
☐ |
|
productID |
int32 |
Product ID |
☐ |
|
quantity |
double |
Quantity |
☐ |
|
quoteID |
int32 |
Quote ID |
☐ |
|
quoteItemType |
int32 |
Quote Item Type |
☐ |
|
serviceBundleID |
int32 |
Service Bundle ID |
☐ |
|
serviceID |
int32 |
Service ID |
☐ |
|
shippingID |
int32 |
Shipping ID |
☐ |
|
soapParentPropertyId_body_canReduce |
boolean |
|
☐ |
|
soapParentPropertyId_body_nodeType |
string |
|
☐ |
|
soapParentPropertyId_body_type |
string |
|
☐ |
|
soapParentPropertyId_canReduce |
boolean |
|
☐ |
|
soapParentPropertyId_name |
string |
|
☐ |
|
soapParentPropertyId_nodeType |
string |
|
☐ |
|
soapParentPropertyId_returnType |
string |
|
☐ |
|
soapParentPropertyId_tailCall |
boolean |
|
☐ |
|
soapParentPropertyId_type |
string |
|
☐ |
|
sortOrderID |
int32 |
Sort Order ID |
☐ |
|
taxCategoryID |
int32 |
Tax Category ID |
☐ |
|
totalEffectiveTax |
double |
Total Effective Tax |
☐ |
|
unitCost |
double |
Unit Cost |
☐ |
|
unitDiscount |
double |
Unit Discount |
☐ |
|
unitPrice |
double |
Unit Price |
☐ |
|
10-06-2024 18:39 Version 24.1.3-BETA+4689