Microsoft Business Central schema
92 tables
About the connector
Start free
Tables
Columns
92 tables
Expand all
Collapse all
account
11 columns
aged_accounts_payable
13 columns
aged_accounts_receivable
13 columns
balance_sheet
9 columns
bank_account
5 columns
cash_flow_statement
9 columns
company
10 columns
company_information
19 columns
contact
23 columns
country_region
6 columns
currency
9 columns
currency_exchange_rate
9 columns
customer_financial_detail
7 columns
customer_payment_journal
8 columns
customer_payment
17 columns
customer_return_reason
5 columns
customer_sale
6 columns
customer
31 columns
customer_contact_information
7 columns
default_dimension
10 columns
dimension_value
7 columns
dimension
6 columns
dispute_status
5 columns
employee
25 columns
time_registration_entries
16 columns
time_registration_entry_dimension_set_lines
11 columns
fixed_asset
15 columns
fixed_asset_location
6 columns
general_ledger_entry
13 columns
general_ledger_entry_dimension_set_line
11 columns
general_product_posting_group
8 columns
income_statement
9 columns
inventory_posting_group
6 columns
item_category
6 columns
item_ledger_entry
21 columns
item_variant
7 columns
item
19 columns
journal
8 columns
journal_lines
16 columns
journal_line_dimension_set_lines
11 columns
location
15 columns
opportunity
20 columns
payment_method
6 columns
payment_term
10 columns
project
5 columns
purchase_credit_memo
43 columns
purchase_credit_memo_line
29 columns
purchase_credit_memo_line_dimension_set_lines
11 columns
purchase_credit_memo_dimension_set_lines
11 columns
purchase_invoice
45 columns
purchase_invoice_lines
29 columns
purchase_invoice_line_dimension_set_lines
11 columns
purchase_invoice_dimension_set_lines
11 columns
purchase_order
47 columns
purchase_order_lines
33 columns
purchase_order_line_dimension_set_lines
11 columns
purchase_order_dimension_set_lines
11 columns
purchase_receipt
34 columns
purchase_receipt_lines
15 columns
purchase_receipt_line_dimension_set_lines
11 columns
purchase_receipt_dimension_set_lines
11 columns
retained_earnings_statement
9 columns
sales_credit_memo
44 columns
sales_credit_memo_lines
29 columns
sales_credit_memo_line_dimension_set_lines
11 columns
sales_credit_memo_dimension_set_lines
11 columns
sales_invoice
53 columns
sales_invoice_lines
30 columns
sales_invoice_line_dimension_set_lines
11 columns
sales_invoice_dimension_set_lines
11 columns
sales_order
51 columns
sales_order_lines
34 columns
sales_order_line_dimension_set_lines
11 columns
sales_order_dimension_set_lines
11 columns
sales_quote
50 columns
sales_quote_lines
28 columns
sales_quote_line_dimension_set_lines
11 columns
sales_quote_dimension_set_lines
11 columns
sales_shipment
42 columns
sales_shipment_lines
16 columns
sales_shipment_line_dimension_set_lines
11 columns
sales_shipment_dimension_set_lines
11 columns
shipment_method
6 columns
subscription
12 columns
tax_area
7 columns
tax_group
7 columns
trial_balance
11 columns
unit_of_measure
8 columns
vendor_payment
17 columns
vendor_payment_journal
8 columns
vendor_purchase
7 columns
vendor
24 columns
Select a table to see its columns
