EstimateLineItems
Get the details of line items for estimates.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- EstimateId supports the '=' and IN operators.
NOTE: EstimateId is required to query EstimateLineItems.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM EstimateLineItems WHERE EstimateId = '1894553000000077244'
SELECT * FROM EstimateLineItems WHERE EstimateId IN (SELECT EstimateId FROM Estimates)
SELECT * FROM EstimateLineItems WHERE EstimateId IN ('1894553000000077244','1894553000000077245')
Columns
| Name | Type | References | SupportedOperators | Description |
| LineItemId [KEY] | String | Id of the line item. | ||
| EstimateId | String |
Estimates.EstimateId | Id of an estimate. | |
| BcyRate | Decimal | Rate of base currency. | ||
| CustomFields | String | Custom Fields defined for the line item | ||
| Description | String | Description of the estimate line items. | ||
| Discount | String | Discount given to specific item in estimate. | ||
| DiscountAmount | Decimal | Amount of discount given to estimate. | ||
| HeaderId | String | Id of the header. | ||
| HeaderName | String | Name of the header. | ||
| ItemId | String |
Items.ItemId | Id of the item. | |
| ItemOrder | Integer | Order of the item. | ||
| ItemTotal | Decimal | Total number of items. | ||
| Name | String | Name of the line item. | ||
| PricebookId | String | Id of a pricebook. | ||
| Quantity | Decimal | Quantity of the line item. | ||
| Rate | Decimal | Rate of the line item. | ||
| Tags | String | Details of tags related to estimates. | ||
| TaxId | String |
Taxes.TaxId | Id of tax. | |
| TaxName | String | Name of the tax. | ||
| TaxPercentage | Integer | Percentage applied for tax. | ||
| TaxType | String | Type of tax. | ||
| Unit | String | Number of quantity. | ||
| SKU | String | The SKU of the Line Item. | ||
| Discounts | String | Discounts applied to the line item. | ||
| Documents | String | Documents associated with the line item. | ||
| ImageDocumentId | String | ID of the image document for the line item. | ||
| InternalName | String | Internal name of the line item. | ||
| LineItemTaxes | String | Taxes applied to the line item. | ||
| PricingScheme | String | Pricing scheme of the line item. | ||
| TdsTaxAmount | Decimal | TDS tax amount for the line item. | ||
| TdsTaxId | String | ID of the TDS tax for the line item. | ||
| TdsTaxName | String | Name of the TDS tax for the line item. | ||
| TdsTaxPercentage | Decimal | Percentage of the TDS tax for the line item. | ||
| TdsTaxType | String | Type of the TDS tax for the line item. |