The Invantive drivers make all somewhat usable tables available for Exact Online in real-time.
The Exact Online 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 Exact Online with Power BI can be found in Connect Power BI to Exact Online, 180 days free.
A few Exact Online tables were the most used over the past year. The table below shows which Exact Online tables are the most popular and will help you selecting tables.
| Position | Table name | Description |
|---|---|---|
| 1 | TransactionLinesIncremental | Journal entries and lines |
| 2 | DocumentAttachmentsIncremental | Document attachments |
| 3 | SalesOrderLinesIncremental | Sales orders and lines |
| 4 | AccountsIncremental | Accounts |
| 5 | SalesInvoiceLinesIncremental | Sales invoices and lines |
| 6 | PjtTimeTransactions | Time on Projects |
| 7 | ReportingBalance | Balances |
| 8 | GLAccountClassificationMappings | General Ledger account mappings |
| 9 | XML.AccountClassifications | Account classification |
| 10 | SalesEntries | Sales |