JDBC Driver for QuickBooks

Build 20.0.7654

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.
ARCreditCardRefunds Query and Insert QuickBooks AR Credit Card Refund transactions.
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.
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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654