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 Power BI Connector 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. |