ODBC Driver for QuickBooks Online

Build 20.0.7587

Tables

The driver models the data in QuickBooks Online into a list of tables that can be queried using standard SQL statements.

Generally, querying QuickBooks Online 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 ODBC Driver for QuickBooks Online Tables

Name Description
Accounts Create, update, delete, and query QuickBooks Accounts.
AttachableRefs Attachables
Attachables Attachables
BillLineItems Create, update, delete, and query QuickBooks Bill Line Items.
BillLinkedTransactions Create, update, delete, and query QuickBooks Invoice Line Items.
BillPaymentLineItems Create, update, delete, and query QuickBooks Bill Payment Line Items.
BillPayments Create, update, delete, and query QuickBooks Bill Payments.
Bills Create, update, delete, and query QuickBooks Bills.
BudgetDetails Query QuickBooks BudgetDetails.
Budgets Query QuickBooks Budgets.
Class Create, update, delete, and query QuickBooks Classes.
CompanyCurrency Create, update, delete, and query QuickBooks CompanyCurrency. Applicable only for those companies that enable multicurrency, a companycurrency object defines a currency that is active in the QuickBooks Online company. One or more companycurrency objects are active based on the company's multicurrency business requirements and correspond to the list displayed by the Currency Center in the QuickBooks Online UI.
CompanyInfo Retrieve information about the QuickBooks company.
CreditMemoLineItems Create, update, delete, and query QuickBooks Credit Memo Line Items.
CreditMemos Create, update, delete, and query QuickBooks Credit Memos.
Customers Create, update, delete, and query QuickBooks Customers.
Departments Create, update, delete, and query QuickBooks Departments.
DepositLineItems Create, update, delete, and query QuickBooks Deposit Line Items.
Deposits Create, update, delete, and query QuickBooks Deposits.
Employees Create, update, delete, and query QuickBooks Employees.
EstimateLineItems Create, update, delete, and query QuickBooks Estimate Line Items.
EstimateLinkedTransactions Create, update, delete, and query QuickBooks Estimate Line Items.
Estimates Create, update, delete, and query QuickBooks Estimates.
ExchangeRates Retrieves QuickBooks exchange rates.
InvoiceLineItems Create, update, delete, and query QuickBooks Invoice Line Items.
InvoiceLinkedTransactions Create, update, delete, and query QuickBooks Invoice Line Items.
Invoices Create, update, delete, and query QuickBooks Invoices.
Items Create, update, delete, and query QuickBooks Items.
JournalCode Create, update, delete, and query QuickBooks Journal Codes.
JournalEntries Create, update, delete, and query QuickBooks Journal Entries.
JournalEntryLineItems Create, update, delete, and query QuickBooks Journal Entry Line Items.
PaymentLineItems Create, update, delete, and query QuickBooks Payment Line Items.
PaymentMethods Create, update, delete, and query QuickBooks Payment Methods.
Payments Create, update, delete, and query QuickBooks Payments.
Preferences Query QuickBooks Preferences. The Preferences table contains settings for company-wide preferences, which affect all users.
PurchaseLineItems Create, update, delete, and query QuickBooks Purchase Line Items.
PurchaseOrderLineItems Create, update, delete, and query QuickBooks Purchase Order Line Items.
PurchaseOrderLinkedTransactions Create, update, delete, and query QuickBooks Invoice Line Items.
PurchaseOrders Create, update, delete, and query QuickBooks Purchase Orders.
Purchases Create, update, delete, and query QuickBooks Purchases.
RefundReceiptLineItems Create, update, delete, and query QuickBooks RefundReceiptLineItems.
RefundReceipts Create, update, delete, and query QuickBooks RefundReceipts.
SalesReceiptLineItems Create, update, delete, and query QuickBooks Sales Receipt Line Items.
SalesReceipts Create, update, delete, and query QuickBooks Sales Receipts.
TaxAgency Create and Query QuickBooks Tax Agency.
Terms Create, update, delete, and query QuickBooks Terms.
TimeActivities Create, update, delete, and query QuickBooks Time Activities.
Transfers Create, update, delete, and query QuickBooks Transfers
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.

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