QuickBooks (v2) | Stitch Documentation

QuickBooks extraction is supported by Stitch
This integration is powered by Singer's QuickBooks tap and certified by Stitch. Check out and contribute to the repo on GitHub.

For support, contact Stitch support.

QuickBooks integration summary

Stitch’s QuickBooks integration replicates data using the QuickBooks Online API. Refer to the Schema section for a list of objects available for replication.

Note: Currently, replicating data from QuickBooks desktop apps isn’t supported.

QuickBooks feature snapshot

A high-level look at Stitch's QuickBooks (v2) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status	Released on November 30, 2022	Supported by	Stitch
Stitch plan	Standard	API availability	Available
Singer GitHub repository	singer-io/tap-quickbooks
REPLICATION SETTINGS
Anchor Scheduling	Supported	Advanced Scheduling	Supported
Table-level reset	Unsupported	Configurable Replication Methods	Unsupported
DATA SELECTION
Table selection	Supported	Column selection	Supported
Select all	Supported
TRANSPARENCY
Extraction Logs	Supported	Loading Reports	Supported

Connecting QuickBooks

QuickBooks setup requirements

To set up QuickBooks in Stitch, you need:

An online QuickBooks instance. Desktop instances aren’t currently supported.

Step 1: Add QuickBooks as a Stitch data source

Sign into your Stitch account.
On the Stitch Dashboard page, click the Add Integration button.
Click the QuickBooks icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

For example, the name “Stitch QuickBooks” would create a schema called stitch_quickbooks in the destination. Note: Schema names cannot be changed after you save the integration.

Step 2: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your QuickBooks integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond QuickBooks’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 3: Create a replication schedule

Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the Replication Scheduling documentation for more information.

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

QuickBooks integrations support the following replication scheduling methods:

Replication Frequency
Anchor Scheduling
Advanced Scheduling using Cron (Advanced or Premium plans only)

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Authorize Stitch to access QuickBooks

Lastly, you’ll be directed to QuickBooks’ website to complete the setup.

If you’re not already signed into your QuickBooks account, enter your credentials and click Login.
A screen asking for authorization to QuickBooks will display.
Click Authorize.
After the authorization process successfully completes, you’ll be redirected back to Stitch.
Click All Done.

Step 5: Set objects to replicate

Is an object missing or not replicating? Verify that the object meets the requirements for selection and replication.

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For QuickBooks integrations, you can select:

Individual tables and columns
All tables and columns

Click the tabs to view instructions for each selection method.

In the integration’s Tables to Replicate tab, locate a table you want to replicate.
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
Repeat this process for all the tables and columns you want to replicate.
When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.

Important: Using the Select All feature will overwrite any previous selections. However, selections aren’t final until Finalize Your Selections is clicked. Clicking Cancel will restore your previous selections. Refer to the Select All guide for more info about this feature.

Click into the integration from the Stitch Dashboard page.
Click the Tables to Replicate tab.
In the list of tables, click the box next to the Table Names column.
In the menu that displays, click Track all Tables and Fields:
Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up QuickBooks, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Initial replication jobs with Anchor Scheduling

If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Replication will continue after the seven days are over. If you’re no longer interested in this source, be sure to pause or delete the integration to prevent unwanted usage.

QuickBooks table reference

Schemas and versioning

Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.

The schema and info displayed below is for version 2 of this integration.

This is the latest version of the QuickBooks integration.

Table and column names in your destination

Depending on your destination, table and column names may not appear as they are outlined below.

For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.

accounts

The accounts table contains info about the various account types in you QuickBooks instance. This table includes all account types: asset, liability, revenue (income), expenses, and equity.

Note: Both active and inactive accounts are included in the data for this table.

Replication Method

Key-based Incremental

Primary Key

Useful links

QuickBooks documentation

accounts schema on GitHub

QuickBooks API method

accounts table foreign keys

Join accounts with	on
bill_payments	accounts.Id = bill_payments.APAccountRef.value accounts.ParentRef.value = bill_payments.APAccountRef.value accounts.Id = bill_payments.CheckPayment.BankAccountRef.value accounts.ParentRef.value = bill_payments.CheckPayment.BankAccountRef.value accounts.Id = bill_payments.CreditCardPayment.CCAccountRef.value accounts.ParentRef.value = bill_payments.CreditCardPayment.CCAccountRef.value accounts.CurrencyRef.value = bill_payments.CurrencyRef.value
bills	accounts.Id = bills.APAccountRef.value accounts.ParentRef.value = bills.APAccountRef.value accounts.Id = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value accounts.ParentRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value accounts.CurrencyRef.value = bills.CurrencyRef.value
budgets	accounts.Id = budgets.BudgetDetail.AccountRef.value accounts.ParentRef.value = budgets.BudgetDetail.AccountRef.value
deposits	accounts.Id = deposits.CashBack.AccountRef.value accounts.ParentRef.value = deposits.CashBack.AccountRef.value accounts.Id = deposits.DepositToAccountRef.value accounts.ParentRef.value = deposits.DepositToAccountRef.value accounts.Id = deposits.Line.DepositLineDetail.AccountRef.value accounts.ParentRef.value = deposits.Line.DepositLineDetail.AccountRef.value accounts.CurrencyRef.value = deposits.CurrencyRef.value
invoices	accounts.Id = invoices.DepositToAccountRef.value accounts.ParentRef.value = invoices.DepositToAccountRef.value accounts.Id = invoices.Line.DiscountLineDetail.DiscountAccountRef.value accounts.ParentRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value accounts.CurrencyRef.value = invoices.CurrencyRef.value
items	accounts.Id = items.AssetAccountRef.value accounts.ParentRef.value = items.AssetAccountRef.value accounts.Id = items.ExpenseAccountRef.value accounts.ParentRef.value = items.ExpenseAccountRef.value accounts.Id = items.IncomeAccountRef.value accounts.ParentRef.value = items.IncomeAccountRef.value
journal_entries	accounts.Id = journal_entries.Line.JournalEntryLineDetail.AccountRef.value accounts.ParentRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value accounts.CurrencyRef.value = journal_entries.CurrencyRef.value
payments	accounts.Id = payments.DepositToAccountRef.value accounts.ParentRef.value = payments.DepositToAccountRef.value accounts.CurrencyRef.value = payments.CurrencyRef.value
purchase_orders	accounts.Id = purchase_orders.APAccountRef.value accounts.ParentRef.value = purchase_orders.APAccountRef.value accounts.CurrencyRef.value = purchase_orders.CurrencyRef.value
purchases	accounts.Id = purchases.AccountRef.value accounts.ParentRef.value = purchases.AccountRef.value accounts.Id = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value accounts.ParentRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value accounts.CurrencyRef.value = purchases.CurrencyRef.value
refund_receipts	accounts.Id = refund_receipts.DepositToAccountRef.value accounts.ParentRef.value = refund_receipts.DepositToAccountRef.value accounts.CurrencyRef.value = refund_receipts.CurrencyRef.value
sales_receipts	accounts.Id = sales_receipts.DepositToAccountRef.value accounts.ParentRef.value = sales_receipts.DepositToAccountRef.value accounts.Id = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value accounts.ParentRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value accounts.CurrencyRef.value = sales_receipts.CurrencyRef.value
transfers	accounts.Id = transfers.FromAccountRef.value accounts.ParentRef.value = transfers.FromAccountRef.value accounts.Id = transfers.ToAccountRef.value accounts.ParentRef.value = transfers.ToAccountRef.value accounts.CurrencyRef.value = transfers.CurrencyRef.value
vendor_credits	accounts.Id = vendor_credits.APAccountRef.value accounts.ParentRef.value = vendor_credits.APAccountRef.value accounts.Id = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value accounts.ParentRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value accounts.CurrencyRef.value = vendor_credits.CurrencyRef.value
credit_memos	accounts.CurrencyRef.value = credit_memos.CurrencyRef.value
customers	accounts.CurrencyRef.value = customers.CurrencyRef.value
estimates	accounts.CurrencyRef.value = estimates.CurrencyRef.value
vendors	accounts.CurrencyRef.value = vendors.CurrencyRef.value

accounts table schema

AccountAlias

STRING

AccountSubType

STRING

AccountType

STRING

AcctNum

STRING

Active

BOOLEAN

Classification

STRING

CurrencyRef

OBJECT

Click to expand CurrencyRef

name

STRING

value

STRING

CurrentBalance

NUMBER

CurrentBalanceWithSubAccounts

NUMBER

Description

STRING

FullyQualifiedName

STRING

MetaData

OBJECT

Click to expand MetaData

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

Name

STRING

ParentRef

OBJECT

Click to expand ParentRef

name

STRING

value

STRING

SubAccount

BOOLEAN

SyncToken

STRING

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

TxnLocationType

STRING

domain

STRING

bill_payments

The bill_payments table contains info about payments made on bills received from vendors for goods or services.

Replication Method

Key-based Incremental

Primary Key

Useful links

QuickBooks documentation

bill_payments schema on GitHub

QuickBooks API method

bill_payments table foreign keys

Join bill_payments with	on
accounts	bill_payments.APAccountRef.value = accounts.Id bill_payments.CheckPayment.BankAccountRef.value = accounts.Id bill_payments.CreditCardPayment.CCAccountRef.value = accounts.Id bill_payments.APAccountRef.value = accounts.ParentRef.value bill_payments.CheckPayment.BankAccountRef.value = accounts.ParentRef.value bill_payments.CreditCardPayment.CCAccountRef.value = accounts.ParentRef.value bill_payments.CurrencyRef.value = accounts.CurrencyRef.value
bills	bill_payments.APAccountRef.value = bills.APAccountRef.value bill_payments.CheckPayment.BankAccountRef.value = bills.APAccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = bills.APAccountRef.value bill_payments.APAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value bill_payments.CheckPayment.BankAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value bill_payments.Id = bills.LinkedTxn.TxnId bill_payments.Line.LinkedTxn.TxnId = bills.Id bill_payments.CurrencyRef.value = bills.CurrencyRef.value bill_payments.DepartmentRef.value = bills.DepartmentRef.value bill_payments.VendorRef.value = bills.VendorRef.value
budgets	bill_payments.APAccountRef.value = budgets.BudgetDetail.AccountRef.value bill_payments.CheckPayment.BankAccountRef.value = budgets.BudgetDetail.AccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = budgets.BudgetDetail.AccountRef.value bill_payments.DepartmentRef.value = budgets.BudgetDetail.DepartmentRef.value
deposits	bill_payments.APAccountRef.value = deposits.CashBack.AccountRef.value bill_payments.CheckPayment.BankAccountRef.value = deposits.CashBack.AccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = deposits.CashBack.AccountRef.value bill_payments.APAccountRef.value = deposits.DepositToAccountRef.value bill_payments.CheckPayment.BankAccountRef.value = deposits.DepositToAccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = deposits.DepositToAccountRef.value bill_payments.APAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value bill_payments.CheckPayment.BankAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value bill_payments.CurrencyRef.value = deposits.CurrencyRef.value bill_payments.DepartmentRef.value = deposits.DepartmentRef.value bill_payments.Line.LinkedTxn.TxnId = deposits.Line.LinkedTxn.TxnId
invoices	bill_payments.APAccountRef.value = invoices.DepositToAccountRef.value bill_payments.CheckPayment.BankAccountRef.value = invoices.DepositToAccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = invoices.DepositToAccountRef.value bill_payments.APAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value bill_payments.CheckPayment.BankAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value bill_payments.CurrencyRef.value = invoices.CurrencyRef.value bill_payments.DepartmentRef.value = invoices.DepartmentRef.value
items	bill_payments.APAccountRef.value = items.AssetAccountRef.value bill_payments.CheckPayment.BankAccountRef.value = items.AssetAccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = items.AssetAccountRef.value bill_payments.APAccountRef.value = items.ExpenseAccountRef.value bill_payments.CheckPayment.BankAccountRef.value = items.ExpenseAccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = items.ExpenseAccountRef.value bill_payments.APAccountRef.value = items.IncomeAccountRef.value bill_payments.CheckPayment.BankAccountRef.value = items.IncomeAccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = items.IncomeAccountRef.value bill_payments.VendorRef.value = items.PrefVendorRef.value
journal_entries	bill_payments.APAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value bill_payments.CheckPayment.BankAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value bill_payments.CurrencyRef.value = journal_entries.CurrencyRef.value bill_payments.Line.LinkedTxn.TxnId = journal_entries.Id
payments	bill_payments.APAccountRef.value = payments.DepositToAccountRef.value bill_payments.CheckPayment.BankAccountRef.value = payments.DepositToAccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = payments.DepositToAccountRef.value bill_payments.CurrencyRef.value = payments.CurrencyRef.value
purchase_orders	bill_payments.APAccountRef.value = purchase_orders.APAccountRef.value bill_payments.CheckPayment.BankAccountRef.value = purchase_orders.APAccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = purchase_orders.APAccountRef.value bill_payments.Line.LinkedTxn.TxnId = purchase_orders.LinkedTxn.TxnId bill_payments.CurrencyRef.value = purchase_orders.CurrencyRef.value bill_payments.DepartmentRef.value = purchase_orders.DepartmentRef.value bill_payments.Id = purchase_orders.Id bill_payments.VendorRef.value = purchase_orders.VendorRef.value
purchases	bill_payments.APAccountRef.value = purchases.AccountRef.value bill_payments.CheckPayment.BankAccountRef.value = purchases.AccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = purchases.AccountRef.value bill_payments.APAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value bill_payments.CheckPayment.BankAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value bill_payments.CurrencyRef.value = purchases.CurrencyRef.value bill_payments.DepartmentRef.value = purchases.DepartmentRef.value
refund_receipts	bill_payments.APAccountRef.value = refund_receipts.DepositToAccountRef.value bill_payments.CheckPayment.BankAccountRef.value = refund_receipts.DepositToAccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = refund_receipts.DepositToAccountRef.value bill_payments.CurrencyRef.value = refund_receipts.CurrencyRef.value bill_payments.DepartmentRef.value = refund_receipts.DepartmentRef.value
sales_receipts	bill_payments.APAccountRef.value = sales_receipts.DepositToAccountRef.value bill_payments.CheckPayment.BankAccountRef.value = sales_receipts.DepositToAccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = sales_receipts.DepositToAccountRef.value bill_payments.APAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value bill_payments.CheckPayment.BankAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value bill_payments.CurrencyRef.value = sales_receipts.CurrencyRef.value bill_payments.DepartmentRef.value = sales_receipts.DepartmentRef.value
transfers	bill_payments.APAccountRef.value = transfers.FromAccountRef.value bill_payments.CheckPayment.BankAccountRef.value = transfers.FromAccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = transfers.FromAccountRef.value bill_payments.APAccountRef.value = transfers.ToAccountRef.value bill_payments.CheckPayment.BankAccountRef.value = transfers.ToAccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = transfers.ToAccountRef.value bill_payments.CurrencyRef.value = transfers.CurrencyRef.value
vendor_credits	bill_payments.APAccountRef.value = vendor_credits.APAccountRef.value bill_payments.CheckPayment.BankAccountRef.value = vendor_credits.APAccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = vendor_credits.APAccountRef.value bill_payments.APAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value bill_payments.CheckPayment.BankAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value bill_payments.CreditCardPayment.CCAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value bill_payments.CurrencyRef.value = vendor_credits.CurrencyRef.value bill_payments.DepartmentRef.value = vendor_credits.DepartmentRef.value bill_payments.Line.LinkedTxn.TxnId = vendor_credits.Id bill_payments.VendorRef.value = vendor_credits.VendorRef.value
credit_memos	bill_payments.CurrencyRef.value = credit_memos.CurrencyRef.value
customers	bill_payments.CurrencyRef.value = customers.CurrencyRef.value
estimates	bill_payments.CurrencyRef.value = estimates.CurrencyRef.value bill_payments.DepartmentRef.value = estimates.DepartmentRef.value
vendors	bill_payments.CurrencyRef.value = vendors.CurrencyRef.value bill_payments.VendorRef.value = vendors.Id
departments	bill_payments.DepartmentRef.value = departments.ParentRef.value bill_payments.DepartmentRef.value = departments.Id
time_activities	bill_payments.DepartmentRef.value = time_activities.DepartmentRef.value bill_payments.VendorRef.value = time_activities.VendorRef.value

bill_payments table schema

APAccountRef

OBJECT

Click to expand APAccountRef

name

STRING

value

STRING

CheckPayment

OBJECT

Click to expand CheckPayment

BankAccountRef

OBJECT

Click to expand BankAccountRef

name

STRING

value

STRING

PrintStatus

STRING

CreditCardPayment

OBJECT

Click to expand CreditCardPayment

CCAccountRef

OBJECT

Click to expand CCAccountRef

name

STRING

value

STRING

CurrencyRef

OBJECT

Click to expand CurrencyRef

name

STRING

value

STRING

DepartmentRef

OBJECT

Click to expand DepartmentRef

name

STRING

value

STRING

DocNumber

STRING

ExchangeRate

NUMBER

STRING

Line

ARRAY

Click to expand Line

Amount

NUMBER

LinkedTxn

ARRAY

Click to expand LinkedTxn

TxnId

STRING

TxnLineId

STRING

TxnType

STRING

MetaData

OBJECT

Click to expand MetaData

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

PayType

STRING

PrivateNote

STRING

ProcessBillPayment

BOOLEAN

SyncToken

STRING

TotalAmt

NUMBER

TransactionLocationType

STRING

TxnDate

DATE-TIME

VendorRef

OBJECT

Click to expand VendorRef

name

STRING

value

STRING

domain

STRING

bills

The bills table contains info about the bills, or requests for payment from third parties, in your QuickBooks instance.

Replication Method

Key-based Incremental

Primary Key

Useful links

QuickBooks documentation

bills schema on GitHub

QuickBooks API method

bills table foreign keys

Join bills with	on
accounts	bills.APAccountRef.value = accounts.Id bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = accounts.Id bills.APAccountRef.value = accounts.ParentRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = accounts.ParentRef.value bills.CurrencyRef.value = accounts.CurrencyRef.value
bill_payments	bills.APAccountRef.value = bill_payments.APAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = bill_payments.APAccountRef.value bills.APAccountRef.value = bill_payments.CheckPayment.BankAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = bill_payments.CheckPayment.BankAccountRef.value bills.APAccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value bills.LinkedTxn.TxnId = bill_payments.Id bills.Id = bill_payments.Line.LinkedTxn.TxnId bills.CurrencyRef.value = bill_payments.CurrencyRef.value bills.DepartmentRef.value = bill_payments.DepartmentRef.value bills.VendorRef.value = bill_payments.VendorRef.value
budgets	bills.APAccountRef.value = budgets.BudgetDetail.AccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = budgets.BudgetDetail.AccountRef.value bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value = budgets.BudgetDetail.CustomerRef.value bills.DepartmentRef.value = budgets.BudgetDetail.DepartmentRef.value
deposits	bills.APAccountRef.value = deposits.CashBack.AccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = deposits.CashBack.AccountRef.value bills.APAccountRef.value = deposits.DepositToAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = deposits.DepositToAccountRef.value bills.APAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value bills.CurrencyRef.value = deposits.CurrencyRef.value bills.DepartmentRef.value = deposits.DepartmentRef.value
invoices	bills.APAccountRef.value = invoices.DepositToAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = invoices.DepositToAccountRef.value bills.APAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value bills.CurrencyRef.value = invoices.CurrencyRef.value bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value = invoices.CustomerRef.value bills.DepartmentRef.value = invoices.DepartmentRef.value bills.Line.ItemBasedExpenseLineDetail.ItemRef.value = invoices.Line.SalesItemLineDetail.ItemRef.value bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = invoices.Line.SalesItemLineDetail.TaxCodeRef.value bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = invoices.Line.SalesItemLineDetail.TaxCodeRef.value bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = invoices.TxnTaxDetail.TxnTaxCodeRef.value bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = invoices.TxnTaxDetail.TxnTaxCodeRef.value bills.SalesTermRef.value = invoices.SalesTermRef.value
items	bills.APAccountRef.value = items.AssetAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = items.AssetAccountRef.value bills.APAccountRef.value = items.ExpenseAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = items.ExpenseAccountRef.value bills.APAccountRef.value = items.IncomeAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = items.IncomeAccountRef.value bills.Line.ItemBasedExpenseLineDetail.ItemRef.value = items.Id bills.Line.ItemBasedExpenseLineDetail.ItemRef.value = items.ParentRef.value bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = items.PurchaseTaxCodeRef.value bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = items.PurchaseTaxCodeRef.value bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = items.SalesTaxCodeRef.value bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = items.SalesTaxCodeRef.value bills.VendorRef.value = items.PrefVendorRef.value
journal_entries	bills.APAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value bills.CurrencyRef.value = journal_entries.CurrencyRef.value bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value bills.Id = journal_entries.Id
payments	bills.APAccountRef.value = payments.DepositToAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = payments.DepositToAccountRef.value bills.CurrencyRef.value = payments.CurrencyRef.value bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value = payments.CustomerRef.value
purchase_orders	bills.APAccountRef.value = purchase_orders.APAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = purchase_orders.APAccountRef.value bills.Id = purchase_orders.LinkedTxn.TxnId bills.CurrencyRef.value = purchase_orders.CurrencyRef.value bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value bills.DepartmentRef.value = purchase_orders.DepartmentRef.value bills.Line.ItemBasedExpenseLineDetail.ItemRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value bills.LinkedTxn.TxnId = purchase_orders.Id bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value bills.SalesTermRef.value = purchase_orders.SalesTermRef.value bills.VendorRef.value = purchase_orders.VendorRef.value
purchases	bills.APAccountRef.value = purchases.AccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = purchases.AccountRef.value bills.APAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value bills.CurrencyRef.value = purchases.CurrencyRef.value bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value = purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value bills.DepartmentRef.value = purchases.DepartmentRef.value bills.Line.ItemBasedExpenseLineDetail.ItemRef.value = purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value
refund_receipts	bills.APAccountRef.value = refund_receipts.DepositToAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = refund_receipts.DepositToAccountRef.value bills.CurrencyRef.value = refund_receipts.CurrencyRef.value bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value = refund_receipts.CustomerRef.value bills.DepartmentRef.value = refund_receipts.DepartmentRef.value bills.Line.ItemBasedExpenseLineDetail.ItemRef.value = refund_receipts.Line.SalesItemLineDetail.ItemRef.value bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value
sales_receipts	bills.APAccountRef.value = sales_receipts.DepositToAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = sales_receipts.DepositToAccountRef.value bills.APAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value bills.CurrencyRef.value = sales_receipts.CurrencyRef.value bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value = sales_receipts.CustomerRef.value bills.DepartmentRef.value = sales_receipts.DepartmentRef.value bills.Line.ItemBasedExpenseLineDetail.ItemRef.value = sales_receipts.Line.SalesItemLineDetail.ItemRef.value bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value
transfers	bills.APAccountRef.value = transfers.FromAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = transfers.FromAccountRef.value bills.APAccountRef.value = transfers.ToAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = transfers.ToAccountRef.value bills.CurrencyRef.value = transfers.CurrencyRef.value
vendor_credits	bills.APAccountRef.value = vendor_credits.APAccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = vendor_credits.APAccountRef.value bills.APAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value bills.Line.AccountBasedExpenseLineDetail.AccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value bills.CurrencyRef.value = vendor_credits.CurrencyRef.value bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value bills.DepartmentRef.value = vendor_credits.DepartmentRef.value bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value bills.Id = vendor_credits.Id bills.VendorRef.value = vendor_credits.VendorRef.value
credit_memos	bills.CurrencyRef.value = credit_memos.CurrencyRef.value bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value = credit_memos.CustomerRef.value bills.Line.ItemBasedExpenseLineDetail.ItemRef.value = credit_memos.Line.SalesItemLineDetail.ItemRef.value bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value bills.SalesTermRef.value = credit_memos.SalesTermRef.value
customers	bills.CurrencyRef.value = customers.CurrencyRef.value bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value = customers.Id bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = customers.DefaultTaxCodeRef.value bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = customers.DefaultTaxCodeRef.value bills.SalesTermRef.value = customers.SalesTermRef.value
estimates	bills.CurrencyRef.value = estimates.CurrencyRef.value bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value = estimates.CustomerRef.value bills.DepartmentRef.value = estimates.DepartmentRef.value bills.Line.ItemBasedExpenseLineDetail.ItemRef.value = estimates.Line.SalesItemLineDetail.ItemRef.value bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = estimates.Line.SalesItemLineDetail.TaxCodeRef.value bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = estimates.Line.SalesItemLineDetail.TaxCodeRef.value bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = estimates.TxnTaxDetail.TxnTaxCodeRef.value bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = estimates.TxnTaxDetail.TxnTaxCodeRef.value bills.SalesTermRef.value = estimates.SalesTermRef.value
vendors	bills.CurrencyRef.value = vendors.CurrencyRef.value bills.VendorRef.value = vendors.Id
departments	bills.DepartmentRef.value = departments.ParentRef.value bills.DepartmentRef.value = departments.Id
time_activities	bills.DepartmentRef.value = time_activities.DepartmentRef.value bills.Line.ItemBasedExpenseLineDetail.ItemRef.value = time_activities.ItemRef.value bills.VendorRef.value = time_activities.VendorRef.value
terms	bills.SalesTermRef.value = terms.Id

bills table schema

APAccountRef

OBJECT

Click to expand APAccountRef

name

STRING

value

STRING

Balance

NUMBER

CurrencyRef

OBJECT

Click to expand CurrencyRef

name

STRING

value

STRING

DepartmentRef

OBJECT

Click to expand DepartmentRef

name

STRING

value

STRING

DocNumber

STRING

DueDate

DATE-TIME

ExchangeRate

NUMBER

GlobalTaxCalculation

STRING

HomeBalance

NUMBER

STRING

IncludeInAnnualTPAR

BOOLEAN

Line

ARRAY

Click to expand Line

AccountBasedExpenseLineDetail

OBJECT

Click to expand AccountBasedExpenseLineDetail

AccountRef

OBJECT

Click to expand AccountRef

name

STRING

value

STRING

BillableStatus

STRING

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

CustomerRef

OBJECT

Click to expand CustomerRef

name

STRING

value

STRING

MarkupInfo

OBJECT

Click to expand MarkupInfo

MarkUpIncomeAccountRef

OBJECT

Click to expand MarkUpIncomeAccountRef

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

Click to expand PriceLevelRef

name

STRING

value

STRING

TaxAmount

NUMBER

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

Amount

NUMBER

Description

STRING

DetailType

STRING

ItemBasedExpenseLineDetail

OBJECT

Click to expand ItemBasedExpenseLineDetail

BillableStatus

