RetainerInvoicesLineItems
List line items of retainer invoice.
Table Specific Information
Select
The connector will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the connector.
- RetainerInvoiceId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM RetainerInvoiceLineItems WHERE RetainerInvoiceId = '3350895000000089001'
Columns
| Name | Type | References | Description |
| RetainerInvoiceId | Long | RetainerInvoice Id. | |
| BcyRate | Integer | base currency rate | |
| Description | String | The description of the line items. | |
| ItemOrder | Integer | The order of the line item_order | |
| ItemTotal | Integer | The total amount of the line items | |
| LineItemId [KEY] | Long | The line item id | |
| Rate | Integer | Rate of the line item. | |
| TaxId | Long | ID of the tax or tax group applied to the estimate | |
| TaxName | String | The name of the tax | |
| TaxPercentage | Double | The percentage of tax levied | |
| TaxType | String | The type of the tax |