invantive documentation
Forum di supporto InvantiveAccedi / Registrati

Exact Online Data Model

Il driver Exact Online offre oltre 1.000 tabelle raggruppate su una gamma di API XML, API REST e alcune API speciali.

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.

Configura questa piattaforma su Invantive Cloud: https://cloud.invantive.com/exactonline

The data is partitioned per Administration (Division).

I confronti tra testi su questa piattaforma tengono conto delle maiuscole e delle minuscole.

Piattaforma

  • Utilizzabile da: Invantive Cloud e dai prodotti Invantive installati sul proprio computer o server.
  • Tipo: un'applicazione accessibile tramite la propria API.
  • I dati sono suddivisi, ad esempio per azienda o per amministrazione.
  • Una query può leggere i dati di più aziende contemporaneamente.
  • I dati possono essere sia letti che scritti.
  • 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.

Figure

Figure Count
Tables 1,239
Columns 1,553,883
Tabella con inserti 699
Tabella con aggiornamento 685
Tabella con la clausola DELETE 312
Tabella documentata 395

Poster sul modello di dati

PDF, 4 fogli in formato A0

Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.

Exact Online Modello di dati, Foglio 1 di 4Exact Online Modello di datida utilizzare con Invantive UniversalSQLComunicato 27.1.3-BETA+6294 · 01-11-2026SalesOrder · Progetto · Produzione · SalesInvoice · FinancialTransaction · Logistics · Vendite · Documenti · Accountancy · LicenceFoglio 1 di 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)DocumentsDocumentiExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.HRM.Costcenters: Cost CentresCostcentersHRMExactOnlineREST.Users.UsersUExactOnlineREST.HRM.Costunits: Cost UnitsCostunitsHRMExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.BatchNumbers: Batch NumbersBatchNumbersInventarioExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.SerialNumbers: Serial NumbersSerialNumbersInventarioExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.StockCountLines: Stock Count LinesStockCountLinesInventarioExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.StorageLocations: Storage LocationsStorageLocationsInventarioExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.Warehouses: Warehouses (ExactOnlineREST.SalesOrder.WarehousesBulk)WarehousesInventarioExactOnlineREST.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)ShopOrdersProduzioneExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProgettoExactOnlineREST.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 ListsSalesPriceListsVenditeExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.Sales.ShippingMethods: Shipping MethodsShippingMethodsVenditeExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesIVAExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUProgetto×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)EmployeesLibro pagaExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Payroll.Employments: Employments (ExactOnlineREST.Incremental.EmploymentsIncremental, ExactOnlineREST.Sync.SyncEmployments)EmploymentsLibro pagaExactOnlineREST.Users.UsersUExactOnlineREST.Subscription.Subscriptions: Subscriptions (ExactOnlineREST.Incremental.SubscriptionsIncremental, ExactOnlineREST.Sync.SyncSubscriptions)SubscriptionsAbbonamentoExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesIVAExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUProduzione×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 LocationsStorageLocationsInventarioExactOnlineREST.Users.UsersUExactOnlineREST.Inventory.Warehouses: Warehouses (ExactOnlineREST.SalesOrder.WarehousesBulk)WarehousesInventarioExactOnlineREST.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)EmployeesLibro pagaExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProgettoExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesIVAExactOnlineREST.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)DocumentsDocumentiExactOnlineREST.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)WarehousesInventarioExactOnlineREST.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)EmployeesLibro pagaExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectWBS: Project WBS (ExactOnlineREST.Incremental.ProjectWBSIncremental, ExactOnlineREST.Project.ProjectWBSBulk, ExactOnlineREST.Sync.SyncProjectWBS)ProjectWBSProgettoExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProgettoExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Sales.SalesPriceLists: Sales Price ListsSalesPriceListsVenditeExactOnlineREST.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)SubscriptionsAbbonamentoExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesIVAExactOnlineREST.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: AssetsAssetsAttiviExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Documents.Documents: Documents (ExactOnlineREST.Documents.DocumentsBulk, ExactOnlineREST.Incremental.DocumentsIncremental, ExactOnlineREST.Sync.SyncDocuments)DocumentsDocumentiExactOnlineREST.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)ShopOrdersProduzioneExactOnlineREST.Users.UsersUExactOnlineREST.Project.ProjectWBS: Project WBS (ExactOnlineREST.Incremental.ProjectWBSIncremental, ExactOnlineREST.Project.ProjectWBSBulk, ExactOnlineREST.Sync.SyncProjectWBS)ProjectWBSProgettoExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProgettoExactOnlineREST.CRM.AccountsAExactOnlineREST.Users.UsersUExactOnlineREST.Subscription.Subscriptions: Subscriptions (ExactOnlineREST.Incremental.SubscriptionsIncremental, ExactOnlineREST.Sync.SyncSubscriptions)SubscriptionsAbbonamentoExactOnlineREST.CRM.AccountsAExactOnlineREST.General.CurrenciesCExactOnlineREST.Users.UsersUExactOnlineREST.VAT.VATCodes: VAT CodesVATCodesIVAExactOnlineREST.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.UsersUVenditeExactOnlineREST.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: UnitsUnitsLogisticsDocumenti×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)EmploymentContractsLibro pagaExactOnlineREST.Users.UsersUExactOnlineREST.Project.Projects: Projects (ExactOnlineREST.Incremental.ProjectsIncremental, ExactOnlineREST.Sync.SyncProjects)ProjectsProgettoExactOnlineREST.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 RolesUserRolesUtentiLicenceExactOnlineREST.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.ArgomentiAbbonamento2Accountancy1Acquisto2Attivi2Attività2BankGateway3Bilancio2Cashflow2Cassetta postale2ContinuousMonitoring3CRM2Documenti1Financial2FinancialTransaction1Generale3GeneralJournalEntry3HRM2Inventario2IVA3Libro paga2Licence1Logistics1OpeningBalance2Produzione1Progetto1PurchaseEntry3PurchaseOrder2SalesEntry2SalesInvoice1SalesOrder1Sistema3Utenti2Vendite1Webhooks3Workflow3Tabella senza relazioni3, 4LeggendaTransazionaleInstallazioneAspetti tecniciValori hardcodedDescritto in un altro argomentoChiave dichiarataRelazione descritta a paroleCandidato derivato dai nomi delle colonneIn grassetto: una tabella molto diffusa+Bulk, +Read: la tabella è disponibile anche in queste varianti\u00D7n: n chiavi tra le stesse tabelleLettere: si riferisce a una tabella utilizzata nella maggior parte degli argomenti: U = Users, A = Accounts,C = CurrenciesGenerato dai metadati di Invantive UniversalSQL 27.1.3-BETA+6294 il 01-11-2026. Ogni tabella rimanda allarelativa pagina con le colonne, le chiavi e le Query di esempio.documentation.invantive.eu/it/datamodels/exactonline
Il poster come testo: tabelle per argomento e le loro relazioni

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

Produzione

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

Progetto

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

Inventario

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

Libro paga

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

Cashflow

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

Attività

CommunicationNotes, Complaints, Events, Messages, ServiceRequests, Tasks

FinancialTransaction

BankEntries, BankEntryLines, CashEntries, CashEntryLines, TransactionLines, Transactions

Cassetta postale

DefaultMailbox, MailMessagesReceived, MailMessagesReceivedByMailbox, MailMessagesSent, Mailboxes, PreferredMailbox

PurchaseOrder

GoodsReceiptLines, GoodsReceipts, PurchaseOrderLines, PurchaseOrderStockBatchNumbers, PurchaseOrderStockSerialNumbers, PurchaseOrders

Abbonamento

SubscriptionLines, SubscriptionReasonCodes, SubscriptionRestrictionEmployees, SubscriptionRestrictionItems, SubscriptionTypes, Subscriptions

Documenti

DocumentAttachmentFiles, DocumentAttachments, DocumentFolders, DocumentTypeFolders, Documents

Vendite

SalesPriceListLinkedAccounts, SalesPriceListPeriods, SalesPriceListVolumeDiscounts, SalesPriceLists, ShippingMethods

IVA

TaxComponentRates, TaxScheduleComponents, TaxSchedules, VATCodes, VatPercentages

OpeningBalance

CurrentYearAfterEntry, CurrentYearProcessed, PreviousYearAfterEntry, PreviousYearProcessed

Sistema

GetCurrentDivision, GetMostRecentlyUsedDivisions, Me, SystemDivisions

Attivi

AssetGroups, Assets, DepreciationMethods

Licence

MyBankAccounts, OAuthClients, PartnerKeys

SalesInvoice

Layouts, SalesInvoiceLines, SalesInvoices

Utenti

UserRoles, UserRolesPerDivision, Users

Bilancio

BudgetScenarios, Budgets

GeneralJournalEntry

GeneralJournalEntries, GeneralJournalEntryLines

Acquisto

PurchaseInvoiceLines, PurchaseInvoices

PurchaseEntry

PurchaseEntries, PurchaseEntryLines

SalesEntry

SalesEntries, SalesEntryLines

BankGateway

BankSubscriptions

Generale

Currencies

Webhooks

WebhookSubscriptions

Workflow

CustomerCooperations

Accountancy (senza relazioni)

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

Attività (senza relazioni)

InContextRequests, RequestAttachments

AppCenter (senza relazioni)

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

Attivi (senza relazioni)

CommercialBuildingValues

Saldi (senza relazioni)

BalanceLineTotalsCostAnalysisAll, BalanceLineTotalsCostAnalysisAllProcessed, BalanceLinesCostAnalysisAll, BalanceLinesCostAnalysisAllProcessed, BalanceLinesPerPeriodAll, BalanceLinesPerPeriodCostAnalysisAll

CRM (senza relazioni)

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

Cashflow (senza relazioni)

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

CodeValues (senza relazioni)

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

Documenti (senza relazioni)

DocumentCategories, DocumentTypeCategories, DocumentTypes, EolDmsDocuments

ExactOnlineREST Native (senza relazioni)

NATIVEPLATFORMSCALARREQUESTS

Financial (senza relazioni)

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

Generale (senza relazioni)

Layouts

Global (senza relazioni)

IBANFormats

HRM (senza relazioni)

HrmDivisionClassifications, LeaveAbsenceHoursByDay, ScheduleEntries

Incremental (senza relazioni)

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

Interno (senza relazioni)

CompanyNames

Inventario (senza relazioni)

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

Licence (senza relazioni)

GetAllPartnerKeys, OAuthClientsWithSecrets, OAuthScopes, RevokedOAuthPermission

Logistics (senza relazioni)

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

Cassetta postale (senza relazioni)

MailMessageAttachments, MailMessagesReceivedUnhandled, MailMessagesSentUnhandled

Produzione (senza relazioni)

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

OfficeApp (senza relazioni)

MsTeamsMeetingReferences, MsTeamsReferences, ReportingUser

Libro paga (senza relazioni)

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

Progetto (senza relazioni)

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

PurchaseEntry (senza relazioni)

Approval

PurchaseOrder (senza relazioni)

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

RGS (senza relazioni)

RGS10CodeRelations, RGS11CodeRelations, RGS20CodeRelations, RGS30CodeRelations

Vendite (senza relazioni)

OrderCharges, SalesChannels

SalesEntry (senza relazioni)

CreditedSalesInvoices

SalesInvoice (senza relazioni)

SalesInvoiceOrderChargeLines

SalesOrder (senza relazioni)

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

Abbonamento (senza relazioni)

SubscriptionLineTypes

Sincronizza (senza relazioni)

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

Sistema (senza relazioni)

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

Visualizzazioni (senza relazioni)

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

Workflow (senza relazioni)

RequestAttachments

DataDictionary (senza relazioni)

IncrementalEntityTypes, IncrementalLoadDataFiles, IncrementalLoadEventLogEntries, IncrementalLoadStatistics, IncrementalLoadStatuses, RowCounts

Unsupported (senza relazioni)

Backups

ExactOnlineXML Native (senza relazioni)

NATIVEPLATFORMSCALARREQUESTS

XML (senza relazioni)

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

Relazioni

Tabelle

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

Esempi di Query

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

Attributi

The attributes of this platform are on the page Attributes.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: