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 Xero 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 - Bank transaction - Bank transaction line item tracking category - Bank transfer - Batch payment - Budget - Contact - Contact group - Credit note - Credit note item - Credit note item tracking category - Employee - Contact history - Bank transaction history - Bank transfer history - Credit note history - Manual journal history - Invoice history - Item history - Payment history - Purchase order history - Repeating invoice history - Quote history - Overpayment history - Prepayment history - Batch payment history - Invoice - Invoice item - Invoice item tracking category - Item - Journal - Journal item - Expense claim - Manual journal - Organisation - Overpayment - Overpayment item - Payment - Prepayment - Prepayment item - Prepayment item tracking category - Purchase order - Purchase order item tracking category - Quote - Quote item - Quote item tracking category - Repeating invoice - Repeating invoice item - Repeating invoice item tracking category - Tax rate - Tracking category - User - Balance sheet report - Profit and loss report by fiscal year - Profit and loss report by fiscal year and tracking category - Profit and loss report by month - Profit and loss report by month and tracking category - Trial balance report - Bank transaction line item - Batch payment payment - Budget tracking category - Contact contact group - Contact address - Contact phone - Credit note allocation - Journal item tracking category - Manual journal line item - Over payment allocation - Purchase order line item - Tracking category option - Report row cell - Report row - Budget account balance - Manual journal item tracking category