Fortnox Data Model
Het Fortnox ERP-systeem biedt cloudgebaseerde tools voor boekhouding, facturering, salarisadministratie en voorraadbeheer, waardoor kleine bedrijven processen efficiënt kunnen automatiseren.
Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/fortnox
Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.
Platform
- Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
- Type: een applicatie die via de API toegankelijk is.
- De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
- Met één Query kunnen meerdere bedrijven tegelijk worden opgehaald.
- 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.
Cijfers
| Figure | Count |
|---|---|
| Tables | 248 |
| Columns | 6,184 |
| Tabeller med invoegsel | 51 |
| Tabeller med update | 39 |
| Tabellen met de functie 'verwijderen' | 28 |
| Tabeller gedocumenteerd | 118 |
Poster met datamodel
Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden
Overige
Accounts, Expenses, PredefinedAccounts, PredefinedVoucherSeries, VoucherSeries, Vouchers
Account (zonder relaties)
Factuur (zonder relaties)
Mij (zonder relaties)
NATIVEPLATFORMSCALARREQUESTS (zonder relaties)
SIEType (zonder relaties)
Sie (zonder relaties)
SieAnnualBalanceFiles, SieItemBalanceFiles, SiePeriodBalanceFiles, SieTransactionFiles
Leverancier (zonder relaties)
Voucher (zonder relaties)
Relaties
- Expenses → Accounts (kandidaat): 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 (kandidaat): 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 (kandidaat): 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 (in woorden beschreven): 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.
Tabellen
Fortnox.AbsenceTransactions
- AbsenceTransactionById: Absence Transaction by ID
- AbsenceTransactionsByEmployeeId: Absence Transactions by Employee ID
- AbsenceTransactionsByEmployeeIdAndDateAndCode: Absence Transactions by Employee ID, Date and Code
Fortnox.AccountCharts
- AccountCharts: Account Charts
Fortnox.Accounts
- AccountByNumber: Account by Number
- AccountOpeningQuantitiesByAccountNumber: Account Opening Quantities by Account Number
- Accounts: Accounts
Fortnox.Archive
- Archive: Archive
- ArchiveById: Archive by ID
- ArchiveFiles: Archive Files
- ArchiveFolders: Archive Folders
Fortnox.ArticleFileConnections
- ArticleFileConnectionById: Article File Connection by ID
- ArticleFileConnections: Article File Connections
Fortnox.ArticleUrlConnections
- ArticleUrlConnectionById: Article URL Connection by ID
- ArticleUrlConnections: Article URL Connections
Fortnox.Articles
- ArticleByNumber: Article by Number
- Articles: Articles
Fortnox.AssetFileConnection
- AssetFileConnectors: Asset File Connectors
Fortnox.AssetTypes
- AssetTypeById: Asset Type by ID
- AssetTypes: Asset Types
Fortnox.Assets
- AssetByGivenNumber: Asset by Given Number
- AssetHistoryByGivenAssetNumber: Asset History by Given Asset Number
- Assets: Assets
- Deprecations: Deprecations
Fortnox.AttendanceTransactions
- ArticleUrlConnectionByEmployeeIdAndDateAndCode: Article URL Connection by Employee ID, Date and Code
- AttendanceTransactionById: Attendance Transaction by ID
- AttendanceTransactions: Attendance Transactions
Fortnox.CodeValues
- SIETypes: Domain SIETypes
Fortnox.CompanyInformation
- CompanyInformation: Company Information
Fortnox.CompanySettings
- CompanySettings: Company Settings
Fortnox.ContractAccruals
- ContractAccrualByDocumentNumber: Contract Accrual by Document Number
- ContractAccrualLinesByDocumentNumber: Contract Accrual Lines by Document Number
- ContractAccruals: Contract Accruals
Fortnox.ContractTemplates
- ContractTemplateByTemplateNumber: Contract Template by Template Number
- ContractTemplateInvoiceLinesByTemplateNumber: Contract Template Invoice Lines by Template Number
- ContractTemplates: Contract Templates
Fortnox.Contracts
- ContractByDocumentNumber: Contract by Document Number
- ContractInvoiceLinesByDocumentNumber: Contract Invoice Lines by Document Number
- Contracts: Contracts
Fortnox.CostCenters
- CostCenterByCode: Cost Centre by Code
- CostCenters: Cost Centres
Fortnox.Currencies
- Currencies: Currencies
- CurrencyByCode: Currency by Code
Fortnox.CustomerReferences
- CustomerReferenceById: Customer Reference by ID
- CustomerReferenceLines: Customer Reference Lines
- CustomerReferenceLinesByReferenceId: Customer Reference Lines by Reference ID
- CustomerReferences: Customer References
Fortnox.Customers
- CustomerByNumber: Customer by Number
- Customers: Customers
Fortnox.EUVatLimitRegulation
- EUVatLimitRegulationByYear: EU Vat Limit Regulation by Year
Fortnox.Employees
- EmployeeById: Employee by ID
- EmployeeCategories: itgen_fnx_employeecategories_plural
- EmployeeCategoriesByEmployeeId: itgen_fnx_employeecategoriesbyemployeeid_plural
- EmployeeChildren: Employee Children
- EmployeeChildrenByEmployeeId: Employee Children by Employee ID
- EmployeeDatedSchedules: Employee Dated Schedules
- EmployeeDatedSchedulesByEmployeeId: Employee Dated Schedules by Employee ID
- EmployeeDatedWages: Employee Dated Wages
- EmployeeDatedWagesByEmployeeId: Employee Dated Wages by Employee ID
- EmployeeOpeningSalaries: itgen_fnx_employeeopeningsalaries_plural
- EmployeeOpeningSalariesByEmployeeId: itgen_fnx_employeeopeningsalariesbyemployeeid_plural
- Employees: Employees
Fortnox.Expenses
- ExpenseByCode: Expense by Code
- Expenses: Expenses
Fortnox.FileAttachments
- AttachmentCountByEntityType: Attachment Count by Entity Type
- AttachmentsByEntityType: Attachments by Entity Type
Fortnox.FinanceInvoices
- FinancialInvoiceByNumber: Financial Invoice by Number
Fortnox.FinancialYears
- FinancialYearById: Financial Year by ID
- FinancialYears: Financial Years Plural
Fortnox.Inbox
- Inbox: Inbox
- InboxById: Inbox by ID
- InboxFiles: Inbox Files
- InboxFolders: Inbox Folders
Fortnox.IntegrationDeveloperRatings
- Ratings: Ratings
Fortnox.IntegrationDeveloperSales
- IntegrationSalesByIntegrationId: Integration Sales by Integration ID
Fortnox.IntegrationDeveloperUsers
- UsersByIntegrationIdAndTenantId: itgen_fnx_usersbyintegrationidandtenantid_plural
Fortnox.IntegrationPartnerSales
- AppSaleTenantPurchasesByAppIdAndTenantId: App Sale Tenant Purchases by App ID and Tenant ID
- AppSaleTenantTerminationsByAppIdAndTenantId: App Sale Tenant Terminations by App ID and Tenant ID
- AppSaleTenantUsersByAppIdAndTenantId: App Sale Tenant Users by App ID and Tenant ID
- AppSaleTenantsByAppIdAndTenantId: App Sale Tenants by App ID and Tenant ID
- AppSalesByAppId: App Sales by App ID
- AppSalesByAppIdAndTenantId: App Sales by App ID and Tenant ID
- AppSalesTenantPurchasesByAppId: App Sales Tenant Purchases by App ID
- AppSalesTenantTerminationsByAppId: App Sales Tenant Terminations by App ID
- AppSalesTenantUsersByAppId: App Sales Tenant Users by App ID
- AppSalesTenantsByAppId: App Sales Tenants by App ID
Fortnox.InvoiceAccruals
- InvoiceAccrualLinesByInvoiceNumber: Invoice Accrual Lines by Invoice Number
- InvoiceAccruals: Invoice Accruals
- InvoiceAccrualsByInvoiceNumber: Invoice Accruals by Invoice Number
Fortnox.InvoicePayments
- InvoicePaymentByNumber: Invoice Payment by Number
- InvoicePaymentWriteOffsByPaymentNumber: Invoice Payment Write-offs by Payment Number
- InvoicePayments: Invoice Payments
Fortnox.Invoices
- InvoiceByDocumentNumber: Invoice by Document Number
- InvoiceEmailByDocumentNumber: Invoice Email by Document Number
- InvoiceEmailInvoiceLabelsByDocumentNumber: Invoice Email Invoice Labels by Document Number
- InvoiceEmailInvoiceLinesByDocumentNumber: Invoice Email Invoice Lines by Document Number
- InvoiceLabelsByDocumentNumber: Invoice Labels by Document Number
- InvoiceLinesByDocumentNumber: Invoice Lines by Document Number
- InvoicePreviewByDocumentNumber: Invoice Preview by Document Number
- InvoicePrintByDocumentNumber: Invoice Print by Document Number
- Invoices: Invoices
Fortnox.Labels
- Labels: Labels
Fortnox.LockedPeriod
- LockedPeriods: Locked Periods
Fortnox.Me
- Me: Me
Fortnox.ModesOfPayments
- PaymentMethodByCode: Payment Method by Code
- PaymentModes: Payment Modes
Fortnox.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
Fortnox.Offers
- OfferByDocumentNumber: Offer by Document Number
- OfferLabelsByDocumentNumber: Offer Labels by Document Number
- OfferLinesByDocumentNumber: Offer Lines by Document Number
- Offers: Offers
Fortnox.Orders
- OrderByDocumentNumber: Order by Document Number
- OrderLabelsByDocumentNumber: Order Labels by Document Number
- OrderLinesByDocumentNumber: Order Lines by Document Number
- Orders: Orders
Fortnox.PredefinedAccounts
- PredefinedAccountByName: Predefined Account by Name
- PredefinedAccounts: Predefined Accounts
Fortnox.PredefinedVoucherSeries
- PredefinedVoucherSeries: Predefined Voucher Series
- PredefinedVoucherSeriesByName: Predefined Voucher Series by Name
Fortnox.PriceLists
- PriceListByCode: Pricelist by Code
- PriceLists: Pricelists
Fortnox.Prices
- ArticleFirstPriceByPriceListAndArticleNumber: Article First Price by Pricelist and Article Number
- ArticlePriceByPriceListAndArticleNumberAndQuantity: Article Price by Pricelist, Article Number and Quantity
- Prices: Prices
- Prices2: Prices
Fortnox.PrintTemplates
- PrintTemplates: Print Templates
Fortnox.Projects
- ProjectByProjectNumber: Project by Number
- Projects: Projects
Fortnox.RecurringBillingDeviations
- RecurringDeviationAccrualLinesById: itgen_fnx_recurringdeviationaccruallinesbyid_plural
- RecurringDeviationAccrualLinesByRecurringId: itgen_fnx_recurringdeviationaccruallinesbyrecurringid_plural
- RecurringDeviationById: itgen_fnx_recurringdeviationbyid_plural
- RecurringDeviationLinesById: itgen_fnx_recurringdeviationlinesbyid_plural
- RecurringDeviationLinesByRecurringId: itgen_fnx_recurringdeviationlinesbyrecurringid_plural
- RecurringDeviationsByRecurringId: itgen_fnx_recurringdeviationsbyrecurringid_plural
Fortnox.RecurringBillingInvoiceRequests
- InvoiceRequestById: itgen_fnx_invoicerequestbyid_plural
- InvoiceRequestItemErrorsById: itgen_fnx_invoicerequestitemerrorsbyid_plural
- InvoiceRequestItemInvoiceNumbersById: itgen_fnx_invoicerequestiteminvoicenumbersbyid_plural
- InvoiceRequestItemsById: itgen_fnx_invoicerequestitemsbyid_plural
Fortnox.RecurringBillings
- RecurringAccrualLinesById: itgen_fnx_recurringaccruallinesbyid_plural
- RecurringById: itgen_fnx_recurringbyid_plural
- RecurringErrorLogsById: itgen_fnx_recurringerrorlogsbyid_plural
- RecurringLinesById: itgen_fnx_recurringlinesbyid_plural
- RecurringTaxReductionsById: itgen_fnx_recurringtaxreductionsbyid_plural
- Recurrings: itgen_fnx_recurrings_plural
Fortnox.SIE
- SieFileByType: SIE File by Type
Fortnox.SalaryTransactions
- SalaryTransactionByRow: Salary Transaction by Row
- SalaryTransactions: Salary Transactions
Fortnox.ScheduleTimes
- ScheduleTimeByEmployeeIdAndDate: Schedule Time by Employee ID and Date
Fortnox.SupplierInvoiceAccruals
- SupplierInvoiceAccrualByInvoiceNumber: Supplier Invoice Accrual by Invoice Number
- SupplierInvoiceAccrualLinesByInvoiceNumber: Supplier Invoice Accrual Lines by Invoice Number
- SupplierInvoiceAccruals: Supplier Invoice Accruals
Fortnox.SupplierInvoiceExternalUrlConnections
- SupplierInvoiceExternalUrlConnectionById: Supplier Invoice External URL Connection by ID
Fortnox.SupplierInvoiceFileConnections
- SupplierInvoiceFileConnectionByFileId: Supplier Invoice File Connection by File ID
- SupplierInvoiceFileConnections: Supplier Invoice File Connections
Fortnox.SupplierInvoicePayments
- SupplierInvoicePaymentByInvoicePaymentNumber: Supplier Invoice Payment by Invoice Payment Number
- SupplierInvoicePaymentWriteOffsByInvoicePaymentNumber: Supplier Invoice Payment Write-offs by Invoice Payment Number
- SupplierInvoicePayments: Supplier Invoice Payments
Fortnox.SupplierInvoices
- SupplierInvoiceByGivenNumber: Supplier Invoice by Given Number
- SupplierInvoiceLinesByGivenNumber: Supplier Invoice Lines by Given Number
- SupplierInvoiceVouchers: Supplier Invoice Vouchers
- SupplierInvoiceVouchersByGivenNumber: Supplier Invoice Vouchers by Given Number
- SupplierInvoices: Supplier Invoices
Fortnox.Suppliers
- SupplierByNumber: Supplier by Number
- Suppliers: Suppliers
Fortnox.TaxReductions
- TaxReductionAmounts: itgen_fnx_taxreductionamounts_plural
- TaxReductionAmountsByTaxReductionId: Tax Reduction Amounts by Tax Reduction ID
- TaxReductionById: Tax Reduction by ID
- TaxReductions: Tax Reductions
Fortnox.TermsOfDeliveries
- DeliveryTermByCode: Delivery Term by Code
- DeliveryTerms: Delivery Terms
Fortnox.TermsOfPayments
- PaymentTermByCode: Payment Term by Code
- PaymentTerms: Payment Terms
Fortnox.TimeReportingArticles
- TimeReportingArticleRegistrationSalesPrices: Time Reporting Article Registration Sales Prices
- TimeReportingArticleRegistrations: Time Reporting Article Registrations
- TimeReportingArticles: Time Reporting Articles
- TimeReportingRegisteredArticleSalesPrices: Time Reporting Registered Article Sales Prices
Fortnox.TimeReportingRegistrations
- TimeReportingRegistrationServiceSalesPrices: Time Reporting Registration Service Sales Prices
- TimeReportingRegistrations: Time Reporting Registrations
Fortnox.TrustedEmailSenders
- RejectedSenders: Rejected Senders
- Senders: Senders
- TrustedSenders: Trusted Senders
Fortnox.Units
- UnitByCode: Unit by Code
- Units: Units
Fortnox.VacationDebtBasis
- VacationDebtBasisByYearAndMonth: Vacation Debt Basis by Year and Month
- VacationDebtBasisEmployeesByYearAndMonth: Vacation Debt Basis Employees by Year and Month
Fortnox.Views
- AccountActiveBalances: Fortnox Active Account Balances
- InvoiceLines: Fortnox Invoice Lines
- SieAnnualBalanceFiles: Fortnox Sie Annual Balance Files
- SieItemBalanceFiles: Fortnox Sie Item Balance Files
- SiePeriodBalanceFiles: Fortnox Sie Period Balance Files
- SieTransactionFiles: Fortnox Sie Transaction Files
- SupplierInvoiceLines: Fortnox Supplier Invoice Lines
- VoucherLines: Voucher Lines
- Vouchers: Vouchers
Fortnox.VoucherFileConnections
- VoucherFileConnectionByFileId: Voucher File Connection by File ID
- VoucherFileConnections: Voucher File Connections
Fortnox.VoucherSeries
- VoucherSeries: Voucher Series
- VoucherSeriesByCode: Voucher Series by Code
Fortnox.Vouchers
- VoucherLinesByVoucherSeriesAndVoucherNumber: Voucher Lines by Voucher Series and Voucher Number
- Vouchers: Vouchers
- VouchersByVoucherSeries: Vouchers by Voucher Series
- VouchersByVoucherSeriesAndVoucherNumber: Vouchers by Voucher Series and Voucher Number
- VouchersForCurrentFinancialYear: Vouchers for Current Financial Year
Fortnox.WarehouseCustomDocumentTypes
- CustomDocumentTypeByType: Custom Document Type by Type
- CustomDocumentTypes: Custom Document Types
Fortnox.WarehouseCustomInboundDocuments
- CustomInboundDocumentRows: Custom Inbound Document Rows
- CustomInboundDocuments: Custom Inbound Documents
Fortnox.WarehouseCustomOutboundDocuments
- CustomOutboundDocumentAverageCostsByTypeAndId: Custom Outbound Document Average Costs by Type and ID
- CustomOutboundDocumentByTypeAndId: Custom Outbound Document by Type and ID
- CustomOutboundDocumentLinesByTypeAndId: Custom Outbound Document Lines by Type and ID
Fortnox.WarehouseIncomingGoods
- IncomingGoodDocumentById: Incoming Good Document by ID
- IncomingGoodDocumentLinesById: Incoming Good Document Lines by ID
- IncomingGoodDocuments: Incoming Good Documents
Fortnox.WarehouseManualDocuments
- ManualDocuments: Manual Documents
Fortnox.WarehouseManualInboundDocuments
- ManualInboundDocumentRows: Manual Inbound Document Rows
- ManualInboundDocuments: Manual Inbound Documents
Fortnox.WarehouseManualOutboundDocuments
- ManualOutboundDocumentRows: Manual Outbound Document Rows
- ManualOutboundDocuments: Manual Outbound Documents
Fortnox.WarehouseProductionOrders
- ProductionOrderDocumentById: Production Order Document by ID
- ProductionOrderDocumentPackageItemsById: Production Order Document Package Items by ID
- ProductionOrderPackageItems: Production Order Package Items
- ProductionOrders: Production Orders
- RequiredProductionPartsByItemId: Required Production Parts by Item ID
Fortnox.WarehousePurchaseOrders
- MatchedDocumentsByPurchaseOrderId: Matched Documents by Purchase Order ID
- ProductionOrderRowNotes: Production Order Row Notes
- PurchaseOrderAttachedNotesByPurchaseOrderId: Purchase Order Attached Notes by Purchase Order ID
- PurchaseOrderById: Purchase Order by ID
- PurchaseOrderCsvReports: Purchase Order CSV Reports Plural
- PurchaseOrderLinesById: Purchase Order Lines by ID
- PurchaseOrderRowNotesById: Purchase Order Row Notes by ID
- PurchaseOrderRows: Purchase Order Rows
- PurchaseOrders: Purchase Orders
Fortnox.WarehouseStockPoints
- MultiStockLocations: Multi-stock Locations
- MultiStockpoints: Multi-stock Points
- StockLocations2ByStockPointId: Stock Locations2 by Stockpoint ID
- StockLocationsByStockPointId: Stock Locations by Stockpoint ID
- StockPointById: Stockpoint by ID
- StockPoints: Stockpoints
- StockpointLocations: Stockpoint Locations
Fortnox.WarehouseStockStatuses
- StockBalances: Stock Balances
Fortnox.WarehouseStockTakings
- StockTakingCandidatesByParameters: itgen_fnx_stocktakingcandidatesbyparameters_plural
- StockTakingLinesByDocumentId: Stock Taking Lines by Document ID
- StockTakings: Stock Takings
- StockTakings2ByParameters: itgen_fnx_stocktakings2byparameters_plural
- StockTakingsByDocumentId: Stock Takings by Document ID
- StockTakingsByParameters: itgen_fnx_stocktakingsbyparameters_plural
Fortnox.WarehouseStockTransfers
- StockTransferDocumentLinesById: Stock Transfer Document Lines by ID
- StockTransferDocumentsById: Stock Transfer Documents by ID
Fortnox.WarehouseTenants
- HasWarehouseFeatures: Has Warehouse Features
Fortnox.WayOfDeliveries
- DeliveryMethodByCode: Delivery Method by Code
- DeliveryMethods: Delivery Methods
Voorbeeldqueries
--
-- 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
Attributen
The attributes of this platform are on the page Attributes.
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: