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
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.
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
GeneralJournalEntry
GeneralJournalEntries, GeneralJournalEntryLines
Achat
PurchaseInvoiceLines, PurchaseInvoices
PurchaseEntry
PurchaseEntries, PurchaseEntryLines
SalesEntry
BankGateway
Général
Webhooks
Workflow
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)
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)
Financial (sans relations)
FinancialYears, FinancialYears2, FiscalVatEntities, GLTransactionSources, GLTransactionTypes, JournalStatusList, Notes, OutstandingInvoicesOverview, ProcessReturn, RevenueList, RgsAccountSchemes, RgsBrugstaatDetailData
Général (sans relations)
Global (sans relations)
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)
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)
PurchaseOrder (sans relations)
GoodsReceiptLineBatchNumbers, GoodsReceiptLineSerialNumbers, PurchaseOrderBatchQuantitiesPerLocations, PurchaseOrderBatchQuantitiesPerWarehouses, PurchasePlanningShopOrderMaterialPlans, PurchasePlanningShopOrderRoutingStepPlans, PurchaseReturnLineBatchNumbers, PurchaseReturnLineSerialNumbers, PurchaseReturnLines, PurchaseReturns
RGS (sans relations)
RGS10CodeRelations, RGS11CodeRelations, RGS20CodeRelations, RGS30CodeRelations
Ventes (sans relations)
SalesEntry (sans relations)
SalesInvoice (sans relations)
SalesOrder (sans relations)
CompleteSalesOrder, CompleteSalesOrderLine, DigitalOrderPickingLocations, DropShipmentLines, DropShipments, GoodsDeliveryLineBatchNumbers, GoodsDeliveryLineSerialNumbers, SalesOrderBatchQuantitiesPerLocations, SalesOrderBatchQuantitiesPerWarehouses, SalesOrderOrderChargeLines
Abonnement (sans relations)
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)
DataDictionary (sans relations)
IncrementalEntityTypes, IncrementalLoadDataFiles, IncrementalLoadEventLogEntries, IncrementalLoadStatistics, IncrementalLoadStatuses, RowCounts
Unsupported (sans relations)
ExactOnlineXML Native (sans relations)
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
- AccountInvolvedAccounts → Accounts (clé, 2 keys)
- AccountInvolvedAccounts → Users (clé, 2 keys)
- AccountOwners → Accounts (clé, 2 keys)
- AccountOwners → Users (clé, 2 keys)
- CenterProfileDetails → Accounts (clé)
- CenterProfiles → Accounts (clé)
- ExcludedDivisions → Accounts (clé)
- InvolvedUserRoles → Users (clé, 2 keys)
- InvolvedUsers → Accounts (clé)
- InvolvedUsers → UserRoles (clé)
- InvolvedUsers → Users (clé, 2 keys)
- SolutionLinks → Accounts (clé)
- SolutionLinks → Users (clé, 2 keys)
- TaskTypes → Users (clé, 2 keys)
- CommunicationNotes → Accounts (clé)
- CommunicationNotes → Contacts (clé)
- CommunicationNotes → Opportunities (clé)
- CommunicationNotes → Documents (clé)
- CommunicationNotes → Users (clé, 2 keys)
- Complaints → Accounts (clé)
- Complaints → Contacts (clé)
- Complaints → Documents (clé)
- Complaints → Users (clé, 3 keys)
- Events → Accounts (clé)
- Events → Contacts (clé)
- Events → Opportunities (clé)
- Events → Documents (clé)
- Events → Projects (clé)
- Events → Users (clé, 2 keys)
- Messages → Accounts (clé)
- ServiceRequests → Accounts (clé)
- ServiceRequests → Contacts (clé)
- ServiceRequests → Documents (clé)
- ServiceRequests → Users (clé, 3 keys)
- Tasks → Accounts (clé)
- Tasks → Contacts (clé)
- Tasks → Opportunities (clé)
- Tasks → Documents (clé)
- Tasks → Projects (clé)
- Tasks → Users (clé, 2 keys)
- AssetGroups → DepreciationMethods (clé)
- AssetGroups → GLAccounts (clé, 4 keys)
- AssetGroups → Users (clé, 2 keys)
- Assets → AssetGroups (clé)
- Assets → Assets (clé, 2 keys)
- Assets → DepreciationMethods (clé)
- Assets → Accounts (clé)
- Assets → Costcenters (clé)
- Assets → Costunits (clé)
- Assets → Users (clé, 2 keys)
- DepreciationMethods → Users (clé, 2 keys)
- BankSubscriptions → Banks (clé)
- BudgetScenarios → Users (clé, 2 keys)
- Budgets → BudgetScenarios (clé)
- Budgets → GLAccounts (clé)
- Budgets → Costcenters (clé)
- Budgets → Costunits (clé)
- Budgets → Items (clé)
- Budgets → Users (clé, 2 keys)
- AccountClasses → Users (clé, 2 keys)
- AccountClassificationNames → Users (clé, 4 keys)
- AccountClassifications → AccountClassificationNames (clé, 2 keys)
- AccountClassifications → Users (clé, 4 keys)
- Accounts → Accounts (clé, 4 keys)
- Accounts → BusinessTypes (clé, 2 keys)
- Accounts → Contacts (clé, 2 keys)
- Accounts → LeadPurposes (clé, 2 keys)
- Accounts → LeadSources (clé, 2 keys)
- Accounts → GLAccounts (clé, 8 keys)
- Accounts → SalesPriceLists (clé, 2 keys)
- Accounts → ShippingMethods (clé, 2 keys)
- Accounts → Users (clé, 4 keys)
- Addresses → Accounts (clé, 3 keys)
- Addresses → Contacts (clé, 3 keys)
- Addresses → Warehouses (clé, 3 keys)
- Addresses → Users (clé, 6 keys)
- BankAccounts → Accounts (clé, 3 keys)
- BankAccounts → Users (clé, 6 keys)
- Contacts → Accounts (clé, 3 keys)
- Contacts → Contacts (clé)
- Contacts → LeadPurposes (clé, 3 keys)
- Contacts → LeadSources (clé, 3 keys)
- Contacts → Documents (clé, 3 keys)
- Contacts → Users (clé, 9 keys)
- CrmDocuments → Accounts (clé)
- CrmDocuments → Contacts (clé)
- CrmDocuments → Opportunities (clé)
- CrmDocuments → DocumentFolders (clé)
- CrmDocuments → Users (clé, 2 keys)
- HostingOpportunities → Accounts (clé, 6 keys)
- HostingOpportunities → LeadSources (clé, 2 keys)
- HostingOpportunities → OpportunityStages (clé, 2 keys)
- HostingOpportunities → ReasonCodes (clé, 2 keys)
- HostingOpportunities → SalesTypes (clé, 2 keys)
- HostingOpportunities → Currencies (clé, 2 keys)
- HostingOpportunities → Projects (clé, 2 keys)
- HostingOpportunities → Users (clé, 6 keys)
- Opportunities → Accounts (clé, 6 keys)
- Opportunities → LeadSources (clé, 2 keys)
- Opportunities → OpportunityStages (clé, 2 keys)
- Opportunities → ReasonCodes (clé, 2 keys)
- Opportunities → SalesTypes (clé, 2 keys)
- Opportunities → Currencies (clé, 2 keys)
- Opportunities → Projects (clé, 2 keys)
- Opportunities → Users (clé, 6 keys)
- OpportunityContactsRead → Accounts (clé)
- OpportunityContactsRead → Contacts (clé, 2 keys)
- OpportunityContactsRead → LeadPurposes (clé)
- OpportunityContactsRead → LeadSources (clé)
- OpportunityContactsRead → Opportunities (clé)
- OpportunityContactsRead → Documents (clé)
- OpportunityContactsRead → Users (clé, 3 keys)
- OpportunityStages → Users (clé, 2 keys)
- QuotationLines → Quotations (clé, 2 keys)
- QuotationLines → Items (clé, 2 keys)
- QuotationLines → VATCodes (clé, 2 keys)
- Quotations → Accounts (clé, 6 keys)
- Quotations → Addresses (clé, 2 keys)
- Quotations → Contacts (clé, 6 keys)
- Quotations → Opportunities (clé, 2 keys)
- Quotations → Documents (clé, 2 keys)
- Quotations → Currencies (clé, 2 keys)
- Quotations → SelectionCodes (clé, 2 keys)
- Quotations → Projects (clé, 2 keys)
- Quotations → Users (clé, 6 keys)
- ReasonCodes → Users (clé, 2 keys)
- AllocationRule → Accounts (clé)
- AllocationRule → GLAccounts (clé)
- AllocationRule → Costcenters (clé)
- AllocationRule → Costunits (clé)
- AllocationRule → Users (clé, 2 keys)
- AllocationRule → VATCodes (clé)
- BankLinks → Accounts (clé)
- BankLinks → Currencies (clé)
- DirectDebitMandates → Accounts (clé)
- DirectDebitMandates → BankAccounts (clé)
- DirectDebitMandates → Users (clé, 2 keys)
- ImportNotifications → BankAccounts (clé)
- ImportNotifications → Documents (clé)
- ImportNotifications → Users (clé)
- PaymentConditions → Users (clé, 2 keys)
- Payments → Accounts (clé, 2 keys)
- Payments → BankAccounts (clé, 4 keys)
- Payments → Contacts (clé, 2 keys)
- Payments → Documents (clé, 2 keys)
- Payments → GLAccounts (clé, 2 keys)
- Payments → Journals (clé, 2 keys)
- Payments → Currencies (clé, 2 keys)
- Payments → Users (clé, 6 keys)
- Receivables → Accounts (clé, 2 keys)
- Receivables → BankAccounts (clé, 4 keys)
- Receivables → Contacts (clé, 2 keys)
- Receivables → DirectDebitMandates (clé, 2 keys)
- Receivables → Documents (clé, 2 keys)
- Receivables → GLAccounts (clé, 2 keys)
- Receivables → Journals (clé, 2 keys)
- Receivables → Currencies (clé, 2 keys)
- Receivables → Users (clé, 6 keys)
- IndicatorBalances → Users (clé, 2 keys)
- IndicatorDeviatingAmountEntereds → Users (clé, 2 keys)
- IndicatorDifferenceByPeriods → BudgetScenarios (clé)
- IndicatorDifferenceByPeriods → Users (clé, 2 keys)
- IndicatorDifferentVatCodes → Users (clé, 2 keys)
- IndicatorGLAccounts → GLAccounts (clé)
- IndicatorLiquidities → Users (clé, 2 keys)
- IndicatorSignals → GLAccounts (clé)
- IndicatorSignals → Users (clé, 3 keys)
- IndicatorStates → Users (clé, 2 keys)
- IndicatorUsageOfJournals → Users (clé, 2 keys)
- DocumentAttachmentFiles → Documents (clé)
- DocumentAttachments → Documents (clé)
- DocumentFolders → Users (clé, 2 keys)
- DocumentTypeFolders → DocumentFolders (clé)
- DocumentTypeFolders → Users (clé, 2 keys)
- Documents → Accounts (clé, 2 keys)
- Documents → Contacts (clé, 2 keys)
- Documents → Opportunities (clé, 2 keys)
- Documents → DocumentFolders (clé, 2 keys)
- Documents → Currencies (clé, 2 keys)
- Documents → EmploymentContracts (clé, 2 keys)
- Documents → Projects (clé, 2 keys)
- Documents → Users (clé, 4 keys)
- AgingOverview → Currencies (clé)
- AgingOverviewOverdue → Currencies (clé)
- AgingPayablesList → Currencies (clé)
- AgingPayablesListOverdue → Currencies (clé)
- AgingReceivablesList → Currencies (clé)
- AgingReceivablesListOverdue → Currencies (clé)
- CashflowBalance → Journals (clé)
- CashflowBalance → Currencies (clé)
- DeductibilityPercentages → GLAccounts (clé)
- DeductibilityPercentages → Users (clé, 2 keys)
- ExchangeRates → Users (clé, 2 keys)
- FinancialPeriods → Users (clé, 2 keys)
- GLAccountClassificationMappings → GLAccounts (clé)
- GLAccountClassificationMappings → GLSchemes (clé)
- GLAccounts → GLAccounts (clé, 4 keys)
- GLAccounts → Costcenters (clé, 2 keys)
- GLAccounts → Costunits (clé, 2 keys)
- GLAccounts → Users (clé, 4 keys)
- GLAccounts → VATCodes (clé, 2 keys)
- GLClassifications → Users (clé, 4 keys)
- GLSchemes → Users (clé, 2 keys)
- Journals → BankAccounts (clé)
- Journals → GLAccounts (clé, 2 keys)
- Journals → Currencies (clé)
- Journals → Users (clé, 2 keys)
- OfficialReturns → Users (clé, 2 keys)
- PayablesList → Accounts (clé)
- PayablesList → Journals (clé)
- PayablesList → Currencies (clé)
- PayablesListOverdue → Journals (clé)
- PayablesListOverdue → Currencies (clé)
- ProfitLossOverview → Currencies (clé)
- ProfitLossPeriodCompareList → Currencies (clé)
- ReceivablesList → Accounts (clé)
- ReceivablesList → Journals (clé)
- ReceivablesList → Currencies (clé)
- ReceivablesListOverdue → Journals (clé)
- ReceivablesListOverdue → Currencies (clé)
- ReportingBalance → GLAccounts (clé)
- Returns → Currencies (clé)
- RevenueByDebtorList → Currencies (clé)
- BankEntries → Documents (clé)
- BankEntries → Journals (clé)
- BankEntries → Currencies (clé)
- BankEntryLines → Assets (clé)
- BankEntryLines → Accounts (clé)
- BankEntryLines → Documents (clé)
- BankEntryLines → GLAccounts (clé)
- BankEntryLines → Costcenters (clé)
- BankEntryLines → Costunits (clé)
- BankEntryLines → ProjectWBS (clé)
- BankEntryLines → Projects (clé)
- BankEntryLines → Users (clé, 2 keys)
- BankEntryLines → VATCodes (clé)
- CashEntries → Journals (clé)
- CashEntries → Currencies (clé)
- CashEntryLines → Assets (clé)
- CashEntryLines → Accounts (clé)
- CashEntryLines → Documents (clé)
- CashEntryLines → GLAccounts (clé)
- CashEntryLines → CashEntries (clé)
- CashEntryLines → Costcenters (clé)
- CashEntryLines → Costunits (clé)
- CashEntryLines → ProjectWBS (clé)
- CashEntryLines → Projects (clé)
- CashEntryLines → Users (clé, 2 keys)
- CashEntryLines → VATCodes (clé)
- TransactionLines → Assets (clé, 2 keys)
- TransactionLines → Accounts (clé, 2 keys)
- TransactionLines → Documents (clé, 2 keys)
- TransactionLines → GLAccounts (clé, 2 keys)
- TransactionLines → Journals (clé, 2 keys)
- TransactionLines → Currencies (clé, 2 keys)
- TransactionLines → Costcenters (clé, 2 keys)
- TransactionLines → Costunits (clé, 2 keys)
- TransactionLines → Items (clé, 2 keys)
- TransactionLines → ShopOrders (clé, 2 keys)
- TransactionLines → ProjectWBS (clé, 2 keys)
- TransactionLines → Projects (clé, 2 keys)
- TransactionLines → Subscriptions (clé, 2 keys)
- TransactionLines → Users (clé, 4 keys)
- TransactionLines → VATCodes (clé, 2 keys)
- Transactions → Documents (clé)
- Transactions → Journals (clé)
- GeneralJournalEntries → Journals (clé)
- GeneralJournalEntries → Currencies (clé)
- GeneralJournalEntryLines → Assets (clé)
- GeneralJournalEntryLines → Accounts (clé)
- GeneralJournalEntryLines → Documents (clé)
- GeneralJournalEntryLines → GLAccounts (clé)
- GeneralJournalEntryLines → Costcenters (clé)
- GeneralJournalEntryLines → Costunits (clé)
- GeneralJournalEntryLines → ProjectWBS (clé)
- GeneralJournalEntryLines → Projects (clé)
- GeneralJournalEntryLines → Users (clé, 2 keys)
- GeneralJournalEntryLines → VATCodes (clé)
- AbsenceRegistrationTransactions → AbsenceRegistrations (clé)
- AbsenceRegistrationTransactions → Users (clé, 2 keys)
- AbsenceRegistrations → Employees (clé)
- AbsenceRegistrations → Users (clé, 2 keys)
- CompanyCars → Assets (clé)
- CompanyCars → Users (clé, 2 keys)
- Costcenters → Users (clé, 2 keys)
- Costunits → Users (clé, 2 keys)
- Departments → Costcenters (clé)
- Departments → Users (clé, 2 keys)
- DivisionClassNames → Users (clé, 2 keys)
- DivisionClassValues → Accounts (clé)
- DivisionClassValues → Users (clé, 2 keys)
- DivisionClasses → DivisionClassNames (clé)
- DivisionClasses → Users (clé, 2 keys)
- EmploymentCompanyCars → CompanyCars (clé)
- EmploymentCompanyCars → Employees (clé)
- EmploymentCompanyCars → Employments (clé)
- EmploymentCompanyCars → Users (clé, 2 keys)
- HrmDivisions → Accounts (clé)
- HrmDivisions → Currencies (clé)
- HrmDivisions → Users (clé, 2 keys)
- JobGroups → Users (clé, 2 keys)
- JobTitles → JobGroups (clé)
- JobTitles → Users (clé, 2 keys)
- LeaveBuildUpRegistrations → Employees (clé)
- LeaveBuildUpRegistrations → Users (clé, 2 keys)
- LeaveRegistrations → Employees (clé)
- LeaveRegistrations → Users (clé, 2 keys)
- Schedules → Employments (clé)
- Schedules → Users (clé, 2 keys)
- AssemblyOrders → StorageLocations (clé)
- AssemblyOrders → Warehouses (clé)
- AssemblyOrders → Items (clé)
- BatchNumbers → Items (clé)
- BatchNumbers → Users (clé, 2 keys)
- ItemWarehousePlanningDetails → Warehouses (clé)
- ItemWarehousePlanningDetails → Items (clé)
- ItemWarehouseStorageLocations → StorageLocations (clé)
- ItemWarehouseStorageLocations → Warehouses (clé)
- ItemWarehouseStorageLocations → Items (clé)
- ItemWarehouseStorageLocations → Units (clé)
- ItemWarehouses → StorageLocations (clé)
- ItemWarehouses → Warehouses (clé)
- ItemWarehouses → Items (clé)
- ItemWarehouses → Units (clé)
- ItemWarehouses → Users (clé, 2 keys)
- SerialNumbers → StorageLocations (clé)
- SerialNumbers → Warehouses (clé)
- SerialNumbers → Items (clé)
- SerialNumbers → Users (clé, 2 keys)
- StockBatchNumbers → BatchNumbers (clé)
- StockBatchNumbers → StockCountLines (clé)
- StockBatchNumbers → StorageLocations (clé)
- StockBatchNumbers → Warehouses (clé)
- StockBatchNumbers → Items (clé)
- StockBatchNumbers → Users (clé, 2 keys)
- StockCountLines → StockCounts (clé)
- StockCountLines → StorageLocations (clé)
- StockCountLines → Warehouses (clé)
- StockCountLines → Items (clé)
- StockCountLines → Users (clé, 3 keys)
- StockCounts → GLAccounts (clé)
- StockCounts → Warehouses (clé)
- StockCounts → Users (clé, 3 keys)
- StockSerialNumbers → SerialNumbers (clé)
- StockSerialNumbers → StockCountLines (clé)
- StockSerialNumbers → StorageLocations (clé)
- StockSerialNumbers → Warehouses (clé)
- StockSerialNumbers → Items (clé)
- StockSerialNumbers → Users (clé, 2 keys)
- StorageLocations → Warehouses (clé)
- StorageLocations → Users (clé, 2 keys)
- WarehouseTransferLines → StorageLocations (clé, 2 keys)
- WarehouseTransferLines → WarehouseTransfers (clé)
- WarehouseTransferLines → Items (clé)
- WarehouseTransferLines → Users (clé, 2 keys)
- WarehouseTransfers → Warehouses (clé, 2 keys)
- WarehouseTransfers → Users (clé, 2 keys)
- Warehouses → StorageLocations (clé)
- Warehouses → Users (clé, 3 keys)
- MyBankAccounts → Users (clé, 2 keys)
- OAuthClients → Users (clé, 2 keys)
- PartnerKeys → Users (clé, 2 keys)
- CustomerItems → Accounts (clé)
- CustomerItems → Items (clé)
- CustomerItems → Users (clé, 2 keys)
- ItemChargeRelations → Currencies (clé)
- ItemGroups → GLAccounts (clé, 6 keys)
- ItemGroups → Users (clé, 2 keys)
- ItemVersions → Items (clé)
- ItemVersions → Users (clé, 2 keys)
- Items → GLAccounts (clé, 6 keys)
- Items → ItemGroups (clé, 3 keys)
- Items → Units (clé, 2 keys)
- Items → Users (clé, 6 keys)
- SalesItemPrices → Accounts (clé, 2 keys)
- SalesItemPrices → Currencies (clé, 2 keys)
- SalesItemPrices → Items (clé, 2 keys)
- SalesItemPrices → Units (clé, 2 keys)
- SalesItemPrices → Users (clé, 4 keys)
- SelectionCodes → Users (clé, 2 keys)
- SupplierItems → Accounts (clé)
- SupplierItems → Currencies (clé)
- SupplierItems → Items (clé)
- SupplierItems → Users (clé, 2 keys)
- DefaultMailbox → Users (clé, 2 keys)
- MailMessagesReceived → Mailboxes (clé)
- MailMessagesReceived → Users (clé, 2 keys)
- MailMessagesReceivedByMailbox → Mailboxes (clé)
- MailMessagesReceivedByMailbox → Users (clé, 2 keys)
- MailMessagesSent → Mailboxes (clé)
- MailMessagesSent → Users (clé, 2 keys)
- Mailboxes → Accounts (clé)
- Mailboxes → Users (clé, 2 keys)
- PreferredMailbox → Users (clé, 2 keys)
- BillOfMaterialMaterials → Costcenters (clé)
- BillOfMaterialMaterials → Costunits (clé)
- BillOfMaterialMaterials → ItemVersions (clé)
- BillOfMaterialMaterials → Items (clé)
- BillOfMaterialMaterials → Users (clé, 2 keys)
- BillOfMaterialVersions → Items (clé)
- BillOfMaterialVersions → Users (clé, 2 keys)
- ByProductReceipts → StorageLocations (clé)
- ByProductReceipts → Warehouses (clé)
- ByProductReceipts → Items (clé)
- ByProductReceipts → Units (clé)
- ByProductReceipts → ShopOrderMaterialPlans (clé)
- ByProductReceipts → ShopOrders (clé)
- ByProductReceipts → Users (clé)
- ByProductReversals → StorageLocations (clé)
- ByProductReversals → Warehouses (clé)
- ByProductReversals → Items (clé)
- ByProductReversals → Units (clé)
- ByProductReversals → ShopOrderMaterialPlans (clé)
- ByProductReversals → ShopOrders (clé)
- ByProductReversals → Users (clé)
- MaterialIssues → StorageLocations (clé)
- MaterialIssues → Warehouses (clé)
- MaterialIssues → Items (clé)
- MaterialIssues → Units (clé)
- MaterialIssues → ShopOrderMaterialPlans (clé)
- MaterialIssues → ShopOrders (clé)
- MaterialIssues → Users (clé)
- MaterialReversals → StorageLocations (clé)
- MaterialReversals → Warehouses (clé)
- MaterialReversals → Items (clé)
- MaterialReversals → Units (clé)
- MaterialReversals → ShopOrderMaterialPlans (clé)
- MaterialReversals → ShopOrders (clé)
- MaterialReversals → Users (clé)
- MfgItemWarehouseStorageLocations → StorageLocations (clé)
- MfgItemWarehouseStorageLocations → Warehouses (clé)
- MfgItemWarehouseStorageLocations → Items (clé)
- MfgItemWarehouseStorageLocations → Units (clé)
- MfgSalesOrderlines → VATCodes (clé)
- MfgTimeTransactions → ShopOrderRoutingStepPlans (clé)
- MfgTimeTransactions → ShopOrders (clé)
- MfgTimeTransactions → Workcenters (clé)
- MfgTimeTransactions → Employees (clé)
- MfgTimeTransactions → Users (clé, 2 keys)
- OperationResources → Accounts (clé)
- OperationResources → Currencies (clé)
- OperationResources → Operations (clé)
- OperationResources → Workcenters (clé)
- OperationResources → Users (clé, 2 keys)
- Operations → Items (clé)
- Operations → Users (clé, 2 keys)
- ProductionAreas → Costcenters (clé)
- ProductionAreas → Costunits (clé)
- ProductionAreas → Users (clé, 2 keys)
- ShopOrderMaterialPlanDetails → Users (clé, 2 keys)
- ShopOrderMaterialPlans → Items (clé)
- ShopOrderMaterialPlans → Units (clé)
- ShopOrderMaterialPlans → ShopOrders (clé)
- ShopOrderMaterialPlans → Users (clé, 2 keys)
- ShopOrderReceipts → StorageLocations (clé)
- ShopOrderReceipts → Warehouses (clé)
- ShopOrderReceipts → Items (clé)
- ShopOrderReceipts → Units (clé)
- ShopOrderReceipts → ShopOrders (clé, 2 keys)
- ShopOrderReceipts → Users (clé)
- ShopOrderReversals → StorageLocations (clé)
- ShopOrderReversals → Warehouses (clé)
- ShopOrderReversals → Items (clé)
- ShopOrderReversals → Units (clé)
- ShopOrderReversals → ShopOrders (clé)
- ShopOrderReversals → Users (clé)
- ShopOrderRoutingStepPlans → Accounts (clé)
- ShopOrderRoutingStepPlans → OperationResources (clé)
- ShopOrderRoutingStepPlans → Operations (clé)
- ShopOrderRoutingStepPlans → ShopOrders (clé)
- ShopOrderRoutingStepPlans → Workcenters (clé)
- ShopOrderRoutingStepPlans → Users (clé, 2 keys)
- ShopOrders → Costcenters (clé)
- ShopOrders → Costunits (clé)
- ShopOrders → Warehouses (clé)
- ShopOrders → ItemVersions (clé)
- ShopOrders → Items (clé)
- ShopOrders → SelectionCodes (clé)
- ShopOrders → Units (clé)
- ShopOrders → ShopOrders (clé, 2 keys)
- ShopOrders → Projects (clé)
- ShopOrders → Users (clé, 2 keys)
- StageForDeliveryReceipts → Warehouses (clé)
- StageForDeliveryReceipts → Items (clé)
- StageForDeliveryReceipts → Units (clé)
- StageForDeliveryReceipts → ShopOrders (clé)
- StageForDeliveryReceipts → Users (clé)
- StageForDeliveryReversals → Warehouses (clé)
- StageForDeliveryReversals → Items (clé)
- StageForDeliveryReversals → Units (clé)
- StageForDeliveryReversals → ShopOrders (clé)
- StageForDeliveryReversals → Users (clé)
- SubOrderReceipts → Warehouses (clé)
- SubOrderReceipts → Items (clé)
- SubOrderReceipts → Units (clé)
- SubOrderReceipts → ShopOrderMaterialPlans (clé)
- SubOrderReceipts → ShopOrders (clé, 2 keys)
- SubOrderReceipts → Users (clé)
- SubOrderReversals → Warehouses (clé)
- SubOrderReversals → Items (clé)
- SubOrderReversals → Units (clé)
- SubOrderReversals → ShopOrders (clé, 2 keys)
- SubOrderReversals → Users (clé)
- TimedTimeTransactions → Users (clé, 2 keys)
- Workcenters → Costcenters (clé)
- Workcenters → Costunits (clé)
- Workcenters → ProductionAreas (clé)
- Workcenters → Users (clé, 2 keys)
- CurrentYearAfterEntry → GLAccounts (clé)
- CurrentYearProcessed → GLAccounts (clé)
- PreviousYearAfterEntry → GLAccounts (clé)
- PreviousYearProcessed → GLAccounts (clé)
- ActiveEmployments → Documents (clé)
- ActiveEmployments → Departments (clé)
- ActiveEmployments → JobTitles (clé)
- ActiveEmployments → Schedules (clé)
- ActiveEmployments → Employees (clé)
- ActiveEmployments → EmploymentContracts (clé)
- ActiveEmployments → EmploymentOrganizations (clé)
- ActiveEmployments → EmploymentSalaries (clé)
- ActiveEmployments → Users (clé, 2 keys)
- Employees → Accounts (clé)
- Employees → Users (clé, 2 keys)
- EmploymentConditionGroups → Users (clé, 2 keys)
- EmploymentContracts → Documents (clé)
- EmploymentContracts → Employees (clé)
- EmploymentContracts → Employments (clé)
- EmploymentContracts → Users (clé, 2 keys)
- EmploymentOrganizations → Costcenters (clé)
- EmploymentOrganizations → Costunits (clé)
- EmploymentOrganizations → Departments (clé)
- EmploymentOrganizations → JobTitles (clé)
- EmploymentOrganizations → Employees (clé)
- EmploymentOrganizations → Employments (clé)
- EmploymentOrganizations → Users (clé, 2 keys)
- EmploymentSalaries → Schedules (clé)
- EmploymentSalaries → Employees (clé)
- EmploymentSalaries → Employments (clé)
- EmploymentSalaries → Users (clé, 2 keys)
- Employments → Employees (clé)
- Employments → Users (clé, 2 keys)
- TaxEmploymentEndFlexCodes → Users (clé, 2 keys)
- VariableMutations → Employees (clé)
- CostTransactions → Accounts (clé, 3 keys)
- CostTransactions → Currencies (clé)
- CostTransactions → Items (clé)
- CostTransactions → Employees (clé)
- CostTransactions → Projects (clé)
- CostTransactions → Subscriptions (clé)
- CostTransactions → Users (clé, 2 keys)
- EmployeeRestrictionItems → Items (clé)
- EmployeeRestrictionItems → Employees (clé)
- EmployeeRestrictionItems → Users (clé, 2 keys)
- EmploymentInternalRates → Employees (clé)
- EmploymentInternalRates → Employments (clé)
- EmploymentInternalRates → Users (clé, 2 keys)
- InvoiceTerms → Items (clé)
- InvoiceTerms → Projects (clé)
- InvoiceTerms → Users (clé, 2 keys)
- InvoiceTerms → VATCodes (clé)
- PjtTimeTransactions → Accounts (clé, 3 keys)
- PjtTimeTransactions → Currencies (clé)
- PjtTimeTransactions → Items (clé)
- PjtTimeTransactions → Employees (clé)
- PjtTimeTransactions → Projects (clé)
- PjtTimeTransactions → Subscriptions (clé)
- PjtTimeTransactions → Users (clé, 2 keys)
- ProjectAccountMutations → Accounts (clé)
- ProjectAccountMutations → Projects (clé)
- ProjectAccountMutations → Users (clé, 2 keys)
- ProjectHourBudgets → Items (clé)
- ProjectHourBudgets → Projects (clé)
- ProjectHourBudgets → Users (clé, 2 keys)
- ProjectPlanning → Accounts (clé)
- ProjectPlanning → Employees (clé)
- ProjectPlanning → ProjectPlanningRecurring (clé)
- ProjectPlanning → ProjectWBS (clé)
- ProjectPlanning → Projects (clé)
- ProjectPlanning → Users (clé, 2 keys)
- ProjectPlanningRecurring → Accounts (clé)
- ProjectPlanningRecurring → Employees (clé)
- ProjectPlanningRecurring → ProjectWBS (clé)
- ProjectPlanningRecurring → Projects (clé)
- ProjectPlanningRecurring → Users (clé, 2 keys)
- ProjectRestrictionEmployeeItems → Items (clé)
- ProjectRestrictionEmployeeItems → Employees (clé)
- ProjectRestrictionEmployeeItems → Projects (clé)
- ProjectRestrictionEmployeeItems → Users (clé, 2 keys)
- ProjectRestrictionEmployees → Employees (clé)
- ProjectRestrictionEmployees → Projects (clé)
- ProjectRestrictionEmployees → Users (clé, 2 keys)
- ProjectRestrictionItems → Items (clé)
- ProjectRestrictionItems → Projects (clé)
- ProjectRestrictionItems → Users (clé, 2 keys)
- ProjectRestrictionRebillings → Projects (clé)
- ProjectRestrictionRebillings → Users (clé, 2 keys)
- ProjectWBS → Items (clé, 2 keys)
- ProjectWBS → InvoiceTerms (clé, 2 keys)
- ProjectWBS → ProjectWBS (clé)
- ProjectWBS → Projects (clé, 2 keys)
- ProjectWBS → Users (clé, 4 keys)
- Projects → Accounts (clé)
- Projects → Addresses (clé)
- Projects → Contacts (clé)
- Projects → Quotations (clé)
- Projects → Items (clé, 2 keys)
- Projects → Users (clé, 2 keys)
- RecentCosts → Accounts (clé)
- RecentCosts → Currencies (clé)
- RecentCosts → Items (clé)
- RecentCosts → Projects (clé)
- RecentHours → Accounts (clé)
- RecentHours → Items (clé)
- RecentHours → Projects (clé)
- TimeCorrections → Users (clé, 2 keys)
- WBSActivities → Items (clé)
- WBSActivities → Projects (clé)
- WBSActivities → Users (clé, 2 keys)
- WBSDeliverables → InvoiceTerms (clé)
- WBSDeliverables → Projects (clé)
- WBSDeliverables → Users (clé, 2 keys)
- WBSExpenses → Projects (clé)
- WBSExpenses → Users (clé, 2 keys)
- PurchaseInvoiceLines → Currencies (clé)
- PurchaseInvoiceLines → Costcenters (clé)
- PurchaseInvoiceLines → Costunits (clé)
- PurchaseInvoiceLines → Items (clé)
- PurchaseInvoiceLines → Units (clé, 2 keys)
- PurchaseInvoiceLines → Projects (clé)
- PurchaseInvoiceLines → PurchaseInvoices (clé)
- PurchaseInvoiceLines → PurchaseOrderLines (clé)
- PurchaseInvoiceLines → VATCodes (clé)
- PurchaseInvoices → Accounts (clé)
- PurchaseInvoices → Contacts (clé)
- PurchaseInvoices → Documents (clé)
- PurchaseInvoices → Journals (clé)
- PurchaseInvoices → Currencies (clé)
- PurchaseInvoices → Warehouses (clé)
- PurchaseEntries → Accounts (clé)
- PurchaseEntries → Documents (clé)
- PurchaseEntries → Journals (clé)
- PurchaseEntries → Currencies (clé)
- PurchaseEntries → Users (clé, 2 keys)
- PurchaseEntryLines → Assets (clé)
- PurchaseEntryLines → GLAccounts (clé)
- PurchaseEntryLines → Costcenters (clé)
- PurchaseEntryLines → Costunits (clé)
- PurchaseEntryLines → Projects (clé)
- PurchaseEntryLines → Subscriptions (clé)
- PurchaseEntryLines → VATCodes (clé)
- GoodsReceiptLines → Items (clé)
- GoodsReceiptLines → Projects (clé)
- GoodsReceiptLines → GoodsReceipts (clé)
- GoodsReceiptLines → PurchaseOrderLines (clé)
- GoodsReceiptLines → PurchaseOrders (clé)
- GoodsReceiptLines → Users (clé, 2 keys)
- GoodsReceipts → Accounts (clé)
- GoodsReceipts → Contacts (clé)
- GoodsReceipts → Documents (clé)
- GoodsReceipts → Warehouses (clé)
- GoodsReceipts → Users (clé, 2 keys)
- PurchaseOrderLines → Costcenters (clé)
- PurchaseOrderLines → Costunits (clé)
- PurchaseOrderLines → Items (clé)
- PurchaseOrderLines → Units (clé)
- PurchaseOrderLines → Projects (clé)
- PurchaseOrderLines → PurchaseOrders (clé)
- PurchaseOrderLines → SalesOrderLines (clé)
- PurchaseOrderLines → SalesOrders (clé)
- PurchaseOrderLines → Users (clé, 2 keys)
- PurchaseOrderLines → VATCodes (clé)
- PurchaseOrderStockBatchNumbers → BatchNumbers (clé)
- PurchaseOrderStockBatchNumbers → StockCountLines (clé)
- PurchaseOrderStockBatchNumbers → StorageLocations (clé)
- PurchaseOrderStockBatchNumbers → Warehouses (clé)
- PurchaseOrderStockBatchNumbers → Items (clé)
- PurchaseOrderStockBatchNumbers → Users (clé, 2 keys)
- PurchaseOrderStockSerialNumbers → SerialNumbers (clé)
- PurchaseOrderStockSerialNumbers → StockCountLines (clé)
- PurchaseOrderStockSerialNumbers → StorageLocations (clé)
- PurchaseOrderStockSerialNumbers → Warehouses (clé)
- PurchaseOrderStockSerialNumbers → Items (clé)
- PurchaseOrderStockSerialNumbers → Users (clé, 2 keys)
- PurchaseOrders → Accounts (clé, 2 keys)
- PurchaseOrders → Addresses (clé)
- PurchaseOrders → Contacts (clé, 2 keys)
- PurchaseOrders → Documents (clé)
- PurchaseOrders → Currencies (clé)
- PurchaseOrders → Warehouses (clé)
- PurchaseOrders → SelectionCodes (clé)
- PurchaseOrders → ShippingMethods (clé)
- PurchaseOrders → SalesOrders (clé)
- PurchaseOrders → Users (clé, 3 keys)
- SalesPriceListLinkedAccounts → SalesPriceLists (clé)
- SalesPriceListLinkedAccounts → Users (clé, 2 keys)
- SalesPriceListPeriods → Currencies (clé)
- SalesPriceListPeriods → SalesPriceLists (clé)
- SalesPriceListPeriods → Users (clé, 2 keys)
- SalesPriceListVolumeDiscounts → ItemGroups (clé)
- SalesPriceListVolumeDiscounts → Items (clé)
- SalesPriceListVolumeDiscounts → Units (clé)
- SalesPriceListVolumeDiscounts → SalesPriceListPeriods (clé)
- SalesPriceListVolumeDiscounts → Users (clé, 2 keys)
- SalesPriceLists → Currencies (clé)
- SalesPriceLists → Users (clé, 2 keys)
- ShippingMethods → Users (clé, 2 keys)
- SalesEntries → Accounts (clé)
- SalesEntries → Documents (clé)
- SalesEntries → Journals (clé)
- SalesEntries → Currencies (clé)
- SalesEntries → Users (clé, 2 keys)
- SalesEntryLines → Assets (clé)
- SalesEntryLines → GLAccounts (clé)
- SalesEntryLines → Costcenters (clé)
- SalesEntryLines → Costunits (clé)
- SalesEntryLines → ProjectWBS (clé)
- SalesEntryLines → Projects (clé)
- SalesEntryLines → Subscriptions (clé)
- SalesEntryLines → VATCodes (clé)
- Layouts → Users (clé, 2 keys)
- SalesInvoiceLines → GLAccounts (clé, 2 keys)
- SalesInvoiceLines → Costcenters (clé, 2 keys)
- SalesInvoiceLines → Costunits (clé, 2 keys)
- SalesInvoiceLines → Items (clé, 2 keys)
- SalesInvoiceLines → Employees (clé, 2 keys)
- SalesInvoiceLines → ProjectWBS (clé, 2 keys)
- SalesInvoiceLines → Projects (clé, 2 keys)
- SalesInvoiceLines → SalesPriceLists (clé, 2 keys)
- SalesInvoiceLines → SalesInvoices (clé, 2 keys)
- SalesInvoiceLines → SalesOrderLines (clé, 2 keys)
- SalesInvoiceLines → SalesOrders (clé, 2 keys)
- SalesInvoiceLines → Subscriptions (clé, 2 keys)
- SalesInvoiceLines → VATCodes (clé, 2 keys)
- SalesInvoices → Accounts (clé, 6 keys)
- SalesInvoices → Addresses (clé, 2 keys)
- SalesInvoices → Contacts (clé, 6 keys)
- SalesInvoices → Documents (clé, 2 keys)
- SalesInvoices → Journals (clé, 2 keys)
- SalesInvoices → Currencies (clé, 2 keys)
- SalesInvoices → Warehouses (clé, 2 keys)
- SalesInvoices → SelectionCodes (clé, 2 keys)
- SalesInvoices → Users (clé, 6 keys)
- DigitalOrderPickingLines → StorageLocations (clé)
- DigitalOrderPickingLines → Warehouses (clé)
- DigitalOrderPickingLines → Items (clé)
- DigitalOrderPickingLines → DigitalOrderPickings (clé)
- DigitalOrderPickingLines → SalesOrderLines (clé)
- DigitalOrderPickingLines → Users (clé, 3 keys)
- DigitalOrderPickings → Accounts (clé)
- DigitalOrderPickings → Warehouses (clé)
- DigitalOrderPickings → Users (clé, 3 keys)
- GoodsDeliveries → Accounts (clé, 2 keys)
- GoodsDeliveries → Addresses (clé, 2 keys)
- GoodsDeliveries → Contacts (clé, 2 keys)
- GoodsDeliveries → Documents (clé, 2 keys)
- GoodsDeliveries → Warehouses (clé, 2 keys)
- GoodsDeliveries → ShippingMethods (clé, 2 keys)
- GoodsDeliveries → Users (clé, 4 keys)
- GoodsDeliveryLines → StorageLocations (clé, 2 keys)
- GoodsDeliveryLines → Items (clé, 2 keys)
- GoodsDeliveryLines → GoodsDeliveries (clé, 2 keys)
- GoodsDeliveryLines → SalesOrderLines (clé, 2 keys)
- GoodsDeliveryLines → Users (clé, 4 keys)
- PlannedSalesReturnLines → StorageLocations (clé)
- PlannedSalesReturnLines → Items (clé)
- PlannedSalesReturnLines → GoodsDeliveryLines (clé)
- PlannedSalesReturnLines → PlannedSalesReturns (clé)
- PlannedSalesReturnLines → SalesOrderLines (clé)
- PlannedSalesReturnLines → Users (clé, 2 keys)
- PlannedSalesReturns → Accounts (clé)
- PlannedSalesReturns → Addresses (clé)
- PlannedSalesReturns → Contacts (clé)
- PlannedSalesReturns → Documents (clé)
- PlannedSalesReturns → Warehouses (clé)
- PlannedSalesReturns → Users (clé, 2 keys)
- SalesOrderLayouts → Users (clé, 2 keys)
- SalesOrderLines → Costcenters (clé, 2 keys)
- SalesOrderLines → Costunits (clé, 2 keys)
- SalesOrderLines → ItemVersions (clé, 2 keys)
- SalesOrderLines → Items (clé, 2 keys)
- SalesOrderLines → ShopOrders (clé, 2 keys)
- SalesOrderLines → Projects (clé, 2 keys)
- SalesOrderLines → PurchaseOrderLines (clé, 2 keys)
- SalesOrderLines → PurchaseOrders (clé, 2 keys)
- SalesOrderLines → SalesPriceLists (clé, 2 keys)
- SalesOrderLines → SalesOrders (clé, 2 keys)
- SalesOrderLines → VATCodes (clé, 2 keys)
- SalesOrderStockBatchNumbers → BatchNumbers (clé, 2 keys)
- SalesOrderStockBatchNumbers → StockCountLines (clé, 2 keys)
- SalesOrderStockBatchNumbers → StorageLocations (clé, 2 keys)
- SalesOrderStockBatchNumbers → Warehouses (clé, 2 keys)
- SalesOrderStockBatchNumbers → Items (clé, 2 keys)
- SalesOrderStockBatchNumbers → Users (clé, 4 keys)
- SalesOrderStockSerialNumbers → SerialNumbers (clé)
- SalesOrderStockSerialNumbers → StockCountLines (clé)
- SalesOrderStockSerialNumbers → StorageLocations (clé)
- SalesOrderStockSerialNumbers → Warehouses (clé)
- SalesOrderStockSerialNumbers → Items (clé)
- SalesOrderStockSerialNumbers → Users (clé, 4 keys)
- SalesOrderStorageLocationsBulk → Warehouses (clé)
- SalesOrders → Accounts (clé, 6 keys)
- SalesOrders → Addresses (clé, 2 keys)
- SalesOrders → Contacts (clé, 6 keys)
- SalesOrders → Documents (clé, 2 keys)
- SalesOrders → Currencies (clé, 2 keys)
- SalesOrders → Warehouses (clé, 2 keys)
- SalesOrders → SelectionCodes (clé, 2 keys)
- SalesOrders → ShippingMethods (clé, 2 keys)
- SalesOrders → Users (clé, 8 keys)
- SubscriptionLines → Costcenters (clé)
- SubscriptionLines → Costunits (clé)
- SubscriptionLines → Items (clé)
- SubscriptionLines → Subscriptions (clé)
- SubscriptionLines → VATCodes (clé)
- SubscriptionReasonCodes → Users (clé, 2 keys)
- SubscriptionRestrictionEmployees → Employees (clé)
- SubscriptionRestrictionEmployees → Subscriptions (clé)
- SubscriptionRestrictionEmployees → Users (clé, 2 keys)
- SubscriptionRestrictionItems → Items (clé)
- SubscriptionRestrictionItems → Subscriptions (clé)
- SubscriptionRestrictionItems → Users (clé, 2 keys)
- SubscriptionTypes → Users (clé, 2 keys)
- Subscriptions → Accounts (clé, 2 keys)
- Subscriptions → Contacts (clé, 2 keys)
- Subscriptions → Currencies (clé)
- Subscriptions → SubscriptionTypes (clé)
- Subscriptions → Users (clé, 2 keys)
- GetCurrentDivision → Accounts (clé)
- GetCurrentDivision → Currencies (clé)
- GetCurrentDivision → Users (clé, 2 keys)
- GetMostRecentlyUsedDivisions → Accounts (clé)
- GetMostRecentlyUsedDivisions → Currencies (clé)
- GetMostRecentlyUsedDivisions → Users (clé, 2 keys)
- Me → Employees (clé)
- SystemDivisions → Accounts (clé)
- SystemDivisions → Currencies (clé)
- SystemDivisions → Users (clé, 2 keys)
- UserRoles → Users (clé, 3 keys)
- UserRolesPerDivision → Users (clé, 3 keys)
- Users → Accounts (clé)
- Users → Users (clé, 2 keys)
- TaxComponentRates → Users (clé, 2 keys)
- TaxScheduleComponents → Users (clé, 2 keys)
- TaxSchedules → Users (clé, 2 keys)
- VATCodes → Accounts (clé)
- VATCodes → GLAccounts (clé, 4 keys)
- VATCodes → Users (clé, 2 keys)
- VatPercentages → Users (clé, 2 keys)
- WebhookSubscriptions → Users (clé)
- CustomerCooperations → Accounts (clé)
- CustomerCooperations → Currencies (clé)
- CustomerCooperations → Users (clé, 2 keys)
Tableaux
ExactOnlineDataDictionary.DataDictionary
- IncrementalEntityTypes: Please use the software from that date onwards, or contact the Invantive licence desk when the subscription was meant to have started already.
- IncrementalLoadDataFiles: Incremental Loading Data Files
- IncrementalLoadEventLogEntries: Incremental Loading Event Log Entries
- IncrementalLoadStatistics: Incremental Loading Statistics
- IncrementalLoadStatuses: Incremental Loading Statuses
- RowCounts: Row Counts
ExactOnlineHTML.Documents
- AttachmentByRow: Attachment of Row
- AttachmentByUrl: Attachment by URL
- ThumbnailByRow: Thumbnail of Row
- ThumbnailByUrl: Thumbnail by URL
ExactOnlineHTML.Unsupported
- BackupContents: Backup Contents
- Backups: Backups
ExactOnlineREST.Accountancy
- AccountInvolvedAccounts: Account Involved Accounts
- AccountOwners: Account Owners
- CenterFilters: User Type Filters
- CenterProfileCertifications: Accountant Profile Certifications
- CenterProfileDetails: Accountant Profile Details
- CenterProfileLocations: Accountant Profile Locations
- CenterProfiles: Accountant Profiles
- CenterTags: Accountant Tags
- Certifications: Certifications
- CollaborationRequests: Collaboration Requests
- DeclarationRenderData: Declaration Render Data
- DeclarationRenderDataByDocId: Declaration Render Data by Document ID
- DeclarationUploads: Declaration Uploads
- ExcludedDivisions: Excluded Divisions
- Filters: Filters
- InvolvedUserRoles: Involved User Roles
- InvolvedUsers: Involved Users
- ProfileCertifications: Profile Certifications
- ProfileDetails: Profile Details
- Profiles: Profiles
- QuestionListClientLists: Client Lists
- QuestionListClientQuestions: Client Questions
- QuestionListClientSections: Client Sections
- QuestionlistClientListByRequestId: Client Question List by Request ID
- SolutionLinks: Solution Links
- StopCollaboration: Stop Collaboration Requests
- StopCollaborationByAccountant: Stop Collaboration by Accountant
- TaskTypes: Task Types
ExactOnlineREST.Activities
- CommunicationNotes: Communication Notes
- Complaints: Complaints
- Events: Events
- InContextRequests: In-context Requests
- Messages: Messages
- RequestAttachments: Request Attachments
- ServiceRequests: Service Requests
- Tasks: Tasks
ExactOnlineREST.AppCenter
- AppDetails: Exact Online App Store App Details
- AppExactOnlineProducts: Exact Online App Store App Supported Products
- AppExactOnlineSolutionFilterSubscriptions: Exact Online App Store App Solution Filter Subscriptions
- AppExactOnlineSolutions: Exact Online App Store App Solutions
- AppPricePlanElements: Exact Online App Store App Price Elements
- AppPricePlans: Exact Online App Store App Price Plans
- AppReviews: Exact Online App Store App Reviews
- Apps: Exact Online App Store Apps
ExactOnlineREST.Assets
- AssetGroups: Asset Groups
- Assets: Assets
- CommercialBuildingValues: Commercial Building Values
- DepreciationMethods: Depreciation Methods
ExactOnlineREST.Balances
- BalanceLineTotalsCostAnalysisAll: Balance Lines Totals for Cost Analysis (All Years)
- BalanceLineTotalsCostAnalysisAllProcessed: Balance Lines Totals for Cost Analysis (All Years, Processed Entries)
- BalanceLinesCostAnalysisAll: Balance Lines per Year for Cost Analysis (All Years)
- BalanceLinesCostAnalysisAllProcessed: Balance Lines per Year for Cost Analysis (All Years, Processed Entries)
- BalanceLinesPerPeriodAll: Balance Lines per Period (All Years)
- BalanceLinesPerPeriodCostAnalysisAll: Balance Lines per Period for Cost Analysis (All Years)
ExactOnlineREST.BankGateway
- BankSubscriptions: Bank Subscriptions
ExactOnlineREST.Budget
- BudgetScenarios: Budget Scenarios
- Budgets: Budgets
ExactOnlineREST.CRM
- AcceptQuotation: Accept Quotation
- AccountClasses: Account Classes
- AccountClassificationNames: Account Classification Names
- AccountClassificationNamesRead: Account Classification Names (Read-only)
- AccountClassifications: Account Classifications
- AccountClassificationsRead: Account Classifications (Read-only)
- AccountDocumentFolders: Account Document Folders
- AccountDocuments: Account Documents
- Accounts: Accounts
- AccountsBulk: Accounts
- AccountsFullTextSearch: Accounts Full-Text Search
- AddressStates: Address States
- Addresses: Addresses
- AddressesBulk: Addresses
- AddressesRead: Addresses (Read-only)
- BankAccounts: Bank Accounts
- BankAccountsBulk: Bank Accounts
- BankAccountsRead: Bank Accounts (Read-only)
- BusinessTypes: Business Types
- ClientDossierDocumentFolderContents: Client File Document Folder Contents
- Contacts: Contacts
- ContactsBulk: Contacts
- ContactsRead: Contacts (Read-only)
- CrmDocuments: CRM Documents
- DefaultAddressForAccountRead: Default Address for Account
- DivisionDocumentFolders: Company Document Folders
- DivisionDocuments: Company Documents
- DocumentExplorerDocumentFolders: Document Explorer Folders
- DocumentExplorerDocuments: Document Explorer Documents
- DocumentFolderContents: Document Folder Contents
- DocumentFolderContentsByFolderId: Document Folder Contents by Folder ID
- DocumentsAttachments: Attachment
- DossierDocumentFolderContent: File Document Folder Content
- DossierDocumentFolderContents: File Document Folder Contents
- EmailWithSignOffQuotation: Email with Sign Off Quotation
- HostingOpportunities: Hosting Opportunities
- HostingOpportunitiesRead: Hosting Opportunities
- LeadPurposes: Lead Purposes
- LeadSources: Lead Sources
- Opportunities: Opportunities
- OpportunitiesRead: Opportunities (Read-only)
- OpportunityContactsRead: Opportunity Contacts (Read-only)
- OpportunityDocuments: Opportunity Documents
- OpportunityStages: Opportunity Stages
- OptionalQuotationLineID: Optional Quotation Line I D
- PrintQuotation: Print Quotation
- QuotationLines: Quotation Lines
- QuotationLinesBulk: Quotation Lines
- QuotationOrderChargeLines: Quotation Order Charge Lines
- Quotations: Quotations
- QuotationsBulk: Quotations
- ReasonCodes: Reason Codes
- RejectQuotation: Reject Quotation
- ReopenQuotation: Reopen Quotation
- ReviewQuotation: Review Quotation
- SalesTypes: Sales Types
ExactOnlineREST.Cashflow
- AllocationRule: Allocation Rule
- BankLinks: Bank Links
- Banks: Banks
- DirectDebitMandates: Direct Debit Mandates
- ImportNotificationDetails: Import Notification Details
- ImportNotifications: Import Notifications
- InternalPayments: Internal Payments
- Lines: Lines
- PaymentConditions: Payment Conditions
- PaymentIDs: Payment IDs
- Payments: Payments
- PaymentsBulk: Payments
- ProcessPayments: Process Payments
- Receivables: Receivables
- ReceivablesBulk: Receivables
- Statements: Statements
- TransactionIdentifiers: Transaction Identifiers
ExactOnlineREST.CodeValues
- AbsenceRegistrationTransactionStatuses: Domain AbsenceRegistrationTransactionStatuses
- AccountConsolidationScenarios: Domain AccountConsolidationScenarios
- AccountCustomerStatuses: Domain AccountCustomerStatuses
- AccountTypes: Domain AccountTypes
- AddressTypes: Domain AddressTypes
- AssemblyOrderStatuses: Domain AssemblyOrderStatuses
- AssetStatuses: Domain AssetStatuses
- BalanceSides: Domain BalanceSides
- BalanceTypes: Domain BalanceTypes
- BankAccountTypes: Domain BankAccountTypes
- BankStatuses: Domain BankStatuses
- BelgiumBelcoTaxTypes: Domain BelgiumBelcoTaxTypes
- BelgiumInvestmentDeductions: Domain BelgiumInvestmentDeductions
- BelgiumVatGlAccountTypes: Domain BelgiumVatGlAccountTypes
- BlockingStatuses: Domain BlockingStatuses
- BusinessComponents: Domain BusinessComponents
- CalculatorTypes: Domain CalculatorTypes
- CommunicationNoteStatuses: Domain CommunicationNoteStatuses
- ComplaintStatuses: Domain ComplaintStatuses
- CostTransactionStatuses: Domain CostTransactionStatuses
- CreditCardTypes: Domain CreditCardTypes
- CreditManagementScenarioRuleActionStarts: Domain CreditManagementScenarioRuleActionStarts
- CreditManagementScenarioRuleActions: Domain CreditManagementScenarioRuleActions
- DdMandatePaymentTypes: Domain DdMandatePaymentTypes
- DdMandateTypes: Domain DdMandateTypes
- DepreciationIntervals: Domain DepreciationIntervals
- DepreciationMethodTypes: Domain DepreciationMethodTypes
- DirectDebitMandatePaymentTypes: Domain DirectDebitMandatePaymentTypes
- DirectDebitMandateTypes: Domain DirectDebitMandateTypes
- DivisionStatuses: Domain DivisionStatuses
- EmploymentContractReasons: Domain EmploymentContractReasons
- EmploymentContractTypes: Domain EmploymentContractTypes
- EngineTypes: Domain EngineTypes
- EntryTemplateLineAmountCalculations: Domain EntryTemplateLineAmountCalculations
- EntryTemplateTransactionStatuses: Domain EntryTemplateTransactionStatuses
- EttSources: Domain EttSources
- EuSalesListings: Domain EuSalesListings
- EventStatuses: Domain EventStatuses
- GLAccountTypes: Domain GLAccountTypes
- IndicatorValidationOperator: Domain IndicatorValidationOperator
- IntrastatTypes: Domain IntrastatTypes
- InvoiceAttachmentTypes: Domain InvoiceAttachmentTypes
- InvoiceStatuses: Domain InvoiceStatuses
- InvoiceTypes: Domain InvoiceTypes
- InvoicingMethods: Domain InvoicingMethods
- ItemVersionStatuses: Domain ItemVersionStatuses
- ItemVersionTypes: Domain ItemVersionTypes
- JournalStatuses: Domain JournalStatuses
- JournalTypes: Domain JournalTypes
- LayoutTypes: Domain LayoutTypes
- LeaveBuildUpRegistrationStatuses: Domain LeaveBuildUpRegistrationStatuses
- LeaveRegistrationStatuses: Domain LeaveRegistrationStatuses
- Legislations: Domain Legislations
- ManufacturedBillOfMaterialStatuses: Domain ManufacturedBillOfMaterialStatuses
- ManufacturedBillofMaterialRoutingDetailFactorTypes: Domain ManufacturedBillofMaterialRoutingDetailFactorTypes
- ManufacturedBillofMaterialRoutingDetailRoutingStepTypes: Domain ManufacturedBillofMaterialRoutingDetailRoutingStepTypes
- ManufacturedBillofMaterialRoutingDetailRunMethods: Domain ManufacturedBillofMaterialRoutingDetailRunMethods
- ManufacturedBillofMaterialRoutingDetailSetupTypes: Domain ManufacturedBillofMaterialRoutingDetailSetupTypes
- ManufacturingTimeTransactionActivities: Domain ManufacturingTimeTransactionActivities
- ManufacturingTimeTransactionHourStatuses: Domain ManufacturingTimeTransactionHourStatuses
- MaterialPlanStatuses: Domain MaterialPlanStatuses
- MaterialPurchaseOrderAssignSupplierVias: Domain MaterialPurchaseOrderAssignSupplierVias
- OperationResourceTypes: Domain OperationResourceTypes
- OperationStatuses: Domain OperationStatuses
- OpportunityStatuses: Domain OpportunityStatuses
- PaymentDiscountTypes: Domain PaymentDiscountTypes
- PaymentMethods: Domain PaymentMethods
- PaymentServiceProviders: Domain PaymentServiceProviders
- PaymentSources: Domain PaymentSources
- PaymentStatuses: Domain PaymentStatuses
- PeppolIdentifierTypes: Domain PeppolIdentifierTypes
- ProjectPlanningBgtStatuses: Domain ProjectPlanningBgtStatuses
- ProjectPlanningCommunicationErrorStatuses: Domain ProjectPlanningCommunicationErrorStatuses
- ProjectPlanningLineStatuses: Domain ProjectPlanningLineStatuses
- ProjectPlanningStatuses: Domain ProjectPlanningStatuses
- ProjectPlanningTypes: Domain ProjectPlanningTypes
- ProjectPrepaidTypes: Domain ProjectPrepaidTypes
- ProjectTimeTransactionHourStatuses: Domain ProjectTimeTransactionHourStatuses
- ProjectTypes: Domain ProjectTypes
- PurchaseInvoiceSources: Domain PurchaseInvoiceSources
- PurchaseInvoiceTypes: Domain PurchaseInvoiceTypes
- PurchaseOrderSources: Domain PurchaseOrderSources
- PurchaseOrderStatuses: Domain PurchaseOrderStatuses
- QuotationStatuses: Domain QuotationStatuses
- RGS10Codes: Domain RGS10Codes
- RGS10Hoofdrubrieken: Domain RGS10Hoofdrubrieken
- RGS10Mutaties: Domain RGS10Mutaties
- RGS10Rekeningen: Domain RGS10Rekeningen
- RGS10Rubrieken: Domain RGS10Rubrieken
- RGS11Codes: Domain RGS11Codes
- RGS11Hoofdrubrieken: Domain RGS11Hoofdrubrieken
- RGS11Mutaties: Domain RGS11Mutaties
- RGS11Rekeningen: Domain RGS11Rekeningen
- RGS11Rubrieken: Domain RGS11Rubrieken
- RGS20Codes: Domain RGS20Codes
- RGS30Codes: Domain RGS30Codes
- ReceivableSources: Domain ReceivableSources
- ReceivableStatuses: Domain ReceivableStatuses
- RecipientStatuses: Domain RecipientStatuses
- ReturnStatuses: Domain ReturnStatuses
- SalesEntryStatuses: Domain SalesEntryStatuses
- SalesEntryTypes: Domain SalesEntryTypes
- SalesForecastPeriodTypes: Domain SalesForecastPeriodTypes
- SalesOrderStatuses: Domain SalesOrderStatuses
- ScheduleTypes: Domain ScheduleTypes
- ServiceRequestStatuses: Domain ServiceRequestStatuses
- SettingValueTypes: Domain SettingValueTypes
- ShopOrderByProductPlanStatuses: Domain ShopOrderByProductPlanStatuses
- ShopOrderRoutingPlanStatuses: Domain ShopOrderRoutingPlanStatuses
- ShopOrderRoutingStepFactorTypes: Domain ShopOrderRoutingStepFactorTypes
- ShopOrderRoutingStepRunMethods: Domain ShopOrderRoutingStepRunMethods
- ShopOrderRoutingStepTypes: Domain ShopOrderRoutingStepTypes
- ShopOrderStatuses: Domain ShopOrderStatuses
- ShopOrderStockReceiptDispositions: Domain ShopOrderStockReceiptDispositions
- SolutionLinkStatuses: Domain SolutionLinkStatuses
- SolutionTypes: Domain SolutionTypes
- StandardTaskTypes: Domain StandardTaskTypes
- StockTransactionTypes: Domain StockTransactionTypes
- SubcontractPurchaseOrderAssignSupplierVias: Domain SubcontractPurchaseOrderAssignSupplierVias
- SubscriptionLineLineTypes: Domain SubscriptionLineLineTypes
- TaskStatuses: Domain TaskStatuses
- TaxReturnTypes: Domain TaxReturnTypes
- TrackingNumberStatuses: Domain TrackingNumberStatuses
- TrackingNumberTypes: Domain TrackingNumberTypes
- TransactionStatuses: Domain TransactionStatuses
- TransactionTypes: Domain TransactionTypes
- UnitTypes: Domain UnitTypes
- UserAuthenticationTypes: Domain UserAuthenticationTypes
- VATCalculations: Domain VATCalculations
- VatDocTypes: Domain VatDocTypes
- VatInclusionTypes: Domain VatInclusionTypes
- VatSystems: Domain VatSystems
- VatTransactionTypes: Domain VatTransactionTypes
- VatTypes: Domain VatTypes
- WBSTypes: Domain WBSTypes
- WarehouseTransferStatuses: Domain WarehouseTransferStatuses
- WebhookTopics: Domain WebhookTopics
- WorkcenterRunMethods: Domain WorkcenterRunMethods
- WorkcenterSetupUnits: Domain WorkcenterSetupUnits
- WorkcenterStatuses: Domain WorkcenterStatuses
- WorkcenterTypes: Domain WorkcenterTypes
- WriteOffTypes: Domain WriteOffTypes
- XmlMessageTypes: Domain XmlMessageTypes
ExactOnlineREST.ContinuousMonitoring
- IndicatorBalances: Indicator Balances
- IndicatorDeviatingAmountEntereds: Indicator Deviating Amounts Entered
- IndicatorDifferenceByPeriods: Indicator Difference by Periods
- IndicatorDifferentVatCodes: Indicator Different VAT Codes
- IndicatorGLAccounts: Indicator General Ledger Accounts
- IndicatorLiquidities: Indicator Liquidities
- IndicatorSignals: Indicator Signals
- IndicatorStates: Indicator States
- IndicatorUsageOfJournals: Indicator Usage of Journals
ExactOnlineREST.CustomFields
- CustomFieldValues: Custom Field Values
ExactOnlineREST.Documents
- DocumentAttachmentFiles: Document Attachment Files
- DocumentAttachmentFilesBulk: Document Attachment Files (Bulk)
- DocumentAttachments: Document Attachments
- DocumentAttachmentsBulk: Document Attachments (Bulk)
- DocumentCategories: Document Categories
- DocumentFolders: Document Folders
- DocumentTypeCategories: Document Type Categories
- DocumentTypeFolders: Document Type Folders
- DocumentTypes: Document Types
- Documents: Documents
- DocumentsBulk: Documents
- EolDmsDocuments: DMS Documents
ExactOnlineREST.Financial
- AgingOverview: Aging Overview
- AgingOverviewByAccount: Aging Overview by Account
- AgingOverviewByAccountOverdue: Overdue Aging Overview by Account
- AgingOverviewOverdue: Aging Overview Overdue Invoices
- AgingPayablesList: Aging Payables List
- AgingPayablesListByAgeGroup: Aging Payables List by Age Group
- AgingPayablesListByAgeGroupOverdue: Overdue Payables List by Age Group
- AgingPayablesListOverdue: Aging Overdue Payable Invoices
- AgingReceivablesList: Aging Receivables List
- AgingReceivablesListByAgeGroup: Aging Receivables List by Age Group
- AgingReceivablesListByAgeGroupOverdue: Overdue Receivables List by Age Group
- AgingReceivablesListOverdue: Aging Overdue Receivable Invoices
- CashflowBalance: Cashflow Balance
- DeductibilityPercentages: Deductibility Percentages
- DeductibilityPercentagesBulk: Deductibility Percentages
- DossierReturns: File Returns
- ExchangeRates: Exchange Rates
- FinancialPeriods: Financial Periods
- FinancialYears: Financial Years
- FinancialYears2: Financial Years
- FiscalVatEntities: Fiscal VAT Entities
- GLAccountClassificationMappings: GL Account Classification Mappings
- GLAccounts: General Ledger Accounts
- GLAccountsBulk: General Ledger Accounts
- GLClassifications: General Ledger Classifications
- GLClassificationsBulk: General Ledger Classifications
- GLSchemes: General Ledger Schemes
- GLTransactionSources: General Ledger Transaction Sources
- GLTransactionTypes: General Ledger Transaction Types
- JournalStatusByFinancialPeriod: Journal Status by Financial Period
- JournalStatusList: Journal Status List
- Journals: Journals
- Notes: Notes
- OfficialReturns: Official Returns
- OutstandingInvoicesOverview: Outstanding Invoices Overview
- OutstandingInvoicesOverviewForJournalTypes: Outstanding Invoices Overview for Journal Types
- PayablesList: Payables List
- PayablesListByAccount: Aging Payables List by Account
- PayablesListByAccountAndAgeGroup: Payables List by Account and Age Group
- PayablesListByAccountAndAgeGroupOverdue: Payables List by Account and Age Group Overdue
- PayablesListByAccountOverdue: Payables List by Account Overdue
- PayablesListByAgeGroup: Payables List by Age Group
- PayablesListByAgeGroupOverdue: Payables List by Age Group Overdue
- PayablesListOverdue: Overdue Payable Invoices
- ProcessReturn: Process Return
- ProfitLossAlternativePeriodCompare: Profit & Loss Alternative Period Compare
- ProfitLossOverview: Profit & Loss Overview
- ProfitLossPeriodCompare: Profit/Loss Period Compare
- ProfitLossPeriodCompareList: Profit & Loss Periods Comparison
- ReceivablesList: Receivables List
- ReceivablesListByAccount: Receivables List by Account
- ReceivablesListByAccountAndAgeGroup: Receivables List by Account and Age Group
- ReceivablesListByAccountAndAgeGroupOverdue: Receivables List by Account and Age Group Overdue
- ReceivablesListByAccountOverdue: Receivables List by Account Overdue
- ReceivablesListByAgeGroup: Receivables List by Age Group
- ReceivablesListByAgeGroupOverdue: Receivables List by Age Group Overdue
- ReceivablesListOverdue: Overdue Receivable Invoices
- ReportingBalance: Reporting Balance
- ReportingBalanceByClassification: Reporting Balance by Classification
- ReportingBalanceByClassificationList: Reporting Balance by Classification List
- Returns: Returns
- RevenueByDebtorForYear: Revenue by Debtor in a Year
- RevenueByDebtorForYearPeriod: Revenue by Debtor in a Year/Period
- RevenueByDebtorList: Revenues by Debtor
- RevenueList: Revenue List
- RevenueListByYear: Revenue List by Year
- RevenueListByYearAndStatus: Revenue List by Year and Status
- RgsAccountSchemes: RGS Account Schemes
- RgsBrugstaatDetailData: Brugstaat Details
ExactOnlineREST.FinancialTransaction
- BankEntries: Bank Entries
- BankEntryLines: Bank Entry Lines
- CashEntries: Cash Entries
- CashEntryLines: Cash Entry Lines
- TransactionLines: Transaction Lines
- TransactionLinesBulk: Transaction Lines (Bulk)
- Transactions: Transactions
ExactOnlineREST.General
- Currencies: Currencies
- Layouts: Layouts
ExactOnlineREST.GeneralJournalEntry
- GeneralJournalEntries: General Journal Entries
- GeneralJournalEntryLines: General Ledger Journal Entry Lines
ExactOnlineREST.Global
- IBANFormats: IBAN Formats
ExactOnlineREST.HRM
- AbsenceRegistrationTransactions: Absence Registration Transactions
- AbsenceRegistrations: Absence Registrations
- CompanyCars: Company Cars
- Costcenters: Cost Centres
- Costunits: Cost Units
- Departments: Departments
- DivisionClassNames: Division Class Names
- DivisionClassValues: Division Class Values
- DivisionClasses: Division Classes
- EmploymentCompanyCars: Employment Company Cars
- HrmDivisionClassifications: HRM Division Classifications
- HrmDivisions: Customer HR Divisions
- JobGroups: Job Groups
- JobTitles: Job titles
- LeaveAbsenceHoursByDay: Leave Absence Hours by Day
- LeaveBuildUpRegistrations: Leave Build-up Registrations
- LeaveRegistrations: Leave Registrations
- ScheduleEntries: Schedule Entries
- Schedules: Schedules
ExactOnlineREST.Incremental
- AccountsIncremental: Accounts (Incremental)
- AddressesIncremental: Addresses (Incremental)
- ContactsIncremental: Contacts (Incremental)
- DocumentAttachmentFilesIncremental: Document Attachmen Files (Incremental)
- DocumentAttachmentsIncremental: Document Attachments (Incremental)
- DocumentsIncremental: Documents (Incremental)
- EmployeesIncremental: Employees (Incremental)
- EmploymentCLAsIncremental: Employment CLAs (Incremental)
- EmploymentContractsIncremental: Employment Contracts (Incremental)
- EmploymentOrganizationsIncremental: Employment Organisations (Incremental)
- EmploymentSalariesIncremental: Employment Salaries (Incremental)
- EmploymentTaxAuthoritiesGeneralIncremental: Employment General Tax Authorities (Incremental)
- EmploymentsIncremental: Employments (Incremental)
- GLAccountsIncremental: General Ledger Accounts (Incremental)
- GLClassificationsIncremental: General Ledger Classifications
- GoodsDeliveriesIncremental: Goods Deliveries
- GoodsDeliveryLinesIncremental: Goods Delivery Lines
- ItemStorageLocationsIncremental: Item Storage Locations
- ItemWarehousesIncremental: Item Warehouses
- ItemsIncremental: Items (Incremental)
- PaymentTermsIncremental: Payment Terms
- PayrollBankAccountsIncremental: Payroll Bank Accounts (Incremental)
- ProjectPlanningsIncremental: Project Plannings
- ProjectWBSIncremental: Project WBS
- ProjectsIncremental: Projects
- PurchaseOrderLinesIncremental: Purchase Order Lines (Incremental)
- QuotationLinesV2Incremental: Quotation Lines
- QuotationsV2Incremental: Quotations
- SalesInvoiceLinesIncremental: Sales Invoice Lines (Incremental)
- SalesItemPricesIncremental: Sales Item Prices
- SalesOrderLinesV2Incremental: Sales Order Lines
- SalesOrdersV2Incremental: Sales Orders
- SalesPriceListVolumeDiscountsIncremental: Sales Price List Volume Discounts
- ScheduleEntriesIncremental: Schedule Entries
- SchedulesIncremental: Schedules
- SerialBatchNumbersIncremental: Serial Batch Numbers
- ShopOrderMaterialPlansIncremental: Shop Order Material Plans (Incremental)
- ShopOrderRoutingStepPlansIncremental: Shop Order Routing Step Plans (Incremental)
- ShopOrdersIncremental: Shop Orders (Incremental)
- StockPositionsIncremental: Stock Positions (Incremental)
- StockSerialBatchNumbersIncremental: Stock Serial Batch Numbers
- StorageLocationStockPositionsIncremental: Storage Location Stock Positions
- SubscriptionLinesIncremental: Subscription Lines
- SubscriptionsIncremental: Subscriptions
- SupplierItemsIncremental: Supplier Items
- TimeCostTransactionsIncremental: Project Time Cost Transactions
- TransactionLinesIncremental: Transaction Lines (Incremental)
ExactOnlineREST.Internal
- CompanyNames: Company Names
ExactOnlineREST.Inventory
- AssemblyBillOfMaterialHeaders: Assembly Bill of Material Headers
- AssemblyBillOfMaterialMaterials: Assembly Bill of Material Materials
- AssemblyOrderPartItems: Assembly Order Part Items
- AssemblyOrders: Assembly Orders
- BatchNumbers: Batch Numbers
- BatchQuantitiesPerLocations: Batch Quantities per Location
- BatchQuantitiesPerWarehouses: Batch Quantities per Warehouse
- FinishAssemblyOrder: Finish Assembly Order
- InventorySettings: Inventory Settings
- ItemWarehousePlanningDetails: Warehouse Planning Details
- ItemWarehouseStorageLocations: Item Warehouse Storage Locations
- ItemWarehouses: Item Warehouses
- ProcessStockCount: Process Stock Count
- ProcessWarehouseTransfer: Process Warehouse Transfer
- SerialNumbers: Serial Numbers
- StockBatchNumbers: Stock Batch Numbers
- StockCountLines: Stock Count Lines
- StockCounts: Stock Counts
- StockSerialNumbers: Stock Serial Numbers
- StorageLocationStockPositions: Storage Location Stock Positions
- StorageLocations: Storage Locations
- WarehouseTransferLines: Warehouse Transfer Lines
- WarehouseTransfers: Warehouse Transfers
- Warehouses: Warehouses
ExactOnlineREST.Licence
- GetAllPartnerKeys: Get All Partner Keys
- MyBankAccounts: My Bank Accounts
- OAuthClients: OAuth Clients
- OAuthClientsWithSecrets: OAuth Clients with Secrets
- OAuthScopes: OAuth Scopes
- PartnerKeys: Partner Keys
- RevokedOAuthPermission: License Revoked OAuth Permissions
ExactOnlineREST.Logistics
- AccountItems: Account Items
- CustomerItems: Customer Items
- Incoterms: INCO Terms
- ItemAssortmentProperties: Item Assortment Properties
- ItemAssortments: Item Assortments
- ItemChargeRelations: Charge Relations
- ItemDetails: Item Details
- ItemDetailsByID: Item Details by ID
- ItemExtraFieldValues: Item Extra Field Values
- ItemExtraFields: itgen_eol_item_extra_fields
- ItemGroups: Item Groups
- ItemVersions: Item Versions
- Items: Items
- ItemsBulk: Items
- ItemsRead: Items
- ReasonCodes: Reason Codes
- ReasonCodesLinkTypes: Reason Code Link Types
- SalesItemPrice: Sales Item Price
- SalesItemPrices: Sales Item Prices
- SalesItemPricesBulk: Sales Item Prices
- SelectionCodes: Selection Codes
- SupplierItems: Supplier Items
- Units: Units
- WarehouseAccountItems: Warehouse Account Items
- WarehouseItems: Warehouse Items
ExactOnlineREST.Mailbox
- DefaultMailbox: Default Mailbox
- MailMessageAttachments: Mail Message Attachments
- MailMessageAttachmentsRead: Mail Message Attachments (Read-only)
- MailMessagesReceived: Received Mail Messages
- MailMessagesReceivedByMailbox: Mail Messages Received by Mailbox
- MailMessagesReceivedUnhandled: Unhandled Received Mail Messages
- MailMessagesSent: Mail Messages Sent
- MailMessagesSentUnhandled: Unhandled Sent Mail Messages
- Mailboxes: Mailboxes
- MailboxesByDivision: Mailboxes by Division
- PreferredMailbox: Preferred Mailbox
- PreferredMailboxForOperation: Preferred Mailbox for Operation
ExactOnlineREST.Manufacturing
- BillOfMaterialMaterials: BOM Materials
- BillOfMaterialRoutings: Bill of Material Routings
- BillOfMaterialVersions: Bill of Material Versions
- ByProductReceipts: Receipts by Product
- ByProductReversals: Reversals by Product
- EmployeeWorkcenters: Employee Workcentres
- ManufacturingSettings: Manufacturing Settings
- MaterialIssues: Material Issues
- MaterialReversals: Processed Cost Analysis Balance Lines per Period
- MfgItemWarehouseStorageLocations: Manufacturing Item Warehouse Storage Locations
- MfgSalesOrderlines: Manufacturing Sales Order Lines
- MfgTimeTransactions: Manufacturing Time Transactions
- OperationResources: Operation Resources
- Operations: Operations
- ProductionAreas: Production Areas
- RecentTimeTransactions: Recent Time Transactions
- RecentTimeTransactionsByEmployee: Recent Time Transactions by Employee
- ShopOrderMaterialPlanDetails: Shop Order Material Plan Details
- ShopOrderMaterialPlans: Shop Order Material Plans
- ShopOrderPriorities: Shop Order Priorities
- ShopOrderReceipts: Shop Order Receipts
- ShopOrderReversals: Shop Order Reversals
- ShopOrderRoutingStepPlans: Shop Order Routing Step Plans
- ShopOrderRoutingStepPlansAvailable: Shop Order Routing Step Plans Available
- ShopOrderRoutingStepPlansAvailableToWork: Shop Order Routing Step Plans Available to Work
- ShopOrders: Shop Orders
- StageForDeliveryReceipts: Stage for Delivery Receipts
- StageForDeliveryReversals: Stage for Delivery Reversals
- StartedTimedTimeTransactions: Started Timed Time Transactions
- StartedTimedTimeTransactionsByEmployee: Started Timed Time Transactions
- SubOrderReceipts: Sub Order Receipts
- SubOrderReversals: Sub Order Reversals
- TimedTimeTransactions: Timed Time Transactions
- Workcenters: Workcentre
ExactOnlineREST.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
ExactOnlineREST.OfficeApp
- MsTeamsMeetingReferences: Microsoft Teams Meeting References
- MsTeamsReferences: MS Teams References
- ReportingUser: Reporting User
ExactOnlineREST.OpeningBalance
- CurrentYearAfterEntry: Current Year After Entry
- CurrentYearProcessed: Current Year Processed
- PreviousYearAfterEntry: Previous Year After Entry
- PreviousYearProcessed: Previous Year Processed
ExactOnlineREST.Payroll
- ActiveEmployments: Active Employments
- Employees: Employees
- EmploymentConditionGroups: Employment Condition Groups
- EmploymentContractFlexPhases: Employment Contract Flex Phases
- EmploymentContracts: Employment Contracts
- EmploymentEndReasons: Employment End Reasons
- EmploymentOrganizations: Employment Organisations
- EmploymentSalaries: Employment Salaries
- EmploymentTaxAuthoritiesGeneral: Employment General Tax Authorities
- Employments: Employments
- FiscaalGemakEmployments: Fiscaal Gemak Employments
- FiscaalGemakPeriodCalculations: Fiscaal Gemak Period Calculations
- PayrollComponents: Payroll Components
- PayrollComponentsByEmploymentConditionGroupCode: Payroll Components by Employment Condition Group Code
- PayrollTransactions: Payroll Transactions
- PayrollTransactionsAll: Payroll Transactions
- PayrollTransactionsByPayrollYear: Payroll Transactions by Payroll Year
- RestoreEmployment: Restore Employment
- ScheduleEntries: Schedule Entries
- TaxEmploymentEndFlexCodes: Tax Employment End Flex Codes
- VariableMutations: Variable Mutations
- WageScaleDetails: Wage Scale Details
- WageScales: Wage Scales
ExactOnlineREST.Project
- CostEntryExpensesByProject: Cost Entry Expenses by Project
- CostEntryRecentAccounts: Cost Entry Recent Accounts
- CostEntryRecentAccountsByProject: Cost Entry Recent Accounts by Project
- CostEntryRecentCostTypes: Cost Entry Recent Cost Types
- CostEntryRecentCostTypesByProject: Cost Entry Recent Cost Types by Project
- CostEntryRecentExpensesByProject: Cost Entry Recent Expenses by Project
- CostEntryRecentHourTypesByAccount: Cost Entry Recent Hour Types by Account
- CostEntryRecentProjects: Cost Entry Recent Projects
- CostEntryRecentProjectsByAccount: Cost Entry Recent Projects by Account
- CostTransactions: Cost Transactions
- CostTypes: Cost Types
- CostTypesByDate: Cost Types by Date
- CostTypesByProjectAndDate: Cost Types by Project and Date
- CostsByDate: Costs by Date
- CostsById: Costs by ID
- EmployeeRestrictionItems: Employee Restriction Items
- EmploymentInternalRates: Employment Internal Rates
- HourCostTypes: Hour Cost Types
- HourEntryActivitiesByProject: Hour Entry Activities by Project
- HourEntryRecentAccounts: Hour Entry Recent Accounts
- HourEntryRecentAccountsByProject: Hour Entry Recent Accounts by Project
- HourEntryRecentActivitiesByProject: Hour Entry Recent Activities by Project
- HourEntryRecentHourTypes: Hour Entry Recent Hour Types
- HourEntryRecentHourTypesByAccount: Hour Entry Recent Hour Types by Account
- HourEntryRecentHourTypesByProject: Hour Entry Recent Hour Types by Project
- HourEntryRecentProjects: Hour Entry Recent Projects
- HourEntryRecentProjectsByAccount: Hour Entry Recent Projects by Account
- HourTypes: Hour Types
- HourTypesByDate: Hour Entry Recent Hour Types by Date
- HourTypesByProjectAndDate: Hour Types by Project and Date
- HoursByDate: Hours by Date
- HoursById: Hours by ID
- InvoiceTerms: Invoice Terms
- PjtTimeEntryAttachments: Time Entry Attachments
- PjtTimeTransactions: Project Time Transactions
- ProjectAccountMutations: Project Account Mutations
- ProjectBudgetTypes: Project Budget Types
- ProjectClassifications: Project Classifications
- ProjectHourBudgets: Project Hour Budgets
- ProjectPlanning: Project Planning
- ProjectPlanningRecurring: Recurring Project Planning
- ProjectProgressReports: Project Progress Reports
- ProjectRestrictionEmployeeItems: Project Restriction Employee Items
- ProjectRestrictionEmployees: Project Restriction Employees
- ProjectRestrictionItems: Project Restriction Items
- ProjectRestrictionRebillings: Project Restriction Rebillings
- ProjectWBS: Project WBS
- ProjectWBSBulk: Project WBS
- ProjectWBSByProject: WBS by Project
- ProjectWBSByProjectAndWBS: WBS by Project and WBS
- Projects: Projects
- RecentCosts: Recent Costs
- RecentCostsByNumberOfWeeks: Recent Costs by Number of Weeks
- RecentCostsByNumberOfWeeksByDate: Date
- RecentHours: Recent Hours
- RecentHoursByNumberOfWeeks: Recent Hours by Number of Weeks
- RecentHoursByNumberOfWeeksByDate: Date
- TimeAndBillingAccountDetails: Time and Billing Account Details
- TimeAndBillingAccountDetailsByID: Time and Billing Account Details by ID
- TimeAndBillingActivitiesAndExpenses: Time and Billing Activities and Expenses
- TimeAndBillingEntryAccounts: Time and Billing Entry Accounts
- TimeAndBillingEntryAccountsByDate: Time and Billing Account Details by Date
- TimeAndBillingEntryAccountsByProjectAndDate: Time and Billing Account Details by Project and Date
- TimeAndBillingEntryProjects: Time and Billing Entry Projects
- TimeAndBillingEntryProjectsByAccountAndDate: Time and Billing Account Details by Account and Date
- TimeAndBillingEntryProjectsByDate: Time and Billing Account Details by Date
- TimeAndBillingEntryRecentAccounts: Time and Billing Entry Recent Accounts
- TimeAndBillingEntryRecentActivitiesAndExpenses: Time and Billing Entry Recent Activities and Expenses
- TimeAndBillingEntryRecentHourCostTypes: Time and Billing Entry Recent Hour Cost Types
- TimeAndBillingEntryRecentProjects: Time and Billing Entry Recent Projects
- TimeAndBillingItemDetails: Time and Billing Item Details
- TimeAndBillingItemDetailsByID: Time and Billing Item Details by ID
- TimeAndBillingProjectDetails: Time and Billing Project Details
- TimeAndBillingProjectDetailsByID: Time and Billing Project Details by ID
- TimeAndBillingRecentProjects: Time and Billing Recent Projects
- TimeCorrections: Time Corrections
- TimeCostEntryFavorites: Time Cost Entry Favorites
- WBSActivities: WBS Activities
- WBSDeliverables: WBS Deliverables
- WBSExpenses: WBS Expenses
ExactOnlineREST.Purchase
- PurchaseInvoiceLines: Purchase Invoice Lines
- PurchaseInvoices: Purchase Invoices
ExactOnlineREST.PurchaseEntry
- Approval: Approve Purchase Entry
- PurchaseEntries: Purchase Entries
- PurchaseEntryLines: Purchase Entry Lines
ExactOnlineREST.PurchaseOrder
- GoodsReceiptLineBatchNumbers: Goods Receipt Line Batch Numbers
- GoodsReceiptLineSerialNumbers: Goods Receipt Line Serial Numbers
- GoodsReceiptLines: Goods Receipt Lines
- GoodsReceipts: Goods Receipts
- PurchaseOrderBatchQuantitiesPerLocations: Purchase Order Batch Quantities per Locations
- PurchaseOrderBatchQuantitiesPerWarehouses: Purchase Order Batch Quantities per Warehouses
- PurchaseOrderLines: Purchase Order Lines
- PurchaseOrderStockBatchNumbers: Purchase Order Stock Batch Numbers
- PurchaseOrderStockSerialNumbers: Purchase Order Stock Serial Numbers
- PurchaseOrders: Purchase Orders
- PurchasePlanningShopOrderMaterialPlans: Purchase Planning Shop Order Material Plans
- PurchasePlanningShopOrderRoutingStepPlans: Purchase Planning Shop Order Routing Step Plans
- PurchaseReturnLineBatchNumbers: Purchase Return Line Batch Numbers
- PurchaseReturnLineSerialNumbers: Purchase Return Line Serial Numbers
- PurchaseReturnLines: Purchase Return Lines
- PurchaseReturns: Purchase Returns
ExactOnlineREST.RGS
- RGS10CodeRelations: RGS 1.0 Code Relations
- RGS11CodeRelations: RGS 1.1 Code Relations
- RGS20CodeRelations: RGS 2.0 Code Relations
- RGS30CodeRelations: RGS 3.0 Code Relations
ExactOnlineREST.Sales
- OrderCharges: Order Charges
- SalesChannels: Sales Channels
- SalesPriceListLinkedAccounts: Sales Price List Linked Accounts
- SalesPriceListPeriods: Sales Price List Periods
- SalesPriceListVolumeDiscounts: Sales Price List Volume Discounts
- SalesPriceLists: Sales Price Lists
- ShippingMethods: Shipping Methods
ExactOnlineREST.SalesEntry
- CreditedSalesInvoices: Credited Sales Invoices
- SalesEntries: Sales Entries
- SalesEntryLines: Sales Entry Lines
ExactOnlineREST.SalesInvoice
- InvoiceSalesOrders: Invoice Sales Orders
- Layouts: Layouts
- PrintedSalesInvoices: Printed Sales Invoices
- SalesInvoiceLines: Sales Invoice Lines
- SalesInvoiceLinesBulk: Sales Invoice Lines
- SalesInvoiceOrderChargeLines: Sales Invoice Order Charge Lines
- SalesInvoices: Sales Invoices
- SalesInvoicesBulk: Sales Invoices
- SalesInvoicesExploded: Sales Invoices (Exploded)
- SalesOrderID: Sales Order ID
ExactOnlineREST.SalesOrder
- CompleteSalesOrder: Complete Sales Order
- CompleteSalesOrderLine: Complete Sales Order Line
- DigitalOrderPickingLines: Digital Order Picking Lines
- DigitalOrderPickingLocations: Digital Order Picking Locations
- DigitalOrderPickings: Digital Order Pickings
- DropShipmentLines: Drop-shipment Lines
- DropShipments: Drop-shipments
- GoodsDeliveries: Goods Deliveries
- GoodsDeliveriesBulk: Goods Deliveries
- GoodsDeliveryLineBatchNumbers: Goods Delivery Line Batch Numbers
- GoodsDeliveryLineSerialNumbers: Goods Delivery Line Serial Numbers
- GoodsDeliveryLines: Goods Delivery Lines
- GoodsDeliveryLinesBulk: Goods Delivery Lines
- PlannedSalesReturnLines: Planned Sales Return Lines
- PlannedSalesReturns: Planned Sales Returns
- PrintedSalesOrders: Printed Sales Orders
- SalesOrderBatchQuantitiesPerLocations: Sales Order Batch Quantities per Location
- SalesOrderBatchQuantitiesPerWarehouses: Sales Order Batch Quantities per Warehouse
- SalesOrderLayouts: Sales Order Layouts
- SalesOrderLines: Sales Order Lines
- SalesOrderLinesBulk: Sales Order Lines (Bulk)
- SalesOrderOrderChargeLines: Sales Order Charge Lines
- SalesOrderStockBatchNumbers: Sales Order Stock Batch Numbers
- SalesOrderStockBatchNumbersBulk: Stock Batch Numbers
- SalesOrderStockSerialNumbers: Sales Order Stock Serial Numbers
- SalesOrderStockSerialNumbersBulk: Stock Serial Numbers
- SalesOrderStorageLocationsBulk: Storage Locations
- SalesOrders: Sales Orders
- SalesOrdersBulk: Sales Orders
- SalesOrdersExploded: Sales Orders (Exploded Structure)
- WarehousesBulk: Warehouses
ExactOnlineREST.Subscription
- SubscriptionLineTypes: Subscription Line Types
- SubscriptionLines: Subscription Lines
- SubscriptionReasonCodes: Subscription Reason Codes
- SubscriptionRestrictionEmployees: Subscription Restriction Employees
- SubscriptionRestrictionItems: Subscription Restriction Items
- SubscriptionTypes: Subscription Types
- Subscriptions: Subscriptions
ExactOnlineREST.Sync
- SyncAccounts: Accounts
- SyncAddresses: Addresses
- SyncBankAccounts: Bank Accounts
- SyncBillOfMaterialMaterials: BOM Materials
- SyncBillOfMaterialVersions: Bill of Material Versions
- SyncContacts: Contacts
- SyncDeductibilityPercentages: Deductibility Percentages
- SyncDeleted: Deleted Rows
- SyncDocumentAttachments: Document Attachments
- SyncDocuments: Documents
- SyncEmployees: Employees
- SyncEmploymentCLAs: Employment Collective Labour Agreements
- SyncEmploymentContracts: Employment Contracts
- SyncEmploymentOrganizationCostCenters: Employment Organisation Cost Centers
- SyncEmploymentOrganizations: Employment Organisations
- SyncEmploymentSalaries: Employment Salaries
- SyncEmploymentTaxAuthoritiesGeneral: Employment General Tax Authorities
- SyncEmployments: Employments
- SyncGLAccounts: General Ledger Accounts
- SyncGLClassifications: General Ledger Classifications
- SyncGoodsDeliveries: Goods Deliveries
- SyncGoodsDeliveryLines: Goods Delivery Lines
- SyncItemStorageLocations: Item Storage Locations
- SyncItemWarehouses: Item Warehouses
- SyncItems: Items
- SyncLeaveAbsenceHoursByDay: Leave Absence Hours by Day
- SyncMaterialIssues: Material Issues
- SyncPaymentTerms: Payment Terms
- SyncPayrollBankAccounts: Payroll Bank Accounts
- SyncProjectPlannings: Project Plannings
- SyncProjectWBS: Project WBS
- SyncProjects: Projects
- SyncPurchaseItemPrices: Purchase Item Prices
- SyncPurchaseOrderLines: Purchase Orders
- SyncQuotationLinesV2: Quotation Lines
- SyncQuotationsV2: Quotations
- SyncSalesInvoices: Sales Invoices
- SyncSalesItemPrices: Sales Item Prices
- SyncSalesOrderLinesV2: Sales Order Lines
- SyncSalesOrdersV2: Sales Orders
- SyncSalesPriceListVolumeDiscounts: Sales Price List Volume Discounts
- SyncScheduleEntries: Schedule Entries
- SyncSchedules: Schedules
- SyncSerialBatchNumbers: Serial Batch Numbers
- SyncShopOrderMaterialPlans: Shop Order Material Plans
- SyncShopOrderPurchasePlanning: Shop Order Purchase Planning
- SyncShopOrderRoutingStepPlans: Shop Order Routing Step Plans
- SyncShopOrderSubOrders: Shop Order Sub Orders
- SyncShopOrders: Shop Orders
- SyncStockBatchNumbers: Stock Batch Numbers
- SyncStockPositions: Stock Positions
- SyncStockSerialBatchNumbers: Stock Serial Batch Numbers
- SyncStockSerialNumbers: Stock Serial Numbers
- SyncStorageLocationStockPositions: Storage Location Stock Positions
- SyncSubscriptionLines: Subscription Lines
- SyncSubscriptions: Subscriptions
- SyncSupplierItems: Supplier Items
- SyncTimeCostTransactions: Project Time Cost Transactions
- SyncTransactionLines: Transaction Lines (Synchronized)
ExactOnlineREST.System
- AccountantInfo: Accountant Information
- AllDivisions: All Divisions
- AvailableFeatures: Available Features
- ExactInfo: Exact Information
- GetCurrentDivision: Get Current Division
- GetMostRecentlyUsedDivisions: Most Recently Used Divisions
- GetMostRecentlyUsedLicensedDivisions: Get Most Recently Used Licensed Divisions
- Me: Me
- SetCurrentDivision: Set Current Division
- Settings: Settings
- SmartphoneMenu: Smartphone Menu
- SmartphoneRights: Smartphone Privileges
- SystemDivisionClassifications: System Division Classifications
- SystemDivisions: System Divisions
- UserSettings: User Settings
ExactOnlineREST.Users
- UnlinkAllRoles: Unlink All Roles
- UserHasRights: User Has Rights
- UserRoles: User Roles
- UserRolesPerDivision: User Roles per Division
- Users: Users
- UsersByDivision: Users by Division
ExactOnlineREST.VAT
- TaxComponentRates: Tax Component Rates
- TaxScheduleComponents: Tax Schedule Components
- TaxSchedules: Tax Schedules
- VATCodes: VAT Codes
- VatPercentages: VAT Percentages
ExactOnlineREST.Views
- APOutstandingItemsPerFinancialPeriodUltimo: Open Purchase Invoices per Ultimo Financial Period
- APOutstandingItemsPerFinancialYearUltimo: Open Purchase Invoices per Ultimo Financial Year
- AROutstandingItemsPerFinancialPeriodUltimo: Open Sales Invoices per Ultimo Financial Period
- AROutstandingItemsPerFinancialYearUltimo: Open Sales Invoices per Ultimo Financial Year
- CostTransactionsIncremental: Cost Transactions
- FinancialYearsExtended: Financial Years (Extended)
- OutstandingInvoicesPerJournalType: Outstanding Invoices per Journal Type
- PjtTimeTransactionsIncremental: Project Time Transactions
- PurchaseOrdersIncremental: Purchase Orders (Incremental)
- RequestTablesWithoutRights: Tables Without Rights
- SalesInvoicesIncremental: Sales Invoices (Incremental)
- SystemDivisionsToQuery: Exact Online Companies to Query
- TransactionsIncremental: Transactions (Incremental)
- UserRoleProperties: User Role Properties
ExactOnlineREST.Webhooks
- WebhookSubscriptions: Webhook Subscriptions
ExactOnlineREST.Workflow
- CustomerCooperations: Customer Cooperations
- RequestAttachments: Request Attachments
ExactOnlineXML.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
ExactOnlineXML.XML
- APOutstandingItems: Account Payables Outstanding Items
- APOutstandingItemsEx: Account Payables Outstanding Items Extended
- APs: Account Payables
- AROutstandingItems: Account Receivables Outstanding Items
- AROutstandingItemsEx: Account Receivables Outstanding Items Extended
- ARs: Account Receivables
- AccountAddresses: Account Addresses
- AccountAddressesEx: Account Addresses
- AccountBankAccounts: Account Bank Accounts
- AccountBankAccountsEx: Account Bank Accounts
- AccountClassifications: Account Classifications
- AccountClassificationsEx: Account Classifications
- AccountContacts: Account Contacts
- AccountContactsEx: Account Contacts
- AccountDDMandates: Account DD Mandates
- AccountDDMandatesEx: Account DD Mandates
- AccountVATPurchaseBoxes: Account VAT Purchase Links
- Accounts: Accounts
- AccountsEx: Accounts
- ActivitySectors: Activity Sectors
- ActivitySectorsEx: Activity Sectors
- AdministrationTypes: Administration Types
- Agencies: Agencies
- AllAdministrationAssignedTypes: All Administration Assigned Types
- AllAdministrationClassifications: All Administrations
- AllAdministrationCustomers: Administration Customers
- AllAdministrations: Administrations
- AllUserAdministrations: All User Administrations
- AllUsers: Users across All Customers
- AllocationRules: Allocation Rules
- AllocationRulesEx: Allocation Rules
- AssemblyOrders: Assembly Orders
- AssemblyOrdersEx: Assembly Orders
- AssetGroups: Asset Groups
- AssetGroupsEx: Asset Groups
- Assets: Assets
- BalanceLines: Balance Lines
- BalanceLinesCostAnalysis: Balance Lines Cost Analysis
- BalanceLinesCostAnalysisEx: Balance Lines Cost Analysis
- BalanceLinesCostAnalysisProcessed: Processed Cost Analysis Balance Lines
- BalanceLinesEx: Balance Lines
- BalanceLinesPerPeriod: Balance Lines per Period
- BalanceLinesPerPeriodCostAnalysis: Balance Lines per Period Cost Analysis
- BalanceLinesPerPeriodCostAnalysisEx: Balance Lines per Period Cost Analysis
- BalanceLinesPerPeriodCostAnalysisProcessed: Processed Cost Analysis Balance Lines per Period
- BalanceLinesPerPeriodEx: Balance Lines per Period
- BalanceLinesPerPeriodProcessed: Processed Balance Lines per Period
- BalanceLinesProcessed: Processed Balance Lines
- Balances: Balances
- BalancesEx: Balances
- BalancesProcessed: Processed Balances
- BankLinks: Bank Links
- BankLinksEx: Bank Links
- BillOfMaterialItemDetails: Bill of Material Item Details
- BillOfMaterialItemDetailsEx: Bill of Material Item Details
- BillOfMaterials: Bill of Materials
- BillOfMaterialsEx: Bill of Materials
- BudgetLines: Budget Lines
- BudgetLinesEx: Budget Lines
- BudgetLinesPerPeriod: Budget Lines per Period
- BudgetLinesPerPeriodEx: Budget Lines per Period
- BudgetScenarios: Budget Scenarios
- Budgets: Budgets
- BudgetsEx: Budgets
- BusinessTypes: Business Types
- BusinessTypesEx: Business Types
- CompanySizes: Company Sizes
- CompanySizesEx: Company Sizes
- CostTransactionDocumentAttachments: Cost Transaction Document Attachments
- CostTransactionDocumentAttachmentsEx: Cost Transaction Document Attachments
- CostTransactions: Cost Transactions
- CostTransactionsEx: Cost Transactions
- Costcenters: Cost Centres
- CostcentersEx: Cost Centres
- Costunits: Cost Units
- CostunitsEx: Cost Units
- CreditManagementScenarios: Credit Management Scenarios
- CreditManagementStatuses: Credit Management Statuses
- DDMandates: Mandates
- DDMandatesEx: Mandates
- Deliveries: Deliveries
- DeliveriesEx: Deliveries
- DeliveryLines: Delivery Lines
- DeliveryLinesEx: Delivery Lines
- DeliverySplitLineStockTransactionLocations: Delivery Split Line Stock Transaction Locations
- DeliverySplitLineStockTransactionLocationsEx: Delivery Split Line Stock Transaction Locations
- DeliverySplitLines: Delivery Split Lines
- DeliverySplitLinesEx: Delivery Split Lines
- Departments: Departments
- DepartmentsEx: Departments
- DepositDetails: Deposit Details
- Deposits: Deposits
- DepreciationMethods: Depreciation Methods
- DepreciationMethodsEx: Depreciation Methods
- DocumentAttachments: Document Attachments
- DocumentAttachmentsEx: Document Attachments
- DocumentImages: Document Images
- DocumentImagesEx: Document Images
- Documents: Documents
- DocumentsEx: Documents
- EmployeeWorkcenters: Employee Work Centres
- Employees: Employees
- EmployeesEx: Employees
- EmploymentAgenciesTax: Employment Agencies Tax
- EmploymentAgenciesTaxEx: Employment Agencies Tax
- EmploymentCLAs: Employment Class
- EmploymentCLAsEx: Employment Class
- EmploymentContracts: Employment Contracts
- EmploymentContractsEx: Employment Contracts
- EmploymentOrganizations: Employment Organisations
- EmploymentOrganizationsEx: Employment Organisations
- EmploymentSalaries: Employment Salaries
- EmploymentSalariesEx: Employment Salaries
- Employments: Employments
- EmploymentsEx: Employments
- EntryTemplateLinks: Entry Template Links
- EntryTemplateTransactions: Entry Template Transactions
- EntryTemplates: Entry Templates
- ExchangeRates: Exchange Rates
- ExchangeRatesEx: Exchange Rates
- ExtraFieldDefinitions: Extra Field Definitions
- ExtraFieldDefinitionsEx: Extra Field Definitions
- FinPeriods: Financial Periods
- FinPeriodsEx: Financial Periods
- FinYears: Financial Years
- FinYearsEx: Financial Years
- FinishedAssemblies: Finished Assemblies
- FinishedAssembliesEx: Finished Assemblies
- FinishedAssemblySerialNumberPartSerialNumbers: Finished Assembly Serial Number Part Serial Numbers
- FinishedAssemblySerialNumberParts: Finished Assembly Serial Number Parts
- FinishedAssemblySerialNumbers: Finished Assembly Serial Numbers
- GLAccountCategories: General Ledger Account Categories
- GLAccountCategoriesEx: General Ledger Account Categories
- GLAccountClassificationRelations: GL Account Classification Relations
- GLAccountClassificationSchemeTranslations: General Ledger Account Classification Link Scheme Classifications Translations
- GLAccountClassificationSchemes: General Ledger Account Classification Link Schemes
- GLAccountClassificationSchemesEx: General Ledger Account Classification Link Schemes
- GLAccountClassificationTranslationsLevel1: General Ledger Account Classification Translations Level 1
- GLAccountClassificationTranslationsLevel10: General Ledger Account Classification Translations (Level 10)
- GLAccountClassificationTranslationsLevel2: General Ledger Account Classification Translations Level 2
- GLAccountClassificationTranslationsLevel3: General Ledger Account Classification Translations Level 3
- GLAccountClassificationTranslationsLevel4: General Ledger Account Classification Translations Level 4
- GLAccountClassificationTranslationsLevel5: General Ledger Account Classification Translations Level 5
- GLAccountClassificationTranslationsLevel6: General Ledger Account Classification Translations Level 6
- GLAccountClassificationTranslationsLevel7: General Ledger Account Classification Translations Level 7
- GLAccountClassificationTranslationsLevel8: General Ledger Account Classification Translations Level 8
- GLAccountClassificationTranslationsLevel9: General Ledger Account Classification Translations (Level 9)
- GLAccountClassifications: General Ledger Account Classification Links
- GLAccountClassificationsEx: General Ledger Account Classification Links
- GLAccountClassificationsLevel1: General Ledger Account Classifications Level 1
- GLAccountClassificationsLevel10: General Ledger Account Classifications (Level 10)
- GLAccountClassificationsLevel2: General Ledger Account Classifications Level 2
- GLAccountClassificationsLevel3: General Ledger Account Classifications Level 3
- GLAccountClassificationsLevel4: General Ledger Account Classifications Level 4
- GLAccountClassificationsLevel5: General Ledger Account Classifications Level 5
- GLAccountClassificationsLevel6: General Ledger Account Classifications Level 6
- GLAccountClassificationsLevel7: General Ledger Account Classifications Level 7
- GLAccountClassificationsLevel8: General Ledger Account Classifications Level 8
- GLAccountClassificationsLevel9: General Ledger Account Classifications (Level 9)
- GLAccounts: General Ledger Accounts
- GLAccountsEx: General Ledger Accounts
- GLClassificationMemberAccounts: GL Classification Member Accounts
- GLClassificationMemberClassifications: GL Classification Member Classifications
- GLSchemes: General Ledger Schemes
- GLTransactionDocumentAttachments: General Ledger Transaction Document Attachments
- GLTransactionDocumentAttachmentsEx: General Ledger Transaction Document Attachments
- GLTransactionLines: General Ledger Transaction Lines
- GLTransactionLinesEx: General Ledger Transaction Lines
- GLTransactions: General Ledger Transactions
- GLTransactionsEx: General Ledger Transactions
- HRMSubscriptions: HRM Subscriptions
- Indicators: Indicators
- InvoiceDocumentAttachments: Invoice Document Attachments
- InvoiceDocumentAttachmentsEx: Invoice Document Attachments
- InvoiceLines: Invoice Lines
- InvoiceLinesEx: Invoice Lines
- Invoices: Invoice
- InvoicesEx: Invoice
- ItemAccounts: Item Suppliers
- ItemAccountsEx: Item Suppliers
- ItemAssortmentValues: Item Assortment Values
- ItemAssortmentValuesEx: Item Assortment Values
- ItemPrices: Item Prices
- ItemPricesEx: Item Prices
- ItemSalesPriceVATBoxLinks: Item Sales Price VAT Box Links
- ItemTranslations: Item Translations
- ItemWarehouses: Item Warehouses
- ItemWarehousesEx: Item Warehouses
- Items: Items
- ItemsEx: Items
- JobGroups: Job Groups
- JobGroupsEx: Job Groups
- JobTitles: Job titles
- JobTitlesEx: Job titles
- Journals: Journals
- JournalsEx: Journals
- LeadPurposes: Lead Purposes
- LeadPurposesEx: Lead Purposes
- LeadRatings: Lead Ratings
- LeadRatingsEx: Lead Ratings
- LeadSources: Lead Sources
- LeadSourcesEx: Lead Sources
- LeadStages: Lead Stages
- LeadStagesEx: Lead Stages
- Leads: Leads
- ManufacturedBillOfMaterialItemDetails: Manufactured BOM Item Details
- ManufacturedBillOfMaterialItemDetailsEx: Manufactured BOM Item Details
- ManufacturedBillOfMaterialRoutingDetails: Manufactured BOM Routing Details
- ManufacturedBillOfMaterialRoutingDetailsEx: Manufactured BOM Routing Details
- ManufacturedBillOfMaterials: Manufactured Bill of Materials
- ManufacturedBillOfMaterialsEx: Manufactured Bill of Materials
- ManufacturingProjects: Manufacturing Project
- ManufacturingTimeTransactions: Manufacturing Time Transactions
- ManufacturingTimeTransactionsEx: Manufacturing Time Transactions
- MatchSetLines: Match Set Lines
- MatchSetLinesEx: Match Set Lines
- MatchSets: Match Sets
- MatchSetsEx: Match Sets
- MaterialIssueSplitIssueLines: Material Issue Split Issue Lines
- MaterialIssueSplitIssueLinesEx: Material Issue Split Issue Lines
- MaterialIssues: Material Issues
- MaterialIssuesEx: Material Issues
- MaterialPurchaseOrders: Material Purchase Orders
- NationalHolidays: National Holidays
- NationalHolidaysEx: National Holidays
- OperationResources: Operation Resources
- OperationResourcesEx: Operation Resources
- Operations: Operations
- OperationsEx: Operations
- Opportunities: Opportunities
- OpportunitiesEx: Opportunities
- OpportunityStages: Opportunity Stages
- OpportunityStagesEx: Opportunity Stages
- OwnerAdministrationAssignedTypes: Current Customer Administration Assigned Types
- OwnerAdministrationClassifications: Current Customer Administration Classifications
- OwnerAdministrations: Current Customer Administrations
- OwnerUserAdministrations: User Administrations
- OwnerUsers: Users
- OwnerUsersEx: Users
- PaymentConditions: Payment Conditions
- PaymentConditionsEx: Payment Conditions
- PayrollComponentGroups: Payroll component groups
- PayrollComponentInputs: Payroll Component Inputs
- PayrollComponentOutputs: Payroll Component Outputs
- PayrollComponentSubtotalLinks: Payroll Component Sub Total Links
- PayrollComponents: Payroll Components
- PayrollEntries: Payroll Entries
- PayrollEntriesEx: Payroll Entries
- PayrollGLLinks: Payroll General Ledger Links
- PayrollPeriods: Payroll Periods
- PayrollYears: Payroll Years
- ProductionAreas: Production Areas
- ProductionAreasEx: Production Areas
- ProjectPlanningLines: Project Planning Lines
- ProjectPlanningLinesEx: Project Planning Lines
- ProjectPlanningLinesExtended: Project Planning Lines Extended
- Projects: Projects
- ProjectsEx: Projects
- PurchaseOrderDocumentAttachments: Purchase Order Document Attachments
- PurchaseOrderDocumentAttachmentsEx: Purchase Order Document Attachments
- PurchaseOrderLines: Purchase Order Lines
- PurchaseOrderLinesEx: Purchase Order Lines
- PurchaseOrders: Purchase Orders
- PurchaseOrdersEx: Purchase Orders
- QuotationLines: Quotation Lines
- QuotationLinesEx: Quotation Lines
- Quotations: Quotations
- QuotationsEx: Quotations
- ReasonCodes: Reason Codes
- ReasonCodesEx: Reason Codes
- ReceiptLines: Receipt Lines
- ReceiptLinesEx: Receipt Lines
- ReceiptSplitLineStockTransactionLocations: Receipt Split Line Stock Transaction Locations
- ReceiptSplitLines: Receipt Split Lines
- ReceiptSplitLinesEx: Receipt Split Lines
- Receipts: Receipts
- ReceiptsEx: Receipts
- SalesForecastItemDetailsEx: Sales Forecast Item Details
- SalesForecastItemsEx: Sales Forecast Items
- SalesForecastsEx: Sales Forecasts
- SalesOrderDocumentAttachments: Sales Order Document Attachments
- SalesOrderDocumentAttachmentsEx: Sales Order Document Attachments
- SalesOrderLines: Sales Order Lines
- SalesOrderLinesEx: Sales Order Lines
- SalesOrders: Sales Orders
- SalesOrdersEx: Sales Orders
- SalesTypes: Sales Types
- SalesTypesEx: Sales Types
- Settings: Settings
- ShippingMethods: Shipping Methods
- ShippingMethodsEx: Shipping Methods
- ShopOrderMaterialPlans: Shop Order Material Plans
- ShopOrderMaterialPlansEx: Shop Order Material Plans
- ShopOrderRoutingPlans: Shop Order Routing Plans
- ShopOrderRoutingPlansEx: Shop Order Routing Plans
- ShopOrderStockReceiptSplitByProducts: Shop Order Stock Receipt Split by Products
- ShopOrderStockReceiptSplitByProductsEx: Shop Order Stock Receipt Split by Products
- ShopOrderStockReceiptSplitShopOrderStocks: Shop Order Stock Receipt Split Shop Order Stocks
- ShopOrderStockReceiptSplitShopOrderStocksEx: Shop Order Stock Receipt Split Shop Order Stocks
- ShopOrderStockReceipts: Shop Orders Stock Receipts
- ShopOrderStockReceiptsEx: Shop Orders Stock Receipts
- ShopOrders: Shop Orders
- ShopOrdersEx: Shop Orders
- StockCountLines: Stock Count Lines
- StockCountLinesEx: Stock Count Lines
- StockCounts: Stock Counts
- StockCountsEx: Stock Counts
- StockPositions: Stock Positions
- StockPositionsEx: Stock Positions
- Students: Students
- SubcontractPurchaseOrders: Subcontract Purchase Orders
- SubscriptionEmployees: Subscription Employees
- SubscriptionEmployeesEx: Subscription Employees
- SubscriptionItems: Subscription Items
- SubscriptionItemsEx: Subscription Items
- SubscriptionLines: Subscription Lines
- SubscriptionLinesEx: Subscription Lines
- SubscriptionTypes: Subscription Types
- SubscriptionTypesEx: Subscription Types
- Subscriptions: Subscriptions
- SubscriptionsEx: Subscriptions
- TaxComponents: Tax Components
- TaxSchedules: Tax Schedules
- TimeTransactionDocumentAttachments: Time Transaction Document Attachments
- TimeTransactionDocumentAttachmentsEx: Time Transaction Document Attachments
- TimeTransactions: Time Transactions
- TimeTransactionsEx: Time Transactions
- TimeTransactionsExtended: Time Transactions Extended
- Titles: Titles
- TitlesEx: Titles
- TrackingNumbers: Tracking Numbers
- UploadXMLTopicFragments: Update XML Topic Fragments
- UploadXMLTopics: Upload XML Topics
- UserProfiles: User Profiles
- UserTypes: User Types
- VATBoxLinks: VAT Box Links
- VATBoxLinksEx: VAT Box Links
- VATPercentages: VAT Percentages
- VATPercentagesEx: VAT Percentages
- VATs: VAT Types
- VATsEx: VAT Types
- WBSActivitiesLevel1: WBS Activities Level 1
- WBSActivitiesLevel2: WBS Activities Level 2
- WBSActivitiesLevel3: WBS Activities Level 3
- WBSActivitiesLevel4: WBS Activities Level 4
- WBSActivitiesLevel5: WBS Activities Level 5
- WBSActivitiesLevel6: WBS Activities Level 6
- WBSActivitiesLevel7: WBS Activities Level 7
- WBSActivitiesLevel8: WBS Activities Level 8
- WBSDeliverablesLevel1: Work Breakdown Structures Level 1
- WBSDeliverablesLevel2: Work Breakdown Structures Level 2
- WBSDeliverablesLevel3: Work Breakdown Structures Level 3
- WBSDeliverablesLevel4: Work Breakdown Structures Level 3
- WBSDeliverablesLevel5: Work Breakdown Structures Level 3
- WBSDeliverablesLevel6: Work Breakdown Structures Level 3
- WBSDeliverablesLevel7: Work Breakdown Structures Level 3
- WBSDeliverablesLevel8: Work Breakdown Structures Level 3
- WBSExpensesLevel1: WBS Expenses Level 1
- WBSExpensesLevel2: WBS Expenses Level 2
- WBSExpensesLevel3: WBS Expenses Level 3
- WBSExpensesLevel4: WBS Expenses Level 4
- WBSExpensesLevel5: WBS Expenses Level 5
- WBSExpensesLevel6: WBS Expenses Level 6
- WBSExpensesLevel7: WBS Expenses Level 7
- WBSExpensesLevel8: WBS Expenses Level 8
- WBSTemplates: WBS Templates
- WageScales: Wage Scales
- WarehouseItems: Warehouse Items
- WarehouseItemsEx: Warehouse Items
- WarehouseStorageLocations: Warehouse Storage Locations
- WarehouseTransferLines: Warehouse Transfer Lines
- WarehouseTransferLinesEx: Warehouse Transfer Lines
- WarehouseTransfers: Warehouse Transfers
- WarehouseTransfersEx: Warehouse Transfers
- Warehouses: Warehouses
- WarehousesEx: Warehouses
- WebShopSalesOrderDeliveries: Web Shop Sales Order Deliveries
- WebShopSalesOrderDeliveriesEx: Web Shop Sales Order Deliveries
- WebShopSalesOrderDeliveryLineItems: Web Shop Sales Order Delivery Line Items
- WebShopSalesOrderDeliveryLineItemsEx: Web Shop Sales Order Delivery Line Items
- WebShopSalesOrders: Webshop Sales Orders
- WebShopSalesOrdersEx: Webshop Sales Orders
- WorkBreakdownStructures: Work Breakdown Structures
- WorkCenters: Work Centres
- WorkCentersEx: Work Centres
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 :