STRING

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

CustomerRef

OBJECT

Click to expand CustomerRef

name

STRING

value

STRING

ItemRef

OBJECT

Click to expand ItemRef

name

STRING

value

STRING

MarkupInfo

OBJECT

Click to expand MarkupInfo

MarkUpIncomeAccountRef

OBJECT

Click to expand MarkUpIncomeAccountRef

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

Click to expand PriceLevelRef

name

STRING

value

STRING

PriceLevelRef

OBJECT

Click to expand PriceLevelRef

name

STRING

value

STRING

Qty

INTEGER

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

UnitPrice

NUMBER

LineNum

INTEGER

LinkedTxn

ARRAY

Click to expand LinkedTxn

TxnId

STRING

TxnLineId

STRING

TxnType

STRING

LinkedTxn

ARRAY

Click to expand LinkedTxn

TxnId

STRING

TxnLineId

STRING

TxnType

STRING

MetaData

OBJECT

Click to expand MetaData

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

PrivateNote

STRING

RecurDataRef

OBJECT

Click to expand RecurDataRef

name

STRING

value

STRING

SalesTermRef

OBJECT

Click to expand SalesTermRef

name

STRING

value

STRING

SyncToken

STRING

TotalAmt

NUMBER

TransactionLocationType

STRING

TxnDate

DATE-TIME

TxnTaxDetail

OBJECT

Click to expand TxnTaxDetail

TaxLine

ARRAY

Click to expand TaxLine

Amount

NUMBER

DetailType

STRING

TaxLineDetail

OBJECT

Click to expand TaxLineDetail

NetAmountTaxable

NUMBER

OverrideDeltaAmount

NUMBER

PercentBased

BOOLEAN

TaxInclusiveAmount

NUMBER

TaxPercent

NUMBER

TaxRateRef

OBJECT

Click to expand TaxRateRef

name

STRING

value

STRING

TotalTax

NUMBER

TxnTaxCodeRef

OBJECT

Click to expand TxnTaxCodeRef

name

STRING

value

STRING

VendorRef

OBJECT

Click to expand VendorRef

name

STRING

value

STRING

domain

STRING

budgets

The budgets table contains info about the current state of budgets in your QuickBooks instance. Note: Both active and inactive budgets are included in the data for this table.

Replication Method

Key-based Incremental

Primary Key

Useful links

QuickBooks documentation

budgets schema on GitHub

QuickBooks API method

budgets table foreign keys

Join budgets with	on
accounts	budgets.BudgetDetail.AccountRef.value = accounts.Id budgets.BudgetDetail.AccountRef.value = accounts.ParentRef.value
bill_payments	budgets.BudgetDetail.AccountRef.value = bill_payments.APAccountRef.value budgets.BudgetDetail.AccountRef.value = bill_payments.CheckPayment.BankAccountRef.value budgets.BudgetDetail.AccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value budgets.BudgetDetail.DepartmentRef.value = bill_payments.DepartmentRef.value
bills	budgets.BudgetDetail.AccountRef.value = bills.APAccountRef.value budgets.BudgetDetail.AccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value budgets.BudgetDetail.CustomerRef.value = bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value budgets.BudgetDetail.DepartmentRef.value = bills.DepartmentRef.value
deposits	budgets.BudgetDetail.AccountRef.value = deposits.CashBack.AccountRef.value budgets.BudgetDetail.AccountRef.value = deposits.DepositToAccountRef.value budgets.BudgetDetail.AccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value budgets.BudgetDetail.DepartmentRef.value = deposits.DepartmentRef.value
invoices	budgets.BudgetDetail.AccountRef.value = invoices.DepositToAccountRef.value budgets.BudgetDetail.AccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value budgets.BudgetDetail.ClassRef.value = invoices.ClassRef.value budgets.BudgetDetail.ClassRef.value = invoices.Line.SalesItemLineDetail.ClassRef.value budgets.BudgetDetail.CustomerRef.value = invoices.CustomerRef.value budgets.BudgetDetail.DepartmentRef.value = invoices.DepartmentRef.value
items	budgets.BudgetDetail.AccountRef.value = items.AssetAccountRef.value budgets.BudgetDetail.AccountRef.value = items.ExpenseAccountRef.value budgets.BudgetDetail.AccountRef.value = items.IncomeAccountRef.value budgets.BudgetDetail.ClassRef.value = items.ClassRef.value
journal_entries	budgets.BudgetDetail.AccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value
payments	budgets.BudgetDetail.AccountRef.value = payments.DepositToAccountRef.value budgets.BudgetDetail.CustomerRef.value = payments.CustomerRef.value
purchase_orders	budgets.BudgetDetail.AccountRef.value = purchase_orders.APAccountRef.value budgets.BudgetDetail.ClassRef.value = purchase_orders.ClassRef.value budgets.BudgetDetail.ClassRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value budgets.BudgetDetail.CustomerRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value budgets.BudgetDetail.DepartmentRef.value = purchase_orders.DepartmentRef.value
purchases	budgets.BudgetDetail.AccountRef.value = purchases.AccountRef.value budgets.BudgetDetail.AccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value budgets.BudgetDetail.ClassRef.value = purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value budgets.BudgetDetail.CustomerRef.value = purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value budgets.BudgetDetail.DepartmentRef.value = purchases.DepartmentRef.value
refund_receipts	budgets.BudgetDetail.AccountRef.value = refund_receipts.DepositToAccountRef.value budgets.BudgetDetail.ClassRef.value = refund_receipts.ClassRef.value budgets.BudgetDetail.CustomerRef.value = refund_receipts.CustomerRef.value budgets.BudgetDetail.DepartmentRef.value = refund_receipts.DepartmentRef.value
sales_receipts	budgets.BudgetDetail.AccountRef.value = sales_receipts.DepositToAccountRef.value budgets.BudgetDetail.AccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value budgets.BudgetDetail.ClassRef.value = sales_receipts.ClassRef.value budgets.BudgetDetail.CustomerRef.value = sales_receipts.CustomerRef.value budgets.BudgetDetail.DepartmentRef.value = sales_receipts.DepartmentRef.value
transfers	budgets.BudgetDetail.AccountRef.value = transfers.FromAccountRef.value budgets.BudgetDetail.AccountRef.value = transfers.ToAccountRef.value
vendor_credits	budgets.BudgetDetail.AccountRef.value = vendor_credits.APAccountRef.value budgets.BudgetDetail.AccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value budgets.BudgetDetail.ClassRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value budgets.BudgetDetail.CustomerRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value budgets.BudgetDetail.DepartmentRef.value = vendor_credits.DepartmentRef.value
classes	budgets.BudgetDetail.ClassRef.value = classes.Id budgets.BudgetDetail.ClassRef.value = classes.ParentRef.value
credit_memos	budgets.BudgetDetail.ClassRef.value = credit_memos.ClassRef.value budgets.BudgetDetail.CustomerRef.value = credit_memos.CustomerRef.value
estimates	budgets.BudgetDetail.ClassRef.value = estimates.ClassRef.value budgets.BudgetDetail.CustomerRef.value = estimates.CustomerRef.value budgets.BudgetDetail.DepartmentRef.value = estimates.DepartmentRef.value
time_activities	budgets.BudgetDetail.ClassRef.value = time_activities.ClassRef.value budgets.BudgetDetail.DepartmentRef.value = time_activities.DepartmentRef.value
customers	budgets.BudgetDetail.CustomerRef.value = customers.Id
departments	budgets.BudgetDetail.DepartmentRef.value = departments.ParentRef.value budgets.BudgetDetail.DepartmentRef.value = departments.Id

budgets table schema

Active

BOOLEAN

BudgetDetail

ARRAY

Click to expand BudgetDetail

AccountRef

OBJECT

Click to expand AccountRef

name

STRING

value

STRING

Amount

NUMBER

BudgetDate

DATE-TIME

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

CustomerRef

OBJECT

Click to expand CustomerRef

name

STRING

value

STRING

DepartmentRef

OBJECT

Click to expand DepartmentRef

name

STRING

value

STRING

BudgetEntryType

STRING

BudgetType

STRING

EndDate

DATE-TIME

STRING

MetaData

OBJECT

Click to expand MetaData

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

Name

STRING

StartDate

DATE-TIME

SyncToken

STRING

domain

STRING

classes

The classes table contains info about the classes set up in your QuickBooks instance. Note: Both active and inactive classes are included in the data for this table.

Replication Method

Key-based Incremental

Primary Key

Useful links

QuickBooks documentation

classes schema on GitHub

QuickBooks API method

classes table foreign keys

Join classes with	on
budgets	classes.Id = budgets.BudgetDetail.ClassRef.value classes.ParentRef.value = budgets.BudgetDetail.ClassRef.value
credit_memos	classes.Id = credit_memos.ClassRef.value classes.ParentRef.value = credit_memos.ClassRef.value
estimates	classes.Id = estimates.ClassRef.value classes.ParentRef.value = estimates.ClassRef.value
invoices	classes.Id = invoices.ClassRef.value classes.ParentRef.value = invoices.ClassRef.value classes.Id = invoices.Line.SalesItemLineDetail.ClassRef.value classes.ParentRef.value = invoices.Line.SalesItemLineDetail.ClassRef.value
items	classes.Id = items.ClassRef.value classes.ParentRef.value = items.ClassRef.value
purchase_orders	classes.Id = purchase_orders.ClassRef.value classes.ParentRef.value = purchase_orders.ClassRef.value classes.Id = purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value classes.ParentRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value
purchases	classes.Id = purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value classes.ParentRef.value = purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value
refund_receipts	classes.Id = refund_receipts.ClassRef.value classes.ParentRef.value = refund_receipts.ClassRef.value
sales_receipts	classes.Id = sales_receipts.ClassRef.value classes.ParentRef.value = sales_receipts.ClassRef.value
time_activities	classes.Id = time_activities.ClassRef.value classes.ParentRef.value = time_activities.ClassRef.value
vendor_credits	classes.Id = vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value classes.ParentRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value

classes table schema

Active

BOOLEAN

FullyQualifiedName

STRING

MetaData

OBJECT

Click to expand MetaData

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

Name

STRING

ParentRef

OBJECT

Click to expand ParentRef

name

STRING

value

STRING

SubClass

BOOLEAN

SyncToken

STRING

domain

STRING

credit_memos

The credit_memos table contains info about the credit memos in your QuickBooks instance. A credit memo is a transaction representing a refund or credit of payment for goods or services that have been sold.

Replication Method

Key-based Incremental

Primary Key

Useful links

QuickBooks documentation

credit_memos schema on GitHub

QuickBooks API method

credit_memos table foreign keys

Join credit_memos with	on
budgets	credit_memos.ClassRef.value = budgets.BudgetDetail.ClassRef.value credit_memos.CustomerRef.value = budgets.BudgetDetail.CustomerRef.value
classes	credit_memos.ClassRef.value = classes.Id credit_memos.ClassRef.value = classes.ParentRef.value
estimates	credit_memos.ClassRef.value = estimates.ClassRef.value credit_memos.CurrencyRef.value = estimates.CurrencyRef.value credit_memos.CustomerRef.value = estimates.CustomerRef.value credit_memos.Line.SalesItemLineDetail.ItemRef.value = estimates.Line.SalesItemLineDetail.ItemRef.value credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = estimates.Line.SalesItemLineDetail.TaxCodeRef.value credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = estimates.TxnTaxDetail.TxnTaxCodeRef.value credit_memos.SalesTermRef.value = estimates.SalesTermRef.value
invoices	credit_memos.ClassRef.value = invoices.ClassRef.value credit_memos.ClassRef.value = invoices.Line.SalesItemLineDetail.ClassRef.value credit_memos.CurrencyRef.value = invoices.CurrencyRef.value credit_memos.CustomerRef.value = invoices.CustomerRef.value credit_memos.Line.SalesItemLineDetail.ItemRef.value = invoices.Line.SalesItemLineDetail.ItemRef.value credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = invoices.Line.SalesItemLineDetail.TaxCodeRef.value credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = invoices.TxnTaxDetail.TxnTaxCodeRef.value credit_memos.SalesTermRef.value = invoices.SalesTermRef.value credit_memos.Id = invoices.Id
items	credit_memos.ClassRef.value = items.ClassRef.value credit_memos.Line.SalesItemLineDetail.ItemRef.value = items.Id credit_memos.Line.SalesItemLineDetail.ItemRef.value = items.ParentRef.value credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = items.PurchaseTaxCodeRef.value credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = items.SalesTaxCodeRef.value
purchase_orders	credit_memos.ClassRef.value = purchase_orders.ClassRef.value credit_memos.ClassRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value credit_memos.CurrencyRef.value = purchase_orders.CurrencyRef.value credit_memos.CustomerRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value credit_memos.Line.SalesItemLineDetail.ItemRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value credit_memos.SalesTermRef.value = purchase_orders.SalesTermRef.value
purchases	credit_memos.ClassRef.value = purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value credit_memos.CurrencyRef.value = purchases.CurrencyRef.value credit_memos.CustomerRef.value = purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value credit_memos.Line.SalesItemLineDetail.ItemRef.value = purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value credit_memos.Id = purchases.Id
refund_receipts	credit_memos.ClassRef.value = refund_receipts.ClassRef.value credit_memos.CurrencyRef.value = refund_receipts.CurrencyRef.value credit_memos.CustomerRef.value = refund_receipts.CustomerRef.value credit_memos.Line.SalesItemLineDetail.ItemRef.value = refund_receipts.Line.SalesItemLineDetail.ItemRef.value credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value
sales_receipts	credit_memos.ClassRef.value = sales_receipts.ClassRef.value credit_memos.CurrencyRef.value = sales_receipts.CurrencyRef.value credit_memos.CustomerRef.value = sales_receipts.CustomerRef.value credit_memos.Line.SalesItemLineDetail.ItemRef.value = sales_receipts.Line.SalesItemLineDetail.ItemRef.value credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value
time_activities	credit_memos.ClassRef.value = time_activities.ClassRef.value credit_memos.Line.SalesItemLineDetail.ItemRef.value = time_activities.ItemRef.value
vendor_credits	credit_memos.ClassRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value credit_memos.CurrencyRef.value = vendor_credits.CurrencyRef.value credit_memos.CustomerRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value
payments	credit_memos.Id = payments.Line.LinkedTxn.TxnId credit_memos.CurrencyRef.value = payments.CurrencyRef.value credit_memos.CustomerRef.value = payments.CustomerRef.value
accounts	credit_memos.CurrencyRef.value = accounts.CurrencyRef.value
bill_payments	credit_memos.CurrencyRef.value = bill_payments.CurrencyRef.value
bills	credit_memos.CurrencyRef.value = bills.CurrencyRef.value credit_memos.CustomerRef.value = bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value credit_memos.Line.SalesItemLineDetail.ItemRef.value = bills.Line.ItemBasedExpenseLineDetail.ItemRef.value credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value credit_memos.SalesTermRef.value = bills.SalesTermRef.value
customers	credit_memos.CurrencyRef.value = customers.CurrencyRef.value credit_memos.CustomerRef.value = customers.Id credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = customers.DefaultTaxCodeRef.value credit_memos.SalesTermRef.value = customers.SalesTermRef.value
deposits	credit_memos.CurrencyRef.value = deposits.CurrencyRef.value
journal_entries	credit_memos.CurrencyRef.value = journal_entries.CurrencyRef.value credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value
transfers	credit_memos.CurrencyRef.value = transfers.CurrencyRef.value
vendors	credit_memos.CurrencyRef.value = vendors.CurrencyRef.value
terms	credit_memos.SalesTermRef.value = terms.Id

