invantive documentation
Invantive Support ForumsLog In / Sign Up

Fortnox Data Model

Fortnox ERP system provides cloud-based tools for accounting, invoicing, payroll, and inventory management, enabling small businesses to automate processes efficiently.

Set up this platform in Invantive Cloud: https://cloud.invantive.com/fortnox

Text comparisons on this platform are case sensitive.

Platform

  • Used from: Invantive Cloud and the Invantive products on your own computer or server.
  • Kind: an application reached over its API.
  • The data is partitioned, such as per company or administration.
  • One query can read several companies at once.
  • Invantive Cloud plans: Free for public data, Free, Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.fortnox.se.

Figures

Figure Count
Tables 248
Columns 6,184
Tables with insert 51
Tables with update 39
Tables with delete 28
Tables documented 118

Data Model Poster

PDF, 1 A0 sheet

On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.

Fortnox data model, Sheet 1 of 1Fortnox data modelfor use with Invantive UniversalSQLRelease 27.1.3-BETA+6294 · 01-11-2026OtherSheet 1 of 1 · documentation.invantive.euOtherFortnox.Accounts.Accounts: AccountsAccountsFortnox.Expenses.Expenses: ExpensesExpensesFortnox.PredefinedAccounts.PredefinedAccounts: Predefined AccountsPredefinedAccountsFortnox.PredefinedVoucherSeries.PredefinedVoucherSeries: Predefined Voucher SeriesPredefinedVoucherSeriesFortnox.VoucherSeries.VoucherSeries: Voucher SeriesVoucherSeriesFortnox.Vouchers.Vouchers: VouchersVouchersAccountFortnox.Views.AccountActiveBalances: Fortnox Active Account BalancesAccountActiveBalancesInvoiceFortnox.Views.InvoiceLines: Fortnox Invoice LinesInvoiceLinesMeFortnox.Me.Me: MeMeNATIVEPLATFORMSCALARREQUESTSFortnox.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSSIETypeFortnox.CodeValues.SIETypes: Domain SIETypesSIETypesSieFortnox.Views.SieAnnualBalanceFiles: Fortnox Sie Annual Balance FilesSieAnnualBalanceFilesFortnox.Views.SieItemBalanceFiles: Fortnox Sie Item Balance FilesSieItemBalanceFilesFortnox.Views.SiePeriodBalanceFiles: Fortnox Sie Period Balance FilesSiePeriodBalanceFilesFortnox.Views.SieTransactionFiles: Fortnox Sie Transaction FilesSieTransactionFilesSupplierFortnox.Views.SupplierInvoiceLines: Fortnox Supplier Invoice LinesSupplierInvoiceLinesVoucherFortnox.Views.VoucherLines: Voucher LinesVoucherLinesFortnox.Views.Vouchers: VouchersVouchersFortnoxData dictionaryEvery table and column of this data model is described with its documentation ondocumentation.invantive.eu, where the poster is also available in other languages.NotesThe boxes are grouped by topic and coloured by category. A relation is drawn in the topic of thetable holding the key; a box in pale grey is defined in another topic.TopicsOther1Tables without relations1LegendTransactionalSetupTechnicalHard-coded valuesDefined in another topicDeclared keyRelation described in wordsCandidate derived from column namesBold: a popular table+Bulk, +Read: the table also exists as these variants×n: n keys between the same tablesGenerated from the metadata of Invantive UniversalSQL 27.1.3-BETA+6294 on 01-11-2026. Every table links to itspage with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/fortnox
The poster as text: tables per topic and their relations

Other

Accounts, Expenses, PredefinedAccounts, PredefinedVoucherSeries, VoucherSeries, Vouchers

Account (without relations)

AccountActiveBalances

Invoice (without relations)

InvoiceLines

Me (without relations)

Me

NATIVEPLATFORMSCALARREQUESTS (without relations)

NATIVEPLATFORMSCALARREQUESTS

SIEType (without relations)

SIETypes

Sie (without relations)

SieAnnualBalanceFiles, SieItemBalanceFiles, SiePeriodBalanceFiles, SieTransactionFiles

Supplier (without relations)

SupplierInvoiceLines

Voucher (without relations)

VoucherLines, Vouchers

