Quickbooks Pre-mapped Data Warehouse Tables

Pre-mapped ETL+ tables available for Quickbooks as of 03/2021. This list applies to Quickbooks Online. We don’t know (yet) if it also applies to Quickbooks Desktop and Enterprise.

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

RefundReceiptLineItems

Quickbooks

SalesReceiptLineItems

Quickbooks

SalesReceipts

Quickbooks

Transfers

Quickbooks

VendorCreditLineItems

 

In this section