RetainerInvoicesLineItems
List line items of retainer invoice.
Table Specific Information
Select
The add-in 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 add-in.
- 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 |