Knowledge base

Data Model Explorer

Our **Data Model Explorer** provides an _Entity Relationship Diagram_ (ERD) of your Sage Accounting 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 - Address - Address region - Address type - Attachment - Bank account - Bank account type - Bank deposit - Bank opening balance - Bank reconciliation - Bank transfer - Chart of accounts - Chart of accounts template - Contact - Contact allocation - Contact opening balance - Contact payment - Contact person - Country - Currency - Journal - Ledger account - Ledger account opening balance - Ledger account type - Ledger entry - Other payment - Payment method - Product - Product sales price type - Product stock item - Purchase credit note - Purchase invoice - Sales credit note - Sales estimate - Sales invoice - Sales quote - Service - Service rate type - Stock movement - Tax rate - Transaction - Transaction type - Contact type - Contact allocation artefact - Contact payment allocated artefact - Contact person type - Journal line - Other payment line - Product sales price - Purchase credit note line - Purchase credit note payment allocation - Purchase invoice line - Purchase invoice payment allocation - Sales credit note line - Sales credit note payment allocation - Sales estimate profit line breakdown - Sales estimate line - Sales invoice line - Sales invoice payment allocation - Sales quote profit line breakdown - Sales quote line - Service sale rate - Tax rate percentage