# Fortnox schema ERD

Table and field reference for the Fivetran Fortnox connector.

## Table & Field Reference

### voucher

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| series | Unknown | PK |
| year | Unknown | PK |
| approval_state | Unknown |  |
| comment | Unknown |  |
| description | Unknown |  |
| reference_number | Unknown |  |
| reference_type | Unknown |  |
| transaction_date | Unknown |  |
| url | Unknown |  |

### voucher_row

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| voucher_number | Unknown | PK, FK |
| voucher_series | Unknown | PK, FK |
| voucher_year | Unknown | PK, FK |
| account_number | Unknown | FK |
| project | Unknown | FK |
| cost_center | Unknown |  |
| credit | Unknown |  |
| debit | Unknown |  |
| description | Unknown |  |
| quantity | Unknown |  |
| removed | Unknown |  |
| transaction_information | Unknown |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK, FK |
| description | Unknown |  |
| end_date | Unknown |  |
| project_leader | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| url | Unknown |  |

### company_setting

| Column | Type | Keys |
| --- | --- | --- |
| organization_number | Unknown | PK |
| address | Unknown |  |
| bg | Unknown |  |
| bic | Unknown |  |
| branch_code | Unknown |  |
| city | Unknown |  |
| contact_first_name | Unknown |  |
| contact_last_name | Unknown |  |
| country | Unknown |  |
| country_code | Unknown |  |
| database_number | Unknown |  |
| domicile | Unknown |  |
| email | Unknown |  |
| fax | Unknown |  |
| iban | Unknown |  |
| name | Unknown |  |
| pg | Unknown |  |
| phone_1 | Unknown |  |
| phone_2 | Unknown |  |
| tax_enabled | Unknown |  |
| vat_number | Unknown |  |
| visit_address | Unknown |  |
| visit_city | Unknown |  |
| visit_country | Unknown |  |
| visit_country_code | Unknown |  |
| visit_name | Unknown |  |
| visit_zip_code | Unknown |  |
| www | Unknown |  |
| zip_code | Unknown |  |

### stock_taking_row

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| stock_taking_id | Unknown | PK, FK |
| stock_point_id | Unknown | FK |
| counted_by | Unknown |  |
| current_row_no | Unknown |  |
| has_post_release_stock_change | Unknown |  |
| item_id | Unknown |  |
| stock_location_id | Unknown |  |
| stock_taken_quantity | Unknown |  |
| total_quantity_in_stock | Unknown |  |

### stock_taking

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| cost_center_code | Unknown |  |
| date | LocalDate |  |
| name | Unknown |  |
| responsible | Unknown |  |
| sort_params_primary_sort | Unknown |  |
| sort_params_primary_sort_order | Unknown |  |
| sort_params_secondary_sort | Unknown |  |
| sort_params_secondary_sort_order | Unknown |  |
| sorting_id | Unknown |  |
| state | Unknown |  |
| using_stock_point | Unknown |  |

### employee_dated_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| first_day | LocalDate |  |

### employee_dated_wage

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| employee_id | Unknown | PK, FK |
| hourly_pay | Unknown |  |
| monthly_salary | Unknown |  |

### employee_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| employee_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### employee_children

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| approved_day | Unknown |  |
| child | Unknown |  |
| ingoing_withdrawn_day | Unknown |  |
| withdrawn_day | Unknown |  |

### employee_opening_salary

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| employee_id | Unknown | PK, FK |
| amount | Unknown |  |
| period | Unknown |  |
| product_group | Unknown |  |
| quantity | Unknown |  |
| quantity_unit | Unknown |  |
| row_id | Unknown |  |
| salary_type_name | Unknown |  |
| salary_type_number | Unknown |  |
| sort_code | Unknown |  |
| text_row | Unknown |  |
| total | Unknown |  |
| vat | Unknown |  |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project | Unknown | FK |
| absence_hour_non_vacation_based | Unknown |  |
| absence_hour_vacation_based | Unknown |  |
| absence_workday_non_vacation_based | Unknown |  |
| absence_workday_vacation_based | Unknown |  |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| advance_vacation_debt | Unknown |  |
| atf_value | Unknown |  |
| atk_value | Unknown |  |
| attendance_day | Unknown |  |
| attendance_hour | Unknown |  |
| auto_non_recurring_tax | Unknown |  |
| average_hourly_wage | Unknown |  |
| average_weekly_hour | Unknown |  |
| bank_account_no | Unknown |  |
| calendar_day_whole | Unknown |  |
| city | Unknown |  |
| clearing_no | Unknown |  |
| cost_center | Unknown |  |
| country | Unknown |  |
| current_comp_balance | Unknown |  |
| current_flex_balance | Unknown |  |
| department | Unknown |  |
| email | Unknown |  |
| employed_to | LocalDate |  |
| employment_date | LocalDate |  |
| employment_form | Unknown |  |
| first_name | Unknown |  |
| fora_type | Unknown |  |
| full_name | Unknown |  |
| full_time_equivalent | Unknown |  |
| hourly_pay | Unknown |  |
| hourly_rate | Unknown |  |
| inactive | Unknown |  |
| include_in_calculation | Unknown |  |
| initial_comp | Unknown |  |
| initial_flex | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| monthly_salary | Unknown |  |
| non_recurring_tax | Unknown |  |
| non_vacation_based_calendar_day_partial | Unknown |  |
| non_vacation_based_calendar_day_whole | Unknown |  |
| paid | Unknown |  |
| payslip_type | Unknown |  |
| pending_paid | Unknown |  |
| pending_prepaid | Unknown |  |
| pending_saved | Unknown |  |
| pending_saved_year_1 | Unknown |  |
| pending_saved_year_2 | Unknown |  |
| pending_saved_year_3 | Unknown |  |
| pending_saved_year_4 | Unknown |  |
| pending_saved_year_5 | Unknown |  |
| pending_saved_year_6_plus | Unknown |  |
| pending_unpaid | Unknown |  |
| personal_identity_number | Unknown |  |
| personel_type | Unknown |  |
| phone_1 | Unknown |  |
| phone_2 | Unknown |  |
| post_code | Unknown |  |
| preliminary_tax_deducted | Unknown |  |
| prepaid | Unknown |  |
| registered_paid | Unknown |  |
| registered_prepaid | Unknown |  |
| registered_saved | Unknown |  |
| registered_saved_year_1 | Unknown |  |
| registered_saved_year_2 | Unknown |  |
| registered_saved_year_3 | Unknown |  |
| registered_saved_year_4 | Unknown |  |
| registered_saved_year_5 | Unknown |  |
| registered_saved_year_6_plus | Unknown |  |
| registered_unpaid | Unknown |  |
| salary_form | Unknown |  |
| salary_total | Unknown |  |
| salary_variable_addition | Unknown |  |
| salary_worked_time | Unknown |  |
| same_wage_percent | Unknown |  |
| saved | Unknown |  |
| saved_employment_rate_year_1 | Unknown |  |
| saved_employment_rate_year_2 | Unknown |  |
| saved_employment_rate_year_3 | Unknown |  |
| saved_employment_rate_year_4 | Unknown |  |
| saved_employment_rate_year_5 | Unknown |  |
| saved_employment_rate_year_6_plus | Unknown |  |
| saved_year_1 | Unknown |  |
| saved_year_2 | Unknown |  |
| saved_year_3 | Unknown |  |
| saved_year_4 | Unknown |  |
| saved_year_5 | Unknown |  |
| saved_year_6_plus | Unknown |  |
| schedule_id | Unknown |  |
| sole_custody | Unknown |  |
| sum_only_no_day | Unknown |  |
| tax_allowance | Unknown |  |
| tax_column | Unknown |  |
| tax_table | Unknown |  |
| total_vacation_salary_sum | Unknown |  |
| unpaid | Unknown |  |
| vacation_entitlement | Unknown |  |
| variable_addition_sum | Unknown |  |
| working_time_enumeration | Unknown |  |
| zip_code | Unknown |  |

### offer

| Column | Type | Keys |
| --- | --- | --- |
| document_number | Unknown | PK |
| customer_number | Unknown | FK |
| cancelled | Unknown |  |
| currency | Unknown |  |
| last_modified | Unknown |  |
| offer_date | Unknown |  |
| project | Unknown |  |
| sent | Unknown |  |
| total | Unknown |  |
| url | Unknown |  |

### voucher_series

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| approver_id | Unknown |  |
| approver_name | Unknown |  |
| description | Unknown |  |
| manual | Unknown |  |
| next_voucher_number | Unknown |  |
| year | Unknown |  |

### price_list

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| comment | Unknown |  |
| description | Unknown |  |
| pre_selected | Unknown |  |
| url | Unknown |  |

### price

| Column | Type | Keys |
| --- | --- | --- |
| from_quantity | Unknown | PK |
| price | Unknown | PK |
| article_number | Unknown | PK, FK |
| price_list | Unknown | FK |
| date | Instant |  |
| percentage | Unknown |  |

### supplier

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| active | Unknown |  |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| bank_account_number | Unknown |  |
| bg | Unknown |  |
| bic | Unknown |  |
| city | Unknown |  |
| cost_center | Unknown |  |
| country_code | Unknown |  |
| currency | Unknown |  |
| disable_payment_file | Unknown |  |
| email | Unknown |  |
| iban | Unknown |  |
| name | Unknown |  |
| organisation_number | Unknown |  |
| pg | Unknown |  |
| phone | Unknown |  |
| pre_defined_account | Unknown |  |
| project | Unknown |  |
| terms_of_payment | Unknown |  |
| url | Unknown |  |
| zip_code | Unknown |  |

### production_order_package_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| production_order_id | Unknown | PK, FK |
| item_unit | Unknown |  |
| quantity_required | Unknown |  |
| quantity_reserved | Unknown |  |
| total_quantity_required | Unknown |  |

### production_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| batch | Unknown |  |
| cost_center_code | Unknown |  |
| document_state | Unknown |  |
| inbound_stock_location_id | Unknown |  |
| inbound_stock_point_id | Unknown |  |
| item_description | Unknown |  |
| note | Unknown |  |
| outbound_stock_point_id | Unknown |  |
| production_date | LocalDate |  |
| production_state | Unknown |  |
| quantity | Unknown |  |
| start_date | LocalDate |  |

### contract

| Column | Type | Keys |
| --- | --- | --- |
| document_number | Unknown | PK |
| customer_number | Unknown | FK |
| continuous | Unknown |  |
| contract_length | Unknown |  |
| currency | Unknown |  |
| invoice_interval | Unknown |  |
| invoice_remaining | Unknown |  |
| last_invoice_date | Unknown |  |
| period_end | Unknown |  |
| period_start | Unknown |  |
| status | Unknown |  |
| template_number | Unknown |  |
| total | Unknown |  |
| url | Unknown |  |

### attendance_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | FK |
| cause_code | Unknown |  |
| cost_center | Unknown |  |
| date | LocalDate |  |
| hours | Unknown |  |
| project | Unknown |  |

### expense

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account | Unknown |  |
| code | Unknown |  |
| text | Unknown |  |

### article

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| description | Unknown |  |
| disposable_quantity | Unknown |  |
| ean | Unknown |  |
| housework | Unknown |  |
| last_modified | Unknown |  |
| purchase_price | Unknown |  |
| quantity_in_stock | Unknown |  |
| reserved_quantity | Unknown |  |
| sales_price | Unknown |  |
| stock_place | Unknown |  |
| stock_value | Unknown |  |
| unit | Unknown |  |
| url | Unknown |  |
| vat | Unknown |  |
| webshop_article | Unknown |  |

### locked_period

| Column | Type | Keys |
| --- | --- | --- |
| end_date | LocalDate | PK |

### cost_center

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| active | Unknown |  |
| description | Unknown |  |
| note | Unknown |  |

### purchase_order_row

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| price | Unknown | FK |
| stock_point_id | Unknown | FK |
| back_order_quantity | Unknown |  |
| is_stock_item | Unknown |  |
| item_description | Unknown |  |
| item_id | Unknown |  |
| item_unit | Unknown |  |
| note | Unknown |  |
| ordered_quantity | Unknown |  |
| received_quantity | Unknown |  |
| remaining_ordered_quantity | Unknown |  |
| row_num | Unknown |  |
| stock_location_code | Unknown |  |
| stock_location_id | Unknown |  |
| stock_location_name | Unknown |  |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_number | Unknown | FK |
| project_id | Unknown | FK |
| stock_point_id | Unknown | FK |
| supplier_number | Unknown | FK |
| confirmation_email | Unknown |  |
| cost_center_code | Unknown |  |
| currency_code | Unknown |  |
| currency_rate | Unknown |  |
| currency_unit | Unknown |  |
| customer_id | Unknown |  |
| delivery_address | Unknown |  |
| delivery_address_2 | Unknown |  |
| delivery_city | Unknown |  |
| delivery_country_code | Unknown |  |
| delivery_date | LocalDate |  |
| delivery_name | Unknown |  |
| delivery_zip_code | Unknown |  |
| dropship | Unknown |  |
| internal_reference | Unknown |  |
| language_code | Unknown |  |
| manually_completed | Unknown |  |
| message_to_supplier | Unknown |  |
| note | Unknown |  |
| order_date | LocalDate |  |
| order_value | Unknown |  |
| order_value_in_sek | Unknown |  |
| our_reference | Unknown |  |
| outbound_document_reference_id | Unknown |  |
| outbound_document_reference_type | Unknown |  |
| payment_terms_code | Unknown |  |
| purchase_order_state | Unknown |  |
| purchase_type | Unknown |  |
| response_state | Unknown |  |
| supplier | Unknown |  |
| supplier_address | Unknown |  |
| supplier_address_2 | Unknown |  |
| supplier_city | Unknown |  |
| supplier_country_code | Unknown |  |
| supplier_email | Unknown |  |
| supplier_name | Unknown |  |
| supplier_post_code | Unknown |  |
| total_received_quantity | Unknown |  |
| translated_response_state | Unknown |  |
| voided | Unknown |  |
| your_reference | Unknown |  |

### salary_transaction

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| employee_id | Unknown | FK |
| project | Unknown | FK |
| amount | Unknown |  |
| cost_center | Unknown |  |
| date | LocalDate |  |
| expense | Unknown |  |
| salary_code | Unknown |  |
| salary_row | Unknown |  |
| text_row | Unknown |  |
| total | Unknown |  |
| vat | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| document_number | Unknown | PK |
| customer_number | Unknown | FK |
| cancelled | Unknown |  |
| currency | Unknown |  |
| delivery_date | Unknown |  |
| external_invoice_reference_1 | Unknown |  |
| external_invoice_reference_2 | Unknown |  |
| last_modified | Unknown |  |
| order_date | Unknown |  |
| order_type | Unknown |  |
| project | Unknown |  |
| sent | Unknown |  |
| total | Unknown |  |
| url | Unknown |  |

### supplier_invoice_accrual_row

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| supplier_invoice_accrual_supplier_invoice_number | Unknown | PK, FK |
| credit | Unknown |  |
| debit | Unknown |  |
| project | Unknown |  |
| transaction_information | Unknown |  |

### supplier_invoice_accrual

| Column | Type | Keys |
| --- | --- | --- |
| supplier_invoice_number | Unknown | PK, FK |
| accrual_account | Unknown |  |
| cost_account | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| period | Unknown |  |
| time | Unknown |  |
| total | Unknown |  |
| vat_included | Unknown |  |

### incoming_good

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| stock_point_id | Unknown | FK |
| supplier_number | Unknown | FK |
| completed | Unknown |  |
| date | LocalDate |  |
| delivery_note_id | Unknown |  |
| has_delivery_note | Unknown |  |
| note | Unknown |  |
| released | Unknown |  |
| unmatched_value | Unknown |  |
| voided | Unknown |  |

### financial_year

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_chart_type | Unknown |  |
| accounting_method | Unknown |  |
| from_date | LocalDate |  |
| to_date | LocalDate |  |

### invoice_accrual_row

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_accrual_invoice_number | Unknown | PK, FK |
| cost_center | Unknown |  |
| credit | Unknown |  |
| debit | Unknown |  |
| project | Unknown |  |
| transaction_information | Unknown |  |

### invoice_accrual

| Column | Type | Keys |
| --- | --- | --- |
| invoice_number | Unknown | PK |
| accrual_account | Unknown |  |
| description | Unknown |  |
| end_date | LocalDate |  |
| period | Unknown |  |
| revenue_account | Unknown |  |
| start_date | LocalDate |  |
| times | Unknown |  |
| total | Unknown |  |
| vat_included | Unknown |  |

