invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

Exact Online Data Model

The Exact Online driver offers over 1.000 tables grouped over a range of XML APIs, REST APIs and some special APIs.

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:

  • Flux d’autorisation par code OAuth

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

Configurez cette plateforme dans Invantive Cloud : https://cloud.invantive.com/exactonline

The data is partitioned per Administration (Division).

Les comparaisons de texte sur cette plateforme tiennent compte de la casse.

Plate-forme

  • Utilisable depuis : Invantive Cloud et les produits Invantive installés sur votre ordinateur ou votre serveur.
  • Type : une application accessible via son API.
  • Les données sont regroupées par catégorie, par exemple par entreprise ou par administration.
  • Une Query peut interroger plusieurs entreprises à la fois.
  • Les données peuvent être aussi bien écrites que lues.
  • 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.

Chiffres

Figure Count
Tables 1,239
Columns 1,553,883
Tableaux avec insert 699
Tables avec mise à jour 685
Tables avec la clause DELETE 312
Tableaux documentés 395

Affiche sur le modèle de données

PDF, 4 feuilles A0

Sur une table de l'affiche : Zoom avant et arrière, les touches fléchées permettent de se déplacer, la touche 0 permet de revenir à la taille normale.

Exact Online Modèle de données, Page 1 sur 4Exact Online Modèle de donnéesà utiliser avec Invantive UniversalSQLCommuniqué 27.1.3-BETA+6294 · 01-11-2026SalesOrder · Projet · Fabrication · SalesInvoice · FinancialTransaction · Logistics · Ventes · Documents · Accountancy · LicencePage 1 sur 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)DocumentsDocumentsExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.HRM.Costcenters: Cost CentresCostcentersHRMExactOnlineREST.Users.UsersUExactOnlineREST.HRM.Costunits: Cost UnitsCostunitsHRMExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.BatchNumbers: Batch NumbersBatchNumbersL'inventaireExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.SerialNumbers: Serial NumbersSerialNumbersL'inventaireExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.StockCountLines: Stock Count LinesStockCountLinesL'inventaireExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.StorageLocations: Storage LocationsStorageLocationsL'inventaireExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.Warehouses: Warehouses (ExactOnlineREST.SalesOrder.WarehousesBulk)WarehousesL'inventaireExactOnlineREST.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)ShopOrdersFabricationExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProjetExactOnlineREST.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 ListsSalesPriceListsVentesExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Sales.ShippingMethods: Shipping MethodsShippingMethodsVentesExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesVATExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUProjet×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)EmployeesPaieExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Payroll.Employments: Employments (ExactOnlineREST.Incremental.EmploymentsIncremental, ExactOnlineREST.Sync.SyncEmployments)EmploymentsPaieExactOnlineREST.Users.UsersUExactOnlineREST.Subscription.Subscriptions: Subscriptions (ExactOnlineREST.Incremental.SubscriptionsIncremental, ExactOnlineREST.Sync.SyncSubscriptions)SubscriptionsAbonnementExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesVATExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUFabrication×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 LocationsStorageLocationsL'inventaireExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.Warehouses: Warehouses (ExactOnlineREST.SalesOrder.WarehousesBulk)WarehousesL'inventaireExactOnlineREST.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)EmployeesPaieExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProjetExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesVATExactOnlineREST.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)DocumentsDocumentsExactOnlineREST.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)WarehousesL'inventaireExactOnlineREST.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)EmployeesPaieExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectWBS: Project WBS (ExactOnlineREST.Incremental.ProjectWBSIncremental, ExactOnlineREST.Project.ProjectWBSBulk, ExactOnlineREST.Sync.SyncProjectWBS)ProjectWBSProjetExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProjetExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Sales.SalesPriceLists: Sales Price ListsSalesPriceListsVentesExactOnlineREST.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 CodesVATCodesVATExactOnlineREST.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: AssetsAssetsActifsExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Documents.Documents: Documents (ExactOnlineREST.Documents.DocumentsBulk, ExactOnlineREST.Incremental.DocumentsIncremental, ExactOnlineREST.Sync.SyncDocuments)DocumentsDocumentsExactOnlineREST.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)ShopOrdersFabricationExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectWBS: Project WBS (ExactOnlineREST.Incremental.ProjectWBSIncremental, ExactOnlineREST.Project.ProjectWBSBulk, ExactOnlineREST.Sync.SyncProjectWBS)ProjectWBSProjetExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProjetExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Subscription.Subscriptions: Subscriptions (ExactOnlineREST.Incremental.SubscriptionsIncremental, ExactOnlineREST.Sync.SyncSubscriptions)SubscriptionsAbonnementExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesVATExactOnlineREST.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.UsersUVentesExactOnlineREST.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: UnitsUnitsLogisticsDocuments×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)EmploymentContractsPaieExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProjetExactOnlineREST.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 RolesUserRolesUtilisateursLicenceExactOnlineREST.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.SujetsAbonnement2Accountancy1Achat2Actifs2Activités2BankGateway3Boites aux lettres2Budget2Cashflow2ContinuousMonitoring3CRM2Documents1Fabrication1Financial2FinancialTransaction1Général3GeneralJournalEntry3HRM2L'inventaire2Licence1Logistics1OpeningBalance2Paie2Projet1PurchaseEntry3PurchaseOrder2SalesEntry2SalesInvoice1SalesOrder1Système3Utilisateurs2VAT3Ventes1Webhooks3Workflow3Tables sans relations3, 4LégendeTransactionnelSetupTechniqueValeurs codées en durDéfini dans une autre rubriqueClé déclaréeRelation décrite avec des motsCandidat dérivé des noms de colonnesEn gras : une table très appréciée+Bulk, +Read : la Table existe également sous ces variantes: n clés entre les mêmes tablesLettres : désigne une table utilisée dans la plupart des rubriques: U = Users, A = Accounts, C = CurrenciesGénéré à partir des métadonnées d'Invantive UniversalSQL 27.1.3-BETA+6294 le 01-11-2026. Chaque tablerenvoie vers sa page présentant les colonnes, les clés et des exemples de requêtes.documentation.invantive.eu/fr/datamodels/exactonline
L'affiche sous forme de texte : tableaux par thème et leurs relations

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

