RecurringInvoiceLineItems
Get the details of line items of a recurring invoice.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- RecurringInvoiceId supports the '=' and IN operators.
NOTE: RecurringInvoiceId is required to query RecurringInvoiceLineItems.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM RecurringInvoiceLineItems WHERE RecurringInvoiceId = '1895453000000042244'
SELECT * FROM RecurringInvoiceLineItems WHERE RecurringInvoiceId IN (SELECT RecurringInvoiceId FROM RecurringInvoices)
SELECT * FROM RecurringInvoiceLineItems WHERE RecurringInvoiceId IN ('1895453000000042244','1895453000000042245')
Columns
| Name | Type | References | SupportedOperators | Description |
| LineItemId [KEY] | String | Id of line item. | ||
| RecurringInvoiceId | String |
RecurringInvoices.RecurringInvoiceId | Id of recurring invoice. | |
| ItemId | String |
Items.ItemId | Id of the item. | |
| ItemOrder | Integer | Order of the item. | ||
| ItemTotal | Decimal | Total number of item. | ||
| Description | String | Description of the recurring invoice line item. | ||
| Discount | String | Amount of discount applied for items of recurring invoice. | ||
| DiscountAmount | Decimal | Amount of discount. | ||
| HeaderId | String | Id of the header. | ||
| HeaderName | String | Name of the header. | ||
| Name | String | Name of the recurring invoice line item. | ||
| ProjectId | String |
Projects.ProjectId | Id of the project. | |
| Quantity | String | Total number of item. | ||
| Rate | Decimal | Rate for recurring invoice.. | ||
| 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 | Total quantity included in recurring invoice items. | ||
| SKU | String | The SKU of the Line Item. |