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. |
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
This Note
Groups
- Data model 265
- Provider attributes 2
- Capabilities 0
- Performance 9
- Bug fixes 19
- Enhancements 10
- Log-on and platform 5
More
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:
- Table ExactOnlineREST.CRM.Budgets is removed
- Check statements, views and scripts that use it before the upgrade.
- Exclude companies in countries with an ICC warrant and outside the service area
- Check whether companies located in an excluded country are still used. They are no longer available.
- Update the Exact Online XML tables to the XML schema of August 2026
- Name the columns that are needed instead of selecting all columns from the XML view for work breakdown structure expenses (second level and deeper).
- Report durations in milliseconds with decimals
- Check scripts that store the duration of the row count in a whole-number column.
Top 25 Changes
Changes that can break a statement first, then by importance. Columns are summarised per table in the data model.
- Table ExactOnlineREST.CRM.Budgets is removed
- Data model
- Breaks an existing statement or script.
- Update the Exact Online XML tables to the XML schema of August 2026
- Enhancements
- Breaks an existing statement or script.
- Exclude companies in countries with an ICC warrant and outside the service area
- Log-on and platform
- Breaks an existing statement or script.
- Report durations in milliseconds with decimals
- Enhancements
- Breaks an existing statement or script.
- Incremental tables are read faster and with less memory
- Performance
- Importance 4 of 5.
- Incremental refresh no longer reloads a heavily changed table on every run
- Bug fixes
- Importance 4 of 5.
- Incremental tables can be loaded in the background before they are asked for
- Performance
- Importance 3 of 5.
- Less memory is used when reading Exact Online answers
- Performance
- Importance 3 of 5.
- Open the XML data model faster with a predefined list of fields
- Performance
- Importance 3 of 5.
- Row limits, counts and grouping are sent to Exact Online
- Performance
- Importance 3 of 5.
- A rejected stored copy of an incremental table is rebuilt instead of reused
- Bug fixes
- Importance 3 of 5.
- A stopped run no longer leaves a torn copy of an incremental table
- Bug fixes
- Importance 3 of 5.
- Developer accounts are no longer refused as accountancy subscriptions
- Bug fixes
- Importance 3 of 5.
- Handle log-on errors of the XML API when they are wrapped in another error
- Bug fixes
- Importance 3 of 5.
- Writes through the XML API are not repeated after an HTTP 500
- Bug fixes
- Importance 3 of 5.
- A view lists the tables on which Exact Online refused access
- Enhancements
- Importance 3 of 5.
- Statements and synchronisations can be cancelled promptly
- Enhancements
- Importance 3 of 5.
- Web requests use the new HTTP client
- Log-on and platform
- Importance 3 of 5.
- 46,289 more columns are added to ExactOnlineXML.XML.WBSExpensesLevel2
- Data model
- Importance 3 of 5.
- Package eol_invoice is added
- Data model
- Importance 3 of 5.
- Package eol_premium is added
- Data model
- Importance 3 of 5.
- Attribute exact-online-url: allow set from log on changes
- Provider attributes
- Importance 3 of 5.
- Do not rebuild the list of companies on a USE statement
- Performance
- Importance 2 of 5.
- Inserts run on dedicated threads, one partition at a time
- Performance
- Importance 2 of 5.
- 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
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
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
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
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
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
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
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
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
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
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
ExactOnlineXML.XML.FinishedAssemblySerialNumbers: 1 added, 0 removed, 0 changed+SERIALNUMBERS_FINISHEDASSEMBLY_TYPE_ATTR(varchar2)
ExactOnlineXML.XML.WBSExpensesLevel2: 200 added, 0 removed, 0 changed
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
- Data model documentation of the driver
- Questions and answers on the forum
- Invantive Cloud page of the driver
- Documentation of the platform
- All release notes
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.