invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Exact Online Data Model

De Exact Online-driver biedt meer dan 1.000 tabellen, gegroepeerd over een reeks XML-API's, REST-API's en enkele speciale API's.

For Exact Online apps it was discouraged to use the CSV APIs and starting 2019 the use is almost impossible and requires techniques that can lead to delisting or app blocks. Therefore Invantive SQL includes the XML APIs and REST APIs. Both documented as the many undocumented Exact Online APIs are included.

A graphical representation of the essential Exact Online API tables available with Invantive SQL is at https://go.invantive.eu/eolerd. It includes individual entity relationship data models per area and industry and includes manufacturing, PSA, trade, accounting and accountancy.

API Authentication

The Invantive SQL driver for Exact Online allows multiple authentication models:

  • OAuth-codetoekenningsstroom

  • OAuth Implicit Grant Flow without MFA

  • OAuth Implicit Grant Flow with MFA

Scraping

The functionality of all APIs is identical independent of the chosen authentication models. Business professionals, finance professionals and developers can choose the authentication model most suitable for API access.

All Invantive products include "OAuth client" settings such as client ID. In compliance with OAuth security recommendation, the code grant flow with an Invantive-controlled client ID and client secret is only used when the software runs on a device controlled by Invantive, such as on the Exact Online Power BI driver on Invantive Cloud.

The OAuth Implicit Grant Flow is used for interactive products such as the Excel add-in: Invantive Control for Excel. By default, a re-authentication is necessary every ten minutes. The user password is automatically provided when "Remember Password" was checked on log in. The MFA verification code (also known as "TOTP") must be entered every ten minutes. You can specify the secret key used for MFA verification process in the client software for an auto-generated verification code, but this reduces the security.

The OAuth security rules require the Implicit Grant Flow for deployment on a device not under control of the client app owner. However, you or a your developers can register your own company client on apps.exactonline.com. Use the client ID and client secret generated by Exact and use the form "Pre-authenticate" on Invantive Cloud to generate a refresh token. Optionally, you can request through Invantive Support that obsoletion of the refresh tokens is disabled for your client.

Authentication using scraping is possible, for instance for non-browser logins from a console application, but is highly discouraged and might be obsoleted without further notice.

Exact Online REST API and Popular Tables

The Exact Online REST API is most commonly used. Some of the most popular tables from the REST API are:

  • TransactionLinesBulk: financial transaction accounting details

  • AccountsBulk: customers and suppliers

  • GLAccountsBulk: general ledger accounts

  • ItemsBulk: articles.

  • DocumentAttachmentFilesBulk: documents in binary format such as accounting documents

The REST API has in general great download performance. Additionally, the Exact REST API has filter capabilities on many columns, allowing use of server-side filtering in an translation of where-clauses in Invantive SQL leading to highly optimized REST API calls. Also the REST API allows complex join optimizations leading to highly reduced execution times compared to full downloads of multiple tables and joining them on the client. Incremental download facilities are available for further reducing the number of API calls and meeting Exact's strict rate limit policies.

Exact Online XML API and Popular Tables

Despite that the REST API was introduced by Exact in 2016, the XML API is still thriving and especially for accounting offers many high performance and scalable APIs. Also many APIs are not available in the REST API yet, the XML API offers them nonetheless. The most popular tables from the XML API are:

  • BalanceLinesPerPeriod: balances per financial year and period and general ledger account

  • AROutstandingItems: open invoices in accounts receivables

  • APOutstandingItems: open invoices in account payables

  • Settings: Exact Online company settings

  • MatchSetLines: bank reconciliation details

Tables based on the XML API typically offer many columns which are mostly empty. This is due to the design chosen for the XML API by Exact developers with a very flexible XSD.

The XML API has even better download performance than the REST API. However, the XML API has limited filtering capabilities. For small environment a full download is acceptable but especially for the top 500 Exact Online customers an out-of-the-box great performance with Invantive SQL requires the use of the REST APIs.

API Rate Limits

The Exact Online APIs limit the number of API calls made in various ways. Invantive SQL has numerous optimizations specifically for Exact Online to achieve optimal API performance without manual fiddling of options or code.

Calls to the XML API are typically limited to 60 calls per minute. Invantive SQL automatically throttles to meet the specified XML API reate limits. These division-specific throttles are also applied when using the UploadXMLTopics table to upload massive amounts of transaction data into one or hundreds of companies in parallel.

Calls to the REST API are limited by minutely rate limits and daily limits. The daily limit per division (an Exact Online company) varies between 5.000 and 50.000 calls per day and client app, depending on agreement. The minute rate limit for the REST API varies between 60 and 300 calls per minute. Once the minute or daily API call rate limit has been reached, no more API calls can be made. Invantive SQL automatically throttles API calls to meet the rate limits reported by the Exact Online REST API. Developers can access the current rate limits and their reported API usage per division using the view RateLimits. The contents of the view RateLimits are automatically updated on every Exact Online API call.

Division and Data Scoping

Starting december 2020, the REST APIs apply division and data scoping. Division scoping means that an API call of an app can only access specific Exact Online companies or all companies granted to the user used to authenticate the app with. After an app was approved for use with Exact Online, the top-level menu "Import/Export" allows changing the division scope using the form "App privileges".

Data scoping means that an API call of an app is first compared to the registered and approved list of APIs for that app on apps.exactonline.com. Data scoping is never active for customer-specific app registrations. However, published apps always must undergo a security check including data scoping for REST APIs.

XML APIs are covered on division scoping, but currently the XML API is not subjected to data scoping.

All Invantive SQL products support division and data scoping for custom and published apps.

Cross-division Queries (Companies)

Every Exact Online company is called a "division". Each division in an Exact Online country has a unique number called the "division code". The column "divisioncode" (REST API tables) or "division_code" (XML API tables) contains the division code. Most REST API tables on Invantive SQL have columns not present in the REST API and added by Invantive SQL for additional data on the division, such as VAT number. This is for use with large accounting or accountancy environments which typically run across thousands of divisions.

For use and billing purposes, each division maps onto one partition. It does not matter whether data is retrieved on the REST API, XML API or from both Exact Online APIs on the division.

Invantive SQL API access to Exact Online is not possible for an archived division or a division of a accountancy customer which has been blocked due to dunning. The last scenario only applies for accountancy use; each accountant can access the divisions of associated customers.

Invantive SQL executes all queries without changes on one division or multiple divisions. The get results from multiple Exact Online divisions are merged into one large table with data from multiple divisions. The retrieval of data is performed in parallel as specified through connector attributes; the default maximum number of divisions queried in parallel is 8 per SQL engine instance.

Graphical products typically contain a division selector, allowing a finance professional to choose all divisions, a specific one or a sub-selection such as on division classification setup (account manager, accountancy office, monthly or quarterly VAT).

A developer can specify the division(s) to use with the Invantive SQL statement "use". The default division can be set using "use default" and all using "use all". Division segmentation across a larger population such as all divisions from the accountancy branch office "Amsterdam" can be selected using "use" with a selection query such as "use select ... from". At all times, at least one division must be selected. For details see the SQL grammar.

Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/exactonline

The data is partitioned per Administration (Division).

Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.

Platform

  • Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
  • Type: een applicatie die via de API toegankelijk is.
  • De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
  • Met één Query kunnen meerdere bedrijven tegelijk worden opgehaald.
  • Gegevens kunnen zowel worden geschreven als gelezen.
  • Invantive Cloud plans: Free for Exact Online, Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.exact.com/.
  • Language of its user community: Dutch.

Cijfers

Figure Count
Tables 1,239
Columns 1,553,883
Tabeller med invoegsel 699
Tabeller med update 685
Tabellen met de functie 'verwijderen' 312
Tabeller gedocumenteerd 395

Poster met datamodel

PDF, 4 A0-vellen

Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.

Exact Online Datamodel, Pagina 1 van 4Exact Online Datamodelvoor gebruik met Invantive UniversalSQLPersbericht 27.1.3-BETA+6294 · 01-11-2026SalesOrder · Project · Productie · SalesInvoice · FinancialTransaction · Logistics · Verkoper · Documenten · Accountancy · LicencePagina 1 van 4 · documentation.invantive.euSalesOrder×2×2×2×2×2×2×2×2×2×2×2×2×2×2×2×2×2×2×2×2×2×2×2×2×2×2×6×2×2×2×2ExactOnlineREST.SalesOrder.DigitalOrderPickingLines: Digital Order Picking LinesDigitalOrderPickingLinesExactOnlineREST.Users.UsersUExactOnlineREST.SalesOrder.DigitalOrderPickings: Digital Order PickingsDigitalOrderPickingsExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.SalesOrder.GoodsDeliveries: Goods Deliveries (ExactOnlineREST.Incremental.GoodsDeliveriesIncremental, ExactOnlineREST.SalesOrder.GoodsDeliveriesBulk, ExactOnlineREST.Sync.SyncGoodsDeliveries)GoodsDeliveries+Bulk +Incremental +SyncExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.SalesOrder.GoodsDeliveryLines: Goods Delivery Lines (ExactOnlineREST.Incremental.GoodsDeliveryLinesIncremental, ExactOnlineREST.SalesOrder.GoodsDeliveryLinesBulk, ExactOnlineREST.Sync.SyncGoodsDeliveryLines)GoodsDeliveryLines+Bulk +Incremental +SyncExactOnlineREST.Users.UsersUExactOnlineREST.SalesOrder.PlannedSalesReturnLines: Planned Sales Return LinesPlannedSalesReturnLinesExactOnlineREST.Users.UsersUExactOnlineREST.SalesOrder.PlannedSalesReturns: Planned Sales ReturnsPlannedSalesReturnsExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.SalesOrder.SalesOrderLayouts: Sales Order LayoutsSalesOrderLayoutsExactOnlineREST.Users.UsersUExactOnlineREST.SalesOrder.SalesOrderLines: Sales Order Lines (ExactOnlineREST.SalesOrder.SalesOrderLinesBulk)SalesOrderLines+BulkExactOnlineREST.SalesOrder.SalesOrderStockBatchNumbers: Sales Order Stock Batch Numbers (ExactOnlineREST.SalesOrder.SalesOrderStockBatchNumbersBulk)SalesOrderStockBatchNumbers+BulkExactOnlineREST.Users.UsersUExactOnlineREST.SalesOrder.SalesOrderStockSerialNumbers: Sales Order Stock Serial Numbers (ExactOnlineREST.SalesOrder.SalesOrderStockSerialNumbersBulk)SalesOrderStockSerialNumbers+BulkExactOnlineREST.Users.UsersUExactOnlineREST.SalesOrder.SalesOrderStorageLocationsBulk: Storage LocationsSalesOrderStorageLocationsBulkExactOnlineREST.SalesOrder.SalesOrders: Sales Orders (ExactOnlineREST.SalesOrder.SalesOrdersBulk, ExactOnlineREST.SalesOrder.SalesOrdersExploded)SalesOrders+Bulk +ExplodedExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.CRM.Addresses: Addresses (ExactOnlineREST.CRM.AddressesBulk, ExactOnlineREST.CRM.AddressesRead, ExactOnlineREST.Incremental.AddressesIncremental, ExactOnlineREST.Sync.SyncAddresses)AddressesCRMExactOnlineREST.Users.UsersUExactOnlineREST.CRM.Contacts: Contacts (ExactOnlineREST.CRM.ContactsBulk, ExactOnlineREST.CRM.ContactsRead, ExactOnlineREST.Incremental.ContactsIncremental, ExactOnlineREST.Sync.SyncContacts)ContactsCRMExactOnlineREST.Users.UsersUExactOnlineREST.Documents.Documents: Documents (ExactOnlineREST.Documents.DocumentsBulk, ExactOnlineREST.Incremental.DocumentsIncremental, ExactOnlineREST.Sync.SyncDocuments)DocumentsDocumentenExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.HRM.Costcenters: Cost CentresCostcentersHRMExactOnlineREST.Users.UsersUExactOnlineREST.HRM.Costunits: Cost UnitsCostunitsHRMExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.BatchNumbers: Batch NumbersBatchNumbersInventarisExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.SerialNumbers: Serial NumbersSerialNumbersInventarisExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.StockCountLines: Stock Count LinesStockCountLinesInventarisExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.StorageLocations: Storage LocationsStorageLocationsInventarisExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.Warehouses: Warehouses (ExactOnlineREST.SalesOrder.WarehousesBulk)WarehousesInventarisExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.ItemVersions: Item VersionsItemVersionsLogisticsExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.Items: Items (ExactOnlineREST.Incremental.ItemsIncremental, ExactOnlineREST.Logistics.ItemsBulk, ExactOnlineREST.Logistics.ItemsRead, ExactOnlineREST.Sync.SyncItems)ItemsLogisticsExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.SelectionCodes: Selection CodesSelectionCodesLogisticsExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.ShopOrders: Shop Orders (ExactOnlineREST.Incremental.ShopOrdersIncremental, ExactOnlineREST.Sync.SyncShopOrders)ShopOrdersProductieExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProjectExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.PurchaseOrder.PurchaseOrderLines: Purchase Order Lines (ExactOnlineREST.Incremental.PurchaseOrderLinesIncremental, ExactOnlineREST.Sync.SyncPurchaseOrderLines)PurchaseOrderLinesPurchaseOrderExactOnlineREST.Users.UsersUExactOnlineREST.PurchaseOrder.PurchaseOrders: Purchase Orders (ExactOnlineREST.Views.PurchaseOrdersIncremental)PurchaseOrdersPurchaseOrderExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Sales.SalesPriceLists: Sales Price ListsSalesPriceListsVerkoperExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Sales.ShippingMethods: Shipping MethodsShippingMethodsVerkoperExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesBTWExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUProject×2×2×2×2ExactOnlineREST.Project.CostTransactions: Cost Transactions (ExactOnlineREST.Views.CostTransactionsIncremental)CostTransactions+IncrementalExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Project.EmployeeRestrictionItems: Employee Restriction ItemsEmployeeRestrictionItemsExactOnlineREST.Users.UsersUExactOnlineREST.Project.EmploymentInternalRates: Employment Internal RatesEmploymentInternalRatesExactOnlineREST.Users.UsersUExactOnlineREST.Project.InvoiceTerms: Invoice TermsInvoiceTermsExactOnlineREST.Users.UsersUExactOnlineREST.Project.PjtTimeTransactions: Project Time Transactions (ExactOnlineREST.Views.PjtTimeTransactionsIncremental)PjtTimeTransactions+IncrementalExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectAccountMutations: Project Account MutationsProjectAccountMutationsExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectHourBudgets: Project Hour BudgetsProjectHourBudgetsExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectPlanning: Project PlanningProjectPlanningExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectPlanningRecurring: Recurring Project PlanningProjectPlanningRecurringExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectRestrictionEmployeeItems: Project Restriction Employee ItemsProjectRestrictionEmployeeItemsExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectRestrictionEmployees: Project Restriction EmployeesProjectRestrictionEmployeesExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectRestrictionItems: Project Restriction ItemsProjectRestrictionItemsExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectRestrictionRebillings: Project Restriction RebillingsProjectRestrictionRebillingsExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectWBS: Project WBS (ExactOnlineREST.Incremental.ProjectWBSIncremental, ExactOnlineREST.Project.ProjectWBSBulk, ExactOnlineREST.Sync.SyncProjectWBS)ProjectWBS+Bulk +Incremental +SyncExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)Projects+Incremental +SyncExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Project.RecentCosts: Recent CostsRecentCostsExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Project.RecentHours: Recent HoursRecentHoursExactOnlineREST.CRM.AccountsAExactOnlineREST.Project.TimeCorrections: Time CorrectionsTimeCorrectionsExactOnlineREST.Users.UsersUExactOnlineREST.Project.WBSActivities: WBS ActivitiesWBSActivitiesExactOnlineREST.Users.UsersUExactOnlineREST.Project.WBSDeliverables: WBS DeliverablesWBSDeliverablesExactOnlineREST.Users.UsersUExactOnlineREST.Project.WBSExpenses: WBS ExpensesWBSExpensesExactOnlineREST.Users.UsersUExactOnlineREST.CRM.Addresses: Addresses (ExactOnlineREST.CRM.AddressesBulk, ExactOnlineREST.CRM.AddressesRead, ExactOnlineREST.Incremental.AddressesIncremental, ExactOnlineREST.Sync.SyncAddresses)AddressesCRMExactOnlineREST.Users.UsersUExactOnlineREST.CRM.Contacts: Contacts (ExactOnlineREST.CRM.ContactsBulk, ExactOnlineREST.CRM.ContactsRead, ExactOnlineREST.Incremental.ContactsIncremental, ExactOnlineREST.Sync.SyncContacts)ContactsCRMExactOnlineREST.Users.UsersUExactOnlineREST.CRM.Quotations: Quotations (ExactOnlineREST.CRM.QuotationsBulk)QuotationsCRMExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.Items: Items (ExactOnlineREST.Incremental.ItemsIncremental, ExactOnlineREST.Logistics.ItemsBulk, ExactOnlineREST.Logistics.ItemsRead, ExactOnlineREST.Sync.SyncItems)ItemsLogisticsExactOnlineREST.Users.UsersUExactOnlineREST.Payroll.Employees: Employees (ExactOnlineREST.Incremental.EmployeesIncremental, ExactOnlineREST.Sync.SyncEmployees)EmployeesLonenExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Payroll.Employments: Employments (ExactOnlineREST.Incremental.EmploymentsIncremental, ExactOnlineREST.Sync.SyncEmployments)EmploymentsLonenExactOnlineREST.Users.UsersUExactOnlineREST.Subscription.Subscriptions: Subscriptions (ExactOnlineREST.Incremental.SubscriptionsIncremental, ExactOnlineREST.Sync.SyncSubscriptions)SubscriptionsAbonnementExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesBTWExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUProductie×2×2×2×2ExactOnlineREST.Manufacturing.BillOfMaterialMaterials: BOM Materials (ExactOnlineREST.Sync.SyncBillOfMaterialMaterials)BillOfMaterialMaterials+SyncExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.BillOfMaterialVersions: Bill of Material Versions (ExactOnlineREST.Sync.SyncBillOfMaterialVersions)BillOfMaterialVersions+SyncExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.ByProductReceipts: Receipts by ProductByProductReceiptsExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.ByProductReversals: Reversals by ProductByProductReversalsExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.MaterialIssues: Material Issues (ExactOnlineREST.Sync.SyncMaterialIssues)MaterialIssues+SyncExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.MaterialReversals: Processed Cost Analysis Balance Lines per PeriodMaterialReversalsExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.MfgItemWarehouseStorageLocations: Manufacturing Item Warehouse Storage LocationsMfgItemWarehouseStorageLocationsExactOnlineREST.Manufacturing.MfgSalesOrderlines: Manufacturing Sales Order LinesMfgSalesOrderlinesExactOnlineREST.Manufacturing.MfgTimeTransactions: Manufacturing Time TransactionsMfgTimeTransactionsExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.OperationResources: Operation ResourcesOperationResourcesExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.Operations: OperationsOperationsExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.ProductionAreas: Production AreasProductionAreasExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.ShopOrderMaterialPlanDetails: Shop Order Material Plan DetailsShopOrderMaterialPlanDetailsExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.ShopOrderMaterialPlans: Shop Order Material Plans (ExactOnlineREST.Incremental.ShopOrderMaterialPlansIncremental, ExactOnlineREST.Sync.SyncShopOrderMaterialPlans)ShopOrderMaterialPlans+Incremental +SyncExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.ShopOrderReceipts: Shop Order ReceiptsShopOrderReceiptsExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.ShopOrderReversals: Shop Order ReversalsShopOrderReversalsExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.ShopOrderRoutingStepPlans: Shop Order Routing Step Plans (ExactOnlineREST.Incremental.ShopOrderRoutingStepPlansIncremental, ExactOnlineREST.Sync.SyncShopOrderRoutingStepPlans)ShopOrderRoutingStepPlans+Incremental +SyncExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.ShopOrders: Shop Orders (ExactOnlineREST.Incremental.ShopOrdersIncremental, ExactOnlineREST.Sync.SyncShopOrders)ShopOrders+Incremental +SyncExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.StageForDeliveryReceipts: Stage for Delivery ReceiptsStageForDeliveryReceiptsExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.StageForDeliveryReversals: Stage for Delivery ReversalsStageForDeliveryReversalsExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.SubOrderReceipts: Sub Order ReceiptsSubOrderReceiptsExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.SubOrderReversals: Sub Order ReversalsSubOrderReversalsExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.TimedTimeTransactions: Timed Time TransactionsTimedTimeTransactionsExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.Workcenters: WorkcentreWorkcentersExactOnlineREST.Users.UsersUExactOnlineREST.HRM.Costcenters: Cost CentresCostcentersHRMExactOnlineREST.Users.UsersUExactOnlineREST.HRM.Costunits: Cost UnitsCostunitsHRMExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.StorageLocations: Storage LocationsStorageLocationsInventarisExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.Warehouses: Warehouses (ExactOnlineREST.SalesOrder.WarehousesBulk)WarehousesInventarisExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.ItemVersions: Item VersionsItemVersionsLogisticsExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.Items: Items (ExactOnlineREST.Incremental.ItemsIncremental, ExactOnlineREST.Logistics.ItemsBulk, ExactOnlineREST.Logistics.ItemsRead, ExactOnlineREST.Sync.SyncItems)ItemsLogisticsExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.SelectionCodes: Selection CodesSelectionCodesLogisticsExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.Units: UnitsUnitsLogisticsExactOnlineREST.Payroll.Employees: Employees (ExactOnlineREST.Incremental.EmployeesIncremental, ExactOnlineREST.Sync.SyncEmployees)EmployeesLonenExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProjectExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesBTWExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUSalesInvoice×2×2×2×2×2×2×2×2×2×2×2×2×2×2×6×2×2×2×2ExactOnlineREST.SalesInvoice.Layouts: LayoutsLayoutsExactOnlineREST.Users.UsersUExactOnlineREST.SalesInvoice.SalesInvoiceLines: Sales Invoice Lines (ExactOnlineREST.Incremental.SalesInvoiceLinesIncremental, ExactOnlineREST.SalesInvoice.SalesInvoiceLinesBulk)SalesInvoiceLines+Bulk +IncrementalExactOnlineREST.SalesInvoice.SalesInvoices: Sales Invoices (ExactOnlineREST.SalesInvoice.SalesInvoicesBulk, ExactOnlineREST.SalesInvoice.SalesInvoicesExploded, ExactOnlineREST.Sync.SyncSalesInvoices, ExactOnlineREST.Views.SalesInvoicesIncremental)SalesInvoices+Bulk +Exploded +Incremental +SyncExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.CRM.Addresses: Addresses (ExactOnlineREST.CRM.AddressesBulk, ExactOnlineREST.CRM.AddressesRead, ExactOnlineREST.Incremental.AddressesIncremental, ExactOnlineREST.Sync.SyncAddresses)AddressesCRMExactOnlineREST.Users.UsersUExactOnlineREST.CRM.Contacts: Contacts (ExactOnlineREST.CRM.ContactsBulk, ExactOnlineREST.CRM.ContactsRead, ExactOnlineREST.Incremental.ContactsIncremental, ExactOnlineREST.Sync.SyncContacts)ContactsCRMExactOnlineREST.Users.UsersUExactOnlineREST.Documents.Documents: Documents (ExactOnlineREST.Documents.DocumentsBulk, ExactOnlineREST.Incremental.DocumentsIncremental, ExactOnlineREST.Sync.SyncDocuments)DocumentsDocumentenExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Financial.GLAccounts: General Ledger Accounts (ExactOnlineREST.Financial.GLAccountsBulk, ExactOnlineREST.Incremental.GLAccountsIncremental, ExactOnlineREST.Sync.SyncGLAccounts)GLAccountsFinancialExactOnlineREST.Users.UsersUExactOnlineREST.Financial.Journals: JournalsJournalsFinancialExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.HRM.Costcenters: Cost CentresCostcentersHRMExactOnlineREST.Users.UsersUExactOnlineREST.HRM.Costunits: Cost UnitsCostunitsHRMExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.Warehouses: Warehouses (ExactOnlineREST.SalesOrder.WarehousesBulk)WarehousesInventarisExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.Items: Items (ExactOnlineREST.Incremental.ItemsIncremental, ExactOnlineREST.Logistics.ItemsBulk, ExactOnlineREST.Logistics.ItemsRead, ExactOnlineREST.Sync.SyncItems)ItemsLogisticsExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.SelectionCodes: Selection CodesSelectionCodesLogisticsExactOnlineREST.Users.UsersUExactOnlineREST.Payroll.Employees: Employees (ExactOnlineREST.Incremental.EmployeesIncremental, ExactOnlineREST.Sync.SyncEmployees)EmployeesLonenExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectWBS: Project WBS (ExactOnlineREST.Incremental.ProjectWBSIncremental, ExactOnlineREST.Project.ProjectWBSBulk, ExactOnlineREST.Sync.SyncProjectWBS)ProjectWBSProjectExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProjectExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Sales.SalesPriceLists: Sales Price ListsSalesPriceListsVerkoperExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.SalesOrder.SalesOrderLines: Sales Order Lines (ExactOnlineREST.SalesOrder.SalesOrderLinesBulk)SalesOrderLinesSalesOrderExactOnlineREST.SalesOrder.SalesOrders: Sales Orders (ExactOnlineREST.SalesOrder.SalesOrdersBulk, ExactOnlineREST.SalesOrder.SalesOrdersExploded)SalesOrdersSalesOrderExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Subscription.Subscriptions: Subscriptions (ExactOnlineREST.Incremental.SubscriptionsIncremental, ExactOnlineREST.Sync.SyncSubscriptions)SubscriptionsAbonnementExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesBTWExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUFinancialTransaction×2×2×2×2×2×2×2×2×2×2×2×2ExactOnlineREST.FinancialTransaction.BankEntries: Bank EntriesBankEntriesExactOnlineREST.General.CurrenciesCExactOnlineREST.FinancialTransaction.BankEntryLines: Bank Entry LinesBankEntryLinesExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.FinancialTransaction.CashEntries: Cash EntriesCashEntriesExactOnlineREST.General.CurrenciesCExactOnlineREST.FinancialTransaction.CashEntryLines: Cash Entry LinesCashEntryLinesExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.FinancialTransaction.TransactionLines: Transaction Lines (ExactOnlineREST.FinancialTransaction.TransactionLinesBulk, ExactOnlineREST.Incremental.TransactionLinesIncremental, ExactOnlineREST.Sync.SyncTransactionLines)TransactionLines+Bulk +Incremental +SyncExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.FinancialTransaction.Transactions: Transactions (ExactOnlineREST.Views.TransactionsIncremental)Transactions+IncrementalExactOnlineREST.Assets.Assets: AssetsAssetsActivaExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Documents.Documents: Documents (ExactOnlineREST.Documents.DocumentsBulk, ExactOnlineREST.Incremental.DocumentsIncremental, ExactOnlineREST.Sync.SyncDocuments)DocumentsDocumentenExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Financial.GLAccounts: General Ledger Accounts (ExactOnlineREST.Financial.GLAccountsBulk, ExactOnlineREST.Incremental.GLAccountsIncremental, ExactOnlineREST.Sync.SyncGLAccounts)GLAccountsFinancialExactOnlineREST.Users.UsersUExactOnlineREST.Financial.Journals: JournalsJournalsFinancialExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.HRM.Costcenters: Cost CentresCostcentersHRMExactOnlineREST.Users.UsersUExactOnlineREST.HRM.Costunits: Cost UnitsCostunitsHRMExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.Items: Items (ExactOnlineREST.Incremental.ItemsIncremental, ExactOnlineREST.Logistics.ItemsBulk, ExactOnlineREST.Logistics.ItemsRead, ExactOnlineREST.Sync.SyncItems)ItemsLogisticsExactOnlineREST.Users.UsersUExactOnlineREST.Manufacturing.ShopOrders: Shop Orders (ExactOnlineREST.Incremental.ShopOrdersIncremental, ExactOnlineREST.Sync.SyncShopOrders)ShopOrdersProductieExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectWBS: Project WBS (ExactOnlineREST.Incremental.ProjectWBSIncremental, ExactOnlineREST.Project.ProjectWBSBulk, ExactOnlineREST.Sync.SyncProjectWBS)ProjectWBSProjectExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProjectExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Subscription.Subscriptions: Subscriptions (ExactOnlineREST.Incremental.SubscriptionsIncremental, ExactOnlineREST.Sync.SyncSubscriptions)SubscriptionsAbonnementExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesBTWExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersULogistics×6×6×3×2×2×2ExactOnlineREST.Logistics.CustomerItems: Customer ItemsCustomerItemsExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.ItemChargeRelations: Charge RelationsItemChargeRelationsExactOnlineREST.General.CurrenciesCExactOnlineREST.Logistics.ItemGroups: Item GroupsItemGroupsExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.ItemVersions: Item VersionsItemVersionsExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.Items: Items (ExactOnlineREST.Incremental.ItemsIncremental, ExactOnlineREST.Logistics.ItemsBulk, ExactOnlineREST.Logistics.ItemsRead, ExactOnlineREST.Sync.SyncItems)Items+Bulk +Incremental +Read +SyncExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.SalesItemPrices: Sales Item Prices (ExactOnlineREST.Incremental.SalesItemPricesIncremental, ExactOnlineREST.Logistics.SalesItemPricesBulk, ExactOnlineREST.Sync.SyncSalesItemPrices)SalesItemPrices+Bulk +Incremental +SyncExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.SelectionCodes: Selection CodesSelectionCodesExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.SupplierItems: Supplier Items (ExactOnlineREST.Incremental.SupplierItemsIncremental, ExactOnlineREST.Sync.SyncSupplierItems)SupplierItems+Incremental +SyncExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.Units: UnitsUnitsExactOnlineREST.Financial.GLAccounts: General Ledger Accounts (ExactOnlineREST.Financial.GLAccountsBulk, ExactOnlineREST.Incremental.GLAccountsIncremental, ExactOnlineREST.Sync.SyncGLAccounts)GLAccountsFinancialExactOnlineREST.Users.UsersUVerkoperExactOnlineREST.Sales.SalesPriceListLinkedAccounts: Sales Price List Linked AccountsSalesPriceListLinkedAccountsExactOnlineREST.Users.UsersUExactOnlineREST.Sales.SalesPriceListPeriods: Sales Price List PeriodsSalesPriceListPeriodsExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Sales.SalesPriceListVolumeDiscounts: Sales Price List Volume Discounts (ExactOnlineREST.Incremental.SalesPriceListVolumeDiscountsIncremental, ExactOnlineREST.Sync.SyncSalesPriceListVolumeDiscounts)SalesPriceListVolumeDiscounts+Incremental +SyncExactOnlineREST.Users.UsersUExactOnlineREST.Sales.SalesPriceLists: Sales Price ListsSalesPriceListsExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Sales.ShippingMethods: Shipping MethodsShippingMethodsExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.ItemGroups: Item GroupsItemGroupsLogisticsExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.Items: Items (ExactOnlineREST.Incremental.ItemsIncremental, ExactOnlineREST.Logistics.ItemsBulk, ExactOnlineREST.Logistics.ItemsRead, ExactOnlineREST.Sync.SyncItems)ItemsLogisticsExactOnlineREST.Users.UsersUExactOnlineREST.Logistics.Units: UnitsUnitsLogisticsDocumenten×2×2×2×2×2ExactOnlineREST.Documents.DocumentAttachmentFiles: Document Attachment Files (ExactOnlineREST.Documents.DocumentAttachmentFilesBulk, ExactOnlineREST.Incremental.DocumentAttachmentFilesIncremental)DocumentAttachmentFiles+Bulk +IncrementalExactOnlineREST.Documents.DocumentAttachments: Document Attachments (ExactOnlineREST.Documents.DocumentAttachmentsBulk, ExactOnlineREST.Incremental.DocumentAttachmentsIncremental, ExactOnlineREST.Sync.SyncDocumentAttachments)DocumentAttachments+Bulk +Incremental +SyncExactOnlineREST.Documents.DocumentFolders: Document FoldersDocumentFoldersExactOnlineREST.Users.UsersUExactOnlineREST.Documents.DocumentTypeFolders: Document Type FoldersDocumentTypeFoldersExactOnlineREST.Users.UsersUExactOnlineREST.Documents.Documents: Documents (ExactOnlineREST.Documents.DocumentsBulk, ExactOnlineREST.Incremental.DocumentsIncremental, ExactOnlineREST.Sync.SyncDocuments)Documents+Bulk +Incremental +SyncExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.CRM.Contacts: Contacts (ExactOnlineREST.CRM.ContactsBulk, ExactOnlineREST.CRM.ContactsRead, ExactOnlineREST.Incremental.ContactsIncremental, ExactOnlineREST.Sync.SyncContacts)ContactsCRMExactOnlineREST.Users.UsersUExactOnlineREST.CRM.Opportunities: Opportunities (ExactOnlineREST.CRM.OpportunitiesRead)OpportunitiesCRMExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Payroll.EmploymentContracts: Employment Contracts (ExactOnlineREST.Incremental.EmploymentContractsIncremental, ExactOnlineREST.Sync.SyncEmploymentContracts)EmploymentContractsLonenExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProjectExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUAccountancyExactOnlineREST.Accountancy.AccountInvolvedAccounts: Account Involved AccountsAccountInvolvedAccountsExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Accountancy.AccountOwners: Account OwnersAccountOwnersExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Accountancy.CenterProfileDetails: Accountant Profile DetailsCenterProfileDetailsExactOnlineREST.CRM.AccountsAExactOnlineREST.Accountancy.CenterProfiles: Accountant ProfilesCenterProfilesExactOnlineREST.CRM.AccountsAExactOnlineREST.Accountancy.ExcludedDivisions: Excluded DivisionsExcludedDivisionsExactOnlineREST.CRM.AccountsAExactOnlineREST.Accountancy.InvolvedUserRoles: Involved User RolesInvolvedUserRolesExactOnlineREST.Users.UsersUExactOnlineREST.Accountancy.InvolvedUsers: Involved UsersInvolvedUsersExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Accountancy.SolutionLinks: Solution LinksSolutionLinksExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Accountancy.TaskTypes: Task TypesTaskTypesExactOnlineREST.Users.UsersUExactOnlineREST.Users.UserRoles: User RolesUserRolesGebruikersLicenceExactOnlineREST.Licence.MyBankAccounts: My Bank AccountsMyBankAccountsExactOnlineREST.Users.UsersUExactOnlineREST.Licence.OAuthClients: OAuth ClientsOAuthClientsExactOnlineREST.Users.UsersUExactOnlineREST.Licence.PartnerKeys: Partner KeysPartnerKeysExactOnlineREST.Users.UsersUExact OnlineFor Exact Online apps it was discouraged to use the CSV APIsand starting 2019 the use is almost impossible and requirestechniques that can lead to delisting or app blocks. ThereforeInvantive SQL includes the XML APIs and REST APIs. Bothdocumented as the many undocumented Exact Online APIs areincluded.API AuthenticationThe Invantive SQL driver for Exact Online allows multiple authentication models:• OAuth Code Grant Flow• OAuth Implicit Grant Flow without MFA• OAuth Implicit Grant Flow with MFAScrapingThe functionality of all APIs is identical independent of the chosen authentication models.Business professionals, finance professionals and developers can choose the authenticationmodel most suitable for API access.All Invantive products include "OAuth client" settings such as client ID. In compliance with OAuthsecurity recommendation, the code grant flow with an Invantive-controlled client ID and clientsecret is only used when the software runs on a device controlled by Invantive, such as on theExact Online Power BI driver on Invantive Cloud.The OAuth Implicit Grant Flow is used for interactive products such as the Excel add-in: InvantiveControl for Excel. By default, a re-authentication is necessary every ten minutes. The userpassword is automatically provided when "Remember Password" was checked on log in. The MFAverification code (also known as "TOTP") must be entered every ten minutes. You can specify thesecret key used for MFA verification process in the client software for an auto-generatedverification code, but this reduces the security.The OAuth security rules require the Implicit Grant Flow for deployment on a device not undercontrol of the client app owner. However, you or a your developers can register your owncompany client on apps.exactonline.com. Use the client ID and client secret generated by Exactand use the form "Pre-authenticate" on Invantive Cloud to generate a refresh token. Optionally,you can request through Invantive Support that obsoletion of the refresh tokens is disabled foryour client.Authentication using scraping is possible, for instance for non-browser logins from a consoleapplication, but is highly discouraged and might be obsoleted without further notice.Exact Online REST API and Popular TablesThe Exact Online REST API is most commonly used. Some of the most popular tables from theREST API are:• TransactionLinesBulk: financial transaction accounting details• AccountsBulk: customers and suppliers• GLAccountsBulk: general ledger accounts• ItemsBulk: articles.• DocumentAttachmentFilesBulk: documents in binary format such as accounting documentsThe REST API has in general great download performance. Additionally, the Exact REST API hasfilter capabilities on many columns, allowing use of server-side filtering in an translation ofwhere-clauses in Invantive SQL leading to highly optimized REST API calls. Also the REST API allowscomplex join optimizations leading to highly reduced execution times compared to full downloadsof multiple tables and joining them on the client. Incremental download facilities are available forfurther reducing the number of API calls and meeting Exact's strict rate limit policies.OnderwerpenAbonnement2Accountancy1Activa2Activiteiten2Algemeen3BankGateway3BTW3Budget2Cashflow2ContinuousMonitoring3CRM2Documenten1Financial2FinancialTransaction1Gebruikers2GeneralJournalEntry3HRM2Inkoop2Inventaris2Licence1Logistics1Lonen2OpeningBalance2Postvak2Productie1Project1PurchaseEntry3PurchaseOrder2SalesEntry2SalesInvoice1SalesOrder1Systeem3Verkoper1Webhooks3Workflow3Tabeller uden relationen3, 4LegendaTransactioneelInrichtingTechnischVastgelegde waardenUitgelegd in een ander onderwerpVerklaarde sleutelDe relatie in woorden beschrevenKandidaat afgeleid van kolomnamenVetgedrukt: een populaire tabel+Bulk, +Lezen: de tabel bestaat ook in deze varianten\u00D7n: n toetsen tussen dezelfde tabellenBrieven: verwijst naar een tabel die bij de meeste onderwerpen wordt gebruikt: U = Users, A = Accounts,C = CurrenciesGegenereerd op basis van de metagegevens van Invantive UniversalSQL 27.1.3-BETA+6294 op 01-11-2026. Elketabel bevat een link naar de bijbehorende pagina met kolommen, sleutels en voorbeeldquery's.documentation.invantive.eu/nl/datamodels/exactonline
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden

Financial

AgingOverview, AgingOverviewOverdue, AgingPayablesList, AgingPayablesListOverdue, AgingReceivablesList, AgingReceivablesListOverdue, CashflowBalance, DeductibilityPercentages, ExchangeRates, FinancialPeriods, GLAccountClassificationMappings, GLAccounts, GLClassifications, GLSchemes, Journals, OfficialReturns, PayablesList, PayablesListOverdue, ProfitLossOverview, ProfitLossPeriodCompareList, ReceivablesList, ReceivablesListOverdue, ReportingBalance, Returns, RevenueByDebtorList

Productie

BillOfMaterialMaterials, BillOfMaterialVersions, ByProductReceipts, ByProductReversals, MaterialIssues, MaterialReversals, MfgItemWarehouseStorageLocations, MfgSalesOrderlines, MfgTimeTransactions, OperationResources, Operations, ProductionAreas, ShopOrderMaterialPlanDetails, ShopOrderMaterialPlans, ShopOrderReceipts, ShopOrderReversals, ShopOrderRoutingStepPlans, ShopOrders, StageForDeliveryReceipts, StageForDeliveryReversals, SubOrderReceipts, SubOrderReversals, TimedTimeTransactions, Workcenters

Project

CostTransactions, EmployeeRestrictionItems, EmploymentInternalRates, InvoiceTerms, PjtTimeTransactions, ProjectAccountMutations, ProjectHourBudgets, ProjectPlanning, ProjectPlanningRecurring, ProjectRestrictionEmployeeItems, ProjectRestrictionEmployees, ProjectRestrictionItems, ProjectRestrictionRebillings, ProjectWBS, Projects, RecentCosts, RecentHours, TimeCorrections, WBSActivities, WBSDeliverables, WBSExpenses

CRM

AccountClasses, AccountClassificationNames, AccountClassifications, Accounts, Addresses, BankAccounts, BusinessTypes, Contacts, CrmDocuments, HostingOpportunities, LeadPurposes, LeadSources, Opportunities, OpportunityContactsRead, OpportunityStages, QuotationLines, Quotations, ReasonCodes, SalesTypes

HRM

AbsenceRegistrationTransactions, AbsenceRegistrations, CompanyCars, Costcenters, Costunits, Departments, DivisionClassNames, DivisionClassValues, DivisionClasses, EmploymentCompanyCars, HrmDivisions, JobGroups, JobTitles, LeaveBuildUpRegistrations, LeaveRegistrations, Schedules

Inventaris

AssemblyOrders, BatchNumbers, ItemWarehousePlanningDetails, ItemWarehouseStorageLocations, ItemWarehouses, SerialNumbers, StockBatchNumbers, StockCountLines, StockCounts, StockSerialNumbers, StorageLocations, WarehouseTransferLines, WarehouseTransfers, Warehouses

SalesOrder

DigitalOrderPickingLines, DigitalOrderPickings, GoodsDeliveries, GoodsDeliveryLines, PlannedSalesReturnLines, PlannedSalesReturns, SalesOrderLayouts, SalesOrderLines, SalesOrderStockBatchNumbers, SalesOrderStockSerialNumbers, SalesOrderStorageLocationsBulk, SalesOrders

Accountancy

AccountInvolvedAccounts, AccountOwners, CenterProfileDetails, CenterProfiles, ExcludedDivisions, InvolvedUserRoles, InvolvedUsers, SolutionLinks, TaskTypes

ContinuousMonitoring

IndicatorBalances, IndicatorDeviatingAmountEntereds, IndicatorDifferenceByPeriods, IndicatorDifferentVatCodes, IndicatorGLAccounts, IndicatorLiquidities, IndicatorSignals, IndicatorStates, IndicatorUsageOfJournals

Logistics

CustomerItems, ItemChargeRelations, ItemGroups, ItemVersions, Items, SalesItemPrices, SelectionCodes, SupplierItems, Units

Lonen

ActiveEmployments, Employees, EmploymentConditionGroups, EmploymentContracts, EmploymentOrganizations, EmploymentSalaries, Employments, TaxEmploymentEndFlexCodes, VariableMutations

Cashflow

AllocationRule, BankLinks, Banks, DirectDebitMandates, ImportNotifications, PaymentConditions, Payments, Receivables

Activiteiten

CommunicationNotes, Complaints, Events, Messages, ServiceRequests, Tasks

FinancialTransaction

BankEntries, BankEntryLines, CashEntries, CashEntryLines, TransactionLines, Transactions

Postvak

DefaultMailbox, MailMessagesReceived, MailMessagesReceivedByMailbox, MailMessagesSent, Mailboxes, PreferredMailbox

PurchaseOrder

GoodsReceiptLines, GoodsReceipts, PurchaseOrderLines, PurchaseOrderStockBatchNumbers, PurchaseOrderStockSerialNumbers, PurchaseOrders

Abonnement

SubscriptionLines, SubscriptionReasonCodes, SubscriptionRestrictionEmployees, SubscriptionRestrictionItems, SubscriptionTypes, Subscriptions

Documenten

DocumentAttachmentFiles, DocumentAttachments, DocumentFolders, DocumentTypeFolders, Documents

Verkoper

SalesPriceListLinkedAccounts, SalesPriceListPeriods, SalesPriceListVolumeDiscounts, SalesPriceLists, ShippingMethods

BTW

TaxComponentRates, TaxScheduleComponents, TaxSchedules, VATCodes, VatPercentages

OpeningBalance

CurrentYearAfterEntry, CurrentYearProcessed, PreviousYearAfterEntry, PreviousYearProcessed

Systeem

GetCurrentDivision, GetMostRecentlyUsedDivisions, Me, SystemDivisions

Activa

AssetGroups, Assets, DepreciationMethods

Licence

MyBankAccounts, OAuthClients, PartnerKeys

SalesInvoice

Layouts, SalesInvoiceLines, SalesInvoices

Gebruikers

UserRoles, UserRolesPerDivision, Users

Budget

BudgetScenarios, Budgets

GeneralJournalEntry

GeneralJournalEntries, GeneralJournalEntryLines

Inkoop

PurchaseInvoiceLines, PurchaseInvoices

PurchaseEntry

PurchaseEntries, PurchaseEntryLines

SalesEntry

SalesEntries, SalesEntryLines

BankGateway

BankSubscriptions

Algemeen

Currencies

Webhooks

WebhookSubscriptions

Workflow

CustomerCooperations

Accountancy (zonder relaties)

CenterFilters, CenterProfileCertifications, CenterProfileLocations, CenterTags, Certifications, CollaborationRequests, DeclarationRenderData, DeclarationUploads, QuestionListClientLists, QuestionListClientQuestions, QuestionListClientSections, StopCollaboration, StopCollaborationByAccountant

Activiteiten (zonder relaties)

InContextRequests, RequestAttachments

AppCenter (zonder relaties)

AppDetails, AppExactOnlineProducts, AppExactOnlineSolutionFilterSubscriptions, AppExactOnlineSolutions, AppPricePlanElements, AppPricePlans, AppReviews, Apps

Activa (zonder relaties)

CommercialBuildingValues

Saldi (zonder relaties)

BalanceLineTotalsCostAnalysisAll, BalanceLineTotalsCostAnalysisAllProcessed, BalanceLinesCostAnalysisAll, BalanceLinesCostAnalysisAllProcessed, BalanceLinesPerPeriodAll, BalanceLinesPerPeriodCostAnalysisAll

CRM (zonder relaties)

AddressStates, DocumentFolderContentsByFolderId, DocumentsAttachments, DossierDocumentFolderContent, EmailWithSignOffQuotation, OptionalQuotationLineID, QuotationOrderChargeLines

Cashflow (zonder relaties)

ImportNotificationDetails, InternalPayments, Lines, PaymentIDs, ProcessPayments, Statements, TransactionIdentifiers

CodeValues (zonder relaties)

AbsenceRegistrationTransactionStatuses, AccountConsolidationScenarios, AccountCustomerStatuses, AccountTypes, AddressTypes, AssemblyOrderStatuses, AssetStatuses, BalanceSides, BalanceTypes, BankAccountTypes, BankStatuses, BelgiumBelcoTaxTypes, BelgiumInvestmentDeductions, BelgiumVatGlAccountTypes, BlockingStatuses, BusinessComponents, CalculatorTypes, CommunicationNoteStatuses, ComplaintStatuses, CostTransactionStatuses, CreditCardTypes, CreditManagementScenarioRuleActionStarts, CreditManagementScenarioRuleActions, DdMandatePaymentTypes, DdMandateTypes, DepreciationIntervals, DepreciationMethodTypes, DirectDebitMandatePaymentTypes, DirectDebitMandateTypes, DivisionStatuses, EmploymentContractReasons, EmploymentContractTypes, EngineTypes, EntryTemplateLineAmountCalculations, EntryTemplateTransactionStatuses, EttSources, EuSalesListings, EventStatuses, GLAccountTypes, IndicatorValidationOperator, IntrastatTypes, InvoiceAttachmentTypes, InvoiceStatuses, InvoiceTypes, InvoicingMethods, ItemVersionStatuses, ItemVersionTypes, JournalStatuses, JournalTypes, LayoutTypes, LeaveBuildUpRegistrationStatuses, LeaveRegistrationStatuses, Legislations, ManufacturedBillOfMaterialStatuses, ManufacturedBillofMaterialRoutingDetailFactorTypes, ManufacturedBillofMaterialRoutingDetailRoutingStepTypes, ManufacturedBillofMaterialRoutingDetailRunMethods, ManufacturedBillofMaterialRoutingDetailSetupTypes, ManufacturingTimeTransactionActivities, ManufacturingTimeTransactionHourStatuses, MaterialPlanStatuses, MaterialPurchaseOrderAssignSupplierVias, OperationResourceTypes, OperationStatuses, OpportunityStatuses, PaymentDiscountTypes, PaymentMethods, PaymentServiceProviders, PaymentSources, PaymentStatuses, PeppolIdentifierTypes, ProjectPlanningBgtStatuses, ProjectPlanningCommunicationErrorStatuses, ProjectPlanningLineStatuses, ProjectPlanningStatuses, ProjectPlanningTypes, ProjectPrepaidTypes, ProjectTimeTransactionHourStatuses, ProjectTypes, PurchaseInvoiceSources, PurchaseInvoiceTypes, PurchaseOrderSources, PurchaseOrderStatuses, QuotationStatuses, RGS10Codes, RGS10Hoofdrubrieken, RGS10Mutaties, RGS10Rekeningen, RGS10Rubrieken, RGS11Codes, RGS11Hoofdrubrieken, RGS11Mutaties, RGS11Rekeningen, RGS11Rubrieken, RGS20Codes, RGS30Codes, ReceivableSources, ReceivableStatuses, RecipientStatuses, ReturnStatuses, SalesEntryStatuses, SalesEntryTypes, SalesForecastPeriodTypes, SalesOrderStatuses, ScheduleTypes, ServiceRequestStatuses, SettingValueTypes, ShopOrderByProductPlanStatuses, ShopOrderRoutingPlanStatuses, ShopOrderRoutingStepFactorTypes, ShopOrderRoutingStepRunMethods, ShopOrderRoutingStepTypes, ShopOrderStatuses, ShopOrderStockReceiptDispositions, SolutionLinkStatuses, SolutionTypes, StandardTaskTypes, StockTransactionTypes, SubcontractPurchaseOrderAssignSupplierVias, SubscriptionLineLineTypes, TaskStatuses, TaxReturnTypes, TrackingNumberStatuses, TrackingNumberTypes, TransactionStatuses, TransactionTypes, UnitTypes, UserAuthenticationTypes, VATCalculations, VatDocTypes, VatInclusionTypes, VatSystems, VatTransactionTypes, VatTypes, WBSTypes, WarehouseTransferStatuses, WebhookTopics, WorkcenterRunMethods, WorkcenterSetupUnits, WorkcenterStatuses, WorkcenterTypes, WriteOffTypes, XmlMessageTypes

Documenten (zonder relaties)

DocumentCategories, DocumentTypeCategories, DocumentTypes, EolDmsDocuments

ExactOnlineREST Native (zonder relaties)

NATIVEPLATFORMSCALARREQUESTS

Financial (zonder relaties)

FinancialYears, FinancialYears2, FiscalVatEntities, GLTransactionSources, GLTransactionTypes, JournalStatusList, Notes, OutstandingInvoicesOverview, ProcessReturn, RevenueList, RgsAccountSchemes, RgsBrugstaatDetailData

Algemeen (zonder relaties)

Layouts

Global (zonder relaties)

IBANFormats

HRM (zonder relaties)

HrmDivisionClassifications, LeaveAbsenceHoursByDay, ScheduleEntries

Incremental (zonder relaties)

EmploymentCLAsIncremental, ItemStorageLocationsIncremental, PaymentTermsIncremental, PayrollBankAccountsIncremental, ProjectPlanningsIncremental, QuotationLinesV2Incremental, QuotationsV2Incremental, SalesOrderLinesV2Incremental, SalesOrdersV2Incremental, SerialBatchNumbersIncremental, StockPositionsIncremental, StockSerialBatchNumbersIncremental, TimeCostTransactionsIncremental

Intern (zonder relaties)

CompanyNames

Inventaris (zonder relaties)

AssemblyBillOfMaterialHeaders, AssemblyBillOfMaterialMaterials, AssemblyOrderPartItems, BatchQuantitiesPerLocations, BatchQuantitiesPerWarehouses, FinishAssemblyOrder, InventorySettings, ProcessStockCount, ProcessWarehouseTransfer, StorageLocationStockPositions

Licence (zonder relaties)

GetAllPartnerKeys, OAuthClientsWithSecrets, OAuthScopes, RevokedOAuthPermission

Logistics (zonder relaties)

Incoterms, ItemAssortmentProperties, ItemAssortments, ItemDetails, ItemExtraFieldValues, ReasonCodes, ReasonCodesLinkTypes

Postvak (zonder relaties)

MailMessageAttachments, MailMessagesReceivedUnhandled, MailMessagesSentUnhandled

Productie (zonder relaties)

BillOfMaterialRoutings, EmployeeWorkcenters, ManufacturingSettings, RecentTimeTransactions, ShopOrderPriorities, ShopOrderRoutingStepPlansAvailable, StartedTimedTimeTransactions

OfficeApp (zonder relaties)

MsTeamsMeetingReferences, MsTeamsReferences, ReportingUser

Lonen (zonder relaties)

EmploymentContractFlexPhases, EmploymentEndReasons, EmploymentTaxAuthoritiesGeneral, FiscaalGemakEmployments, FiscaalGemakPeriodCalculations, PayrollComponents, PayrollTransactions, PayrollTransactionsAll, RestoreEmployment, ScheduleEntries, WageScaleDetails, WageScales

Project (zonder relaties)

CostTypes, HourCostTypes, HourTypes, PjtTimeEntryAttachments, ProjectBudgetTypes, ProjectClassifications, ProjectProgressReports, TimeAndBillingAccountDetails, TimeAndBillingActivitiesAndExpenses, TimeAndBillingEntryAccounts, TimeAndBillingEntryProjects, TimeAndBillingEntryRecentAccounts, TimeAndBillingEntryRecentActivitiesAndExpenses, TimeAndBillingEntryRecentHourCostTypes, TimeAndBillingEntryRecentProjects, TimeAndBillingItemDetails, TimeAndBillingProjectDetails, TimeCostEntryFavorites

PurchaseEntry (zonder relaties)

Approval

PurchaseOrder (zonder relaties)

GoodsReceiptLineBatchNumbers, GoodsReceiptLineSerialNumbers, PurchaseOrderBatchQuantitiesPerLocations, PurchaseOrderBatchQuantitiesPerWarehouses, PurchasePlanningShopOrderMaterialPlans, PurchasePlanningShopOrderRoutingStepPlans, PurchaseReturnLineBatchNumbers, PurchaseReturnLineSerialNumbers, PurchaseReturnLines, PurchaseReturns

RGS (zonder relaties)

RGS10CodeRelations, RGS11CodeRelations, RGS20CodeRelations, RGS30CodeRelations

Verkoper (zonder relaties)

OrderCharges, SalesChannels

SalesEntry (zonder relaties)

CreditedSalesInvoices

SalesInvoice (zonder relaties)

SalesInvoiceOrderChargeLines

SalesOrder (zonder relaties)

CompleteSalesOrder, CompleteSalesOrderLine, DigitalOrderPickingLocations, DropShipmentLines, DropShipments, GoodsDeliveryLineBatchNumbers, GoodsDeliveryLineSerialNumbers, SalesOrderBatchQuantitiesPerLocations, SalesOrderBatchQuantitiesPerWarehouses, SalesOrderOrderChargeLines

Abonnement (zonder relaties)

SubscriptionLineTypes

Sync (zonder relaties)

SyncDeleted, SyncEmploymentCLAs, SyncEmploymentOrganizationCostCenters, SyncItemStorageLocations, SyncPaymentTerms, SyncPayrollBankAccounts, SyncProjectPlannings, SyncPurchaseItemPrices, SyncQuotationLinesV2, SyncQuotationsV2, SyncSalesOrderLinesV2, SyncSalesOrdersV2, SyncSerialBatchNumbers, SyncShopOrderPurchasePlanning, SyncShopOrderSubOrders, SyncStockPositions, SyncStockSerialBatchNumbers, SyncTimeCostTransactions

Systeem (zonder relaties)

AccountantInfo, AvailableFeatures, ExactInfo, Settings, SmartphoneMenu, SmartphoneRights, SystemDivisionClassifications

Views (zonder relaties)

APOutstandingItemsPerFinancialPeriodUltimo, APOutstandingItemsPerFinancialYearUltimo, AROutstandingItemsPerFinancialPeriodUltimo, AROutstandingItemsPerFinancialYearUltimo, FinancialYearsExtended, OutstandingInvoicesPerJournalType, RequestTablesWithoutRights, SystemDivisionsToQuery, UserRoleProperties

Workflow (zonder relaties)

RequestAttachments

DataDictionary (zonder relaties)

IncrementalEntityTypes, IncrementalLoadDataFiles, IncrementalLoadEventLogEntries, IncrementalLoadStatistics, IncrementalLoadStatuses, RowCounts

Unsupported (zonder relaties)

Backups

ExactOnlineXML Native (zonder relaties)

NATIVEPLATFORMSCALARREQUESTS

XML (zonder relaties)

APOutstandingItems, APs, AROutstandingItems, ARs, AccountAddresses, AccountBankAccounts, AccountClassifications, AccountContacts, AccountDDMandates, AccountVATPurchaseBoxes, Accounts, ActivitySectors, AdministrationTypes, Agencies, AllAdministrationAssignedTypes, AllAdministrationClassifications, AllAdministrationCustomers, AllAdministrations, AllUserAdministrations, AllUsers, AllocationRules, AssemblyOrders, AssetGroups, Assets, BalanceLines, BalanceLinesCostAnalysis, BalanceLinesCostAnalysisProcessed, BalanceLinesPerPeriod, BalanceLinesPerPeriodCostAnalysis, BalanceLinesPerPeriodCostAnalysisProcessed, BalanceLinesPerPeriodProcessed, BalanceLinesProcessed, Balances, BalancesProcessed, BankLinks, BillOfMaterialItemDetails, BillOfMaterials, BudgetLines, BudgetLinesPerPeriod, BudgetScenarios, Budgets, BusinessTypes, CompanySizes, CostTransactionDocumentAttachments, CostTransactions, Costcenters, Costunits, CreditManagementScenarios, CreditManagementStatuses, DDMandates, Deliveries, DeliveryLines, DeliverySplitLineStockTransactionLocations, DeliverySplitLines, Departments, DepositDetails, Deposits, DepreciationMethods, DocumentAttachments, DocumentImages, Documents, EmployeeWorkcenters, Employees, EmploymentAgenciesTax, EmploymentCLAs, EmploymentContracts, EmploymentOrganizations, EmploymentSalaries, Employments, EntryTemplateLinks, EntryTemplateTransactions, EntryTemplates, ExchangeRates, ExtraFieldDefinitions, FinPeriods, FinYears, FinishedAssemblies, FinishedAssemblySerialNumberPartSerialNumbers, FinishedAssemblySerialNumberParts, FinishedAssemblySerialNumbers, GLAccountCategories, GLAccountClassificationRelations, GLAccountClassificationSchemeTranslations, GLAccountClassificationSchemes, GLAccountClassificationTranslationsLevel1, GLAccountClassificationTranslationsLevel10, GLAccountClassificationTranslationsLevel2, GLAccountClassificationTranslationsLevel3, GLAccountClassificationTranslationsLevel4, GLAccountClassificationTranslationsLevel5, GLAccountClassificationTranslationsLevel6, GLAccountClassificationTranslationsLevel7, GLAccountClassificationTranslationsLevel8, GLAccountClassificationTranslationsLevel9, GLAccountClassifications, GLAccountClassificationsLevel1, GLAccountClassificationsLevel10, GLAccountClassificationsLevel2, GLAccountClassificationsLevel3, GLAccountClassificationsLevel4, GLAccountClassificationsLevel5, GLAccountClassificationsLevel6, GLAccountClassificationsLevel7, GLAccountClassificationsLevel8, GLAccountClassificationsLevel9, GLAccounts, GLClassificationMemberAccounts, GLClassificationMemberClassifications, GLSchemes, GLTransactionDocumentAttachments, GLTransactionLines, GLTransactions, HRMSubscriptions, Indicators, InvoiceDocumentAttachments, InvoiceLines, Invoices, ItemAccounts, ItemAssortmentValues, ItemPrices, ItemSalesPriceVATBoxLinks, ItemTranslations, ItemWarehouses, Items, JobGroups, JobTitles, Journals, LeadPurposes, LeadRatings, LeadSources, LeadStages, Leads, ManufacturedBillOfMaterialItemDetails, ManufacturedBillOfMaterialRoutingDetails, ManufacturedBillOfMaterials, ManufacturingProjects, ManufacturingTimeTransactions, MatchSetLines, MatchSets, MaterialIssueSplitIssueLines, MaterialIssues, MaterialPurchaseOrders, NationalHolidays, OperationResources, Operations, Opportunities, OpportunityStages, OwnerAdministrationAssignedTypes, OwnerAdministrationClassifications, OwnerAdministrations, OwnerUserAdministrations, OwnerUsers, PaymentConditions, PayrollComponentGroups, PayrollComponentInputs, PayrollComponentOutputs, PayrollComponentSubtotalLinks, PayrollComponents, PayrollEntries, PayrollGLLinks, PayrollPeriods, PayrollYears, ProductionAreas, ProjectPlanningLines, ProjectPlanningLinesExtended, Projects, PurchaseOrderDocumentAttachments, PurchaseOrderLines, PurchaseOrders, QuotationLines, Quotations, ReasonCodes, ReceiptLines, ReceiptSplitLineStockTransactionLocations, ReceiptSplitLines, Receipts, SalesOrderDocumentAttachments, SalesOrderLines, SalesOrders, SalesTypes, Settings, ShippingMethods, ShopOrderMaterialPlans, ShopOrderRoutingPlans, ShopOrderStockReceiptSplitByProducts, ShopOrderStockReceiptSplitShopOrderStocks, ShopOrderStockReceipts, ShopOrders, StockCountLines, StockCounts, StockPositions, Students, SubcontractPurchaseOrders, SubscriptionEmployees, SubscriptionItems, SubscriptionLines, SubscriptionTypes, Subscriptions, TaxComponents, TaxSchedules, TimeTransactionDocumentAttachments, TimeTransactions, TimeTransactionsExtended, Titles, TrackingNumbers, UploadXMLTopicFragments, UploadXMLTopics, UserProfiles, UserTypes, VATBoxLinks, VATPercentages, VATs, WBSActivitiesLevel1, WBSActivitiesLevel2, WBSActivitiesLevel3, WBSActivitiesLevel4, WBSActivitiesLevel5, WBSActivitiesLevel6, WBSActivitiesLevel7, WBSActivitiesLevel8, WBSDeliverablesLevel1, WBSDeliverablesLevel2, WBSDeliverablesLevel3, WBSDeliverablesLevel4, WBSDeliverablesLevel5, WBSDeliverablesLevel6, WBSDeliverablesLevel7, WBSDeliverablesLevel8, WBSExpensesLevel1, WBSExpensesLevel2, WBSExpensesLevel3, WBSExpensesLevel4, WBSExpensesLevel5, WBSExpensesLevel6, WBSExpensesLevel7, WBSExpensesLevel8, WBSTemplates, WageScales, WarehouseItems, WarehouseStorageLocations, WarehouseTransferLines, WarehouseTransfers, Warehouses, WebShopSalesOrderDeliveries, WebShopSalesOrderDeliveryLineItems, WebShopSalesOrders, WorkBreakdownStructures, WorkCenters

Relaties

Tabellen

ExactOnlineDataDictionary.DataDictionary

ExactOnlineHTML.Documents

ExactOnlineHTML.Unsupported

ExactOnlineREST.Accountancy

ExactOnlineREST.Activities

ExactOnlineREST.AppCenter

ExactOnlineREST.Assets

ExactOnlineREST.Balances

ExactOnlineREST.BankGateway

ExactOnlineREST.Budget

ExactOnlineREST.CRM

ExactOnlineREST.Cashflow

ExactOnlineREST.CodeValues

ExactOnlineREST.ContinuousMonitoring

ExactOnlineREST.CustomFields

ExactOnlineREST.Documents

ExactOnlineREST.Financial

ExactOnlineREST.FinancialTransaction

ExactOnlineREST.General

ExactOnlineREST.GeneralJournalEntry

ExactOnlineREST.Global

ExactOnlineREST.HRM

ExactOnlineREST.Incremental

ExactOnlineREST.Internal

ExactOnlineREST.Inventory

ExactOnlineREST.Licence

ExactOnlineREST.Logistics

ExactOnlineREST.Mailbox

ExactOnlineREST.Manufacturing

ExactOnlineREST.Native

ExactOnlineREST.OfficeApp

ExactOnlineREST.OpeningBalance

ExactOnlineREST.Payroll

ExactOnlineREST.Project

ExactOnlineREST.Purchase

ExactOnlineREST.PurchaseEntry

ExactOnlineREST.PurchaseOrder

ExactOnlineREST.RGS

ExactOnlineREST.Sales

ExactOnlineREST.SalesEntry

ExactOnlineREST.SalesInvoice

ExactOnlineREST.SalesOrder

ExactOnlineREST.Subscription

ExactOnlineREST.Sync

ExactOnlineREST.System

ExactOnlineREST.Users

ExactOnlineREST.VAT

ExactOnlineREST.Views

ExactOnlineREST.Webhooks

ExactOnlineREST.Workflow

ExactOnlineXML.Native

ExactOnlineXML.XML

Voorbeeldqueries

--
-- Financial transaction lines from all journals and selected companies. Note that LineNumber 0 reflects the header and 9999 the VAT.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/exact-online-data-model/webhelp/exact-online-connector-exactonlinerest-incremental-transactionlinesincremental.html
--
-- Related forum post: https://forums.invantive.eu/t/recommended-and-popular-exact-online-tables-for-2022/2340
--
select *
from   ExactOnlineREST.Incremental.TransactionLinesIncremental@eol
limit  100
--
-- Retrieve list of all Exact Online companies. For accountants, companies of customers are also included.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/exact-online-data-model/webhelp/exact-online-connector-exactonlinerest-system-systemdivisions.html
--
-- Related forum post: https://forums.invantive.eu/t/selecting-partitions-administrations-via-the-use-sql-statement/2172
--
select *
from   ExactOnlineREST.System.SystemDivisions@eol
limit  100

Attributen

The attributes of this platform are on the page Attributes.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: