2024 is the year of the connector - vote here

Knowledge base

Data Model Explorer

Our **Data Model Explorer** provides an _Entity Relationship Diagram_ (ERD) of your QuickBooks data, allowing you to see the relationships between your different tables. ### Navigating 1. Drag tables around the workspace, by clicking and dragging anywhere on a table 1. Drag the entire workspace around by clicking and dragging the background 1. Minimize/maximize your workspace to take up your entire browser screen ### Relationships Relationships are depicted by the arrows running between table properties. For a tidier view, you may select the _Relationships Only_ checkbox, which will hide all the other columns which are not part of a relationship ### Endpoints - Account - Bill - Class - Company - Credit memo - Customer - Department - Deposit - Employee - Expense - Estimate - Invoice - Item - Journal entry - Payment - Purchase order - Sales receipt - Tax agency - Tax code - Tax rate - Term - Vendor - Bill account line - Bill item line - Credit memo sales item line - Deposit linked txn line - Expense account line - Expense item line - Estimate line - Estimate description line - Invoice description line - Invoice line - Journal entry line - Payment line - Purchase order account line - Purchase order item line - Sales receipt line - Tax code rate