### absence_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cause_code | Unknown |  |
| cost_center | Unknown |  |
| date | Unknown |  |
| employee_id | Unknown |  |
| extent | Unknown |  |
| holiday_entitling | Unknown |  |
| hours | Json |  |
| project | Unknown |  |
| url | Unknown |  |

### voucher_connection_file

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| voucher_number | Unknown | FK |
| voucher_series | Unknown | FK |
| description | Unknown |  |
| url | Unknown |  |

### asset_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | FK |
| depreciation_id | Unknown | FK |
| revaluation_id | Unknown | FK |
| sale_loss_id | Unknown | FK |
| sale_win_id | Unknown | FK |
| value_loss_id | Unknown | FK |
| write_down_ack_id | Unknown | FK |
| write_down_id | Unknown | FK |
| description | Unknown |  |
| in_use | Unknown |  |
| note | Unknown |  |
| number | Unknown |  |
| type | Unknown |  |

### stock_point_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| stock_point_id | Unknown | PK, FK |
| code | Unknown |  |
| name | Unknown |  |

### stock_point

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| delivery_address | Unknown |  |
| delivery_address_2 | Unknown |  |
| delivery_city | Unknown |  |
| delivery_country_code | Unknown |  |
| delivery_name | Unknown |  |
| delivery_phone | Unknown |  |
| delivery_zip_code | Unknown |  |
| name | Unknown |  |
| using_company_address | Unknown |  |

### supplier_invoice_payment

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| amount | Unknown |  |
| booked | Unknown |  |
| currency | Unknown |  |
| currency_rate | Unknown |  |
| currency_unit | Unknown |  |
| invoice_number | Unknown |  |
| last_modified | Unknown |  |
| payment_date | Unknown |  |
| source | Unknown |  |
| url | Unknown |  |
| write_off_exist | Unknown |  |

### supplier_invoice_file_connection

| Column | Type | Keys |
| --- | --- | --- |
| file_id | Unknown | PK |
| supplier_invoice_number | Unknown | FK |
| name | Unknown |  |

### invoice_payment

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| amount | Unknown |  |
| booked | Unknown |  |
| currency | Unknown |  |
| currency_rate | Unknown |  |
| currency_unit | Unknown |  |
| invoice_number | Unknown |  |
| last_modified | Unknown |  |
| payment_date | Unknown |  |
| source | Unknown |  |
| url | Unknown |  |
| write_off_exist | Unknown |  |

### label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |

### tax_reduction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| approved_amount | Unknown |  |
| customer_name | Unknown |  |
| reference_document_type | Unknown |  |
| reference_number | Unknown |  |
| social_urity_number | Unknown |  |
| url | Unknown |  |

### stock_balance

| Column | Type | Keys |
| --- | --- | --- |
| item_id | Unknown | PK |
| stock_point_code | Unknown | PK, FK |
| available_stock | Unknown |  |
| in_stock | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| customer_number | Unknown | FK |
| voucher_number | Unknown | FK |
| balance | Unknown |  |
| booked | Unknown |  |
| cancelled | Unknown |  |
| cost_center | Unknown |  |
| currency | Unknown |  |
| currency_rate | Unknown |  |
| currency_unit | Unknown |  |
| document_number | Unknown |  |
| due_date | Unknown |  |
| external_invoice_reference_1 | Unknown |  |
| external_invoice_reference_2 | Unknown |  |
| final_pay_date | Unknown |  |
| invoice_date | Unknown |  |
| invoice_type | Unknown |  |
| last_modified | Unknown |  |
| nox_finans | Unknown |  |
| ocr | Unknown |  |
| project | Unknown |  |
| sent | Unknown |  |
| terms_of_payment | Unknown |  |
| total | Unknown |  |
| url | Unknown |  |
| way_of_delivery | Unknown |  |

### supplier_invoice_voucher

| Column | Type | Keys |
| --- | --- | --- |
| series | Unknown | PK |
| year | Unknown | PK |
| number | Unknown | PK, FK |
| supplier_number | Unknown | PK, FK |

### supplier_invoice

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| supplier_number | Unknown | PK, FK |
| authorizer_name | Unknown |  |
| balance | Unknown |  |
| booked | Unknown |  |
| cancel | Unknown |  |
| cost_center | Unknown |  |
| credit | Unknown |  |
| currency | Unknown |  |
| currency_rate | Unknown |  |
| currency_unit | Unknown |  |
| due_date | Unknown |  |
| external_invoice_number | Unknown |  |
| external_invoice_series | Unknown |  |
| final_pay_date | Unknown |  |
| invoice_date | Unknown |  |
| invoice_number | Unknown |  |
| project | Unknown |  |
| total | Unknown |  |
| url | Unknown |  |

### asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| acquisition_date | Unknown |  |
| acquisition_value | Unknown |  |
| depreciated_to | Unknown |  |
| depreciation_final | Unknown |  |
| description | Unknown |  |
| number | Unknown |  |
| status | Unknown |  |
| status_id | Unknown |  |
| type | Unknown |  |
| type_id | Unknown |  |
| url | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| active | Unknown |  |
| balance_brought_forward | Unknown |  |
| cost_center_settings | Unknown |  |
| description | Unknown |  |
| last_modified | Unknown |  |
| project_settings | Unknown |  |
| sru | Unknown |  |
| url | Unknown |  |
| vat_code | Unknown |  |
| year | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| city | Unknown |  |
| email | Unknown |  |
| last_modified | Unknown |  |
| name | Unknown |  |
| organisation_number | Unknown |  |
| phone | Unknown |  |
| url | Unknown |  |
| zip_code | Unknown |  |

## Relationships

- voucher_row(account_number) → account(number)
- voucher_row(project) → project(number)
- voucher_row(voucher_series) → voucher(series)
- voucher_row(voucher_number) → voucher(number)
- voucher_row(voucher_year) → voucher(year)
- project(number) → attendance_transaction(project)
- stock_taking_row(stock_point_id) → stock_point(id)
- stock_taking_row(stock_taking_id) → stock_taking(id)
- stock_taking(project_id) → project(number)
- employee_dated_schedule(employee_id) → employee(id)
- employee_dated_wage(employee_id) → employee(id)
- employee_category(employee_id) → employee(id)
- employee_children(employee_id) → employee(id)
- employee_opening_salary(employee_id) → employee(id)
- employee(project) → project(number)
- offer(customer_number) → customer(number)
- price(article_number) → article(number)
- price(price_list) → price_list(code)
- production_order_package_item(production_order_id) → production_order(id)
- production_order(project_id) → project(number)
- contract(customer_number) → customer(number)
- attendance_transaction(employee_id) → employee(id)
- purchase_order_row(price) → price(price)
- purchase_order_row(stock_point_id) → stock_point(id)
- purchase_order_row(purchase_order_id) → purchase_order(id)
- purchase_order(supplier_number) → supplier(number)
- purchase_order(customer_number) → customer(number)
- purchase_order(project_id) → project(number)
- purchase_order(stock_point_id) → stock_point(id)
- salary_transaction(project) → project(number)
- salary_transaction(employee_id) → employee(id)
- orders(customer_number) → customer(number)
- supplier_invoice_accrual_row(supplier_invoice_accrual_supplier_invoice_number) → supplier_invoice_accrual(supplier_invoice_number)
- supplier_invoice_accrual(supplier_invoice_number) → supplier_invoice(number)
- incoming_good(supplier_number) → supplier(number)
- incoming_good(stock_point_id) → stock_point(id)
- invoice_accrual_row(invoice_accrual_invoice_number) → invoice_accrual(invoice_number)
- voucher_connection_file(voucher_number) → voucher(number)
- voucher_connection_file(voucher_series) → voucher(series)
- asset_type(sale_win_id) → account(number)
- asset_type(write_down_ack_id) → account(number)
- asset_type(write_down_id) → account(number)
- asset_type(asset_id) → account(number)
- asset_type(sale_loss_id) → account(number)
- asset_type(revaluation_id) → account(number)
- asset_type(depreciation_id) → account(number)
- asset_type(value_loss_id) → account(number)
- stock_point_location(stock_point_id) → stock_point(id)
- supplier_invoice_file_connection(supplier_invoice_number) → supplier_invoice(number)
- stock_balance(stock_point_code) → stock_point(code)
- invoice(voucher_number) → voucher(number)
- invoice(customer_number) → customer(number)
- supplier_invoice_voucher(number) → voucher(number)
- supplier_invoice_voucher(supplier_number) → supplier_invoice(supplier_number)
- supplier_invoice(supplier_number) → supplier(number)