RetainerInvoiceLineItems
Retrieves detail of line items of retainer invoices.
Table Specific Information
Select
The connector 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 connector.
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. |