ODBC Driver for Zoho Books

Build 24.0.9060

Bills

Retrieves list of bills.

Table Specific Information

Select

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

  • BillNumber supports the '=' comparison.
  • Date supports the '=,<,>' comparisons.
  • LastModifiedTime supports the '=' comparison.
  • ReferenceNumber supports the '=' comparison.
  • Status supports the '=' comparison.
  • Total supports the '=,<,<=,>,>=' comparisons.
  • VendorId supports the '=' comparison.
  • VendorName supports the '=' comparison.
  • PurchaseOrderId supports the '=' comparison.
  • RecurringBillId supports the '=' comparison.
  • BillFilter supports the '=' comparison.
  • ItemId supports the '=' comparison.
  • ItemDescription. supports the '=' comparison.

The rest of the filter is executed client-side in the driver.

For example:

    SELECT * FROM Bills WHERE Total < 100 AND Total <= 98

    SELECT * FROM Bills WHERE Date < '2018-07-03'

    SELECT * FROM Bills WHERE CONTAINS (BillNumber, 'Bi')

Columns

Name Type References SupportedOperators Description
BillId [KEY] String Id of a bill.
BillNumber String Number of bill.
Balance Decimal Amount of bill.
CreatedTime Datetime Time at which the bill was created.
Date Date =,<,> Date of a bill.
DueDate Date Delivery date to pay the bill.
DueDays String Due days to pay the bill.
HasAttachment Boolean Check if the bill has attachment.
LastModifiedTime Datetime Last Modified Time of bill.
ReferenceNumber String Reference number of a bill.
Status String Status of a bill.

The allowed values are paid, open, overdue, void, partially_paid.

TdsTotal Decimal Total amount of TDS applied.
Total Decimal =,<,<=,>,>= Total of bills. Search by bill total.
VendorId String Id of the vendor the bill has been made. Search bills by Vendor Id.
VendorName String Name of the vendor the bill has been made. Search bills by vendor name.

Pseudo-Columns

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.

Name Type Description
PurchaseOrderId String Id of a Purchase Order.
RecurringBillId String Id of a Recurring Bill.
BillFilter String Filter bills by any status.

The allowed values are Status.All, Status.PartiallyPaid, Status.Paid, Status.Overdue, Status.Void, Status.Open.

ItemId String Id of an Item.
ItemDescription String Description of a bill.

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