Tables
The driver models the data in Zoho Inventory into a list of tables that can be queried using standard SQL statements.
Generally, querying Zoho Inventory tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData JDBC Driver for Zoho Inventory Tables
Name | Description |
Bills | Read, Insert, Update and Delete Bills. |
CompositeItems | Read, Insert, Update and Delete the CompositeItems. |
CompositeItemsBundles | Read,Insert, Update and Delete CompositeItemsBundles. |
CompositeItemsMappedItems | Read the mapped items of the Composite items. |
ContactPersons | Read, Insert, Update and Delete Contact Persons. |
Contacts | Retrives list of all contacts |
CreditNoteInvoicesCredited | List invoice credited for credit notes. |
CreditNoteRefund | Read, Insert,Update and Delete Refunds of CreditNotes. |
CreditNotes | List, Insert,Update and Delete Credit Notes. |
CreditNotesComments | List, Insert and Delete Comments from CreditNotes. |
Currencies | Read, Insert, Update and Delete Currencies. |
CustomerPayments | Read, Insert, Update nad Delete Customer Payments. |
InventoryAdjustments | Read, Insert and Delete Inventory Adjustments. |
InvoiceComments | Read, Insert,Update and Delete the Comment of the invoice. |
Invoices | Read, Insert, Update and Delete Invoices. |
InvoicesBillCredited | Read, Insert and Delete bills credited of invoices. |
InvoicesLineItems | Line items of Invoices. |
ItemGroups | Read, Insert, Update adn Delete Item groups. |
Items | Read, Insert, Update and Delete Items. |
Organizations | Get list of Organization |
Packages | Read, Insert, Update and Delete Packages. |
Pricebooks | Read, Insert, Update and Delete Pricebooks. |
PurchaseOrders | Read, Insert, Update and Delete Purchase Orders. |
PurchaseReceives | Read, Insert and Delete Purchase Receives. |
RetainerInvoiceListPayments | Get payments of Retainer Invoice. |
RetainerInvoices | Read, Insert, Update and Delete Retainer Invoice. |
RetainerInvoicesComments | List comments of Retainer Invoice. |
SalesOrders | Read, Insert,Update and Delete Sales Orders. |
SalesReturns | Read, Insert, Update and Delete Sales Returns. |
ShipmentOrders | Read, Insert, Update and Delete Shipment Orders. |
TaxAuthorities | Read, Create, Update and Delete Tax Authorities. |
Taxes | Read, Insert, Update and Delete taxes. |
TaxExemptions | Read, Insert, Update and Delete Tax Exemption |
TaxGroups | Read, Insert, Update and Delete Tax Groups. |
TransferOrders | Read, Insert and Delete Transfer Orders. |
Users | Read, Insert, Update and Delete Users. |
VendorCreditRefund | Read, Insert and Update Vendor Credit Refunds. |
VendorCredits | Read, Insert, Update and Delete Vendor Credits. |
VendorCreditsBillCredited | Read, Insert and Delete Bills Credited of Vendor Credits. |
Warehouses | Read, Insert, Update and Delete Warehouses. |