Fortnox schema

23 tables

About the connector Start free

23 tables

Joins between these tables aren't mapped yet.

Loading diagram…

employees

invoices

supplier_invoices

vouchers

accounts

19

url

string

active

boolean

balance_brought_forward

double

balance_carried_forward

double

cost_center

string

cost_center_settings

string

description

string

number

double

articles

47

url

string

article_number

string

bulky

boolean

construction_account

double

depth

double

description

string

disposable_quantity

double

ean

string

cost_centers

6

url

string

code

string

description

string

note

string

active

boolean

_weld_synced

date

currencies

9

url

string

buy_rate

double

code

string

date

date

description

string

sell_rate

double

unit

double

is_automatic

boolean

_weld_synced

date

customers

70

url

string

address_1

string

address_2

string

city

string

country

string

comments

string

currency

string

cost_center

string

employees

74

url

string

employee_id

string

personal_identity_number

string

first_name

string

last_name

string

full_name

string

address_1

string

address_2

string

employee_children

8

id

string

employee_id

string

child

string

approved_days

double

ingoing_withdrawn_days

double

withdrawn_days

double

index

double

_weld_synced

date

employees_dated_schedules

5

employee_id

string

first_day

date

schedule_id

string

index

double

_weld_synced

date

expenses

5

url

string

code

string

text

string

account

double

_weld_synced

date

financial_years

7

id

double

url

string

from_date

date

to_date

date

account_chart_type

string

accounting_method

string

_weld_synced

date

invoices

100

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

invoices_invoice_rows

25

account_number

double

article_number

string

contribution_percent

double

contribution_value

double

cost

string

cost_center

string

delivered_quantity

double

description

string

supplier_invoices

39

url

string

administration_fee

double

balance

double

booked

boolean

cancelled

boolean

comments

string

cost_center

string

credit

boolean

supplier_invoice_rows

21

account

double

article_number

string

code

string

cost_center

string

account_description

string

item_description

string

debit

double

debit_currency

double

suppliers

43

url

string

active

boolean

address_1

string

address_2

string

bank

string

bank_account_number

string

bg

string

bic

string

tax_reductions

2

id

string

_weld_synced

date

terms_of_deliveries

5

url

string

code

string

description_english

string

description

string

_weld_synced

date

terms_of_payments

4

url

string

code

string

description

string

_weld_synced

date

units

5

url

string

code

string

code_english

string

description

string

_weld_synced

date

voucher_series

7

url

string

code

string

description

string

manual

boolean

year

double

approver

string

_weld_synced

date

vouchers

13

url

string

comments

string

cost_center

string

description

string

project

string

reference_number

string

reference_type

string

transaction_date

date

voucher_rows

14

account

double

cost_center

string

credit

double

description

string

debit

double

project

string

removed

boolean

transaction_information

string

way_of_deliveries

5

url

string

code

string

description_english

string

description

string

_weld_synced

date