Tables

The connector models the data in QuickBooks Online as a list of tables in a relational database that can be queried using standard SQL statements.

CData Python Connector for QuickBooks Online Tables


Name	Description
Accounts	Holds the chart of accounts in QuickBooks Online, enabling the creation, modification, deletion, and retrieval of financial account records that are used for categorizing transactions and reporting.
AttachableRefs	Provides references linking transactions or entities to attached files or documents, helping you trace how uploaded attachments relate to bills, invoices, or other QuickBooks objects.
Attachables	Stores the actual files or metadata of attachments that are uploaded to QuickBooks Online, such as receipts, contracts, or images that support financial transactions or customer/vendor records.
BillLineItems	Contains detailed line-item data for vendor bills, including products or services purchased, amounts, tax details, and associated accounts for expense tracking and reporting.
BillLinkedTransactions	Tracks relationships between vendor bills and linked transactions, such as purchase orders or payments, allowing you to see how bills relate to other financial activities.
BillPaymentLineItems	Captures line-level details of bill payments, showing how each payment applies to one or multiple bills and reflecting discounts or credits used.
BillPayments	Maintains records of vendor bill payments, including payment methods, amounts, dates, and vendor details, to manage cash outflows and reconcile accounts payable.
Bills	Represents vendor bills in QuickBooks Online, enabling you to create, modify, delete, and retrieve obligations that are owed to suppliers for goods or services received.
BudgetDetails	Provides detailed budget line items, including amounts per account, class, or department, supporting budget-to-actual analysis within QuickBooks Online.
Budgets	Contains the header-level information of company budgets, including fiscal year, budget type, and tracking segments that are used for financial planning and analysis.
Class	Stores QuickBooks Classes that are used to categorize transactions across multiple business segments or projects, supporting more granular reporting and profit/loss tracking.
CompanyCurrency	Defines each active currency configured for a QuickBooks Online company with multicurrency enabled, including currency codes, exchange rates, and activation status as seen in the Currency Center.
CompanyInfo	Retrieves core company information such as legal name, address, industry type, fiscal year start, and contact details, which underpin company-wide settings in QuickBooks Online.
CreditMemoLineItems	Captures line-level details of customer credit memos, including products or services credited, amounts, and tax information for accurate revenue adjustments.
CreditMemos	Maintains records of customer credit memos that are issued to adjust invoices, apply customer credits, or refund amounts for returned goods or overpayments.
Customers	Contains all customer profiles in QuickBooks Online, enabling you to create, update, delete, and retrieve customer contact information, billing preferences, and tax settings.
Departments	Holds department or location records that are used to track income, expenses, and profitability by business unit or physical location.
DepositLineItems	Contains individual line items of bank deposits, detailing the source payments, amounts, and linked transactions that are consolidated into each deposit.
Deposits	Maintains bank-deposit records that show lump-sum deposits, associated line items, and account allocations for accurate bank reconciliation.
Employees	Stores employee records for payroll and HR functions, including contact details, hire dates, and status that are used in time tracking and expense reporting.
EstimateLineItems	Contains line-item details for customer estimates or quotes, including products, services, quantities, prices, and tax information for potential sales.
EstimateLinkedTransactions	Tracks how customer estimates link to other transactions such as invoices or sales orders, helping follow a deal from quote to billing.
Estimates	Stores header-level information of customer estimates or quotes, such as customer details, dates, and total amounts, supporting the sales pipeline.
ExchangeRates	Provides daily or periodic exchange rate data used by QuickBooks Online to convert multicurrency transactions into the home currency for reporting and compliance.
InvoiceLineItems	Captures line-level details of customer invoices, including products or services sold, quantities, prices, discounts, and taxes, forming the granular data behind each invoice.
InvoiceLinkedTransactions	Tracks relationships between invoices and related transactions, such as payments or sales receipts, to help trace how invoices are settled and linked within the sales process.
Invoices	Stores header-level information for customer invoices, including customer details, invoice dates, terms, due dates, and balances, supporting accounts-receivable tracking and reporting.
Items	Maintains the catalog of products and services that are offered by the business, including inventory and non-inventory items, used for sales, purchases, and expense tracking across QuickBooks Online.
JournalCode	Contains journal codes that are used for classification or statutory reporting in certain regions, enabling businesses to meet country-specific accounting requirements.
JournalEntries	Stores journal entries that record double-entry accounting adjustments, including debits and credits applied to accounts, used for financial corrections and accruals.
JournalEntryLineItems	Contains the line-level debit and credit details of each journal entry, showing how accounts are affected within a balanced accounting transaction.
PaymentLineItems	Captures the line-level allocations of customer payments, showing how each payment applies to invoices, credit memos, or other receivables.
PaymentMethods	Stores available payment-method definitions such as cash, check, credit card, or bank transfer, used when recording customer payments or vendor bill settlements.
Payments	Represents payments that are received from customers, including amount, date, payment method, and linked invoices, forming the basis for accounts-receivable settlement.
Preferences	Contains company-wide preference settings that define QuickBooks Online behavior, such as sales-form defaults, accounting methods, tax preferences, and user-access configurations.
PurchaseLineItems	Captures the line-level details of purchase transactions, including vendor items, quantities, unit costs, and expense accounts for accurate expense and cost tracking.
PurchaseOrderLineItems	Contains detailed line items for purchase orders, specifying products or services requested, quantities, expected costs, and vendor references.
PurchaseOrderLinkedTransactions	Tracks relationships between purchase orders and linked transactions, such as bills or item receipts, allowing visibility into the purchasing and fulfillment lifecycle.
PurchaseOrders	Stores header-level purchase order information, including vendor, order date, expected delivery, and total value, supporting procurement and vendor management.
Purchases	Represents general purchase transactions, including credit-card charges, checks, or cash purchases, capturing spending outside of standard vendor bills.
RecurringCreditMemoTransactions	Contains recurring transaction templates for customer credit memos, allowing automated issuance of credits to customers on a predefined schedule.
RecurringCreditMemoTransactionsLineItems	Captures line-level details of recurring credit memos, including products or services credited, amounts, and taxes applied automatically.
RecurringDepositTransactions	Stores recurring templates for deposit transactions, enabling businesses to automate repetitive deposits into bank accounts.
RecurringDepositTransactionsLineItems	Contains line-level details of recurring deposits, such as payment sources and amounts, supporting automation of regular income deposits.
RecurringEstimateTransactions	Maintains recurring estimate templates, automating the generation of customer quotes on a set schedule for recurring sales opportunities.
RecurringEstimateTransactionsLineItems	Captures the line-level details of recurring estimates, such as products, services, and pricing, ensuring consistent quote creation over time.
RecurringInvoiceTransactions	Stores recurring invoice templates that automate billing for subscriptions, retainers, or repeat sales, improving cash-flow management.
RecurringInvoiceTransactionsLineItems	Contains the line-level detail of recurring invoices, specifying products, services, amounts, and taxes that are applied each billing cycle.
RecurringJournalEntryTransactions	Holds recurring journal entry templates, enabling automated posting of routine accounting adjustments like depreciation or accruals.
RecurringJournalEntryTransactionsLineItems	Captures the debit and credit line items for recurring journal entries, ensuring accurate and consistent automated accounting adjustments.
RecurringPurchaseTransactions	Represents recurring purchase templates for expenses, allowing businesses to schedule automatic entry of regular vendor purchases.
RecurringPurchaseTransactionsLineItems	Contains the detailed line items of recurring purchase templates, including items, costs, and accounts for automated expense tracking.
RecurringRefundReceiptTransactions	Stores recurring templates for customer refund receipts, enabling businesses to automate returning funds to customers on a scheduled basis.
RecurringRefundReceiptTransactionsLineItems	Contains the line-level details of recurring refund receipts, including refunded products, services, amounts, and taxes for consistent automated processing.
RecurringSalesReceiptTransactions	Holds recurring templates for sales receipts, automating the recording of repeat customer sales that are paid at the point of sale.
RecurringSalesReceiptTransactionsLineItems	Captures line-level details of recurring sales receipts, specifying items sold, quantities, and amounts for each automated sales entry.
RecurringTransferTransactions	Maintains recurring templates for fund transfers between accounts, automating routine internal transfers within QuickBooks Online.
RecurringVendorCreditTransactions	Stores recurring templates for vendor credits, allowing automated application of credits or refunds from vendors on a scheduled basis.
RecurringVendorCreditTransactionsLineItems	Contains line-level details of recurring vendor credits, specifying items, amounts, and accounts for automated vendor-credit processing.
RefundReceiptLineItems	Captures the line-level details of customer refund receipts, including refunded items, quantities, and amounts to accurately track returns and reimbursements.
RefundReceipts	Represents customer refund receipts at the header level, including customer information, refund method, and total amount refunded.
SalesReceiptLineItems	Contains line-level details of sales receipts for immediate sales transactions, including items sold, quantities, discounts, and taxes.
SalesReceipts	Represents sales receipts at the header level, recording point-of-sale transactions where payment is received immediately.
TaxAgency	Stores tax-agency records that are used in QuickBooks Online to define the government authorities to which sales tax is remitted.
TaxCodes	Contains sales tax codes and rules that determine how taxes are calculated on transactions, supporting multi-jurisdiction compliance.
TaxRates	Maintains sales-tax rate definitions that are applied to transactions, including jurisdiction, rate percentage, and effective dates.
Terms	Stores payment terms such as Net 30 or Due on Receipt, used to define invoice due dates and early payment discounts.
TimeActivities	Contains time entry records for employees or vendors, capturing billable and non-billable hours linked to customers, projects, or payroll.
Transfers	Represents transfers of funds between bank, credit card, or other accounts, recording movement of money within the business.
VendorCreditLineItems	Captures line-level details of vendor credits, including items or expenses credited, amounts, and accounts to properly offset vendor balances.
VendorCredits	Represents vendor credits at the header level, used to apply credits to bills or reimburse the company for returns or overpayments.
Vendors	Stores vendor records including contact details, payment terms, and tax information, forming the master list of suppliers for QuickBooks Online.