RetainerInvoiceLineItems
Retrieves detail of line items of retainer invoices.
Table Specific Information
Select
The add-in uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- RetainerInvoiceId supports the '=' and IN operators.
NOTE: RetainerInvoiceId is required to query RetainerInvoiceLineItems.
The rest of the filter is executed client-side in the add-in.
For example:
SELECT * FROM RetainerInvoiceLineItems WHERE RetainerInvoiceId = '1894663000000085023'
SELECT * FROM RetainerInvoiceLineItems WHERE RetainerInvoiceId IN (SELECT RetainerInvoiceId FROM RetainerInvoices)
SELECT * FROM RetainerInvoiceLineItems WHERE RetainerInvoiceId IN ('1894663000000085023','1894663000000085024')
Columns
| Name | Type | References | SupportedOperators | Description |
| RetainerInvoiceId | String |
RetainerInvoices.RetainerInvoiceId | Id of a retainer invoice. | |
| LineItemId [KEY] | String | Id of line item. | ||
| AccountId | String |
BankAccounts.AccountId | Id of the Bank Account. | |
| BcyRate | Decimal | Rate of Base Currency. | ||
| Description | String | Description of the retainer invoice line item. | ||
| ItemOrder | Integer | Order of items. | ||
| ItemTotal | Decimal | Total number of items in retainer invoice. | ||
| Rate | Decimal | Rate of the line item. | ||
| TaxId | String |
Taxes.TaxId | Id of tax. | |
| TaxName | String | Name of the tax. | ||
| TaxPercentage | Integer | Percentage applied for tax. | ||
| TaxType | String | Type of tax. | ||
| LineItemTaxes | String | Line Item tax for the invoice |