Fortnox

Explore the interactive ERD

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	PKFK
`voucher_series`	Unknown	PKFK
`voucher_year`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`first_day`	LocalDate

employee_dated_wage

Column	Type	Keys
`index`	Unknown	PK
`employee_id`	Unknown	PKFK
`hourly_pay`	Unknown
`monthly_salary`	Unknown

employee_category

Column	Type	Keys
`index`	Unknown	PK
`employee_id`	Unknown	PKFK
`name`	Unknown
`value`	Unknown

employee_children

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	PKFK
`approved_day`	Unknown
`child`	Unknown
`ingoing_withdrawn_day`	Unknown
`withdrawn_day`	Unknown

employee_opening_salary

Column	Type	Keys
`index`	Unknown	PK
`employee_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`credit`	Unknown
`debit`	Unknown
`project`	Unknown
`transaction_information`	Unknown

supplier_invoice_accrual

Column	Type	Keys
`supplier_invoice_number`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`supplier_number`	Unknown	PKFK

supplier_invoice

Column	Type	Keys
`number`	Unknown	PK
`supplier_number`	Unknown	PKFK
`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