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
- Drag tables around the workspace, by clicking and dragging anywhere on a table
- Drag the entire workspace around by clicking and dragging the background
- 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 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
- 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