Tables

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

CData Python Connector for QuickBooks Tables


Name	Description
Accounts	Manages QuickBooks Accounts, allowing users to create, update, delete, and query account data. Ensure the QBXML Version is set to 6.0 or higher for updates.
BillExpenseItems	Manages QuickBooks Bill Expense Line Items, supporting creation, updates, deletions, and queries for detailed expense tracking.
BillLineItems	Handles creation, updates, deletion, and querying of individual line items associated with QuickBooks Bills.
BillPaymentChecks	Manages Bill Payment Checks in QuickBooks, including creating, updating, deleting, and querying checks. Requires QBXML Version 6.0 or higher for updates.
BillPaymentChecksAppliedTo	Tracks the bill transactions to which Bill Payments are applied, with support for creating, updating, deleting, and querying aggregates. In a Bill Payment, each AppliedTo aggregate represents the Bill transaction to which this part of the payment is being applied.
BillPaymentCreditCards	Manages QuickBooks Bill Payments made via credit cards, including creation, updates, deletion, and queries.
BillPaymentCreditCardsAppliedTo	Tracks the application of credit card payments to specific Bill transactions, supporting creation, updates, deletion, and queries. In a Bill Payment, each AppliedTo aggregate represents the Bill transaction to which this part of the payment is being applied.
Bills	Handles the management of QuickBooks Bills, including creating, updating, deleting, and querying data for expense tracking.
BuildAssemblies	Manages Build Assembly transactions in QuickBooks, allowing users to insert, update, delete, and query assemblies for inventory management.
BuildAssemblyLineItems	Supports creation and querying of individual line items within QuickBooks Build Assembly transactions.
CheckExpenseItems	Handles QuickBooks Check Expense Line Items, allowing users to create, update, delete, and query detailed expense records.
CheckLineItems	Supports management of individual line items within QuickBooks Checks, including creation, updates, deletion, and queries.
Checks	Manages QuickBooks Checks, allowing users to create, update, delete, and query check transactions for financial tracking.
Class	Facilitates the management of QuickBooks Classes, including creating, updating, deleting, and querying classifications. Updates require QBXML Version 8.0 or higher.
CreditCardChargeExpenseItems	Handles QuickBooks Credit Card Charge Expense Line Items, supporting creation, updates, deletion, and detailed queries.
CreditCardChargeLineItems	Manages individual line items associated with QuickBooks Credit Card Charges, including creation, updates, deletion, and queries.
CreditCardCharges	Manages QuickBooks Credit Card Charges, allowing users to create, update, delete, and query financial transactions.
CreditCardCreditExpenseItems	Supports management of expense items associated with QuickBooks Credit Card Credits, including creation, updates, deletion, and queries.
CreditCardCreditLineItems	Handles individual line items within QuickBooks Credit Card Credits, supporting creation, updates, deletion, and queries.
CreditCardCredits	Manages QuickBooks Credit Card Credits, allowing users to create, update, delete, and query credit transactions for accurate accounting.
CreditCardRefunds	Facilitates the creation and querying of QuickBooks AR Credit Card Refund transactions for managing customer refunds.
CreditMemoLineItems	Manages individual line items within QuickBooks Credit Memos, allowing creation, updates, deletion, and detailed queries.
CreditMemos	Manages QuickBooks Credit Memos, supporting creation, updates, deletion, and queries for issuing and tracking customer credits.
Currency	Handles QuickBooks currency management, including creation, updates, deletion, and querying of supported currencies. Requires QBXML Version 8.0 or higher, with multi-currency enabled.
CustomerContacts	Manages QuickBooks Customer Contacts, allowing creation, updates, deletion, and queries for customer relationship management. Requires QBXML Version 12.0 or higher and is only available in QuickBooks editions 2016 and above.
CustomerMessages	Supports creating, deleting, and querying Customer Messages within QuickBooks to streamline communication.
CustomerNotes	Manages QuickBooks Customer Notes, allowing creation, updates, and queries for tracking customer-specific information. Requires QBXML Version 12.0 or higher.
Customers	Handles QuickBooks Customers, supporting creation, updates, deletion, and queries for managing customer data effectively.
CustomerShippingAddresses	Manages multiple shipping addresses for QuickBooks Customers, including creation, updates, deletion, and queries. Requires QBXML Version 12.0 or higher and is supported in QuickBooks 2013 and higher.
CustomerTypes	Facilitates the management of QuickBooks Customer Types, supporting creation, updates, deletion, and queries to classify customers.
DateDrivenTerms	Supports the creation, deletion, and querying of QuickBooks Date-Driven Terms for payment and invoice schedules.
DepositLineItems	Handles individual line items within QuickBooks Deposits, supporting creation, updates, deletion, and queries. Requires QBXML Version 7.0 or higher.
Deposits	Manages QuickBooks Deposits, allowing users to create, update, delete, and query financial deposits. Requires QBXML Version 7.0 or higher for updates.
EmployeeEarnings	Facilitates the management of QuickBooks Employee Earnings, supporting creation, updates, deletion, and queries for payroll tracking.
Employees	Manages QuickBooks Employees, allowing creation, updates, deletion, and queries for employee records and payroll data.
EstimateLineItems	Manages individual line items within QuickBooks Estimates, supporting creation, updates, deletion, and queries for sales planning.
Estimates	Handles QuickBooks Estimates, including creation, updates, deletion, and queries for tracking potential sales.
InventoryAdjustmentLineItems	Manages individual line items within QuickBooks Inventory Adjustments, supporting creation and queries for stock control.
InventoryAdjustments	Handles QuickBooks Inventory Adjustments, allowing creation, queries, and deletion to reconcile stock discrepancies.
InventorySites	Manages QuickBooks Inventory Sites, including creation, updates, deletion, and queries. Available only in QuickBooks Enterprise with Advanced Inventory and QBXML Version 10.0 or higher.
InvoiceLineItems	Manages individual line items within QuickBooks Invoices, supporting creation, updates, deletion, and queries for billing details.
Invoices	Handles QuickBooks Invoices, supporting creation, updates, deletion, and queries for billing and receivables tracking.
ItemLineItems	Manages individual line items in QuickBooks Items, including creation, updates, deletion, and queries for detailed inventory tracking.
ItemReceiptExpenseItems	Handles QuickBooks Item Receipt Expense Line Items, supporting creation, updates, deletion, and queries for purchase expense tracking.
ItemReceiptLineItems	Manages individual line items within QuickBooks Item Receipts, supporting creation, updates, deletion, and queries for purchase tracking.
ItemReceipts	Handles QuickBooks Item Receipts, supporting creation, updates, deletion, and queries for tracking goods received.
Items	Manages QuickBooks Items, including creation, updates, deletion, and queries for inventory and service tracking.
JobTypes	Manages QuickBooks Job Types, supporting creation and queries to classify customer jobs for better project tracking.
JournalEntries	Handles QuickBooks Journal Entries, supporting creation, updates, deletion, and queries for accounting adjustments. Note: Journal Entry Lines cannot be modified in existing entries.
JournalEntryLines	Manages individual lines within QuickBooks Journal Entries, supporting creation, updates, deletion, and queries for detailed accounting entries.
OtherNames	Manages QuickBooks 'Other Name' entities, allowing creation, updates, deletion, and queries for non-customer or vendor names.
PaymentMethods	Handles QuickBooks Payment Methods, supporting creation, updates, deletion, and queries for payment categorization.
PayrollNonWageItems	Queries non-wage payroll items in QuickBooks, providing insight into additional payroll expenses or deductions.
PayrollWageItems	Manages QuickBooks Wage Payroll Items, supporting creation and queries to streamline wage-based payroll processing.
PriceLevelPerItem	Manages Per-Item Price Levels in QuickBooks, allowing creation and queries of individual item pricing for specific customers. Available in QuickBooks Premier and Enterprise with QBXML Version 4.0 or higher. In addition to adding Per-Item Price Levels, you can also add Price Levels from this table. To delete Price Levels, you must use the PriceLevels table.
PriceLevels	Handles QuickBooks Price Levels, supporting creation, deletion, and queries for fixed-percentage pricing adjustments to a wide range of customers or items. You can add and delete Price Levels from this table, but you can only add fixed-percentage Price Levels. To add more specific per-item price levels, use the PriceLevelPerItem table. This table requires QBXML Version 4.0 or higher.
PurchaseOrderLineItems	Manages individual line items in QuickBooks Purchase Orders, supporting creation, updates, deletion, and queries for procurement tracking.
PurchaseOrders	Handles QuickBooks Purchase Orders, supporting creation, updates, deletion, and queries for supplier management.
ReceivePayments	Manages QuickBooks Receive Payment transactions, supporting creation, updates, deletion, and queries for customer payments. Requires QBXML Version 6.0 or higher.
ReceivePaymentsAppliedTo	Tracks individual transactions to which a QuickBooks Receive Payment is applied, supporting creation, updates, and queries. In a Receive Payment, each AppliedTo aggregate represents the transaction to which this part of the payment is being applied. Requires QBXML Version 6.0 or higher.
SalesOrderLineItems	Manages individual line items in QuickBooks Sales Orders, supporting creation, updates, deletion, and queries for order management.
SalesOrders	Handles QuickBooks Sales Orders, supporting creation, updates, deletion, and queries for tracking customer orders.
SalesReceiptLineItems	Manages individual line items in QuickBooks Sales Receipts, supporting creation, updates, deletion, and queries for detailed sales tracking.
SalesReceipts	Handles QuickBooks Sales Receipts, supporting creation, updates, deletion, and queries for tracking point-of-sale transactions.
SalesReps	Manages QuickBooks Sales Representatives, allowing creation, updates, deletion, and queries for tracking sales activities.
SalesTaxCodes	Handles QuickBooks Sales Tax Codes, supporting creation, updates, deletion, and queries for tax categorization.
SalesTaxItems	Manages QuickBooks Sales Tax Items, supporting creation, updates, deletion, and queries for tax calculations on invoices and sales.
ShippingMethods	Manages QuickBooks Shipping Methods, supporting creation, updates, deletion, and queries for shipping-related information.
StandardTerms	Handles QuickBooks Standard Terms, allowing creation, updates, deletion, and queries for payment terms configuration.
StatementCharges	Manages QuickBooks Statement Charges, supporting creation, updates, deletion, and queries for customer billing statements.
TimeTracking	Manages QuickBooks Time Tracking events, supporting creation, updates, deletion, and queries for employee or job time entries.
ToDo	Handles QuickBooks To-Do entries, supporting creation, updates, deletion, and queries for task management.
TransferInventory	Manages QuickBooks Inventory Transfers, supporting queries and deletion for inventory movement tracking. Available in QuickBooks Enterprise with Advanced Inventory.
TransferInventoryLineItems	Handles individual line items within QuickBooks Inventory Transfers, supporting creation and queries for detailed inventory tracking.
Transfers	Manages QuickBooks Transfers, supporting creation, updates, and queries for tracking movement of funds between accounts. Requires QBXML Version 12.0 or higher.
UnitOfMeasure	Handles QuickBooks Units of Measure, supporting creation, updates, deletion, and queries. Requires QBXML Version 7.0 or higher.
UnitOfMeasureDefaultUnits	Manages default units within QuickBooks Units of Measure, supporting creation and queries for streamlined measurement configurations. Requires QBXML Version 7.0 or higher.
UnitOfMeasureRelatedUnits	Handles related units in QuickBooks Units of Measure, supporting creation and queries for complex measurement systems. Requires QBXML Version 7.0 or higher.
VehicleMileage	Manages QuickBooks Vehicle Mileage, supporting creation, updates, deletion, and queries for mileage tracking. Requires QBXML Version 6.0 or higher.
VendorCreditExpenseItems	Handles QuickBooks Vendor Credit Expense Items, supporting creation, updates, deletion, and queries for tracking expenses linked to vendor credits.
VendorCreditLineItems	Manages individual line items in QuickBooks Vendor Credits, supporting creation, updates, deletion, and queries for detailed vendor credit tracking.
VendorCredits	Handles QuickBooks Vendor Credits, supporting creation, updates, deletion, and queries for managing vendor refunds or adjustments.
Vendors	Manages QuickBooks Vendors, supporting creation, updates, deletion, and queries for supplier relationship management.
VendorTypes	Handles QuickBooks Vendor Types, allowing creation, updates, deletion, and queries for categorizing vendors.
WorkersCompCodeLines	Queries QuickBooks Workers Compensation Code details by line item, providing insight into specific payroll classifications.
WorkersCompCodes	Queries QuickBooks Workers Compensation Codes, providing an overview of payroll classifications. Requires QBXML Version 7.0 or higher.