EstimateLineItems
Get the details of line items for estimates.
Table Specific Information
Select
The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
Note: EstimateId is required in order to query EstimateLineItems.
- EstimateId supports the '=' comparison.
SELECT * FROM EstimateLineItems WHERE EstimateId = '1894553000000077244'
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. |