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