Fabrication

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

Projet

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

L'inventaire

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

Paie

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

Cashflow

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

Activités

CommunicationNotes, Complaints, Events, Messages, ServiceRequests, Tasks

FinancialTransaction

BankEntries, BankEntryLines, CashEntries, CashEntryLines, TransactionLines, Transactions

Boites aux lettres

DefaultMailbox, MailMessagesReceived, MailMessagesReceivedByMailbox, MailMessagesSent, Mailboxes, PreferredMailbox

PurchaseOrder

GoodsReceiptLines, GoodsReceipts, PurchaseOrderLines, PurchaseOrderStockBatchNumbers, PurchaseOrderStockSerialNumbers, PurchaseOrders

Abonnement

SubscriptionLines, SubscriptionReasonCodes, SubscriptionRestrictionEmployees, SubscriptionRestrictionItems, SubscriptionTypes, Subscriptions

Documents

DocumentAttachmentFiles, DocumentAttachments, DocumentFolders, DocumentTypeFolders, Documents

Ventes

SalesPriceListLinkedAccounts, SalesPriceListPeriods, SalesPriceListVolumeDiscounts, SalesPriceLists, ShippingMethods

VAT

TaxComponentRates, TaxScheduleComponents, TaxSchedules, VATCodes, VatPercentages

OpeningBalance

CurrentYearAfterEntry, CurrentYearProcessed, PreviousYearAfterEntry, PreviousYearProcessed

Système

GetCurrentDivision, GetMostRecentlyUsedDivisions, Me, SystemDivisions

Actifs

AssetGroups, Assets, DepreciationMethods

Licence

MyBankAccounts, OAuthClients, PartnerKeys

SalesInvoice

Layouts, SalesInvoiceLines, SalesInvoices

Utilisateurs

UserRoles, UserRolesPerDivision, Users

Budget

BudgetScenarios, Budgets

GeneralJournalEntry

GeneralJournalEntries, GeneralJournalEntryLines

Achat

PurchaseInvoiceLines, PurchaseInvoices

PurchaseEntry

PurchaseEntries, PurchaseEntryLines

SalesEntry

SalesEntries, SalesEntryLines

BankGateway

BankSubscriptions

Général

Currencies

Webhooks

WebhookSubscriptions

Workflow

CustomerCooperations

Accountancy (sans relations)

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

Activités (sans relations)

InContextRequests, RequestAttachments

AppCenter (sans relations)

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

Actifs (sans relations)

CommercialBuildingValues

Soldes (sans relations)

BalanceLineTotalsCostAnalysisAll, BalanceLineTotalsCostAnalysisAllProcessed, BalanceLinesCostAnalysisAll, BalanceLinesCostAnalysisAllProcessed, BalanceLinesPerPeriodAll, BalanceLinesPerPeriodCostAnalysisAll

CRM (sans relations)

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

Cashflow (sans relations)

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

CodeValues (sans relations)

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

Documents (sans relations)

DocumentCategories, DocumentTypeCategories, DocumentTypes, EolDmsDocuments

ExactOnlineREST Native (sans relations)

NATIVEPLATFORMSCALARREQUESTS

Financial (sans relations)

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

Général (sans relations)

Layouts

Global (sans relations)

IBANFormats

HRM (sans relations)

HrmDivisionClassifications, LeaveAbsenceHoursByDay, ScheduleEntries

Incremental (sans relations)

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

Interne (sans relations)

CompanyNames

L'inventaire (sans relations)

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

Licence (sans relations)

GetAllPartnerKeys, OAuthClientsWithSecrets, OAuthScopes, RevokedOAuthPermission

Logistics (sans relations)

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

Boites aux lettres (sans relations)

MailMessageAttachments, MailMessagesReceivedUnhandled, MailMessagesSentUnhandled

Fabrication (sans relations)

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

OfficeApp (sans relations)

MsTeamsMeetingReferences, MsTeamsReferences, ReportingUser

Paie (sans relations)

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

Projet (sans relations)

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

PurchaseEntry (sans relations)

Approval

PurchaseOrder (sans relations)

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

RGS (sans relations)

RGS10CodeRelations, RGS11CodeRelations, RGS20CodeRelations, RGS30CodeRelations

Ventes (sans relations)

OrderCharges, SalesChannels

SalesEntry (sans relations)

CreditedSalesInvoices

SalesInvoice (sans relations)

SalesInvoiceOrderChargeLines

SalesOrder (sans relations)

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

Abonnement (sans relations)

SubscriptionLineTypes

Synchroniser (sans relations)

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

Système (sans relations)

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

Vues (sans relations)

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

Workflow (sans relations)

RequestAttachments

DataDictionary (sans relations)

IncrementalEntityTypes, IncrementalLoadDataFiles, IncrementalLoadEventLogEntries, IncrementalLoadStatistics, IncrementalLoadStatuses, RowCounts

Unsupported (sans relations)

Backups

ExactOnlineXML Native (sans relations)

NATIVEPLATFORMSCALARREQUESTS

XML (sans relations)

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

Relations

Tableaux

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

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

Attributs

The attributes of this platform are on the page Attributes.

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :