Link to Overzicht meestgebruikte tabellen per driver
Vertalen deze.
The Invantive drivers make all somewhat usable tables available for Visma.net Financials in real-time.
The Visma.net Financials tables are available for use in SQL, Power BI Desktop, Power BI Service, Power Query, Azure Data Factory, Qlik, Tableau and other popular packages.
The steps to link Autotask with Power BI can be found in Connect Power BI to Visma.net Financials.
A few Visma.net Financials tables were the most used over the past year. The table below shows which Visma.net Financials tables are the most popular and will help you selecting tables.
| Position | Table name | Description |
|---|---|---|
| 1 | VismaNet.Views.JournalTransactionLines | Journal transaction lines |
| 2 | VismaNet.GeneralLedgerTransactions.GeneralLedgerTransactions | General ledger transactions (headers) |
| 3 | VismaNet.GeneralLedgerBalanceV2.GeneralLedgerBalancesV2 | General ledger balances |
| 4 | VismaNet.CustomerInvoice.CustomerInvoices | Sales invoices |
| 5 | VismaNet.CustomerPayment.CustomerPaymentLines | Customer payment lines |
| 6 | VismaNet.CustomerPayment.CustomerPayments | Customer payments |
| 7 | VismaNet.Customer.Customers | Customers |
| 8 | VismaNet.CustomerInvoice.CustomerInvoiceLines | Customer invoice lines |
| 9 | VismaNet.Views.JournalTransactions | Journal transactions |
| 10 | VismaNet.SalesOrder.SalesOrderLines | Sales order lines |
| 11 | VismaNet.Customer.CustomerAttributes | Customer attributes |
| 12 | VismaNet.Inventory.InventoryWarehouseDetails | Inventory warehouse details |
| 13 | VismaNet.Account.Accounts | General ledger accounts |
| 14 | VismaNet.FinancialPeriod.FinancialPeriods | Financial periods |
| 15 | VismaNet.Supplier.Suppliers | Suppliers |
| 16 | VismaNet.SalesOrder.SalesOrders | Sales orders |
| 17 | VismaNet.Supplier.SupplierAttributes | Supplier attributes |
| 18 | VismaNet.ProjectBudget.ProjectBudgets | Project budgets |
| 19 | VismaNet.Shipment.ShipmentOrderLines | Shipment order lines |
| 20 | VismaNet.Inventory.InventoryItems | Inventory items |
| 21 | VismaNet.Shipment.ShipmentDetailLines | Shipment detail lines |
| 22 | VismaNet.Subaccount.SubaccountSegments | Subaccount segments |
| 23 | VismaNet.InventoryReceipt.InventoryReceiptLines | Inventory receipt lines |
| 24 | VismaNet.CreditNote.CreditNotes | Credit notes |
| 25 | VismaNet.SupplierPayment.SupplierPayments | Supplier payments |
| 26 | VismaNet.CustomerCreditWriteOff.CustomerCreditWriteOffs | Customer credit write-offs |
| 27 | VismaNet.Inventory.InventoryAttributes | Inventory attributes |
| 28 | VismaNet.Branch.Branches | Branches |
| 29 | VismaNet.PurchaseOrder.PurchaseOrderLines | Purchase order lines |
| 30 | VismaNet.PurchaseOrder.PurchaseOrders | Purchase orders |
| 31 | VismaNet.InventoryReceipt.InventoryReceipts | Inventory receipts |
| 32 | VismaNet.CustomerDebitNote.CustomerDebitNotes | Customer debit notes |
| 33 | VismaNet.CustomerCreditNote.CustomerCreditNoteLines | Customer credit note lines |
| 34 | VismaNet.PurchaseReceipt.BasicPurchaseReceiptLines | Purchase receipt lines |
| 35 | VismaNet.Project.ProjectTasks | Project tasks |
| 36 | VismaNet.SupplierInvoice.SupplierInvoiceLines | Supplier invoice lines |
| 37 | VismaNet.Project.Projects | Projects |
| 38 | VismaNet.CustomerSalesPrice.CustomerSalesPrices | Customer sales prices |
| 39 | VismaNet.InventoryIssue.InventoryIssueAttachments | Inventory issue attachments |
| 40 | VismaNet.Ledger.Ledgers | Ledgers |
| 41 | VismaNet.SupplierInvoice.SupplierInvoices | Supplier invoices |
| 42 | VismaNet.InventoryIssue.InventoryIssueLineAttachments | Inventory issue line attachments |
| 43 | VismaNet.Location.Locations | Locations |
| 44 | VismaNet.PurchaseOrder.PurchaseOrderReceipts | Purchase order receipts |
| 45 | VismaNet.Shipment.Shipments | Shipments |
| 46 | VismaNet.SalesPerson.SalesPersonRecords | Sales persons |
| 47 | VismaNet.SalesPerson.SalespersonRecordCustomers | Salesperson Customers |
| 48 | VismaNet.CustomerCreditNote.CustomerCreditNotes | Customer credit notes |
| 49 | VismaNet.Inventory.InventoryUnits | Inventory units |
| 50 | VismaNet.Subaccount.Subaccounts | Sub-accounts |
A complete listing of all 635 Visma.net Financials tables is at: