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

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the QuickBooks icon.

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

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:

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.

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

Step 5: Set objects to replicate

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:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
  1. Click into the integration from the Stitch Dashboard page.
  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.
  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

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

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.


QuickBooks table reference

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

Id

Useful links

QuickBooks documentation

accounts schema on GitHub

QuickBooks API method

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

AccountAlias

STRING

AccountSubType

STRING

AccountType

STRING

AcctNum

STRING

Active

BOOLEAN

Classification

STRING

CurrencyRef

OBJECT

name

STRING

value

STRING

CurrentBalance

NUMBER

CurrentBalanceWithSubAccounts

NUMBER

Description

STRING

FullyQualifiedName

STRING

Id

STRING

MetaData

OBJECT

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

Name

STRING

ParentRef

OBJECT

name

STRING

value

STRING

SubAccount

BOOLEAN

SyncToken

STRING

TaxCodeRef

OBJECT

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

Id

Useful links

QuickBooks documentation

bill_payments schema on GitHub

QuickBooks API method

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

APAccountRef

OBJECT

name

STRING

value

STRING

CheckPayment

OBJECT

BankAccountRef

OBJECT

name

STRING

value

STRING

PrintStatus

STRING

CreditCardPayment

OBJECT

CCAccountRef

OBJECT

name

STRING

value

STRING

CurrencyRef

OBJECT

name

STRING

value

STRING

DepartmentRef

OBJECT

name

STRING

value

STRING

DocNumber

STRING

ExchangeRate

NUMBER

Id

STRING

Line

ARRAY

Amount

NUMBER

LinkedTxn

ARRAY

TxnId

STRING

TxnLineId

STRING

TxnType

STRING

MetaData

OBJECT

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

PayType

STRING

PrivateNote

STRING

ProcessBillPayment

BOOLEAN

SyncToken

STRING

TotalAmt

NUMBER

TransactionLocationType

STRING

TxnDate

DATE-TIME

VendorRef

OBJECT

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

Id

Useful links

QuickBooks documentation

bills schema on GitHub

QuickBooks API method

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

APAccountRef

OBJECT

name

STRING

value

STRING

Balance

NUMBER

CurrencyRef

OBJECT

name

STRING

value

STRING

DepartmentRef

OBJECT

name

STRING

value

STRING

DocNumber

STRING

DueDate

DATE-TIME

ExchangeRate

NUMBER

GlobalTaxCalculation

STRING

HomeBalance

NUMBER

Id

STRING

IncludeInAnnualTPAR

BOOLEAN

Line

ARRAY

AccountBasedExpenseLineDetail

OBJECT

AccountRef

OBJECT

name

STRING

value

STRING

BillableStatus

STRING

ClassRef

OBJECT

name

STRING

value

STRING

CustomerRef

OBJECT

name

STRING

value

STRING

MarkupInfo

OBJECT

MarkUpIncomeAccountRef

OBJECT

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

name

STRING

value

STRING

TaxAmount

NUMBER

TaxCodeRef

OBJECT

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

Amount

NUMBER

Description

STRING

DetailType

STRING

Id

STRING

ItemBasedExpenseLineDetail

OBJECT

BillableStatus

STRING

ClassRef

OBJECT

name

STRING

value

STRING

CustomerRef

OBJECT

name

STRING

value

STRING

ItemRef

OBJECT

name

STRING

value

STRING

MarkupInfo

OBJECT

MarkUpIncomeAccountRef

OBJECT

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

name

STRING

value

STRING

PriceLevelRef

OBJECT

name

STRING

value

STRING

Qty

INTEGER

TaxCodeRef

OBJECT

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

UnitPrice

NUMBER

LineNum

INTEGER

LinkedTxn

ARRAY

TxnId

STRING

TxnLineId

STRING

TxnType

STRING

LinkedTxn

ARRAY

TxnId

STRING

TxnLineId

STRING

TxnType

STRING

MetaData