credit_memos table schema

ApplyTaxAfterDiscount

BOOLEAN

Balance

NUMBER

BillAddr

OBJECT

Click to expand BillAddr

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

BillEmail

OBJECT

Click to expand BillEmail

Address

STRING

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

CurrencyRef

OBJECT

Click to expand CurrencyRef

name

STRING

value

STRING

CustomField

ARRAY

CustomerMemo

OBJECT

Click to expand CustomerMemo

value

STRING

CustomerRef

OBJECT

Click to expand CustomerRef

name

STRING

value

STRING

DepartmentRef

OBJECT

Click to expand DepartmentRef

name

STRING

value

STRING

DocNumber

STRING

EmailStatus

STRING

ExchangeRate

NUMBER

GlobalTaxCalculation

STRING

HomeBalance

NUMBER

HomeTotalAmt

NUMBER

STRING

InvoiceRef

OBJECT

Click to expand InvoiceRef

name

STRING

value

STRING

Line

ARRAY

Click to expand Line

Amount

NUMBER

Description

STRING

DescriptionLineDetail

OBJECT

Click to expand DescriptionLineDetail

ServiceDate

DATE-TIME

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

DetailType

STRING

DiscountLineDetail

OBJECT

Click to expand DiscountLineDetail

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

DiscountAccountRef

OBJECT

Click to expand DiscountAccountRef

name

STRING

value

STRING

DiscountPercent

NUMBER

PercentBased

BOOLEAN

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

GroupLineDetail

OBJECT

Click to expand GroupLineDetail

GroupItemRef

OBJECT

Click to expand GroupItemRef

name

STRING

value

STRING

Line

ARRAY

Click to expand Line

Amount

NUMBER

Description

STRING

DetailType

STRING

LineNum

NUMBER

SalesItemLineDetail

OBJECT

Click to expand SalesItemLineDetail

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

DiscountAmt

NUMBER

DiscountRate

NUMBER

ItemAccountRef

OBJECT

Click to expand ItemAccountRef

name

STRING

value

STRING

ItemRef

OBJECT

Click to expand ItemRef

name

STRING

value

STRING

MarkupInfo

OBJECT

Click to expand MarkupInfo

MarkUpIncomeAccountRef

OBJECT

Click to expand MarkUpIncomeAccountRef

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

Click to expand PriceLevelRef

name

STRING

value

STRING

Qty

INTEGER

ServiceDate

DATE-TIME

TaxClassificationRef

OBJECT

Click to expand TaxClassificationRef

name

STRING

value

STRING

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

UnitPrice

NUMBER

Quantity

NUMBER

STRING

LineNum

INTEGER

SalesItemLineDetail

OBJECT

Click to expand SalesItemLineDetail

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

DiscountAmt

NUMBER

DiscountRate

NUMBER

ItemAccountRef

OBJECT

Click to expand ItemAccountRef

name

STRING

value

STRING

ItemRef

OBJECT

Click to expand ItemRef

name

STRING

value

STRING

MarkupInfo

OBJECT

Click to expand MarkupInfo

MarkUpIncomeAccountRef

OBJECT

Click to expand MarkUpIncomeAccountRef

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

Click to expand PriceLevelRef

name

STRING

value

STRING

Qty

INTEGER

ServiceDate

DATE-TIME

TaxClassificationRef

OBJECT

Click to expand TaxClassificationRef

name

STRING

value

STRING

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

UnitPrice

NUMBER

SubtotalLineDetail

OBJECT

Click to expand SubtotalLineDetail

ItemRef

OBJECT

Click to expand ItemRef

name

STRING

value

STRING

MetaData

OBJECT

Click to expand MetaData

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

PaymentMethodRef

OBJECT

Click to expand PaymentMethodRef

name

STRING

value

STRING

PrintStatus

STRING

PrivateNote

STRING

RecurDataRef

OBJECT

Click to expand RecurDataRef

name

STRING

value

STRING

RemainingCredit

INTEGER

SalesTermRef

OBJECT

Click to expand SalesTermRef

name

STRING

value

STRING

ShipAddr

OBJECT

Click to expand ShipAddr

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

SyncToken

STRING

TaxExemptionRef

OBJECT

Click to expand TaxExemptionRef

name

STRING

value

STRING

TotalAmt

NUMBER

TransactionLocationType

STRING

TxnDate

DATE-TIME

TxnTaxDetail

OBJECT

Click to expand TxnTaxDetail

TaxLine

ARRAY

Click to expand TaxLine

Amount

NUMBER

DetailType

STRING

TaxLineDetail

OBJECT

Click to expand TaxLineDetail

NetAmountTaxable

NUMBER

OverrideDeltaAmount

NUMBER

PercentBased

BOOLEAN

TaxInclusiveAmount

NUMBER

TaxPercent

NUMBER

TaxRateRef

OBJECT

Click to expand TaxRateRef

name

STRING

value

STRING

TotalTax

NUMBER

TxnTaxCodeRef

OBJECT

Click to expand TxnTaxCodeRef

name

STRING

value

STRING

domain

STRING

patternProperties

OBJECT

Click to expand patternProperties

customer_types

The customer_types table contains info about types of customers.

Replication Method

Key-based Incremental

Primary Key

Useful links

QuickBooks documentation

customer_types schema on GitHub

QuickBooks API method

customer_types table schema

Active

BOOLEAN

STRING

MetaData

OBJECT

Click to expand MetaData

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

Name

STRING

SyncToken

STRING

domain

STRING

sparse

STRING

customers

The customers table contains info about the consumers of your business’s goods and services. Note: Both active and inactive customers are included in the data for this table.

Replication Method

Key-based Incremental

Primary Key

Useful links

QuickBooks documentation

customers schema on GitHub

QuickBooks API method

customers table foreign keys

Join customers with	on
accounts	customers.CurrencyRef.value = accounts.CurrencyRef.value
bill_payments	customers.CurrencyRef.value = bill_payments.CurrencyRef.value
bills	customers.CurrencyRef.value = bills.CurrencyRef.value customers.Id = bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value customers.DefaultTaxCodeRef.value = bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value customers.DefaultTaxCodeRef.value = bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value customers.SalesTermRef.value = bills.SalesTermRef.value
credit_memos	customers.CurrencyRef.value = credit_memos.CurrencyRef.value customers.Id = credit_memos.CustomerRef.value customers.DefaultTaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value customers.SalesTermRef.value = credit_memos.SalesTermRef.value
deposits	customers.CurrencyRef.value = deposits.CurrencyRef.value customers.PaymentMethodRef.value = deposits.Line.DepositLineDetail.PaymentMethodRef.value
estimates	customers.CurrencyRef.value = estimates.CurrencyRef.value customers.Id = estimates.CustomerRef.value customers.DefaultTaxCodeRef.value = estimates.Line.SalesItemLineDetail.TaxCodeRef.value customers.DefaultTaxCodeRef.value = estimates.TxnTaxDetail.TxnTaxCodeRef.value customers.SalesTermRef.value = estimates.SalesTermRef.value
invoices	customers.CurrencyRef.value = invoices.CurrencyRef.value customers.Id = invoices.CustomerRef.value customers.DefaultTaxCodeRef.value = invoices.Line.SalesItemLineDetail.TaxCodeRef.value customers.DefaultTaxCodeRef.value = invoices.TxnTaxDetail.TxnTaxCodeRef.value customers.SalesTermRef.value = invoices.SalesTermRef.value
journal_entries	customers.CurrencyRef.value = journal_entries.CurrencyRef.value customers.DefaultTaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value
payments	customers.CurrencyRef.value = payments.CurrencyRef.value customers.Id = payments.CustomerRef.value customers.PaymentMethodRef.value = payments.PaymentMethodRef.value
purchase_orders	customers.CurrencyRef.value = purchase_orders.CurrencyRef.value customers.Id = purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value customers.DefaultTaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value customers.SalesTermRef.value = purchase_orders.SalesTermRef.value
purchases	customers.CurrencyRef.value = purchases.CurrencyRef.value customers.Id = purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value customers.PaymentMethodRef.value = purchases.PaymentMethodRef.value customers.DefaultTaxCodeRef.value = purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value customers.DefaultTaxCodeRef.value = purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value
refund_receipts	customers.CurrencyRef.value = refund_receipts.CurrencyRef.value customers.Id = refund_receipts.CustomerRef.value customers.PaymentMethodRef.value = refund_receipts.PaymentMethodRef.value customers.DefaultTaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value
sales_receipts	customers.CurrencyRef.value = sales_receipts.CurrencyRef.value customers.Id = sales_receipts.CustomerRef.value customers.PaymentMethodRef.value = sales_receipts.PaymentMethodRef.value customers.DefaultTaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value
transfers	customers.CurrencyRef.value = transfers.CurrencyRef.value
vendor_credits	customers.CurrencyRef.value = vendor_credits.CurrencyRef.value customers.Id = vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value customers.DefaultTaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value
vendors	customers.CurrencyRef.value = vendors.CurrencyRef.value
budgets	customers.Id = budgets.BudgetDetail.CustomerRef.value
payment_methods	customers.PaymentMethodRef.value = payment_methods.Id
items	customers.DefaultTaxCodeRef.value = items.PurchaseTaxCodeRef.value customers.DefaultTaxCodeRef.value = items.SalesTaxCodeRef.value
terms	customers.SalesTermRef.value = terms.Id

customers table schema

ARAccountRef

OBJECT

Click to expand ARAccountRef

name

STRING

value

STRING

Active

BOOLEAN

AlternatePhone

OBJECT

Click to expand AlternatePhone

FreeFormNumber

STRING

Balance

NUMBER

BalanceWithJobs

NUMBER

BillAddr

OBJECT

Click to expand BillAddr

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

BillWithParent

BOOLEAN

BusinessNumber

STRING

CompanyName

STRING

CurrencyRef

OBJECT

Click to expand CurrencyRef

name

STRING

value

STRING

CustomerTypeRef

OBJECT

Click to expand CustomerTypeRef

value

STRING

DefaultTaxCodeRef

OBJECT

Click to expand DefaultTaxCodeRef

name

STRING

value

STRING

DisplayName

STRING

FamilyName

STRING

Fax

OBJECT

Click to expand Fax

FreeFormNumber

STRING

FullyQualifiedName

STRING

GSTIN

STRING

GSTRegistrationType

STRING

GivenName

STRING

IsProject

BOOLEAN

Job

BOOLEAN

Level

INTEGER

MetaData

OBJECT

Click to expand MetaData

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

MiddleName

STRING

Mobile

OBJECT

Click to expand Mobile

FreeFormNumber

STRING

Notes

STRING

OpenBalanceDate

DATE-TIME

ParentRef

OBJECT

Click to expand ParentRef

name

STRING

value

STRING

PaymentMethodRef

OBJECT

Click to expand PaymentMethodRef

name

STRING

value

STRING

PreferredDeliveryMethod

STRING

PrimaryEmailAddr

OBJECT

Click to expand PrimaryEmailAddr

Address

STRING

PrimaryPhone

OBJECT

Click to expand PrimaryPhone

FreeFormNumber

STRING

PrimaryTaxIdentifier

STRING

PrintOnCheckName

STRING

ResaleNum

STRING

SalesTermRef

OBJECT

Click to expand SalesTermRef

name

STRING

value

STRING

SecondaryTaxIdentifier

STRING

ShipAddr

OBJECT

Click to expand ShipAddr

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

Source

STRING

Suffix

STRING

SyncToken

STRING

TaxExemptionReasonId

INTEGER

Taxable

BOOLEAN

Title

STRING

WebAddr

OBJECT

Click to expand WebAddr

URI

STRING

domain

STRING

deleted_objects

The deleted_objects table contains info about objects deleted from QuickBooks.

Replication Method

Key-based Incremental

Primary Key

Useful links

QuickBooks documentation

deleted_objects schema on GitHub

QuickBooks API method

deleted_objects table schema

STRING

MetaData

OBJECT

Click to expand MetaData

LastUpdatedTime

DATE-TIME

Type

STRING

domain

STRING

departments

The departments table contains info about the departments in your QuickBooks instance. Note: Both active and inactive departments are included in the data for this table.

Replication Method

Key-based Incremental

Primary Key

Useful links

QuickBooks documentation

departments schema on GitHub

QuickBooks API method

departments table foreign keys

Join departments with	on
bills	departments.ParentRef.value = bills.DepartmentRef.value departments.Id = bills.DepartmentRef.value
bill_payments	departments.ParentRef.value = bill_payments.DepartmentRef.value departments.Id = bill_payments.DepartmentRef.value
budgets	departments.ParentRef.value = budgets.BudgetDetail.DepartmentRef.value departments.Id = budgets.BudgetDetail.DepartmentRef.value
deposits	departments.ParentRef.value = deposits.DepartmentRef.value departments.Id = deposits.DepartmentRef.value
estimates	departments.ParentRef.value = estimates.DepartmentRef.value departments.Id = estimates.DepartmentRef.value
invoices	departments.ParentRef.value = invoices.DepartmentRef.value departments.Id = invoices.DepartmentRef.value
purchase_orders	departments.ParentRef.value = purchase_orders.DepartmentRef.value departments.Id = purchase_orders.DepartmentRef.value
purchases	departments.ParentRef.value = purchases.DepartmentRef.value departments.Id = purchases.DepartmentRef.value
refund_receipts	departments.ParentRef.value = refund_receipts.DepartmentRef.value departments.Id = refund_receipts.DepartmentRef.value
sales_receipts	departments.ParentRef.value = sales_receipts.DepartmentRef.value departments.Id = sales_receipts.DepartmentRef.value
time_activities	departments.ParentRef.value = time_activities.DepartmentRef.value departments.Id = time_activities.DepartmentRef.value
vendor_credits	departments.ParentRef.value = vendor_credits.DepartmentRef.value departments.Id = vendor_credits.DepartmentRef.value

departments table schema

Active

BOOLEAN

FullyQualifiedName

STRING

MetaData

OBJECT

Click to expand MetaData

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

Name

STRING

ParentRef

OBJECT

Click to expand ParentRef

name

STRING

value

STRING

SubDepartment

BOOLEAN

SyncToken

STRING

domain

STRING

deposits

The deposits table contains info about deposits in your QuickBooks instance. These can be customer payments or new direct deposits.

Replication Method

Key-based Incremental

Primary Key

Useful links

QuickBooks documentation

deposits schema on GitHub

QuickBooks API method

deposits table foreign keys

Join deposits with	on
accounts	deposits.CashBack.AccountRef.value = accounts.Id deposits.DepositToAccountRef.value = accounts.Id deposits.Line.DepositLineDetail.AccountRef.value = accounts.Id deposits.CashBack.AccountRef.value = accounts.ParentRef.value deposits.DepositToAccountRef.value = accounts.ParentRef.value deposits.Line.DepositLineDetail.AccountRef.value = accounts.ParentRef.value deposits.CurrencyRef.value = accounts.CurrencyRef.value
bill_payments	deposits.CashBack.AccountRef.value = bill_payments.APAccountRef.value deposits.DepositToAccountRef.value = bill_payments.APAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = bill_payments.APAccountRef.value deposits.CashBack.AccountRef.value = bill_payments.CheckPayment.BankAccountRef.value deposits.DepositToAccountRef.value = bill_payments.CheckPayment.BankAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = bill_payments.CheckPayment.BankAccountRef.value deposits.CashBack.AccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value deposits.DepositToAccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value deposits.CurrencyRef.value = bill_payments.CurrencyRef.value deposits.DepartmentRef.value = bill_payments.DepartmentRef.value deposits.Line.LinkedTxn.TxnId = bill_payments.Line.LinkedTxn.TxnId
bills	deposits.CashBack.AccountRef.value = bills.APAccountRef.value deposits.DepositToAccountRef.value = bills.APAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = bills.APAccountRef.value deposits.CashBack.AccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value deposits.DepositToAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value deposits.CurrencyRef.value = bills.CurrencyRef.value deposits.DepartmentRef.value = bills.DepartmentRef.value
budgets	deposits.CashBack.AccountRef.value = budgets.BudgetDetail.AccountRef.value deposits.DepositToAccountRef.value = budgets.BudgetDetail.AccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = budgets.BudgetDetail.AccountRef.value deposits.DepartmentRef.value = budgets.BudgetDetail.DepartmentRef.value
invoices	deposits.CashBack.AccountRef.value = invoices.DepositToAccountRef.value deposits.DepositToAccountRef.value = invoices.DepositToAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = invoices.DepositToAccountRef.value deposits.CashBack.AccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value deposits.DepositToAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value deposits.CurrencyRef.value = invoices.CurrencyRef.value deposits.DepartmentRef.value = invoices.DepartmentRef.value deposits.Line.LinkedTxn.TxnId = invoices.LinkedTxn.TxnId
items	deposits.CashBack.AccountRef.value = items.AssetAccountRef.value deposits.DepositToAccountRef.value = items.AssetAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = items.AssetAccountRef.value deposits.CashBack.AccountRef.value = items.ExpenseAccountRef.value deposits.DepositToAccountRef.value = items.ExpenseAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = items.ExpenseAccountRef.value deposits.CashBack.AccountRef.value = items.IncomeAccountRef.value deposits.DepositToAccountRef.value = items.IncomeAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = items.IncomeAccountRef.value
journal_entries	deposits.CashBack.AccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value deposits.DepositToAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value deposits.CurrencyRef.value = journal_entries.CurrencyRef.value deposits.Line.LinkedTxn.TxnId = journal_entries.Id
payments	deposits.CashBack.AccountRef.value = payments.DepositToAccountRef.value deposits.DepositToAccountRef.value = payments.DepositToAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = payments.DepositToAccountRef.value deposits.CurrencyRef.value = payments.CurrencyRef.value deposits.Line.LinkedTxn.TxnId = payments.Id deposits.Line.DepositLineDetail.PaymentMethodRef.value = payments.PaymentMethodRef.value
purchase_orders	deposits.CashBack.AccountRef.value = purchase_orders.APAccountRef.value deposits.DepositToAccountRef.value = purchase_orders.APAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = purchase_orders.APAccountRef.value deposits.CurrencyRef.value = purchase_orders.CurrencyRef.value deposits.DepartmentRef.value = purchase_orders.DepartmentRef.value
purchases	deposits.CashBack.AccountRef.value = purchases.AccountRef.value deposits.DepositToAccountRef.value = purchases.AccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = purchases.AccountRef.value deposits.CashBack.AccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value deposits.DepositToAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value deposits.CurrencyRef.value = purchases.CurrencyRef.value deposits.DepartmentRef.value = purchases.DepartmentRef.value deposits.Line.DepositLineDetail.PaymentMethodRef.value = purchases.PaymentMethodRef.value
refund_receipts	deposits.CashBack.AccountRef.value = refund_receipts.DepositToAccountRef.value deposits.DepositToAccountRef.value = refund_receipts.DepositToAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = refund_receipts.DepositToAccountRef.value deposits.CurrencyRef.value = refund_receipts.CurrencyRef.value deposits.DepartmentRef.value = refund_receipts.DepartmentRef.value deposits.Line.DepositLineDetail.PaymentMethodRef.value = refund_receipts.PaymentMethodRef.value deposits.Line.LinkedTxn.TxnId = refund_receipts.Id
sales_receipts	deposits.CashBack.AccountRef.value = sales_receipts.DepositToAccountRef.value deposits.DepositToAccountRef.value = sales_receipts.DepositToAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = sales_receipts.DepositToAccountRef.value deposits.CashBack.AccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value deposits.DepositToAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value deposits.CurrencyRef.value = sales_receipts.CurrencyRef.value deposits.DepartmentRef.value = sales_receipts.DepartmentRef.value deposits.Line.DepositLineDetail.PaymentMethodRef.value = sales_receipts.PaymentMethodRef.value deposits.Line.LinkedTxn.TxnId = sales_receipts.Id
transfers	deposits.CashBack.AccountRef.value = transfers.FromAccountRef.value deposits.DepositToAccountRef.value = transfers.FromAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = transfers.FromAccountRef.value deposits.CashBack.AccountRef.value = transfers.ToAccountRef.value deposits.DepositToAccountRef.value = transfers.ToAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = transfers.ToAccountRef.value deposits.CurrencyRef.value = transfers.CurrencyRef.value deposits.Line.LinkedTxn.TxnId = transfers.Id
vendor_credits	deposits.CashBack.AccountRef.value = vendor_credits.APAccountRef.value deposits.DepositToAccountRef.value = vendor_credits.APAccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = vendor_credits.APAccountRef.value deposits.CashBack.AccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value deposits.DepositToAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value deposits.Line.DepositLineDetail.AccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value deposits.CurrencyRef.value = vendor_credits.CurrencyRef.value deposits.DepartmentRef.value = vendor_credits.DepartmentRef.value
credit_memos	deposits.CurrencyRef.value = credit_memos.CurrencyRef.value
customers	deposits.CurrencyRef.value = customers.CurrencyRef.value deposits.Line.DepositLineDetail.PaymentMethodRef.value = customers.PaymentMethodRef.value
estimates	deposits.CurrencyRef.value = estimates.CurrencyRef.value deposits.DepartmentRef.value = estimates.DepartmentRef.value
vendors	deposits.CurrencyRef.value = vendors.CurrencyRef.value
departments	deposits.DepartmentRef.value = departments.ParentRef.value deposits.DepartmentRef.value = departments.Id
time_activities	deposits.DepartmentRef.value = time_activities.DepartmentRef.value
payment_methods	deposits.Line.DepositLineDetail.PaymentMethodRef.value = payment_methods.Id

deposits table schema

CashBack

OBJECT

Click to expand CashBack

AccountRef

OBJECT

Click to expand AccountRef

name

STRING

value

STRING

Amount

NUMBER

Memo

STRING

CurrencyRef

OBJECT

Click to expand CurrencyRef

name

STRING

value

STRING

DepartmentRef

OBJECT

Click to expand DepartmentRef

name

STRING

value

STRING

DepositToAccountRef

OBJECT

Click to expand DepositToAccountRef

name

STRING

value

STRING

ExchangeRate

NUMBER

GlobalTaxCalculation

STRING

HomeTotalAmt

NUMBER

STRING

Line

ARRAY

Click to expand Line

Amount

NUMBER

CustomField

OBJECT

Click to expand CustomField

DefinitionId

STRING

Name

STRING

StringValue

STRING

Type

STRING

DepositLineDetail

OBJECT

Click to expand DepositLineDetail

AccountRef

OBJECT

Click to expand AccountRef

name

STRING

value

STRING

CheckNum

STRING

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

Entity

OBJECT

Click to expand Entity

name

STRING

value

STRING

PaymentMethodRef

OBJECT

Click to expand PaymentMethodRef

name

STRING

value

STRING

TaxApplicableOn

STRING

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

TxnType

STRING

Description

STRING

DetailType

STRING

LineNum

INTEGER

LinkedTxn

ARRAY

Click to expand LinkedTxn

TxnId

STRING

TxnLineId

STRING

TxnType

STRING

MetaData

OBJECT

Click to expand MetaData

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

PrivateNote

STRING

RecurDataRef

OBJECT

Click to expand RecurDataRef

name

STRING

value

STRING

SyncToken

STRING

TotalAmt

NUMBER

TransactionLocationType

STRING

TxnDate

DATE-TIME

TxnSource

STRING

TxnTaxDetail

OBJECT

Click to expand TxnTaxDetail

TaxLine

ARRAY

Click to expand TaxLine

Amount

NUMBER

DetailType

STRING

TaxLineDetail

OBJECT

Click to expand TaxLineDetail

NetAmountTaxable

NUMBER

OverrideDeltaAmount

NUMBER

PercentBased

BOOLEAN

TaxInclusiveAmount

NUMBER

TaxPercent

NUMBER

TaxRateRef

OBJECT

Click to expand TaxRateRef

name

STRING

value

STRING

TotalTax

NUMBER

TxnTaxCodeRef

OBJECT

Click to expand TxnTaxCodeRef

name

STRING

value

STRING

domain

STRING

employees

The employees table contains info about the people working for your company. Note: Both active and inactive employees are included in the data for this table.

Replication Method

Key-based Incremental

Primary Key

Useful links

QuickBooks documentation

employees schema on GitHub

QuickBooks API method

employees table foreign keys

Join employees with	on
purchases	employees.Id = purchases.EntityRef.value
time_activities	employees.Id = time_activities.EmployeeRef.value

employees table schema

Active

BOOLEAN

BillRate

NUMBER

BillableTime

BOOLEAN

BirthDate

DATE-TIME

CostRate

NUMBER

DisplayName

STRING

EmployeeNumber

STRING

FamilyName

STRING

Gender

STRING

GivenName

STRING

HiredDate

DATE-TIME

STRING

MetaData

OBJECT

Click to expand MetaData

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

MiddleName

STRING

Mobile

OBJECT

Click to expand Mobile

FreeFormNumber

STRING

Organization

BOOLEAN

PrimaryAddr

OBJECT

Click to expand PrimaryAddr

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

PrimaryEmailAddr

OBJECT

Click to expand PrimaryEmailAddr

Address

STRING

PrimaryPhone

OBJECT

Click to expand PrimaryPhone

FreeFormNumber

STRING

PrintOnCheckName

STRING

ReleasedDate

DATE-TIME

SSN

STRING

Suffix

STRING

SyncToken

STRING

Title

STRING

V4IDPseudonym

STRING

domain

STRING

estimates

The estimates table contains info about the estimates in your QuickBooks instance. An estimate is a financial proposal from a business to a customer for goods or services.

Replication Method

Key-based Incremental

Primary Key

Useful links

QuickBooks documentation

estimates schema on GitHub

QuickBooks API method

estimates table foreign keys

Join estimates with	on
budgets	estimates.ClassRef.value = budgets.BudgetDetail.ClassRef.value estimates.CustomerRef.value = budgets.BudgetDetail.CustomerRef.value estimates.DepartmentRef.value = budgets.BudgetDetail.DepartmentRef.value
classes	estimates.ClassRef.value = classes.Id estimates.ClassRef.value = classes.ParentRef.value
credit_memos	estimates.ClassRef.value = credit_memos.ClassRef.value estimates.CurrencyRef.value = credit_memos.CurrencyRef.value estimates.CustomerRef.value = credit_memos.CustomerRef.value estimates.Line.SalesItemLineDetail.ItemRef.value = credit_memos.Line.SalesItemLineDetail.ItemRef.value estimates.Line.SalesItemLineDetail.TaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value estimates.TxnTaxDetail.TxnTaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value estimates.SalesTermRef.value = credit_memos.SalesTermRef.value
invoices	estimates.ClassRef.value = invoices.ClassRef.value estimates.ClassRef.value = invoices.Line.SalesItemLineDetail.ClassRef.value estimates.CurrencyRef.value = invoices.CurrencyRef.value estimates.CustomerRef.value = invoices.CustomerRef.value estimates.DepartmentRef.value = invoices.DepartmentRef.value estimates.Id = invoices.LinkedTxn.TxnId estimates.LinkedTxn.TxnId = invoices.Id estimates.Line.SalesItemLineDetail.ItemRef.value = invoices.Line.SalesItemLineDetail.ItemRef.value estimates.Line.SalesItemLineDetail.TaxCodeRef.value = invoices.Line.SalesItemLineDetail.TaxCodeRef.value estimates.TxnTaxDetail.TxnTaxCodeRef.value = invoices.Line.SalesItemLineDetail.TaxCodeRef.value estimates.Line.SalesItemLineDetail.TaxCodeRef.value = invoices.TxnTaxDetail.TxnTaxCodeRef.value estimates.TxnTaxDetail.TxnTaxCodeRef.value = invoices.TxnTaxDetail.TxnTaxCodeRef.value estimates.TxnTaxDetail.TaxLine.TaxLineDetail.TaxLine.TaxLineDetail.TaxRateRef.value = invoices.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value estimates.SalesTermRef.value = invoices.SalesTermRef.value
items	estimates.ClassRef.value = items.ClassRef.value estimates.Line.SalesItemLineDetail.ItemRef.value = items.Id estimates.Line.SalesItemLineDetail.ItemRef.value = items.ParentRef.value estimates.Line.SalesItemLineDetail.TaxCodeRef.value = items.PurchaseTaxCodeRef.value estimates.TxnTaxDetail.TxnTaxCodeRef.value = items.PurchaseTaxCodeRef.value estimates.Line.SalesItemLineDetail.TaxCodeRef.value = items.SalesTaxCodeRef.value estimates.TxnTaxDetail.TxnTaxCodeRef.value = items.SalesTaxCodeRef.value
purchase_orders	estimates.ClassRef.value = purchase_orders.ClassRef.value estimates.ClassRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value estimates.CurrencyRef.value = purchase_orders.CurrencyRef.value estimates.CustomerRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value estimates.DepartmentRef.value = purchase_orders.DepartmentRef.value estimates.Line.SalesItemLineDetail.ItemRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value estimates.Line.SalesItemLineDetail.TaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value estimates.TxnTaxDetail.TxnTaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value estimates.SalesTermRef.value = purchase_orders.SalesTermRef.value
purchases	estimates.ClassRef.value = purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value estimates.CurrencyRef.value = purchases.CurrencyRef.value estimates.CustomerRef.value = purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value estimates.DepartmentRef.value = purchases.DepartmentRef.value estimates.Line.SalesItemLineDetail.ItemRef.value = purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value estimates.Line.SalesItemLineDetail.TaxCodeRef.value = purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value estimates.TxnTaxDetail.TxnTaxCodeRef.value = purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value estimates.Line.SalesItemLineDetail.TaxCodeRef.value = purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value estimates.TxnTaxDetail.TxnTaxCodeRef.value = purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value estimates.Id = purchases.Id
refund_receipts	estimates.ClassRef.value = refund_receipts.ClassRef.value estimates.CurrencyRef.value = refund_receipts.CurrencyRef.value estimates.CustomerRef.value = refund_receipts.CustomerRef.value estimates.DepartmentRef.value = refund_receipts.DepartmentRef.value estimates.Line.SalesItemLineDetail.ItemRef.value = refund_receipts.Line.SalesItemLineDetail.ItemRef.value estimates.Line.SalesItemLineDetail.TaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value estimates.TxnTaxDetail.TxnTaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value
sales_receipts	estimates.ClassRef.value = sales_receipts.ClassRef.value estimates.CurrencyRef.value = sales_receipts.CurrencyRef.value estimates.CustomerRef.value = sales_receipts.CustomerRef.value estimates.DepartmentRef.value = sales_receipts.DepartmentRef.value estimates.Line.SalesItemLineDetail.ItemRef.value = sales_receipts.Line.SalesItemLineDetail.ItemRef.value estimates.Line.SalesItemLineDetail.TaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value estimates.TxnTaxDetail.TxnTaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value
time_activities	estimates.ClassRef.value = time_activities.ClassRef.value estimates.DepartmentRef.value = time_activities.DepartmentRef.value estimates.Line.SalesItemLineDetail.ItemRef.value = time_activities.ItemRef.value estimates.Id = time_activities.Id
vendor_credits	estimates.ClassRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value estimates.CurrencyRef.value = vendor_credits.CurrencyRef.value estimates.CustomerRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value estimates.DepartmentRef.value = vendor_credits.DepartmentRef.value estimates.Line.SalesItemLineDetail.TaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value estimates.TxnTaxDetail.TxnTaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value
accounts	estimates.CurrencyRef.value = accounts.CurrencyRef.value
bill_payments	estimates.CurrencyRef.value = bill_payments.CurrencyRef.value estimates.DepartmentRef.value = bill_payments.DepartmentRef.value
bills	estimates.CurrencyRef.value = bills.CurrencyRef.value estimates.CustomerRef.value = bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value estimates.DepartmentRef.value = bills.DepartmentRef.value estimates.Line.SalesItemLineDetail.ItemRef.value = bills.Line.ItemBasedExpenseLineDetail.ItemRef.value estimates.Line.SalesItemLineDetail.TaxCodeRef.value = bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value estimates.TxnTaxDetail.TxnTaxCodeRef.value = bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value estimates.Line.SalesItemLineDetail.TaxCodeRef.value = bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value estimates.TxnTaxDetail.TxnTaxCodeRef.value = bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value estimates.SalesTermRef.value = bills.SalesTermRef.value
customers	estimates.CurrencyRef.value = customers.CurrencyRef.value estimates.CustomerRef.value = customers.Id estimates.Line.SalesItemLineDetail.TaxCodeRef.value = customers.DefaultTaxCodeRef.value estimates.TxnTaxDetail.TxnTaxCodeRef.value = customers.DefaultTaxCodeRef.value estimates.SalesTermRef.value = customers.SalesTermRef.value
deposits	estimates.CurrencyRef.value = deposits.CurrencyRef.value estimates.DepartmentRef.value = deposits.DepartmentRef.value
journal_entries	estimates.CurrencyRef.value = journal_entries.CurrencyRef.value estimates.Line.SalesItemLineDetail.TaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value estimates.TxnTaxDetail.TxnTaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value estimates.TxnTaxDetail.TaxLine.TaxLineDetail.TaxLine.TaxLineDetail.TaxRateRef.value = journal_entries.TaxRateRef.value estimates.TxnTaxDetail.TaxLine.TaxLineDetail.TaxLine.TaxLineDetail.TaxRateRef.value = journal_entries.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value
payments	estimates.CurrencyRef.value = payments.CurrencyRef.value estimates.CustomerRef.value = payments.CustomerRef.value estimates.LinkedTxn.TxnId = payments.Line.LinkedTxn.TxnId estimates.Id = payments.Id
transfers	estimates.CurrencyRef.value = transfers.CurrencyRef.value
vendors	estimates.CurrencyRef.value = vendors.CurrencyRef.value
departments	estimates.DepartmentRef.value = departments.ParentRef.value estimates.DepartmentRef.value = departments.Id
tax_codes	estimates.TxnTaxDetail.TaxLine.TaxLineDetail.TaxLine.TaxLineDetail.TaxRateRef.value = tax_codes.PurchaseTaxRateList.TaxRateDetail.TaxRateRef.value estimates.TxnTaxDetail.TaxLine.TaxLineDetail.TaxLine.TaxLineDetail.TaxRateRef.value = tax_codes.SalesTaxRateList.TaxRateDetail.TaxRateRef.value
tax_rates	estimates.TxnTaxDetail.TaxLine.TaxLineDetail.TaxLine.TaxLineDetail.TaxRateRef.value = tax_rates.Id
terms	estimates.SalesTermRef.value = terms.Id

estimates table schema

AcceptedBy

STRING

AcceptedDate

DATE-TIME

ApplyTaxAfterDiscount

BOOLEAN

BillAddr

OBJECT

Click to expand BillAddr

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

BillEmail

OBJECT

Click to expand BillEmail

Address

STRING

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

CurrencyRef

OBJECT

Click to expand CurrencyRef

name

STRING

value

STRING

CustomField

ARRAY

CustomerMemo

OBJECT

Click to expand CustomerMemo

value

STRING

CustomerRef

OBJECT

Click to expand CustomerRef

name

STRING

value

STRING

DeliveryInfo

OBJECT

Click to expand DeliveryInfo

DeliveryTime

DATE-TIME

DeliveryType

STRING

DepartmentRef

OBJECT

Click to expand DepartmentRef

name

STRING

value

STRING

DocNumber

STRING

DueDate

DATE-TIME

EmailStatus

STRING

ExchangeRate

NUMBER

ExpirationDate

DATE-TIME

FreeFormAddress

BOOLEAN

GlobalTaxCalculation

STRING

HomeTotalAmt

NUMBER

STRING

Line

ARRAY

Click to expand Line

Amount

NUMBER

Description

STRING

DescriptionLineDetail

OBJECT

Click to expand DescriptionLineDetail

ServiceDate

DATE-TIME

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

DetailType

STRING

DiscountLineDetail

OBJECT

Click to expand DiscountLineDetail

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

DiscountAccountRef

OBJECT

Click to expand DiscountAccountRef

name

STRING

value

STRING

DiscountPercent

NUMBER

PercentBased

BOOLEAN

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

GroupLineDetail

OBJECT

Click to expand GroupLineDetail

GroupItemRef

OBJECT

Click to expand GroupItemRef

name

STRING

value

STRING

Line

ARRAY

Click to expand Line

Amount

NUMBER

Description

STRING

DetailType

STRING

LineNum

NUMBER

SalesItemLineDetail

OBJECT

Click to expand SalesItemLineDetail

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

DiscountAmt

NUMBER

DiscountRate

NUMBER

ItemAccountRef

OBJECT

Click to expand ItemAccountRef

name

STRING

value

STRING

ItemRef

OBJECT

Click to expand ItemRef

name

STRING

value

STRING

MarkupInfo

OBJECT

Click to expand MarkupInfo

MarkUpIncomeAccountRef

OBJECT

Click to expand MarkUpIncomeAccountRef

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

Click to expand PriceLevelRef

name

STRING

value

STRING

Qty

INTEGER

ServiceDate

DATE-TIME

TaxClassificationRef

OBJECT

Click to expand TaxClassificationRef

name

STRING

value

STRING

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

UnitPrice

NUMBER

Quantity

NUMBER

STRING

LineNum

INTEGER

SalesItemLineDetail

OBJECT

Click to expand SalesItemLineDetail

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

DiscountAmt

NUMBER

DiscountRate

NUMBER

ItemAccountRef

OBJECT

Click to expand ItemAccountRef

name

STRING

value

STRING

ItemRef

OBJECT

Click to expand ItemRef

name

STRING

value

STRING

MarkupInfo

OBJECT

Click to expand MarkupInfo

MarkUpIncomeAccountRef

OBJECT

Click to expand MarkUpIncomeAccountRef

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

Click to expand PriceLevelRef

name

STRING

value

STRING

Qty

INTEGER

ServiceDate

DATE-TIME

TaxClassificationRef

OBJECT

Click to expand TaxClassificationRef

name

STRING

value

STRING

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

UnitPrice

NUMBER

SubtotalLineDetail

OBJECT

Click to expand SubtotalLineDetail

ItemRef

OBJECT

Click to expand ItemRef

name

STRING

value

STRING

LinkedTxn

ARRAY

Click to expand LinkedTxn

TxnId

STRING

TxnLineId

STRING

TxnType

STRING

MetaData

OBJECT

Click to expand MetaData

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

PrintStatus

STRING

PrivateNote

STRING

RecurDataRef

OBJECT

Click to expand RecurDataRef

name

STRING

value

STRING

SalesTermRef

OBJECT

Click to expand SalesTermRef

name

STRING

value

STRING

ShipAddr

OBJECT

Click to expand ShipAddr

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

ShipDate

DATE-TIME

ShipFromAddr

OBJECT

Click to expand ShipFromAddr

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

ShipMethodRef

OBJECT

Click to expand ShipMethodRef

name

STRING

value

STRING

SyncToken

STRING

TaxExemptionRef

OBJECT

Click to expand TaxExemptionRef

name

STRING

value

STRING

TotalAmt

NUMBER

TransactionLocationType

STRING

TxnDate

DATE-TIME

TxnStatus

STRING

TxnTaxDetail

OBJECT

Click to expand TxnTaxDetail

TaxLine

ARRAY

Click to expand TaxLine

Amount

NUMBER

DetailType

STRING

TaxLineDetail

OBJECT

Click to expand TaxLineDetail

TaxLine

ARRAY

Click to expand TaxLine

Amount

NUMBER

DetailType

STRING

TaxLineDetail

OBJECT

Click to expand TaxLineDetail

NetAmountTaxable

NUMBER

OverrideDeltaAmount

NUMBER

PercentBased

BOOLEAN

TaxInclusiveAmount

NUMBER

TaxPercent

NUMBER

TaxRateRef

OBJECT

Click to expand TaxRateRef

name

STRING

value

STRING

TotalTax

NUMBER

TxnTaxCodeRef

OBJECT

Click to expand TxnTaxCodeRef

name

STRING

value

STRING

TotalTax

NUMBER

TxnTaxCodeRef

OBJECT

Click to expand TxnTaxCodeRef

name

STRING

value

STRING

domain

STRING

patternProperties

OBJECT

Click to expand patternProperties

invoices

The invoices table contains info about the invoices in your QuickBooks account.

Replication Method

Key-based Incremental

Primary Key

Useful links

QuickBooks documentation

invoices schema on GitHub

QuickBooks API method

invoices table foreign keys

Join invoices with	on
accounts	invoices.DepositToAccountRef.value = accounts.Id invoices.Line.DiscountLineDetail.DiscountAccountRef.value = accounts.Id invoices.DepositToAccountRef.value = accounts.ParentRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = accounts.ParentRef.value invoices.CurrencyRef.value = accounts.CurrencyRef.value
bill_payments	invoices.DepositToAccountRef.value = bill_payments.APAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = bill_payments.APAccountRef.value invoices.DepositToAccountRef.value = bill_payments.CheckPayment.BankAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = bill_payments.CheckPayment.BankAccountRef.value invoices.DepositToAccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value invoices.CurrencyRef.value = bill_payments.CurrencyRef.value invoices.DepartmentRef.value = bill_payments.DepartmentRef.value
bills	invoices.DepositToAccountRef.value = bills.APAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = bills.APAccountRef.value invoices.DepositToAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value invoices.CurrencyRef.value = bills.CurrencyRef.value invoices.CustomerRef.value = bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value invoices.DepartmentRef.value = bills.DepartmentRef.value invoices.Line.SalesItemLineDetail.ItemRef.value = bills.Line.ItemBasedExpenseLineDetail.ItemRef.value invoices.Line.SalesItemLineDetail.TaxCodeRef.value = bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value invoices.TxnTaxDetail.TxnTaxCodeRef.value = bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value invoices.Line.SalesItemLineDetail.TaxCodeRef.value = bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value invoices.TxnTaxDetail.TxnTaxCodeRef.value = bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value invoices.SalesTermRef.value = bills.SalesTermRef.value
budgets	invoices.DepositToAccountRef.value = budgets.BudgetDetail.AccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = budgets.BudgetDetail.AccountRef.value invoices.ClassRef.value = budgets.BudgetDetail.ClassRef.value invoices.Line.SalesItemLineDetail.ClassRef.value = budgets.BudgetDetail.ClassRef.value invoices.CustomerRef.value = budgets.BudgetDetail.CustomerRef.value invoices.DepartmentRef.value = budgets.BudgetDetail.DepartmentRef.value
deposits	invoices.DepositToAccountRef.value = deposits.CashBack.AccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = deposits.CashBack.AccountRef.value invoices.DepositToAccountRef.value = deposits.DepositToAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = deposits.DepositToAccountRef.value invoices.DepositToAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value invoices.CurrencyRef.value = deposits.CurrencyRef.value invoices.DepartmentRef.value = deposits.DepartmentRef.value invoices.LinkedTxn.TxnId = deposits.Line.LinkedTxn.TxnId
items	invoices.DepositToAccountRef.value = items.AssetAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = items.AssetAccountRef.value invoices.DepositToAccountRef.value = items.ExpenseAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = items.ExpenseAccountRef.value invoices.DepositToAccountRef.value = items.IncomeAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = items.IncomeAccountRef.value invoices.ClassRef.value = items.ClassRef.value invoices.Line.SalesItemLineDetail.ClassRef.value = items.ClassRef.value invoices.Line.SalesItemLineDetail.ItemRef.value = items.Id invoices.Line.SalesItemLineDetail.ItemRef.value = items.ParentRef.value invoices.Line.SalesItemLineDetail.TaxCodeRef.value = items.PurchaseTaxCodeRef.value invoices.TxnTaxDetail.TxnTaxCodeRef.value = items.PurchaseTaxCodeRef.value invoices.Line.SalesItemLineDetail.TaxCodeRef.value = items.SalesTaxCodeRef.value invoices.TxnTaxDetail.TxnTaxCodeRef.value = items.SalesTaxCodeRef.value
journal_entries	invoices.DepositToAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value invoices.CurrencyRef.value = journal_entries.CurrencyRef.value invoices.Line.SalesItemLineDetail.TaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value invoices.TxnTaxDetail.TxnTaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value invoices.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value = journal_entries.TaxRateRef.value invoices.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value = journal_entries.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value
payments	invoices.DepositToAccountRef.value = payments.DepositToAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = payments.DepositToAccountRef.value invoices.CurrencyRef.value = payments.CurrencyRef.value invoices.CustomerRef.value = payments.CustomerRef.value invoices.Id = payments.Line.LinkedTxn.TxnId invoices.LinkedTxn.TxnId = payments.Id invoices.LinkedTxn.TxnId = payments.Line.LinkedTxn.TxnId
purchase_orders	invoices.DepositToAccountRef.value = purchase_orders.APAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = purchase_orders.APAccountRef.value invoices.ClassRef.value = purchase_orders.ClassRef.value invoices.Line.SalesItemLineDetail.ClassRef.value = purchase_orders.ClassRef.value invoices.ClassRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value invoices.Line.SalesItemLineDetail.ClassRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value invoices.CurrencyRef.value = purchase_orders.CurrencyRef.value invoices.CustomerRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value invoices.DepartmentRef.value = purchase_orders.DepartmentRef.value invoices.Line.SalesItemLineDetail.ItemRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value invoices.Line.SalesItemLineDetail.TaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value invoices.TxnTaxDetail.TxnTaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value invoices.SalesTermRef.value = purchase_orders.SalesTermRef.value
purchases	invoices.DepositToAccountRef.value = purchases.AccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = purchases.AccountRef.value invoices.DepositToAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value invoices.ClassRef.value = purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value invoices.Line.SalesItemLineDetail.ClassRef.value = purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value invoices.CurrencyRef.value = purchases.CurrencyRef.value invoices.CustomerRef.value = purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value invoices.DepartmentRef.value = purchases.DepartmentRef.value invoices.Line.SalesItemLineDetail.ItemRef.value = purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value invoices.LinkedTxn.TxnId = purchases.Id invoices.Line.SalesItemLineDetail.TaxCodeRef.value = purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value invoices.TxnTaxDetail.TxnTaxCodeRef.value = purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value invoices.Line.SalesItemLineDetail.TaxCodeRef.value = purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value invoices.TxnTaxDetail.TxnTaxCodeRef.value = purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value invoices.Id = purchases.Id
refund_receipts	invoices.DepositToAccountRef.value = refund_receipts.DepositToAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = refund_receipts.DepositToAccountRef.value invoices.ClassRef.value = refund_receipts.ClassRef.value invoices.Line.SalesItemLineDetail.ClassRef.value = refund_receipts.ClassRef.value invoices.CurrencyRef.value = refund_receipts.CurrencyRef.value invoices.CustomerRef.value = refund_receipts.CustomerRef.value invoices.DepartmentRef.value = refund_receipts.DepartmentRef.value invoices.Line.SalesItemLineDetail.ItemRef.value = refund_receipts.Line.SalesItemLineDetail.ItemRef.value invoices.Line.SalesItemLineDetail.TaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value invoices.TxnTaxDetail.TxnTaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value
sales_receipts	invoices.DepositToAccountRef.value = sales_receipts.DepositToAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = sales_receipts.DepositToAccountRef.value invoices.DepositToAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value invoices.ClassRef.value = sales_receipts.ClassRef.value invoices.Line.SalesItemLineDetail.ClassRef.value = sales_receipts.ClassRef.value invoices.CurrencyRef.value = sales_receipts.CurrencyRef.value invoices.CustomerRef.value = sales_receipts.CustomerRef.value invoices.DepartmentRef.value = sales_receipts.DepartmentRef.value invoices.Line.SalesItemLineDetail.ItemRef.value = sales_receipts.Line.SalesItemLineDetail.ItemRef.value invoices.Line.SalesItemLineDetail.TaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value invoices.TxnTaxDetail.TxnTaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value
transfers	invoices.DepositToAccountRef.value = transfers.FromAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = transfers.FromAccountRef.value invoices.DepositToAccountRef.value = transfers.ToAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = transfers.ToAccountRef.value invoices.CurrencyRef.value = transfers.CurrencyRef.value
vendor_credits	invoices.DepositToAccountRef.value = vendor_credits.APAccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = vendor_credits.APAccountRef.value invoices.DepositToAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value invoices.Line.DiscountLineDetail.DiscountAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value invoices.ClassRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value invoices.Line.SalesItemLineDetail.ClassRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value invoices.CurrencyRef.value = vendor_credits.CurrencyRef.value invoices.CustomerRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value invoices.DepartmentRef.value = vendor_credits.DepartmentRef.value invoices.Line.SalesItemLineDetail.TaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value invoices.TxnTaxDetail.TxnTaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value
classes	invoices.ClassRef.value = classes.Id invoices.Line.SalesItemLineDetail.ClassRef.value = classes.Id invoices.ClassRef.value = classes.ParentRef.value invoices.Line.SalesItemLineDetail.ClassRef.value = classes.ParentRef.value
credit_memos	invoices.ClassRef.value = credit_memos.ClassRef.value invoices.Line.SalesItemLineDetail.ClassRef.value = credit_memos.ClassRef.value invoices.CurrencyRef.value = credit_memos.CurrencyRef.value invoices.CustomerRef.value = credit_memos.CustomerRef.value invoices.Line.SalesItemLineDetail.ItemRef.value = credit_memos.Line.SalesItemLineDetail.ItemRef.value invoices.Line.SalesItemLineDetail.TaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value invoices.TxnTaxDetail.TxnTaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value invoices.SalesTermRef.value = credit_memos.SalesTermRef.value invoices.Id = credit_memos.Id
estimates	invoices.ClassRef.value = estimates.ClassRef.value invoices.Line.SalesItemLineDetail.ClassRef.value = estimates.ClassRef.value invoices.CurrencyRef.value = estimates.CurrencyRef.value invoices.CustomerRef.value = estimates.CustomerRef.value invoices.DepartmentRef.value = estimates.DepartmentRef.value invoices.LinkedTxn.TxnId = estimates.Id invoices.Id = estimates.LinkedTxn.TxnId invoices.Line.SalesItemLineDetail.ItemRef.value = estimates.Line.SalesItemLineDetail.ItemRef.value invoices.Line.SalesItemLineDetail.TaxCodeRef.value = estimates.Line.SalesItemLineDetail.TaxCodeRef.value invoices.TxnTaxDetail.TxnTaxCodeRef.value = estimates.Line.SalesItemLineDetail.TaxCodeRef.value invoices.Line.SalesItemLineDetail.TaxCodeRef.value = estimates.TxnTaxDetail.TxnTaxCodeRef.value invoices.TxnTaxDetail.TxnTaxCodeRef.value = estimates.TxnTaxDetail.TxnTaxCodeRef.value invoices.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value = estimates.TxnTaxDetail.TaxLine.TaxLineDetail.TaxLine.TaxLineDetail.TaxRateRef.value invoices.SalesTermRef.value = estimates.SalesTermRef.value
time_activities	invoices.ClassRef.value = time_activities.ClassRef.value invoices.Line.SalesItemLineDetail.ClassRef.value = time_activities.ClassRef.value invoices.DepartmentRef.value = time_activities.DepartmentRef.value invoices.Line.SalesItemLineDetail.ItemRef.value = time_activities.ItemRef.value invoices.LinkedTxn.TxnId = time_activities.Id
customers	invoices.CurrencyRef.value = customers.CurrencyRef.value invoices.CustomerRef.value = customers.Id invoices.Line.SalesItemLineDetail.TaxCodeRef.value = customers.DefaultTaxCodeRef.value invoices.TxnTaxDetail.TxnTaxCodeRef.value = customers.DefaultTaxCodeRef.value invoices.SalesTermRef.value = customers.SalesTermRef.value
vendors	invoices.CurrencyRef.value = vendors.CurrencyRef.value
departments	invoices.DepartmentRef.value = departments.ParentRef.value invoices.DepartmentRef.value = departments.Id
tax_codes	invoices.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value = tax_codes.PurchaseTaxRateList.TaxRateDetail.TaxRateRef.value invoices.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value = tax_codes.SalesTaxRateList.TaxRateDetail.TaxRateRef.value
tax_rates	invoices.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value = tax_rates.Id
terms	invoices.SalesTermRef.value = terms.Id

invoices table schema

AllowIPNPayment

BOOLEAN

AllowOnlineACHPayment

BOOLEAN

AllowOnlineCreditCardPayment

BOOLEAN

AllowOnlinePayment

BOOLEAN

ApplyTaxAfterDiscount

BOOLEAN

Balance

NUMBER

BillAddr

OBJECT

Click to expand BillAddr

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

BillEmail

OBJECT

Click to expand BillEmail

Address

STRING

BillEmailBcc

OBJECT

Click to expand BillEmailBcc

Address

STRING

BillEmailCc

OBJECT

Click to expand BillEmailCc

Address

STRING

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

CurrencyRef

OBJECT

Click to expand CurrencyRef

name

STRING

value

STRING

CustomField

ARRAY

CustomerMemo

OBJECT

Click to expand CustomerMemo

value

STRING

CustomerRef

OBJECT

Click to expand CustomerRef

name

STRING

value

STRING

DeliveryInfo

OBJECT

Click to expand DeliveryInfo

DeliveryTime

DATE-TIME

DeliveryType

STRING

DepartmentRef

OBJECT

Click to expand DepartmentRef

name

STRING

value

STRING

Deposit

NUMBER

DepositToAccountRef

OBJECT

Click to expand DepositToAccountRef

name

STRING

value

STRING

DocNumber

STRING

DueDate

DATE-TIME

EmailStatus

STRING

ExchangeRate

NUMBER

FreeFormAddress

BOOLEAN

GlobalTaxCalculation

STRING

HomeBalance

NUMBER

HomeTotalAmt

NUMBER

STRING

InvoiceLink

STRING

Line

ARRAY

Click to expand Line

Amount

NUMBER

Description

STRING

DescriptionLineDetail

OBJECT

Click to expand DescriptionLineDetail

ServiceDate

DATE-TIME

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

DetailType

STRING

DiscountLineDetail

OBJECT

Click to expand DiscountLineDetail

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

DiscountAccountRef

OBJECT

Click to expand DiscountAccountRef

name

STRING

value

STRING

DiscountPercent

NUMBER

PercentBased

BOOLEAN

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

GroupLineDetail

OBJECT

Click to expand GroupLineDetail

GroupItemRef

OBJECT

Click to expand GroupItemRef

name

STRING

value

STRING

Line

ARRAY

Click to expand Line

Amount

NUMBER

Description

STRING

DetailType

STRING

LineNum

NUMBER

SalesItemLineDetail

OBJECT

Click to expand SalesItemLineDetail

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

DiscountAmt

NUMBER

DiscountRate

NUMBER

ItemAccountRef

OBJECT

Click to expand ItemAccountRef

name

STRING

value

STRING

ItemRef

OBJECT

Click to expand ItemRef

name

STRING

value

STRING

MarkupInfo

OBJECT

Click to expand MarkupInfo

MarkUpIncomeAccountRef

OBJECT

Click to expand MarkUpIncomeAccountRef

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

Click to expand PriceLevelRef

name

STRING

value

STRING

Qty

INTEGER

ServiceDate

DATE-TIME

TaxClassificationRef

OBJECT

Click to expand TaxClassificationRef

name

STRING

value

STRING

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

UnitPrice

NUMBER

Quantity

NUMBER

STRING

LineNum

INTEGER

LinkedTxn

ARRAY

Click to expand LinkedTxn

TxnId

STRING

TxnLineId

STRING

TxnType

STRING

SalesItemLineDetail

OBJECT

Click to expand SalesItemLineDetail

ClassRef

OBJECT

Click to expand ClassRef

name

STRING

value

STRING

DiscountAmt

NUMBER

DiscountRate

NUMBER

ItemAccountRef

OBJECT

Click to expand ItemAccountRef

name

STRING

value

STRING

ItemRef

OBJECT

Click to expand ItemRef

name

STRING

value

STRING

MarkupInfo

OBJECT

Click to expand MarkupInfo

MarkUpIncomeAccountRef

OBJECT

Click to expand MarkUpIncomeAccountRef

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

Click to expand PriceLevelRef

name

STRING

value

STRING

Qty

INTEGER

ServiceDate

DATE-TIME

TaxClassificationRef

OBJECT

Click to expand TaxClassificationRef

name

STRING

value

STRING

TaxCodeRef

OBJECT

Click to expand TaxCodeRef

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

UnitPrice

NUMBER

SubtotalLineDetail

OBJECT

Click to expand SubtotalLineDetail

ItemRef

OBJECT

Click to expand ItemRef

name

STRING

value

STRING

LinkedTxn

ARRAY

Click to expand LinkedTxn

TxnId

STRING

TxnLineId

STRING

TxnType

STRING

MetaData

OBJECT

Click to expand MetaData

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

PrintStatus

STRING

PrivateNote

STRING

RecurDataRef

OBJECT

Click to expand RecurDataRef

name

STRING

value

STRING

SalesTermRef

OBJECT

Click to expand SalesTermRef

name

STRING

value

STRING

ShipAddr

OBJECT

Click to expand ShipAddr

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

ShipDate

DATE-TIME

ShipFromAddr

OBJECT

Click to expand ShipFromAddr

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

ShipMethodRef

OBJECT

Click to expand ShipMethodRef

name

STRING

value

STRING

SyncToken

STRING

TaxExemptionRef

OBJECT

Click to expand TaxExemptionRef

name

STRING

value

STRING

TotalAmt

NUMBER

TrackingNum

STRING

TransactionLocationType

STRING

TxnDate

DATE-TIME

TxnSource

STRING

TxnTaxDetail

OBJECT

Click to expand TxnTaxDetail

TaxLine

ARRAY

Click to expand TaxLine

Amount

NUMBER

DetailType

STRING

TaxLineDetail

OBJECT

Click to expand TaxLineDetail

NetAmountTaxable

NUMBER

OverrideDeltaAmount

NUMBER

PercentBased

BOOLEAN

TaxInclusiveAmount

NUMBER

TaxPercent

NUMBER

TaxRateRef

OBJECT

Click to expand TaxRateRef

name

STRING

value

STRING

TotalTax

NUMBER

TxnTaxCodeRef

OBJECT

Click to expand TxnTaxCodeRef

name

STRING

value

STRING

domain

STRING

patternProperties

OBJECT

Click to expand patternProperties

items

The items table contains info about the items your company buys, sells, or re-sells. This includes all item types in QuickBooks, such as Inventory, Group, Service and Noninventory.

Replication Method

Key-based Incremental

Primary Key

Useful links

QuickBooks documentation

items schema on GitHub

QuickBooks API method

items table foreign keys

Join items with	on
accounts	items.AssetAccountRef.value = accounts.Id items.ExpenseAccountRef.value = accounts.Id items.IncomeAccountRef.value = accounts.Id items.AssetAccountRef.value = accounts.ParentRef.value items.ExpenseAccountRef.value = accounts.ParentRef.value items.IncomeAccountRef.value = accounts.ParentRef.value
bill_payments	items.AssetAccountRef.value = bill_payments.APAccountRef.value items.ExpenseAccountRef.value = bill_payments.APAccountRef.value items.IncomeAccountRef.value = bill_payments.APAccountRef.value items.AssetAccountRef.value = bill_payments.CheckPayment.BankAccountRef.value items.ExpenseAccountRef.value = bill_payments.CheckPayment.BankAccountRef.value items.IncomeAccountRef.value = bill_payments.CheckPayment.BankAccountRef.value items.AssetAccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value items.ExpenseAccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value items.IncomeAccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value items.PrefVendorRef.value = bill_payments.VendorRef.value
bills	items.AssetAccountRef.value = bills.APAccountRef.value items.ExpenseAccountRef.value = bills.APAccountRef.value items.IncomeAccountRef.value = bills.APAccountRef.value items.AssetAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value items.ExpenseAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value items.IncomeAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value items.Id = bills.Line.ItemBasedExpenseLineDetail.ItemRef.value items.ParentRef.value = bills.Line.ItemBasedExpenseLineDetail.ItemRef.value items.PurchaseTaxCodeRef.value = bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value items.SalesTaxCodeRef.value = bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value items.PurchaseTaxCodeRef.value = bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value items.SalesTaxCodeRef.value = bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value items.PrefVendorRef.value = bills.VendorRef.value
budgets	items.AssetAccountRef.value = budgets.BudgetDetail.AccountRef.value items.ExpenseAccountRef.value = budgets.BudgetDetail.AccountRef.value items.IncomeAccountRef.value = budgets.BudgetDetail.AccountRef.value items.ClassRef.value = budgets.BudgetDetail.ClassRef.value
deposits	items.AssetAccountRef.value = deposits.CashBack.AccountRef.value items.ExpenseAccountRef.value = deposits.CashBack.AccountRef.value items.IncomeAccountRef.value = deposits.CashBack.AccountRef.value items.AssetAccountRef.value = deposits.DepositToAccountRef.value items.ExpenseAccountRef.value = deposits.DepositToAccountRef.value items.IncomeAccountRef.value = deposits.DepositToAccountRef.value items.AssetAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value items.ExpenseAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value items.IncomeAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value
invoices	items.AssetAccountRef.value = invoices.DepositToAccountRef.value items.ExpenseAccountRef.value = invoices.DepositToAccountRef.value items.IncomeAccountRef.value = invoices.DepositToAccountRef.value items.AssetAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value items.ExpenseAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value items.IncomeAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value items.ClassRef.value = invoices.ClassRef.value items.ClassRef.value = invoices.Line.SalesItemLineDetail.ClassRef.value items.Id = invoices.Line.SalesItemLineDetail.ItemRef.value items.ParentRef.value = invoices.Line.SalesItemLineDetail.ItemRef.value items.PurchaseTaxCodeRef.value = invoices.Line.SalesItemLineDetail.TaxCodeRef.value items.SalesTaxCodeRef.value = invoices.Line.SalesItemLineDetail.TaxCodeRef.value items.PurchaseTaxCodeRef.value = invoices.TxnTaxDetail.TxnTaxCodeRef.value items.SalesTaxCodeRef.value = invoices.TxnTaxDetail.TxnTaxCodeRef.value
journal_entries	items.AssetAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value items.ExpenseAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value items.IncomeAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value items.PurchaseTaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value items.SalesTaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value
payments	items.AssetAccountRef.value = payments.DepositToAccountRef.value items.ExpenseAccountRef.value = payments.DepositToAccountRef.value items.IncomeAccountRef.value = payments.DepositToAccountRef.value
purchase_orders	items.AssetAccountRef.value = purchase_orders.APAccountRef.value items.ExpenseAccountRef.value = purchase_orders.APAccountRef.value items.IncomeAccountRef.value = purchase_orders.APAccountRef.value items.ClassRef.value = purchase_orders.ClassRef.value items.ClassRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value items.Id = purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value items.ParentRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value items.PurchaseTaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value items.SalesTaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value items.PrefVendorRef.value = purchase_orders.VendorRef.value
purchases	items.AssetAccountRef.value = purchases.AccountRef.value items.ExpenseAccountRef.value = purchases.AccountRef.value items.IncomeAccountRef.value = purchases.AccountRef.value items.AssetAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value items.ExpenseAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value items.IncomeAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value items.ClassRef.value = purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value items.Id = purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value items.ParentRef.value = purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value items.PurchaseTaxCodeRef.value = purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value items.SalesTaxCodeRef.value = purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value items.PurchaseTaxCodeRef.value = purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value items.SalesTaxCodeRef.value = purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value
refund_receipts	items.AssetAccountRef.value = refund_receipts.DepositToAccountRef.value items.ExpenseAccountRef.value = refund_receipts.DepositToAccountRef.value items.IncomeAccountRef.value = refund_receipts.DepositToAccountRef.value items.ClassRef.value = refund_receipts.ClassRef.value items.Id = refund_receipts.Line.SalesItemLineDetail.ItemRef.value items.ParentRef.value = refund_receipts.Line.SalesItemLineDetail.ItemRef.value items.PurchaseTaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value items.SalesTaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value
sales_receipts	items.AssetAccountRef.value = sales_receipts.DepositToAccountRef.value items.ExpenseAccountRef.value = sales_receipts.DepositToAccountRef.value items.IncomeAccountRef.value = sales_receipts.DepositToAccountRef.value items.AssetAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value items.ExpenseAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value items.IncomeAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value