invantive documentation
Invantive SupportforenAnmelden / Eintragen

Exact Online Data Model

Der Exact Online-Treiber bietet über 1.000 Tabellen die über eine Reihe von XML-API's, REST-API's und einigen speziellen API's gruppiert sind.

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 Code Grant Flow

  • 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.

Richten Sie diese Plattform in der Invantive Cloud ein: https://cloud.invantive.com/exactonline

The data is partitioned per Administration (Division).

Bei Textvergleichen auf dieser Plattform wird zwischen Groß- und Kleinschreibung unterschieden.

Plattform

  • Verwendung über: Invantive Cloud und die Invantive-Produkte auf Ihrem eigenen Computer oder Server.
  • Art: Eine Anwendung, auf die über ihre API zugegriffen wird.
  • Die Daten sind partitioniert, beispielsweise nach Unternehmen oder Verwaltungsbereich.
  • Mit einer Query können mehrere Unternehmen gleichzeitig abgerufen werden.
  • Daten können sowohl geschrieben als auch gelesen werden.
  • 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.

Angaben

Figure Count
Tables 1,239
Columns 1,553,883
Tabellen mit Einfügung 699
Tabellen mit Aktualisierung 685
Tabellen mit Löschfunktion 312
Tabellen dokumentiert 395

Poster zum Daten Muster

PDF, 4 A0-Blätter

Auf einer Tabelle des Posters: Zoom-Vergrößerung und Zoom-Verkleinung, mit den Pfeiltasten bewegen, 0 passt.