OBJECT

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

PrivateNote

STRING

RecurDataRef

OBJECT

name

STRING

value

STRING

SalesTermRef

OBJECT

name

STRING

value

STRING

SyncToken

STRING

TotalAmt

NUMBER

TransactionLocationType

STRING

TxnDate

DATE-TIME

TxnTaxDetail

OBJECT

TaxLine

ARRAY

Amount

NUMBER

DetailType

STRING

TaxLineDetail

OBJECT

NetAmountTaxable

NUMBER

OverrideDeltaAmount

NUMBER

PercentBased

BOOLEAN

TaxInclusiveAmount

NUMBER

TaxPercent

NUMBER

TaxRateRef

OBJECT

name

STRING

value

STRING

TotalTax

NUMBER

TxnTaxCodeRef

OBJECT

name

STRING

value

STRING

VendorRef

OBJECT

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

Id

Useful links

QuickBooks documentation

budgets schema on GitHub

QuickBooks API method

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

Active

BOOLEAN

BudgetDetail

ARRAY

AccountRef

OBJECT

name

STRING

value

STRING

Amount

NUMBER

BudgetDate

DATE-TIME

ClassRef

OBJECT

name

STRING

value

STRING

CustomerRef

OBJECT

name

STRING

value

STRING

DepartmentRef

OBJECT

name

STRING

value

STRING

BudgetEntryType

STRING

BudgetType

STRING

EndDate

DATE-TIME

Id

STRING

MetaData

OBJECT

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

Id

Useful links

QuickBooks documentation

classes schema on GitHub

QuickBooks API method

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

Active

BOOLEAN

FullyQualifiedName

STRING

Id

STRING

MetaData

OBJECT

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

Name

STRING

ParentRef

OBJECT

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

Id

Useful links

QuickBooks documentation

credit_memos schema on GitHub

QuickBooks API method

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

ApplyTaxAfterDiscount

BOOLEAN

Balance

NUMBER

BillAddr

OBJECT

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Id

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

BillEmail

OBJECT

Address

STRING

ClassRef

OBJECT

name

STRING

value

STRING

CurrencyRef

OBJECT

name

STRING

value

STRING

CustomField

ARRAY

CustomerMemo

OBJECT

CustomerRef

OBJECT

name

STRING

value

STRING

DepartmentRef

OBJECT

name

STRING

value

STRING

DocNumber

STRING

EmailStatus

STRING

ExchangeRate

NUMBER

GlobalTaxCalculation

STRING

HomeBalance

NUMBER

HomeTotalAmt

NUMBER

Id

STRING

InvoiceRef

OBJECT

name

STRING

value

STRING

Line

ARRAY

Amount

NUMBER

Description

STRING

DescriptionLineDetail

OBJECT

ServiceDate

DATE-TIME

TaxCodeRef

OBJECT

name

STRING

value

STRING

DetailType

STRING

DiscountLineDetail

OBJECT

ClassRef

OBJECT

name

STRING

value

STRING

DiscountAccountRef

OBJECT

name

STRING

value

STRING

DiscountPercent

NUMBER

PercentBased

BOOLEAN

TaxCodeRef

OBJECT

name

STRING

value

STRING

GroupLineDetail

OBJECT

GroupItemRef

OBJECT

name

STRING

value

STRING

Line

ARRAY

Amount

NUMBER

Description

STRING

DetailType

STRING

Id

STRING

LineNum

NUMBER

SalesItemLineDetail

OBJECT

ClassRef

OBJECT

name

STRING

value

STRING

DiscountAmt

NUMBER

DiscountRate

NUMBER

ItemAccountRef

OBJECT

name

STRING

value

STRING

ItemRef

OBJECT

name

STRING

value

STRING

MarkupInfo

OBJECT

MarkUpIncomeAccountRef

OBJECT

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

name

STRING

value

STRING

Qty

INTEGER

ServiceDate

DATE-TIME

TaxClassificationRef

OBJECT

name

STRING

value

STRING

TaxCodeRef

OBJECT

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

UnitPrice

NUMBER

Quantity

NUMBER

Id

STRING

LineNum

INTEGER

SalesItemLineDetail

OBJECT

ClassRef

OBJECT

name

STRING

value

STRING

DiscountAmt

NUMBER

DiscountRate

NUMBER

ItemAccountRef

OBJECT

name

STRING

value

STRING

ItemRef

OBJECT

name

STRING

value

STRING

MarkupInfo

OBJECT

MarkUpIncomeAccountRef

OBJECT

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

name

STRING

value

STRING

Qty

INTEGER

ServiceDate

DATE-TIME

TaxClassificationRef

OBJECT

name

STRING

value

STRING

TaxCodeRef

OBJECT

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

UnitPrice

NUMBER

SubtotalLineDetail

OBJECT

ItemRef

OBJECT

name

STRING

value

STRING

MetaData

OBJECT

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

PaymentMethodRef

OBJECT

name

STRING

value

STRING

PrintStatus

STRING

PrivateNote

STRING

RecurDataRef

OBJECT

name

STRING

value

STRING

RemainingCredit

INTEGER

SalesTermRef

OBJECT

name

STRING

value

STRING

ShipAddr

OBJECT

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Id

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

SyncToken

STRING

TaxExemptionRef

OBJECT

name

STRING

value

STRING

TotalAmt

NUMBER

TransactionLocationType

STRING

TxnDate

DATE-TIME

TxnTaxDetail

OBJECT

TaxLine

ARRAY

Amount

NUMBER

DetailType

STRING

TaxLineDetail

OBJECT

NetAmountTaxable

NUMBER

OverrideDeltaAmount

NUMBER

PercentBased

BOOLEAN

TaxInclusiveAmount

NUMBER

TaxPercent

NUMBER

TaxRateRef

OBJECT

name

STRING

value

STRING

TotalTax

NUMBER

TxnTaxCodeRef

OBJECT

name

STRING

value

STRING

domain

STRING

patternProperties

OBJECT

customer_types

The customer_types table contains info about types of customers.

Replication Method

Key-based Incremental

Primary Key

Id

Useful links

QuickBooks documentation

customer_types schema on GitHub

QuickBooks API method

Active

BOOLEAN

Id

STRING

MetaData

OBJECT

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

Id

Useful links

QuickBooks documentation

customers schema on GitHub

QuickBooks API method

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

ARAccountRef

OBJECT

name

STRING

value

STRING

Active

BOOLEAN

AlternatePhone

OBJECT

FreeFormNumber

STRING

Balance

NUMBER

BalanceWithJobs

NUMBER

BillAddr

OBJECT

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Id

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

name

STRING

value

STRING

CustomerTypeRef

OBJECT

DefaultTaxCodeRef

OBJECT

name

STRING

value

STRING

DisplayName

STRING

FamilyName

STRING

Fax

OBJECT

FreeFormNumber

STRING

FullyQualifiedName

STRING

GSTIN

STRING

GSTRegistrationType

STRING

GivenName

STRING

Id

STRING

IsProject

BOOLEAN

Job

BOOLEAN

Level

INTEGER

MetaData

OBJECT

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

MiddleName

STRING

Mobile

OBJECT

FreeFormNumber

STRING

Notes

STRING

OpenBalanceDate

DATE-TIME

ParentRef

OBJECT

name

STRING

value

STRING

PaymentMethodRef

OBJECT

name

STRING

value

STRING

PreferredDeliveryMethod

STRING

PrimaryEmailAddr

OBJECT

PrimaryPhone

OBJECT

FreeFormNumber

STRING

PrimaryTaxIdentifier

STRING

PrintOnCheckName

STRING

ResaleNum

STRING

SalesTermRef

OBJECT

name

STRING

value

STRING

SecondaryTaxIdentifier

STRING

ShipAddr

OBJECT

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Id

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

domain

STRING

deleted_objects

The deleted_objects table contains info about objects deleted from QuickBooks.

Replication Method

Key-based Incremental

Primary Key

Id

Useful links

QuickBooks documentation

deleted_objects schema on GitHub

QuickBooks API method

Id

STRING

MetaData

OBJECT

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

Id

Useful links

QuickBooks documentation

departments schema on GitHub

QuickBooks API method

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

Active

BOOLEAN

FullyQualifiedName

STRING

Id

STRING

MetaData

OBJECT

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

Name

STRING

ParentRef

OBJECT

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

Id

Useful links

QuickBooks documentation

deposits schema on GitHub

QuickBooks API method

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

CashBack

OBJECT

AccountRef

OBJECT

name

STRING

value

STRING

Amount

NUMBER

Memo

STRING

CurrencyRef

OBJECT

name

STRING

value

STRING

DepartmentRef

OBJECT

name

STRING

value

STRING

DepositToAccountRef

OBJECT

name

STRING

value

STRING

ExchangeRate

NUMBER

GlobalTaxCalculation

STRING

HomeTotalAmt

NUMBER

Id

STRING

Line

ARRAY

Amount

NUMBER

CustomField

OBJECT

DefinitionId

STRING

Name

STRING

StringValue

STRING

Type

STRING

DepositLineDetail

OBJECT

AccountRef

OBJECT

name

STRING

value

STRING

CheckNum

STRING

ClassRef

OBJECT

name

STRING

value

STRING

Entity

OBJECT

name

STRING

value

STRING

PaymentMethodRef

OBJECT

name

STRING

value

STRING

TaxApplicableOn

STRING

TaxCodeRef

OBJECT

name

STRING

value

STRING

TxnType

STRING

Description

STRING

DetailType

STRING

Id

STRING

LineNum

INTEGER

LinkedTxn

ARRAY

TxnId

STRING

TxnLineId

STRING

TxnType

STRING

MetaData

OBJECT

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

PrivateNote

STRING

RecurDataRef

OBJECT

name

STRING

value

STRING

SyncToken

STRING

TotalAmt

NUMBER

TransactionLocationType

STRING

TxnDate

DATE-TIME

TxnSource

STRING

TxnTaxDetail

OBJECT

TaxLine

ARRAY

Amount

NUMBER

DetailType

STRING

TaxLineDetail

OBJECT

NetAmountTaxable

NUMBER

OverrideDeltaAmount

NUMBER

PercentBased

BOOLEAN

TaxInclusiveAmount

NUMBER

TaxPercent

NUMBER

TaxRateRef

OBJECT

name

STRING

value

STRING

TotalTax

NUMBER

TxnTaxCodeRef

OBJECT

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

Id

Useful links

QuickBooks documentation

employees schema on GitHub

QuickBooks API method

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

Active

BOOLEAN

BillRate

NUMBER

BillableTime

BOOLEAN

BirthDate

DATE-TIME

CostRate

NUMBER

DisplayName

STRING

EmployeeNumber

STRING

FamilyName

STRING

Gender

STRING

GivenName

STRING

HiredDate

DATE-TIME

Id

STRING

MetaData

OBJECT

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

MiddleName

STRING

Mobile

OBJECT

FreeFormNumber

STRING

Organization

BOOLEAN

PrimaryAddr

OBJECT

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Id

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

PrimaryEmailAddr

OBJECT

PrimaryPhone

OBJECT

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

Id

Useful links

QuickBooks documentation

estimates schema on GitHub

QuickBooks API method

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

AcceptedBy

STRING

AcceptedDate

DATE-TIME

ApplyTaxAfterDiscount

BOOLEAN

BillAddr

OBJECT

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Id

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

BillEmail

OBJECT

Address

STRING

ClassRef

OBJECT

name

STRING

value

STRING

CurrencyRef

OBJECT

name

STRING

value

STRING

CustomField

ARRAY

CustomerMemo

OBJECT

CustomerRef

OBJECT

name

STRING

value

STRING

DeliveryInfo

OBJECT

DeliveryTime

DATE-TIME

DeliveryType

STRING

DepartmentRef

OBJECT

name

STRING

value

STRING

DocNumber

STRING

DueDate

DATE-TIME

EmailStatus

STRING

ExchangeRate

NUMBER

ExpirationDate

DATE-TIME

FreeFormAddress

BOOLEAN

GlobalTaxCalculation

STRING

HomeTotalAmt

NUMBER

Id

STRING

Line

ARRAY

Amount

NUMBER

Description

STRING

DescriptionLineDetail

OBJECT

ServiceDate

DATE-TIME

TaxCodeRef

OBJECT

name

STRING

value

STRING

DetailType

STRING

DiscountLineDetail

OBJECT

ClassRef

OBJECT

name

STRING

value

STRING

DiscountAccountRef

OBJECT

name

STRING

value

STRING

DiscountPercent

NUMBER

PercentBased

BOOLEAN

TaxCodeRef

OBJECT

name

STRING

value

STRING

GroupLineDetail

OBJECT

GroupItemRef

OBJECT

name

STRING

value

STRING

Line

ARRAY

Amount

NUMBER

Description

STRING

DetailType

STRING

Id

STRING

LineNum

NUMBER

SalesItemLineDetail

OBJECT

ClassRef

OBJECT

name

STRING

value

STRING

DiscountAmt

NUMBER

DiscountRate

NUMBER

ItemAccountRef

OBJECT

name

STRING

value

STRING

ItemRef

OBJECT

name

STRING

value

STRING

MarkupInfo

OBJECT

MarkUpIncomeAccountRef

OBJECT

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

name

STRING

value

STRING

Qty

INTEGER

ServiceDate

DATE-TIME

TaxClassificationRef

OBJECT

name

STRING

value

STRING

TaxCodeRef

OBJECT

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

UnitPrice

NUMBER

Quantity

NUMBER

Id

STRING

LineNum

INTEGER

SalesItemLineDetail

OBJECT

ClassRef

OBJECT

name

STRING

value

STRING

DiscountAmt

NUMBER

DiscountRate

NUMBER

ItemAccountRef

OBJECT

name

STRING

value

STRING

ItemRef

OBJECT

name

STRING

value

STRING

MarkupInfo

OBJECT

MarkUpIncomeAccountRef

OBJECT

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

name

STRING

value

STRING

Qty

INTEGER

ServiceDate

DATE-TIME

TaxClassificationRef

OBJECT

name

STRING

value

STRING

TaxCodeRef

OBJECT

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

UnitPrice

NUMBER

SubtotalLineDetail

OBJECT

ItemRef

OBJECT

name

STRING

value

STRING

LinkedTxn

ARRAY

TxnId

STRING

TxnLineId

STRING

TxnType

STRING

MetaData

OBJECT

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

PrintStatus

STRING

PrivateNote

STRING

RecurDataRef

OBJECT

name

STRING

value

STRING

SalesTermRef

OBJECT

name

STRING

value

STRING

ShipAddr

OBJECT

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Id

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

ShipDate

DATE-TIME

ShipFromAddr

OBJECT

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Id

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

ShipMethodRef

OBJECT

name

STRING

value

STRING

SyncToken

STRING

TaxExemptionRef

OBJECT

name

STRING

value

STRING

TotalAmt

NUMBER

TransactionLocationType

STRING

TxnDate

DATE-TIME

TxnStatus

STRING

TxnTaxDetail

OBJECT

TaxLine

ARRAY

Amount

NUMBER

DetailType

STRING

TaxLineDetail

OBJECT

TaxLine

ARRAY

Amount

NUMBER

DetailType

STRING

TaxLineDetail

OBJECT

NetAmountTaxable

NUMBER

OverrideDeltaAmount

NUMBER

PercentBased

BOOLEAN

TaxInclusiveAmount

NUMBER

TaxPercent

NUMBER

TaxRateRef

OBJECT

name

STRING

value

STRING

TotalTax

NUMBER

TxnTaxCodeRef

OBJECT

name

STRING

value

STRING

TotalTax

NUMBER

TxnTaxCodeRef

OBJECT

name

STRING

value

STRING

domain

STRING

patternProperties

OBJECT

invoices

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

Replication Method

Key-based Incremental

Primary Key

Id

Useful links

QuickBooks documentation

invoices schema on GitHub

QuickBooks API method

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

AllowIPNPayment

BOOLEAN

AllowOnlineACHPayment

BOOLEAN

AllowOnlineCreditCardPayment

BOOLEAN

AllowOnlinePayment

BOOLEAN

ApplyTaxAfterDiscount

BOOLEAN

Balance

NUMBER

BillAddr

OBJECT

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Id

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

BillEmail

OBJECT

Address

STRING

BillEmailBcc

OBJECT

BillEmailCc

OBJECT

ClassRef

OBJECT

name

STRING

value

STRING

CurrencyRef

OBJECT

name

STRING

value

STRING

CustomField

ARRAY

CustomerMemo

OBJECT

CustomerRef

OBJECT

name

STRING

value

STRING

DeliveryInfo

OBJECT

DeliveryTime

DATE-TIME

DeliveryType

STRING

DepartmentRef

OBJECT

name

STRING

value

STRING

Deposit

NUMBER

DepositToAccountRef

OBJECT

name

STRING

value

STRING

DocNumber

STRING

DueDate

DATE-TIME

EmailStatus

STRING

ExchangeRate

NUMBER

FreeFormAddress

BOOLEAN

GlobalTaxCalculation

STRING

HomeBalance

NUMBER

HomeTotalAmt

NUMBER

Id

STRING

InvoiceLink

STRING

Line

ARRAY

Amount

NUMBER

Description

STRING

DescriptionLineDetail

OBJECT

ServiceDate

DATE-TIME

TaxCodeRef

OBJECT

name

STRING

value

STRING

DetailType

STRING

DiscountLineDetail

OBJECT

ClassRef

OBJECT

name

STRING

value

STRING

DiscountAccountRef

OBJECT

name

STRING

value

STRING

DiscountPercent

NUMBER

PercentBased

BOOLEAN

TaxCodeRef

OBJECT

name

STRING

value

STRING

GroupLineDetail

OBJECT

GroupItemRef

OBJECT

name

STRING

value

STRING

Line

ARRAY

Amount

NUMBER

Description

STRING

DetailType

STRING

Id

STRING

LineNum

NUMBER

SalesItemLineDetail

OBJECT

ClassRef

OBJECT

name

STRING

value

STRING

DiscountAmt

NUMBER

DiscountRate

NUMBER

ItemAccountRef

OBJECT

name

STRING

value

STRING

ItemRef

OBJECT

name

STRING

value

STRING

MarkupInfo

OBJECT

MarkUpIncomeAccountRef

OBJECT

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

name

STRING

value

STRING

Qty

INTEGER

ServiceDate

DATE-TIME

TaxClassificationRef

OBJECT

name

STRING

value

STRING

TaxCodeRef

OBJECT

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

UnitPrice

NUMBER

Quantity

NUMBER

Id

STRING

LineNum

INTEGER

LinkedTxn

ARRAY

TxnId

STRING

TxnLineId

STRING

TxnType

STRING

SalesItemLineDetail

OBJECT

ClassRef

OBJECT

name

STRING

value

STRING

DiscountAmt

NUMBER

DiscountRate

NUMBER

ItemAccountRef

OBJECT

name

STRING

value

STRING

ItemRef

OBJECT

name

STRING

value

STRING

MarkupInfo

OBJECT

MarkUpIncomeAccountRef

