Quickbooks Connector Reference

The Quickbooks connector exposes 685 fields (145 metrics, 540 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Quickbooks Fields

Quickbooks accounts fields

The accounts report of the Quickbooks connector includes 18 fields.

ID	Type	Name	Description
accounts__accountsubtype	TEXT	accounts.AccountSubType	accounts.AccountSubType
accounts__accounttype	TEXT	accounts.AccountType	accounts.AccountType
accounts__acctnum	TEXT	accounts.AcctNum	accounts.AcctNum
accounts__active	BOOLEAN	accounts.Active	accounts.Active
accounts__airbyte_cursor	TEXT	accounts.airbyte_cursor	accounts.airbyte_cursor
accounts__classification	TEXT	accounts.Classification	accounts.Classification
accounts__currencyref	OBJECT	accounts.CurrencyRef	accounts.CurrencyRef
accounts__currentbalance	NUMERIC	accounts.CurrentBalance	accounts.CurrentBalance
accounts__currentbalancewithsubaccounts	NUMERIC	accounts.CurrentBalanceWithSubAccounts	accounts.CurrentBalanceWithSubAccounts
accounts__domain	TEXT	accounts.domain	accounts.domain
accounts__fullyqualifiedname	TEXT	accounts.FullyQualifiedName	accounts.FullyQualifiedName
accounts__id	TEXT	accounts.Id	accounts.Id
accounts__metadata	OBJECT	accounts.MetaData	accounts.MetaData
accounts__name	TEXT	accounts.Name	accounts.Name
accounts__parentref	OBJECT	accounts.ParentRef	accounts.ParentRef
accounts__sparse	BOOLEAN	accounts.sparse	accounts.sparse
accounts__subaccount	BOOLEAN	accounts.SubAccount	accounts.SubAccount
accounts__synctoken	TEXT	accounts.SyncToken	accounts.SyncToken

Quickbooks agedpayabledetail fields

The agedpayabledetail report of the Quickbooks connector includes 12 fields.

ID	Type	Name	Description
agedpayabledetail__item__aging_period	TEXT	agedpayabledetail.Item.AgingPeriod	Aging bucket the transaction falls into as of the report date (Current, 1 - 30 days past due, ...)
agedpayabledetail__item__dept_name	TEXT	agedpayabledetail.Item.DepartmentName	Location / department name
agedpayabledetail__item__doc_num	TEXT	agedpayabledetail.Item.DocNum	Document number
agedpayabledetail__item__due_date	DATE	agedpayabledetail.Item.DueDate	Due date; empty for transactions without one (e.g. supplier credits)
agedpayabledetail__item__past_due	NUMERIC	agedpayabledetail.Item.PastDue	Days past due as of the report date
agedpayabledetail__item__subt_neg_home_amount	NUMERIC	agedpayabledetail.Item.Amount	Transaction amount in the home currency
agedpayabledetail__item__subt_neg_home_open_bal	NUMERIC	agedpayabledetail.Item.OpenBalance	Open balance in the home currency as of the report date
agedpayabledetail__item__tx_date	DATE	agedpayabledetail.Item.Date	Transaction date
agedpayabledetail__item__txn_id	TEXT	agedpayabledetail.Item.TransactionId	Transaction ID; QuickBooks IDs are realm-local, so match destination rows on account_id, date, txn_id and txn_type
agedpayabledetail__item__txn_type	TEXT	agedpayabledetail.Item.TransactionType	Transaction type (Bill, Cheque Expense, Supplier Credit, ...)
agedpayabledetail__item__vend_name	TEXT	agedpayabledetail.Item.VendorName	Vendor (supplier) name
agedpayabledetail__item__vend_name__id	TEXT	agedpayabledetail.Item.VendorId	Vendor (supplier) ID

Quickbooks agedpayables fields

The agedpayables report of the Quickbooks connector includes 6 fields.

ID	Type	Name	Description
agedpayables__1_30	NUMERIC	agedpayables.1_30	1 - 30
agedpayables__31_60	NUMERIC	agedpayables.31_60	31 - 60
agedpayables__61_90	NUMERIC	agedpayables.61_90	61 - 90
agedpayables__91andover	NUMERIC	agedpayables.91andover	91 and over
agedpayables__current	NUMERIC	agedpayables.Current	Current
agedpayables__total	NUMERIC	agedpayables.Total	Total

Quickbooks agedreceivables fields

The agedreceivables report of the Quickbooks connector includes 6 fields.

ID	Type	Name	Description
agedreceivables__1_30	NUMERIC	agedreceivables.1_30	1 - 30
agedreceivables__31_60	NUMERIC	agedreceivables.31_60	31 - 60
agedreceivables__61_90	NUMERIC	agedreceivables.61_90	61 - 90
agedreceivables__91andover	NUMERIC	agedreceivables.91andover	91 and over
agedreceivables__current	NUMERIC	agedreceivables.Current	Current
agedreceivables__total	NUMERIC	agedreceivables.Total	Total

Quickbooks balancesheet fields

The balancesheet report of the Quickbooks connector includes 14 fields.

ID	Type	Name	Description
balancesheet__totalassets	NUMERIC	balancesheet.TotalAssets	Total Assets
balancesheet__totalassets__currentassets	NUMERIC	balancesheet.TotalAssets.CurrentAssets	Current Assets
balancesheet__totalassets__currentassets__ar	NUMERIC	balancesheet.TotalAssets.CurrentAssets.AR	AR
balancesheet__totalassets__currentassets__bankaccounts	NUMERIC	balancesheet.TotalAssets.CurrentAssets.BankAccounts	Bank Accounts
balancesheet__totalassets__currentassets__othercurrentassets	NUMERIC	balancesheet.TotalAssets.CurrentAssets.OtherCurrentAssets	Other Current Assets
balancesheet__totalassets__fixedassets	NUMERIC	balancesheet.TotalAssets.FixedAssets	Fixed Assets
balancesheet__totalliabilitiesandequity	NUMERIC	balancesheet.TotalLiabilitiesAndEquity	Total Liabilities and Equity
balancesheet__totalliabilitiesandequity__equity	NUMERIC	balancesheet.TotalLiabilitiesAndEquity.Equity	Equity
balancesheet__totalliabilitiesandequity__equity__netincome	NUMERIC	balancesheet.TotalLiabilitiesAndEquity.Equity.NetIncome	Net Income
balancesheet__totalliabilitiesandequity__liabilities	NUMERIC	balancesheet.TotalLiabilitiesAndEquity.Liabilities	Liabilities
balancesheet__totalliabilitiesandequity__liabilities__currentliabilities	NUMERIC	balancesheet.TotalLiabilitiesAndEquity.Liabilities.CurrentLiabilities	Current Liabilities
balancesheet__totalliabilitiesandequity__liabilities__currentliabilities__ap	NUMERIC	balancesheet.TotalLiabilitiesAndEquity.Liabilities.CurrentLiabilities.AP	AP
balancesheet__totalliabilitiesandequity__liabilities__currentliabilities__creditcards	NUMERIC	balancesheet.TotalLiabilitiesAndEquity.Liabilities.CurrentLiabilities.CreditCards	Credit Cards
balancesheet__totalliabilitiesandequity__liabilities__currentliabilities__OtherCurrentLiabilities	NUMERIC	balancesheet.TotalLiabilitiesAndEquity.Liabilities.CurrentLiabilities.OtherCurrentLiabilities	Other Current Liabilities

Quickbooks bill_payments fields

The bill_payments report of the Quickbooks connector includes 18 fields.

ID	Type	Name	Description
bill_payments__airbyte_cursor	TEXT	bill_payments.airbyte_cursor	bill_payments.airbyte_cursor
bill_payments__apaccountref	OBJECT	bill_payments.APAccountRef	bill_payments.APAccountRef
bill_payments__checkpayment	OBJECT	bill_payments.CheckPayment	bill_payments.CheckPayment
bill_payments__creditcardpayment	OBJECT	bill_payments.CreditCardPayment	bill_payments.CreditCardPayment
bill_payments__currencyref	OBJECT	bill_payments.CurrencyRef	bill_payments.CurrencyRef
bill_payments__departmentref	OBJECT	bill_payments.DepartmentRef	bill_payments.DepartmentRef
bill_payments__docnumber	TEXT	bill_payments.DocNumber	bill_payments.DocNumber
bill_payments__domain	TEXT	bill_payments.domain	bill_payments.domain
bill_payments__exchangerate	NUMERIC	bill_payments.ExchangeRate	bill_payments.ExchangeRate
bill_payments__id	TEXT	bill_payments.Id	bill_payments.Id
bill_payments__line	OBJECT	bill_payments.Line	bill_payments.Line
bill_payments__metadata	OBJECT	bill_payments.MetaData	bill_payments.MetaData
bill_payments__paytype	TEXT	bill_payments.PayType	bill_payments.PayType
bill_payments__sparse	BOOLEAN	bill_payments.sparse	bill_payments.sparse
bill_payments__synctoken	TEXT	bill_payments.SyncToken	bill_payments.SyncToken
bill_payments__totalamt	NUMERIC	bill_payments.TotalAmt	bill_payments.TotalAmt
bill_payments__txndate	TEXT	bill_payments.TxnDate	bill_payments.TxnDate
bill_payments__vendorref	OBJECT	bill_payments.VendorRef	bill_payments.VendorRef

Quickbooks bills fields

The bills report of the Quickbooks connector includes 20 fields.

ID	Type	Name	Description
bills__airbyte_cursor	TEXT	bills.airbyte_cursor	bills.airbyte_cursor
bills__apaccountref	OBJECT	bills.APAccountRef	bills.APAccountRef
bills__balance	NUMERIC	bills.Balance	bills.Balance
bills__currencyref	OBJECT	bills.CurrencyRef	bills.CurrencyRef
bills__departmentref	OBJECT	bills.DepartmentRef	bills.DepartmentRef
bills__docnumber	TEXT	bills.DocNumber	bills.DocNumber
bills__domain	TEXT	bills.domain	bills.domain
bills__duedate	TEXT	bills.DueDate	bills.DueDate
bills__exchangerate	NUMERIC	bills.ExchangeRate	bills.ExchangeRate
bills__id	TEXT	bills.Id	bills.Id
bills__line	OBJECT	bills.Line	bills.Line
bills__linkedtxn	OBJECT	bills.LinkedTxn	bills.LinkedTxn
bills__metadata	OBJECT	bills.MetaData	bills.MetaData
bills__privatenote	TEXT	bills.PrivateNote	bills.PrivateNote
bills__salestermref	OBJECT	bills.SalesTermRef	bills.SalesTermRef
bills__sparse	BOOLEAN	bills.sparse	bills.sparse
bills__synctoken	TEXT	bills.SyncToken	bills.SyncToken
bills__totalamt	NUMERIC	bills.TotalAmt	bills.TotalAmt
bills__txndate	TEXT	bills.TxnDate	bills.TxnDate
bills__vendorref	OBJECT	bills.VendorRef	bills.VendorRef

Quickbooks budgets fields

The budgets report of the Quickbooks connector includes 12 fields.

ID	Type	Name	Description
budgets__active	BOOLEAN	budgets.Active	budgets.Active
budgets__airbyte_cursor	TEXT	budgets.airbyte_cursor	budgets.airbyte_cursor
budgets__budgetdetail	OBJECT	budgets.BudgetDetail	budgets.BudgetDetail
budgets__budgetentrytype	TEXT	budgets.BudgetEntryType	budgets.BudgetEntryType
budgets__budgettype	TEXT	budgets.BudgetType	budgets.BudgetType
budgets__domain	TEXT	budgets.domain	budgets.domain
budgets__enddate	TEXT	budgets.EndDate	budgets.EndDate
budgets__id	TEXT	budgets.Id	budgets.Id
budgets__metadata	OBJECT	budgets.MetaData	budgets.MetaData
budgets__name	TEXT	budgets.Name	budgets.Name
budgets__startdate	TEXT	budgets.StartDate	budgets.StartDate
budgets__synctoken	TEXT	budgets.SyncToken	budgets.SyncToken

Quickbooks cashflow fields

The cashflow report of the Quickbooks connector includes 8 fields.

ID	Type	Name	Description
cashflow__beginningcash	NUMERIC	cashflow.BeginningCash	Cash at beginning of period
cashflow__cashincrease	NUMERIC	cashflow.CashIncrease	Net cash increase for period
cashflow__endingcash	NUMERIC	cashflow.EndingCash	Cash at end of period
cashflow__financingactivities	NUMERIC	cashflow.FinancingActivities	Net cash provided by financing activities (available only for US, CA, GB, IN, AU locales)
cashflow__investingactivities	NUMERIC	cashflow.InvestingActivities	Net cash provided by investing activities (available only for GB, IN, AU locales)
cashflow__operatingactivities	NUMERIC	cashflow.OperatingActivities	Net cash provided by operating activities
cashflow__operatingactivities__netincome	NUMERIC	cashflow.OperatingActivities.NetIncome	Net Income
cashflow__operatingactivities__operatingadjustments	NUMERIC	cashflow.OperatingActivities.OperatingAdjustments	Adjustments to reconcile Net Income to Net Cash provided by operations

Quickbooks classes fields

The classes report of the Quickbooks connector includes 10 fields.

ID	Type	Name	Description
classes__active	BOOLEAN	classes.Active	classes.Active
classes__airbyte_cursor	TEXT	classes.airbyte_cursor	classes.airbyte_cursor
classes__domain	TEXT	classes.domain	classes.domain
classes__fullyqualifiedname	TEXT	classes.FullyQualifiedName	classes.FullyQualifiedName
classes__id	TEXT	classes.Id	classes.Id
classes__metadata	OBJECT	classes.MetaData	classes.MetaData
classes__name	TEXT	classes.Name	classes.Name
classes__parentref	OBJECT	classes.ParentRef	classes.ParentRef
classes__subclass	BOOLEAN	classes.SubClass	classes.SubClass
classes__synctoken	TEXT	classes.SyncToken	classes.SyncToken

Quickbooks credit_memos fields

The credit_memos report of the Quickbooks connector includes 27 fields.

ID	Type	Name	Description
credit_memos__airbyte_cursor	TEXT	credit_memos.airbyte_cursor	credit_memos.airbyte_cursor
credit_memos__applytaxafterdiscount	BOOLEAN	credit_memos.ApplyTaxAfterDiscount	credit_memos.ApplyTaxAfterDiscount
credit_memos__balance	NUMERIC	credit_memos.Balance	credit_memos.Balance
credit_memos__billaddr	OBJECT	credit_memos.BillAddr	credit_memos.BillAddr
credit_memos__billemail	OBJECT	credit_memos.BillEmail	credit_memos.BillEmail
credit_memos__classref	OBJECT	credit_memos.ClassRef	credit_memos.ClassRef
credit_memos__currencyref	OBJECT	credit_memos.CurrencyRef	credit_memos.CurrencyRef
credit_memos__customermemo	OBJECT	credit_memos.CustomerMemo	credit_memos.CustomerMemo
credit_memos__customerref	OBJECT	credit_memos.CustomerRef	credit_memos.CustomerRef
credit_memos__customfield	OBJECT	credit_memos.CustomField	credit_memos.CustomField
credit_memos__docnumber	TEXT	credit_memos.DocNumber	credit_memos.DocNumber
credit_memos__domain	TEXT	credit_memos.domain	credit_memos.domain
credit_memos__emailstatus	TEXT	credit_memos.EmailStatus	credit_memos.EmailStatus
credit_memos__exchangerate	NUMERIC	credit_memos.ExchangeRate	credit_memos.ExchangeRate
credit_memos__hometotalamt	NUMERIC	credit_memos.HomeTotalAmt	credit_memos.HomeTotalAmt
credit_memos__id	TEXT	credit_memos.Id	credit_memos.Id
credit_memos__line	OBJECT	credit_memos.Line	credit_memos.Line
credit_memos__metadata	OBJECT	credit_memos.MetaData	credit_memos.MetaData
credit_memos__printstatus	TEXT	credit_memos.PrintStatus	credit_memos.PrintStatus
credit_memos__remainingcredit	NUMERIC	credit_memos.RemainingCredit	credit_memos.RemainingCredit
credit_memos__salestermref	OBJECT	credit_memos.SalesTermRef	credit_memos.SalesTermRef
credit_memos__shipaddr	OBJECT	credit_memos.ShipAddr	credit_memos.ShipAddr
credit_memos__sparse	BOOLEAN	credit_memos.sparse	credit_memos.sparse
credit_memos__synctoken	TEXT	credit_memos.SyncToken	credit_memos.SyncToken
credit_memos__totalamt	NUMERIC	credit_memos.TotalAmt	credit_memos.TotalAmt
credit_memos__txndate	TEXT	credit_memos.TxnDate	credit_memos.TxnDate
credit_memos__txntaxdetail	OBJECT	credit_memos.TxnTaxDetail	credit_memos.TxnTaxDetail

Quickbooks customers fields

The customers report of the Quickbooks connector includes 34 fields.

ID	Type	Name	Description
customers__active	BOOLEAN	customers.Active	customers.Active
customers__airbyte_cursor	TEXT	customers.airbyte_cursor	customers.airbyte_cursor
customers__balance	NUMERIC	customers.Balance	customers.Balance
customers__balancewithjobs	NUMERIC	customers.BalanceWithJobs	customers.BalanceWithJobs
customers__billaddr	OBJECT	customers.BillAddr	customers.BillAddr
customers__billwithparent	BOOLEAN	customers.BillWithParent	customers.BillWithParent
customers__companyname	TEXT	customers.CompanyName	customers.CompanyName
customers__currencyref	OBJECT	customers.CurrencyRef	customers.CurrencyRef
customers__defaulttaxcoderef	OBJECT	customers.DefaultTaxCodeRef	customers.DefaultTaxCodeRef
customers__displayname	TEXT	customers.DisplayName	customers.DisplayName
customers__domain	TEXT	customers.domain	customers.domain
customers__familyname	TEXT	customers.FamilyName	customers.FamilyName
customers__fax	OBJECT	customers.Fax	customers.Fax
customers__fullyqualifiedname	TEXT	customers.FullyQualifiedName	customers.FullyQualifiedName
customers__givenname	TEXT	customers.GivenName	customers.GivenName
customers__id	TEXT	customers.Id	customers.Id
customers__job	BOOLEAN	customers.Job	customers.Job
customers__level	NUMERIC	customers.Level	customers.Level
customers__metadata	OBJECT	customers.MetaData	customers.MetaData
customers__middlename	TEXT	customers.MiddleName	customers.MiddleName
customers__mobile	OBJECT	customers.Mobile	customers.Mobile
customers__parentref	OBJECT	customers.ParentRef	customers.ParentRef
customers__paymentmethodref	OBJECT	customers.PaymentMethodRef	customers.PaymentMethodRef
customers__preferreddeliverymethod	TEXT	customers.PreferredDeliveryMethod	customers.PreferredDeliveryMethod
customers__primaryemailaddr	OBJECT	customers.PrimaryEmailAddr	customers.PrimaryEmailAddr
customers__primaryphone	OBJECT	customers.PrimaryPhone	customers.PrimaryPhone
customers__printoncheckname	TEXT	customers.PrintOnCheckName	customers.PrintOnCheckName
customers__resalenum	TEXT	customers.ResaleNum	customers.ResaleNum
customers__salestermref	OBJECT	customers.SalesTermRef	customers.SalesTermRef
customers__shipaddr	OBJECT	customers.ShipAddr	customers.ShipAddr
customers__sparse	BOOLEAN	customers.sparse	customers.sparse
customers__synctoken	TEXT	customers.SyncToken	customers.SyncToken
customers__taxable	BOOLEAN	customers.Taxable	customers.Taxable
customers__webaddr	OBJECT	customers.WebAddr	customers.WebAddr

Quickbooks departments fields

The departments report of the Quickbooks connector includes 10 fields.

ID	Type	Name	Description
departments__active	BOOLEAN	departments.Active	departments.Active
departments__airbyte_cursor	TEXT	departments.airbyte_cursor	departments.airbyte_cursor
departments__domain	TEXT	departments.domain	departments.domain
departments__fullyqualifiedname	TEXT	departments.FullyQualifiedName	departments.FullyQualifiedName
departments__id	TEXT	departments.Id	departments.Id
departments__metadata	OBJECT	departments.MetaData	departments.MetaData
departments__name	TEXT	departments.Name	departments.Name
departments__parentref	OBJECT	departments.ParentRef	departments.ParentRef
departments__subdepartment	BOOLEAN	departments.SubDepartment	departments.SubDepartment
departments__synctoken	TEXT	departments.SyncToken	departments.SyncToken

Quickbooks deposits fields

The deposits report of the Quickbooks connector includes 15 fields.

ID	Type	Name	Description
deposits__airbyte_cursor	TEXT	deposits.airbyte_cursor	deposits.airbyte_cursor
deposits__cashback	OBJECT	deposits.CashBack	deposits.CashBack
deposits__currencyref	OBJECT	deposits.CurrencyRef	deposits.CurrencyRef
deposits__departmentref	OBJECT	deposits.DepartmentRef	deposits.DepartmentRef
deposits__deposittoaccountref	OBJECT	deposits.DepositToAccountRef	deposits.DepositToAccountRef
deposits__domain	TEXT	deposits.domain	deposits.domain
deposits__exchangerate	NUMERIC	deposits.ExchangeRate	deposits.ExchangeRate
deposits__id	TEXT	deposits.Id	deposits.Id
deposits__line	OBJECT	deposits.Line	deposits.Line
deposits__metadata	OBJECT	deposits.MetaData	deposits.MetaData
deposits__privatenote	TEXT	deposits.PrivateNote	deposits.PrivateNote
deposits__sparse	BOOLEAN	deposits.sparse	deposits.sparse
deposits__synctoken	TEXT	deposits.SyncToken	deposits.SyncToken
deposits__totalamt	NUMERIC	deposits.TotalAmt	deposits.TotalAmt
deposits__txndate	TEXT	deposits.TxnDate	deposits.TxnDate

Quickbooks employees fields

The employees report of the Quickbooks connector includes 26 fields.

ID	Type	Name	Description
employees__active	BOOLEAN	employees.Active	employees.Active
employees__airbyte_cursor	TEXT	employees.airbyte_cursor	employees.airbyte_cursor
employees__billabletime	BOOLEAN	employees.BillableTime	employees.BillableTime
employees__billrate	NUMERIC	employees.BillRate	employees.BillRate
employees__birthdate	TEXT	employees.BirthDate	employees.BirthDate
employees__displayname	TEXT	employees.DisplayName	employees.DisplayName
employees__domain	TEXT	employees.domain	employees.domain
employees__employeenumber	TEXT	employees.EmployeeNumber	employees.EmployeeNumber
employees__familyname	TEXT	employees.FamilyName	employees.FamilyName
employees__gender	TEXT	employees.Gender	employees.Gender
employees__givenname	TEXT	employees.GivenName	employees.GivenName
employees__hireddate	TEXT	employees.HiredDate	employees.HiredDate
employees__id	TEXT	employees.Id	employees.Id
employees__metadata	OBJECT	employees.MetaData	employees.MetaData
employees__middlename	TEXT	employees.MiddleName	employees.MiddleName
employees__mobile	OBJECT	employees.Mobile	employees.Mobile
employees__organization	BOOLEAN	employees.Organization	employees.Organization
employees__primaryaddr	OBJECT	employees.PrimaryAddr	employees.PrimaryAddr
employees__primaryemailaddr	OBJECT	employees.PrimaryEmailAddr	employees.PrimaryEmailAddr
employees__primaryphone	OBJECT	employees.PrimaryPhone	employees.PrimaryPhone
employees__printoncheckname	TEXT	employees.PrintOnCheckName	employees.PrintOnCheckName
employees__releaseddate	TEXT	employees.ReleasedDate	employees.ReleasedDate
employees__sparse	BOOLEAN	employees.sparse	employees.sparse
employees__suffix	TEXT	employees.Suffix	employees.Suffix
employees__synctoken	TEXT	employees.SyncToken	employees.SyncToken
employees__title	TEXT	employees.Title	employees.Title

Quickbooks estimates fields

The estimates report of the Quickbooks connector includes 26 fields.

ID	Type	Name	Description
estimates__airbyte_cursor	TEXT	estimates.airbyte_cursor	estimates.airbyte_cursor
estimates__applytaxafterdiscount	BOOLEAN	estimates.ApplyTaxAfterDiscount	estimates.ApplyTaxAfterDiscount
estimates__billaddr	OBJECT	estimates.BillAddr	estimates.BillAddr
estimates__billemail	OBJECT	estimates.BillEmail	estimates.BillEmail
estimates__currencyref	OBJECT	estimates.CurrencyRef	estimates.CurrencyRef
estimates__customermemo	OBJECT	estimates.CustomerMemo	estimates.CustomerMemo
estimates__customerref	OBJECT	estimates.CustomerRef	estimates.CustomerRef
estimates__customfield	OBJECT	estimates.CustomField	estimates.CustomField
estimates__deliveryinfo	OBJECT	estimates.DeliveryInfo	estimates.DeliveryInfo
estimates__docnumber	TEXT	estimates.DocNumber	estimates.DocNumber
estimates__domain	TEXT	estimates.domain	estimates.domain
estimates__emailstatus	TEXT	estimates.EmailStatus	estimates.EmailStatus
estimates__exchangerate	NUMERIC	estimates.ExchangeRate	estimates.ExchangeRate
estimates__hometotalamt	NUMERIC	estimates.HomeTotalAmt	estimates.HomeTotalAmt
estimates__id	TEXT	estimates.Id	estimates.Id
estimates__line	OBJECT	estimates.Line	estimates.Line
estimates__linkedtxn	OBJECT	estimates.LinkedTxn	estimates.LinkedTxn
estimates__metadata	OBJECT	estimates.MetaData	estimates.MetaData
estimates__printstatus	TEXT	estimates.PrintStatus	estimates.PrintStatus
estimates__shipaddr	OBJECT	estimates.ShipAddr	estimates.ShipAddr
estimates__sparse	BOOLEAN	estimates.sparse	estimates.sparse
estimates__synctoken	TEXT	estimates.SyncToken	estimates.SyncToken
estimates__totalamt	NUMERIC	estimates.TotalAmt	estimates.TotalAmt
estimates__txndate	TEXT	estimates.TxnDate	estimates.TxnDate
estimates__txnstatus	TEXT	estimates.TxnStatus	estimates.TxnStatus
estimates__txntaxdetail	OBJECT	estimates.TxnTaxDetail	estimates.TxnTaxDetail

Quickbooks generalledger fields

The generalledger report of the Quickbooks connector includes 48 fields.

Quickbooks generalledger fields (generalledger__item__account_id to generalledger__item__subt_nat_amount)

ID	Type	Name	Description
generalledger__item__account_id	TEXT	generalledger.Item.account_id	Account
generalledger__item__account_name	TEXT	generalledger.Item.account_name	Account
generalledger__item__chk_print_state	TEXT	generalledger.Item.chk_print_state	Check Printed
generalledger__item__create_by	TEXT	generalledger.Item.create_by	Created By
generalledger__item__create_date	DATE	generalledger.Item.create_date	Create Date
generalledger__item__credit_amt	NUMERIC	generalledger.Item.credit_amt	Credit Amount
generalledger__item__credit_home_amt	NUMERIC	generalledger.Item.credit_home_amt.Multicurrency	Credit Amount (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__currency	TEXT	generalledger.Item.currency.Multicurrency	Currency (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__cust_name	TEXT	generalledger.Item.cust_name	Customer
generalledger__item__debt_amt	NUMERIC	generalledger.Item.debt_amt	Debit Amount
generalledger__item__debt_home_amt	NUMERIC	generalledger.Item.debt_home_amt.Multicurrency	Debit Amount (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__doc_num	TEXT	generalledger.Item.doc_num	Num
generalledger__item__emp_name	TEXT	generalledger.Item.emp_name	Employee
generalledger__item__exch_rate	NUMERIC	generalledger.Item.exch_rate.Multicurrency	Exchange Rate (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__home_net_amount	NUMERIC	generalledger.Item.net_amount.Multicurrency	Taxable Amount (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__home_tax_amount	NUMERIC	generalledger.Item.tax_amount.Multicurrency	Tax Amount (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__inv_date	DATE	generalledger.Item.inv_date	Invoice Date
generalledger__item__is_adj	TEXT	generalledger.Item.is_adj	Adj
generalledger__item__is_ap_paid	TEXT	generalledger.Item.is_ap_paid	A/P Paid
generalledger__item__is_ar_paid	TEXT	generalledger.Item.is_ar_paid	A/R Paid
generalledger__item__is_cleared	TEXT	generalledger.Item.is_cleared	Cleared
generalledger__item__item_name	TEXT	generalledger.Item.item_name	Product/Service
generalledger__item__last_mod_by	TEXT	generalledger.Item.last_mod_by	Last Modified By
generalledger__item__last_mod_date	DATE	generalledger.Item.last_mod_date	Last Modified Date
generalledger__item__line_id	TEXT	generalledger.Item.line_id	Deterministic key per ledger line; use as the only column to match when syncing to a destination
generalledger__item__memo	TEXT	generalledger.Item.memo	Memo/Description
generalledger__item__name	TEXT	generalledger.Item.name	Name
generalledger__item__nat_foreign_open_bal	NUMERIC	generalledger.Item.nat_foreign_open_bal.Multicurrency	Open Balance Foreign (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__nat_home_open_bal	NUMERIC	generalledger.Item.nat_home_open_bal.Multicurrency	Open Balance Home (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__nat_open_bal	NUMERIC	generalledger.Item.nat_open_bal	Open Balance
generalledger__item__net_amount	NUMERIC	generalledger.Item.net_amount	Taxable Amount
generalledger__item__quantity	NUMERIC	generalledger.Item.quantity	Quantity
generalledger__item__rate	NUMERIC	generalledger.Item.rate	Rate
generalledger__item__rbal_nat_amount	NUMERIC	generalledger.Item.rbal_nat_amount	Balance use for NonTracking disabled comapanies
generalledger__item__rbal_nat_amount_home_nt	NUMERIC	generalledger.Item.rbal_nat_amount_home_nt.Multicurrency	Balance use for NonTracking enabled comapanies (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__rbal_nat_amount_nt	NUMERIC	generalledger.Item.rbal_nat_amount_nt	Balance use for NonTracking enabled comapanies
generalledger__item__rbal_nat_home_amount	NUMERIC	generalledger.Item.rbal_nat_home_amount.Multicurrency	Balance use for NonTracking disabled comapanies (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__report_index	TEXT	generalledger.Item.report_index	Position of the row within a single query; not stable across queries, never use as a column to match
generalledger__item__split_acc	TEXT	generalledger.Item.split_acc	Split
generalledger__item__subt_nat_amount	NUMERIC	generalledger.Item.subt_nat_amount	Amount use for NonTracking disabled comapanies

Quickbooks generalledger fields (generalledger__item__subt_nat_amount_home_nt to generalledger__item__vendor_name)

ID	Type	Name	Description
generalledger__item__subt_nat_amount_home_nt	NUMERIC	generalledger.Item.subt_nat_amount_home_nt.Multicurrency	Amount use for NonTracking enabled comapanies (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__subt_nat_amount_nt	NUMERIC	generalledger.Item.subt_nat_amount_nt	Amount use for NonTracking enabled comapanies
generalledger__item__subt_nat_home_amount	NUMERIC	generalledger.Item.subt_nat_home_amount.Multicurrency	Amount use for NonTracking disabled comapanies (Multicurrency enabled https://developer.intuit.com/app/developer/qbo/docs/workflows/manage-multiple-currencies)
generalledger__item__tax_amount	NUMERIC	generalledger.Item.tax_amount	Tax Amount
generalledger__item__tx_date	DATE	generalledger.Item.tx_date	Transaction Date
generalledger__item__txn_id	TEXT	generalledger.Item.txn_id	QuickBooks transaction id; shared by every line of the same transaction
generalledger__item__txn_type	TEXT	generalledger.Item.txn_type	Transaction Type
generalledger__item__vendor_name	TEXT	generalledger.Item.vendor_name	Vendor

Quickbooks invoices fields

The invoices report of the Quickbooks connector includes 33 fields.

ID	Type	Name	Description
invoices__airbyte_cursor	TEXT	invoices.airbyte_cursor	invoices.airbyte_cursor
invoices__allowipnpayment	BOOLEAN	invoices.AllowIPNPayment	invoices.AllowIPNPayment
invoices__allowonlineachpayment	BOOLEAN	invoices.AllowOnlineACHPayment	invoices.AllowOnlineACHPayment
invoices__allowonlinecreditcardpayment	BOOLEAN	invoices.AllowOnlineCreditCardPayment	invoices.AllowOnlineCreditCardPayment
invoices__allowonlinepayment	BOOLEAN	invoices.AllowOnlinePayment	invoices.AllowOnlinePayment
invoices__applytaxafterdiscount	BOOLEAN	invoices.ApplyTaxAfterDiscount	invoices.ApplyTaxAfterDiscount
invoices__balance	NUMERIC	invoices.Balance	invoices.Balance
invoices__billaddr	OBJECT	invoices.BillAddr	invoices.BillAddr
invoices__billemail	OBJECT	invoices.BillEmail	invoices.BillEmail
invoices__currencyref	OBJECT	invoices.CurrencyRef	invoices.CurrencyRef
invoices__customermemo	OBJECT	invoices.CustomerMemo	invoices.CustomerMemo
invoices__customerref	OBJECT	invoices.CustomerRef	invoices.CustomerRef
invoices__customfield	OBJECT	invoices.CustomField	invoices.CustomField
invoices__deliveryinfo	OBJECT	invoices.DeliveryInfo	invoices.DeliveryInfo
invoices__docnumber	TEXT	invoices.DocNumber	invoices.DocNumber
invoices__domain	TEXT	invoices.domain	invoices.domain
invoices__duedate	TEXT	invoices.DueDate	invoices.DueDate
invoices__emailstatus	TEXT	invoices.EmailStatus	invoices.EmailStatus
invoices__exchangerate	NUMERIC	invoices.ExchangeRate	invoices.ExchangeRate
invoices__hometotalamt	NUMERIC	invoices.HomeTotalAmt	invoices.HomeTotalAmt
invoices__id	TEXT	invoices.Id	invoices.Id
invoices__line	OBJECT	invoices.Line	invoices.Line
invoices__linkedtxn	OBJECT	invoices.LinkedTxn	invoices.LinkedTxn
invoices__metadata	OBJECT	invoices.MetaData	invoices.MetaData
invoices__printstatus	TEXT	invoices.PrintStatus	invoices.PrintStatus
invoices__privatenote	TEXT	invoices.PrivateNote	invoices.PrivateNote
invoices__salestermref	OBJECT	invoices.SalesTermRef	invoices.SalesTermRef
invoices__shipaddr	OBJECT	invoices.ShipAddr	invoices.ShipAddr
invoices__sparse	BOOLEAN	invoices.sparse	invoices.sparse
invoices__synctoken	TEXT	invoices.SyncToken	invoices.SyncToken
invoices__totalamt	NUMERIC	invoices.TotalAmt	invoices.TotalAmt
invoices__txndate	TEXT	invoices.TxnDate	invoices.TxnDate
invoices__txntaxdetail	OBJECT	invoices.TxnTaxDetail	invoices.TxnTaxDetail

Quickbooks items fields

The items report of the Quickbooks connector includes 21 fields.

ID	Type	Name	Description
items__active	BOOLEAN	items.Active	items.Active
items__airbyte_cursor	TEXT	items.airbyte_cursor	items.airbyte_cursor
items__assetaccountref	OBJECT	items.AssetAccountRef	items.AssetAccountRef
items__description	TEXT	items.Description	items.Description
items__domain	TEXT	items.domain	items.domain
items__expenseaccountref	OBJECT	items.ExpenseAccountRef	items.ExpenseAccountRef
items__fullyqualifiedname	TEXT	items.FullyQualifiedName	items.FullyQualifiedName
items__id	TEXT	items.Id	items.Id
items__incomeaccountref	OBJECT	items.IncomeAccountRef	items.IncomeAccountRef
items__invstartdate	TEXT	items.InvStartDate	items.InvStartDate
items__metadata	OBJECT	items.MetaData	items.MetaData
items__name	TEXT	items.Name	items.Name
items__purchasecost	NUMERIC	items.PurchaseCost	items.PurchaseCost
items__purchasedesc	TEXT	items.PurchaseDesc	items.PurchaseDesc
items__qtyonhand	NUMERIC	items.QtyOnHand	items.QtyOnHand
items__sparse	BOOLEAN	items.sparse	items.sparse
items__synctoken	TEXT	items.SyncToken	items.SyncToken
items__taxable	BOOLEAN	items.Taxable	items.Taxable
items__trackqtyonhand	BOOLEAN	items.TrackQtyOnHand	items.TrackQtyOnHand
items__type	TEXT	items.Type	items.Type
items__unitprice	NUMERIC	items.UnitPrice	items.UnitPrice

Quickbooks journal_entries fields

The journal_entries report of the Quickbooks connector includes 15 fields.

ID	Type	Name	Description
journal_entries__adjustment	BOOLEAN	journal_entries.Adjustment	journal_entries.Adjustment
journal_entries__airbyte_cursor	TEXT	journal_entries.airbyte_cursor	journal_entries.airbyte_cursor
journal_entries__currencyref	OBJECT	journal_entries.CurrencyRef	journal_entries.CurrencyRef
journal_entries__docnumber	TEXT	journal_entries.DocNumber	journal_entries.DocNumber
journal_entries__domain	TEXT	journal_entries.domain	journal_entries.domain
journal_entries__exchangerate	NUMERIC	journal_entries.ExchangeRate	journal_entries.ExchangeRate
journal_entries__id	TEXT	journal_entries.Id	journal_entries.Id
journal_entries__line	OBJECT	journal_entries.Line	journal_entries.Line
journal_entries__metadata	OBJECT	journal_entries.MetaData	journal_entries.MetaData
journal_entries__privatenote	TEXT	journal_entries.PrivateNote	journal_entries.PrivateNote
journal_entries__sparse	BOOLEAN	journal_entries.sparse	journal_entries.sparse
journal_entries__synctoken	TEXT	journal_entries.SyncToken	journal_entries.SyncToken
journal_entries__taxrateref	OBJECT	journal_entries.TaxRateRef	journal_entries.TaxRateRef
journal_entries__txndate	TEXT	journal_entries.TxnDate	journal_entries.TxnDate
journal_entries__txntaxdetail	OBJECT	journal_entries.TxnTaxDetail	journal_entries.TxnTaxDetail

Quickbooks payment_methods fields

The payment_methods report of the Quickbooks connector includes 9 fields.

ID	Type	Name	Description
payment_methods__active	BOOLEAN	payment_methods.Active	payment_methods.Active
payment_methods__airbyte_cursor	TEXT	payment_methods.airbyte_cursor	payment_methods.airbyte_cursor
payment_methods__domain	TEXT	payment_methods.domain	payment_methods.domain
payment_methods__id	TEXT	payment_methods.Id	payment_methods.Id
payment_methods__metadata	OBJECT	payment_methods.MetaData	payment_methods.MetaData
payment_methods__name	TEXT	payment_methods.Name	payment_methods.Name
payment_methods__sparse	BOOLEAN	payment_methods.sparse	payment_methods.sparse
payment_methods__synctoken	TEXT	payment_methods.SyncToken	payment_methods.SyncToken
payment_methods__type	TEXT	payment_methods.Type	payment_methods.Type

Quickbooks payments fields

The payments report of the Quickbooks connector includes 20 fields.

ID	Type	Name	Description
payments__airbyte_cursor	TEXT	payments.airbyte_cursor	payments.airbyte_cursor
payments__araccountref	OBJECT	payments.ARAccountRef	payments.ARAccountRef
payments__currencyref	OBJECT	payments.CurrencyRef	payments.CurrencyRef
payments__customerref	OBJECT	payments.CustomerRef	payments.CustomerRef
payments__deposittoaccountref	OBJECT	payments.DepositToAccountRef	payments.DepositToAccountRef
payments__domain	TEXT	payments.domain	payments.domain
payments__exchangerate	NUMERIC	payments.ExchangeRate	payments.ExchangeRate
payments__id	TEXT	payments.Id	payments.Id
payments__line	OBJECT	payments.Line	payments.Line
payments__linkedtxn	OBJECT	payments.LinkedTxn	payments.LinkedTxn
payments__metadata	OBJECT	payments.MetaData	payments.MetaData
payments__paymentmethodref	OBJECT	payments.PaymentMethodRef	payments.PaymentMethodRef
payments__paymentrefnum	TEXT	payments.PaymentRefNum	payments.PaymentRefNum
payments__privatenote	TEXT	payments.PrivateNote	payments.PrivateNote
payments__processpayment	BOOLEAN	payments.ProcessPayment	payments.ProcessPayment
payments__sparse	BOOLEAN	payments.sparse	payments.sparse
payments__synctoken	TEXT	payments.SyncToken	payments.SyncToken
payments__totalamt	NUMERIC	payments.TotalAmt	payments.TotalAmt
payments__txndate	TEXT	payments.TxnDate	payments.TxnDate
payments__unappliedamt	NUMERIC	payments.UnappliedAmt	payments.UnappliedAmt

Quickbooks profitandloss fields

The profitandloss report of the Quickbooks connector includes 25 fields.

ID	Type	Name	Description
profitandloss__cogs	NUMERIC	profitandloss.COGS	Total Cost of Goods Sold (not available for FR locale)
profitandloss__depreciationandprovisions	NUMERIC	profitandloss.DepreciationAndProvisions	Depreciation and Provisions (available only for FR locale)
profitandloss__employeeparticipationresults	NUMERIC	profitandloss.EmployeeParticipationResults	Employee Participation Results (available only for FR locale)
profitandloss__exceptionalcharges	NUMERIC	profitandloss.ExceptionalCharges	Exceptional Charges (available only for FR locale)
profitandloss__exceptionalitems	NUMERIC	profitandloss.ExceptionalItems	Exceptional Items (available only for FR locale)
profitandloss__expenses	NUMERIC	profitandloss.Expenses	Total Expenses (not available for FR locale)
profitandloss__export	NUMERIC	profitandloss.Export	Export (available only for FR locale)
profitandloss__financialcharges	NUMERIC	profitandloss.FinancialCharges	Financial Charges (available only for FR locale)
profitandloss__financialproducts	NUMERIC	profitandloss.FinancialProducts	Financial Products (available only for FR locale)
profitandloss__grossprofit	NUMERIC	profitandloss.GrossProfit	Gross Profit (not available for FR and CA locales)
profitandloss__including	NUMERIC	profitandloss.Including	Including (available only for FR locale)
profitandloss__income	NUMERIC	profitandloss.Income	Total Income (not available for FR locale)
profitandloss__incometaxexpenses	NUMERIC	profitandloss.IncomeTaxExpenses	Income Tax Expenses (available only for FR locale)
profitandloss__jointoperations	NUMERIC	profitandloss.JointOperations	Joint Operations (available only for FR locale)
profitandloss__netincome	NUMERIC	profitandloss.NetIncome	Net Income (not available for FR locale)
profitandloss__netoperatingincome	NUMERIC	profitandloss.NetOperatingIncome	Net Operating Income (available only for US and GB locales)
profitandloss__netotherincome	NUMERIC	profitandloss.NetOtherIncome	Net Other Income (available only for US and GB locales)
profitandloss__operatingexpenses	NUMERIC	profitandloss.OperatingExpenses	Operating Expenses (available only for FR locale)
profitandloss__otherexpenses	NUMERIC	profitandloss.OtherExpenses	Total Other Expenses (not available for FR locale)
profitandloss__otherincome	NUMERIC	profitandloss.OtherIncome	Total Other Income (not available for US and FR locales)
profitandloss__profitorloss	NUMERIC	profitandloss.ProfitOrLoss	Profit or Loss (available only for FR locale)
profitandloss__quotasresultinjointoperations	NUMERIC	profitandloss.QuotasResultInJointOperations	Quotas Result in Joint Operations (available only for FR locale)
profitandloss__revenue	NUMERIC	profitandloss.Revenue	Revenue (available only for FR locale)
profitandloss__totalexpenses	NUMERIC	profitandloss.TotalExpenses	Total Expenses (available only for FR locale)
profitandloss__totalincome	NUMERIC	profitandloss.TotalIncome	Total Income (available only for FR locale)

Quickbooks purchase_orders fields

The purchase_orders report of the Quickbooks connector includes 28 fields.

ID	Type	Name	Description
purchase_orders__airbyte_cursor	TEXT	purchase_orders.airbyte_cursor	purchase_orders.airbyte_cursor
purchase_orders__apaccountref	OBJECT	purchase_orders.APAccountRef	purchase_orders.APAccountRef
purchase_orders__classref	OBJECT	purchase_orders.ClassRef	purchase_orders.ClassRef
purchase_orders__currencyref	OBJECT	purchase_orders.CurrencyRef	purchase_orders.CurrencyRef
purchase_orders__customfield	OBJECT	purchase_orders.CustomField	purchase_orders.CustomField
purchase_orders__departmentref	OBJECT	purchase_orders.DepartmentRef	purchase_orders.DepartmentRef
purchase_orders__docnumber	TEXT	purchase_orders.DocNumber	purchase_orders.DocNumber
purchase_orders__domain	TEXT	purchase_orders.domain	purchase_orders.domain
purchase_orders__duedate	TEXT	purchase_orders.DueDate	purchase_orders.DueDate
purchase_orders__emailstatus	TEXT	purchase_orders.EmailStatus	purchase_orders.EmailStatus
purchase_orders__exchangerate	NUMERIC	purchase_orders.ExchangeRate	purchase_orders.ExchangeRate
purchase_orders__id	TEXT	purchase_orders.Id	purchase_orders.Id
purchase_orders__line	OBJECT	purchase_orders.Line	purchase_orders.Line
purchase_orders__linkedtxn	OBJECT	purchase_orders.LinkedTxn	purchase_orders.LinkedTxn
purchase_orders__memo	TEXT	purchase_orders.Memo	purchase_orders.Memo
purchase_orders__metadata	OBJECT	purchase_orders.MetaData	purchase_orders.MetaData
purchase_orders__postatus	TEXT	purchase_orders.POStatus	purchase_orders.POStatus
purchase_orders__privatenote	TEXT	purchase_orders.PrivateNote	purchase_orders.PrivateNote
purchase_orders__salestermref	OBJECT	purchase_orders.SalesTermRef	purchase_orders.SalesTermRef
purchase_orders__shipaddr	OBJECT	purchase_orders.ShipAddr	purchase_orders.ShipAddr
purchase_orders__shipto	OBJECT	purchase_orders.ShipTo	purchase_orders.ShipTo
purchase_orders__sparse	BOOLEAN	purchase_orders.sparse	purchase_orders.sparse
purchase_orders__synctoken	TEXT	purchase_orders.SyncToken	purchase_orders.SyncToken
purchase_orders__totalamt	NUMERIC	purchase_orders.TotalAmt	purchase_orders.TotalAmt
purchase_orders__txndate	TEXT	purchase_orders.TxnDate	purchase_orders.TxnDate
purchase_orders__txntaxdetail	OBJECT	purchase_orders.TxnTaxDetail	purchase_orders.TxnTaxDetail
purchase_orders__vendoraddr	OBJECT	purchase_orders.VendorAddr	purchase_orders.VendorAddr
purchase_orders__vendorref	OBJECT	purchase_orders.VendorRef	purchase_orders.VendorRef

Quickbooks purchases fields

The purchases report of the Quickbooks connector includes 20 fields.

ID	Type	Name	Description
purchases__accountref	OBJECT	purchases.AccountRef	purchases.AccountRef
purchases__airbyte_cursor	TEXT	purchases.airbyte_cursor	purchases.airbyte_cursor
purchases__credit	BOOLEAN	purchases.Credit	purchases.Credit
purchases__currencyref	OBJECT	purchases.CurrencyRef	purchases.CurrencyRef
purchases__docnumber	TEXT	purchases.DocNumber	purchases.DocNumber
purchases__domain	TEXT	purchases.domain	purchases.domain
purchases__entityref	OBJECT	purchases.EntityRef	purchases.EntityRef
purchases__exchangerate	NUMERIC	purchases.ExchangeRate	purchases.ExchangeRate
purchases__id	TEXT	purchases.Id	purchases.Id
purchases__line	OBJECT	purchases.Line	purchases.Line
purchases__metadata	OBJECT	purchases.MetaData	purchases.MetaData
purchases__paymenttype	TEXT	purchases.PaymentType	purchases.PaymentType
purchases__printstatus	TEXT	purchases.PrintStatus	purchases.PrintStatus
purchases__privatenote	TEXT	purchases.PrivateNote	purchases.PrivateNote
purchases__purchaseex	OBJECT	purchases.PurchaseEx	purchases.PurchaseEx
purchases__remittoaddr	OBJECT	purchases.RemitToAddr	purchases.RemitToAddr
purchases__sparse	BOOLEAN	purchases.sparse	purchases.sparse
purchases__synctoken	TEXT	purchases.SyncToken	purchases.SyncToken
purchases__totalamt	NUMERIC	purchases.TotalAmt	purchases.TotalAmt
purchases__txndate	TEXT	purchases.TxnDate	purchases.TxnDate

Quickbooks refund_receipts fields

The refund_receipts report of the Quickbooks connector includes 24 fields.

ID	Type	Name	Description
refund_receipts__airbyte_cursor	TEXT	refund_receipts.airbyte_cursor	refund_receipts.airbyte_cursor
refund_receipts__applytaxafterdiscount	BOOLEAN	refund_receipts.ApplyTaxAfterDiscount	refund_receipts.ApplyTaxAfterDiscount
refund_receipts__balance	NUMERIC	refund_receipts.Balance	refund_receipts.Balance
refund_receipts__billaddr	OBJECT	refund_receipts.BillAddr	refund_receipts.BillAddr
refund_receipts__billemail	OBJECT	refund_receipts.BillEmail	refund_receipts.BillEmail
refund_receipts__currencyref	OBJECT	refund_receipts.CurrencyRef	refund_receipts.CurrencyRef
refund_receipts__customermemo	OBJECT	refund_receipts.CustomerMemo	refund_receipts.CustomerMemo
refund_receipts__customerref	OBJECT	refund_receipts.CustomerRef	refund_receipts.CustomerRef
refund_receipts__customfield	OBJECT	refund_receipts.CustomField	refund_receipts.CustomField
refund_receipts__deposittoaccountref	OBJECT	refund_receipts.DepositToAccountRef	refund_receipts.DepositToAccountRef
refund_receipts__docnumber	TEXT	refund_receipts.DocNumber	refund_receipts.DocNumber
refund_receipts__domain	TEXT	refund_receipts.domain	refund_receipts.domain
refund_receipts__exchangerate	NUMERIC	refund_receipts.ExchangeRate	refund_receipts.ExchangeRate
refund_receipts__hometotalamt	NUMERIC	refund_receipts.HomeTotalAmt	refund_receipts.HomeTotalAmt
refund_receipts__id	TEXT	refund_receipts.Id	refund_receipts.Id
refund_receipts__line	OBJECT	refund_receipts.Line	refund_receipts.Line
refund_receipts__metadata	OBJECT	refund_receipts.MetaData	refund_receipts.MetaData
refund_receipts__paymentmethodref	OBJECT	refund_receipts.PaymentMethodRef	refund_receipts.PaymentMethodRef
refund_receipts__printstatus	TEXT	refund_receipts.PrintStatus	refund_receipts.PrintStatus
refund_receipts__sparse	BOOLEAN	refund_receipts.sparse	refund_receipts.sparse
refund_receipts__synctoken	TEXT	refund_receipts.SyncToken	refund_receipts.SyncToken
refund_receipts__totalamt	NUMERIC	refund_receipts.TotalAmt	refund_receipts.TotalAmt
refund_receipts__txndate	TEXT	refund_receipts.TxnDate	refund_receipts.TxnDate
refund_receipts__txntaxdetail	OBJECT	refund_receipts.TxnTaxDetail	refund_receipts.TxnTaxDetail

Quickbooks report fields

The report report of the Quickbooks connector includes 9 fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	Identifier of the connected QuickBooks account
account_name	TEXT	Account Name	Name of the connected QuickBooks account
report__accounts__id	TEXT	report.Accounts.Id	Account ID used for supported fields of report
report__customers__id	TEXT	report.Customers.Id	Customer ID used for supported fields of ARAging Summary report
report__summarize_by__classes__id	TEXT	report.SummarizeBy.Classes.Id	Class ID; select it to break the report down per Class. Combine with report__accounts__id for an Account-by-Class breakdown (e.g. Profit and Loss by Class). Supported for ProfitAndLoss, BalanceSheet, and CashFlow.
report__summarize_by__customers__id	TEXT	report.SummarizeBy.Customers.Id	Customer ID; select it to break the report down per Customer. Combine with report__accounts__id for an Account-by-Customer breakdown. Supported for ProfitAndLoss, BalanceSheet, and CashFlow.
report__summarize_by__employees__id	TEXT	report.SummarizeBy.Employees.Id	Employee ID; select it to break the report down per Employee. Combine with report__accounts__id for an Account-by-Employee breakdown. Supported for ProfitAndLoss, BalanceSheet, and CashFlow.
report__summarize_by__vendors__id	TEXT	report.SummarizeBy.Vendors.Id	Vendor ID; select it to break the report down per Vendor. Combine with report__accounts__id for an Account-by-Vendor breakdown. Supported for ProfitAndLoss, BalanceSheet, and CashFlow.
report__vendors__id	TEXT	report.Vendors.Id	Vendor ID used for supported fields of the AP Aging Summary (AgedPayables) report; QuickBooks IDs are realm-local, so match destination rows on account_id, date and report__vendors__id

Quickbooks sales_receipts fields

The sales_receipts report of the Quickbooks connector includes 28 fields.

ID	Type	Name	Description
sales_receipts__airbyte_cursor	TEXT	sales_receipts.airbyte_cursor	sales_receipts.airbyte_cursor
sales_receipts__applytaxafterdiscount	BOOLEAN	sales_receipts.ApplyTaxAfterDiscount	sales_receipts.ApplyTaxAfterDiscount
sales_receipts__balance	NUMERIC	sales_receipts.Balance	sales_receipts.Balance
sales_receipts__billaddr	OBJECT	sales_receipts.BillAddr	sales_receipts.BillAddr
sales_receipts__billemail	OBJECT	sales_receipts.BillEmail	sales_receipts.BillEmail
sales_receipts__currencyref	OBJECT	sales_receipts.CurrencyRef	sales_receipts.CurrencyRef
sales_receipts__customermemo	OBJECT	sales_receipts.CustomerMemo	sales_receipts.CustomerMemo
sales_receipts__customerref	OBJECT	sales_receipts.CustomerRef	sales_receipts.CustomerRef
sales_receipts__customfield	OBJECT	sales_receipts.CustomField	sales_receipts.CustomField
sales_receipts__deposittoaccountref	OBJECT	sales_receipts.DepositToAccountRef	sales_receipts.DepositToAccountRef
sales_receipts__docnumber	TEXT	sales_receipts.DocNumber	sales_receipts.DocNumber
sales_receipts__domain	TEXT	sales_receipts.domain	sales_receipts.domain
sales_receipts__emailstatus	TEXT	sales_receipts.EmailStatus	sales_receipts.EmailStatus
sales_receipts__exchangerate	NUMERIC	sales_receipts.ExchangeRate	sales_receipts.ExchangeRate
sales_receipts__hometotalamt	NUMERIC	sales_receipts.HomeTotalAmt	sales_receipts.HomeTotalAmt
sales_receipts__id	TEXT	sales_receipts.Id	sales_receipts.Id
sales_receipts__line	OBJECT	sales_receipts.Line	sales_receipts.Line
sales_receipts__linkedtxn	OBJECT	sales_receipts.LinkedTxn	sales_receipts.LinkedTxn
sales_receipts__metadata	OBJECT	sales_receipts.MetaData	sales_receipts.MetaData
sales_receipts__paymentmethodref	OBJECT	sales_receipts.PaymentMethodRef	sales_receipts.PaymentMethodRef
sales_receipts__paymentrefnum	TEXT	sales_receipts.PaymentRefNum	sales_receipts.PaymentRefNum
sales_receipts__printstatus	TEXT	sales_receipts.PrintStatus	sales_receipts.PrintStatus
sales_receipts__shipaddr	OBJECT	sales_receipts.ShipAddr	sales_receipts.ShipAddr
sales_receipts__sparse	BOOLEAN	sales_receipts.sparse	sales_receipts.sparse
sales_receipts__synctoken	TEXT	sales_receipts.SyncToken	sales_receipts.SyncToken
sales_receipts__totalamt	NUMERIC	sales_receipts.TotalAmt	sales_receipts.TotalAmt
sales_receipts__txndate	TEXT	sales_receipts.TxnDate	sales_receipts.TxnDate
sales_receipts__txntaxdetail	OBJECT	sales_receipts.TxnTaxDetail	sales_receipts.TxnTaxDetail

Quickbooks tax_agencies fields

The tax_agencies report of the Quickbooks connector includes 10 fields.

ID	Type	Name	Description
tax_agencies__airbyte_cursor	TEXT	tax_agencies.airbyte_cursor	tax_agencies.airbyte_cursor
tax_agencies__displayname	TEXT	tax_agencies.DisplayName	tax_agencies.DisplayName
tax_agencies__domain	TEXT	tax_agencies.domain	tax_agencies.domain
tax_agencies__id	TEXT	tax_agencies.Id	tax_agencies.Id
tax_agencies__metadata	OBJECT	tax_agencies.MetaData	tax_agencies.MetaData
tax_agencies__sparse	BOOLEAN	tax_agencies.sparse	tax_agencies.sparse
tax_agencies__synctoken	TEXT	tax_agencies.SyncToken	tax_agencies.SyncToken
tax_agencies__taxregistrationnumber	TEXT	tax_agencies.TaxRegistrationNumber	tax_agencies.TaxRegistrationNumber
tax_agencies__taxtrackedonpurchases	BOOLEAN	tax_agencies.TaxTrackedOnPurchases	tax_agencies.TaxTrackedOnPurchases
tax_agencies__taxtrackedonsales	BOOLEAN	tax_agencies.TaxTrackedOnSales	tax_agencies.TaxTrackedOnSales

Quickbooks tax_codes fields

The tax_codes report of the Quickbooks connector includes 14 fields.

ID	Type	Name	Description
tax_codes__active	BOOLEAN	tax_codes.Active	tax_codes.Active
tax_codes__airbyte_cursor	TEXT	tax_codes.airbyte_cursor	tax_codes.airbyte_cursor
tax_codes__description	TEXT	tax_codes.Description	tax_codes.Description
tax_codes__domain	TEXT	tax_codes.domain	tax_codes.domain
tax_codes__hidden	BOOLEAN	tax_codes.Hidden	tax_codes.Hidden
tax_codes__id	TEXT	tax_codes.Id	tax_codes.Id
tax_codes__metadata	OBJECT	tax_codes.MetaData	tax_codes.MetaData
tax_codes__name	TEXT	tax_codes.Name	tax_codes.Name
tax_codes__purchasetaxratelist	OBJECT	tax_codes.PurchaseTaxRateList	tax_codes.PurchaseTaxRateList
tax_codes__salestaxratelist	OBJECT	tax_codes.SalesTaxRateList	tax_codes.SalesTaxRateList
tax_codes__sparse	BOOLEAN	tax_codes.sparse	tax_codes.sparse
tax_codes__synctoken	TEXT	tax_codes.SyncToken	tax_codes.SyncToken
tax_codes__taxable	BOOLEAN	tax_codes.Taxable	tax_codes.Taxable
tax_codes__taxgroup	BOOLEAN	tax_codes.TaxGroup	tax_codes.TaxGroup

Quickbooks tax_rates fields

The tax_rates report of the Quickbooks connector includes 14 fields.

ID	Type	Name	Description
tax_rates__active	BOOLEAN	tax_rates.Active	tax_rates.Active
tax_rates__agencyref	OBJECT	tax_rates.AgencyRef	tax_rates.AgencyRef
tax_rates__airbyte_cursor	TEXT	tax_rates.airbyte_cursor	tax_rates.airbyte_cursor
tax_rates__description	TEXT	tax_rates.Description	tax_rates.Description
tax_rates__displaytype	TEXT	tax_rates.DisplayType	tax_rates.DisplayType
tax_rates__domain	TEXT	tax_rates.domain	tax_rates.domain
tax_rates__effectivetaxrate	TEXT	tax_rates.EffectiveTaxRate	tax_rates.EffectiveTaxRate
tax_rates__id	TEXT	tax_rates.Id	tax_rates.Id
tax_rates__metadata	OBJECT	tax_rates.MetaData	tax_rates.MetaData
tax_rates__name	TEXT	tax_rates.Name	tax_rates.Name
tax_rates__ratevalue	NUMERIC	tax_rates.RateValue	tax_rates.RateValue
tax_rates__sparse	BOOLEAN	tax_rates.sparse	tax_rates.sparse
tax_rates__specialtaxtype	TEXT	tax_rates.SpecialTaxType	tax_rates.SpecialTaxType
tax_rates__synctoken	TEXT	tax_rates.SyncToken	tax_rates.SyncToken

Quickbooks terms fields

The terms report of the Quickbooks connector includes 15 fields.

ID	Type	Name	Description
terms__active	BOOLEAN	terms.Active	terms.Active
terms__airbyte_cursor	TEXT	terms.airbyte_cursor	terms.airbyte_cursor
terms__dayofmonthdue	NUMERIC	terms.DayOfMonthDue	terms.DayOfMonthDue
terms__discountdayofmonth	NUMERIC	terms.DiscountDayOfMonth	terms.DiscountDayOfMonth
terms__discountdays	NUMERIC	terms.DiscountDays	terms.DiscountDays
terms__discountpercent	NUMERIC	terms.DiscountPercent	terms.DiscountPercent
terms__domain	TEXT	terms.domain	terms.domain
terms__duedays	NUMERIC	terms.DueDays	terms.DueDays
terms__duenextmonthdays	NUMERIC	terms.DueNextMonthDays	terms.DueNextMonthDays
terms__id	TEXT	terms.Id	terms.Id
terms__metadata	OBJECT	terms.MetaData	terms.MetaData
terms__name	TEXT	terms.Name	terms.Name
terms__sparse	BOOLEAN	terms.sparse	terms.sparse
terms__synctoken	TEXT	terms.SyncToken	terms.SyncToken
terms__type	TEXT	terms.Type	terms.Type

Quickbooks time_activities fields

The time_activities report of the Quickbooks connector includes 17 fields.

ID	Type	Name	Description
time_activities__airbyte_cursor	TEXT	time_activities.airbyte_cursor	time_activities.airbyte_cursor
time_activities__billablestatus	TEXT	time_activities.BillableStatus	time_activities.BillableStatus
time_activities__customerref	OBJECT	time_activities.CustomerRef	time_activities.CustomerRef
time_activities__description	TEXT	time_activities.Description	time_activities.Description
time_activities__domain	TEXT	time_activities.domain	time_activities.domain
time_activities__employeeref	OBJECT	time_activities.EmployeeRef	time_activities.EmployeeRef
time_activities__hourlyrate	NUMERIC	time_activities.HourlyRate	time_activities.HourlyRate
time_activities__hours	NUMERIC	time_activities.Hours	time_activities.Hours
time_activities__id	TEXT	time_activities.Id	time_activities.Id
time_activities__itemref	OBJECT	time_activities.ItemRef	time_activities.ItemRef
time_activities__metadata	OBJECT	time_activities.MetaData	time_activities.MetaData
time_activities__minutes	NUMERIC	time_activities.Minutes	time_activities.Minutes
time_activities__nameof	TEXT	time_activities.NameOf	time_activities.NameOf
time_activities__sparse	BOOLEAN	time_activities.sparse	time_activities.sparse
time_activities__synctoken	TEXT	time_activities.SyncToken	time_activities.SyncToken
time_activities__taxable	BOOLEAN	time_activities.Taxable	time_activities.Taxable
time_activities__txndate	TEXT	time_activities.TxnDate	time_activities.TxnDate

Quickbooks transfers fields

The transfers report of the Quickbooks connector includes 12 fields.

ID	Type	Name	Description
transfers__airbyte_cursor	TEXT	transfers.airbyte_cursor	transfers.airbyte_cursor
transfers__amount	NUMERIC	transfers.Amount	transfers.Amount
transfers__currencyref	OBJECT	transfers.CurrencyRef	transfers.CurrencyRef
transfers__domain	TEXT	transfers.domain	transfers.domain
transfers__exchangerate	NUMERIC	transfers.ExchangeRate	transfers.ExchangeRate
transfers__fromaccountref	OBJECT	transfers.FromAccountRef	transfers.FromAccountRef
transfers__id	TEXT	transfers.Id	transfers.Id
transfers__metadata	OBJECT	transfers.MetaData	transfers.MetaData
transfers__privatenote	TEXT	transfers.PrivateNote	transfers.PrivateNote
transfers__synctoken	TEXT	transfers.SyncToken	transfers.SyncToken
transfers__toaccountref	OBJECT	transfers.ToAccountRef	transfers.ToAccountRef
transfers__txndate	TEXT	transfers.TxnDate	transfers.TxnDate

Quickbooks vendor_credits fields

The vendor_credits report of the Quickbooks connector includes 14 fields.

ID	Type	Name	Description
vendor_credits__airbyte_cursor	TEXT	vendor_credits.airbyte_cursor	vendor_credits.airbyte_cursor
vendor_credits__apaccountref	OBJECT	vendor_credits.APAccountRef	vendor_credits.APAccountRef
vendor_credits__currencyref	OBJECT	vendor_credits.CurrencyRef	vendor_credits.CurrencyRef
vendor_credits__departmentref	OBJECT	vendor_credits.DepartmentRef	vendor_credits.DepartmentRef
vendor_credits__docnumber	TEXT	vendor_credits.DocNumber	vendor_credits.DocNumber
vendor_credits__domain	TEXT	vendor_credits.domain	vendor_credits.domain
vendor_credits__exchangerate	NUMERIC	vendor_credits.ExchangeRate	vendor_credits.ExchangeRate
vendor_credits__id	TEXT	vendor_credits.Id	vendor_credits.Id
vendor_credits__line	OBJECT	vendor_credits.Line	vendor_credits.Line
vendor_credits__metadata	OBJECT	vendor_credits.MetaData	vendor_credits.MetaData
vendor_credits__synctoken	TEXT	vendor_credits.SyncToken	vendor_credits.SyncToken
vendor_credits__totalamt	NUMERIC	vendor_credits.TotalAmt	vendor_credits.TotalAmt
vendor_credits__txndate	TEXT	vendor_credits.TxnDate	vendor_credits.TxnDate
vendor_credits__vendorref	OBJECT	vendor_credits.VendorRef	vendor_credits.VendorRef

Quickbooks vendors fields

The vendors report of the Quickbooks connector includes 26 fields.

ID	Type	Name	Description
vendors__acctnum	TEXT	vendors.AcctNum	vendors.AcctNum
vendors__active	BOOLEAN	vendors.Active	vendors.Active
vendors__airbyte_cursor	TEXT	vendors.airbyte_cursor	vendors.airbyte_cursor
vendors__balance	NUMERIC	vendors.Balance	vendors.Balance
vendors__billaddr	OBJECT	vendors.BillAddr	vendors.BillAddr
vendors__companyname	TEXT	vendors.CompanyName	vendors.CompanyName
vendors__currencyref	OBJECT	vendors.CurrencyRef	vendors.CurrencyRef
vendors__displayname	TEXT	vendors.DisplayName	vendors.DisplayName
vendors__domain	TEXT	vendors.domain	vendors.domain
vendors__familyname	TEXT	vendors.FamilyName	vendors.FamilyName
vendors__fax	OBJECT	vendors.Fax	vendors.Fax
vendors__givenname	TEXT	vendors.GivenName	vendors.GivenName
vendors__id	TEXT	vendors.Id	vendors.Id
vendors__metadata	OBJECT	vendors.MetaData	vendors.MetaData
vendors__middlename	TEXT	vendors.MiddleName	vendors.MiddleName
vendors__mobile	OBJECT	vendors.Mobile	vendors.Mobile
vendors__primaryemailaddr	OBJECT	vendors.PrimaryEmailAddr	vendors.PrimaryEmailAddr
vendors__primaryphone	OBJECT	vendors.PrimaryPhone	vendors.PrimaryPhone
vendors__printoncheckname	TEXT	vendors.PrintOnCheckName	vendors.PrintOnCheckName
vendors__suffix	TEXT	vendors.Suffix	vendors.Suffix
vendors__synctoken	TEXT	vendors.SyncToken	vendors.SyncToken
vendors__taxidentifier	TEXT	vendors.TaxIdentifier	vendors.TaxIdentifier
vendors__termref	OBJECT	vendors.TermRef	vendors.TermRef
vendors__title	TEXT	vendors.Title	vendors.Title
vendors__vendor1099	BOOLEAN	vendors.Vendor1099	vendors.Vendor1099
vendors__webaddr	OBJECT	vendors.WebAddr	vendors.WebAddr

Quickbooks other fields

The Quickbooks connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Report
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
date	DATE	Report Date	Date of the report data	date
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
trialbalance__credit	NUMERIC	trialbalance.Credit	Trial Balance Credit	trialbalance
trialbalance__debit	NUMERIC	trialbalance.Debit	Trial Balance Debit	trialbalance
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024|20