Exact Online Daten Muster, Seite 1 von 4Exact Online Daten Musterzur Verwendung mit Invantive UniversalSQLVeröffentlichung 27.1.3-BETA+6294 · 01-11-2026SalesOrder · Projekt · Herstellung · SalesInvoice · FinancialTransaction · Logistics · Verkauf · Dokumente · Accountancy · LicenceSeite 1 von 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)DocumentsDokumenteExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.HRM.Costcenters: Cost CentresCostcentersHRMExactOnlineREST.Users.UsersUExactOnlineREST.HRM.Costunits: Cost UnitsCostunitsHRMExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.BatchNumbers: Batch NumbersBatchNumbersInventarExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.SerialNumbers: Serial NumbersSerialNumbersInventarExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.StockCountLines: Stock Count LinesStockCountLinesInventarExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.StorageLocations: Storage LocationsStorageLocationsInventarExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.Warehouses: Warehouses (ExactOnlineREST.SalesOrder.WarehousesBulk)WarehousesInventarExactOnlineREST.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)ShopOrdersHerstellungExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProjektExactOnlineREST.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 ListsSalesPriceListsVerkaufExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Sales.ShippingMethods: Shipping MethodsShippingMethodsVerkaufExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesUmsatzsteuerExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUProjekt×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)EmployeesLohn-und GehaltsabrechnungExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Payroll.Employments: Employments (ExactOnlineREST.Incremental.EmploymentsIncremental, ExactOnlineREST.Sync.SyncEmployments)EmploymentsLohn-und GehaltsabrechnungExactOnlineREST.Users.UsersUExactOnlineREST.Subscription.Subscriptions: Subscriptions (ExactOnlineREST.Incremental.SubscriptionsIncremental, ExactOnlineREST.Sync.SyncSubscriptions)SubscriptionsAbonnementExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesUmsatzsteuerExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUHerstellung×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 LocationsStorageLocationsInventarExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.Warehouses: Warehouses (ExactOnlineREST.SalesOrder.WarehousesBulk)WarehousesInventarExactOnlineREST.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)EmployeesLohn-und GehaltsabrechnungExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProjektExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesUmsatzsteuerExactOnlineREST.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)DocumentsDokumenteExactOnlineREST.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)WarehousesInventarExactOnlineREST.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)EmployeesLohn-und GehaltsabrechnungExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectWBS: Project WBS (ExactOnlineREST.Incremental.ProjectWBSIncremental, ExactOnlineREST.Project.ProjectWBSBulk, ExactOnlineREST.Sync.SyncProjectWBS)ProjectWBSProjektExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProjektExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Sales.SalesPriceLists: Sales Price ListsSalesPriceListsVerkaufExactOnlineREST.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 CodesVATCodesUmsatzsteuerExactOnlineREST.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: AssetsAssetsAktivpostenExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Documents.Documents: Documents (ExactOnlineREST.Documents.DocumentsBulk, ExactOnlineREST.Incremental.DocumentsIncremental, ExactOnlineREST.Sync.SyncDocuments)DocumentsDokumenteExactOnlineREST.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)ShopOrdersHerstellungExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectWBS: Project WBS (ExactOnlineREST.Incremental.ProjectWBSIncremental, ExactOnlineREST.Project.ProjectWBSBulk, ExactOnlineREST.Sync.SyncProjectWBS)ProjectWBSProjektExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProjektExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Subscription.Subscriptions: Subscriptions (ExactOnlineREST.Incremental.SubscriptionsIncremental, ExactOnlineREST.Sync.SyncSubscriptions)SubscriptionsAbonnementExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesUmsatzsteuerExactOnlineREST.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.UsersUVerkaufExactOnlineREST.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: UnitsUnitsLogisticsDokumente×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)EmploymentContractsLohn-und GehaltsabrechnungExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProjektExactOnlineREST.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 RolesUserRolesBenutzerLicenceExactOnlineREST.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.ThemenAbonnement2Accountancy1Aktivitäten2Aktivposten2Allgemein3BankGateway3Benutzer2Budget2Cashflow2ContinuousMonitoring3CRM2Dokumente1Financial2FinancialTransaction1GeneralJournalEntry3Herstellung1HRM2Inventar2Kauf2Licence1Logistics1Lohn-und Gehaltsabrechnung2OpeningBalance2Postfach2Projekt1PurchaseEntry3PurchaseOrder2SalesEntry2SalesInvoice1SalesOrder1System3Umsatzsteuer3Verkauf1Webhooks3Workflow3Tabellen ohne Beziehungen3, 4LegendeTransaktionalSetupTechnischFest codierte WerteIn einem anderen Thema definiertDeklarierter SchlüsselIn Worten beschriebene BeziehungAus Spaltennamen abgeleiteter KandidatFett: eine beliebte Tabelle+Bulk, +Read: Die Tabelle ist auch in diesen Varianten verfügbar\u00D7n: n Schlüssel zwischen denselben TabellenBuchstaben: Bezieht sich auf eine Tabelle, die in den meisten Themen verwendet wird: U = Users, A =Accounts, C = CurrenciesErstellt anhand der Metadaten von Invantive UniversalSQL 27.1.3-BETA+6294 am 01-11-2026. Jede Tabelle enthälteinen Link zu ihrer Seite mit Spalten, Schlüsseln und Beispiel-Queries.documentation.invantive.eu/de/datamodels/exactonline
Das Poster als Text: Tabellen nach Themen und deren Zusammenhänge

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

Herstellung

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

Projekt

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

Inventar

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

Lohn-und Gehaltsabrechnung

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

Cashflow

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

Aktivitäten

CommunicationNotes, Complaints, Events, Messages, ServiceRequests, Tasks

FinancialTransaction

BankEntries, BankEntryLines, CashEntries, CashEntryLines, TransactionLines, Transactions

Postfach

DefaultMailbox, MailMessagesReceived, MailMessagesReceivedByMailbox, MailMessagesSent, Mailboxes, PreferredMailbox

PurchaseOrder

GoodsReceiptLines, GoodsReceipts, PurchaseOrderLines, PurchaseOrderStockBatchNumbers, PurchaseOrderStockSerialNumbers, PurchaseOrders

Abonnement

SubscriptionLines, SubscriptionReasonCodes, SubscriptionRestrictionEmployees, SubscriptionRestrictionItems, SubscriptionTypes, Subscriptions

Dokumente

DocumentAttachmentFiles, DocumentAttachments, DocumentFolders, DocumentTypeFolders, Documents

Verkauf

SalesPriceListLinkedAccounts, SalesPriceListPeriods, SalesPriceListVolumeDiscounts, SalesPriceLists, ShippingMethods

Umsatzsteuer

TaxComponentRates, TaxScheduleComponents, TaxSchedules, VATCodes, VatPercentages

OpeningBalance

CurrentYearAfterEntry, CurrentYearProcessed, PreviousYearAfterEntry, PreviousYearProcessed

System

