JDBC Driver for Zoho Inventory

Build 24.0.9060

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.

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