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
- Bill payment
- Class
- Company
- Credit memo
- Customer
- Department
- Deposit
- Employee
- Estimate
- Expense
- Invoice
- Item
- Journal entry
- Payment
- Preferences
- Purchase order
- Balance sheet report by fiscal year
- Balance sheet report by month
- Profit and loss report by fiscal year
- Profit and loss report by month
- Sales receipt
- Tax agency
- Tax code
- Tax rate
- Term
- Time activity
- Vendor
- Bill account line
- Bill item line
- Bill payment line
- Credit memo sales item line
- Deposit linked txn line
- Estimate line
- Estimate description line
- Expense account line
- Expense item line
- Invoice description line
- Invoice line
- Journal entry line
- Payment line
- Preferences custom field
- Purchase order account line
- Purchase order item line
- Balance sheet report by fiscal year row
- Balance sheet report by fiscal year column
- Balance sheet report by month row
- Balance sheet report by month column
- Profit and loss report by fiscal year row
- Profit and loss report by fiscal year column
- Profit and loss report by month row
- Profit and loss report by month column
- Sales receipt line
- Tax code rate
- Balance sheet report by fiscal year row column value
- Balance sheet report by fiscal year column meta data item
- Balance sheet report by month row column value
- Balance sheet report by month column meta data item
- Profit and loss report by fiscal year row column value
- Profit and loss report by fiscal year column meta data item
- Profit and loss report by month row column value
- Profit and loss report by month column meta data item