Retrieves list of all recurring invoices.
Table Specific Information
The connector 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 connector.
- RecurrenceName supports the '=' comparison.
- CustomerId supports the '=' comparison.
- CustomerName supports the '=' comparison.
- Status supports the '=' comparison.
- RecurringInvoiceFilter supports the '=' comparison.
- LineItemId supports the '=' comparison.
- TaxId supports the '=' comparison.
- Notes supports the '=' comparison.
- ItemId supports the '=' comparison.
- ItemName supports the '=' comparison.
- ItemDescription supports the '=' comparison.
SELECT * FROM RecurringInvoices WHERE RecurrenceName = 'Office Rent' AND EndDate = '2018-06-21' SELECT * FROM RecurringInvoices WHERE ItemName = 'Standard Plan'
|RecurringInvoiceId [KEY]||String||ID of a recurring invoice.|
|RecurrenceName||String||Name of a recurrence.|
|ChildEntityType||String||Entity type of a child.|
|CreatedTime||Datetime||Time at which the recurring invoice was created.|
|ID of the customer or vendor.|
|CustomerName||String||Name of the customer or vendor.|
|EndDate||Date||End date for the statement.|
|LastFourDigits||String||It store the last four digits of customer's card details.|
|LastModifiedTime||Datetime||The time of last modification of the recurring invoice.|
|LastSentDate||Date||Date recurring invoice was last sent.|
|NextInvoiceDate||Date||Date when recurring invoice will be send next.|
|RecurrenceFrequency||String||Frequency of the recurrence.|
|ReferenceNumber||String||Reference number of recurring invoice.|
|StartDate||Date||Starting date of recurring invoice.|
|Status||String||Status of the recurring invoice.
The allowed values are active, stopped, expired.
|Total||Decimal||Total of recurring invoices.|
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
|RecurringInvoiceFilter||String||Filter recurring invoice by status.
The allowed values are Status.All, Status.Active, Status.Stopped, Status.Expired.
|LineItemId||String||Id of a line item.|
|TaxId||String||ID of tax.|
|Notes||String||Notes for this recurring invoice.|
|ItemId||String||ID of an item.|
|ItemName||String||Name of an item.|
|ItemDescription||String||Description of an item.|