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
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+.

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.