# 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 | ☐ | |