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
- InvoiceTerms
- InternalRates
HRM
- Employees
- EmploymentContracts
- Departments
- JobTitles
- ScheduleHours
- LeaveHours
- LeaveHoursByDay
- AbsenceHours
- AbsenceHoursByDay
Payroll
- Salaries
- PayrollTransactions