1. Home
  2. Docs
  3. Power BI Connector for Exact Online (English)
  4. 2. Power BI Desktop
  5. 2.5 Datamodel Exact Online

2.5 Datamodel Exact Online

Several tables are predefined in the Power BI Connector, according to Davista’s standard data model. Below we give an overview of the available tables.

General

  • Companies
  • Users
  • Periods
  • Calender (according to the Exact Online period table)
  • Documents

Finance

  • Ledger
  • LedgerClassifications
  • LedgerMapping
  • LedgerTransactions
  • LedgerAmounts
  • BudgetAmounts
  • Openingsbalance
  • Journals
  • CostCenters
  • CostUnits
  • Vat
  • Currencies
  • ExchangeRates

Sales

  • Debtors
  • Quotations
  • Opportunitues
  • SalesOrders
  • SalesInvoices
  • GoodsDeliveries
  • DebtorsOutstanding
  • RelationGroups
  • PaymentConditions

Purchase

  • Creditors
  • PurchaseOrders
  • PurchaseInvoices
  • GoodsReceipts
  • CreditorsOutstanding

Voorraad

  • Items
  • ItemGroups
  • Warehouses
  • StorageLocations
  • Stock

Projects

  • Projects
  • ProjectActivities (= WBS structure)
  • ProjectPlanning
  • ProjectCosts
  • ProjectHours
  • CostTypes
  • HourTypes

HRM

  • Employees
  • EmploymentContracts
  • Departments
  • JobTitles
  • ScheduleHours
  • LeaveHours
  • AbsenceHours

Payroll

  • Salaries
  • PayrollTransactions
Was this article helpful to you? Yes No