# Microsoft Dynamics 365 Business Central schema ERD

Table and field reference for the Fivetran Microsoft Dynamics 365 Business Central connector.

## 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 |  |

## Relationships

- sales_line(company_id) → company(id)
- sales_line(blanket_order_no) → sales_header(no)
- sales_line(description) → general_ledger_account(name)
- sales_line(dimension_set_id) → dimension_set_entity(dimension_set_id)
- sales_line(originally_ordered_no) → item_variant(item_no)
- sales_line(originally_ordered_var_code) → item_variant(code)
- sales_line(purch_order_line_no) → purchase_line(line_no)
- sales_line(purchase_order_no) → purchase_header(no)
- sales_line(shortcut_dimension_1_code) → dimension_value(code)
- company_information(company_id) → company(id)
- vendor(company_id) → company(id)
- vendor(currency_id) → currency(system_id)
- vendor(global_dimension_1_code) → dimension_value(code)
- vendor(payment_method_id) → payment_method(system_id)
- vendor(payment_terms_id) → payment_term(system_id)
- currency(company_id) → company(id)
- item_category(company_id) → company(id)
- posted_general_journal_line(company_id) → company(id)
- posted_general_journal_line(account_id) → general_ledger_account(system_id)
- posted_general_journal_line(applies_to_invoice_id) → sales_invoice_header(system_id)
- posted_general_journal_line(customer_id) → customer(system_id)
- posted_general_journal_line(dimension_set_id) → dimension_set_entity(dimension_set_id)
- posted_general_journal_line(journal_batch_id) → general_journal_batch(system_id)
- posted_general_journal_line(journal_batch_name) → posted_general_journal_batch(name)
- posted_general_journal_line(journal_template_name) → posted_general_journal_batch(journal_template_name)
- posted_general_journal_line(payment_method_id) → payment_method(system_id)
- posted_general_journal_line(shortcut_dimension_1_code) → dimension_value(code)
- sales_shipment_header(company_id) → company(id)
- sales_shipment_header(dimension_set_id) → dimension_set_entity(dimension_set_id)
- sales_shipment_header(shortcut_dimension_1_code) → dimension_value(code)
- sales_shipment_line(company_id) → company(id)
- sales_shipment_line(blanket_order_line_no) → sales_line(line_no)
- sales_shipment_line(blanket_order_no) → sales_header(no)
- sales_shipment_line(dimension_set_id) → dimension_set_entity(dimension_set_id)
- sales_shipment_line(no) → item_variant(item_no)
- sales_shipment_line(shortcut_dimension_1_code) → dimension_value(code)
- sales_shipment_line(variant_code) → item_variant(code)
- dimension(company_id) → company(id)
- purchase_invoice_line(company_id) → company(id)
- purchase_invoice_line(blanket_order_line_no) → purchase_line(line_no)
- purchase_invoice_line(blanket_order_no) → purchase_header(no)
- purchase_invoice_line(dimension_set_id) → dimension_set_entity(dimension_set_id)
- purchase_invoice_line(no) → item_variant(item_no)
- purchase_invoice_line(shortcut_dimension_1_code) → dimension_value(code)
- purchase_invoice_line(variant_code) → item_variant(code)
- opportunity(company_id) → company(id)
- opportunity(contact_no) → sales_header(sell_to_contact_no)
- opportunity(sales_document_no) → sales_header(no)
- sales_credit_memo_line(company_id) → company(id)
- sales_credit_memo_line(blanket_order_line_no) → sales_line(line_no)
- sales_credit_memo_line(blanket_order_no) → sales_header(no)
- sales_credit_memo_line(dimension_set_id) → dimension_set_entity(dimension_set_id)
- sales_credit_memo_line(no) → item_variant(item_no)
- sales_credit_memo_line(shortcut_dimension_1_code) → dimension_value(code)
- sales_credit_memo_line(variant_code) → item_variant(code)
- general_product_posting_group(company_id) → company(id)
- contact(company_id) → company(id)
- payment_method(company_id) → company(id)
- country_region(company_id) → company(id)
- sales_header(company_id) → company(id)
- sales_header(bill_to_name) → customer(name)
- sales_header(dimension_set_id) → dimension_set_entity(dimension_set_id)
- sales_header(opportunity_no) → opportunity(no)
- sales_header(sell_to_contact_no) → opportunity(contact_no)
- sales_header(shortcut_dimension_1_code) → dimension_value(code)
- currency_exchange_rate(company_id) → company(id)
- bank_account(company_id) → company(id)
- bank_account(global_dimension_1_code) → dimension_value(code)
- general_ledger_account(company_id) → company(id)
- general_ledger_account(global_dimension_1_code) → dimension_value(code)
- default_dimension(company_id) → company(id)
- default_dimension(dimension_code) → dimension_value(dimension_code)
- default_dimension(dimension_id) → dimension(system_id)
- default_dimension(dimension_value_code) → dimension_value(code)
- default_dimension(parent_id) → general_ledger_account(system_id)
- job(company_id) → company(id)
- job(bill_to_name) → customer(name)
- job(global_dimension_1_code) → dimension_value(code)
- sales_invoice_header(company_id) → company(id)
- sales_invoice_header(dimension_set_id) → dimension_set_entity(dimension_set_id)
- sales_invoice_header(shortcut_dimension_1_code) → dimension_value(code)
- purchase_receipt_header(company_id) → company(id)
- purchase_receipt_header(dimension_set_id) → dimension_set_entity(dimension_set_id)
- purchase_receipt_header(shortcut_dimension_1_code) → dimension_value(code)
- item_variant(company_id) → company(id)
- item_variant(item_id) → item(system_id)
- payment_term(company_id) → company(id)
- employee(company_id) → company(id)
- employee(global_dimension_1_code) → dimension_value(code)
- item(company_id) → company(id)
- item(gen_prod_posting_group_id) → general_product_posting_group(system_id)
- item(global_dimension_1_code) → dimension_value(code)
- item(item_category_id) → item_category(system_id)
- item(no) → item_variant(item_no)
- item(unit_of_measure_id) → unit_of_measure(system_id)
- item(variant_filter) → item_variant(code)
- customer(company_id) → company(id)
- customer(currency_id) → currency(system_id)
- customer(global_dimension_1_code) → dimension_value(code)
- customer(payment_method_id) → payment_method(system_id)
- customer(payment_terms_id) → payment_term(system_id)
- customer(shipment_method_id) → shipment_method(system_id)
- reason_code(company_id) → company(id)
- purchase_line(company_id) → company(id)
- purchase_line(blanket_order_no) → purchase_header(no)
- purchase_line(description) → general_ledger_account(name)
- purchase_line(dimension_set_id) → dimension_set_entity(dimension_set_id)
- purchase_line(no) → item_variant(code)
- purchase_line(sales_order_line_no) → sales_line(line_no)
- purchase_line(sales_order_no) → sales_header(no)
- purchase_line(shortcut_dimension_1_code) → dimension_value(code)
- purchase_line(variant_code) → item_variant(code)
- general_journal_line(company_id) → company(id)
- general_journal_line(account_id) → general_ledger_account(system_id)
- general_journal_line(customer_id) → customer(system_id)
- general_journal_line(dimension_set_id) → dimension_set_entity(dimension_set_id)
- general_journal_line(journal_batch_id) → general_journal_batch(system_id)
- general_journal_line(payment_method_id) → payment_method(system_id)
- general_journal_line(shortcut_dimension_1_code) → dimension_value(code)
- general_journal_line(vendor_id) → vendor(system_id)
- inventory_posting_group(company_id) → company(id)
- purchase_header(company_id) → company(id)
- purchase_header(buy_from_vendor_name) → vendor(name)
- purchase_header(dimension_set_id) → dimension_set_entity(dimension_set_id)
- purchase_header(shortcut_dimension_1_code) → dimension_value(code)
- location(company_id) → company(id)
- purchase_receipt_line(company_id) → company(id)
- purchase_receipt_line(blanket_order_line_no) → purchase_line(line_no)
- purchase_receipt_line(blanket_order_no) → purchase_header(no)
- purchase_receipt_line(dimension_set_id) → dimension_set_entity(dimension_set_id)
- purchase_receipt_line(no) → item_variant(item_no)
- purchase_receipt_line(shortcut_dimension_1_code) → dimension_value(code)
- purchase_receipt_line(variant_code) → item_variant(code)
- general_ledger_entry(company_id) → company(id)
- general_ledger_entry(account_id) → general_ledger_account(system_id)
- general_ledger_entry(dimension_set_id) → dimension_set_entity(dimension_set_id)
- general_ledger_entry(global_dimension_1_code) → dimension_value(code)
- sales_invoice_line(company_id) → company(id)
- sales_invoice_line(blanket_order_line_no) → sales_line(line_no)
- sales_invoice_line(blanket_order_no) → sales_header(no)
- sales_invoice_line(dimension_set_id) → dimension_set_entity(dimension_set_id)
- sales_invoice_line(no) → item_variant(item_no)
- sales_invoice_line(shortcut_dimension_1_code) → dimension_value(code)
- sales_invoice_line(variant_code) → item_variant(code)
- dimension_value(company_id) → company(id)
- dimension_value(dimension_id) → dimension(system_id)
- posted_general_journal_batch(company_id) → company(id)
- time_sheet_detail(company_id) → company(id)
- time_sheet_detail(job_id) → job(system_id)
- purchase_invoice_header(company_id) → company(id)
- purchase_invoice_header(dimension_set_id) → dimension_set_entity(dimension_set_id)
- purchase_invoice_header(shortcut_dimension_1_code) → dimension_value(code)
- dimension_set_entity(company_id) → company(id)
- dimension_set_entity(dimension_code) → dimension_value(code)
- dimension_set_entity(dimension_value_code) → dimension_value(dimension_code)
- sales_credit_memo_header(company_id) → company(id)
- sales_credit_memo_header(dimension_set_id) → dimension_set_entity(dimension_set_id)
- sales_credit_memo_header(shortcut_dimension_1_code) → dimension_value(code)
- shipment_method(company_id) → company(id)
- unit_of_measure(company_id) → company(id)
- general_journal_batch(company_id) → company(id)
- item_ledger_entry(company_id) → company(id)
- item_ledger_entry(dimension_set_id) → dimension_set_entity(dimension_set_id)
- item_ledger_entry(global_dimension_1_code) → dimension_value(code)
- item_ledger_entry(job_no) → job(no)
- item_ledger_entry(originally_ordered_no) → item_variant(item_no)
- item_ledger_entry(originally_ordered_var_code) → item_variant(code)