GetCurrentDivision, GetMostRecentlyUsedDivisions, Me, SystemDivisions

Aktivposten

AssetGroups, Assets, DepreciationMethods

Licence

MyBankAccounts, OAuthClients, PartnerKeys

SalesInvoice

Layouts, SalesInvoiceLines, SalesInvoices

Benutzer

UserRoles, UserRolesPerDivision, Users

Budget

BudgetScenarios, Budgets

GeneralJournalEntry

GeneralJournalEntries, GeneralJournalEntryLines

Kauf

PurchaseInvoiceLines, PurchaseInvoices

PurchaseEntry

PurchaseEntries, PurchaseEntryLines

SalesEntry

SalesEntries, SalesEntryLines

BankGateway

BankSubscriptions

Allgemein

Currencies

Webhooks

WebhookSubscriptions

Workflow

CustomerCooperations

Accountancy (ohne Beziehungen)

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

Aktivitäten (ohne Beziehungen)

InContextRequests, RequestAttachments

AppCenter (ohne Beziehungen)

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

Aktivposten (ohne Beziehungen)

CommercialBuildingValues

Bilanzen (ohne Beziehungen)

BalanceLineTotalsCostAnalysisAll, BalanceLineTotalsCostAnalysisAllProcessed, BalanceLinesCostAnalysisAll, BalanceLinesCostAnalysisAllProcessed, BalanceLinesPerPeriodAll, BalanceLinesPerPeriodCostAnalysisAll

CRM (ohne Beziehungen)

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

Cashflow (ohne Beziehungen)

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

CodeValues (ohne Beziehungen)

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

Dokumente (ohne Beziehungen)

DocumentCategories, DocumentTypeCategories, DocumentTypes, EolDmsDocuments

ExactOnlineREST Native (ohne Beziehungen)

NATIVEPLATFORMSCALARREQUESTS

Financial (ohne Beziehungen)

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

Allgemein (ohne Beziehungen)

Layouts

Global (ohne Beziehungen)

IBANFormats

HRM (ohne Beziehungen)

HrmDivisionClassifications, LeaveAbsenceHoursByDay, ScheduleEntries

Incremental (ohne Beziehungen)

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

Intern (ohne Beziehungen)

CompanyNames

Inventar (ohne Beziehungen)

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

Licence (ohne Beziehungen)

GetAllPartnerKeys, OAuthClientsWithSecrets, OAuthScopes, RevokedOAuthPermission

Logistics (ohne Beziehungen)

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

Postfach (ohne Beziehungen)

MailMessageAttachments, MailMessagesReceivedUnhandled, MailMessagesSentUnhandled

Herstellung (ohne Beziehungen)

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

OfficeApp (ohne Beziehungen)

MsTeamsMeetingReferences, MsTeamsReferences, ReportingUser

Lohn-und Gehaltsabrechnung (ohne Beziehungen)

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

Projekt (ohne Beziehungen)

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

PurchaseEntry (ohne Beziehungen)

Approval

PurchaseOrder (ohne Beziehungen)

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

RGS (ohne Beziehungen)

RGS10CodeRelations, RGS11CodeRelations, RGS20CodeRelations, RGS30CodeRelations

Verkauf (ohne Beziehungen)

OrderCharges, SalesChannels

SalesEntry (ohne Beziehungen)

CreditedSalesInvoices

SalesInvoice (ohne Beziehungen)

SalesInvoiceOrderChargeLines

SalesOrder (ohne Beziehungen)

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

Abonnement (ohne Beziehungen)

SubscriptionLineTypes

Sync (ohne Beziehungen)

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

System (ohne Beziehungen)

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

Views (ohne Beziehungen)

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

Workflow (ohne Beziehungen)

RequestAttachments

DataDictionary (ohne Beziehungen)

IncrementalEntityTypes, IncrementalLoadDataFiles, IncrementalLoadEventLogEntries, IncrementalLoadStatistics, IncrementalLoadStatuses, RowCounts

Unsupported (ohne Beziehungen)

Backups

ExactOnlineXML Native (ohne Beziehungen)

NATIVEPLATFORMSCALARREQUESTS

XML (ohne Beziehungen)

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

Beziehungen

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

Beispiel-Queries

--
-- 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

Attribute

The attributes of this platform are on the page Attributes.

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: