Quickbooks Pre-mapped Data Warehouse Tables

Pre-mapped ETL+ tables available for Quickbooks. This list applies to Quickbooks Online. Subject to change without notice.

Source

Table Name

Source

Table Name

Quickbooks

Accounts

Quickbooks

BillLineItems

Quickbooks

BillPaymentLineItems

Quickbooks

CreditMemoLineItems

Quickbooks

CreditMemos

Quickbooks

Customers

Quickbooks

DepositLineItems

Quickbooks

Deposits

Quickbooks

InvoiceLineItems

Quickbooks

Invoices

Quickbooks

Items

Quickbooks

JournalEntries

Quickbooks

JournalEntryLineItems

Quickbooks

PaymentLineItems

Quickbooks

PurchaseLineItems

Quickbooks

PurchaseOrderLineItems

Quickbooks

RecurringCreditMemoTransactions

Quickbooks

RecurringCreditMemoTransactionsLineItems

Quickbooks

RecurringInvoiceTransactions

Quickbooks

RecurringInvoiceTransactionsLineItems

Quickbooks

RecurringSalesReceiptTransactions

Quickbooks

RecurringSalesReceiptTransactionsLineItems

Quickbooks

RefundReceiptLineItems

Quickbooks

SalesReceiptLineItems

Quickbooks

SalesReceipts

Quickbooks

Terms

Quickbooks

Transfers

Quickbooks

VendorCreditLineItems

Quickbooks

Vendors

Data Warehouse

4_Today

Data Warehouse

5_Date

Data Warehouse

AllTransactions_T

Data Warehouse

RecurringLineItems_T

Notes:

  • Some tables above will only be deployed using customized SOWs or via services.

  • Currently, the Quickbook tables are extracted into the data warehouse using ODBC.

  • We only recommend extracting tables that are important for your reporting purposes.

Table Columns Example

DataSelf ETL+ templates include adjustments to table columns' data types and indexes. Click here to learn more.

The following is an example of a Quickbooks table and its column names, indexes, and formatting in ETL+.

image-20240509-042429.png

Delta Load Example

DataSelf ETL+ templates include delta load configuration for popular large tables. This dramatically reduces the time to refresh the data warehouse. ETL+ Table Load Types.

The following is an example using the Upsert feature.

image-20240509-042513.png