Tables
The driver models the data in QuickBooks into a list of tables that can be queried using standard SQL statements.
Generally, querying QuickBooks 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 QuickBooks Tables
| Name | Description |
| Accounts | Create, update, delete, and query QuickBooks Accounts. To update Accounts, set the QBXMLVersion to 6.0 or higher. |
| BillExpenseItems | Create, update, delete, and query QuickBooks Bill Expense Line Items. |
| BillLineItems | Create, update, delete, and query QuickBooks Bill Line Items. |
| BillPaymentChecks | Create, update, delete, and query QuickBooks Bill Payment Checks. QBXMLVersion must be set to 6.0 or higher to update a BillPaymentCheck. |
| BillPaymentChecksAppliedTo | Create, update, delete, and query QuickBooks Bill Payment AppliedTo aggregates. In a Bill Payment, each AppliedTo aggregate represents the Bill transaction to which this part of the payment is being applied. |
| BillPaymentCreditCards | Create, update, delete, and query QuickBooks Bill Payments. |
| BillPaymentCreditCardsAppliedTo | Create, update, delete, and query QuickBooks Bill Payment AppliedTo aggregates. In a Bill Payment, each AppliedTo aggregate represents the Bill transaction to which this part of the payment is being applied. |
| Bills | Create, update, delete, and query QuickBooks Bills. |
| BuildAssemblies | Insert, Update, delete, and query QuickBooks Build Assembly transactions. |
| BuildAssemblyLineItems | Create and query QuickBooks Build Assembly transactions. |
| CheckExpenseItems | Create, update, delete, and query QuickBooks Check Expense Line Items. |
| CheckLineItems | Create, update, delete, and query QuickBooks Check Line Items. |
| Checks | Create, update, delete, and query QuickBooks Checks. |
| Class | Create, update, delete, and query QuickBooks Classes. QuickBooks requires QBXML version 8.0 or higher for updates to a Class. |
| CreditCardChargeExpenseItems | Create, update, delete, and query QuickBooks Credit Card Charge Expense Line Items. |
| CreditCardChargeLineItems | Create, update, delete, and query QuickBooks Credit Card Charge Line Items. |
| CreditCardCharges | Create, update, delete, and query QuickBooks Credit Card Charges. |
| CreditCardCreditExpenseItems | Create, update, delete, and query QuickBooks Credit Card Credit Expense Line Items. |
| CreditCardCreditLineItems | Create, update, delete, and query QuickBooks Credit Card Credit Line Items. |
| CreditCardCredits | Create, update, delete, and query QuickBooks Credit Card Credits. |
| CreditCardRefunds | Query and Insert QuickBooks AR Credit Card Refund transactions. |
| CreditMemoLineItems | Create, update, delete, and query QuickBooks Credit Memo Line Items. |
| CreditMemos | Create, update, delete, and query QuickBooks Credit Memos. |
| Currency | Create, update, delete, and query QuickBooks Currencies. This table requires QBXML version 8.0 or higher, and you will need to enable multiple Currencies in your QuickBooks company file to use it. |
| CustomerContacts | Create, update, delete, and query QuickBooks Customer Contacts. This table requires QBXML version 12.0 or higher, and is only available in QuickBooks editions 2016 and above. |
| CustomerMessages | Create, delete, and query Customer Messages. |
| CustomerNotes | Create, update, and query QuickBooks Customer Notes. This table requires QBXML version 12.0 or higher. |
| Customers | Create, update, delete, and query QuickBooks Customers. |
| CustomerShippingAddresses | Create, update, delete, and query QuickBooks Customer Shipping Addresses. Multiple Customer Shipping Addresses are supported in only QuickBooks 2013 and higher. Additionally, this table requires QBXML version 12.0 or higher. |
| CustomerTypes | Create, update, delete, and query QuickBooks Customer Types. |
| DateDrivenTerms | Create, delete, and query QuickBooks Date Driven Terms. |
| DepositLineItems | Create, update, delete, and query QuickBooks Deposit Line Items. QBXMLVersion must be set to 7.0 or higher to update a deposit. |
| Deposits | Create, update, delete, and query QuickBooks Deposits. QBXMLVersion must be set to 7.0 or higher to update a deposit. |
| EmployeeEarnings | Create, update, delete, and query QuickBooks Employee Earnings. |
| Employees | Create, update, delete, and query QuickBooks Employees. |
| EstimateLineItems | Create, update, delete, and query QuickBooks Estimate Line Items. |
| Estimates | Create, update, delete, and query QuickBooks Estimates. |
| InventoryAdjustmentLineItems | Create and query QuickBooks Inventory Adjustment Line Items. |
| InventoryAdjustments | Create, query, and delete QuickBooks Inventory Adjustments. |
| InventorySites | Create, update, delete, and query QuickBooks Inventory Sites. Inventory Sites are only available in QuickBooks Enterprise 2010 and above, and only with the Advanced Inventory add-on. |
| InvoiceLineItems | Create, update, delete, and query QuickBooks Invoice Line Items. |
| Invoices | Create, update, delete, and query QuickBooks Invoices. |
| ItemLineItems | Create, update, delete, and query QuickBooks Item Line Items. |
| ItemReceiptExpenseItems | Create, update, delete, and query QuickBooks Item Receipt Expense Line Items. |
| ItemReceiptLineItems | Create, update, delete, and query QuickBooks Item Receipt Line Items. |
| ItemReceipts | Create, update, delete, and query QuickBooks Item Receipts. |
| Items | Create, update, delete, and query QuickBooks Items. |
| JobTypes | Create and query QuickBooks JobTypes. |
| JournalEntries | Create, update, delete, and query QuickBooks Journal Entries. Note that while Journal Entry Lines can be created with a new Journal Entry, they cannot be added or removed from an existing Journal Entry. |
| JournalEntryLines | Create, update, delete, and query QuickBooks Journal Entries. Note that while Journal Entry Lines can be created with a new Journal Entry, they cannot be added or removed from an existing Journal Entry. |
| OtherNames | Create, update, delete, and query QuickBooks Other Name entities. |
| PaymentMethods | Create, update, delete, and query QuickBooks Payment Methods. |
| PayrollNonWageItems | Query QuickBooks Non-Wage Payroll Items. |
| PayrollWageItems | Create and query QuickBooks Wage Payroll Items. |
| PriceLevelPerItem | Create and query QuickBooks Price Levels Per Item. Only QuickBooks Premier and Enterprise support Per-Item Price Levels. Note that while Price Levels can be added from this table, you may only add Per-Item Price Levels from this table. Price Levels may be deleted from the PriceLevels table. This table requires QBXML version 4.0 or later. |
| PriceLevels | Create, delete, and query QuickBooks Price Levels. Note that while Price Levels can be added and deleted from this table, you may add only fixed-percentage Price Levels from this table. Per-Item Price Levels may be added via the PriceLevelPerItem table. This table requires QBXML version 4.0 or higher. |
| PurchaseOrderLineItems | Create, update, delete, and query QuickBooks Purchase Order Line Items. |
| PurchaseOrders | Create, update, delete, and query QuickBooks Purchase Orders. |
| ReceivePayments | Create, update, delete, and query QuickBooks Receive Payment transactions. QBXMLVersion must be set to 6.0 or higher to update a ReceivePayment. |
| ReceivePaymentsAppliedTo | Create, update, and query QuickBooks Receive Payment AppliedTo aggregates. In a Receive Payment, each AppliedTo aggregate represents the transaction to which this part of the payment is being applied. QBXMLVersion must be set to 6.0 or higher to update a ReceivePayment. |
| SalesOrderLineItems | Create, update, delete, and query QuickBooks Sales Order Line Items. |
| SalesOrders | Create, update, delete, and query QuickBooks Sales Orders. |
| SalesReceiptLineItems | Create, update, delete, and query QuickBooks Sales Receipt Line Items. |
| SalesReceipts | Create, update, delete, and query QuickBooks Sales Receipts. |
| SalesReps | Create, update, delete, and query QuickBooks Sales Rep entities. |
| SalesTaxCodes | Create, update, delete, and query QuickBooks Sales Tax Codes. |
| SalesTaxItems | Create, update, delete, and query QuickBooks Sales Tax Items. |
| ShippingMethods | Create, update, delete, and query QuickBooks Shipping Methods. |
| StandardTerms | Create, update, delete, and query QuickBooks Standard Terms. |
| StatementCharges | Create, update, delete, and query QuickBooks Statement Charges. |
| TimeTracking | Create, update, delete, and query QuickBooks Time Tracking events. |
| ToDo | Create, update, delete, and query QuickBooks To Do entries. |
| TransferInventory | Query and delete QuickBooks Transfer Inventory transactions. Transfer Inventory is available in only QuickBooks Enterprise 2010 and above, and only with the Advanced Inventory add-on. |
| TransferInventoryLineItems | Create and query QuickBooks Transfer Inventory Line Items. Transfer Inventory is available in only QuickBooks Enterprise 2010 and above, and only with the Advanced Inventory add-on. |
| Transfers | Create, update, and query QuickBooks transfers. Requires QBXML version 12.0 or higher. |
| UnitOfMeasure | Create, update, delete, and query QuickBooks units of measure. QuickBooks requires QBXML version 7.0 or higher to use this table. |
| UnitOfMeasureDefaultUnits | Create and query QuickBooks unit-of-measure default units. QuickBooks requires QBXML version 7.0 or higher to use this table. |
| UnitOfMeasureRelatedUnits | Create and query QuickBooks unit-of-measure related units. QuickBooks requires QBXML version 7.0 or higher to use this table. |
| VehicleMileage | Create, update, delete, and query QuickBooks Vehicle Mileage entities. QuickBooks requires QBXML version 6.0 or higher to use this table. |
| VendorCreditExpenseItems | Create, update, delete, and query QuickBooks Vendor Credit Expense Line Items. |
| VendorCreditLineItems | Create, update, delete, and query QuickBooks Vendor Credit Line Items. |
| VendorCredits | Create, update, delete, and query QuickBooks Vendor Credits. |
| Vendors | Create, update, delete, and query QuickBooks Vendors. |
| VendorTypes | Create, update, delete, and query QuickBooks Vendor Types. |
| WorkersCompCodeLines | Query QuickBooks Workers Comp Code entries by line. Requires QBXML Version 7.0 or higher. |
| WorkersCompCodes | Query QuickBooks Workers Comp Code entries. Requires QBXML Version 7.0 or higher. |