Tables
The driver models the data in Zoho Inventory as a list of tables in a relational database that can be queried using standard SQL statements.
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. |
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. |
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. |
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. |