OBJECT

name

STRING

value

STRING

Percent

NUMBER

PriceLevelRef

OBJECT

name

STRING

value

STRING

Qty

INTEGER

ServiceDate

DATE-TIME

TaxClassificationRef

OBJECT

name

STRING

value

STRING

TaxCodeRef

OBJECT

name

STRING

value

STRING

TaxInclusiveAmt

NUMBER

UnitPrice

NUMBER

SubtotalLineDetail

OBJECT

ItemRef

OBJECT

name

STRING

value

STRING

LinkedTxn

ARRAY

TxnId

STRING

TxnLineId

STRING

TxnType

STRING

MetaData

OBJECT

CreateTime

DATE-TIME

LastUpdatedTime

DATE-TIME

PrintStatus

STRING

PrivateNote

STRING

RecurDataRef

OBJECT

name

STRING

value

STRING

SalesTermRef

OBJECT

name

STRING

value

STRING

ShipAddr

OBJECT

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Id

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

ShipDate

DATE-TIME

ShipFromAddr

OBJECT

City

STRING

Country

STRING

CountrySubDivisionCode

STRING

Id

STRING

Lat

STRING

Line1

STRING

Line2

STRING

Line3

STRING

Line4

STRING

Line5

STRING

Long

STRING

PostalCode

STRING

ShipMethodRef

OBJECT

name

STRING

value

STRING

SyncToken

STRING

TaxExemptionRef

OBJECT

name

STRING

value

STRING

TotalAmt

NUMBER

TrackingNum

STRING

TransactionLocationType

STRING

TxnDate

DATE-TIME

TxnSource

STRING

TxnTaxDetail

OBJECT

TaxLine

ARRAY

Amount

NUMBER

DetailType

STRING

TaxLineDetail

OBJECT

NetAmountTaxable

NUMBER

OverrideDeltaAmount

NUMBER

PercentBased

BOOLEAN

TaxInclusiveAmount

NUMBER

TaxPercent

NUMBER

TaxRateRef

OBJECT

name

STRING

value

STRING

TotalTax

NUMBER

TxnTaxCodeRef

OBJECT

name

STRING

value

STRING

domain

STRING

patternProperties

OBJECT

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

Id

Useful links

QuickBooks documentation

items schema on GitHub

QuickBooks API method

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
items.ClassRef.value = sales_receipts.ClassRef.value
items.Id = sales_receipts.Line.SalesItemLineDetail.ItemRef.value
items.ParentRef.value = sales_receipts.Line.SalesItemLineDetail.ItemRef.value
items.PurchaseTaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value
items.SalesTaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value
transfers
items.AssetAccountRef.value = transfers.FromAccountRef.value
items.ExpenseAccountRef.value = transfers.FromAccountRef.value
items.IncomeAccountRef.value = transfers.FromAccountRef.value
items.AssetAccountRef.value = transfers.ToAccountRef.value
items.ExpenseAccountRef.value = transfers.ToAccountRef.value
items.IncomeAccountRef.value = transfers.ToAccountRef.value
vendor_credits
items.AssetAccountRef.value = vendor_credits.APAccountRef.value
items.ExpenseAccountRef.value = vendor_credits.APAccountRef.value
items.IncomeAccountRef.value = vendor_credits.APAccountRef.value
items.AssetAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value
items.ExpenseAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value
items.IncomeAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value
items.ClassRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value
items.PurchaseTaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value
items.SalesTaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value
items.PrefVendorRef.value = vendor_credits.VendorRef.value
classes
items.ClassRef.value = classes.Id
items.ClassRef.value = classes.ParentRef.value
credit_memos
items.ClassRef.value = credit_memos.ClassRef.value
items.Id = credit_memos.Line.SalesItemLineDetail.ItemRef.value
items.ParentRef.value = credit_memos.Line.SalesItemLineDetail.ItemRef.value
items.PurchaseTaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value
items.SalesTaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value
estimates