JDBC Driver for Zoho Inventory

Build 24.0.9060

PurchaseOrderDocuments

List Documents of Purchase 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.
  • PurchaseOrderId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM PurchaseOrderDocuments WHERE DocumentId = '3350895000000089001'

Columns

Name Type References Description
PurchaseOrderId Long

PurchaseOrders.Id

Unique ID generated by the server for the Purchase Order.
AttachmentOrder Integer Attachment Order
CanSendInMail Boolean Can Send in Mail
DocumentId [KEY] Long Document Id
FileName String File Name
FileSize Integer File Size
FileSizeFormatted String File Size Formatted
FileType String File Type

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