Fivetran documentation

Search the docs

/

Microsoft Dynamics 365 Business Central

Explore the interactive ERD

Table & Field Reference

sales_line

Column	Type	Keys
`system_id`	String	PK
`blanket_order_no`	String	FK
`company_id`	String	FK
`description`	String	FK
`dimension_set_id`	String	FK
`originally_ordered_no`	String	FK
`originally_ordered_var_code`	String	FK
`purch_order_line_no`	String	FK
`purchase_order_no`	String	FK
`shortcut_dimension_1_code`	String	FK
`amount`	Double
`line_no`	Long
`no`	String
`quantity`	Double
`variant_code`	String

company_information

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`address`	String
`city`	String
`country_region_code`	String
`e_mail`	String
`iban`	String
`name`	String
`phone_no`	String
`post_code`	String

vendor

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`global_dimension_1_code`	String	FK
`payment_method_id`	String	FK
`payment_terms_id`	String	FK
`address`	String
`balance`	Double
`blocked`	String
`name`	String
`no`	String
`purchases_lcy`	Double
`vendor_posting_group`	String

currency

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`code`	String
`description`	String
`iso_code`	String
`symbol`	String

item_category

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`code`	String
`description`	String
`has_children`	Boolean
`parent_category`	String

posted_general_journal_line

Column	Type	Keys
`system_id`	String	PK
`account_id`	String	FK
`applies_to_invoice_id`	String	FK
`company_id`	String	FK
`customer_id`	String	FK
`dimension_set_id`	String	FK
`journal_batch_id`	String	FK
`journal_batch_name`	String	FK
`journal_template_name`	String	FK
`payment_method_id`	String	FK
`shortcut_dimension_1_code`	String	FK
`amount`	Double
`credit_amount`	Double
`debit_amount`	Double
`line_no`	Long

sales_shipment_header

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`dimension_set_id`	String	FK
`shortcut_dimension_1_code`	String	FK
`no`	String
`order_no`	String

sales_shipment_line

Column	Type	Keys
`system_id`	String	PK
`blanket_order_line_no`	String	FK
`blanket_order_no`	String	FK
`company_id`	String	FK
`dimension_set_id`	String	FK
`no`	String	FK
`shortcut_dimension_1_code`	String	FK
`variant_code`	String	FK
`line_no`	Long
`quantity`	Double

dimension

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`blocked`	Boolean
`code`	String
`description`	String
`name`	String

purchase_invoice_line

Column	Type	Keys
`system_id`	String	PK
`blanket_order_line_no`	String	FK
`blanket_order_no`	String	FK
`company_id`	String	FK
`dimension_set_id`	String	FK
`no`	String	FK
`shortcut_dimension_1_code`	String	FK
`variant_code`	String	FK
`amount`	Double
`line_no`	Long
`quantity`	Double

opportunity

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`contact_no`	String	FK
`sales_document_no`	String	FK
`campaign_no`	String
`closed`	Boolean
`description`	String
`no`	String
`probability`	Double
`salesperson_code`	String
`status`	String

sales_credit_memo_line

Column	Type	Keys
`system_id`	String	PK
`blanket_order_line_no`	String	FK
`blanket_order_no`	String	FK
`company_id`	String	FK
`dimension_set_id`	String	FK
`no`	String	FK
`shortcut_dimension_1_code`	String	FK
`variant_code`	String	FK
`amount`	Double
`line_no`	Long
`quantity`	Double

general_product_posting_group

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`code`	String
`def_vatprod_posting_group`	String
`description`	String

contact

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`address`	String
`city`	String
`company_name`	String
`company_no`	String
`e_mail`	String
`first_name`	String
`last_date_modified`	LocalDate
`mobile_phone_no`	String
`name`	String
`no`	String
`phone_no`	String
`salesperson_code`	String
`surname`	String
`type`	String

payment_method

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`bal_account_no`	String
`bal_account_type`	String
`code`	String
`description`	String
`direct_debit`	Boolean

country_region

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`code`	String
`iso_code`	String
`iso_numeric_code`	String
`name`	String

sales_header

Column	Type	Keys
`system_id`	String	PK
`bill_to_name`	String	FK
`company_id`	String	FK
`dimension_set_id`	String	FK
`opportunity_no`	String	FK
`sell_to_contact_no`	String	FK
`shortcut_dimension_1_code`	String	FK
`amount`	Double
`amount_including_vat`	Double
`due_date`	LocalDate
`no`	String
`order_date`	LocalDate
`status`	String

currency_exchange_rate

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`exchange_rate_amount`	Double
`relational_currency_code`	String
`starting_date`	LocalDate

bank_account

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`global_dimension_1_code`	String	FK
`balance`	Double
`iban`	String
`name`	String
`no`	String
`swift_code`	String

general_ledger_account

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`global_dimension_1_code`	String	FK
`account_category`	String
`account_type`	String
`balance`	Double
`blocked`	Boolean
`credit_amount`	Double
`debit_amount`	Double
`name`	String
`net_change`	Double
`no`	String

default_dimension

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`dimension_code`	String	FK
`dimension_id`	String	FK
`dimension_value_code`	String	FK
`parent_id`	String	FK
`parent_type`	String
`value_posting`	String

subscription

Column	Type	Keys
`subscription_id`	String	PK
`_odata_etag`	String
`client_state`	String
`expiration_date_time`	Instant
`last_modified_date_time`	Instant
`notification_url`	String
`resource`	String
`system_created_at`	Instant
`system_created_by`	String
`system_modified_at`	Instant
`system_modified_by`	String
`user_id`	String

job

Column	Type	Keys
`system_id`	String	PK
`bill_to_name`	String	FK
`company_id`	String	FK
`global_dimension_1_code`	String	FK
`creation_date`	LocalDate
`description`	String
`ending_date`	LocalDate
`no`	String
`person_responsible`	String
`project_manager`	String
`starting_date`	LocalDate
`status`	String

sales_invoice_header

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`dimension_set_id`	String	FK
`shortcut_dimension_1_code`	String	FK
`amount`	Double
`amount_including_vat`	Double
`due_date`	LocalDate
`no`	String
`order_no`	String

purchase_receipt_header

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`dimension_set_id`	String	FK
`shortcut_dimension_1_code`	String	FK
`no`	String
`order_no`	String

item_variant

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`item_id`	String	FK
`blocked`	Boolean
`code`	String
`description`	String
`item_no`	String

payment_term

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`code`	String
`description`	String
`discount`	Double
`due_date_calculation`	String

employee

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`global_dimension_1_code`	String	FK
`address`	String
`birth_date`	LocalDate
`company_email`	String
`employment_date`	LocalDate
`first_name`	String
`last_name`	String
`manager_no`	String
`no`	String
`status`	String
`termination_date`	LocalDate

item

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`gen_prod_posting_group_id`	String	FK
`global_dimension_1_code`	String	FK
`item_category_id`	String	FK
`no`	String	FK
`unit_of_measure_id`	String	FK
`variant_filter`	String	FK
`description`	String
`inventory`	Double
`item_category_code`	String
`standard_cost`	Double
`type`	String
`vendor_no`	String

customer

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`currency_id`	String	FK
`global_dimension_1_code`	String	FK
`payment_method_id`	String	FK
`payment_terms_id`	String	FK
`shipment_method_id`	String	FK
`address`	String
`balance`	Double
`blocked`	String
`credit_limit_lcy`	Double
`name`	String
`no`	String
`sales_lcy`	Double

company

Column	Type	Keys
`id`	String	PK
`business_profile_id`	String
`display_name`	String
`name`	String
`system_created_at`	Instant
`system_created_by`	String
`system_modified_at`	Instant
`system_modified_by`	String
`system_version`	String

reason_code

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`code`	String
`description`	String

purchase_line

Column	Type	Keys
`system_id`	String	PK
`blanket_order_no`	String	FK
`company_id`	String	FK
`description`	String	FK
`dimension_set_id`	String	FK
`no`	String	FK
`sales_order_line_no`	String	FK
`sales_order_no`	String	FK
`shortcut_dimension_1_code`	String	FK
`variant_code`	String	FK
`amount`	Double
`line_no`	Long
`quantity`	Double

general_journal_line

Column	Type	Keys
`system_id`	String	PK
`account_id`	String	FK
`company_id`	String	FK
`customer_id`	String	FK
`dimension_set_id`	String	FK
`journal_batch_id`	String	FK
`payment_method_id`	String	FK
`shortcut_dimension_1_code`	String	FK
`vendor_id`	String	FK
`account_no`	String
`account_type`	String
`amount`	Double
`credit_amount`	Double
`debit_amount`	Double
`line_no`	Long

inventory_posting_group

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`code`	String
`description`	String

purchase_header

Column	Type	Keys
`system_id`	String	PK
`buy_from_vendor_name`	String	FK
`company_id`	String	FK
`dimension_set_id`	String	FK
`shortcut_dimension_1_code`	String	FK
`amount`	Double
`amount_including_vat`	Double
`due_date`	LocalDate
`no`	String
`order_date`	LocalDate
`status`	String

location

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`address`	String
`city`	String
`code`	String
`contact`	String
`country_region_code`	String
`name`	String
`require_receive`	Boolean
`require_shipment`	Boolean

purchase_receipt_line

Column	Type	Keys
`system_id`	String	PK
`blanket_order_line_no`	String	FK
`blanket_order_no`	String	FK
`company_id`	String	FK
`dimension_set_id`	String	FK
`no`	String	FK
`shortcut_dimension_1_code`	String	FK
`variant_code`	String	FK
`line_no`	Long
`quantity`	Double

general_ledger_entry

Column	Type	Keys
`system_id`	String	PK
`account_id`	String	FK
`company_id`	String	FK
`dimension_set_id`	String	FK
`global_dimension_1_code`	String	FK
`amount`	Double
`credit_amount`	Double
`debit_amount`	Double
`description`	String
`entry_no`	Long
`g_laccount_no`	String

sales_invoice_line

Column	Type	Keys
`system_id`	String	PK
`blanket_order_line_no`	String	FK
`blanket_order_no`	String	FK
`company_id`	String	FK
`dimension_set_id`	String	FK
`no`	String	FK
`shortcut_dimension_1_code`	String	FK
`variant_code`	String	FK
`amount`	Double
`line_no`	Long
`quantity`	Double

dimension_value

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`dimension_id`	String	FK
`blocked`	Boolean
`code`	String
`dimension_code`	String
`dimension_value_id`	String
`dimension_value_type`	String
`name`	String

posted_general_journal_batch

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`description`	String
`journal_template_name`	String
`name`	String
`no_series`	String
`reason_code`	String

time_sheet_detail

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`job_id`	String	FK
`date`	LocalDate
`job_no`	String
`job_task_no`	String
`quantity`	Double
`resource_no`	String
`status`	String
`type`	String

purchase_invoice_header

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`dimension_set_id`	String	FK
`shortcut_dimension_1_code`	String	FK
`amount`	Double
`amount_including_vat`	Double
`due_date`	LocalDate
`no`	String
`order_no`	String

dimension_set_entity

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`dimension_code`	String	FK
`dimension_value_code`	String	FK
`dimension_name`	String
`dimension_set_id`	String
`dimension_value_id`	String
`dimension_value_name`	String
`global_dimension_no`	Long

sales_credit_memo_header

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`dimension_set_id`	String	FK
`shortcut_dimension_1_code`	String	FK
`amount`	Double
`amount_including_vat`	Double
`no`	String

shipment_method

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`code`	String
`description`	String

unit_of_measure

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`code`	String
`description`	String
`international_standard_code`	String
`symbol`	String

general_journal_batch

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`description`	String
`journal_template_name`	String
`name`	String
`no_series`	String
`reason_code`	String

item_ledger_entry

Column	Type	Keys
`system_id`	String	PK
`company_id`	String	FK
`dimension_set_id`	String	FK
`global_dimension_1_code`	String	FK
`job_no`	String	FK
`originally_ordered_no`	String	FK
`originally_ordered_var_code`	String	FK
`entry_no`	Long
`entry_type`	String
`item_no`	String
`quantity`	Double
`variant_code`	String