Relations

  • Expenses → Accounts (candidate): Follows from the name of the column and held in every filled row of the test company on 2026-10-31; not stated by Fortnox.
  • PredefinedAccounts → Accounts (candidate): Follows from the name of the column and held in every filled row of the test company on 2026-10-31; not stated by Fortnox.
  • PredefinedVoucherSeries → VoucherSeries (candidate): Follows from the name of the column and held in every filled row of the test company on 2026-10-31; not stated by Fortnox.
  • Vouchers → VoucherSeries (described in words): The voucher series of the voucher in the financial year of the voucher; VoucherSeries lists the series of one financial year, so a voucher of another year finds no row.

Tables

Fortnox.AbsenceTransactions

Fortnox.AccountCharts

Fortnox.Accounts

Fortnox.Archive

Fortnox.ArticleFileConnections

Fortnox.ArticleUrlConnections

Fortnox.Articles

Fortnox.AssetFileConnection

Fortnox.AssetTypes

Fortnox.Assets

Fortnox.AttendanceTransactions

Fortnox.CodeValues

Fortnox.CompanyInformation

Fortnox.CompanySettings

Fortnox.ContractAccruals

Fortnox.ContractTemplates

Fortnox.Contracts

Fortnox.CostCenters

Fortnox.Currencies

Fortnox.CustomerReferences

Fortnox.Customers

Fortnox.EUVatLimitRegulation

Fortnox.Employees

Fortnox.Expenses

Fortnox.FileAttachments

Fortnox.FinanceInvoices

Fortnox.FinancialYears

Fortnox.Inbox

Fortnox.IntegrationDeveloperRatings

Fortnox.IntegrationDeveloperSales

Fortnox.IntegrationDeveloperUsers

Fortnox.IntegrationPartnerSales

Fortnox.InvoiceAccruals

Fortnox.InvoicePayments

Fortnox.Invoices

Fortnox.Labels

Fortnox.LockedPeriod

Fortnox.Me

Fortnox.ModesOfPayments

Fortnox.Native

Fortnox.Offers

Fortnox.Orders

Fortnox.PredefinedAccounts

Fortnox.PredefinedVoucherSeries

Fortnox.PriceLists

Fortnox.Prices

Fortnox.PrintTemplates

Fortnox.Projects

Fortnox.RecurringBillingDeviations

Fortnox.RecurringBillingInvoiceRequests

Fortnox.RecurringBillings

Fortnox.SIE

Fortnox.SalaryTransactions

Fortnox.ScheduleTimes

Fortnox.SupplierInvoiceAccruals

Fortnox.SupplierInvoiceExternalUrlConnections

Fortnox.SupplierInvoiceFileConnections

Fortnox.SupplierInvoicePayments

Fortnox.SupplierInvoices

Fortnox.Suppliers

Fortnox.TaxReductions

Fortnox.TermsOfDeliveries

Fortnox.TermsOfPayments

Fortnox.TimeReportingArticles

Fortnox.TimeReportingRegistrations

Fortnox.TrustedEmailSenders

Fortnox.Units

Fortnox.VacationDebtBasis

Fortnox.Views

Fortnox.VoucherFileConnections

Fortnox.VoucherSeries

Fortnox.Vouchers

Fortnox.WarehouseCustomDocumentTypes

Fortnox.WarehouseCustomInboundDocuments

Fortnox.WarehouseCustomOutboundDocuments

Fortnox.WarehouseIncomingGoods

Fortnox.WarehouseManualDocuments

Fortnox.WarehouseManualInboundDocuments

Fortnox.WarehouseManualOutboundDocuments

Fortnox.WarehouseProductionOrders

Fortnox.WarehousePurchaseOrders

Fortnox.WarehouseStockPoints

Fortnox.WarehouseStockStatuses

Fortnox.WarehouseStockTakings

Fortnox.WarehouseStockTransfers

Fortnox.WarehouseTenants

Fortnox.WayOfDeliveries

Sample Queries

--
-- Fortnox Sample Query Accounts
--
-- Table documentation: https://documentation.invantive.eu/2017R2/fortnox-data-model/webhelp/index.html
--
select *
from   Fortnox.Accounts.Accountsact@fnx
limit  100
--
-- Fortnox Sample Query Accounts
--
-- Table documentation: https://documentation.invantive.eu/2017R2/fortnox-data-model/webhelp/index.html
--
select *
from   Fortnox.Projects.Projectspjt@fnx
limit  100
--
-- Fortnox Sample Query Me
--
-- Table documentation: https://documentation.invantive.eu/2017R2/fortnox-data-model/webhelp/index.html
--
select *
from   Fortnox.Me.Meme@fnx
limit  100

Attributes

The attributes of this platform are on the page Attributes.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: