Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

Schema Information

This subtopic provides a structured reference to assist you in working with Daton's QuickBooks connector and the associated fields and tables.

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Pulse

    • Daton

      Need help with something?

      Talk to data expert

      Schema Information

      This subtopic provides a structured reference to assist you in working with Daton's QuickBooks connector and the associated fields and tables.

      Tables/APIs 

      The following is the list of tables or APIs associated with the QuickBooks connector:

      • Bills
      • Accounts
      • Companyinfo
      • Invoice
      • Preferences
      • Purchase
      • Vendor
      • TaxAgency
      • Payment
      • Item
      • Employee
      • Customer

      Bills

      Purpose: Returns all the results of bills.

      Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/bill#query-a-bill

      Replication: Key-Based Replication

      Replication Key: lastRunDate

      Fields

      Name
      Target Datatype
      DueDate
      DATE
      Balance
      NUMERIC
      domain
      STRING
      sparse
      BOOLEAN
      Id
      INTEGER
      SyncToken
      STRING
      MetaData
      RECORD
      TxnDate
      DATE
      CurrencyRef
      RECORD
      Line
      RECORD
      TxnTaxDetail
      RECORD
      VendorRef
      RECORD
      APAccountRef
      RECORD
      TotalAmt
      NUMERIC
      GlobalTaxCalculation
      STRING

      Accounts

      Purpose: Returns a list of all the accounts.

      Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/account#query-an-account

      Replication: Key-Based Replication

      Replication Key: lastRunDate

      Fields

      Name
      Target Datatype
      Name
      STRING
      SubAccount
      BOOLEAN
      FullyQualifiedName
      STRING
      Active
      BOOLEAN
      Classification
      STRING
      AccountType
      STRING
      AccountSubType
      STRING
      CurrentBalance
      NUMERIC
      CurrentBalanceWithSubAccounts
      NUMERIC
      CurrencyRef
      RECORD
      domain
      STRING
      sparse
      BOOLEAN
      Id
      INTEGER
      SyncToken
      STRING
      MetaData
      RECORD

      Companyinfo

      Purpose:Returns the results of all the companies and their info.

      Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/companyinfo#query-companyinfo

      Replication: Full Replication

      Replication Key: NA

      Fields

      Name
      Target Datatype
      CompanyName
      STRING
      LegalName
      STRING
      CompanyAddr
      RECORD
      CustomerCommunicationAddr
      RECORD
      LegalAddr
      RECORD
      CompanyStartDate
      DATE
      FiscalYearStartMonth
      STRING
      Country
      STRING
      Email
      RECORD
      SupportedLanguages
      STRING
      NameValue
      RECORD
      domain
      STRING
      sparse
      BOOLEAN
      Id
      INTEGER
      SyncToken
      STRING
      MetaData
      RECORD

      Invoice

      Purpose:Returns a result of all the invoices generated.

      Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/invoice#query-an-invoice

      Replication: Key-Based Replication

      Replication Key: lastRunDate

      Fields

      Name
      Target Datatype
      AllowIPNPayment
      BOOLEAN
      AllowOnlinePayment
      BOOLEAN
      AllowOnlineCreditCardPayment
      BOOLEAN
      AllowOnlineACHPayment
      BOOLEAN
      domain
      STRING
      sparse
      BOOLEAN
      Id
      INTEGER
      SyncToken
      STRING
      MetaData
      RECORD
      DocNumber
      INTEGER
      TxnDate
      DATE
      CurrencyRef
      RECORD
      LinkedTxn
      RECORD
      Line
      RECORD
      TxnTaxDetail
      RECORD
      CustomerRef
      RECORD
      FreeFormAddress
      BOOLEAN
      SalesTermRef
      RECORD
      DueDate
      DATE
      GlobalTaxCalculation
      STRING
      TotalAmt
      NUMERIC
      PrintStatus
      STRING
      EmailStatus
      STRING
      Balance
      NUMERIC
      DiscountAmt
      NUMERIC

      Preferences

      Purpose:Returns a result of all the preferences.

      Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/preferences#query-preferences

      Replication: Key-Based Replication

      Replication Key: lastRunDate

      Fields

      Name
      Target Datatype
      AccountingInfoPrefs
      RECORD
      ProductAndServicesPrefs
      RECORD
      SalesFormsPrefs
      RECORD
      EmailMessagesPrefs
      RECORD
      VendorAndPurchasesPrefs
      RECORD
      TimeTrackingPrefs
      RECORD
      TaxPrefs
      RECORD
      CurrencyPrefs
      RECORD
      ReportPrefs
      RECORD
      domain
      STRING
      sparse
      BOOLEAN
      Id
      STRING
      SyncToken
      STRING
      MetaData
      RECORD

      Purchase

      Purpose: Returns a list of all the purchases made.

      Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/purchase#query-a-purchase

      Replication: Key-Based Replication

      Replication Key: lastRunDate

      Fields

      Name
      Target Datatype
      AccountRef
      RECORD
      PaymentType
      STRING
      TotalAmt
      NUMERIC
      PrintStatus
      STRING
      GlobalTaxCalculation
      STRING
      PurchaseEx
      RECORD
      domain
      STRING
      sparse
      BOOLEAN
      Id
      INTEGER
      SyncToken
      STRING
      MetaData
      RECORD
      DocNumber
      STRING
      TxnDate
      DATE
      CurrencyRef
      RECORD
      Line
      RECORD

      Vendor

      Purpose:Returns list of all the vendors.

      Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/vendor#query-a-vendor

      Replication: Key-Based Replication

      Replication Key: lastRunDate

      Fields

      Name
      Target Datatype
      Balance
      NUMERIC
      Vendor1099
      BOOLEAN
      CurrencyRef
      RECORD
      GSTIN
      STRING
      GSTRegistrationType
      STRING
      domain
      STRING
      sparse
      BOOLEAN
      Id
      INTEGER
      SyncToken
      STRING
      MetaData
      RECORD
      DisplayName
      STRING
      PrintOnCheckName
      STRING
      Active
      BOOLEAN

      TaxAgency

      Purpose:Returns a list of all the taxes generated.

      Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/taxagency#query-a-taxagency

      Replication: Key-Based Replication

      Replication Key: lastRunDate

      Fields

      Name
      Target Datatype
      TaxTrackedOnPurchases
      BOOLEAN
      TaxTrackedOnSales
      BOOLEAN
      domain
      STRING
      sparse
      BOOLEAN
      Id
      INTEGER
      SyncToken
      STRING
      MetaData
      RECORD
      DisplayName
      STRING

      Payment

      Purpose:Returns a list of all the payments.

      Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/payment#query-a-payment

      Replication: Key-Based Replication

      Replication Key: lastRunDate

      Fields

      Name
      Target Datatype
      CustomerRef
      RECORD
      DepositToAccountRef
      RECORD
      PaymentMethodRef
      RECORD
      PaymentRefNum
      INTEGER
      TotalAmt
      NUMERIC
      UnappliedAmt
      NUMERIC
      ProcessPayment
      BOOLEAN
      domain
      STRING
      sparse
      BOOLEAN
      Id
      INTEGER
      SyncToken
      STRING
      MetaData
      RECORD
      TxnDate
      DATE
      CurrencyRef
      RECORD
      Line
      RECORD

      Item

      Purpose:Returns the list of all the items boughtsold by the company.

      Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/item#query-an-item

      Replication: Key-Based Replication

      Replication Key: lastRunDate

      Fields

      Name
      Target Datatype
      Name
      STRING
      Active
      BOOLEAN
      FullyQualifiedName
      STRING
      Taxable
      BOOLEAN
      SalesTaxIncluded
      BOOLEAN
      UnitPrice
      NUMERIC
      Type
      STRING
      IncomeAccountRef
      RECORD
      PurchaseTaxIncluded
      BOOLEAN
      PurchaseCost
      NUMERIC
      TrackQtyOnHand
      BOOLEAN
      AbatementRate
      NUMERIC
      ReverseChargeRate
      NUMERIC
      domain
      STRING
      sparse
      BOOLEAN
      Id
      INTEGER
      SyncToken
      STRING
      MetaData
      RECORD

      Employee

      Purpose: Returns the list of all the employees in the company.

      Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/employee#query-an-employee

      Replication: Key-Based Replication

      Replication Key: lastRunDate

      Fields

      Name
      Target Datatype
      EmployeeNumber
      STRING
      SSN
      STRING
      PrimaryAddr
      RECORD
      BillableTime
      BOOLEAN
      BillRate
      NUMERIC
      BirthDate
      DATE
      Gender
      STRING
      HiredDate
      DATE
      ReleasedDate
      DATE
      V4IDPseudonym
      STRING
      domain
      STRING
      sparse
      BOOLEAN
      Id
      INTEGER
      SyncToken
      STRING
      MetaData
      RECORD
      Title
      STRING
      GivenName
      STRING
      FamilyName
      STRING
      DisplayName
      STRING
      PrintOnCheckName
      STRING
      Active
      BOOLEAN

      Customer

      Purpose: Returns the list of all the customers.

      Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/customer#query-a-customer

      Replication: Key-Based Replication

      Replication Key: lastRunDate

      Fields

      Name
      Target Datatype
      Taxable
      BOOLEAN
      Job
      BOOLEAN
      BillWithParent
      BOOLEAN
      Balance
      NUMERIC
      BalanceWithJobs
      INTEGER
      CurrencyRef
      RECORD
      PreferredDeliveryMethod
      STRING
      IsProject
      BOOLEAN
      GSTRegistrationType
      STRING
      domain
      STRING
      sparse
      BOOLEAN
      Id
      INTEGER
      SyncToken
      STRING
      MetaData
      RECORD
      GivenName
      STRING
      FullyQualifiedName
      STRING
      DisplayName
      STRING
      PrintOnCheckName
      STRING
      Active
      BOOLEAN
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       

       

      information model data structure

      Was this article helpful?

      Yes
      No
      Give feedback about this article

      Related Articles

      • Essential Attributes and Supported Tables
      • How to Integrate QuickBooks with Daton

      Table of Contents

      Tables/APIs Bills Fields Accounts Fields Companyinfo Fields Invoice Fields Preferences Fields Purchase Fields Vendor Fields TaxAgency Fields Payment Fields Item Fields Employee Fields Customer Fields

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Experts
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Follow Us

      Linkedin Youtube

      Company

      • Customers
      • Partner With Us
      • Contact Us

      Culture

      • About
      • People
      • Careers

      Offerings

      • Daton
      • For Brands
      • For Agencies

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA

      Follow Us

      Linkedin Youtube

      DISCLAIMER: Various trademarks are held by their respective owners

      © 2023 sarasanalytics.com

      Sitemap

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Sales
      DISCLAIMER: Trademarks are held by their respective owners
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Company

      • Customers
      • Partners
      • About
      • People
      • Careers
      • Contact Us

      Offerings

      • Daton
      • Solution for Brands
      • Solution for Agencies
      • Dashboards
      • Founder's Note
      • Status

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA
      • Sitemap

      © 2023 sarasanalytics.com

      Linkedin Youtube

      Knowledge Base Software powered by Helpjuice

      Expand