- Getting started
- Account management
- Security
- Destinations
- Integrations
- SaaS
- Overview
- 3PL Central
- ActiveCampaign
- AdRoll
- Amplitude
- AppsFlyer
- Asana
- Autopilot
- BigCommerce
- Braintree
- Bronto
- Campaign Manager
- Campaign Monitor
- Chargebee
- Chargify
- CircleCI
- Close.io
- Club Speed
- Codat
- COVID-19 Public Data
- Crossbeam
- Darksky
- Deputy
- Desk
- Dixa
- Doorbell.io
- eBay
- Eloqua
- Facebook Ads
- Freshdesk
- Front
- FullStory
- GitHub
- GitLab
- Google Ads
- Google Ads (AdWords)
- Google Analytics
- Google Analytics (AdWords)
- Google Analytics 360
- Google Analytics 4
- Google ECommerce
- Google Search Console
- Google Sheets
- Harvest
- Harvest Forecast
- Heap
- Help Scout
- HubSpot
- iLEVEL
- Impact
- Intacct
- Intercom
- Invoiced
- Iterable
- JIRA
- Klaviyo
- Kustomer
- Lever
- LinkedIn Ads
- Listrak
- LivePerson
- Looker
- LookML
- MailChimp
- Mailshake
- Mambu
- Marketo
- Microsoft Advertising
- Microsoft Teams
- Mixpanel
- NetSuite
- NetSuite Suite Analytics
- Onfleet
- Outbrain
- Outreach
- Pardot
- Pendo
- Pepperjam
- Pipedrive
- Quick Base
- QuickBooks
- Recharge
- Recurly
- Referral SaaSquatch
- Revinate
- RingCentral
- SaaSOptics
- Sailthru
- Salesforce
- Salesforce Marketing Cloud
- Selligent
- SendGrid Core
- ShipHero
- Shippo
- Shopify
- Slack
- Snapchat Ads
- Square
- Stripe
- SurveyMonkey
- Taboola
- TikTok Ads
- Toggl
- Trello
- Twilio
- Twitter Ads
- Typeform
- UJET
- Urban Airship
- UserVoice
- Wootric
- Workday RaaS
- Xero
- Yotpo
- Zendesk Chat
- Zendesk Support
- Zoom
- Zuora
- Databases
- Overview
- Amazon Aurora MySQL RDS
- Amazon Aurora PostgreSQL RDS
- Amazon DynamoDB
- Amazon Microsoft SQL Server RDS
- Amazon MySQL RDS
- Amazon Oracle RDS
- Amazon PostgreSQL RDS
- Amazon S3 CSV
- Google CloudSQL MySQL
- Google CloudSQL PostgreSQL
- Heroku
- Magento
- MariaDB
- Microsoft Azure MySQL
- Microsoft Azure SQL Database
- Microsoft SQL Server
- MongoDB
- MongoDB Atlas
- MySQL
- Oracle
- PostgreSQL
- Responsys
- SFTP
- Webhooks
- All integrations
- Connection cloning
- Connect other data sources
- SaaS
- Extracting data
- Loading data
- Analysis tools
- Troubleshooting
- Developers
- Changelog
- version 2 (Latest)
- version 1 (Deprecated)
- version 21-12-2015 (Deprecated)
Get started with a free trial today
Already have an account? Sign in
QuickBooks (v2)
This integration is powered bySinger's QuickBooks tap and certified by Stitch.Check out and contribute to the repo on GitHub.
For support, contactSupport.
QuickBooks integration summary
Stitch’s QuickBooks integration replicates data using theQuickBooks Online API. Refer to theSchema 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 plan | Standard | API availability | Available |
| Singer GitHub repository | |||
| REPLICATION SETTINGS | |||
| Anchor Scheduling | Supported | Advanced Scheduling | Supported |
| Table-level reset | Unsupported | Configurable Replication Methods | Unsupported |
| DATA SELECTION | |||
| Table selection | Supported | Column selection | Supported |
| Select all | Supported | ||
| TRANSPARENCY | |||
| Extraction Logs | Supported | Loading Reports | Supported |
Connecting QuickBooks
QuickBooks setup requirements
To set up QuickBooks in Stitch, you need:
An online QuickBooks instance. Desktop instances aren’t currently supported.
Step 1: Add QuickBooks as a Stitch data source
- Sign into your Stitch account.
On the Stitch Dashboard page, click theAdd Integration button.
Click theQuickBooks icon.
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.
For example, the name “Stitch QuickBooks” would create a schema called
stitch_quickbooksin 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 dataequal 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 of1 year. For a detailed look at historical replication jobs, check out theSyncing Historical SaaS Data guide.
Step 3: Create a replication schedule
In theReplication Frequency section, you’ll create the integration’sreplication 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:
Advanced Scheduling using Cron (Advanced or Premium plans only)
To keep your row usage low, consider setting the integration to replicate less frequently. See theUnderstanding and Reducing Your Row Usage guide for tips on reducing your usage.
Step 4: Authorize Stitch to access QuickBooks
Lastly, you’ll be directed to QuickBooks’ website to complete the setup.
- If you’re not already signed into your QuickBooks account, enter your credentials and clickLogin.
- A screen asking for authorization to QuickBooks will display.
- ClickAuthorize.
- After the authorization process successfully completes, you’ll be redirected back to Stitch.
- ClickAll 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:
Individual tables and columns
All tables and columns
Click the tabs to view instructions for each selection method.
- In the integration’sTables to Replicate tab, locate a table you want to replicate.
To track a table, click thecheckbox next to the table’s name. A blue checkmark means the table is set to replicate.
To track a column, click thecheckbox next to the column’s name. A blue checkmark means the column is set to replicate.
- Repeat this process for all the tables and columns you want to replicate.
- When finished, click theFinalize Your Selections button at the bottom of the screen to save your selections.
- Click into the integration from the Stitch Dashboard page.
Click theTables to Replicate tab.
- In the list of tables, click the box next to theTable Names column.
In the menu that displays, clickTrack all Tables and Fields:
- Click theFinalize 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, itsSync Status may show asPending on either the Stitch Dashboard or in the Integration Details page.
For a new integration, aPending status indicates that Stitch is in the process of scheduling the initial replication job for the integration.This may take some time to complete.
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to theAnchor Scheduling documentation for more information.
Free historical data loads
The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.
QuickBooks table reference
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is forversion 2 of this integration.
This is the latest version of the QuickBooks integration.
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs >customers), while case is maintained in PostgreSQL destinations (CusTomERs >CusTomERs). Refer to theLoading Guide for your destination for more info.
accounts
Theaccounts 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.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| 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
| ||
CurrentBalance NUMBER | ||
CurrentBalanceWithSubAccounts NUMBER | ||
Description STRING | ||
FullyQualifiedName STRING | ||
Id STRING | ||
MetaData OBJECT
| ||
Name STRING | ||
ParentRef OBJECT
| ||
SubAccount BOOLEAN | ||
SyncToken STRING | ||
TaxCodeRef OBJECT
| ||
TxnLocationType STRING | ||
domain STRING |
bill_payments
Thebill_payments table contains info about payments made on bills received from vendors for goods or services.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| 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
| |||||
CheckPayment OBJECT
| |||||
CreditCardPayment OBJECT
| |||||
CurrencyRef OBJECT
| |||||
DepartmentRef OBJECT
| |||||
DocNumber STRING | |||||
ExchangeRate NUMBER | |||||
Id STRING | |||||
Line ARRAY
| |||||
MetaData OBJECT
| |||||
PayType STRING | |||||
PrivateNote STRING | |||||
ProcessBillPayment BOOLEAN | |||||
SyncToken STRING | |||||
TotalAmt NUMBER | |||||
TransactionLocationType STRING | |||||
TxnDate DATE-TIME | |||||
VendorRef OBJECT
| |||||
domain STRING |
bills
Thebills table contains info about the bills, or requests for payment from third parties, in your QuickBooks instance.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| 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
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Balance NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CurrencyRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DepartmentRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DocNumber STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DueDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ExchangeRate NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GlobalTaxCalculation STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
HomeBalance NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Id STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
IncludeInAnnualTPAR BOOLEAN | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Line ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
LinkedTxn ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MetaData OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PrivateNote STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
RecurDataRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SalesTermRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SyncToken STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TotalAmt NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TransactionLocationType STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnTaxDetail OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
VendorRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
domain STRING |
budgets
Thebudgets 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.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| 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
| ||||||||||||||
BudgetEntryType STRING | ||||||||||||||
BudgetType STRING | ||||||||||||||
EndDate DATE-TIME | ||||||||||||||
Id STRING | ||||||||||||||
MetaData OBJECT
| ||||||||||||||
Name STRING | ||||||||||||||
StartDate DATE-TIME | ||||||||||||||
SyncToken STRING | ||||||||||||||
domain STRING |
classes
Theclasses 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.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| 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
| ||
Name STRING | ||
ParentRef OBJECT
| ||
SubClass BOOLEAN | ||
SyncToken STRING | ||
domain STRING |
credit_memos
Thecredit_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.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| 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
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
BillEmail OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ClassRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CurrencyRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomField ARRAY | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomerMemo OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomerRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DepartmentRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DocNumber STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
EmailStatus STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ExchangeRate NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GlobalTaxCalculation STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
HomeBalance NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
HomeTotalAmt NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Id STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
InvoiceRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Line ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MetaData OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PaymentMethodRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PrintStatus STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PrivateNote STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
RecurDataRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
RemainingCredit INTEGER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SalesTermRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipAddr OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SyncToken STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TaxExemptionRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TotalAmt NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TransactionLocationType STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnTaxDetail OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
domain STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
patternProperties OBJECT |
customer_types
Thecustomer_types table contains info about types of customers.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
Active BOOLEAN | ||
Id STRING | ||
MetaData OBJECT
| ||
Name STRING | ||
SyncToken STRING | ||
domain STRING | ||
sparse STRING |
customers
Thecustomers 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.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| 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
| ||||||||||||
Active BOOLEAN | ||||||||||||
AlternatePhone OBJECT
| ||||||||||||
Balance NUMBER | ||||||||||||
BalanceWithJobs NUMBER | ||||||||||||
BillAddr OBJECT
| ||||||||||||
BillWithParent BOOLEAN | ||||||||||||
BusinessNumber STRING | ||||||||||||
CompanyName STRING | ||||||||||||
CurrencyRef OBJECT
| ||||||||||||
CustomerTypeRef OBJECT
| ||||||||||||
DefaultTaxCodeRef OBJECT
| ||||||||||||
DisplayName STRING | ||||||||||||
FamilyName STRING | ||||||||||||
Fax OBJECT
| ||||||||||||
FullyQualifiedName STRING | ||||||||||||
GSTIN STRING | ||||||||||||
GSTRegistrationType STRING | ||||||||||||
GivenName STRING | ||||||||||||
Id STRING | ||||||||||||
IsProject BOOLEAN | ||||||||||||
Job BOOLEAN | ||||||||||||
Level INTEGER | ||||||||||||
MetaData OBJECT
| ||||||||||||
MiddleName STRING | ||||||||||||
Mobile OBJECT
| ||||||||||||
Notes STRING | ||||||||||||
OpenBalanceDate DATE-TIME | ||||||||||||
ParentRef OBJECT
| ||||||||||||
PaymentMethodRef OBJECT
| ||||||||||||
PreferredDeliveryMethod STRING | ||||||||||||
PrimaryEmailAddr OBJECT
| ||||||||||||
PrimaryPhone OBJECT
| ||||||||||||
PrimaryTaxIdentifier STRING | ||||||||||||
PrintOnCheckName STRING | ||||||||||||
ResaleNum STRING | ||||||||||||
SalesTermRef OBJECT
| ||||||||||||
SecondaryTaxIdentifier STRING | ||||||||||||
ShipAddr OBJECT
| ||||||||||||
Source STRING | ||||||||||||
Suffix STRING | ||||||||||||
SyncToken STRING | ||||||||||||
TaxExemptionReasonId INTEGER | ||||||||||||
Taxable BOOLEAN | ||||||||||||
Title STRING | ||||||||||||
WebAddr OBJECT
| ||||||||||||
domain STRING |
deleted_objects
Thedeleted_objects table contains info about objects deleted from QuickBooks.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
Id STRING | |
MetaData OBJECT
| |
Type STRING | |
domain STRING |
departments
Thedepartments table contains info about the departments in your QuickBooks instance.Note: Both active and inactive departments are included in the data for this table.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| 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
| ||
Name STRING | ||
ParentRef OBJECT
| ||
SubDepartment BOOLEAN | ||
SyncToken STRING | ||
domain STRING |
deposits
Thedeposits table contains info about deposits in your QuickBooks instance. These can be customer payments or new direct deposits.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| 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
| |||||||||||||||||||||||||||||||||
CurrencyRef OBJECT
| |||||||||||||||||||||||||||||||||
DepartmentRef OBJECT
| |||||||||||||||||||||||||||||||||
DepositToAccountRef OBJECT
| |||||||||||||||||||||||||||||||||
ExchangeRate NUMBER | |||||||||||||||||||||||||||||||||
GlobalTaxCalculation STRING | |||||||||||||||||||||||||||||||||
HomeTotalAmt NUMBER | |||||||||||||||||||||||||||||||||
Id STRING | |||||||||||||||||||||||||||||||||
Line ARRAY
| |||||||||||||||||||||||||||||||||
MetaData OBJECT
| |||||||||||||||||||||||||||||||||
PrivateNote STRING | |||||||||||||||||||||||||||||||||
RecurDataRef OBJECT
| |||||||||||||||||||||||||||||||||
SyncToken STRING | |||||||||||||||||||||||||||||||||
TotalAmt NUMBER | |||||||||||||||||||||||||||||||||
TransactionLocationType STRING | |||||||||||||||||||||||||||||||||
TxnDate DATE-TIME | |||||||||||||||||||||||||||||||||
TxnSource STRING | |||||||||||||||||||||||||||||||||
TxnTaxDetail OBJECT
| |||||||||||||||||||||||||||||||||
domain STRING |
employees
Theemployees table contains info about the people working for your company.Note: Both active and inactive employees are included in the data for this table.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| 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
| ||||||||||||
MiddleName STRING | ||||||||||||
Mobile OBJECT
| ||||||||||||
Organization BOOLEAN | ||||||||||||
PrimaryAddr OBJECT
| ||||||||||||
PrimaryEmailAddr OBJECT
| ||||||||||||
PrimaryPhone OBJECT
| ||||||||||||
PrintOnCheckName STRING | ||||||||||||
ReleasedDate DATE-TIME | ||||||||||||
SSN STRING | ||||||||||||
Suffix STRING | ||||||||||||
SyncToken STRING | ||||||||||||
Title STRING | ||||||||||||
V4IDPseudonym STRING | ||||||||||||
domain STRING |
estimates
Theestimates table contains info about the estimates in your QuickBooks instance. An estimate is a financial proposal from a business to acustomer for goods or services.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| 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
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
BillEmail OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ClassRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CurrencyRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomField ARRAY | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomerMemo OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomerRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DeliveryInfo OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DepartmentRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DocNumber STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DueDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
EmailStatus STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ExchangeRate NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ExpirationDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
FreeFormAddress BOOLEAN | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GlobalTaxCalculation STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
HomeTotalAmt NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Id STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Line ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
LinkedTxn ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MetaData OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PrintStatus STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PrivateNote STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
RecurDataRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SalesTermRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipAddr OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipFromAddr OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipMethodRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SyncToken STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TaxExemptionRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TotalAmt NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TransactionLocationType STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnStatus STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnTaxDetail OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
domain STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
patternProperties OBJECT |
invoices
Theinvoices table contains info about the invoices in your QuickBooks account.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| 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
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
BillEmail OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
BillEmailBcc OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
BillEmailCc OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ClassRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CurrencyRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomField ARRAY | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomerMemo OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomerRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DeliveryInfo OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DepartmentRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Deposit NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DepositToAccountRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DocNumber STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DueDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
EmailStatus STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ExchangeRate NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
FreeFormAddress BOOLEAN | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GlobalTaxCalculation STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
HomeBalance NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
HomeTotalAmt NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Id STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
InvoiceLink STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Line ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
LinkedTxn ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MetaData OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PrintStatus STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PrivateNote STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
RecurDataRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SalesTermRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipAddr OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipFromAddr OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipMethodRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SyncToken STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TaxExemptionRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TotalAmt NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TrackingNum STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TransactionLocationType STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnSource STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnTaxDetail OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
domain STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
patternProperties OBJECT |
items
Theitems table contains info about the items your company buys, sells, or re-sells. This includes all item types in QuickBooks, such asInventory,Group,Service andNoninventory.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| 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 | items.ClassRef.value = estimates.ClassRef.value items.Id = estimates.Line.SalesItemLineDetail.ItemRef.value items.ParentRef.value = estimates.Line.SalesItemLineDetail.ItemRef.value items.PurchaseTaxCodeRef.value = estimates.Line.SalesItemLineDetail.TaxCodeRef.value items.SalesTaxCodeRef.value = estimates.Line.SalesItemLineDetail.TaxCodeRef.value items.PurchaseTaxCodeRef.value = estimates.TxnTaxDetail.TxnTaxCodeRef.value items.SalesTaxCodeRef.value = estimates.TxnTaxDetail.TxnTaxCodeRef.value |
| time_activities | items.ClassRef.value = time_activities.ClassRef.value items.Id = time_activities.ItemRef.value items.ParentRef.value = time_activities.ItemRef.value items.PrefVendorRef.value = time_activities.VendorRef.value |
| customers | items.PurchaseTaxCodeRef.value = customers.DefaultTaxCodeRef.value items.SalesTaxCodeRef.value = customers.DefaultTaxCodeRef.value |
| vendors | items.PrefVendorRef.value = vendors.Id |
AbatementRate NUMBER | ||
Active BOOLEAN | ||
AssetAccountRef OBJECT
| ||
ClassRef OBJECT
| ||
Description STRING | ||
ExpenseAccountRef OBJECT
| ||
FullyQualifiedName STRING | ||
Id STRING | ||
IncomeAccountRef OBJECT
| ||
InvStartDate DATE-TIME | ||
ItemCategoryType STRING | ||
Level INTEGER | ||
MetaData OBJECT
| ||
Name STRING | ||
ParentRef OBJECT
| ||
PrefVendorRef OBJECT
| ||
PurchaseCost INTEGER, NUMBER | ||
PurchaseDesc STRING | ||
PurchaseTaxCodeRef OBJECT
| ||
PurchaseTaxIncluded BOOLEAN | ||
QtyOnHand INTEGER | ||
ReorderPoint NUMBER | ||
ReverseChargeRate NUMBER | ||
SalesTaxCodeRef OBJECT
| ||
SalesTaxIncluded BOOLEAN | ||
ServiceType STRING | ||
Sku STRING | ||
Source STRING | ||
SubItem BOOLEAN | ||
SyncToken STRING | ||
TaxClassificationRef OBJECT
| ||
Taxable BOOLEAN | ||
TrackQtyOnHand BOOLEAN | ||
Type STRING | ||
UQCDisplayText STRING | ||
UQCId STRING | ||
UnitPrice NUMBER | ||
domain STRING | ||
patternProperties OBJECT |
journal_entries
Thejournal_entries table contains info about the journal entries in your QuickBooks instance. A journal entry is a transaction that:
- Contains a pair of distribution lines, including a debit and a credit
- Each distribution line has an account from the Chart of Accounts
- The total of the debit column equals the total of the credit column
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| Join journal_entries with | on |
|---|---|
| accounts | journal_entries.Line.JournalEntryLineDetail.AccountRef.value = accounts.Id journal_entries.Line.JournalEntryLineDetail.AccountRef.value = accounts.ParentRef.value journal_entries.CurrencyRef.value = accounts.CurrencyRef.value |
| bill_payments | journal_entries.Line.JournalEntryLineDetail.AccountRef.value = 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.CurrencyRef.value = bill_payments.CurrencyRef.value journal_entries.Id = bill_payments.Line.LinkedTxn.TxnId |
| bills | journal_entries.Line.JournalEntryLineDetail.AccountRef.value = bills.APAccountRef.value journal_entries.Line.JournalEntryLineDetail.AccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value journal_entries.CurrencyRef.value = bills.CurrencyRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value journal_entries.Id = bills.Id |
| budgets | journal_entries.Line.JournalEntryLineDetail.AccountRef.value = budgets.BudgetDetail.AccountRef.value |
| deposits | journal_entries.Line.JournalEntryLineDetail.AccountRef.value = 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.CurrencyRef.value = deposits.CurrencyRef.value journal_entries.Id = deposits.Line.LinkedTxn.TxnId |
| invoices | journal_entries.Line.JournalEntryLineDetail.AccountRef.value = invoices.DepositToAccountRef.value journal_entries.Line.JournalEntryLineDetail.AccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value journal_entries.CurrencyRef.value = invoices.CurrencyRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = invoices.Line.SalesItemLineDetail.TaxCodeRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = invoices.TxnTaxDetail.TxnTaxCodeRef.value journal_entries.TaxRateRef.value = invoices.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value journal_entries.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value = invoices.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value |
| items | journal_entries.Line.JournalEntryLineDetail.AccountRef.value = items.AssetAccountRef.value journal_entries.Line.JournalEntryLineDetail.AccountRef.value = items.ExpenseAccountRef.value journal_entries.Line.JournalEntryLineDetail.AccountRef.value = items.IncomeAccountRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = items.PurchaseTaxCodeRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = items.SalesTaxCodeRef.value |
| payments | journal_entries.Line.JournalEntryLineDetail.AccountRef.value = payments.DepositToAccountRef.value journal_entries.CurrencyRef.value = payments.CurrencyRef.value journal_entries.Id = payments.Id |
| purchase_orders | journal_entries.Line.JournalEntryLineDetail.AccountRef.value = purchase_orders.APAccountRef.value journal_entries.CurrencyRef.value = purchase_orders.CurrencyRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value |
| purchases | journal_entries.Line.JournalEntryLineDetail.AccountRef.value = purchases.AccountRef.value journal_entries.Line.JournalEntryLineDetail.AccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value journal_entries.CurrencyRef.value = purchases.CurrencyRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value |
| refund_receipts | journal_entries.Line.JournalEntryLineDetail.AccountRef.value = refund_receipts.DepositToAccountRef.value journal_entries.CurrencyRef.value = refund_receipts.CurrencyRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value journal_entries.Id = refund_receipts.Id |
| sales_receipts | journal_entries.Line.JournalEntryLineDetail.AccountRef.value = sales_receipts.DepositToAccountRef.value journal_entries.Line.JournalEntryLineDetail.AccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value journal_entries.CurrencyRef.value = sales_receipts.CurrencyRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value journal_entries.Id = sales_receipts.Id |
| transfers | journal_entries.Line.JournalEntryLineDetail.AccountRef.value = transfers.FromAccountRef.value journal_entries.Line.JournalEntryLineDetail.AccountRef.value = transfers.ToAccountRef.value journal_entries.CurrencyRef.value = transfers.CurrencyRef.value journal_entries.Id = transfers.Id |
| vendor_credits | journal_entries.Line.JournalEntryLineDetail.AccountRef.value = vendor_credits.APAccountRef.value journal_entries.Line.JournalEntryLineDetail.AccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value journal_entries.CurrencyRef.value = vendor_credits.CurrencyRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value journal_entries.Id = vendor_credits.Id |
| credit_memos | journal_entries.CurrencyRef.value = credit_memos.CurrencyRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value |
| customers | journal_entries.CurrencyRef.value = customers.CurrencyRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = customers.DefaultTaxCodeRef.value |
| estimates | journal_entries.CurrencyRef.value = estimates.CurrencyRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = estimates.Line.SalesItemLineDetail.TaxCodeRef.value journal_entries.TxnTaxDetail.TxnTaxCodeRef.value = estimates.TxnTaxDetail.TxnTaxCodeRef.value journal_entries.TaxRateRef.value = estimates.TxnTaxDetail.TaxLine.TaxLineDetail.TaxLine.TaxLineDetail.TaxRateRef.value journal_entries.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value = estimates.TxnTaxDetail.TaxLine.TaxLineDetail.TaxLine.TaxLineDetail.TaxRateRef.value |
| vendors | journal_entries.CurrencyRef.value = vendors.CurrencyRef.value |
| tax_codes | journal_entries.TaxRateRef.value = tax_codes.PurchaseTaxRateList.TaxRateDetail.TaxRateRef.value journal_entries.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value = tax_codes.PurchaseTaxRateList.TaxRateDetail.TaxRateRef.value journal_entries.TaxRateRef.value = tax_codes.SalesTaxRateList.TaxRateDetail.TaxRateRef.value journal_entries.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value = tax_codes.SalesTaxRateList.TaxRateDetail.TaxRateRef.value |
| tax_rates | journal_entries.TaxRateRef.value = tax_rates.Id journal_entries.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value = tax_rates.Id |
Adjustment BOOLEAN | ||||||||||||||||||||||||||||||||||||
CurrencyRef OBJECT
| ||||||||||||||||||||||||||||||||||||
DocNumber STRING | ||||||||||||||||||||||||||||||||||||
ExchangeRate NUMBER | ||||||||||||||||||||||||||||||||||||
GlobalTaxCalculation STRING | ||||||||||||||||||||||||||||||||||||
HomeTotalAmt NUMBER | ||||||||||||||||||||||||||||||||||||
Id STRING | ||||||||||||||||||||||||||||||||||||
JournalCodeRef OBJECT
| ||||||||||||||||||||||||||||||||||||
Line ARRAY
| ||||||||||||||||||||||||||||||||||||
MetaData OBJECT
| ||||||||||||||||||||||||||||||||||||
PrivateNote STRING | ||||||||||||||||||||||||||||||||||||
RecurDataRef OBJECT
| ||||||||||||||||||||||||||||||||||||
SyncToken STRING | ||||||||||||||||||||||||||||||||||||
TaxRateRef OBJECT
| ||||||||||||||||||||||||||||||||||||
TotalAmt NUMBER | ||||||||||||||||||||||||||||||||||||
TransactionLocationType STRING | ||||||||||||||||||||||||||||||||||||
TxnDate DATE-TIME | ||||||||||||||||||||||||||||||||||||
TxnTaxDetail OBJECT
| ||||||||||||||||||||||||||||||||||||
domain STRING |
payment_methods
Thepayment_methods table contains info about the methods of payment your company receives for goods.Note: Both active and inactive payment methods are included in the data for this table.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| Join payment_methods with | on |
|---|---|
| customers | payment_methods.Id = customers.PaymentMethodRef.value |
| deposits | payment_methods.Id = deposits.Line.DepositLineDetail.PaymentMethodRef.value |
| payments | payment_methods.Id = payments.PaymentMethodRef.value |
| purchases | payment_methods.Id = purchases.PaymentMethodRef.value |
| refund_receipts | payment_methods.Id = refund_receipts.PaymentMethodRef.value |
| sales_receipts | payment_methods.Id = sales_receipts.PaymentMethodRef.value |
Active BOOLEAN | ||
Id STRING | ||
MetaData OBJECT
| ||
Name STRING | ||
SyncToken STRING | ||
Type STRING | ||
domain STRING |
payments
Thepayments table contains info about the payments recorded in your QuickBooks instance.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| Join payments with | on |
|---|---|
| accounts | payments.DepositToAccountRef.value = accounts.Id payments.DepositToAccountRef.value = accounts.ParentRef.value payments.CurrencyRef.value = accounts.CurrencyRef.value |
| bill_payments | payments.DepositToAccountRef.value = bill_payments.APAccountRef.value payments.DepositToAccountRef.value = bill_payments.CheckPayment.BankAccountRef.value payments.DepositToAccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value payments.CurrencyRef.value = bill_payments.CurrencyRef.value |
| bills | payments.DepositToAccountRef.value = bills.APAccountRef.value payments.DepositToAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value payments.CurrencyRef.value = bills.CurrencyRef.value payments.CustomerRef.value = bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value |
| budgets | payments.DepositToAccountRef.value = budgets.BudgetDetail.AccountRef.value payments.CustomerRef.value = budgets.BudgetDetail.CustomerRef.value |
| deposits | payments.DepositToAccountRef.value = deposits.CashBack.AccountRef.value payments.DepositToAccountRef.value = deposits.DepositToAccountRef.value payments.DepositToAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value payments.CurrencyRef.value = deposits.CurrencyRef.value payments.Id = deposits.Line.LinkedTxn.TxnId payments.PaymentMethodRef.value = deposits.Line.DepositLineDetail.PaymentMethodRef.value |
| invoices | payments.DepositToAccountRef.value = invoices.DepositToAccountRef.value payments.DepositToAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value payments.CurrencyRef.value = invoices.CurrencyRef.value payments.CustomerRef.value = invoices.CustomerRef.value payments.Line.LinkedTxn.TxnId = invoices.Id payments.Id = invoices.LinkedTxn.TxnId payments.Line.LinkedTxn.TxnId = invoices.LinkedTxn.TxnId |
| items | payments.DepositToAccountRef.value = items.AssetAccountRef.value payments.DepositToAccountRef.value = items.ExpenseAccountRef.value payments.DepositToAccountRef.value = items.IncomeAccountRef.value |
| journal_entries | payments.DepositToAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value payments.CurrencyRef.value = journal_entries.CurrencyRef.value payments.Id = journal_entries.Id |
| purchase_orders | payments.DepositToAccountRef.value = purchase_orders.APAccountRef.value payments.CurrencyRef.value = purchase_orders.CurrencyRef.value payments.CustomerRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value |
| purchases | payments.DepositToAccountRef.value = purchases.AccountRef.value payments.DepositToAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value payments.CurrencyRef.value = purchases.CurrencyRef.value payments.CustomerRef.value = purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value payments.PaymentMethodRef.value = purchases.PaymentMethodRef.value payments.Line.LinkedTxn.TxnId = purchases.Id payments.Id = purchases.Id |
| refund_receipts | payments.DepositToAccountRef.value = refund_receipts.DepositToAccountRef.value payments.CurrencyRef.value = refund_receipts.CurrencyRef.value payments.CustomerRef.value = refund_receipts.CustomerRef.value payments.PaymentMethodRef.value = refund_receipts.PaymentMethodRef.value payments.Id = refund_receipts.Id |
| sales_receipts | payments.DepositToAccountRef.value = sales_receipts.DepositToAccountRef.value payments.DepositToAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value payments.CurrencyRef.value = sales_receipts.CurrencyRef.value payments.CustomerRef.value = sales_receipts.CustomerRef.value payments.PaymentMethodRef.value = sales_receipts.PaymentMethodRef.value payments.Id = sales_receipts.Id |
| transfers | payments.DepositToAccountRef.value = transfers.FromAccountRef.value payments.DepositToAccountRef.value = transfers.ToAccountRef.value payments.CurrencyRef.value = transfers.CurrencyRef.value payments.Id = transfers.Id |
| vendor_credits | payments.DepositToAccountRef.value = vendor_credits.APAccountRef.value payments.DepositToAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value payments.CurrencyRef.value = vendor_credits.CurrencyRef.value payments.CustomerRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value |
| credit_memos | payments.Line.LinkedTxn.TxnId = credit_memos.Id payments.CurrencyRef.value = credit_memos.CurrencyRef.value payments.CustomerRef.value = credit_memos.CustomerRef.value |
| customers | payments.CurrencyRef.value = customers.CurrencyRef.value payments.CustomerRef.value = customers.Id payments.PaymentMethodRef.value = customers.PaymentMethodRef.value |
| estimates | payments.CurrencyRef.value = estimates.CurrencyRef.value payments.CustomerRef.value = estimates.CustomerRef.value payments.Line.LinkedTxn.TxnId = estimates.LinkedTxn.TxnId payments.Id = estimates.Id |
| vendors | payments.CurrencyRef.value = vendors.CurrencyRef.value |
| payment_methods | payments.PaymentMethodRef.value = payment_methods.Id |
| time_activities | payments.Id = time_activities.Id |
ARAccountRef OBJECT
| ||||||||||||||||
CreditCardPayment OBJECT
| ||||||||||||||||
CurrencyRef OBJECT
| ||||||||||||||||
CustomerRef OBJECT
| ||||||||||||||||
DepositToAccountRef OBJECT
| ||||||||||||||||
ExchangeRate NUMBER | ||||||||||||||||
Id STRING | ||||||||||||||||
Line ARRAY
| ||||||||||||||||
LinkedTxn ARRAY
| ||||||||||||||||
MetaData OBJECT
| ||||||||||||||||
PaymentMethodRef OBJECT
| ||||||||||||||||
PaymentRefNum STRING | ||||||||||||||||
PrivateNote STRING | ||||||||||||||||
ProcessPayment BOOLEAN | ||||||||||||||||
SyncToken STRING | ||||||||||||||||
TaxExemptionRef OBJECT
| ||||||||||||||||
TotalAmt NUMBER | ||||||||||||||||
TransactionLocationType STRING | ||||||||||||||||
TxnDate DATE-TIME | ||||||||||||||||
TxnSource STRING | ||||||||||||||||
UnappliedAmt NUMBER | ||||||||||||||||
domain STRING |
profit_loss_report
Theprofit_loss_report table contains reports about profit and loss recorded in your QuickBooks instance.
Key-based Incremental | |
Primary Key | ReportDate |
| Useful links |
AccountingMethod STRING |
Details OBJECT |
ReportDate DATE-TIME |
purchase_orders
Thepurchase_orders table contains info about purchase orders in your QuickBooks instance. A purchase order is a request to purchase goods or services from a third party.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| Join purchase_orders with | on |
|---|---|
| accounts | purchase_orders.APAccountRef.value = accounts.Id purchase_orders.APAccountRef.value = accounts.ParentRef.value purchase_orders.CurrencyRef.value = accounts.CurrencyRef.value |
| bill_payments | purchase_orders.APAccountRef.value = bill_payments.APAccountRef.value purchase_orders.APAccountRef.value = bill_payments.CheckPayment.BankAccountRef.value purchase_orders.APAccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value purchase_orders.LinkedTxn.TxnId = bill_payments.Line.LinkedTxn.TxnId purchase_orders.CurrencyRef.value = bill_payments.CurrencyRef.value purchase_orders.DepartmentRef.value = bill_payments.DepartmentRef.value purchase_orders.Id = bill_payments.Id purchase_orders.VendorRef.value = bill_payments.VendorRef.value |
| bills | purchase_orders.APAccountRef.value = bills.APAccountRef.value purchase_orders.APAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value purchase_orders.LinkedTxn.TxnId = bills.Id purchase_orders.CurrencyRef.value = bills.CurrencyRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value = bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value purchase_orders.DepartmentRef.value = bills.DepartmentRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value = bills.Line.ItemBasedExpenseLineDetail.ItemRef.value purchase_orders.Id = bills.LinkedTxn.TxnId purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value purchase_orders.SalesTermRef.value = bills.SalesTermRef.value purchase_orders.VendorRef.value = bills.VendorRef.value |
| budgets | purchase_orders.APAccountRef.value = budgets.BudgetDetail.AccountRef.value purchase_orders.ClassRef.value = budgets.BudgetDetail.ClassRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value = budgets.BudgetDetail.ClassRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value = budgets.BudgetDetail.CustomerRef.value purchase_orders.DepartmentRef.value = budgets.BudgetDetail.DepartmentRef.value |
| deposits | purchase_orders.APAccountRef.value = deposits.CashBack.AccountRef.value purchase_orders.APAccountRef.value = deposits.DepositToAccountRef.value purchase_orders.APAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value purchase_orders.CurrencyRef.value = deposits.CurrencyRef.value purchase_orders.DepartmentRef.value = deposits.DepartmentRef.value |
| invoices | purchase_orders.APAccountRef.value = invoices.DepositToAccountRef.value purchase_orders.APAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value purchase_orders.ClassRef.value = invoices.ClassRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value = invoices.ClassRef.value purchase_orders.ClassRef.value = invoices.Line.SalesItemLineDetail.ClassRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value = invoices.Line.SalesItemLineDetail.ClassRef.value purchase_orders.CurrencyRef.value = invoices.CurrencyRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value = invoices.CustomerRef.value purchase_orders.DepartmentRef.value = invoices.DepartmentRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value = invoices.Line.SalesItemLineDetail.ItemRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = invoices.Line.SalesItemLineDetail.TaxCodeRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = invoices.TxnTaxDetail.TxnTaxCodeRef.value purchase_orders.SalesTermRef.value = invoices.SalesTermRef.value |
| items | purchase_orders.APAccountRef.value = items.AssetAccountRef.value purchase_orders.APAccountRef.value = items.ExpenseAccountRef.value purchase_orders.APAccountRef.value = items.IncomeAccountRef.value purchase_orders.ClassRef.value = items.ClassRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value = items.ClassRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value = items.Id purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value = items.ParentRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = items.PurchaseTaxCodeRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = items.SalesTaxCodeRef.value purchase_orders.VendorRef.value = items.PrefVendorRef.value |
| journal_entries | purchase_orders.APAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value purchase_orders.CurrencyRef.value = journal_entries.CurrencyRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value |
| payments | purchase_orders.APAccountRef.value = payments.DepositToAccountRef.value purchase_orders.CurrencyRef.value = payments.CurrencyRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value = payments.CustomerRef.value |
| purchases | purchase_orders.APAccountRef.value = purchases.AccountRef.value purchase_orders.APAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value purchase_orders.ClassRef.value = purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value = purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value purchase_orders.CurrencyRef.value = purchases.CurrencyRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value = purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value purchase_orders.DepartmentRef.value = purchases.DepartmentRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value = purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value |
| refund_receipts | purchase_orders.APAccountRef.value = refund_receipts.DepositToAccountRef.value purchase_orders.ClassRef.value = refund_receipts.ClassRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value = refund_receipts.ClassRef.value purchase_orders.CurrencyRef.value = refund_receipts.CurrencyRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value = refund_receipts.CustomerRef.value purchase_orders.DepartmentRef.value = refund_receipts.DepartmentRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value = refund_receipts.Line.SalesItemLineDetail.ItemRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value |
| sales_receipts | purchase_orders.APAccountRef.value = sales_receipts.DepositToAccountRef.value purchase_orders.APAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value purchase_orders.ClassRef.value = sales_receipts.ClassRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value = sales_receipts.ClassRef.value purchase_orders.CurrencyRef.value = sales_receipts.CurrencyRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value = sales_receipts.CustomerRef.value purchase_orders.DepartmentRef.value = sales_receipts.DepartmentRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value = sales_receipts.Line.SalesItemLineDetail.ItemRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value |
| transfers | purchase_orders.APAccountRef.value = transfers.FromAccountRef.value purchase_orders.APAccountRef.value = transfers.ToAccountRef.value purchase_orders.CurrencyRef.value = transfers.CurrencyRef.value |
| vendor_credits | purchase_orders.APAccountRef.value = vendor_credits.APAccountRef.value purchase_orders.APAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value purchase_orders.ClassRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value purchase_orders.CurrencyRef.value = vendor_credits.CurrencyRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value purchase_orders.DepartmentRef.value = vendor_credits.DepartmentRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value purchase_orders.VendorRef.value = vendor_credits.VendorRef.value |
| classes | purchase_orders.ClassRef.value = classes.Id purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value = classes.Id purchase_orders.ClassRef.value = classes.ParentRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value = classes.ParentRef.value |
| credit_memos | purchase_orders.ClassRef.value = credit_memos.ClassRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value = credit_memos.ClassRef.value purchase_orders.CurrencyRef.value = credit_memos.CurrencyRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value = credit_memos.CustomerRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value = credit_memos.Line.SalesItemLineDetail.ItemRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value purchase_orders.SalesTermRef.value = credit_memos.SalesTermRef.value |
| estimates | purchase_orders.ClassRef.value = estimates.ClassRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value = estimates.ClassRef.value purchase_orders.CurrencyRef.value = estimates.CurrencyRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value = estimates.CustomerRef.value purchase_orders.DepartmentRef.value = estimates.DepartmentRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value = estimates.Line.SalesItemLineDetail.ItemRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = estimates.Line.SalesItemLineDetail.TaxCodeRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = estimates.TxnTaxDetail.TxnTaxCodeRef.value purchase_orders.SalesTermRef.value = estimates.SalesTermRef.value |
| time_activities | purchase_orders.ClassRef.value = time_activities.ClassRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value = time_activities.ClassRef.value purchase_orders.DepartmentRef.value = time_activities.DepartmentRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value = time_activities.ItemRef.value purchase_orders.VendorRef.value = time_activities.VendorRef.value |
| customers | purchase_orders.CurrencyRef.value = customers.CurrencyRef.value purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value = customers.Id purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = customers.DefaultTaxCodeRef.value purchase_orders.SalesTermRef.value = customers.SalesTermRef.value |
| vendors | purchase_orders.CurrencyRef.value = vendors.CurrencyRef.value purchase_orders.VendorRef.value = vendors.Id |
| departments | purchase_orders.DepartmentRef.value = departments.ParentRef.value purchase_orders.DepartmentRef.value = departments.Id |
| terms | purchase_orders.SalesTermRef.value = terms.Id |
APAccountRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ClassRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CurrencyRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomField ARRAY | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DepartmentRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DocNumber STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DueDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
EmailStatus STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ExchangeRate NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GlobalTaxCalculation STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Id STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Line ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
LinkedTxn ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Memo STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MetaData OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
POEmail OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
POStatus STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PrivateNote STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
RecurDataRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SalesTermRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipAddr OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipMethodRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipTo OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SyncToken STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TotalAmt NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TransactionLocationType STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnTaxDetail OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
VendorAddr OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
VendorRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
domain STRING |
purchases
Thepurchases table contains info about the purchases recorded in your QuickBooks instance. This table includes all purchase types:Cash,Check, andCreditCard.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| Join purchases with | on |
|---|---|
| accounts | purchases.AccountRef.value = accounts.Id purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = accounts.Id purchases.AccountRef.value = accounts.ParentRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = accounts.ParentRef.value purchases.CurrencyRef.value = accounts.CurrencyRef.value |
| bill_payments | purchases.AccountRef.value = bill_payments.APAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = bill_payments.APAccountRef.value purchases.AccountRef.value = bill_payments.CheckPayment.BankAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = bill_payments.CheckPayment.BankAccountRef.value purchases.AccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value purchases.CurrencyRef.value = bill_payments.CurrencyRef.value purchases.DepartmentRef.value = bill_payments.DepartmentRef.value |
| bills | purchases.AccountRef.value = bills.APAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = bills.APAccountRef.value purchases.AccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value purchases.CurrencyRef.value = bills.CurrencyRef.value purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value = bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value purchases.DepartmentRef.value = bills.DepartmentRef.value purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value = bills.Line.ItemBasedExpenseLineDetail.ItemRef.value purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value |
| budgets | purchases.AccountRef.value = budgets.BudgetDetail.AccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = budgets.BudgetDetail.AccountRef.value purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value = budgets.BudgetDetail.ClassRef.value purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value = budgets.BudgetDetail.CustomerRef.value purchases.DepartmentRef.value = budgets.BudgetDetail.DepartmentRef.value |
| deposits | purchases.AccountRef.value = deposits.CashBack.AccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = deposits.CashBack.AccountRef.value purchases.AccountRef.value = deposits.DepositToAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = deposits.DepositToAccountRef.value purchases.AccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value purchases.CurrencyRef.value = deposits.CurrencyRef.value purchases.DepartmentRef.value = deposits.DepartmentRef.value purchases.PaymentMethodRef.value = deposits.Line.DepositLineDetail.PaymentMethodRef.value |
| invoices | purchases.AccountRef.value = invoices.DepositToAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = invoices.DepositToAccountRef.value purchases.AccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value = invoices.ClassRef.value purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value = invoices.Line.SalesItemLineDetail.ClassRef.value purchases.CurrencyRef.value = invoices.CurrencyRef.value purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value = invoices.CustomerRef.value purchases.DepartmentRef.value = invoices.DepartmentRef.value purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value = invoices.Line.SalesItemLineDetail.ItemRef.value purchases.Id = invoices.LinkedTxn.TxnId purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = invoices.Line.SalesItemLineDetail.TaxCodeRef.value purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = invoices.Line.SalesItemLineDetail.TaxCodeRef.value purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = invoices.TxnTaxDetail.TxnTaxCodeRef.value purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = invoices.TxnTaxDetail.TxnTaxCodeRef.value purchases.Id = invoices.Id |
| items | purchases.AccountRef.value = items.AssetAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = items.AssetAccountRef.value purchases.AccountRef.value = items.ExpenseAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = items.ExpenseAccountRef.value purchases.AccountRef.value = items.IncomeAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = items.IncomeAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value = items.ClassRef.value purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value = items.Id purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value = items.ParentRef.value purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = items.PurchaseTaxCodeRef.value purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = items.PurchaseTaxCodeRef.value purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = items.SalesTaxCodeRef.value purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = items.SalesTaxCodeRef.value |
| journal_entries | purchases.AccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value purchases.CurrencyRef.value = journal_entries.CurrencyRef.value purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value |
| payments | purchases.AccountRef.value = payments.DepositToAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = payments.DepositToAccountRef.value purchases.CurrencyRef.value = payments.CurrencyRef.value purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value = payments.CustomerRef.value purchases.PaymentMethodRef.value = payments.PaymentMethodRef.value purchases.Id = payments.Line.LinkedTxn.TxnId purchases.Id = payments.Id |
| purchase_orders | purchases.AccountRef.value = purchase_orders.APAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = purchase_orders.APAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value = purchase_orders.ClassRef.value purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value purchases.CurrencyRef.value = purchase_orders.CurrencyRef.value purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value purchases.DepartmentRef.value = purchase_orders.DepartmentRef.value purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value |
| refund_receipts | purchases.AccountRef.value = refund_receipts.DepositToAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = refund_receipts.DepositToAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value = refund_receipts.ClassRef.value purchases.CurrencyRef.value = refund_receipts.CurrencyRef.value purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value = refund_receipts.CustomerRef.value purchases.DepartmentRef.value = refund_receipts.DepartmentRef.value purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value = refund_receipts.Line.SalesItemLineDetail.ItemRef.value purchases.PaymentMethodRef.value = refund_receipts.PaymentMethodRef.value purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value |
| sales_receipts | purchases.AccountRef.value = sales_receipts.DepositToAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = sales_receipts.DepositToAccountRef.value purchases.AccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value = sales_receipts.ClassRef.value purchases.CurrencyRef.value = sales_receipts.CurrencyRef.value purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value = sales_receipts.CustomerRef.value purchases.DepartmentRef.value = sales_receipts.DepartmentRef.value purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value = sales_receipts.Line.SalesItemLineDetail.ItemRef.value purchases.PaymentMethodRef.value = sales_receipts.PaymentMethodRef.value purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value |
| transfers | purchases.AccountRef.value = transfers.FromAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = transfers.FromAccountRef.value purchases.AccountRef.value = transfers.ToAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = transfers.ToAccountRef.value purchases.CurrencyRef.value = transfers.CurrencyRef.value |
| vendor_credits | purchases.AccountRef.value = vendor_credits.APAccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = vendor_credits.APAccountRef.value purchases.AccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value purchases.CurrencyRef.value = vendor_credits.CurrencyRef.value purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value purchases.DepartmentRef.value = vendor_credits.DepartmentRef.value purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value |
| classes | purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value = classes.Id purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value = classes.ParentRef.value |
| credit_memos | purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value = credit_memos.ClassRef.value purchases.CurrencyRef.value = credit_memos.CurrencyRef.value purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value = credit_memos.CustomerRef.value purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value = credit_memos.Line.SalesItemLineDetail.ItemRef.value purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value purchases.Id = credit_memos.Id |
| estimates | purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value = estimates.ClassRef.value purchases.CurrencyRef.value = estimates.CurrencyRef.value purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value = estimates.CustomerRef.value purchases.DepartmentRef.value = estimates.DepartmentRef.value purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value = estimates.Line.SalesItemLineDetail.ItemRef.value purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = estimates.Line.SalesItemLineDetail.TaxCodeRef.value purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = estimates.Line.SalesItemLineDetail.TaxCodeRef.value purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = estimates.TxnTaxDetail.TxnTaxCodeRef.value purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = estimates.TxnTaxDetail.TxnTaxCodeRef.value purchases.Id = estimates.Id |
| time_activities | purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value = time_activities.ClassRef.value purchases.DepartmentRef.value = time_activities.DepartmentRef.value purchases.EntityRef.value = time_activities.EmployeeRef.value purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value = time_activities.ItemRef.value purchases.Id = time_activities.Id |
| customers | purchases.CurrencyRef.value = customers.CurrencyRef.value purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value = customers.Id purchases.PaymentMethodRef.value = customers.PaymentMethodRef.value purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = customers.DefaultTaxCodeRef.value purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value = customers.DefaultTaxCodeRef.value |
| vendors | purchases.CurrencyRef.value = vendors.CurrencyRef.value |
| departments | purchases.DepartmentRef.value = departments.ParentRef.value purchases.DepartmentRef.value = departments.Id |
| employees | purchases.EntityRef.value = employees.Id |
| payment_methods | purchases.PaymentMethodRef.value = payment_methods.Id |
AccountRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Credit BOOLEAN | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CurrencyRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DepartmentRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DocNumber STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
EntityRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ExchangeRate NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GlobalTaxCalculation STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Id STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
IncludeInAnnualTPAR BOOLEAN | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Line ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
LinkedTxn ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MetaData OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PaymentMethodRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PaymentType STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PrintStatus STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PrivateNote STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PurchaseEx OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
RecurDataRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
RemitToAddr OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SyncToken STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TotalAmt NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TransactionLocationType STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnSource STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnTaxDetail OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
domain STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
patternProperties OBJECT |
refund_receipts
Therefund_receipts table contains info about customer refunds recorded in your QuickBooks instance.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| Join refund_receipts with | on |
|---|---|
| accounts | refund_receipts.DepositToAccountRef.value = accounts.Id refund_receipts.DepositToAccountRef.value = accounts.ParentRef.value refund_receipts.CurrencyRef.value = accounts.CurrencyRef.value |
| bill_payments | refund_receipts.DepositToAccountRef.value = bill_payments.APAccountRef.value refund_receipts.DepositToAccountRef.value = bill_payments.CheckPayment.BankAccountRef.value refund_receipts.DepositToAccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value refund_receipts.CurrencyRef.value = bill_payments.CurrencyRef.value refund_receipts.DepartmentRef.value = bill_payments.DepartmentRef.value |
| bills | refund_receipts.DepositToAccountRef.value = bills.APAccountRef.value refund_receipts.DepositToAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value refund_receipts.CurrencyRef.value = bills.CurrencyRef.value refund_receipts.CustomerRef.value = bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value refund_receipts.DepartmentRef.value = bills.DepartmentRef.value refund_receipts.Line.SalesItemLineDetail.ItemRef.value = bills.Line.ItemBasedExpenseLineDetail.ItemRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value |
| budgets | refund_receipts.DepositToAccountRef.value = budgets.BudgetDetail.AccountRef.value refund_receipts.ClassRef.value = budgets.BudgetDetail.ClassRef.value refund_receipts.CustomerRef.value = budgets.BudgetDetail.CustomerRef.value refund_receipts.DepartmentRef.value = budgets.BudgetDetail.DepartmentRef.value |
| deposits | refund_receipts.DepositToAccountRef.value = deposits.CashBack.AccountRef.value refund_receipts.DepositToAccountRef.value = deposits.DepositToAccountRef.value refund_receipts.DepositToAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value refund_receipts.CurrencyRef.value = deposits.CurrencyRef.value refund_receipts.DepartmentRef.value = deposits.DepartmentRef.value refund_receipts.PaymentMethodRef.value = deposits.Line.DepositLineDetail.PaymentMethodRef.value refund_receipts.Id = deposits.Line.LinkedTxn.TxnId |
| invoices | refund_receipts.DepositToAccountRef.value = invoices.DepositToAccountRef.value refund_receipts.DepositToAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value refund_receipts.ClassRef.value = invoices.ClassRef.value refund_receipts.ClassRef.value = invoices.Line.SalesItemLineDetail.ClassRef.value refund_receipts.CurrencyRef.value = invoices.CurrencyRef.value refund_receipts.CustomerRef.value = invoices.CustomerRef.value refund_receipts.DepartmentRef.value = invoices.DepartmentRef.value refund_receipts.Line.SalesItemLineDetail.ItemRef.value = invoices.Line.SalesItemLineDetail.ItemRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = invoices.Line.SalesItemLineDetail.TaxCodeRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = invoices.TxnTaxDetail.TxnTaxCodeRef.value |
| items | refund_receipts.DepositToAccountRef.value = items.AssetAccountRef.value refund_receipts.DepositToAccountRef.value = items.ExpenseAccountRef.value refund_receipts.DepositToAccountRef.value = items.IncomeAccountRef.value refund_receipts.ClassRef.value = items.ClassRef.value refund_receipts.Line.SalesItemLineDetail.ItemRef.value = items.Id refund_receipts.Line.SalesItemLineDetail.ItemRef.value = items.ParentRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = items.PurchaseTaxCodeRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = items.SalesTaxCodeRef.value |
| journal_entries | refund_receipts.DepositToAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value refund_receipts.CurrencyRef.value = journal_entries.CurrencyRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value refund_receipts.Id = journal_entries.Id |
| payments | refund_receipts.DepositToAccountRef.value = payments.DepositToAccountRef.value refund_receipts.CurrencyRef.value = payments.CurrencyRef.value refund_receipts.CustomerRef.value = payments.CustomerRef.value refund_receipts.PaymentMethodRef.value = payments.PaymentMethodRef.value refund_receipts.Id = payments.Id |
| purchase_orders | refund_receipts.DepositToAccountRef.value = purchase_orders.APAccountRef.value refund_receipts.ClassRef.value = purchase_orders.ClassRef.value refund_receipts.ClassRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value refund_receipts.CurrencyRef.value = purchase_orders.CurrencyRef.value refund_receipts.CustomerRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value refund_receipts.DepartmentRef.value = purchase_orders.DepartmentRef.value refund_receipts.Line.SalesItemLineDetail.ItemRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value |
| purchases | refund_receipts.DepositToAccountRef.value = purchases.AccountRef.value refund_receipts.DepositToAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value refund_receipts.ClassRef.value = purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value refund_receipts.CurrencyRef.value = purchases.CurrencyRef.value refund_receipts.CustomerRef.value = purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value refund_receipts.DepartmentRef.value = purchases.DepartmentRef.value refund_receipts.Line.SalesItemLineDetail.ItemRef.value = purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value refund_receipts.PaymentMethodRef.value = purchases.PaymentMethodRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value |
| sales_receipts | refund_receipts.DepositToAccountRef.value = sales_receipts.DepositToAccountRef.value refund_receipts.DepositToAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value refund_receipts.ClassRef.value = sales_receipts.ClassRef.value refund_receipts.CurrencyRef.value = sales_receipts.CurrencyRef.value refund_receipts.CustomerRef.value = sales_receipts.CustomerRef.value refund_receipts.DepartmentRef.value = sales_receipts.DepartmentRef.value refund_receipts.Line.SalesItemLineDetail.ItemRef.value = sales_receipts.Line.SalesItemLineDetail.ItemRef.value refund_receipts.PaymentMethodRef.value = sales_receipts.PaymentMethodRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value refund_receipts.Id = sales_receipts.Id |
| transfers | refund_receipts.DepositToAccountRef.value = transfers.FromAccountRef.value refund_receipts.DepositToAccountRef.value = transfers.ToAccountRef.value refund_receipts.CurrencyRef.value = transfers.CurrencyRef.value refund_receipts.Id = transfers.Id |
| vendor_credits | refund_receipts.DepositToAccountRef.value = vendor_credits.APAccountRef.value refund_receipts.DepositToAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value refund_receipts.ClassRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value refund_receipts.CurrencyRef.value = vendor_credits.CurrencyRef.value refund_receipts.CustomerRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value refund_receipts.DepartmentRef.value = vendor_credits.DepartmentRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value |
| classes | refund_receipts.ClassRef.value = classes.Id refund_receipts.ClassRef.value = classes.ParentRef.value |
| credit_memos | refund_receipts.ClassRef.value = credit_memos.ClassRef.value refund_receipts.CurrencyRef.value = credit_memos.CurrencyRef.value refund_receipts.CustomerRef.value = credit_memos.CustomerRef.value refund_receipts.Line.SalesItemLineDetail.ItemRef.value = credit_memos.Line.SalesItemLineDetail.ItemRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value |
| estimates | refund_receipts.ClassRef.value = estimates.ClassRef.value refund_receipts.CurrencyRef.value = estimates.CurrencyRef.value refund_receipts.CustomerRef.value = estimates.CustomerRef.value refund_receipts.DepartmentRef.value = estimates.DepartmentRef.value refund_receipts.Line.SalesItemLineDetail.ItemRef.value = estimates.Line.SalesItemLineDetail.ItemRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = estimates.Line.SalesItemLineDetail.TaxCodeRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = estimates.TxnTaxDetail.TxnTaxCodeRef.value |
| time_activities | refund_receipts.ClassRef.value = time_activities.ClassRef.value refund_receipts.DepartmentRef.value = time_activities.DepartmentRef.value refund_receipts.Line.SalesItemLineDetail.ItemRef.value = time_activities.ItemRef.value |
| customers | refund_receipts.CurrencyRef.value = customers.CurrencyRef.value refund_receipts.CustomerRef.value = customers.Id refund_receipts.PaymentMethodRef.value = customers.PaymentMethodRef.value refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = customers.DefaultTaxCodeRef.value |
| vendors | refund_receipts.CurrencyRef.value = vendors.CurrencyRef.value |
| departments | refund_receipts.DepartmentRef.value = departments.ParentRef.value refund_receipts.DepartmentRef.value = departments.Id |
| payment_methods | refund_receipts.PaymentMethodRef.value = payment_methods.Id |
ApplyTaxAfterDiscount BOOLEAN | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Balance NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
BillAddr OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
BillEmail OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CheckPayment OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ClassRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CreditCardPayment OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CurrencyRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomField ARRAY | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomerMemo OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomerRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DepartmentRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DepositToAccountRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DocNumber STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ExchangeRate NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
FreeFormAddress BOOLEAN | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GlobalTaxCalculation STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
HomeBalance NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
HomeTotalAmt NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Id STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Line ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MetaData OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PaymentMethodRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PaymentRefNum STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PaymentType STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PrintStatus STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PrivateNote STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
RecurDataRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipAddr OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SyncToken STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TaxExemptionRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TotalAmt NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TransactionLocationType STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnSource STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnTaxDetail OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
domain STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
patternProperties OBJECT |
sales_receipts
Thesales_receipts table contains info about the sales receipts recorded in your QuickBooks instance.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| Join sales_receipts with | on |
|---|---|
| accounts | sales_receipts.DepositToAccountRef.value = accounts.Id sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = accounts.Id sales_receipts.DepositToAccountRef.value = accounts.ParentRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = accounts.ParentRef.value sales_receipts.CurrencyRef.value = accounts.CurrencyRef.value |
| bill_payments | sales_receipts.DepositToAccountRef.value = bill_payments.APAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = bill_payments.APAccountRef.value sales_receipts.DepositToAccountRef.value = bill_payments.CheckPayment.BankAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = bill_payments.CheckPayment.BankAccountRef.value sales_receipts.DepositToAccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value sales_receipts.CurrencyRef.value = bill_payments.CurrencyRef.value sales_receipts.DepartmentRef.value = bill_payments.DepartmentRef.value |
| bills | sales_receipts.DepositToAccountRef.value = bills.APAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = bills.APAccountRef.value sales_receipts.DepositToAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value sales_receipts.CurrencyRef.value = bills.CurrencyRef.value sales_receipts.CustomerRef.value = bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value sales_receipts.DepartmentRef.value = bills.DepartmentRef.value sales_receipts.Line.SalesItemLineDetail.ItemRef.value = bills.Line.ItemBasedExpenseLineDetail.ItemRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value |
| budgets | sales_receipts.DepositToAccountRef.value = budgets.BudgetDetail.AccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = budgets.BudgetDetail.AccountRef.value sales_receipts.ClassRef.value = budgets.BudgetDetail.ClassRef.value sales_receipts.CustomerRef.value = budgets.BudgetDetail.CustomerRef.value sales_receipts.DepartmentRef.value = budgets.BudgetDetail.DepartmentRef.value |
| deposits | sales_receipts.DepositToAccountRef.value = deposits.CashBack.AccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = deposits.CashBack.AccountRef.value sales_receipts.DepositToAccountRef.value = deposits.DepositToAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = deposits.DepositToAccountRef.value sales_receipts.DepositToAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value sales_receipts.CurrencyRef.value = deposits.CurrencyRef.value sales_receipts.DepartmentRef.value = deposits.DepartmentRef.value sales_receipts.PaymentMethodRef.value = deposits.Line.DepositLineDetail.PaymentMethodRef.value sales_receipts.Id = deposits.Line.LinkedTxn.TxnId |
| invoices | sales_receipts.DepositToAccountRef.value = invoices.DepositToAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = invoices.DepositToAccountRef.value sales_receipts.DepositToAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value sales_receipts.ClassRef.value = invoices.ClassRef.value sales_receipts.ClassRef.value = invoices.Line.SalesItemLineDetail.ClassRef.value sales_receipts.CurrencyRef.value = invoices.CurrencyRef.value sales_receipts.CustomerRef.value = invoices.CustomerRef.value sales_receipts.DepartmentRef.value = invoices.DepartmentRef.value sales_receipts.Line.SalesItemLineDetail.ItemRef.value = invoices.Line.SalesItemLineDetail.ItemRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = invoices.Line.SalesItemLineDetail.TaxCodeRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = invoices.TxnTaxDetail.TxnTaxCodeRef.value |
| items | sales_receipts.DepositToAccountRef.value = items.AssetAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = items.AssetAccountRef.value sales_receipts.DepositToAccountRef.value = items.ExpenseAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = items.ExpenseAccountRef.value sales_receipts.DepositToAccountRef.value = items.IncomeAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = items.IncomeAccountRef.value sales_receipts.ClassRef.value = items.ClassRef.value sales_receipts.Line.SalesItemLineDetail.ItemRef.value = items.Id sales_receipts.Line.SalesItemLineDetail.ItemRef.value = items.ParentRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = items.PurchaseTaxCodeRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = items.SalesTaxCodeRef.value |
| journal_entries | sales_receipts.DepositToAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value sales_receipts.CurrencyRef.value = journal_entries.CurrencyRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value sales_receipts.Id = journal_entries.Id |
| payments | sales_receipts.DepositToAccountRef.value = payments.DepositToAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = payments.DepositToAccountRef.value sales_receipts.CurrencyRef.value = payments.CurrencyRef.value sales_receipts.CustomerRef.value = payments.CustomerRef.value sales_receipts.PaymentMethodRef.value = payments.PaymentMethodRef.value sales_receipts.Id = payments.Id |
| purchase_orders | sales_receipts.DepositToAccountRef.value = purchase_orders.APAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = purchase_orders.APAccountRef.value sales_receipts.ClassRef.value = purchase_orders.ClassRef.value sales_receipts.ClassRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value sales_receipts.CurrencyRef.value = purchase_orders.CurrencyRef.value sales_receipts.CustomerRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value sales_receipts.DepartmentRef.value = purchase_orders.DepartmentRef.value sales_receipts.Line.SalesItemLineDetail.ItemRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value |
| purchases | sales_receipts.DepositToAccountRef.value = purchases.AccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = purchases.AccountRef.value sales_receipts.DepositToAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value sales_receipts.ClassRef.value = purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value sales_receipts.CurrencyRef.value = purchases.CurrencyRef.value sales_receipts.CustomerRef.value = purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value sales_receipts.DepartmentRef.value = purchases.DepartmentRef.value sales_receipts.Line.SalesItemLineDetail.ItemRef.value = purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value sales_receipts.PaymentMethodRef.value = purchases.PaymentMethodRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value |
| refund_receipts | sales_receipts.DepositToAccountRef.value = refund_receipts.DepositToAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = refund_receipts.DepositToAccountRef.value sales_receipts.ClassRef.value = refund_receipts.ClassRef.value sales_receipts.CurrencyRef.value = refund_receipts.CurrencyRef.value sales_receipts.CustomerRef.value = refund_receipts.CustomerRef.value sales_receipts.DepartmentRef.value = refund_receipts.DepartmentRef.value sales_receipts.Line.SalesItemLineDetail.ItemRef.value = refund_receipts.Line.SalesItemLineDetail.ItemRef.value sales_receipts.PaymentMethodRef.value = refund_receipts.PaymentMethodRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value sales_receipts.Id = refund_receipts.Id |
| transfers | sales_receipts.DepositToAccountRef.value = transfers.FromAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = transfers.FromAccountRef.value sales_receipts.DepositToAccountRef.value = transfers.ToAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = transfers.ToAccountRef.value sales_receipts.CurrencyRef.value = transfers.CurrencyRef.value sales_receipts.Id = transfers.Id |
| vendor_credits | sales_receipts.DepositToAccountRef.value = vendor_credits.APAccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = vendor_credits.APAccountRef.value sales_receipts.DepositToAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value sales_receipts.ClassRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value sales_receipts.CurrencyRef.value = vendor_credits.CurrencyRef.value sales_receipts.CustomerRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value sales_receipts.DepartmentRef.value = vendor_credits.DepartmentRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value |
| classes | sales_receipts.ClassRef.value = classes.Id sales_receipts.ClassRef.value = classes.ParentRef.value |
| credit_memos | sales_receipts.ClassRef.value = credit_memos.ClassRef.value sales_receipts.CurrencyRef.value = credit_memos.CurrencyRef.value sales_receipts.CustomerRef.value = credit_memos.CustomerRef.value sales_receipts.Line.SalesItemLineDetail.ItemRef.value = credit_memos.Line.SalesItemLineDetail.ItemRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value |
| estimates | sales_receipts.ClassRef.value = estimates.ClassRef.value sales_receipts.CurrencyRef.value = estimates.CurrencyRef.value sales_receipts.CustomerRef.value = estimates.CustomerRef.value sales_receipts.DepartmentRef.value = estimates.DepartmentRef.value sales_receipts.Line.SalesItemLineDetail.ItemRef.value = estimates.Line.SalesItemLineDetail.ItemRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = estimates.Line.SalesItemLineDetail.TaxCodeRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = estimates.TxnTaxDetail.TxnTaxCodeRef.value |
| time_activities | sales_receipts.ClassRef.value = time_activities.ClassRef.value sales_receipts.DepartmentRef.value = time_activities.DepartmentRef.value sales_receipts.Line.SalesItemLineDetail.ItemRef.value = time_activities.ItemRef.value |
| customers | sales_receipts.CurrencyRef.value = customers.CurrencyRef.value sales_receipts.CustomerRef.value = customers.Id sales_receipts.PaymentMethodRef.value = customers.PaymentMethodRef.value sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value = customers.DefaultTaxCodeRef.value |
| vendors | sales_receipts.CurrencyRef.value = vendors.CurrencyRef.value |
| departments | sales_receipts.DepartmentRef.value = departments.ParentRef.value sales_receipts.DepartmentRef.value = departments.Id |
| payment_methods | sales_receipts.PaymentMethodRef.value = payment_methods.Id |
ApplyTaxAfterDiscount BOOLEAN | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Balance NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
BillAddr OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
BillEmail OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ClassRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CreditCardPayment OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CurrencyRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomField ARRAY | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomerMemo OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CustomerRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DeliveryInfo OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DepartmentRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DepositToAccountRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DocNumber STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
EmailStatus STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ExchangeRate NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
FreeFormAddress BOOLEAN | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GlobalTaxCalculation STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
HomeBalance NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
HomeTotalAmt NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Id STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Line ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
LinkedTxn ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MetaData OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PaymentMethodRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PaymentRefNum STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PrintStatus STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PrivateNote STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
RecurDataRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipAddr OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipFromAddr OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ShipMethodRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SyncToken STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TotalAmt NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TrackingNum STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TransactionLocationType STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnSource STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnTaxDetail OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
domain STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
patternProperties OBJECT |
tax_agencies
Thetax_agencies table contains info about the tax-collecting entites defined in your QuickBooks instance.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| Join tax_agencies with | on |
|---|---|
| tax_rates | tax_agencies.Id = tax_rates.AgencyRef.value |
DisplayName STRING | ||
Id STRING | ||
LastFileDate DATE-TIME | ||
MetaData OBJECT
| ||
SyncToken STRING | ||
TaxAgencyConfig STRING | ||
TaxRegistrationNumber STRING | ||
TaxTrackedOnPurchases BOOLEAN | ||
TaxTrackedOnSales BOOLEAN | ||
domain STRING |
tax_codes
Thetax_codes table contains info about the tax codes defined in your QuickBooks instance.Note: Both active and inactive tax codes are included in the data for this table.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| Join tax_codes with | on |
|---|---|
| estimates | tax_codes.PurchaseTaxRateList.TaxRateDetail.TaxRateRef.value = estimates.TxnTaxDetail.TaxLine.TaxLineDetail.TaxLine.TaxLineDetail.TaxRateRef.value tax_codes.SalesTaxRateList.TaxRateDetail.TaxRateRef.value = estimates.TxnTaxDetail.TaxLine.TaxLineDetail.TaxLine.TaxLineDetail.TaxRateRef.value |
| invoices | tax_codes.PurchaseTaxRateList.TaxRateDetail.TaxRateRef.value = invoices.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value tax_codes.SalesTaxRateList.TaxRateDetail.TaxRateRef.value = invoices.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value |
| journal_entries | tax_codes.PurchaseTaxRateList.TaxRateDetail.TaxRateRef.value = journal_entries.TaxRateRef.value tax_codes.SalesTaxRateList.TaxRateDetail.TaxRateRef.value = journal_entries.TaxRateRef.value tax_codes.PurchaseTaxRateList.TaxRateDetail.TaxRateRef.value = journal_entries.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value tax_codes.SalesTaxRateList.TaxRateDetail.TaxRateRef.value = journal_entries.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value |
| tax_rates | tax_codes.PurchaseTaxRateList.TaxRateDetail.TaxRateRef.value = tax_rates.Id tax_codes.SalesTaxRateList.TaxRateDetail.TaxRateRef.value = tax_rates.Id |
Active BOOLEAN | ||||||
Description STRING | ||||||
Hidden BOOLEAN | ||||||
Id STRING | ||||||
MetaData OBJECT
| ||||||
Name STRING | ||||||
PurchaseTaxRateList OBJECT
| ||||||
SalesTaxRateList OBJECT
| ||||||
SyncToken STRING | ||||||
TaxCodeConfigType STRING | ||||||
TaxGroup BOOLEAN | ||||||
Taxable BOOLEAN | ||||||
domain STRING |
tax_rates
Thetax_rates table contains info about the tax rates defined in your QuickBooks instance.Note: Both active and inactive tax rates are included in the data for this table.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| Join tax_rates with | on |
|---|---|
| tax_agencies | tax_rates.AgencyRef.value = tax_agencies.Id |
| estimates | tax_rates.Id = estimates.TxnTaxDetail.TaxLine.TaxLineDetail.TaxLine.TaxLineDetail.TaxRateRef.value |
| invoices | tax_rates.Id = invoices.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value |
| journal_entries | tax_rates.Id = journal_entries.TaxRateRef.value tax_rates.Id = journal_entries.TxnTaxDetail.TaxLine.TaxLineDetail.TaxRateRef.value |
| tax_codes | tax_rates.Id = tax_codes.PurchaseTaxRateList.TaxRateDetail.TaxRateRef.value tax_rates.Id = tax_codes.SalesTaxRateList.TaxRateDetail.TaxRateRef.value |
Active BOOLEAN | |||
AgencyRef OBJECT
| |||
Description STRING | |||
DisplayType STRING | |||
EffectiveTaxRate OBJECT ARRAY
| |||
Id STRING | |||
MetaData OBJECT
| |||
Name STRING | |||
OriginalTaxRate STRING | |||
RateValue NUMBER | |||
SpecialTaxType STRING | |||
SyncToken STRING | |||
TaxReturnLineRef OBJECT
| |||
domain STRING |
terms
Theterms table contains info about the sale terms defined in your QuickBooks instance.Note: Both active and inactive terms are included in the data for this table.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| Join terms with | on |
|---|---|
| bills | terms.Id = bills.SalesTermRef.value |
| credit_memos | terms.Id = credit_memos.SalesTermRef.value |
| customers | terms.Id = customers.SalesTermRef.value |
| estimates | terms.Id = estimates.SalesTermRef.value |
| invoices | terms.Id = invoices.SalesTermRef.value |
| purchase_orders | terms.Id = purchase_orders.SalesTermRef.value |
Active BOOLEAN | ||
DayOfMonthDue INTEGER | ||
DiscountDayOfMonth INTEGER | ||
DiscountDays INTEGER | ||
DiscountPercent NUMBER | ||
DueDays INTEGER | ||
DueNextMonthDays INTEGER | ||
Id STRING | ||
MetaData OBJECT
| ||
Name STRING | ||
SyncToken STRING | ||
Type STRING | ||
domain STRING |
time_activities
Thetime_activities table contains info about vendor and employee time records in your QuickBooks instance.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| Join time_activities with | on |
|---|---|
| budgets | time_activities.ClassRef.value = budgets.BudgetDetail.ClassRef.value time_activities.DepartmentRef.value = budgets.BudgetDetail.DepartmentRef.value |
| classes | time_activities.ClassRef.value = classes.Id time_activities.ClassRef.value = classes.ParentRef.value |
| credit_memos | time_activities.ClassRef.value = credit_memos.ClassRef.value time_activities.ItemRef.value = credit_memos.Line.SalesItemLineDetail.ItemRef.value |
| estimates | time_activities.ClassRef.value = estimates.ClassRef.value time_activities.DepartmentRef.value = estimates.DepartmentRef.value time_activities.ItemRef.value = estimates.Line.SalesItemLineDetail.ItemRef.value time_activities.Id = estimates.Id |
| invoices | time_activities.ClassRef.value = invoices.ClassRef.value time_activities.ClassRef.value = invoices.Line.SalesItemLineDetail.ClassRef.value time_activities.DepartmentRef.value = invoices.DepartmentRef.value time_activities.ItemRef.value = invoices.Line.SalesItemLineDetail.ItemRef.value time_activities.Id = invoices.LinkedTxn.TxnId |
| items | time_activities.ClassRef.value = items.ClassRef.value time_activities.ItemRef.value = items.Id time_activities.ItemRef.value = items.ParentRef.value time_activities.VendorRef.value = items.PrefVendorRef.value |
| purchase_orders | time_activities.ClassRef.value = purchase_orders.ClassRef.value time_activities.ClassRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value time_activities.DepartmentRef.value = purchase_orders.DepartmentRef.value time_activities.ItemRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ItemRef.value time_activities.VendorRef.value = purchase_orders.VendorRef.value |
| purchases | time_activities.ClassRef.value = purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value time_activities.DepartmentRef.value = purchases.DepartmentRef.value time_activities.EmployeeRef.value = purchases.EntityRef.value time_activities.ItemRef.value = purchases.Line.ItemBasedExpenseLineDetail.ItemRef.value time_activities.Id = purchases.Id |
| refund_receipts | time_activities.ClassRef.value = refund_receipts.ClassRef.value time_activities.DepartmentRef.value = refund_receipts.DepartmentRef.value time_activities.ItemRef.value = refund_receipts.Line.SalesItemLineDetail.ItemRef.value |
| sales_receipts | time_activities.ClassRef.value = sales_receipts.ClassRef.value time_activities.DepartmentRef.value = sales_receipts.DepartmentRef.value time_activities.ItemRef.value = sales_receipts.Line.SalesItemLineDetail.ItemRef.value |
| vendor_credits | time_activities.ClassRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value time_activities.DepartmentRef.value = vendor_credits.DepartmentRef.value time_activities.VendorRef.value = vendor_credits.VendorRef.value |
| bills | time_activities.DepartmentRef.value = bills.DepartmentRef.value time_activities.ItemRef.value = bills.Line.ItemBasedExpenseLineDetail.ItemRef.value time_activities.VendorRef.value = bills.VendorRef.value |
| bill_payments | time_activities.DepartmentRef.value = bill_payments.DepartmentRef.value time_activities.VendorRef.value = bill_payments.VendorRef.value |
| departments | time_activities.DepartmentRef.value = departments.ParentRef.value time_activities.DepartmentRef.value = departments.Id |
| deposits | time_activities.DepartmentRef.value = deposits.DepartmentRef.value |
| employees | time_activities.EmployeeRef.value = employees.Id |
| payments | time_activities.Id = payments.Id |
| vendors | time_activities.VendorRef.value = vendors.Id |
BillableStatus STRING | ||
BreakHours INTEGER | ||
BreakMinutes INTEGER | ||
ClassRef OBJECT
| ||
CostRate NUMBER | ||
CustomerRef OBJECT
| ||
DepartmentRef OBJECT
| ||
Description STRING | ||
EmployeeRef OBJECT
| ||
EndTime DATE-TIME | ||
HourlyRate INTEGER | ||
Hours INTEGER | ||
Id STRING | ||
ItemRef OBJECT
| ||
MetaData OBJECT
| ||
Minutes INTEGER | ||
NameOf STRING | ||
PayrollItemRef OBJECT
| ||
StartTime DATE-TIME | ||
SyncToken STRING | ||
Taxable BOOLEAN | ||
TransactionLocationType STRING | ||
TxnDate DATE-TIME | ||
VendorRef OBJECT
| ||
domain STRING | ||
patternProperties OBJECT |
transfers
Thetransfers table contains info about account transfers from your company’s QuickBooks chart of accounts.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| Join transfers with | on |
|---|---|
| accounts | transfers.FromAccountRef.value = accounts.Id transfers.ToAccountRef.value = accounts.Id transfers.FromAccountRef.value = accounts.ParentRef.value transfers.ToAccountRef.value = accounts.ParentRef.value transfers.CurrencyRef.value = accounts.CurrencyRef.value |
| bill_payments | transfers.FromAccountRef.value = bill_payments.APAccountRef.value transfers.ToAccountRef.value = bill_payments.APAccountRef.value transfers.FromAccountRef.value = bill_payments.CheckPayment.BankAccountRef.value transfers.ToAccountRef.value = bill_payments.CheckPayment.BankAccountRef.value transfers.FromAccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value transfers.ToAccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value transfers.CurrencyRef.value = bill_payments.CurrencyRef.value |
| bills | transfers.FromAccountRef.value = bills.APAccountRef.value transfers.ToAccountRef.value = bills.APAccountRef.value transfers.FromAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value transfers.ToAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value transfers.CurrencyRef.value = bills.CurrencyRef.value |
| budgets | transfers.FromAccountRef.value = budgets.BudgetDetail.AccountRef.value transfers.ToAccountRef.value = budgets.BudgetDetail.AccountRef.value |
| deposits | transfers.FromAccountRef.value = deposits.CashBack.AccountRef.value transfers.ToAccountRef.value = deposits.CashBack.AccountRef.value transfers.FromAccountRef.value = deposits.DepositToAccountRef.value transfers.ToAccountRef.value = deposits.DepositToAccountRef.value transfers.FromAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value transfers.ToAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value transfers.CurrencyRef.value = deposits.CurrencyRef.value transfers.Id = deposits.Line.LinkedTxn.TxnId |
| invoices | transfers.FromAccountRef.value = invoices.DepositToAccountRef.value transfers.ToAccountRef.value = invoices.DepositToAccountRef.value transfers.FromAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value transfers.ToAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value transfers.CurrencyRef.value = invoices.CurrencyRef.value |
| items | transfers.FromAccountRef.value = items.AssetAccountRef.value transfers.ToAccountRef.value = items.AssetAccountRef.value transfers.FromAccountRef.value = items.ExpenseAccountRef.value transfers.ToAccountRef.value = items.ExpenseAccountRef.value transfers.FromAccountRef.value = items.IncomeAccountRef.value transfers.ToAccountRef.value = items.IncomeAccountRef.value |
| journal_entries | transfers.FromAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value transfers.ToAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value transfers.CurrencyRef.value = journal_entries.CurrencyRef.value transfers.Id = journal_entries.Id |
| payments | transfers.FromAccountRef.value = payments.DepositToAccountRef.value transfers.ToAccountRef.value = payments.DepositToAccountRef.value transfers.CurrencyRef.value = payments.CurrencyRef.value transfers.Id = payments.Id |
| purchase_orders | transfers.FromAccountRef.value = purchase_orders.APAccountRef.value transfers.ToAccountRef.value = purchase_orders.APAccountRef.value transfers.CurrencyRef.value = purchase_orders.CurrencyRef.value |
| purchases | transfers.FromAccountRef.value = purchases.AccountRef.value transfers.ToAccountRef.value = purchases.AccountRef.value transfers.FromAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value transfers.ToAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value transfers.CurrencyRef.value = purchases.CurrencyRef.value |
| refund_receipts | transfers.FromAccountRef.value = refund_receipts.DepositToAccountRef.value transfers.ToAccountRef.value = refund_receipts.DepositToAccountRef.value transfers.CurrencyRef.value = refund_receipts.CurrencyRef.value transfers.Id = refund_receipts.Id |
| sales_receipts | transfers.FromAccountRef.value = sales_receipts.DepositToAccountRef.value transfers.ToAccountRef.value = sales_receipts.DepositToAccountRef.value transfers.FromAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value transfers.ToAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value transfers.CurrencyRef.value = sales_receipts.CurrencyRef.value transfers.Id = sales_receipts.Id |
| vendor_credits | transfers.FromAccountRef.value = vendor_credits.APAccountRef.value transfers.ToAccountRef.value = vendor_credits.APAccountRef.value transfers.FromAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value transfers.ToAccountRef.value = vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value transfers.CurrencyRef.value = vendor_credits.CurrencyRef.value |
| credit_memos | transfers.CurrencyRef.value = credit_memos.CurrencyRef.value |
| customers | transfers.CurrencyRef.value = customers.CurrencyRef.value |
| estimates | transfers.CurrencyRef.value = estimates.CurrencyRef.value |
| vendors | transfers.CurrencyRef.value = vendors.CurrencyRef.value |
Amount NUMBER | ||
CurrencyRef OBJECT
| ||
ExchangeRate NUMBER | ||
FromAccountRef OBJECT
| ||
Id STRING | ||
MetaData OBJECT
| ||
PrivateNote STRING | ||
RecurDataRef OBJECT
| ||
SyncToken STRING | ||
ToAccountRef OBJECT
| ||
TransactionLocationType STRING | ||
TxnDate DATE-TIME | ||
domain STRING |
vendor_credits
Thevendor_credits table contains info about credits that a vendor owes your company.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| Join vendor_credits with | on |
|---|---|
| accounts | vendor_credits.APAccountRef.value = accounts.Id vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = accounts.Id vendor_credits.APAccountRef.value = accounts.ParentRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = accounts.ParentRef.value vendor_credits.CurrencyRef.value = accounts.CurrencyRef.value |
| bill_payments | vendor_credits.APAccountRef.value = bill_payments.APAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = bill_payments.APAccountRef.value vendor_credits.APAccountRef.value = bill_payments.CheckPayment.BankAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = bill_payments.CheckPayment.BankAccountRef.value vendor_credits.APAccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = bill_payments.CreditCardPayment.CCAccountRef.value vendor_credits.CurrencyRef.value = bill_payments.CurrencyRef.value vendor_credits.DepartmentRef.value = bill_payments.DepartmentRef.value vendor_credits.Id = bill_payments.Line.LinkedTxn.TxnId vendor_credits.VendorRef.value = bill_payments.VendorRef.value |
| bills | vendor_credits.APAccountRef.value = bills.APAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = bills.APAccountRef.value vendor_credits.APAccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = bills.Line.AccountBasedExpenseLineDetail.AccountRef.value vendor_credits.CurrencyRef.value = bills.CurrencyRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value = bills.Line.AccountBasedExpenseLineDetail.CustomerRef.value vendor_credits.DepartmentRef.value = bills.DepartmentRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = bills.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = bills.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value vendor_credits.Id = bills.Id vendor_credits.VendorRef.value = bills.VendorRef.value |
| budgets | vendor_credits.APAccountRef.value = budgets.BudgetDetail.AccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = budgets.BudgetDetail.AccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value = budgets.BudgetDetail.ClassRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value = budgets.BudgetDetail.CustomerRef.value vendor_credits.DepartmentRef.value = budgets.BudgetDetail.DepartmentRef.value |
| deposits | vendor_credits.APAccountRef.value = deposits.CashBack.AccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = deposits.CashBack.AccountRef.value vendor_credits.APAccountRef.value = deposits.DepositToAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = deposits.DepositToAccountRef.value vendor_credits.APAccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = deposits.Line.DepositLineDetail.AccountRef.value vendor_credits.CurrencyRef.value = deposits.CurrencyRef.value vendor_credits.DepartmentRef.value = deposits.DepartmentRef.value |
| invoices | vendor_credits.APAccountRef.value = invoices.DepositToAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = invoices.DepositToAccountRef.value vendor_credits.APAccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = invoices.Line.DiscountLineDetail.DiscountAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value = invoices.ClassRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value = invoices.Line.SalesItemLineDetail.ClassRef.value vendor_credits.CurrencyRef.value = invoices.CurrencyRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value = invoices.CustomerRef.value vendor_credits.DepartmentRef.value = invoices.DepartmentRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = invoices.Line.SalesItemLineDetail.TaxCodeRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = invoices.TxnTaxDetail.TxnTaxCodeRef.value |
| items | vendor_credits.APAccountRef.value = items.AssetAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = items.AssetAccountRef.value vendor_credits.APAccountRef.value = items.ExpenseAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = items.ExpenseAccountRef.value vendor_credits.APAccountRef.value = items.IncomeAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = items.IncomeAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value = items.ClassRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = items.PurchaseTaxCodeRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = items.SalesTaxCodeRef.value vendor_credits.VendorRef.value = items.PrefVendorRef.value |
| journal_entries | vendor_credits.APAccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = journal_entries.Line.JournalEntryLineDetail.AccountRef.value vendor_credits.CurrencyRef.value = journal_entries.CurrencyRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = journal_entries.TxnTaxDetail.TxnTaxCodeRef.value vendor_credits.Id = journal_entries.Id |
| payments | vendor_credits.APAccountRef.value = payments.DepositToAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = payments.DepositToAccountRef.value vendor_credits.CurrencyRef.value = payments.CurrencyRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value = payments.CustomerRef.value |
| purchase_orders | vendor_credits.APAccountRef.value = purchase_orders.APAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = purchase_orders.APAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value = purchase_orders.ClassRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.ClassRef.value vendor_credits.CurrencyRef.value = purchase_orders.CurrencyRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.CustomerRef.value vendor_credits.DepartmentRef.value = purchase_orders.DepartmentRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = purchase_orders.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value vendor_credits.VendorRef.value = purchase_orders.VendorRef.value |
| purchases | vendor_credits.APAccountRef.value = purchases.AccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = purchases.AccountRef.value vendor_credits.APAccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = purchases.Line.AccountBasedExpenseLineDetail.AccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value = purchases.Line.AccountBasedExpenseLineDetail.ClassRef.value vendor_credits.CurrencyRef.value = purchases.CurrencyRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value = purchases.Line.AccountBasedExpenseLineDetail.CustomerRef.value vendor_credits.DepartmentRef.value = purchases.DepartmentRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = purchases.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = purchases.Line.ItemBasedExpenseLineDetail.TaxCodeRef.value |
| refund_receipts | vendor_credits.APAccountRef.value = refund_receipts.DepositToAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = refund_receipts.DepositToAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value = refund_receipts.ClassRef.value vendor_credits.CurrencyRef.value = refund_receipts.CurrencyRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value = refund_receipts.CustomerRef.value vendor_credits.DepartmentRef.value = refund_receipts.DepartmentRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = refund_receipts.Line.SalesItemLineDetail.TaxCodeRef.value |
| sales_receipts | vendor_credits.APAccountRef.value = sales_receipts.DepositToAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = sales_receipts.DepositToAccountRef.value vendor_credits.APAccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = sales_receipts.Line.DiscountLineDetail.DiscountAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value = sales_receipts.ClassRef.value vendor_credits.CurrencyRef.value = sales_receipts.CurrencyRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value = sales_receipts.CustomerRef.value vendor_credits.DepartmentRef.value = sales_receipts.DepartmentRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = sales_receipts.Line.SalesItemLineDetail.TaxCodeRef.value |
| transfers | vendor_credits.APAccountRef.value = transfers.FromAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = transfers.FromAccountRef.value vendor_credits.APAccountRef.value = transfers.ToAccountRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.AccountRef.value = transfers.ToAccountRef.value vendor_credits.CurrencyRef.value = transfers.CurrencyRef.value |
| classes | vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value = classes.Id vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value = classes.ParentRef.value |
| credit_memos | vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value = credit_memos.ClassRef.value vendor_credits.CurrencyRef.value = credit_memos.CurrencyRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value = credit_memos.CustomerRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = credit_memos.Line.SalesItemLineDetail.TaxCodeRef.value |
| estimates | vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value = estimates.ClassRef.value vendor_credits.CurrencyRef.value = estimates.CurrencyRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value = estimates.CustomerRef.value vendor_credits.DepartmentRef.value = estimates.DepartmentRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = estimates.Line.SalesItemLineDetail.TaxCodeRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = estimates.TxnTaxDetail.TxnTaxCodeRef.value |
| time_activities | vendor_credits.Line.AccountBasedExpenseLineDetail.ClassRef.value = time_activities.ClassRef.value vendor_credits.DepartmentRef.value = time_activities.DepartmentRef.value vendor_credits.VendorRef.value = time_activities.VendorRef.value |
| customers | vendor_credits.CurrencyRef.value = customers.CurrencyRef.value vendor_credits.Line.AccountBasedExpenseLineDetail.CustomerRef.value = customers.Id vendor_credits.Line.AccountBasedExpenseLineDetail.TaxCodeRef.value = customers.DefaultTaxCodeRef.value |
| vendors | vendor_credits.CurrencyRef.value = vendors.CurrencyRef.value vendor_credits.VendorRef.value = vendors.Id |
| departments | vendor_credits.DepartmentRef.value = departments.ParentRef.value vendor_credits.DepartmentRef.value = departments.Id |
APAccountRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Balance NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CurrencyRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DepartmentRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DocNumber STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
ExchangeRate NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
GlobalTaxCalculation STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Id STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
IncludeInAnnualTPAR BOOLEAN | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Line ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
LinkedTxn ARRAY
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MetaData OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PrivateNote STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
RecurDataRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SyncToken STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TotalAmt NUMBER | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TransactionLocationType STRING | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
TxnDate DATE-TIME | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
VendorRef OBJECT
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
domain STRING |
vendors
Thevendors table contains info about the sellers your company purchases products from.Note: Both active and inactive vendors are included in the data for this table.
Key-based Incremental | |
Primary Key | Id |
| Useful links |
| Join vendors with | on |
|---|---|
| accounts | vendors.CurrencyRef.value = accounts.CurrencyRef.value |
| bill_payments | vendors.CurrencyRef.value = bill_payments.CurrencyRef.value vendors.Id = bill_payments.VendorRef.value |
| bills | vendors.CurrencyRef.value = bills.CurrencyRef.value vendors.Id = bills.VendorRef.value |
| credit_memos | vendors.CurrencyRef.value = credit_memos.CurrencyRef.value |
| customers | vendors.CurrencyRef.value = customers.CurrencyRef.value |
| deposits | vendors.CurrencyRef.value = deposits.CurrencyRef.value |
| estimates | vendors.CurrencyRef.value = estimates.CurrencyRef.value |
| invoices | vendors.CurrencyRef.value = invoices.CurrencyRef.value |
| journal_entries | vendors.CurrencyRef.value = journal_entries.CurrencyRef.value |
| payments | vendors.CurrencyRef.value = payments.CurrencyRef.value |
| purchase_orders | vendors.CurrencyRef.value = purchase_orders.CurrencyRef.value vendors.Id = purchase_orders.VendorRef.value |
| purchases | vendors.CurrencyRef.value = purchases.CurrencyRef.value |
| refund_receipts | vendors.CurrencyRef.value = refund_receipts.CurrencyRef.value |
| sales_receipts | vendors.CurrencyRef.value = sales_receipts.CurrencyRef.value |
| transfers | vendors.CurrencyRef.value = transfers.CurrencyRef.value |
| vendor_credits | vendors.CurrencyRef.value = vendor_credits.CurrencyRef.value vendors.Id = vendor_credits.VendorRef.value |
| items | vendors.Id = items.PrefVendorRef.value |
| time_activities | vendors.Id = time_activities.VendorRef.value |
APAccountRef OBJECT
| ||||||||||||
AcctNum STRING | ||||||||||||
Active BOOLEAN | ||||||||||||
AlternatePhone OBJECT
| ||||||||||||
Balance NUMBER | ||||||||||||
BillAddr OBJECT
| ||||||||||||
BillRate NUMBER | ||||||||||||
BusinessNumber STRING | ||||||||||||
CompanyName STRING | ||||||||||||
CostRate NUMBER | ||||||||||||
CurrencyRef OBJECT
| ||||||||||||
DisplayName STRING | ||||||||||||
FamilyName STRING | ||||||||||||
Fax OBJECT
| ||||||||||||
GSTIN STRING | ||||||||||||
GSTRegistrationType STRING | ||||||||||||
GivenName STRING | ||||||||||||
HasTPAR BOOLEAN | ||||||||||||
Id STRING | ||||||||||||
MetaData OBJECT
| ||||||||||||
MiddleName STRING | ||||||||||||
Mobile OBJECT
| ||||||||||||
OtherContactInfo OBJECT
| ||||||||||||
PrimaryEmailAddr OBJECT
| ||||||||||||
PrimaryPhone OBJECT
| ||||||||||||
PrintOnCheckName STRING | ||||||||||||
Source STRING | ||||||||||||
Suffix STRING | ||||||||||||
SyncToken STRING | ||||||||||||
T4AEligible BOOLEAN | ||||||||||||
T5018Eligible BOOLEAN | ||||||||||||
TaxIdentifier STRING | ||||||||||||
TaxReportingBasis STRING | ||||||||||||
TermRef OBJECT
| ||||||||||||
Title STRING | ||||||||||||
Vendor1099 BOOLEAN | ||||||||||||
VendorPaymentBankDetail OBJECT
| ||||||||||||
WebAddr OBJECT
| ||||||||||||
domain STRING | ||||||||||||
patternProperties OBJECT |
| Related | Troubleshooting |
Questions? Feedback?
Did this article help? If you have questions or feedback, feel free tosubmit a pull request with your suggestions,open an issue on GitHub, orreach out to us.