JDBC Driver for Zoho Books

Build 22.0.8479


Retrieves list of all sales orders.

Table Specific Information


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 本製品.

  • SalesorderId supports the '=' comparison.
  • CustomerId supports the '=' comparison.
  • CustomerName supports the '=' comparison.
  • Date supports the '=,<,>' comparisons.
  • ReferenceNumber supports the '=' comparison.
  • SalesorderNumber supports the '=' comparison.
  • ShipmentDate supports the '=,<,>' comparisons.
  • Status supports the '=' comparison.
  • Total supports the '=,<,<=,>,>=' comparisons.
  • ItemId supports the '=' comparison.
  • ItemName supports the '=' comparison.
  • ItemDescription supports the '=' comparison.
  • SalesOrderFilter supports the '=' comparison.
For example:
    SELECT * FROM SalesOrders WHERE CustomerId = '1894553000000077328' AND CustomerName = 'Zylak' AND SalesOrderFilter = 'Status.All'

    SELECT * FROM SalesOrders WHERE ShipmentDate > '2017-08-01'

    SELECT * FROM SalesOrders WHERE CONTAINS(SalesorderNumber,'SO-00')


Name Type References SupportedOperators Description
SalesorderId [KEY] String ID of a sales order.
SalespersonName String Name of the sales order.
BcyTotal Decimal Total Base Currency.
ColorCode String Color code of Sales order.
CompanyName String Name of the company.
CreatedTime Datetime Time at which the sales order was created.
CurrencyCode String Currency code of the customer's currency.
CurrencyId String


Currency ID of the customer's currency.
CurrentSubStatus String Current sub status of a sales order.
CurrentSubStatusId String Current sub status ID of a sales order.
CustomerId String


ID of the customer or vendor. Search Sales Order based on customer_id.
CustomerName String Name of the customer or vendor. .
Date Date =,<,> Date of an sales order.
DueByDays String Total number of day sales order is due by.
DueInDays String Total number of day the sales order is due in.
HasAttachment Boolean Check if the sales order has attachment.
InvoicedStatus String Status of invoiced sales orders.
IsEmailed Boolean Check if the sales order is emailed.
LastModifiedTime Datetime The time of last modification of the sales order.
OrderStatus String Status of order.
ReferenceNumber String Reference number of sales order.
SalesorderNumber String Number of a sales order.
ShipmentDate Date =,<,> Date of shipment.
ShipmentDays String Total number of days for shipment.
Status String Status of sales order.

使用できる値は次のとおりです。draft, open, invoiced, partially_invoiced, void, overdue

Total Decimal =,<,<=,>,>= Total of sales orders.
TotalInvoicedAmount Decimal Total amount which is invoiced.


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
ItemId String Id of an item.
ItemName String Name of an item.
ItemDescription String Description of an item.
SalesOrderFilter String Filter sales order by status.

使用できる値は次のとおりです。Status.All, Status.Open, Status.Draft, Status.OverDue, Status.PartiallyInvoiced, Status.Invoiced, Status.Void, Status.Closed

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