Cmdlets for Zoho Books

Build 24.0.8963

RecurringBills

To list, add, update and delete details of a bill.

Table Specific Information

Select

The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:

  • VendorId supports the '=' comparison.
  • VendorName supports the '=, CONTAINS' comparisons.
  • RecurrenceName supports the '=' comparison.
  • Status supports the '=' comparison.
  • StartDate supports the '=,<,>' comparisons.
  • EndDate supports the '=' comparison.

The rest of the filter is executed client-side in the 本製品.

For example:

    SELECT * FROM RecurringBills WHERE vendorid = '3255827000000081003'

    SELECT * FROM RecurringBills WHERE CONTAINS (vendorname, 'c')

    SELECT * FROM RecurringBills WHERE startdate > '2023-03-3'

Columns

Name Type References SupportedOperators Description
RecurringBillId [KEY] String Id of a Bill.
VendorId String = Id of the vendor the bill has been made.
VendorName String = Name of the vendor the bill has been made.
Status String = Status of the bill.
RecurrenceName String = Frequency at which recurring bill will be sent.
RecurrenceFrequency String Search recurring bills by recurrence number.
RepeatEvery Integer Integer value denoting the frequency of bill.
StartDate Date =,>,< Date when bill was created.
LastSentDate Date Date when recurring bill was last sent.
NextBillDate Date Date when bill will be sent next.
EndDate Date = Date when the payment is expected.
CreatedTime Datetime Time at which the bill was created.
LastModifiedTime Datetime The time of last modification of the bill.
Total Integer Total of the bill.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963