Quickbooks Data Dictionary

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