Quickbooks Data Dictionary
  • 19 Jul 2022
  • 1 Minute to read
  • Dark
    Light
  • PDF

Quickbooks Data Dictionary

  • Dark
    Light
  • PDF

Panoply utilizes Quickbooks' REST API to collect data into your Panoply data warehouse.

Metadata

Panoply inserts the following metadata fields into each table collected:

  • __company_id: The connected Quickbooks Company ID.
  • __company_name: The connected Quickbooks Company name.
  • __resource: The name of the selected resource.

Quickbooks Endpoints

Panoply supports up to 36 different endpoints:

  • Account
  • Attachable
  • Bill
  • Bill Payment
  • Budget
  • Class
  • Company Currency
  • Company Info
  • Credit Memo
  • Credit Card Payment
  • Customer
  • Customer Type
  • Department
  • Deposit
  • Employee
  • Estimate
  • Invoice
  • Item
  • Journal Code
  • Journal Entry
  • Payment
  • Payment Method
  • Purchase
  • Purchase Order
  • Refund Receipt
  • Reimburse Charge
  • Sales Receipt
  • Tax Agency
  • Tax Code
  • Tax Payment (only available for AU, CA and UK locales)
  • Tax Rate
  • Term
  • Time Activity
  • Transfer
  • Vendor
  • Vendor Credit

Was this article helpful?