Tables
The component models the data in Zoho Inventory as a list of tables in a relational database that can be queried using standard SQL statements.
CData SSIS Components for Zoho Inventory Tables
| Name | Description |
| Bills | List, Insert, Update, delete bills |
| CompositeItems | List, Insert, Update, delete CompositeItems |
| CompositeItemsBundles | List, Insert, Update, delete CompositeItems Bundles |
| ContactPersons | List, Insert, Update, delete contact persons |
| Contacts | List, Insert, Update, delete contacts |
| CreditNoteInvoicesCredited | Get invoices credited related to credit notes |
| CreditNoteListTemplates | Get templates related to credit notes |
| CreditNoteRefund | Get refund related to credit notes |
| CreditNotes | List, Insert, Update, delete CreditNotes |
| CreditNotesComments | Get comments related to credit notes |
| Currencies | List, Insert, Update, delete currency |
| CustomerPayments | List, Insert, Update, delete CustomerPayments |
| InventoryAdjustments | List, Insert, Update, delete inventory adjustments |
| InvoiceComments | Get comments related to invoices |
| Invoices | List, Insert, Update, delete Invoices |
| InvoicesBillCredited | Get bills credited related to invoices |
| ItemGroups | List, Insert, Update, delete item groups |
| Items | List, Insert, Update, delete items |
| Organizations | List, Insert, Update, delete organizations |
| Packages | List, Insert, Update, delete packages |
| PriceBooks | List, Insert, Update, delete pricebooks |
| PurchaseOrders | List, Insert, Update, delete purchase orders |
| PurchaseReceives | List, Insert, Update, delete purchase receives |
| RetainerInvoices | List, Insert, Update, delete Retainer Invoices |
| RetainerInvoicesComments | Get comments related to a contact |
| SalesOrders | List, Insert, Update, delete sales orders |
| SalesReturns | List, Insert, Update, delete salesreturns |
| ShipmentOrders | List, Insert, Update, Delete shipment orders |
| TaxAuthorities | List, Insert, Update, delete tax authorities |
| Taxes | List, Insert, Update, delete taxes |
| TaxExemptions | List, Insert, Update, delete tax exemptions |
| TaxGroups | List, Insert, Update, delete tax groups |
| TransferOrders | List, Insert, Update, delete transfer orders |
| Users | List, Insert, Update, delete users |
| VendorCreditRefund | Get refund for a vendor credit |
| VendorCredits | List, Insert, Update, delete VendorCredits |
| VendorCreditsBillCredited | Get bills credited to a vendor credit |
| VendorCreditsComments | Get comments related to vendor credit |
| Warehouses | List, Insert, Update, delete warehouses |