# Brightpearl schema ERD

Table and field reference for the Fivetran Brightpearl connector.

## Table & Field Reference

### good_out_note_detail_event

| Column | Type | Keys |
| --- | --- | --- |
| event_code | Unknown | PK |
| goods_out_note_id | Unknown | PK, FK |
| order_id | Unknown | PK, FK |
| event_owner_id | Unknown |  |
| occured | Unknown |  |

### goods_out_note_detail

| Column | Type | Keys |
| --- | --- | --- |
| order_id | Unknown | PK |
| goods_out_note_id | Unknown | PK, FK |
| warehouse_id | Unknown | FK |
| created_by | Unknown |  |
| created_on | Unknown |  |
| label_uri | Unknown |  |
| last_event_version | Unknown |  |
| priority | Unknown |  |
| release_date | Unknown |  |
| sequence | Unknown |  |
| shipping_boxes | Unknown |  |
| shipping_method_id | Unknown |  |
| shipping_references | Unknown |  |
| shipping_weight | Unknown |  |
| status_packed | Unknown |  |
| status_packed_by_id | Unknown |  |
| status_packed_on | Unknown |  |
| status_picked | Unknown |  |
| status_picked_by_id | Unknown |  |
| status_picked_on | Unknown |  |
| status_printed | Unknown |  |
| status_printed_by_id | Unknown |  |
| status_printed_on | Unknown |  |
| status_shipped | Unknown |  |
| status_shipped_by_id | Unknown |  |
| status_shipped_on | Unknown |  |
| transfer | Unknown |  |

### goods_in_note

| Column | Type | Keys |
| --- | --- | --- |
| purchase_order_id | Unknown | PK |
| custom_** |  |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| custom_** |  |  |

### warehouse_weekly_operating_period

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| warehouse_id | Unknown | PK, FK |
| closing_hours | Unknown |  |
| day_of_week | Unknown |  |
| opening_hours | Unknown |  |

### warehouse_external_transfer_sla

| Column | Type | Keys |
| --- | --- | --- |
| external_transfer_sla_warehouse_id | Unknown | PK, FK |
| warehouse_id | Unknown | PK, FK |
| time_units | Unknown |  |
| value | Unknown |  |

### warehouse

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_country_id | Unknown |  |
| address_country_iso_code_2 | Unknown |  |
| address_customer_id | Unknown |  |
| address_id | Unknown |  |
| click_and_collect_enabled | Unknown |  |
| collection_sla_time_units | Unknown |  |
| collection_sla_value | Unknown |  |
| name | Unknown |  |
| type_code | Unknown |  |
| type_description | Unknown |  |
| weekly_operating_period_timezone | Unknown |  |

### contact_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_** |  |  |

### tax_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| description | Unknown |  |

### nominal_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_** |  |  |

### contact_group_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_group_id | Unknown | PK, FK |
| created_by | Unknown |  |
| created_on | Unknown |  |
| description | Unknown |  |
| is_read_only | Unknown |  |
| name | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_** |  |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_** |  |  |

### product_detail_season

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| season_id | Unknown |  |

### product_detail_warehouse

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| warehouse_id | Unknown | PK, FK |
| default_location_id | Unknown |  |
| overflow_location_id | Unknown |  |
| reorder_level | Unknown |  |
| reorder_quantity | Unknown |  |

### product_detail_variation

| Column | Type | Keys |
| --- | --- | --- |
| option_id | Unknown | PK |
| product_id | Unknown | PK, FK |
| option_name | Unknown |  |
| option_value | Unknown |  |
| option_value_id | Unknown |  |

### product_detail_sales_channel_category

| Column | Type | Keys |
| --- | --- | --- |
| category_code | Unknown | PK |
| product_id | Unknown | PK, FK |
| product_sales_channel_index | Unknown | PK, FK |

### product_detail_sales_channel

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| description_format | Unknown |  |
| description_language_code | Unknown |  |
| description_text | Unknown |  |
| product_condition | Unknown |  |
| product_name | Unknown |  |
| sales_channel_name | Unknown |  |
| short_description_format | Unknown |  |
| short_description_language_code | Unknown |  |
| short_description_text | Unknown |  |

### product_detail

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| brand_id | Unknown |  |
| composition_bundle | Unknown |  |
| created_on | Unknown |  |
| featured | Unknown |  |
| financial_detail_tax_code | Unknown |  |
| financial_detail_tax_code_id | Unknown |  |
| identity_barcode | Unknown |  |
| identity_ean | Unknown |  |
| identity_isbn | Unknown |  |
| identity_sku | Unknown |  |
| identity_upc | Unknown |  |
| nominal_code_purchase | Unknown |  |
| nominal_code_sale | Unknown |  |
| nominal_code_stock | Unknown |  |
| primary_supplier_id | Unknown |  |
| product_group_id | Unknown |  |
| product_type_id | Unknown |  |
| reporting_category_id | Unknown |  |
| reporting_season_id | Unknown |  |
| reporting_sub_category_id | Unknown |  |
| sales_popup_message | Unknown |  |
| status | Unknown |  |
| stock_dimension_height | Unknown |  |
| stock_dimension_length | Unknown |  |
| stock_dimension_volume | Unknown |  |
| stock_dimension_width | Unknown |  |
| stock_tracked | Unknown |  |
| stock_weight_magnitude | Unknown |  |
| updated_on | Unknown |  |
| version | Unknown |  |
| warehouse_popup_message | Unknown |  |

### order_detail_invoice

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| order_id | Unknown | FK |
| due_date | Unknown |  |
| invoice_reference | Unknown |  |
| tax_date | Unknown |  |

### order_detail_tax_error

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| tax_error | Unknown |  |

### order_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_order_id | Unknown | FK |
| parties_billing_contact_id | Unknown | FK |
| parties_customer_contact_id | Unknown | FK |
| parties_supplier_contact_id | Unknown | FK |
| warehouse_id | Unknown | FK |
| accounting_currency_code | Unknown |  |
| acknowledged | Unknown |  |
| allocation_status_code | Unknown |  |
| assignment_current_channel_id | Unknown |  |
| assignment_current_lead_source_id | Unknown |  |
| assignment_current_project_id | Unknown |  |
| assignment_current_staff_owner_contact_id | Unknown |  |
| assignment_current_team_id | Unknown |  |
| closed_on | Unknown |  |
| cost_price_list_id | Unknown |  |
| created_by_id | Unknown |  |
| created_on | Unknown |  |
| currency_exchange_rate | Unknown |  |
| currency_fixed_exchange_rate | Unknown |  |
| delivery_date | Unknown |  |
| delivery_shipping_method_id | Unknown |  |
| historical_order | Unknown |  |
| order_currency_code | Unknown |  |
| order_payment_status | Unknown |  |
| order_rows | Json |  |
| order_status_id | Unknown |  |
| order_status_name | Unknown |  |
| order_type_code | Unknown |  |
| order_weighting | Unknown |  |
| parties_billing_address_full_name | Unknown |  |
| parties_billing_address_line_1 | Unknown |  |
| parties_billing_address_line_2 | Unknown |  |
| parties_billing_address_line_3 | Unknown |  |
| parties_billing_address_line_4 | Unknown |  |
| parties_billing_company_name | Unknown |  |
| parties_billing_country | Unknown |  |
| parties_billing_country_id | Unknown |  |
| parties_billing_country_iso_code | Unknown |  |
| parties_billing_country_iso_code_3 | Unknown |  |
| parties_billing_email | Unknown |  |
| parties_billing_fax | Unknown |  |
| parties_billing_mobile_telephone | Unknown |  |
| parties_billing_postal_code | Unknown |  |
| parties_billing_telephone | Unknown |  |
| parties_customer_address_full_name | Unknown |  |
| parties_customer_address_line_1 | Unknown |  |
| parties_customer_address_line_2 | Unknown |  |
| parties_customer_address_line_3 | Unknown |  |
| parties_customer_address_line_4 | Unknown |  |
| parties_customer_company_name | Unknown |  |
| parties_customer_country | Unknown |  |
| parties_customer_country_id | Unknown |  |
| parties_customer_country_iso_code | Unknown |  |
| parties_customer_country_iso_code_3 | Unknown |  |
| parties_customer_email | Unknown |  |
| parties_customer_fax | Unknown |  |
| parties_customer_mobile_telephone | Unknown |  |
| parties_customer_postal_code | Unknown |  |
| parties_customer_telephone | Unknown |  |
| parties_supplier_address_full_name | Unknown |  |
| parties_supplier_address_line_1 | Unknown |  |
| parties_supplier_address_line_2 | Unknown |  |
| parties_supplier_address_line_3 | Unknown |  |
| parties_supplier_address_line_4 | Unknown |  |
| parties_supplier_company_name | Unknown |  |
| parties_supplier_country | Unknown |  |
| parties_supplier_country_id | Unknown |  |
| parties_supplier_country_iso_code | Unknown |  |
| parties_supplier_country_iso_code_3 | Unknown |  |
| parties_supplier_email | Unknown |  |
| parties_supplier_mobile_telephone | Unknown |  |
| parties_supplier_postal_code | Unknown |  |
| parties_supplier_telephone | Unknown |  |
| placed_on | Unknown |  |
| price_list_id | Unknown |  |
| price_mode_code | Unknown |  |
| reference | Unknown |  |
| shipping_status_code | Unknown |  |
| state_tax | Unknown |  |
| stock_status_code | Unknown |  |
| tax_errors | Json |  |
| total_value | Unknown |  |
| total_value_base_net | Unknown |  |
| total_value_base_tax_amount | Unknown |  |
| total_value_base_total | Unknown |  |
| total_value_net | Unknown |  |
| total_value_tax_amount | Unknown |  |
| updated_on | Unknown |  |
| version | Unknown |  |
| parties_delivery_** |  |  |

