Brightpearl

Explore the interactive ERD

Table & Field Reference

good_out_note_detail_event

Column	Type	Keys
`event_code`	Unknown	PK
`goods_out_note_id`	Unknown	PKFK
`order_id`	Unknown	PKFK
`event_owner_id`	Unknown
`occured`	Unknown

goods_out_note_detail

Column	Type	Keys
`order_id`	Unknown	PK
`goods_out_note_id`	Unknown	PKFK
`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	PKFK
`closing_hours`	Unknown
`day_of_week`	Unknown
`opening_hours`	Unknown

warehouse_external_transfer_sla

Column	Type	Keys
`external_transfer_sla_warehouse_id`	Unknown	PKFK
`warehouse_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`season_id`	Unknown

product_detail_warehouse

Column	Type	Keys
`product_id`	Unknown	PKFK
`warehouse_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`product_sales_channel_index`	Unknown	PKFK

product_detail_sales_channel

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`order_id`	Unknown	PKFK
`product_id`	Unknown	PKFK
`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	PKFK
`order_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`contact_status_name`	Unknown
`occured_on`	Unknown
`staff_contact_id`	Unknown

contact_detail

Column	Type	Keys
`contact_id`	Unknown	PKFK
`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_`