RecurringInvoiceLineItems
Get the details of line items of a recurring invoice.
Table Specific Information
Select
The component will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.
Note: RecurringInvoiceId is required in order to query RecurringInvoiceLineItems.
- RecurringInvoiceId supports the '=' comparison.
SELECT * FROM RecurringInvoiceLineItems WHERE RecurringInvoiceId = '1895453000000042244'
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. |