### good_in_note_detail_moved

| Column | Type | Keys |
| --- | --- | --- |
| goods_in_note_detail_id | Unknown | PK, FK |
| order_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| warehouse_id | Unknown | FK |
| allocated | Unknown |  |
| batch_goods_note_id | Unknown |  |
| cleared | Unknown |  |
| created_by | Unknown |  |
| created_on | Unknown |  |
| destination_location_id | Unknown |  |
| product_value | Unknown |  |
| product_value_currency | Unknown |  |
| purchase_order_row_id | Unknown |  |
| quantity | Unknown |  |
| quarantine | Unknown |  |
| updated_by | Unknown |  |
| updated_on | Unknown |  |
| value_confirmed | Unknown |  |

### good_in_note_detail

| Column | Type | Keys |
| --- | --- | --- |
| goods_note_id | Unknown | PK, FK |
| order_id | Unknown | PK, FK |
| created_by | Unknown |  |
| goods_note_status | Unknown |  |
| received_on | Unknown |  |
| transfer | Unknown |  |
| user_batch_reference | Unknown |  |

### journal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_by_contact_id | Unknown | FK |
| created_on | Instant |  |
| currency_id | Unknown |  |
| due_date | Unknown |  |
| exchange_rate | Unknown |  |
| journal_date | Unknown |  |
| journal_type_code | Unknown |  |
| tax_date | Unknown |  |
| tax_reconciliation_date | Unknown |  |
| tax_reconciliation_tax_period_id | Unknown |  |

### journal_transaction

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| journal_id | Unknown | PK, FK |
| nominal_code | Unknown | FK |
| order_id | Unknown | FK |
| tax_code | Unknown | FK |
| channel_id | Unknown |  |
| invoice_reference | Unknown |  |
| lead_source_id | Unknown |  |
| project_id | Unknown |  |
| transaction_amount | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### contact_detail_status_history

| Column | Type | Keys |
| --- | --- | --- |
| contact_status_id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| contact_status_name | Unknown |  |
| occured_on | Unknown |  |
| staff_contact_id | Unknown |  |

### contact_detail

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| assignment_current_contact_group_id | Unknown | FK |
| company_id | Unknown | FK |
| assignment_current_department_id | Unknown |  |
| assignment_current_lead_source_id | Unknown |  |
| assignment_current_staff_owner_contact_id | Unknown |  |
| communication_messaging_voips_skp | Unknown |  |
| communication_primary_email | Unknown |  |
| communication_secondary_email | Unknown |  |
| communication_telephone_fax | Unknown |  |
| communication_telephone_mobile | Unknown |  |
| communication_telephone_primary | Unknown |  |
| communication_telephone_secondary | Unknown |  |
| communication_tertiary_email | Unknown |  |
| communication_website_primary | Unknown |  |
| contact_tag | Unknown |  |
| created_by_id | Unknown |  |
| created_on | Unknown |  |
| current_contact_status_id | Unknown |  |
| current_contact_status_name | Unknown |  |
| financial_detail_credit_limit | Unknown |  |
| financial_detail_credit_term_days | Unknown |  |
| financial_detail_credit_term_type_id | Unknown |  |
| financial_detail_currency_id | Unknown |  |
| financial_detail_discount_percentage | Unknown |  |
| financial_detail_nominal_code | Unknown |  |
| financial_detail_price_list_id | Unknown |  |
| financial_detail_tax_code_id | Unknown |  |
| financial_detail_tax_number | Unknown |  |
| first_name | Unknown |  |
| is_primary_contact | Unknown |  |
| last_contacted_on | Unknown |  |
| last_name | Unknown |  |
| marketing_is_receive_email_newsletter | Unknown |  |
| organisation_id | Unknown |  |
| organisation_job_title | Unknown |  |
| organisation_name | Unknown |  |
| relationship_to_account_is_staff | Unknown |  |
| relationship_to_account_is_supplier | Unknown |  |
| salutation | Unknown |  |
| trade_status | Unknown |  |
| updated_on | Unknown |  |
| aliases_** |  |  |
| post_address_id_** |  |  |

## Relationships

- good_out_note_detail_event(order_id) → goods_out_note_detail(order_id)
- good_out_note_detail_event(goods_out_note_id) → goods_out_note_detail(goods_out_note_id)
- goods_out_note_detail(warehouse_id) → warehouse(id)
- goods_out_note_detail(goods_out_note_id) → goods_out_note_detail(goods_out_note_id)
- warehouse_weekly_operating_period(warehouse_id) → warehouse(id)
- warehouse_external_transfer_sla(external_transfer_sla_warehouse_id) → warehouse(id)
- warehouse_external_transfer_sla(warehouse_id) → warehouse(id)
- contact_group_detail(contact_group_id) → contact_group(id)
- product_detail_season(product_id) → product_detail(product_id)
- product_detail_warehouse(warehouse_id) → warehouse(id)
- product_detail_warehouse(product_id) → product_detail(product_id)
- product_detail_variation(product_id) → product_detail(product_id)
- product_detail_sales_channel_category(product_id) → product_detail_sales_channel(product_id)
- product_detail_sales_channel_category(product_sales_channel_index) → product_detail_sales_channel(index)
- product_detail_sales_channel(product_id) → product_detail(product_id)
- product_detail(product_id) → product(id)
- order_detail_invoice(order_id) → order_detail(id)
- order_detail_tax_error(order_id) → order_detail(id)
- order_detail(parent_order_id) → order_detail(id)
- order_detail(warehouse_id) → warehouse(id)
- order_detail(parties_customer_contact_id) → contact(id)
- order_detail(parties_billing_contact_id) → contact(id)
- order_detail(parties_supplier_contact_id) → contact(id)
- good_in_note_detail_moved(product_id) → product(id)
- good_in_note_detail_moved(warehouse_id) → warehouse(id)
- good_in_note_detail_moved(order_id) → good_in_note_detail(order_id)
- good_in_note_detail_moved(goods_in_note_detail_id) → good_in_note_detail(goods_note_id)
- good_in_note_detail(order_id) → order_detail(id)
- good_in_note_detail(goods_note_id) → goods_in_note(purchase_order_id)
- journal(created_by_contact_id) → contact(id)
- journal(contact_id) → contact(id)
- journal_transaction(journal_id) → journal(id)
- journal_transaction(nominal_code) → nominal_code(id)
- journal_transaction(order_id) → order_detail(id)
- journal_transaction(tax_code) → tax_code(id)
- contact_detail_status_history(contact_id) → contact_detail(contact_id)
- contact_detail(company_id) → company(id)
- contact_detail(contact_id) → contact(id)
- contact_detail(assignment_current_contact_group_id) → contact_group(id)