# e-conomic schema ERD

Table and field reference for the Fivetran e-conomic connector.

## Table & Field Reference

### customer_template_invoice

| Column | Type | Keys |
| --- | --- | --- |
| customer_number | Unknown | PK, FK |
| delivery_location_number | Unknown | FK |
| currency | Unknown |  |
| date | Unknown |  |
| due_date | Unknown |  |
| exchange_rate | Unknown |  |
| recipientcustomer_contact_number | Unknown |  |
| recipientself | Unknown |  |
| referencescustomer_contact_number | Unknown |  |
| referencesself | Unknown |  |

### app_setting_user

| Column | Type | Keys |
| --- | --- | --- |
| setting_key | Unknown | PK |
| content | Unknown |  |
| self | Unknown |  |

### app_setting_agreement

| Column | Type | Keys |
| --- | --- | --- |
| setting_key | Unknown | PK, FK |
| content | Unknown |  |
| self | Unknown |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| employee_number | Unknown | PK |
| barred | Unknown |  |
| booked_invoices | Unknown |  |
| customers | Unknown |  |
| draft_invoices | Unknown |  |
| email | Unknown |  |
| group_number | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| self | Unknown |  |

### accounting_year_period

| Column | Type | Keys |
| --- | --- | --- |
| period_number | Unknown | PK |
| closed | Unknown |  |
| entries | Unknown |  |
| from_date | Unknown |  |
| self | Unknown |  |
| to_date | Unknown |  |
| totals | Unknown |  |
| year | Unknown |  |

### required_module

| Column | Type | Keys |
| --- | --- | --- |
| module_number | Unknown | PK |
| app_role_role_number | Unknown | PK, FK |
| self | Unknown |  |

### app_role

| Column | Type | Keys |
| --- | --- | --- |
| role_number | Unknown | PK |
| name | Unknown |  |

### journal_entry

| Column | Type | Keys |
| --- | --- | --- |
| journal_entry_number | Unknown | PK |
| journal_number | Unknown | PK, FK |
| account_number | Unknown | FK |
| customer_number | Unknown | FK |
| departmental_distribution_number | Unknown | FK |
| employee_number | Unknown | FK |
| payment_type_number | Unknown | FK |
| supplier_number | Unknown | FK |
| unit_1_number | Unknown | FK |
| unit_2_number | Unknown | FK |
| voucher_accounting_year | Unknown | FK |
| amount | Unknown |  |
| amount_default_currency | Unknown |  |
| contra_vat_account_code | Unknown |  |
| contra_vat_account_self | Unknown |  |
| contra_vat_amount | Unknown |  |
| contra_vat_amount_in_base_currency | Unknown |  |
| cost_type_number | Unknown |  |
| cost_type_self | Unknown |  |
| currency_code | Unknown |  |
| currency_self | Unknown |  |
| customer_invoice | Unknown |  |
| date | LocalDate |  |
| due_date | LocalDate |  |
| entry_type | Unknown |  |
| exchange_rate | Unknown |  |
| project_number | Unknown |  |
| project_self | Unknown |  |
| quantity_1 | Unknown |  |
| quantity_2 | Unknown |  |
| remainder | Unknown |  |
| remainder_in_default_currency | Unknown |  |
| self | Unknown |  |
| supplier_invoice_number | Unknown |  |
| template_account | Unknown |  |
| template_account_and_contra_account | Unknown |  |
| template_contra_account | Unknown |  |
| template_contra_payment | Unknown |  |
| text | Unknown |  |
| voucher_number | Unknown |  |
| voucher_self | Unknown |  |

### journal

| Column | Type | Keys |
| --- | --- | --- |
| journal_number | Unknown | PK |
| entries | Unknown |  |
| maximum_voucher_number | Unknown |  |
| minimum_voucher_number | Unknown |  |
| name | Unknown |  |
| self | Unknown |  |
| vouchers | Unknown |  |

### journal_customer_invoice

| Column | Type | Keys |
| --- | --- | --- |
| customer_number | Unknown | PK, FK |
| journal_journal_number | Unknown | PK, FK |
| self | Unknown |  |

### accounting_year

| Column | Type | Keys |
| --- | --- | --- |
| year | Unknown | PK |
| closed | Unknown |  |
| entries | Unknown |  |
| from_date | Unknown |  |
| periods | Unknown |  |
| self | Unknown |  |
| to_date | Unknown |  |
| totals | Unknown |  |
| vouchers | Unknown |  |

### supplier

| Column | Type | Keys |
| --- | --- | --- |
| supplier_number | Unknown | PK |
| layout_number | Unknown | FK |
| payment_terms_number | Unknown | FK |
| supplier_group_number | Unknown | FK |
| vat_zone_number | Unknown | FK |
| account_number | Unknown |  |
| address | Unknown |  |
| bank_account | Unknown |  |
| city | Unknown |  |
| contacts | Unknown |  |
| corporate_identification_number | Unknown |  |
| creditor_id | Unknown |  |
| currency | Unknown |  |
| default_invoice_text | Unknown |  |
| employee_number | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| self | Unknown |  |
| supplier_contact_number | Unknown |  |
| zip | Unknown |  |

### currency

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| iso_number | Unknown |  |
| name | Unknown |  |
| self | Unknown |  |

### product_group

| Column | Type | Keys |
| --- | --- | --- |
| product_group_number | Unknown | PK |
| account_number | Unknown | FK |
| name | Unknown |  |
| products | Unknown |  |
| sales_accounts | Unknown |  |
| self | Unknown |  |

### order_archived

| Column | Type | Keys |
| --- | --- | --- |
| order_number | Unknown | PK |
| customer_number | Unknown | FK |
| delivery_location_number | Unknown | FK |
| payment_terms_number | Unknown | FK |
| attentioncustomer_contact_number | Unknown |  |
| attentionself | Unknown |  |
| cost_price_in_base_currency | Unknown |  |
| currency | Unknown |  |
| date | Unknown |  |
| due_date | Unknown |  |
| exchange_rate | Unknown |  |
| gross_amount | Unknown |  |
| gross_amount_in_base_currency | Unknown |  |
| heading | Unknown |  |
| margin_in_base_currency | Unknown |  |
| margin_percentage | Unknown |  |
| net_amount | Unknown |  |
| net_amount_in_base_currency | Unknown |  |
| project_number | Unknown |  |
| recipient_address | Unknown |  |
| recipient_city | Unknown |  |
| recipient_country | Unknown |  |
| recipient_cvr | Unknown |  |
| recipient_ean | Unknown |  |
| recipient_name | Unknown |  |
| recipient_nem_handel_type | Unknown |  |
| recipient_public_entry_number | Unknown |  |
| recipient_zip | Unknown |  |
| referencescustomer_contact_number | Unknown |  |
| referencesself | Unknown |  |
| remainder | Unknown |  |
| remainder_in_base_currency | Unknown |  |
| rounding_amount | Unknown |  |
| sales_personemployee_number | Unknown |  |
| sales_personself | Unknown |  |
| self | Unknown |  |
| sent | Unknown |  |
| soapid | Unknown |  |
| text_line_1 | Unknown |  |
| text_line_2 | Unknown |  |
| vat_amount | Unknown |  |
| vendoremployee_number | Unknown |  |
| vendorself | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| product_number | Unknown | PK |
| departmental_distribution_number | Unknown | FK |
| product_group_number | Unknown | FK |
| unit_number | Unknown | FK |
| available | Unknown |  |
| bar_code | Unknown |  |
| barred | Unknown |  |
| cost_price | Unknown |  |
| distribution_type | Unknown |  |
| gross_weight | Unknown |  |
| in_stock | Unknown |  |
| invoices_booked | Unknown |  |
| invoices_drafts | Unknown |  |
| invoices_self | Unknown |  |
| last_updated | Unknown |  |
| name | Unknown |  |
| net_weight | Unknown |  |
| ordered_by_customers | Unknown |  |
| ordered_from_suppliers | Unknown |  |
| package_volume | Unknown |  |
| recommended_cost_price | Unknown |  |
| recommended_price | Unknown |  |
| sales_price | Unknown |  |
| self | Unknown |  |

### invoice_booked_line

| Column | Type | Keys |
| --- | --- | --- |
| line_number | Unknown | PK |
| booked_invoice_number | Unknown | PK, FK |
| departmental_distribution_number | Unknown | FK |
| product_number | Unknown | FK |
| unit_number | Unknown | FK |
| delivery_date | LocalDate |  |
| description | Unknown |  |
| discount_percentage | Unknown |  |
| quantity | Unknown |  |
| sort_key | Unknown |  |
| total_net_amount | Unknown |  |
| unit_cost_price | Unknown |  |
| unit_net_price | Unknown |  |
| vat_amount | Unknown |  |
| vat_rate | Unknown |  |

### invoice_booked

| Column | Type | Keys |
| --- | --- | --- |
| booked_invoice_number | Unknown | PK |
| customer_number | Unknown | FK |
| delivery_location_number | Unknown | FK |
| payment_terms_number | Unknown | FK |
| attentioncustomer_contact_number | Unknown |  |
| attentionself | Unknown |  |
| currency | Unknown |  |
| date | LocalDate |  |
| due_date | LocalDate |  |
| exchange_rate | Unknown |  |
| gross_amount | Unknown |  |
| gross_amount_in_base_currency | Unknown |  |
| heading | Unknown |  |
| net_amount | Unknown |  |
| net_amount_in_base_currency | Unknown |  |
| project_number | Unknown |  |
| recipient_address | Unknown |  |
| recipient_city | Unknown |  |
| recipient_country | Unknown |  |
| recipient_cvr | Unknown |  |
| recipient_ean | Unknown |  |
| recipient_name | Unknown |  |
| recipient_nem_handel_type | Unknown |  |
| recipient_public_entry_number | Unknown |  |
| recipient_zip | Unknown |  |
| referencescustomer_contact_number | Unknown |  |
| referencesself | Unknown |  |
| remainder | Unknown |  |
| remainder_in_base_currency | Unknown |  |
| rounding_amount | Unknown |  |
| sales_personemployee_number | Unknown |  |
| sales_personself | Unknown |  |
| self | Unknown |  |
| sent | Unknown |  |
| text_line_1 | Unknown |  |
| text_line_2 | Unknown |  |
| vat_amount | Unknown |  |
| vendoremployee_number | Unknown |  |
| vendorself | Unknown |  |

### payment_term

| Column | Type | Keys |
| --- | --- | --- |
| payment_terms_number | Unknown | PK |
| cardcustomer_number | Unknown |  |
| cardself | Unknown |  |
| days_of_credit | Unknown |  |
| name | Unknown |  |
| payment_terms_type | Unknown |  |
| percentage_for_prepaid_amount | Unknown |  |
| percentage_for_remainder_amount | Unknown |  |
| prepaidaccount_number | Unknown |  |
| prepaidself | Unknown |  |
| remainderaccount_number | Unknown |  |
| remainderself | Unknown |  |
| self | Unknown |  |

### customer_template_invoice_line

| Column | Type | Keys |
| --- | --- | --- |
| product_number | Unknown | PK |
| customer_number | Unknown | PK, FK |
| description | Unknown |  |
| self | Unknown |  |

### accounting_year_period_entry

