invantive documentation
Invantive Support ForumsLog In / Sign Up

Visma.net Financials Data Model

Visma.net Financials is online software for accounting. Visma.net is used both by large accounting firms as well as large entrepreneurs.

Please make sure your user is authorized to use the API when no companies are listed in AvailableContext. Typically the user needs the following user roles: 'Financials User' and 'Financials Administrator'. Test the privileges using https://api.finance.visma.net/API-index/index.html and choosing the 'Authorize' button. When successfully authorized, the Authorize button should be replaced by a 'Logout' button. In case of a JSON error message contact your application administrator.

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

The data is partitioned per Company (COMPANY_CODE).

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.
  • Data can be written as well as read.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.

Figures

Figure Count
Tables 1,018
Columns 73,267
Tables with insert 58
Tables with update 14
Tables with delete 1
Tables documented 402

Data Model Poster

PDF, 2 A0 sheets

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

Visma.net Financials data model, Sheet 1 of 2Visma.net Financials data modelfor use with Invantive UniversalSQLRelease 27.1.3-BETA+6294 · 01-11-2026Customer · CustomerInvoice · CustomerCreditNote · CustomerDebitNote · CustomerOverdueCharge · Supplier · PurchaseOrder · Project · CashSale · Purchase…Sheet 1 of 2 · documentation.invantive.euCustomer×2×2VismaNet.Customer.CustomerAttributes: Customer AttributesCustomerAttributesVismaNet.Country.CountriesCVismaNet.Customer.CustomerBalances: Customer BalancesCustomerBalancesVismaNet.Customer.CustomerClassAttributeDetails: Customer Class Attribute DetailsCustomerClassAttributeDetailsVismaNet.Customer.CustomerClassAttributes: Customer Class AttributesCustomerClassAttributesVismaNet.Customer.CustomerClasses: Customer ClassesCustomerClassesVismaNet.Customer.CustomerDirectDebitLines: Customer Direct Debit LinesCustomerDirectDebitLinesVismaNet.Country.CountriesCVismaNet.Customer.CustomerPaymentMethods: Customer Payment MethodsCustomerPaymentMethodsVismaNet.Country.CountriesCVismaNet.Customer.Customers: CustomersCustomersVismaNet.Country.CountriesCVismaNet.CreditTerm.CreditTermRecords: Credit Term RecordsCreditTermRecordsCreditTermVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.PaymentMethod.PaymentMethods: Payment MethodsPaymentMethodsPaymentMethodVismaNet.VatZone.VatZones: VAT ZonesVatZonesVatZoneCustomerInvoiceVismaNet.CustomerInvoice.CustomerInvoiceApplications: Customer Invoice ApplicationsCustomerInvoiceApplicationsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerInvoice.CustomerInvoiceAttachments: Customer Invoice AttachmentsCustomerInvoiceAttachmentsVismaNet.CustomerInvoice.CustomerInvoiceLineAttachments: Customer Invoice Line AttachmentsCustomerInvoiceLineAttachmentsVismaNet.CustomerInvoice.CustomerInvoiceLineSubaccountSegments: Customer Invoice Line Subaccount SegmentsCustomerInvoiceLineSubaccountSeg…VismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerInvoice.CustomerInvoiceLines: Customer Invoice LinesCustomerInvoiceLinesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerInvoice.CustomerInvoiceSubaccountSegments: Customer Invoice Subaccount SegmentsCustomerInvoiceSubaccountSegmentsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerInvoice.CustomerInvoiceTaxDetails: Customer Invoice Tax DetailsCustomerInvoiceTaxDetailsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerInvoice.CustomerInvoices: Customer InvoicesCustomerInvoicesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.CreditTerm.CreditTermRecords: Credit Term RecordsCreditTermRecordsCreditTermVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCVismaNet.Inventory.InventoryItems: Inventory ItemsInventoryItemsInventoryVismaNet.PaymentMethod.PaymentMethods: Payment MethodsPaymentMethodsPaymentMethodVismaNet.Project.Projects: ProjectsProjectsProjectVismaNet.Branch.BranchesBVismaNet.VatZone.VatZones: VAT ZonesVatZonesVatZoneCustomerCreditNoteVismaNet.CustomerCreditNote.CustomerCreditNoteApplications: Customer Credit Note ApplicationsCustomerCreditNoteApplicationsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerCreditNote.CustomerCreditNoteAttachments: Customer Credit Note AttachmentsCustomerCreditNoteAttachmentsVismaNet.CustomerCreditNote.CustomerCreditNoteLineAttachments: Customer Credit Note Line AttachmentsCustomerCreditNoteLineAttachmentsVismaNet.CustomerCreditNote.CustomerCreditNoteLineSubaccountSegments: Customer Credit Note Line Subaccount SegmentsCustomerCreditNoteLineSubaccountS…VismaNet.CustomerCreditNote.CustomerCreditNoteLines: Customer Credit Note LinesCustomerCreditNoteLinesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerCreditNote.CustomerCreditNoteSubaccountSegments: Customer Credit Note Subaccount SegmentsCustomerCreditNoteSubaccountSeg…VismaNet.CustomerCreditNote.CustomerCreditNoteTaxDetails: Customer Credit Note Tax DetailsCustomerCreditNoteTaxDetailsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerCreditNote.CustomerCreditNotes: Customer Credit NotesCustomerCreditNotesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.CreditTerm.CreditTermRecords: Credit Term RecordsCreditTermRecordsCreditTermVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCVismaNet.PaymentMethod.PaymentMethods: Payment MethodsPaymentMethodsPaymentMethodVismaNet.Project.Projects: ProjectsProjectsProjectVismaNet.Branch.BranchesBVismaNet.VatZone.VatZones: VAT ZonesVatZonesVatZoneCustomerDebitNoteVismaNet.CustomerDebitNote.CustomerDebitNoteApplications: Customer Debit Note ApplicationsCustomerDebitNoteApplicationsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerDebitNote.CustomerDebitNoteAttachments: Customer Debit Note AttachmentsCustomerDebitNoteAttachmentsVismaNet.CustomerDebitNote.CustomerDebitNoteLineAttachments: Customer Debit Note Line AttachmentsCustomerDebitNoteLineAttachmentsVismaNet.CustomerDebitNote.CustomerDebitNoteLineSubaccountSegments: Customer Debit Note Line Subaccount SegmentsCustomerDebitNoteLineSubaccountS…VismaNet.CustomerDebitNote.CustomerDebitNoteLines: Customer Debit Note LinesCustomerDebitNoteLinesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerDebitNote.CustomerDebitNoteSubaccountSegments: Customer Debit Note Subaccount SegmentsCustomerDebitNoteSubaccountSegm…VismaNet.CustomerDebitNote.CustomerDebitNoteTaxDetails: Customer Debit Note Tax DetailsCustomerDebitNoteTaxDetailsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerDebitNote.CustomerDebitNotes: Customer Debit NotesCustomerDebitNotesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.CreditTerm.CreditTermRecords: Credit Term RecordsCreditTermRecordsCreditTermVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCVismaNet.PaymentMethod.PaymentMethods: Payment MethodsPaymentMethodsPaymentMethodVismaNet.Project.Projects: ProjectsProjectsProjectVismaNet.Branch.BranchesBVismaNet.VatZone.VatZones: VAT ZonesVatZonesVatZoneCustomerOverdueChargeVismaNet.CustomerOverdueCharge.CustomerOverdueChargeApplications: Customer Overdue Charge ApplicationsCustomerOverdueChargeApplicationsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerOverdueCharge.CustomerOverdueChargeAttachments: Customer Overdue Charge AttachmentsCustomerOverdueChargeAttachmentsVismaNet.CustomerOverdueCharge.CustomerOverdueChargeLineAttachments: itgen_vnet_customeroverduechargelineattachments_pluralCustomerOverdueChargeLineAttach…VismaNet.CustomerOverdueCharge.CustomerOverdueChargeLines: itgen_vnet_customeroverduechargelines_pluralCustomerOverdueChargeLinesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerOverdueCharge.CustomerOverdueChargeSubAccountSegmentLines: itgen_vnet_customeroverduechargesubaccountsegmentlines_pluralCustomerOverdueChargeSubAccount…VismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerOverdueCharge.CustomerOverdueChargeSubAccountSegments: itgen_vnet_customeroverduechargesubaccountsegments_pluralCustomerOverdueChargeSubAccount…VismaNet.CustomerOverdueCharge.CustomerOverdueChargeTaxDetails: itgen_vnet_customeroverduechargetaxdetails_pluralCustomerOverdueChargeTaxDetailsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerOverdueCharge.CustomerOverdueCharges: Customer Overdue ChargesCustomerOverdueChargesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.CreditTerm.CreditTermRecords: Credit Term RecordsCreditTermRecordsCreditTermVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCVismaNet.PaymentMethod.PaymentMethods: Payment MethodsPaymentMethodsPaymentMethodVismaNet.Project.Projects: ProjectsProjectsProjectVismaNet.Branch.BranchesBVismaNet.VatZone.VatZones: VAT ZonesVatZonesVatZoneSupplier×2×2VismaNet.Supplier.SupplierAttributes: Supplier AttributesSupplierAttributesVismaNet.Country.CountriesCVismaNet.Supplier.SupplierBalances: Supplier BalancesSupplierBalancesVismaNet.Supplier.SupplierClasses: Supplier ClassesSupplierClassesVismaNet.Supplier.SupplierPOBalances: Supplier PO BalancesSupplierPOBalancesVismaNet.Supplier.SupplierPaymentMethodDetails: Supplier Payment Method DetailsSupplierPaymentMethodDetailsVismaNet.Country.CountriesCVismaNet.Supplier.Suppliers: SuppliersSuppliersVismaNet.Country.CountriesCVismaNet.CreditTerm.CreditTermRecords: Credit Term RecordsCreditTermRecordsCreditTermVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.PaymentMethod.PaymentMethods: Payment MethodsPaymentMethodsPaymentMethodVismaNet.VatZone.VatZones: VAT ZonesVatZonesVatZonePurchaseOrder×2×2×2×2×2×2VismaNet.PurchaseOrder.PurchaseOrderDiscountDetails: Purchase Order Discount DetailsPurchaseOrderDiscountDetailsVismaNet.Branch.BranchesBVismaNet.PurchaseOrder.PurchaseOrderLineSubsegments: Purchase Order Line SubsegmentsPurchaseOrderLineSubsegmentsVismaNet.Branch.BranchesBVismaNet.PurchaseOrder.PurchaseOrderLines: Purchase Order LinesPurchaseOrderLinesVismaNet.Branch.BranchesBVismaNet.PurchaseOrder.PurchaseOrderReceipts: Purchase Order ReceiptsPurchaseOrderReceiptsVismaNet.Branch.BranchesBVismaNet.PurchaseOrder.PurchaseOrderTaxDetails: Purchase Order Tax DetailsPurchaseOrderTaxDetailsVismaNet.Branch.BranchesBVismaNet.PurchaseOrder.PurchaseOrders: Purchase OrdersPurchaseOrdersVismaNet.Branch.BranchesBVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.CreditTerm.CreditTermRecords: Credit Term RecordsCreditTermRecordsCreditTermVismaNet.Inventory.InventoryItems: Inventory ItemsInventoryItemsInventoryVismaNet.Supplier.Suppliers: SuppliersSuppliersSupplierVismaNet.Country.CountriesCVismaNet.VatZone.VatZones: VAT ZonesVatZonesVatZoneVismaNet.Warehouse.Warehouses: WarehousesWarehousesWarehouseVismaNet.Branch.BranchesBProject×2×2×2×2×2×2VismaNet.Project.ProjectAttributes: Project AttributesProjectAttributesVismaNet.Branch.BranchesBVismaNet.Project.ProjectEmployees: Project EmployeesProjectEmployeesVismaNet.Branch.BranchesBVismaNet.Project.ProjectTaskAttributes: itgen_vnet_projecttaskattributes_pluralProjectTaskAttributesVismaNet.Branch.BranchesBVismaNet.Project.ProjectTaskEmployees: Project Task EmployeesProjectTaskEmployeesVismaNet.Branch.BranchesBVismaNet.Project.ProjectTasks: Project TasksProjectTasksVismaNet.Branch.BranchesBVismaNet.Project.Projects: ProjectsProjectsVismaNet.Branch.BranchesBVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCCashSaleVismaNet.CashSale.CashSaleApplications: Cash Sale ApplicationsCashSaleApplicationsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CashSale.CashSaleLineSubaccountSegments: Cash Sales Line Subaccount SegmentsCashSaleLineSubaccountSegmentsVismaNet.CashSale.CashSaleLines: Cash Sale LinesCashSaleLinesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CashSale.CashSaleSubaccountSegments: Cash Sale Subaccount SegmentsCashSaleSubaccountSegmentsVismaNet.CashSale.CashSales: Cash SalesCashSalesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.CreditTerm.CreditTermRecords: Credit Term RecordsCreditTermRecordsCreditTermVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCVismaNet.PaymentMethod.PaymentMethods: Payment MethodsPaymentMethodsPaymentMethodVismaNet.Project.Projects: ProjectsProjectsProjectVismaNet.Branch.BranchesBPurchaseOrderBasic×2×2×2×2×2VismaNet.PurchaseOrderBasic.BasicPurchaseOrderLines: Basic Purchase Order LinesBasicPurchaseOrderLinesVismaNet.Branch.BranchesBVismaNet.PurchaseOrderBasic.BasicPurchaseOrderReceipts: Basic Purchase Order ReceiptsBasicPurchaseOrderReceiptsVismaNet.Branch.BranchesBVismaNet.PurchaseOrderBasic.BasicPurchaseOrderTaxDetails: Basic Purchase Order Tax DetailsBasicPurchaseOrderTaxDetailsVismaNet.Branch.BranchesBVismaNet.PurchaseOrderBasic.BasicPurchaseOrders: Basic Purchase OrdersBasicPurchaseOrdersVismaNet.Branch.BranchesBVismaNet.PurchaseOrderBasic.PurchaseOrderLinesSubsegments: Purchase Order Lines SubsegmentsPurchaseOrderLinesSubsegmentsVismaNet.Branch.BranchesBVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.Inventory.InventoryItems: Inventory ItemsInventoryItemsInventoryVismaNet.Supplier.Suppliers: SuppliersSuppliersSupplierVismaNet.Country.CountriesCVismaNet.Warehouse.Warehouses: WarehousesWarehousesWarehouseVismaNet.Branch.BranchesBSupplierInvoice×2×2×2×2×2VismaNet.SupplierInvoice.SupplierInvoiceLandedCosts: itgen_vnet_supplierinvoicelandedcosts_pluralSupplierInvoiceLandedCostsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.SupplierInvoice.SupplierInvoiceLines: Supplier Invoice LinesSupplierInvoiceLinesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.SupplierInvoice.SupplierInvoiceTaxDetailLines: Supplier Invoice Tax Detail LinesSupplierInvoiceTaxDetailLinesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.SupplierInvoice.SupplierInvoices: Supplier InvoicesSupplierInvoicesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.CreditTerm.CreditTermRecords: Credit Term RecordsCreditTermRecordsCreditTermVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.PaymentMethod.PaymentMethods: Payment MethodsPaymentMethodsPaymentMethodVismaNet.Supplier.Suppliers: SuppliersSuppliersSupplierVismaNet.Country.CountriesCVismaNet.VatZone.VatZones: VAT ZonesVatZonesVatZoneCustomerCreditWriteOffVismaNet.CustomerCreditWriteOff.CustomerCreditWriteOffSubAccountSegments: Customer Credit Write-off Sub Account SegmentsCustomerCreditWriteOffSubAccountS…VismaNet.CustomerCreditWriteOff.CustomerCreditWriteOffs: Customer Credit Write-offsCustomerCreditWriteOffsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCVismaNet.PaymentMethod.PaymentMethods: Payment MethodsPaymentMethodsPaymentMethodVismaNet.Project.Projects: ProjectsProjectsProjectVismaNet.Branch.BranchesBVismaNet.VatZone.VatZones: VAT ZonesVatZonesVatZoneShipment×3×3×2×2×2×2VismaNet.Shipment.ShipmentDetailLineAllocations: Shipment Detail Line AllocationsShipmentDetailLineAllocationsVismaNet.Country.CountriesCVismaNet.Shipment.ShipmentDetailLines: Shipment Detail LinesShipmentDetailLinesVismaNet.Country.CountriesCVismaNet.Shipment.ShipmentOrderLines: Shipment Order LinesShipmentOrderLinesVismaNet.Country.CountriesCVismaNet.Shipment.ShipmentPackageLines: Shipment Package LinesShipmentPackageLinesVismaNet.Country.CountriesCVismaNet.Shipment.Shipments: ShipmentsShipmentsVismaNet.Country.CountriesCVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCVismaNet.Warehouse.Warehouses: WarehousesWarehousesWarehouseVismaNet.Branch.BranchesBCustomerDocumentVismaNet.CustomerDocument.CustomerDocumentSubaccountSegments: Customer Document Subaccount SegmentsCustomerDocumentSubaccountSegm…VismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CustomerDocument.CustomerDocuments: Customer DocumentsCustomerDocumentsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCVismaNet.PaymentMethod.PaymentMethods: Payment MethodsPaymentMethodsPaymentMethodVismaNet.Project.Projects: ProjectsProjectsProjectVismaNet.Branch.BranchesBSalesOrder×2VismaNet.SalesOrder.SalesOrders: Sales OrdersSalesOrdersVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.CreditTerm.CreditTermRecords: Credit Term RecordsCreditTermRecordsCreditTermVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCVismaNet.PaymentMethod.PaymentMethods: Payment MethodsPaymentMethodsPaymentMethodVismaNet.VatZone.VatZones: VAT ZonesVatZonesVatZoneVismaNet.Warehouse.Warehouses: WarehousesWarehousesWarehouseVismaNet.Branch.BranchesBCustomerPaymentVismaNet.CustomerPayment.CustomerPaymentLines: Customer Payment LinesCustomerPaymentLinesVismaNet.Country.CountriesCVismaNet.CustomerPayment.CustomerPaymentOrdersToApply: Customer Payment Orders to ApplyCustomerPaymentOrdersToApplyVismaNet.Country.CountriesCVismaNet.CustomerPayment.CustomerPayments: Customer PaymentsCustomerPaymentsVismaNet.Country.CountriesCVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCVismaNet.PaymentMethod.PaymentMethods: Payment MethodsPaymentMethodsPaymentMethodCashTransaction×3VismaNet.CashTransaction.CashTransactionDetailOffsetSubAccountSegments: Cash Transaction Detail Offset Subaccount SegmentsCashTransactionDetailOffsetSubAccou…VismaNet.CashTransaction.CashTransactionDetails: Cash Transaction DetailsCashTransactionDetailsVismaNet.Branch.BranchesBVismaNet.CashTransaction.CashTransactionTaxDetails: Cash Transaction Tax DetailsCashTransactionTaxDetailsVismaNet.CashTransaction.CashTransactions: Cash TransactionsCashTransactionsVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.Inventory.InventoryItems: Inventory ItemsInventoryItemsInventoryVismaNet.Project.Projects: ProjectsProjectsProjectVismaNet.Branch.BranchesBExpenseReceipt×2×2VismaNet.ExpenseReceipt.ExpenseReceiptClaimsByWorkGroupDescription: itgen_vnet_expensereceiptclaimsbyworkgroupdescription_pluralExpenseReceiptClaimsByWorkGroup…VismaNet.Branch.BranchesBVismaNet.ExpenseReceipt.ExpenseReceipts: Expense ReceiptsExpenseReceiptsVismaNet.Branch.BranchesBVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCVismaNet.Inventory.InventoryItems: Inventory ItemsInventoryItemsInventorySupplierDocument×2VismaNet.SupplierDocument.SupplierDocuments: Supplier DocumentsSupplierDocumentsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.PaymentMethod.PaymentMethods: Payment MethodsPaymentMethodsPaymentMethodVismaNet.Supplier.Suppliers: SuppliersSuppliersSupplierVismaNet.Country.CountriesCCashAccount×3VismaNet.CashAccount.CashAccountEntryTypes: Cash Account Entry TypesCashAccountEntryTypesVismaNet.CashAccount.CashAccountSubAccountSegments: itgen_vnet_cashaccountsubaccountsegments_pluralCashAccountSubAccountSegmentsVismaNet.CashAccount.CashAccounts: Cash AccountsCashAccountsVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.VatZone.VatZones: VAT ZonesVatZonesVatZoneCustomerContractVismaNet.CustomerContract.CustomerContractAttributes: Customer Contract AttributesCustomerContractAttributesVismaNet.CustomerContract.CustomerContractDetailsLines: Customer Contract Details LinesCustomerContractDetailsLinesVismaNet.CustomerContract.CustomerContracts: Customer ContractsCustomerContractsVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCInventoryIssueVismaNet.InventoryIssue.InventoryIssueLineAllocations: Inventory Issue Line AllocationsInventoryIssueLineAllocationsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.InventoryIssue.InventoryIssueLines: Inventory Issue LinesInventoryIssueLinesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.InventoryIssue.InventoryIssues: Inventory IssuesInventoryIssuesVismaNet.Branch.BranchesBVismaNet.Inventory.InventoryItems: Inventory ItemsInventoryItemsInventoryVismaNet.Warehouse.Warehouses: WarehousesWarehousesWarehouseVismaNet.Branch.BranchesBInventoryReceiptVismaNet.InventoryReceipt.InventoryReceiptLineAllocations: itgen_vnet_inventoryreceiptlineallocations_pluralInventoryReceiptLineAllocationsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.InventoryReceipt.InventoryReceiptLines: Inventory Receipt LinesInventoryReceiptLinesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.InventoryReceipt.InventoryReceipts: Inventory ReceiptsInventoryReceiptsVismaNet.Branch.BranchesBVismaNet.Inventory.InventoryItems: Inventory ItemsInventoryItemsInventoryVismaNet.Warehouse.Warehouses: WarehousesWarehousesWarehouseVismaNet.Branch.BranchesBInventoryTransfer×2×2×2VismaNet.InventoryTransfer.InventoryTransferLineAllocations: Inventor Transfer Line AllocationsInventoryTransferLineAllocationsVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.InventoryTransfer.InventoryTransferLines: Inventory Transfer LinesInventoryTransferLinesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.InventoryTransfer.InventoryTransfers: Inventory TransfersInventoryTransfersVismaNet.Branch.BranchesBVismaNet.Inventory.InventoryItems: Inventory ItemsInventoryItemsInventoryVismaNet.Warehouse.Warehouses: WarehousesWarehousesWarehouseVismaNet.Branch.BranchesBInventoryAdjustmentVismaNet.InventoryAdjustment.InventoryAdjustmentLines: Inventory Adjustment LinesInventoryAdjustmentLinesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.InventoryAdjustment.InventoryAdjustments: Inventory AdjustmentsInventoryAdjustmentsVismaNet.Branch.BranchesBVismaNet.Inventory.InventoryItems: Inventory ItemsInventoryItemsInventoryVismaNet.Warehouse.Warehouses: WarehousesWarehousesWarehouseVismaNet.Branch.BranchesBOrganizationVismaNet.Organization.Branches: BranchesBranchesVismaNet.Country.CountriesCVismaNet.Organization.Organization: OrganisationOrganizationVismaNet.Country.CountriesCVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.Ledger.Ledgers: LedgersLedgersLedgerVismaNet.Branch.BranchesBVismaNet.VatZone.VatZones: VAT ZonesVatZonesVatZoneBranchVismaNet.Branch.Branches: BranchesBranchesVismaNet.Country.CountriesCVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.Ledger.Ledgers: LedgersLedgersLedgerVismaNet.Branch.BranchesBVismaNet.VatZone.VatZones: VAT ZonesVatZonesVatZoneSalesOrderBasic×2VismaNet.SalesOrderBasic.BasicSalesOrderLines: Basic Sales Order LinesBasicSalesOrderLinesVismaNet.Branch.BranchesBVismaNet.Country.CountriesCVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCVismaNet.Inventory.InventoryItems: Inventory ItemsInventoryItemsInventoryVismaNet.Warehouse.Warehouses: WarehousesWarehousesWarehouseVismaNet.Branch.BranchesBExpenseClaim×2VismaNet.ExpenseClaim.ExpenseClaimDetails: Expense Claim DetailsExpenseClaimDetailsVismaNet.Branch.BranchesBVismaNet.ExpenseClaim.ExpenseClaims: Expense ClaimsExpenseClaimsVismaNet.Account.Accounts: General Ledger AccountsAccountsAccountVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCSupplierLocationVismaNet.SupplierLocation.SupplierLocationPaymentMethodDetails: itgen_vnet_supplierlocationpaymentmethoddetails_pluralSupplierLocationPaymentMethodDet…VismaNet.SupplierLocation.SupplierLocations: itgen_vnet_supplierlocations_pluralSupplierLocationsVismaNet.VatZone.VatZones: VAT ZonesVatZonesVatZoneSupplierPayment×2×2VismaNet.SupplierPayment.SupplierPaymentLines: Supplier Payment LinesSupplierPaymentLinesVismaNet.Country.CountriesCVismaNet.SupplierPayment.SupplierPayments: Supplier PaymentsSupplierPaymentsVismaNet.Country.CountriesCVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyVismaNet.Supplier.Suppliers: SuppliersSuppliersSupplierVismaNet.Country.CountriesCWarehouseVismaNet.Warehouse.WarehouseLocationPrimaryItemClassAttributeDetails: itgen_vnet_warehouselocationprimaryitemclassattributedetails_pluralWarehouseLocationPrimaryItemClas…VismaNet.Branch.BranchesBVismaNet.Warehouse.WarehouseLocationPrimaryItemClassAttributes: Warehouse Location Primary Item Class AttributesWarehouseLocationPrimaryItemClas…VismaNet.Branch.BranchesBVismaNet.Warehouse.WarehouseLocations: Warehouse LocationsWarehouseLocationsVismaNet.Branch.BranchesBVismaNet.Warehouse.Warehouses: WarehousesWarehousesVismaNet.Branch.BranchesBContractUsageVismaNet.ContractUsage.ContractUsageTransactions: Contract Usage TransactionsContractUsageTransactionsVismaNet.Branch.BranchesBVismaNet.Inventory.InventoryItems: Inventory ItemsInventoryItemsInventoryCurrencyRate×2VismaNet.CurrencyRate.CurrencyRate: Currency RatesCurrencyRateVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyCustomerPaym…VismaNet.CustomerPaymentMethod.CustomerPaymentMethodDetails: Customer Payment Method DetailsCustomerPaymentMethodDetailsVismaNet.PaymentMethod.PaymentMethods: Payment MethodsPaymentMethodsPaymentMethodLedgerVismaNet.Ledger.Ledgers: LedgersLedgersVismaNet.Branch.BranchesBVismaNet.Currency.Currencies: CurrenciesCurrenciesCurrencyLocationVismaNet.Location.Locations: LocationsLocationsVismaNet.VatZone.VatZones: VAT ZonesVatZonesVatZoneProjectBasicVismaNet.ProjectBasic.BasicProjects: Basic ProjectsBasicProjectsVismaNet.Customer.Customers: CustomersCustomersCustomerVismaNet.Country.CountriesCAccountVismaNet.Account.Accounts: General Ledger AccountsAccountsCountryVismaNet.Country.Countries: CountriesCountriesCreditTermVismaNet.CreditTerm.CreditTermRecords: Credit Term RecordsCreditTermRecordsCurrencyVismaNet.Currency.Currencies: CurrenciesCurrenciesEmployeeVismaNet.Employee.Employees: EmployeesEmployeesVismaNet.Branch.BranchesBInventoryVismaNet.Inventory.InventoryItems: Inventory ItemsInventoryItemsPaymentMethodVismaNet.PaymentMethod.PaymentMethods: Payment MethodsPaymentMethodsVatZoneVismaNet.VatZone.VatZones: VAT ZonesVatZonesCurrencyVismaNet.Currency.Currencies2: CurrenciesCurrencies2VismaNet.Currency.Currencies3: CurrenciesCurrencies3Visma.net FinancialsPlease make sure your user is authorized to use the API whenno companies are listed in AvailableContext. Typically the userneeds the following user roles: 'Financials User' and 'FinancialsAdministrator'. Test the privileges usinghttps://api.finance.visma.net/API-index/index.html andchoosing the 'Authorize' button. When successfully authorized,Data 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.TopicsAccount1Branch1CashAccount1CashSale1CashTransaction1ContractUsage1Country1CreditTerm1Currency1CurrencyRate1Customer1CustomerContract1CustomerCreditNote1CustomerCreditWriteOff1CustomerDebitNote1CustomerDocument1CustomerInvoice1CustomerOverdueCharge1CustomerPayment1CustomerPaymentMethod1Employee1ExpenseClaim1ExpenseReceipt1Inventory1InventoryAdjustment1InventoryIssue1InventoryReceipt1InventoryTransfer1Ledger1Location1Organization1PaymentMethod1Project1ProjectBasic1PurchaseOrder1PurchaseOrderBasic1SalesOrder1SalesOrderBasic1Shipment1Supplier1SupplierDocument1SupplierInvoice1SupplierLocation1SupplierPayment1VatZone1Warehouse1Tables without relations1, 2LegendTransactionalSetupTechnicalHard-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 relations between the same tablesLetters: refers to a table used by most topics: B = Branches, C = CountriesGenerated 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/vismanet
The poster as text: tables per topic and their relations

