invantive documentation
Invantive Support ForumsLog In / Sign Up

Release notes of Exact Online

Driver Release Note - Cloud

Exact Online driver 27.0, from 26.0

Build Date Description
26.0.4 22-03-2026 first build of release 26.0
27.0.93 10-11-2026 latest build of release 27.0 at the time of writing

Data models compared: 26.0.340-PROD+6295 and 27.0.6-PROD+6293.

The older end is the first build of release 26.0, not its last, because later builds of 26.0 received ports of changes made for 27.0. The data model of a release is the model that a later build of the same release generated.

  • 310 changes
  • 4 can break a statement
  • 0 groups not available

What Changed, by Group

Every change is in one group: the group answers the question that you ask before you upgrade.

  • Data model
    • 265
    • 1 can break a statement
    • Do my statements and views still work?
  • Provider attributes
    • 2
    • Do I have to change my connection string, provider file or settings?
  • Capabilities
    • 0
    • What can the driver do with a table?
  • Performance
    • 9
    • Is it faster, and does it call the platform less?
  • Bug fixes
    • 19
    • Is the defect that I met repaired?
  • Enhancements
    • 10
    • 2 can break a statement
    • What can I do now that I could not?
  • Log-on and platform
    • 5
    • 1 can break a statement
    • Do I have to log on again, or change something because of the platform?

Download Changes as CSV | Data Model of Exact Online

Before You Upgrade

These changes can stop an existing statement, view, connection string or script from working:

Top 25 Changes

Changes that can break a statement first, then by importance. Columns are summarised per table in the data model.

  1. Table ExactOnlineREST.CRM.Budgets is removed
    • Data model
    • Breaks an existing statement or script.
  2. Update the Exact Online XML tables to the XML schema of August 2026
    • Enhancements
    • Breaks an existing statement or script.
  3. Exclude companies in countries with an ICC warrant and outside the service area
    • Log-on and platform
    • Breaks an existing statement or script.
  4. Report durations in milliseconds with decimals
    • Enhancements
    • Breaks an existing statement or script.
  5. Incremental tables are read faster and with less memory
    • Performance
    • Importance 4 of 5.
  6. Incremental refresh no longer reloads a heavily changed table on every run
    • Bug fixes
    • Importance 4 of 5.
  7. Incremental tables can be loaded in the background before they are asked for
    • Performance
    • Importance 3 of 5.
  8. Less memory is used when reading Exact Online answers
    • Performance
    • Importance 3 of 5.
  9. Open the XML data model faster with a predefined list of fields
    • Performance
    • Importance 3 of 5.
  10. Row limits, counts and grouping are sent to Exact Online
    • Performance
    • Importance 3 of 5.
  11. A rejected stored copy of an incremental table is rebuilt instead of reused
    • Bug fixes
    • Importance 3 of 5.
  12. A stopped run no longer leaves a torn copy of an incremental table
    • Bug fixes
    • Importance 3 of 5.
  13. Developer accounts are no longer refused as accountancy subscriptions
    • Bug fixes
    • Importance 3 of 5.
  14. Handle log-on errors of the XML API when they are wrapped in another error
    • Bug fixes
    • Importance 3 of 5.
  15. Writes through the XML API are not repeated after an HTTP 500
    • Bug fixes
    • Importance 3 of 5.
  16. A view lists the tables on which Exact Online refused access
    • Enhancements
    • Importance 3 of 5.
  17. Statements and synchronisations can be cancelled promptly
    • Enhancements
    • Importance 3 of 5.
  18. Web requests use the new HTTP client
    • Log-on and platform
    • Importance 3 of 5.
  19. 46,289 more columns are added to ExactOnlineXML.XML.WBSExpensesLevel2
    • Data model
    • Importance 3 of 5.
  20. Package eol_invoice is added
    • Data model
    • Importance 3 of 5.
  21. Package eol_premium is added
    • Data model
    • Importance 3 of 5.
  22. Attribute exact-online-url: allow set from log on changes
    • Provider attributes
    • Importance 3 of 5.
  23. Do not rebuild the list of companies on a USE statement
    • Performance
    • Importance 2 of 5.
  24. Inserts run on dedicated threads, one partition at a time
    • Performance
    • Importance 2 of 5.
  25. Use less memory and fewer reads for large cached JSON responses
    • Performance
    • Importance 2 of 5.

Data model

Do my statements and views still work? Tables, views, table functions, columns, parameters, keys, code values, packages and procedures that appear, disappear, are renamed or change type.

  • 265 changes
  • model files

Tables, Views and Table Functions

Table ExactOnlineREST.CRM.Budgets is removed

A statement that reads ExactOnlineREST.CRM.Budgets fails after the upgrade. It had 191 columns. The removed table used the column list of accounts on the budget service and probably did not work as intended. Use the Budgets table of the Budget schema.

What to Do

Check statements, views and scripts that use it before the upgrade.

  • can break a statement
  • importance 5

Columns

254 added, 0 removed, 6 changed, in 12 tables.

ExactOnlineDataDictionary.DataDictionary.RowCounts: 0 added, 0 removed, 2 changed

  • ~ DURATION_MS (database_data_type: int64 → double)
  • ~ DURATION_MS (dotnet_data_type: int64 → double)

ExactOnlineREST.Native.NATIVEPLATFORMSCALARREQUESTS: 0 added, 0 removed, 2 changed

  • ~ DURATION_MS (database_data_type: int64 → double)
  • ~ DURATION_MS (dotnet_data_type: int64 → double)

ExactOnlineREST.Views.PurchaseOrdersIncremental: 12 added, 0 removed, 0 changed

  • + Item (guid)
  • + Item2 (guid)
  • + LineNumber (int32)
  • + LineNumber2 (int32)
  • + Project (guid)
  • + Project2 (guid)
  • + SalesOrderLine (guid)
  • + SalesOrderLine2 (guid)
  • + Unit (varchar2)
  • + Unit2 (varchar2)
  • + UnitPrice (double)
  • + UnitPrice2 (double)

ExactOnlineREST.Views.SalesInvoicesIncremental: 16 added, 0 removed, 0 changed

  • + EndTime (datetime)
  • + EndTime2 (datetime)
  • + GLAccount (guid)
  • + GLAccount2 (guid)
  • + Item (guid)
  • + Item2 (guid)
  • + LineNumber (int32)
  • + LineNumber2 (int32)
  • + Project (guid)
  • + Project2 (guid)
  • + SalesOrderLine (guid)
  • + SalesOrderLine2 (guid)
  • + StartTime (datetime)
  • + StartTime2 (datetime)
  • + UnitPrice (double)
  • + UnitPrice2 (double)

ExactOnlineREST.Views.TransactionsIncremental: 14 added, 0 removed, 0 changed

  • + GLAccount (guid)
  • + GLAccount2 (guid)
  • + Item (guid)
  • + Item2 (guid)
  • + LineNumber (int32)
  • + LineNumber2 (int32)
  • + LineType (int16)
  • + LineType2 (int16)
  • + OffsetID (guid)
  • + OffsetID2 (guid)
  • + Project (guid)
  • + Project2 (guid)
  • + Quantity (double)
  • + Quantity2 (double)

ExactOnlineXML.Native.NATIVEPLATFORMSCALARREQUESTS: 0 added, 0 removed, 2 changed

  • ~ DURATION_MS (database_data_type: int64 → double)
  • ~ DURATION_MS (dotnet_data_type: int64 → double)

ExactOnlineXML.XML.EmploymentCLAs: 2 added, 0 removed, 0 changed

  • + EMPLOYMENTCLAS_EMPLOYMENT_EMPLOYMENTTYPE (number)
  • + EMPLOYMENTCLAS_EMPLOYMENT_MAIN (boolean)

ExactOnlineXML.XML.EmploymentContracts: 2 added, 0 removed, 0 changed

  • + EMPLOYMENTCONTRACTS_EMPLOYMENT_EMPLOYMENTTYPE (number)
  • + EMPLOYMENTCONTRACTS_EMPLOYMENT_MAIN (boolean)

ExactOnlineXML.XML.EmploymentOrganizations: 5 added, 0 removed, 0 changed

  • + COSTCENTER_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + COSTUNIT_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEPARTMENT_COSTCENTER_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + EMPLOYMENTORGANIZATIONS_EMPLOYMENT_EMPLOYMENTTYPE (number)
  • + EMPLOYMENTORGANIZATIONS_EMPLOYMENT_MAIN (boolean)

ExactOnlineXML.XML.EmploymentSalaries: 2 added, 0 removed, 0 changed

  • + EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_EMPLOYMENTTYPE (number)
  • + EMPLOYMENTSALARIES_EMPLOYMENTCLA_EMPLOYMENTCLAS_EMPLOYMENT_MAIN (boolean)

ExactOnlineXML.XML.FinishedAssemblySerialNumbers: 1 added, 0 removed, 0 changed

  • + SERIALNUMBERS_FINISHEDASSEMBLY_TYPE_ATTR (varchar2)

ExactOnlineXML.XML.WBSExpensesLevel2: 200 added, 0 removed, 0 changed

  • + AUTOCREATEINVOICETERM (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_BALANCESIDE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_BALANCETYPE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_BELCOTAXTYPE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_BLOCKED_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_COMPRESS_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_COSTCENTER_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_COSTCENTER_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_COSTCENTER_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_COSTCENTER_ENDDATE (date)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_COSTCENTER_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_COSTUNIT_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_COSTUNIT_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_COSTUNIT_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_COSTUNIT_ENDDATE (date)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_COSTUNIT_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_DATEVAUTOMATICVAT_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_DEDUCTIBILITYPERCENTAGES (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_EXCLUDEVATLISTING (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_EXPENSENONDEDUCTIBLEPERCENTAGE (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_GOCATEGORYDESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_GOCATEGORYISACTIVE (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_ID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_ISVARIABLEVATNONDEDUCTIBLEPERCENTAGE (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_MATCHING_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_BALANCESIDE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_BALANCETYPE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_BELCOTAXTYPE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_BLOCKED_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_COMPRESS_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_COSTCENTER_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_COSTCENTER_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_COSTCENTER_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_COSTCENTER_ENDDATE (date)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_COSTCENTER_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_COSTUNIT_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_COSTUNIT_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_COSTUNIT_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_COSTUNIT_ENDDATE (date)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_COSTUNIT_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_DATEVAUTOMATICVAT_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_DEDUCTIBILITYPERCENTAGES (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_EXCLUDEVATLISTING (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_EXPENSENONDEDUCTIBLEPERCENTAGE (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_GOCATEGORYDESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_GOCATEGORYISACTIVE (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_ID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_ISVARIABLEVATNONDEDUCTIBLEPERCENTAGE (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_MATCHING_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_PRIVATEPERCENTAGE (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_REPORTINGCODE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_REVALUECURRENCY_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_SEARCHCODE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_TYPE_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_USECOSTCENTER (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_USECOSTUNIT (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VAT (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATGLACCOUNTTYPE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_BALANCESIDE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_BALANCETYPE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_BELCOTAXTYPE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_BLOCKED_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_COMPRESS_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_COSTCENTER_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_COSTCENTER_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_COSTCENTER_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_COSTCENTER_ENDDATE (date)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_COSTCENTER_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_COSTUNIT_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_COSTUNIT_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_COSTUNIT_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_COSTUNIT_ENDDATE (date)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_COSTUNIT_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_DATEVAUTOMATICVAT_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_DEDUCTIBILITYPERCENTAGES (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_EXCLUDEVATLISTING (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_EXPENSENONDEDUCTIBLEPERCENTAGE (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_GOCATEGORYDESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_GOCATEGORYISACTIVE (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_ID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_ISVARIABLEVATNONDEDUCTIBLEPERCENTAGE (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_MATCHING_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEPERCENTAGE (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_REPORTINGCODE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_REVALUECURRENCY_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_SEARCHCODE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_TYPE_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_USECOSTCENTER (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_USECOSTUNIT (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_VAT (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_VATGLACCOUNTTYPE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_VATNONDEDUCTIBLEPERCENTAGE (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEGLACCOUNT_VATSYSTEM_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEPERCENTAGE (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEGLACCOUNT_VATSYSTEM_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_PRIVATEPERCENTAGE (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_REPORTINGCODE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_REVALUECURRENCY_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_SEARCHCODE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_TYPE_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_USECOSTCENTER (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_USECOSTUNIT (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VAT (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATGLACCOUNTTYPE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_BALANCESIDE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_BALANCETYPE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_BELCOTAXTYPE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_BLOCKED_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_COMPRESS_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_COSTCENTER_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_COSTCENTER_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_COSTCENTER_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_COSTCENTER_ENDDATE (date)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_COSTCENTER_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_COSTUNIT_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_COSTUNIT_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_COSTUNIT_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_COSTUNIT_ENDDATE (date)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_COSTUNIT_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_DATEVAUTOMATICVAT_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_DEDUCTIBILITYPERCENTAGES (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_EXCLUDEVATLISTING (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_EXPENSENONDEDUCTIBLEPERCENTAGE (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_GOCATEGORYDESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_GOCATEGORYISACTIVE (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_ID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_ISVARIABLEVATNONDEDUCTIBLEPERCENTAGE (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_MATCHING_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_BALANCESIDE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_BALANCETYPE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_BELCOTAXTYPE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_BLOCKED_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_COMPRESS_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_COSTCENTER_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_COSTCENTER_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_COSTCENTER_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_COSTCENTER_ENDDATE (date)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_COSTCENTER_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_COSTUNIT_CODE_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_COSTUNIT_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_COSTUNIT_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_COSTUNIT_ENDDATE (date)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_COSTUNIT_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_DATEVAUTOMATICVAT_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_DEDUCTIBILITYPERCENTAGES (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_DESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_DESCRIPTION_TERMID_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_EXCLUDEVATLISTING (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_EXPENSENONDEDUCTIBLEPERCENTAGE (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_GOCATEGORYDESCRIPTION (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_GOCATEGORYISACTIVE (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_ID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_ISVARIABLEVATNONDEDUCTIBLEPERCENTAGE (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_MATCHING_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_PRIVATEPERCENTAGE (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_REPORTINGCODE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_REVALUECURRENCY_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_SEARCHCODE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_TYPE_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_USECOSTCENTER (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_USECOSTUNIT (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_VAT (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_VATGLACCOUNTTYPE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_VATNONDEDUCTIBLEPERCENTAGE (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEGLACCOUNT_VATSYSTEM_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_PRIVATEPERCENTAGE (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_REPORTINGCODE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_REVALUECURRENCY_ATTR (boolean)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_SEARCHCODE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_TRANSLATIONS_TERMID_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_TYPE_ATTR (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_USECOSTCENTER (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_USECOSTUNIT (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_VAT (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_VATGLACCOUNTTYPE (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_VATNONDEDUCTIBLEPERCENTAGE (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEGLACCOUNT_VATSYSTEM_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATNONDEDUCTIBLEPERCENTAGE (number)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTSWORKINPROGRESS_VATSYSTEM_ATTR (varchar2)
  • + DEFAULTCOSTTYPE_ASSORTMENT_GLCOSTS_BALANCESIDE_ATTR (varchar2)

Parameters, Packages and Procedures, Keys and Code Values

46,289 more columns are added to ExactOnlineXML.XML.WBSExpensesLevel2

The table gains 46,489 columns in all; the first 200 have a row of their own. Select the columns that you need by name.

  • importance 3
Package eol_invoice is added
  • importance 3
Package eol_premium is added
  • importance 3
Package dcr_metadata is added
  • importance 1

Provider attributes

Do I have to change my connection string, provider file or settings? Attributes of the connection and settings of the driver that appear, disappear or change default or place where they can be set.

  • 2 changes
  • model files

Attribute exact-online-url: allow set from log on changes

Allow set from log on changes from false to true.

  • false → true
  • importance 3
Engine-wide connection attributes change

28 attributes added, 2 removed and 5 settings of attributes changed. These attributes belong to the SQL engine and exist for every driver; the Query Tool notes describe them.

  • importance 2

Capabilities

What can the driver do with a table? Whether a table or table function can be selected from, inserted into, updated and deleted from.

  • 0 changes
  • model files

No changes in this group.

Performance

Is it faster, and does it call the platform less? Paging, batching, caching, filters and projections sent to the platform, fewer requests, less memory.

  • 9 changes
  • commits

Incremental tables are read faster and with less memory

The stored copy of an incremental table uses a typed binary format that is cheaper to write and to read. A statement reads only the columns it uses, and the rows are built on the threads that parse. The first read of each table after the upgrade performs one full reload.

What to Do

Expect one full reload of every incremental table after the upgrade. Plan it outside peak hours and mind the Exact Online API limits.

  • importance 4
  • confidence medium
Incremental tables can be loaded in the background before they are asked for

Frequently used incremental tables are refreshed ahead of the first statement, with priorities per table and a freshness window. Later fixes make the loading safe when several data containers share the same data.

  • importance 3
  • confidence medium
Less memory is used when reading Exact Online answers

The REST driver reads the JSON answers with a leaner reader and out of a parsed document instead of a tree of nodes. A test run in the code comments shows 42% less memory allocated on a read of 2,253 rows with 130 columns.

  • importance 3
  • confidence medium
Open the XML data model faster with a predefined list of fields

For most tables of the XML API the columns are read from a predefined list instead of scanning the XML schema each time. A new connection attribute switches this off.

  • importance 3
  • confidence high
Row limits, counts and grouping are sent to Exact Online

A statement with a row limit on one unsorted table now asks Exact Online for only that number of rows. Counts and aggregates can be answered by the platform instead of by downloading all rows. Incremental tables are left out, since a limit there would cut the changes that the next refresh builds on.

  • importance 3
  • confidence medium
Do not rebuild the list of companies on a USE statement

A USE statement no longer makes Exact Online rebuild the list of companies.

  • importance 2
  • confidence medium
Inserts run on dedicated threads, one partition at a time

Writes to several companies in parallel no longer wait for each other on the shared thread pool. Every insert blocks on the API, so each company gets a thread of its own.

  • importance 2
  • confidence medium
Use less memory and fewer reads for large cached JSON responses

Reading and writing the disk cache of large incremental JSON responses uses less memory (no duplicate copy of buffers) and reads in larger blocks.

  • importance 2
  • confidence medium
Less processing time on log-on and in the HTTP cache

Several lists are sorted once in place instead of through repeated queries, and the cache keeps its last bytes without copying a large source.

  • importance 1
  • confidence medium

Bug fixes

Is the defect that I met repaired? Wrong or missing rows, wrong values, crashes and wrong messages, repaired in a release line that had the defect.

  • 19 changes
  • commits

Incremental refresh no longer reloads a heavily changed table on every run

The point from which the next refresh continues was set too low when many rows were changed and only old rows were deleted. The estimated row count then came out at about twice the real count, the consistency check failed and the stored copy was rebuilt on every run. The point is now taken from the changed rows, rows that only grew are not seen as unchanged, and an apparent deviation is first checked against the stored copy.

  • importance 4
  • confidence medium
A rejected stored copy of an incremental table is rebuilt instead of reused

When the stored copy was rejected, for example because a part of it was missing, the refresh skipped writing a new version. Every run in the following hour then rejected the same copy again. The new version is now written.

  • importance 3
  • confidence medium
A stopped run no longer leaves a torn copy of an incremental table

A background task that outlived its request could fail between saving the data parts and the description of a stored copy, leaving a copy that could not be read. The session identifier is now only used for diagnostics and no longer stops the save.

  • importance 3
  • confidence medium
Developer accounts are no longer refused as accountancy subscriptions

One feature was used to tell accountancy subscriptions apart, but Exact Online developer accounts now have it too. The check no longer uses it. The error message for a real accountancy subscription now lists the features found.

  • importance 3
  • confidence medium
Handle log-on errors of the XML API when they are wrapped in another error

A log-on error of Exact Online that was wrapped inside another error was not recognised by the XML API, so no new token was requested and the statement failed. Wrapped errors are now handled like direct ones.

  • importance 3
  • confidence medium
Writes through the XML API are not repeated after an HTTP 500

An internal server error, or a failure without an answer, can follow a write that was carried out. The XML driver now sends such a write again only when the driver declares its writes safe to repeat. This prevents duplicate documents.

  • importance 3
  • confidence medium
A filter that nests too deeply gives a specific error message

Exact Online refuses filters with roughly fourteen OR-ed groups with a bad request and an empty code. The driver now reports this under its own message with advice to reduce the alternatives. A wrong variable name in the error handling was also corrected.

  • importance 2
  • confidence high
Callback address errors during log-on are recognised

Exact Online reports an unregistered callback address in more than one wording and sometimes as a complete HTML page. The check only matched one sentence and always answered no, so the cause was not explained.

  • importance 2
  • confidence medium
Correct the primary key columns of several tables

A number of tables had an invalid or missing primary key column, for example cash flow lines, statements and transaction identifiers, bulk warehouses and material issues. The key columns are corrected.

  • importance 2
  • confidence medium
Eleven incremental views show their proper names

The incremental views for employees, employments, shop orders and payroll bank accounts showed an unresolved placeholder as their name. They now have a real name.

  • importance 2
  • confidence high
Hide the views that need the XML API when the XML API is switched off

Predefined views that read from the Exact Online XML API are no longer offered when the XML API is switched off, so they no longer fail when used.

  • importance 2
  • confidence medium
Keep the cache of incremental tables when a cache refresh is requested

Settings of a statement such as a request not to use the disk cache no longer apply to incremental tables. A refresh by the data cache could otherwise force the incremental cache to be built again.

  • importance 2
  • confidence high
Overload answers (HTTP 429) of the XML API are handled when retrying

The XML driver now treats HTTP 429 as a refusal that was not carried out, so that the request can be tried again without duplicating it, with a bounded wait.

  • importance 2
  • confidence low
Pass the selected companies on correctly when the Premium connector is enabled

With the Exact Online Premium connector enabled, the companies selected with a USE statement were not passed on to the Exact Online connection. They are now.

  • importance 2
  • confidence medium
Repair the filter on the general ledger scheme of the classification table functions

A statement on a classification table function with a filter on the scheme code, for example a filter on the scheme code column of the account classifications function, failed with a message that the column could not be found. The filter is now only renamed for the tables that support it.

  • importance 2
  • confidence high
Rows of XML calls are counted in the call register

The register of calls to Exact Online showed no rows for XML calls, because the call was completed before the response was parsed. The rows of each page are now added to the record of the call.

  • importance 2
  • confidence medium
Stop repeated session-state errors when reading account classifications

After a disconnect, reading the account classifications could keep failing with the error that the session state is missing, because the failed result was kept. The result is now rebuilt on that error.

  • importance 2
  • confidence medium
Store incremental data in the correct cache folder

Incremental data could end up in the wrong folder of the disk cache. The cache settings for incremental tables are now merged with the predefined settings.

  • importance 2
  • confidence medium
Make the copy remarks of supplier items optional

The field with the copy remarks of purchase order lines for supplier items was described as required. It is now optional.

  • importance 1
  • confidence high

Enhancements

What can I do now that I could not? New functions and options that are not a table or a column.

  • 10 changes
  • commits

Update the Exact Online XML tables to the XML schema of August 2026

The tables and views of the Exact Online XML API follow the updated XML schema and topic parameters of 3 August 2026. Several topics get extra fields, for example employment, finished assembly serial numbers and project work breakdown structures. As a side effect the view with the expenses on the second level of a work breakdown structure grows from 40 to about 46,500 columns.

What to Do

Name the columns that are needed instead of selecting all columns from the XML view for work breakdown structure expenses (second level and deeper).

  • can break a statement
  • importance 4
  • confidence high
A view lists the tables on which Exact Online refused access

A new view shows per table in how many companies Exact Online refused a read and how many calls were refused, with a sentence that explains it.

  • importance 3
  • confidence medium
Report durations in milliseconds with decimals

Durations in milliseconds are measured and reported more accurately. The column with the duration of counting rows in the data dictionary changes from a whole number to a decimal number.

What to Do

Check scripts that store the duration of the row count in a whole-number column.

  • can break a statement
  • importance 3
  • confidence high
Statements and synchronisations can be cancelled promptly

A cancelled run no longer requests a further page, no longer starts another attempt after a failure and cancels web requests that wait for a response or for a connection.

  • importance 3
  • confidence medium
A session can accept a recent stored copy to answer faster

When a session sets a maximum age, an incremental table is answered from the stored copy if it is young enough and is brought up to date afterwards. This is off unless the session asks for it, and a notice states that a stored copy was used.

  • importance 2
  • confidence medium
Add a table with the entity types of incremental loading

A new table in the data dictionary lists the entity types of the Exact Online sync API that are used for incremental loading, with their service address pattern.

  • importance 2
  • confidence medium
Add technical documentation to entities and views

Tables and views of Exact Online get a short description and technical documentation in the data dictionary, for example on incremental header views and on the views for financial years and outstanding items.

  • importance 2
  • confidence high
Give expected latency and throughput for tables

The data dictionary shows expected figures for access time and rows per minute for each Exact Online table, based on the type of table (REST, bulk, sync and incremental).

  • importance 2
  • confidence medium
The incremental load checks the age of deleted rows at Exact Online

The synchronisation of deleted rows now stops with a new error when Exact Online returns deleted rows older than its documented retention plus seven days. The age limit is a connection setting with default 63 days.

  • importance 2
  • confidence medium
Add the company name to the view with balance lines per period

The view with balance lines per period for all financial periods now also shows the name of the company.

  • importance 1
  • confidence medium

Log-on and platform

Do I have to log on again, or change something because of the platform? Log-on and token handling, scopes and permissions, a new version of the platform API, retired endpoints and changed limits.

  • 5 changes
  • commits

Exclude companies in countries with an ICC warrant and outside the service area

Companies (divisions) of Exact Online are no longer listed or usable when the company is located in a country whose government has a member wanted by the International Criminal Court. The same holds for companies in countries outside the service area, unless the company is on a fixed list of companies that were allowed before.

What to Do

Check whether companies located in an excluded country are still used. They are no longer available.

  • can break a statement
  • importance 4
  • confidence medium
Web requests use the new HTTP client

Requests to Exact Online now go through the product-wide HTTP client instead of the older web request class. Error handling follows the new exception type, and the check of which failures can be retried was repaired for it. Proxy and TLS behaviour follow the new client.

  • importance 3
  • confidence medium
Allow the Invantive Cloud redirect address for all applications

The check that only allowed the redirect address of Invantive Cloud for Invantive Cloud products is switched off, because with the Credentials Server this redirect address can also end up in all on-premises products. The Invantive MCP Server and the online app were added to the allowed products on the way.

  • importance 2
  • confidence medium
Follow the longer fields of Exact Online: classification code and your reference

Exact Online allows a longer code for general ledger classifications and a longer reference of the customer on orders and invoices. Both are now described with a length of 60 characters instead of 30.

  • importance 2
  • confidence medium
Invantive web addresses are moved to the .eu domain

The Get My Report link for documents and other Invantive addresses in the driver now use the invantive.eu domain. The log-on redirect address was changed to the .eu domain and changed back, so it ends where it started.

  • importance 2
  • confidence medium

In Numbers

Objects of the data model at both ends of the step.

Objects 26.0 27.0 Change
tables 624 623 -1
views 357 357 +0
table functions 0 0 +0
columns 29,031 75,383 +46,352
function parameters 1,088 1,088 +0
attributes of driver 37 37 +0
tables that can insert 700 699 -1
tables that can update 686 685 -1
tables that can delete 313 312 -1

More Information

How This Note Was Made

  • 2026-11-01T12:11:05.2205504Z
  • 2026-11-01T12:00:13.510425Z
  • Fields that only the newer model has.
  • Fields that only the newer model has.
  • Fields that only the newer model has.
  • Fields that only the newer model has.
  • Fields that only the newer model has.
  • Fields that only the newer model has.
  • ExactOnlineXmlProvider.cs, 6 lines, in a commit titled 'Add DeepL driver'; only the two status code cases were read. The effect in practice depends on the shared worker, which was not read.
  • Commit items were classified by one reader; the model changes are derived and need no reading.
  • Commits: the commits of the driver directory in the range that have no equivalent patch in the older state, without merges and version stamps; each was classified by reading its message and change.
  • Model: the NDJSON files of data-models/database of the workspace of each release are compared record by record; only fields that both models have are compared, and texts are counted, not listed.
  • A model generated from a later build of the same release (for example 26.0.340 for 26.0) stands for the release.
  • 300 links between a change and a source commit are recorded.
  • 2 exclusions are recorded in the audit of the note.