JDBC Driver for Zoho Inventory

Build 24.0.9060

SalesOrderDocuments

List documents of sales orders.

Table Specific Information

Select

The driver will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the driver.

  • DocumentId supports the '=' comparison.
  • SalesOrderId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM SalesOrderDocuments WHERE DocumentId = '3350895000000089001'

SELECT * FROM SalesOrderDocuments WHERE SalesOrderId = '3350895000000089001'

Columns

Name Type References Description
DocumentId [KEY] Long Unique ID generated by the server for the document.
SalesOrderId Long

SalesOrders.Id

Id of the salesorder.
AttachmentOrder Integer This indicates the chronological number of the attachment.
CanSendInMail Boolean Checks whether the sales order can be sent as a mail or not.
FileName String This indicates the name of the file.
FileSize Integer this indicates the size of the attached file.
FileSizeFormatted String This indicates the size of the formatted file.
FileType String Sales order can have files attached to them.

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