Fortnox Data Model
Il sistema ERP Fortnox offre strumenti basati sul cloud per la contabilità, la fatturazione, la gestione delle buste paga e la gestione delle scorte, consentendo alle piccole imprese di automatizzare i processi in modo efficiente.
Configura questa piattaforma su Invantive Cloud: https://cloud.invantive.com/fortnox
I confronti tra testi su questa piattaforma tengono conto delle maiuscole e delle minuscole.
Piattaforma
- Utilizzabile da: Invantive Cloud e dai prodotti Invantive installati sul proprio computer o server.
- Tipo: un'applicazione accessibile tramite la propria API.
- I dati sono suddivisi, ad esempio per azienda o per amministrazione.
- Una query può leggere i dati di più aziende contemporaneamente.
- 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.
Figure
| Figure | Count |
|---|---|
| Tables | 248 |
| Columns | 6,184 |
| Tabella con inserti | 51 |
| Tabella con aggiornamento | 39 |
| Tabella con la clausola DELETE | 28 |
| Tabella documentata | 118 |
Poster sul modello di dati
Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.
Il poster come testo: tabelle per argomento e le loro relazioni
Altro
Accounts, Expenses, PredefinedAccounts, PredefinedVoucherSeries, VoucherSeries, Vouchers
Conto (senza relazioni)
Fattura (senza relazioni)
Io (senza relazioni)
NATIVEPLATFORMSCALARREQUESTS (senza relazioni)
SIEType (senza relazioni)
Sie (senza relazioni)
SieAnnualBalanceFiles, SieItemBalanceFiles, SiePeriodBalanceFiles, SieTransactionFiles
Fornitore (senza relazioni)
Voucher (senza relazioni)
Relazioni
- Expenses → Accounts (candidato): 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 (candidato): 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 (candidato): 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 (descritto a parole): 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.
Tabelle
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
Esempi di Query
--
-- 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
Attributi
The attributes of this platform are on the page Attributes.
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: