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 Brightpearl 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 - Accounting period - Brand - Channel brand - Company - Contact group - Contact group member - Contact - Contact custom field - Contact tag - Currency - Customer payment - Goods movement - Order goods note - Order goods out note - Journal - Lead source - Nominal code - Order - Order custom field - Order status - Order stock status - Order shipping status - Order type - Payment - Payment method - Postal address - Price list - Product season - Product product category - Product - Product warehouse availability - Product category - Product channel - Product custom field - Product supplier - Product type - Product variation - Project - Season - Shipping method - Stock transfer - Supplier payment - Tax code - Warehouse location - Warehouse - Contact tag value - Contact custom field value - Contact custom field option - Order goods note movement - Order goods out note row - Order goods out note event - Journal credit - Journal debit - Order custom field value - Order invoice - Order landed cost estimate - Order row - Order custom field option - Payment method bank account - Product variation value - Product custom field value - Product bundled product - Product group - Product warehouse location availability - Product channel warehouse - Product custom field option - Product price - Product type associated variation - Product variation option - Shipping method break - Shipping method country - Order reservation - Order row product variation