Power BI Connector for Zoho Books

Build 22.0.8479

RecurringInvoiceLineItems

Get the details of line items of a recurring invoice.

Table Specific Information

Select

The 本製品 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 本製品.
Note: RecurringInvoiceId is required in order to query RecurringInvoiceLineItems.

  • RecurringInvoiceId supports the '=' comparison.
For example:
    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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479