ERD for Fortnox

26 tables

Loading diagram…

invoices

url

string

url_tax_reduction_list

string

accounting_method

string

address_1

string

address_2

string

administration_fee

double

administration_fee_vat

double

balance

double

basis_tax_reduction

double

booked

boolean

cancelled

boolean

city

string

comments

string

contract_reference

double

contribution_percent

double

contribution_value

double

cost_center

string

country

string

credit

boolean

credit_invoice_reference

double

currency

string

currency_rate

double

currency_unit

double

customer_name

string

customer_number

double

delivery_address_1

string

delivery_address_2

string

delivery_city

string

delivery_country

string

delivery_date

string

delivery_name

string

delivery_zip_code

string

document_number

double

due_date

date

edi_information_edi_global_location_number

string

edi_information_edi_global_location_number_delivery

string

edi_information_edi_invoice_extra_1

string

edi_information_edi_invoice_extra_2

string

edi_information_edi_our_electronic_reference

string

edi_information_edi_your_electronic_reference

string

edi_information_edi_status

double

eu_quarterly_report

boolean

email_information_email_address_from

string

email_information_email_address_to

string

email_information_email_address_cc

string

email_information_email_address_bcc

string

email_information_email_subject

string

email_information_email_body

string

external_invoice_reference_1

string

external_invoice_reference_2

string

final_pay_date

date

freight

double

freight_vat

double

gross

double

house_work

boolean

invoice_date

date

invoice_period_end

string

invoice_period_start

string

invoice_reference

double

invoice_type

string

labels

string

language

string

last_remind_date

date

net

double

not_completed

boolean

nox_finans

boolean

ocr

double

offer_reference

double

order_reference

double

organisation_number

string

our_reference

string

outbound_date

date

payment_way

string

phone_1

string

phone_2

string

price_list

string

print_template

string

project

string

remarks

string

reminders

double

round_off

double

sent

boolean

tax_reduction

string

tax_reduction_type

string

terms_of_delivery

string

terms_of_payment

double

time_basis_reference

string

total

double

total_to_pay

double

total_vat

double

vat_included

boolean

voucher_number

double

voucher_series

string

voucher_year

double

warehouse_ready

boolean

way_of_delivery

string

your_order_number

string

your_reference

string

zip_code

string

_weld_synced

date

invoice_rows

account_number

double

article_number

string

contribution_percent

double

contribution_value

double

cost

double

cost_center

string

delivered_quantity

double

description

string

discount

double

discount_type

string

house_work

boolean

house_work_hours_to_report

string

house_work_type

string

price

double

price_excluding_vat

double

project

string

row_id

double

stock_point_code

string

total

double

total_excluding_vat

double

unit

string

vat

double

index

double

invoice_document_number

string

supplier_invoices

url

string

administration_fee

double

balance

double

booked

boolean

cancelled

boolean

comments

string

cost_center

string

credit

boolean

credit_reference

double

currency

string

currency_rate

double

currency_unit

double

disable_payment_file

boolean

due_date

date

external_invoice_number

string

external_invoice_series

string

freight

double

given_number

double

invoice_date

date

invoice_number

string

ocr

double

our_reference

string

payment_pending

boolean

project

string

round_off_value

double

supplier_number

double

supplier_name

string

total

double

vat

double

your_reference

string

voucher_number

string

voucher_series

string

voucher_year

string

vat_type

string

sales_type

string

accounting_method

string

vouchers

string

final_pay_date

date

_weld_synced

date

supplier_invoice_rows

account

double

article_number

string

code

string

cost_center

string

account_description

string

item_description

string

debit

double

debit_currency

double

credit

double

credit_currency

double

project

string

transaction_information

string

price

double

quantity

double

total

double

unit

string

stock_point_code

string

stock_location_code

string

index

double

supplier_invoice_given_number

string

employees

url

string

employee_id

string

personal_identity_number

string

first_name

string

last_name

string

full_name

string

address_1

string

address_2

string

post_code

string

city

string

country

string

phone_1

string

phone_2

string

employment_date

date

employment_form

string

salary_form

string

job_title

string

personel_type

string

schedule_id

string

fora_type

string

monthly_salary

double

hourly_pay

string

tax_allowance

string

tax_table

double

tax_column

double

auto_non_recurring_tax

boolean

non_recurring_tax

double

cost_center

string

project

string

vacation_days_paid

double

vacation_days_saved

double

vacation_days_unpaid

double

vacation_days_prepaid

double

vacation_days_saved_year_1

double

vacation_days_saved_year_2

double

vacation_days_saved_year_3

double

vacation_days_saved_year_4

double

vacation_days_saved_year_5

double

vacation_days_saved_year_6_plus

double

vacation_days_saved_employment_rate_year_1

double

vacation_days_saved_employment_rate_year_2

double

vacation_days_saved_employment_rate_year_3

double

vacation_days_saved_employment_rate_year_4

double

vacation_days_saved_employment_rate_year_5

double

vacation_days_saved_employment_rate_year_6_plus

double

vacation_days_registered_paid

double

vacation_days_registered_saved

double

vacation_days_registered_unpaid

double

vacation_days_registered_prepaid

double

vacation_days_registered_saved_year_1

double

vacation_days_registered_saved_year_2

double

vacation_days_registered_saved_year_3

double

vacation_days_registered_saved_year_4

double

vacation_days_registered_saved_year_5

double

vacation_days_registered_saved_year_6_plus

double

vacation_days_pending_paid

double

vacation_days_pending_saved

double

vacation_days_pending_unpaid

double

vacation_days_pending_prepaid

double

vacation_days_pending_saved_year_1

double

vacation_days_pending_saved_year_2

double

vacation_days_pending_saved_year_3

double

vacation_days_pending_saved_year_4

double

vacation_days_pending_saved_year_5

double

vacation_days_pending_saved_year_6_plus

double

inactive

boolean

clearing_no

string

bank_account_no

string

employed_to

date

average_weekly_hours

string

average_hourly_wage

string

dated_wages

string

dated_salary_supplements

string

_weld_synced

date

dated_schedules

employee_id

string

first_day

date

schedule_id

string

index

double

employee_children

string

employee_id

string

child

string

approved_days

double

ingoing_withdrawn_days

double

withdrawn_days

double

index

double

financial_years

double

url

string

from_date

date

to_date

date

account_chart_type

string

accounting_method

string

_weld_synced

date

customers

url

string

address_1

string

address_2

string

city

string

country

string

comments

string

currency

string

cost_center

string

country_code

string

active

boolean

customer_number

double

default_delivery_types_invoice

string

default_delivery_types_order

string

default_delivery_types_offer

string

default_templates_order

string

default_templates_offer

string

default_templates_invoice

string

default_templates_cash_invoice

string

delivery_address_1

string

delivery_address_2

string

delivery_city

string

delivery_country

string

delivery_country_code

string

delivery_fax

string

delivery_name

string

delivery_phone_1

string

delivery_phone_2

string

delivery_zip_code

string

email_invoice

string

email_invoice_bcc

string

email_invoice_cc

string

email_offer

string

email_offer_bcc

string

email_offer_cc

string

email_order

string

email_order_bcc

string

email_order_cc

string

external_reference

string

fax

string

gln

string

gln_delivery

string

invoice_administration_fee

string

invoice_discount

string

invoice_freight

string

invoice_remark

string

name

string

organisation_number

string

our_reference

string

phone_1

string

phone_2

string

price_list

string

project

string

sales_account

double

show_price_vat_included

boolean

terms_of_delivery

string

terms_of_payment

double

type

string

vat_number

string

vat_type

string

visiting_address

string

visiting_city

string

visiting_country

string

visiting_country_code

string

visiting_zip_code

string

way_of_delivery

string

www

string

your_reference

string

zip_code

string

_weld_synced

date

suppliers

url

string

active

boolean

address_1

string

address_2

string

bank

string

bank_account_number

string

bic

string

branch_code

double

city

string

clearing_number

string

comments

string

cost_center

string

country

string

country_code

string

currency

string

disable_payment_file

boolean

string

fax

string

iban

string

name

string

organisation_number

string

our_reference

string

our_customer_number

string

phone_1

string

phone_2

string

pre_defined_account

double

project

string

supplier_number

double

terms_of_payment

double

vat_number

string

vat_type

double

visiting_address

string

visiting_city

string

visiting_country

string

visiting_country_code

string

visiting_zip_code

string

work_place

double

www

string

your_reference

string

zip_code

string

_weld_synced

date

terms_of_deliveries

url

string

code

string

description_english

string

description

string

_weld_synced

date

contracts

_weld_synced

date

labels

_weld_synced

date

units

url

string

code

string

code_english

string

description

string

_weld_synced

date

accounts

url

string

active

boolean

balance_brought_forward

double

balance_carried_forward

double

cost_center

string

cost_center_settings

string

description

string

number

double

project

string

project_settings

string

sru

double

transaction_information

string

transaction_information_settings

string

vat_code

string

year

double

quantity_settings

string

quantity_unit

string

opening_quantities

string

_weld_synced

date

terms_of_payments

url

string

code

double

description

string

_weld_synced

date

expenses

url

string

code

string

text

string

account

double

_weld_synced

date

articles

_weld_synced

date

voucher_series

url

string

code

string

description

string

manual

boolean

year

double

approver

string

_weld_synced

date

cost_centers

url

string

code

string

description

string

note

string

active

boolean

_weld_synced

date

currencies

url

string

buy_rate

double

code

string

date

description

string

sell_rate

double

unit

double

is_automatic

boolean

_weld_synced

date

projects

_weld_synced

date

vouchers

url

string

comments

string

description

string

reference_number

double

reference_type

string

transaction_date

date

voucher_number

double

voucher_series

string

year

double

approval_state

double

_weld_synced

date

way_of_deliveries

url

string

code

string

description_english

string

description

string

_weld_synced

date

prices

_weld_synced

date

tax_reductions

_weld_synced

date

Table

Sub table