| Column | Type | Keys |
| --- | --- | --- |
| entry_number | Unknown | PK |
| accounting_year_period_period_number | Unknown | PK, FK |
| accounting_year_year | Unknown | PK, FK |
| account_number | Unknown | FK |
| booked_invoice_number | Unknown | FK |
| departmental_distribution_number | Unknown | FK |
| payment_type_number | Unknown | FK |
| supplier_number | Unknown | FK |
| unit_1_number | Unknown | FK |
| unit_2_number | Unknown | FK |
| vat_code | Unknown | FK |
| amount | Unknown |  |
| amount_in_base_currency | Unknown |  |
| cost_type_number | Unknown |  |
| currency | Unknown |  |
| customer | Unknown |  |
| date | Unknown |  |
| due_date | Unknown |  |
| entry_type | Unknown |  |
| invoice_number | Unknown |  |
| project_number | Unknown |  |
| quantity_1 | Unknown |  |
| quantity_2 | Unknown |  |
| remainder | Unknown |  |
| remainder_in_base_currency | Unknown |  |
| self | Unknown |  |
| supplier_invoice_number | Unknown |  |
| text | Unknown |  |
| voucher_number | Unknown |  |

### invoice_draft

| Column | Type | Keys |
| --- | --- | --- |
| draft_invoice_number | Unknown | PK |
| customer_number | Unknown | FK |
| delivery_location_number | Unknown | FK |
| payment_terms_number | Unknown | FK |
| attentioncustomer_contact_number | Unknown |  |
| attentionself | Unknown |  |
| cost_price_in_base_currency | Unknown |  |
| currency | Unknown |  |
| date | Unknown |  |
| due_date | Unknown |  |
| exchange_rate | Unknown |  |
| gross_amount | Unknown |  |
| gross_amount_in_base_currency | Unknown |  |
| heading | Unknown |  |
| margin_in_base_currency | Unknown |  |
| margin_percentage | Unknown |  |
| net_amount | Unknown |  |
| net_amount_in_base_currency | Unknown |  |
| project_number | Unknown |  |
| recipient_address | Unknown |  |
| recipient_city | Unknown |  |
| recipient_country | Unknown |  |
| recipient_cvr | Unknown |  |
| recipient_ean | Unknown |  |
| recipient_name | Unknown |  |
| recipient_nem_handel_type | Unknown |  |
| recipient_public_entry_number | Unknown |  |
| recipient_zip | Unknown |  |
| referencescustomer_contact_number | Unknown |  |
| referencesself | Unknown |  |
| remainder | Unknown |  |
| remainder_in_base_currency | Unknown |  |
| rounding_amount | Unknown |  |
| sales_personemployee_number | Unknown |  |
| sales_personself | Unknown |  |
| self | Unknown |  |
| sent | Unknown |  |
| soapid | Unknown |  |
| text_line_1 | Unknown |  |
| text_line_2 | Unknown |  |
| vat_amount | Unknown |  |
| vendoremployee_number | Unknown |  |
| vendorself | Unknown |  |

### customer_contact

| Column | Type | Keys |
| --- | --- | --- |
| contact_number | Unknown | PK |
| customer_number | Unknown |  |
| deleted | Unknown |  |
| e_invoice_id | Unknown |  |
| email | Unknown |  |
| email_notifications | Json |  |
| name | Unknown |  |
| notes | Unknown |  |
| phone | Unknown |  |
| self | Unknown |  |
| sort_key | Unknown |  |

### vat_zone

| Column | Type | Keys |
| --- | --- | --- |
| vat_zone_number | Unknown | PK |
| enabled_for_customer | Unknown |  |
| enabled_for_supplier | Unknown |  |
| name | Unknown |  |
| self | Unknown |  |

### product_sales_price

| Column | Type | Keys |
| --- | --- | --- |
| price | Unknown | PK |
| currency_code | Unknown | FK |
| product_number | Unknown | FK |
| self | Unknown |  |

### layout

| Column | Type | Keys |
| --- | --- | --- |
| layout_number | Unknown | PK |
| deleted | Unknown |  |
| name | Unknown |  |
| self | Unknown |  |

### payment_type

| Column | Type | Keys |
| --- | --- | --- |
| payment_type_number | Unknown | PK |
| name | Unknown |  |
| self | Unknown |  |

### unit

| Column | Type | Keys |
| --- | --- | --- |
| unit_number | Unknown | PK |
| name | Unknown |  |
| products | Unknown |  |
| self | Unknown |  |

### customer_group

| Column | Type | Keys |
| --- | --- | --- |
| customer_group_number | Unknown | PK |
| account_number | Unknown | FK |
| customers | Unknown |  |
| layout_number | Unknown |  |
| name | Unknown |  |
| self | Unknown |  |

### vat_account

| Column | Type | Keys |
| --- | --- | --- |
| vat_code | Unknown | PK |
| vat_type_number | Unknown | FK |
| account_number | Unknown |  |
| barred | Unknown |  |
| name | Unknown |  |
| rate_percentage | Unknown |  |
| self | Unknown |  |

### customer_location

| Column | Type | Keys |
| --- | --- | --- |
| customer_number | Unknown | PK |
| delivery_location_number | Unknown | PK |
| address | Unknown |  |
| barred | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| postal_code | Unknown |  |
| self | Unknown |  |
| sort_key | Unknown |  |
| terms_of_delivery | Unknown |  |

### department

| Column | Type | Keys |
| --- | --- | --- |
| department_number | Unknown | PK |
| percentage | Unknown |  |
| self | Unknown |  |

### department_distribution

| Column | Type | Keys |
| --- | --- | --- |
| departmental_distribution_number | Unknown | PK |
| barred | Unknown |  |
| distribution_type | Unknown |  |
| name | Unknown |  |
| self | Unknown |  |

### order_draft

| Column | Type | Keys |
| --- | --- | --- |
| order_number | Unknown | PK |
| customer_number | Unknown | FK |
| delivery_location_number | Unknown | FK |
| payment_terms_number | Unknown | FK |
| attentioncustomer_contact_number | Unknown |  |
| attentionself | Unknown |  |
| cost_price_in_base_currency | Unknown |  |
| currency | Unknown |  |
| date | Unknown |  |
| due_date | Unknown |  |
| exchange_rate | Unknown |  |
| gross_amount | Unknown |  |
| gross_amount_in_base_currency | Unknown |  |
| heading | Unknown |  |
| margin_in_base_currency | Unknown |  |
| margin_percentage | Unknown |  |
| net_amount | Unknown |  |
| net_amount_in_base_currency | Unknown |  |
| project_number | Unknown |  |
| recipient_address | Unknown |  |
| recipient_city | Unknown |  |
| recipient_country | Unknown |  |
| recipient_cvr | Unknown |  |
| recipient_ean | Unknown |  |
| recipient_name | Unknown |  |
| recipient_nem_handel_type | Unknown |  |
| recipient_public_entry_number | Unknown |  |
| recipient_zip | Unknown |  |
| referencescustomer_contact_number | Unknown |  |
| referencesself | Unknown |  |
| remainder | Unknown |  |
| remainder_in_base_currency | Unknown |  |
| rounding_amount | Unknown |  |
| sales_personemployee_number | Unknown |  |
| sales_personself | Unknown |  |
| self | Unknown |  |
| sent | Unknown |  |
| soapid | Unknown |  |
| text_line_1 | Unknown |  |
| text_line_2 | Unknown |  |
| vat_amount | Unknown |  |
| vendoremployee_number | Unknown |  |
| vendorself | Unknown |  |

### vat_type

| Column | Type | Keys |
| --- | --- | --- |
| vat_type_number | Unknown | PK |
| name | Unknown |  |
| self | Unknown |  |

### order_sent

| Column | Type | Keys |
| --- | --- | --- |
| order_number | Unknown | PK |
| customer_number | Unknown | FK |
| delivery_location_number | Unknown | FK |
| payment_terms_number | Unknown | FK |
| attentioncustomer_contact_number | Unknown |  |
| attentionself | Unknown |  |
| cost_price_in_base_currency | Unknown |  |
| currency | Unknown |  |
| date | Unknown |  |
| due_date | Unknown |  |
| exchange_rate | Unknown |  |
| gross_amount | Unknown |  |
| gross_amount_in_base_currency | Unknown |  |
| heading | Unknown |  |
| margin_in_base_currency | Unknown |  |
| margin_percentage | Unknown |  |
| net_amount | Unknown |  |
| net_amount_in_base_currency | Unknown |  |
| project_number | Unknown |  |
| recipient_address | Unknown |  |
| recipient_city | Unknown |  |
| recipient_country | Unknown |  |
| recipient_cvr | Unknown |  |
| recipient_ean | Unknown |  |
| recipient_name | Unknown |  |
| recipient_nem_handel_type | Unknown |  |
| recipient_public_entry_number | Unknown |  |
| recipient_zip | Unknown |  |
| referencescustomer_contact_number | Unknown |  |
| referencesself | Unknown |  |
| remainder | Unknown |  |
| remainder_in_base_currency | Unknown |  |
| rounding_amount | Unknown |  |
| sales_personemployee_number | Unknown |  |
| sales_personself | Unknown |  |
| self | Unknown |  |
| sent | Unknown |  |
| soapid | Unknown |  |
| text_line_1 | Unknown |  |
| text_line_2 | Unknown |  |
| vat_amount | Unknown |  |
| vendoremployee_number | Unknown |  |
| vendorself | Unknown |  |

### invoice_sent

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| booked_invoice_number | Unknown | FK |
| created_by | Unknown |  |
| creation_date | Unknown |  |
| recipient_ean | Unknown |  |
| recipient_mobile_phone | Unknown |  |
| recipient_name | Unknown |  |
| self | Unknown |  |
| send_by | Unknown |  |
| status | Unknown |  |

### supplier_group

| Column | Type | Keys |
| --- | --- | --- |
| supplier_group_number | Unknown | PK |
| account_number | Unknown | FK |
| name | Unknown |  |
| self | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| account_number | Unknown | PK |
| account_type | Unknown |  |
| accounting_years | Unknown |  |
| balance | Unknown |  |
| barred | Unknown |  |
| block_direct_entries | Unknown |  |
| contra_account_account_number | Unknown |  |
| contra_account_self | Unknown |  |
| debit_credit | Unknown |  |
| draft_balance | Unknown |  |
| from_account_number | Json |  |
| name | Unknown |  |
| self | Unknown |  |
| to_account_number | Json |  |
| total_from_account_account_number | Unknown |  |
| total_from_account_self | Unknown |  |
| vat_code | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| customer_contact_number | Unknown | FK |
| delivery_location_number | Unknown | FK |
| employee_number | Unknown | FK |
| group_number | Unknown | FK |
| layout_number | Unknown | FK |
| payment_terms_number | Unknown | FK |
| vat_zone_number | Unknown | FK |
| attention_contact_number | Unknown |  |
| balance | Unknown |  |
| barred | Unknown |  |
| contacts | Unknown |  |
| corporate_identification_number | Unknown |  |
| credit_limit | Unknown |  |
| currency | Unknown |  |
| due_amount | Unknown |  |
| e_invoicing_disabled_by_default | Unknown |  |
| ean | Unknown |  |
| last_updated | Unknown |  |
| p_number | Unknown |  |
| public_entry_number | Unknown |  |
| self | Unknown |  |
| telephone_and_fax_number | Unknown |  |
| templates_invoice | Unknown |  |
| templates_invoice_line | Unknown |  |
| totals_booked | Unknown |  |
| totals_drafts | Unknown |  |
| totals_self | Unknown |  |
| vat_number | Unknown |  |
| website | Unknown |  |

## Relationships

- customer_template_invoice(customer_number) → invoice_booked(booked_invoice_number)
- customer_template_invoice(delivery_location_number) → customer_location(delivery_location_number)
- app_setting_agreement(setting_key) → app_setting_user(setting_key)
- required_module(app_role_role_number) → app_role(role_number)
- journal_entry(account_number) → account(account_number)
- journal_entry(unit_1_number) → unit(unit_number)
- journal_entry(supplier_number) → supplier(supplier_number)
- journal_entry(employee_number) → employee(employee_number)
- journal_entry(unit_2_number) → unit(unit_number)
- journal_entry(customer_number) → customer(number)
- journal_entry(payment_type_number) → payment_type(payment_type_number)
- journal_entry(departmental_distribution_number) → department_distribution(departmental_distribution_number)
- journal_entry(voucher_accounting_year) → accounting_year(year)
- journal_entry(journal_number) → journal(journal_number)
- journal_customer_invoice(customer_number) → customer(number)
- journal_customer_invoice(journal_journal_number) → journal(journal_number)
- supplier(vat_zone_number) → vat_zone(vat_zone_number)
- supplier(layout_number) → layout(layout_number)
- supplier(supplier_group_number) → supplier_group(supplier_group_number)
- supplier(payment_terms_number) → payment_term(payment_terms_number)
- product_group(account_number) → account(account_number)
- order_archived(delivery_location_number) → customer_location(delivery_location_number)
- order_archived(customer_number) → customer(number)
- order_archived(payment_terms_number) → payment_term(payment_terms_number)
- product(product_group_number) → product_group(product_group_number)
- product(unit_number) → unit(unit_number)
- product(departmental_distribution_number) → department_distribution(departmental_distribution_number)
- invoice_booked_line(product_number) → product(product_number)
- invoice_booked_line(unit_number) → unit(unit_number)
- invoice_booked_line(departmental_distribution_number) → department_distribution(departmental_distribution_number)
- invoice_booked_line(booked_invoice_number) → invoice_booked(booked_invoice_number)
- invoice_booked(delivery_location_number) → customer_location(delivery_location_number)
- invoice_booked(customer_number) → customer(number)
- invoice_booked(payment_terms_number) → payment_term(payment_terms_number)
- customer_template_invoice_line(customer_number) → customer(number)
- accounting_year_period_entry(account_number) → account(account_number)
- accounting_year_period_entry(unit_1_number) → unit(unit_number)
- accounting_year_period_entry(vat_code) → vat_account(vat_code)
- accounting_year_period_entry(booked_invoice_number) → invoice_booked(booked_invoice_number)
- accounting_year_period_entry(unit_2_number) → unit(unit_number)
- accounting_year_period_entry(payment_type_number) → payment_term(payment_terms_number)
- accounting_year_period_entry(departmental_distribution_number) → department_distribution(departmental_distribution_number)
- accounting_year_period_entry(supplier_number) → supplier(supplier_number)
- accounting_year_period_entry(accounting_year_period_period_number) → accounting_year_period(period_number)
- accounting_year_period_entry(accounting_year_year) → accounting_year(year)
- invoice_draft(delivery_location_number) → customer_location(delivery_location_number)
- invoice_draft(customer_number) → customer(number)
- invoice_draft(payment_terms_number) → payment_term(payment_terms_number)
- product_sales_price(product_number) → product(product_number)
- product_sales_price(currency_code) → currency(code)
- customer_group(account_number) → account(account_number)
- vat_account(vat_type_number) → vat_type(vat_type_number)
- order_draft(delivery_location_number) → customer_location(delivery_location_number)
- order_draft(customer_number) → customer(number)
- order_draft(payment_terms_number) → payment_term(payment_terms_number)
- order_sent(delivery_location_number) → customer_location(delivery_location_number)
- order_sent(customer_number) → customer(number)
- order_sent(payment_terms_number) → payment_term(payment_terms_number)
- invoice_sent(booked_invoice_number) → invoice_booked(booked_invoice_number)
- supplier_group(account_number) → account(account_number)
- customer(delivery_location_number) → customer_location(delivery_location_number)
- customer(vat_zone_number) → vat_zone(vat_zone_number)
- customer(employee_number) → employee(employee_number)
- customer(layout_number) → layout(layout_number)
- customer(group_number) → customer_group(customer_group_number)
- customer(payment_terms_number) → payment_term(payment_terms_number)
- customer(customer_contact_number) → customer_contact(contact_number)