Customer

CustomerAttributes, CustomerBalances, CustomerClassAttributeDetails, CustomerClassAttributes, CustomerClasses, CustomerDirectDebitLines, CustomerPaymentMethods, Customers

CustomerCreditNote

CustomerCreditNoteApplications, CustomerCreditNoteAttachments, CustomerCreditNoteLineAttachments, CustomerCreditNoteLineSubaccountSegments, CustomerCreditNoteLines, CustomerCreditNoteSubaccountSegments, CustomerCreditNoteTaxDetails, CustomerCreditNotes

CustomerDebitNote

CustomerDebitNoteApplications, CustomerDebitNoteAttachments, CustomerDebitNoteLineAttachments, CustomerDebitNoteLineSubaccountSegments, CustomerDebitNoteLines, CustomerDebitNoteSubaccountSegments, CustomerDebitNoteTaxDetails, CustomerDebitNotes

CustomerInvoice

CustomerInvoiceApplications, CustomerInvoiceAttachments, CustomerInvoiceLineAttachments, CustomerInvoiceLineSubaccountSegments, CustomerInvoiceLines, CustomerInvoiceSubaccountSegments, CustomerInvoiceTaxDetails, CustomerInvoices

CustomerOverdueCharge

CustomerOverdueChargeApplications, CustomerOverdueChargeAttachments, CustomerOverdueChargeLineAttachments, CustomerOverdueChargeLines, CustomerOverdueChargeSubAccountSegmentLines, CustomerOverdueChargeSubAccountSegments, CustomerOverdueChargeTaxDetails, CustomerOverdueCharges

Project

ProjectAttributes, ProjectEmployees, ProjectTaskAttributes, ProjectTaskEmployees, ProjectTasks, Projects

PurchaseOrder

PurchaseOrderDiscountDetails, PurchaseOrderLineSubsegments, PurchaseOrderLines, PurchaseOrderReceipts, PurchaseOrderTaxDetails, PurchaseOrders

Supplier

SupplierAttributes, SupplierBalances, SupplierClasses, SupplierPOBalances, SupplierPaymentMethodDetails, Suppliers

CashSale

CashSaleApplications, CashSaleLineSubaccountSegments, CashSaleLines, CashSaleSubaccountSegments, CashSales

PurchaseOrderBasic

BasicPurchaseOrderLines, BasicPurchaseOrderReceipts, BasicPurchaseOrderTaxDetails, BasicPurchaseOrders, PurchaseOrderLinesSubsegments

Shipment

ShipmentDetailLineAllocations, ShipmentDetailLines, ShipmentOrderLines, ShipmentPackageLines, Shipments

CashTransaction

CashTransactionDetailOffsetSubAccountSegments, CashTransactionDetails, CashTransactionTaxDetails, CashTransactions

SupplierInvoice

SupplierInvoiceLandedCosts, SupplierInvoiceLines, SupplierInvoiceTaxDetailLines, SupplierInvoices

Warehouse

WarehouseLocationPrimaryItemClassAttributeDetails, WarehouseLocationPrimaryItemClassAttributes, WarehouseLocations, Warehouses

CashAccount

CashAccountEntryTypes, CashAccountSubAccountSegments, CashAccounts

CustomerContract

CustomerContractAttributes, CustomerContractDetailsLines, CustomerContracts

CustomerPayment

CustomerPaymentLines, CustomerPaymentOrdersToApply, CustomerPayments

InventoryIssue

InventoryIssueLineAllocations, InventoryIssueLines, InventoryIssues

InventoryReceipt

InventoryReceiptLineAllocations, InventoryReceiptLines, InventoryReceipts

InventoryTransfer

InventoryTransferLineAllocations, InventoryTransferLines, InventoryTransfers

CustomerCreditWriteOff

CustomerCreditWriteOffSubAccountSegments, CustomerCreditWriteOffs

CustomerDocument

CustomerDocumentSubaccountSegments, CustomerDocuments

ExpenseClaim

ExpenseClaimDetails, ExpenseClaims

ExpenseReceipt

ExpenseReceiptClaimsByWorkGroupDescription, ExpenseReceipts

InventoryAdjustment

InventoryAdjustmentLines, InventoryAdjustments

Organization

Branches, Organization

SupplierLocation

SupplierLocationPaymentMethodDetails, SupplierLocations

SupplierPayment

SupplierPaymentLines, SupplierPayments

Account

Accounts

Branch

Branches

ContractUsage

ContractUsageTransactions

Country

Countries

CreditTerm

CreditTermRecords

Currency

Currencies

CurrencyRate

CurrencyRate

CustomerPaymentMethod

CustomerPaymentMethodDetails

Employee

Employees

Inventory

InventoryItems

Ledger

Ledgers

Location

Locations

PaymentMethod

PaymentMethods

ProjectBasic

BasicProjects

SalesOrder

SalesOrders

SalesOrderBasic

BasicSalesOrderLines

SupplierDocument

SupplierDocuments

VatZone

VatZones

Currency (without relations)

Currencies2, Currencies3

CurrencyRateType (without relations)

CurrencyRateType, CurrencyRateType2, CurrencyRateType3

CustomerInvoice (without relations)

CustomerInvoiceWorkTypes, CustomerInvoiceWorkTypes2, CustomerInvoiceWorkTypes3

CustomerPaymentMethod (without relations)

CustomerPaymentMethods, CustomerPaymentMethods2

DeferralCode (without relations)

DeferralCodes

Dimension (without relations)

Dimensions, Dimensions2, Dimensions3

FirstTimeStartup (without relations)

FirstTimeStartup

Inventory (without relations)

InventoryItemClassAttributeDetails, InventoryItemClassAttributes, InventoryItemClasses, InventoryItemPostClasses

Multilanguage (without relations)

MultilanguageActiveLanguages, MultilanguageActiveLanguages2, MultilanguageActiveLanguages3

Native (without relations)

NATIVEPLATFORMSCALARREQUESTS

NumberSequence (without relations)

NumberSequences, NumberSequences2, NumberSequences3, NumberSequences4, NumberSequences5, NumberSequences6

SalesCategory (without relations)

SalesCategories, SalesCategories2, SalesCategories3, SalesCategorySubCategories, SalesCategorySubCategories2, SalesCategorySubCategories3, SalesCategorySubCategorySubCategorySubCategories, SalesCategorySubCategorySubCategorySubCategories2, SalesCategorySubCategorySubCategorySubCategories3, SalesCategorySubCategorySubCategorySubCategorySubCategories, SalesCategorySubCategorySubCategorySubCategorySubCategories2, SalesCategorySubCategorySubCategorySubCategorySubCategories3, SalesCategorySubSubCategories, SalesCategorySubSubCategories2, SalesCategorySubSubCategories3

Supplier (without relations)

SupplierClassAttributeDetails, SupplierClassAttributes, SupplierInboxRulesAsync

UiExtension (without relations)

UiExtensionSteps, UiExtensionSteps2, UiExtensionSteps3, UiExtensions, UiExtensions2, UiExtensions3

UnitOfMeasure (without relations)

UnitsOfMeasure, UnitsOfMeasure2, UnitsOfMeasure3

Views (without relations)

FinancialPeriodStatistics, GeneralLedgerBalancesAll, GeneralLedgerTransactions, JournalTransactionLines, JournalTransactions

Customers (without relations)

Customers

Relations

Tables

NgSalesOrders.Customers

NgSalesOrders.Inventory

NgSalesOrders.SalesOrders

NgSalesOrders.TransferOrders

VismaNet.Account

VismaNet.Attachment

VismaNet.Attribute

VismaNet.Background

VismaNet.Blob

VismaNet.Branch

VismaNet.Budget

VismaNet.Carrier

VismaNet.CashAccount

VismaNet.CashSale

VismaNet.CashTransaction

VismaNet.Contact

VismaNet.ContractTemplate

VismaNet.ContractUsage

VismaNet.Country

VismaNet.CreditNote

VismaNet.CreditTerm

VismaNet.Currency

VismaNet.CurrencyRate

VismaNet.CurrencyRateType

VismaNet.Customer

VismaNet.CustomerContract

VismaNet.CustomerCreditNote

VismaNet.CustomerCreditWriteOff

VismaNet.CustomerDebitNote

VismaNet.CustomerDocument

VismaNet.CustomerInvoice

VismaNet.CustomerOverdueCharge

VismaNet.CustomerPayment

VismaNet.CustomerPaymentMethod

VismaNet.CustomerSalesPrice

VismaNet.CustomerV2

VismaNet.DeferralCode

VismaNet.Department

VismaNet.Dimension

VismaNet.Discount

VismaNet.DiscountCode

VismaNet.DiscountCodeV2

VismaNet.DiscountV2

VismaNet.EarningType

VismaNet.Employee

VismaNet.ExpenseClaim

VismaNet.ExpenseReceipt

VismaNet.FeaturesSet

VismaNet.FinancialPeriod

VismaNet.FirstTimeStartup

VismaNet.FixedAsset

VismaNet.FixedAssetClass

VismaNet.FixedAssetPropertyTaxGroup

VismaNet.FixedAssetTransaction

VismaNet.GeneralLedgerBalanceV2

VismaNet.GeneralLedgerTransactions

VismaNet.Inventory

VismaNet.InventoryAdjustment

VismaNet.InventoryIssue

VismaNet.InventoryReceipt

VismaNet.InventorySummary

VismaNet.InventoryTransfer

VismaNet.JournalTransactionV2

VismaNet.KitAssembly

VismaNet.KitSpecifications

VismaNet.LandedCostCode

VismaNet.Ledger

VismaNet.Location

VismaNet.LotSerialClass

VismaNet.Multilanguage

VismaNet.Native

VismaNet.NumberSequence

VismaNet.Organization

VismaNet.PackagingType

VismaNet.Payment

VismaNet.PaymentMethod

VismaNet.Project

VismaNet.ProjectAccountGroup

VismaNet.ProjectBasic

VismaNet.ProjectBudget

VismaNet.ProjectTask

VismaNet.ProjectTransaction

VismaNet.PurchaseOrder

VismaNet.PurchaseOrderBasic

VismaNet.PurchaseReceipt

VismaNet.PurchaseReceiptBasic

VismaNet.PurchaseReceiptV2

VismaNet.SalesCategory

VismaNet.SalesOrder

VismaNet.SalesOrderBasic

VismaNet.SalesOrderType

VismaNet.SalesOrderV2

VismaNet.SalesPerson

VismaNet.SalesPersonV2

VismaNet.Shipment

VismaNet.StocktakeV2

VismaNet.Subaccount

VismaNet.Supplier

VismaNet.SupplierAccount

VismaNet.SupplierDocument

VismaNet.SupplierInvoice

VismaNet.SupplierLocation

VismaNet.SupplierPayment

VismaNet.SupplierV2

VismaNet.TimeCard

VismaNet.UiExtension

VismaNet.UnitOfMeasure

VismaNet.Vat

VismaNet.VatCategory

VismaNet.VatZone

VismaNet.Views

VismaNet.Warehouse

Sample Queries

--
-- All Visma.net Financials customers.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/visma-net-data-model/webhelp/visma-net-financials-connector-customer-customers.html
--
select *
from   VismaNet.Customer.Customers@vnt
limit  100
--
-- List of all journal transaction lines using a database view.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/visma-net-data-model/webhelp/visma-net-financials-connector-views-journaltransactionlines.html
--
-- Related forum post: https://forums.invantive.eu/t/what-are-table-functions-and-table-function-parameters/1868
--
select *
from   VismaNet.Views.JournalTransactionLines@vnt
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: