invantive documentation
Invantive Support ForumsLog In / Sign Up

Release notes of Yuki

Driver Release Note - Cloud

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

  • 155 changes
  • 0 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.

Download Changes as CSV

Before You Upgrade

No change of this step is marked as breaking.

Top 14 Changes

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

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.

  • 148 changes
  • model files

Tables, Views and Table Functions

Table Yuki.General.Companies is added

The table has 5 columns and can select.

  • importance 3
Table Yuki.General.SupportedLanguages is added

The table has 5 columns and can select.

  • importance 3
Table function Yuki.Accounting.OutstandingCreditorItemsByDateOutstanding is added

The table function has 33 columns and can select.

  • importance 3
Table function Yuki.Accounting.OutstandingCreditorItemsWithPaymentReference is added

The table function has 33 columns and can select.

  • importance 3
Table function Yuki.Accounting.OutstandingDebtorItemsByDateOutstanding is added

The table function has 33 columns and can select.

  • importance 3
Table function Yuki.Accounting.OutstandingDebtorItemsWithLanguage is added

The table function has 33 columns and can select.

  • importance 3
Table function Yuki.Accounting.OutstandingDebtorItemsWithPaymentReference is added

The table function has 33 columns and can select.

  • importance 3
Table function Yuki.AccountingInfo.ContactDefaultValuesByContactId is added

The table function has 17 columns and can select.

  • importance 3
Table function Yuki.AccountingInfo.CustomPaymentMethods is added

The table function has 6 columns and can select.

  • importance 3
Table function Yuki.AccountingInfo.FinancialYearModifiedDatesByYear is added

The table function has 5 columns and can select.

  • importance 3
Table function Yuki.AccountingInfo.TransactionsByPeriod is added

The table function has 42 columns and can select.

  • importance 3
Table function Yuki.Archive.ArchiveProjects is added

The table function has 6 columns and can select.

  • importance 3
Table function Yuki.Archive.DocumentDownloadUrlByDocumentId is added

The table function has 3 columns and can select.

  • importance 3
Table function Yuki.Archive.DocumentXmlDataByDocumentId is added

The table function has 3 columns and can select.

  • importance 3
Table function Yuki.Archive.DocumentsByType is added

The table function has 23 columns and can select.

  • importance 3
Table function Yuki.Archive.ModifiedDocumentsByFolderId is added

The table function has 23 columns and can select.

  • importance 3
Table function Yuki.Archive.ModifiedDocumentsByType is added

The table function has 23 columns and can select.

  • importance 3
Table function Yuki.Contact.SuppliersAndCustomersByDomainId is added

The table function has 33 columns and can select.

  • importance 3
Table function Yuki.Domains.DomainFunctionsByDomainId is added

The table function has 6 columns and can select.

  • importance 3
Table function Yuki.Purchase.PurchaseInvoiceSchemas is added

The table function has 5 columns and can select.

  • importance 3
Table function Yuki.Sales.SalesItems is added

The table function has 6 columns and can select.

  • importance 3
Table function Yuki.Vat.ActiveVatCodes is added

The table function has 11 columns and can select.

  • importance 3
Table function Yuki.Vat.VatReturnsByYear is added

The table function has 11 columns and can select.

  • importance 3
View Yuki.Views.DocumentFolderTabs is added

The view has 11 columns and can select.

  • importance 3
View Yuki.Views.DomainFunctions is added

The view has 11 columns and can select.

  • importance 3
View Yuki.Views.SuppliersAndCustomers is added

The view has 38 columns and can select.

  • importance 3
Yuki.Accounting.OutstandingCreditorItems: table parameters changes

Table parameters of Yuki.Accounting.OutstandingCreditorItems changes from administrationID, includeBankTransactions to administrationID, includeBankTransactions, sortOrder.

  • administrationID, includeBankTransactions → administrationID, includeBankTransactions, sortOrder
  • importance 3
Yuki.Accounting.OutstandingCreditorItemsByDate: table parameters changes

Table parameters of Yuki.Accounting.OutstandingCreditorItemsByDate changes from administrationID, includeBankTransactions, startDate, endDate to administrationID, includeBankTransactions, startDate, endDate, sortOrder.

  • administrationID, includeBankTransactions, startDate, endDate → administrationID, includeBankTransactions, startDate, endDate, sortOrder
  • importance 3
Yuki.Accounting.OutstandingDebtorItems: table parameters changes

Table parameters of Yuki.Accounting.OutstandingDebtorItems changes from administrationID, includeBankTransactions to administrationID, includeBankTransactions, sortOrder.

  • administrationID, includeBankTransactions → administrationID, includeBankTransactions, sortOrder
  • importance 3
Yuki.Accounting.OutstandingDebtorItemsByDate: table parameters changes

Table parameters of Yuki.Accounting.OutstandingDebtorItemsByDate changes from administrationID, includeBankTransactions, startDate, endDate to administrationID, includeBankTransactions, startDate, endDate, sortOrder.

  • administrationID, includeBankTransactions, startDate, endDate → administrationID, includeBankTransactions, startDate, endDate, sortOrder
  • importance 3
Yuki.Archive.Documents: table parameters changes

Table parameters of Yuki.Archive.Documents changes from startDate, endDate to startDate, endDate, sortOrder.

  • startDate, endDate → startDate, endDate, sortOrder
  • importance 3
Yuki.Archive.DocumentsByFolderId: table parameters changes

Table parameters of Yuki.Archive.DocumentsByFolderId changes from folderID, startDate, endDate to folderID, startDate, endDate, sortOrder.

  • folderID, startDate, endDate → folderID, startDate, endDate, sortOrder
  • importance 3
Yuki.Archive.DocumentsBySearchCriteria: table parameters changes

Table parameters of Yuki.Archive.DocumentsBySearchCriteria changes from documentID, searchOption, searchText, folderID, tabID, startDate, endDate to documentID, searchOption, searchText, folderID, tabID, startDate, endDate, sortOrder.

  • documentID, searchOption, searchText, folderID, tabID, startDate, endDate → documentID, searchOption, searchText, folderID, tabID, startDate, endDate, sortOrder
  • importance 3
Yuki.Archive.DocumentsByTabId: table parameters changes

Table parameters of Yuki.Archive.DocumentsByTabId changes from tabID, startDate, endDate to tabID, startDate, endDate, sortOrder.

  • tabID, startDate, endDate → tabID, startDate, endDate, sortOrder
  • importance 3
Yuki.Contact.ContactsByDomainId: table parameters changes

Table parameters of Yuki.Contact.ContactsByDomainId changes from domainId, searchOption, searchValue, modifiedAfter, active to domainId, searchOption, searchValue, modifiedAfter, active, sortOrder.

  • domainId, searchOption, searchValue, modifiedAfter, active → domainId, searchOption, searchValue, modifiedAfter, active, sortOrder
  • importance 3

Columns

100 added, 0 removed, 2 changed, in 12 tables.

Yuki.AccountingInfo.GLAccountSchemes: 3 added, 0 removed, 0 changed

  • + DEDUCTABLEVATPERCENTAGE (decimal)
  • + ISVATAPPLICABLE (char)
  • + PROFESSIONALPERCENTAGE (decimal)

Yuki.Archive.DocumentById: 3 added, 0 removed, 0 changed

  • + PAYMENTID (varchar2)
  • + PAYMENTREFERENCE (varchar2)
  • + VATAMOUNT (decimal)

Yuki.Archive.Documents: 3 added, 0 removed, 0 changed

  • + PAYMENTID (varchar2)
  • + PAYMENTREFERENCE (varchar2)
  • + VATAMOUNT (decimal)

Yuki.Archive.DocumentsByFolderId: 3 added, 0 removed, 0 changed

  • + PAYMENTID (varchar2)
  • + PAYMENTREFERENCE (varchar2)
  • + VATAMOUNT (decimal)

Yuki.Archive.DocumentsBySearchCriteria: 3 added, 0 removed, 0 changed

  • + PAYMENTID (varchar2)
  • + PAYMENTREFERENCE (varchar2)
  • + VATAMOUNT (decimal)

Yuki.Archive.DocumentsByTabId: 3 added, 0 removed, 0 changed

  • + PAYMENTID (varchar2)
  • + PAYMENTREFERENCE (varchar2)
  • + VATAMOUNT (decimal)

Yuki.Contact.ContactsByDomainId: 35 added, 0 removed, 0 changed

  • + ADDRESSLINE1 (varchar2)
  • + ADDRESSLINE2 (varchar2)
  • + BACKOFFICESTATUS (varchar2)
  • + BIC (varchar2)
  • + CITY (varchar2)
  • + COCNUMBER (varchar2)
  • + CODE (varchar2)
  • + COUNTRY (varchar2)
  • + CREATED (datetime)
  • + EMAILHOME (varchar2)
  • + EMAILWORK (varchar2)
  • + FIRSTNAME (varchar2)
  • + HID (int32)
  • + IBAN (varchar2)
  • + ID (guid)
  • + INCOMETAXNUMBER (varchar2)
  • + ISCUSTOMER (char)
  • + ISSUPPLIER (char)
  • + LASTNAME (varchar2)
  • + MAILADDRESSLINE1 (varchar2)
  • + MAILADDRESSLINE2 (varchar2)
  • + MAILCITY (varchar2)
  • + MAILPOSTCODE (varchar2)
  • + MAINCONTACTPERSON (varchar2)
  • + MIDDLENAME (varchar2)
  • + MOBILEHOME (varchar2)
  • + MOBILEWORK (varchar2)
  • + MODIFIED (datetime)
  • + PHONEHOME (varchar2)
  • + PHONEWORK (varchar2)
  • + POSTCODE (varchar2)
  • + TAGS (varchar2)
  • + TYPE (varchar2)
  • + VATNUMBER (varchar2)
  • + WEBSITE (varchar2)

Yuki.General.Administrations: 2 added, 0 removed, 0 changed

  • + ACTIVE (char)
  • + ADDRESSLINE2 (varchar2)

Yuki.General.Domains: 2 added, 0 removed, 0 changed

  • + STATUS (varchar2)
  • + STATUSID (varchar2)

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

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

Yuki.Views.Contacts: 39 added, 0 removed, 0 changed

  • + ADDRESSLINE1 (varchar2)
  • + ADDRESSLINE2 (varchar2)
  • + BACKOFFICESTATUS (varchar2)
  • + BIC (varchar2)
  • + CITY (varchar2)
  • + COCNUMBER (varchar2)
  • + CODE (varchar2)
  • + COUNTRY (varchar2)
  • + CREATED (datetime)
  • + DOMAINNAME (varchar2)
  • + DOMAINNAME2 (varchar2)
  • + EMAILHOME (varchar2)
  • + EMAILWORK (varchar2)
  • + FIRSTNAME (varchar2)
  • + HID (int32)
  • + IBAN (varchar2)
  • + ID (guid)
  • + INCOMETAXNUMBER (varchar2)
  • + ISCUSTOMER (char)
  • + ISSUPPLIER (char)
  • + LASTNAME (varchar2)
  • + MAILADDRESSLINE1 (varchar2)
  • + MAILADDRESSLINE2 (varchar2)
  • + MAILCITY (varchar2)
  • + MAILPOSTCODE (varchar2)
  • + MAINCONTACTPERSON (varchar2)
  • + MIDDLENAME (varchar2)
  • + MOBILEHOME (varchar2)
  • + MOBILEWORK (varchar2)
  • + MODIFIED (datetime)
  • + PHONEHOME (varchar2)
  • + PHONEWORK (varchar2)
  • + POSTCODE (varchar2)
  • + TAGS (varchar2)
  • + TYPE (varchar2)
  • + VATNUMBER (varchar2)
  • + WEBSITE (varchar2)
  • + domain_STATUS (varchar2)
  • + domain_STATUSID (varchar2)

Yuki.Views.Users: 4 added, 0 removed, 0 changed

  • + DOMAINNAME (varchar2)
  • + DOMAINNAME2 (varchar2)
  • + domain_STATUS (varchar2)
  • + domain_STATUSID (varchar2)

Parameters, Packages and Procedures, Keys and Code Values

Parameter folderID of Yuki.Archive.DocumentsBySearchCriteria: presence required changes

Presence required changes from false to true. Without these parameters Yuki already answered with an internal error, so no working statement is affected.

  • false → true
  • importance 3
Parameter tabID of Yuki.Archive.DocumentsBySearchCriteria: presence required changes

Presence required changes from false to true. Without these parameters Yuki already answered with an internal error, so no working statement is affected.

  • false → true
  • importance 3
Parameter sortOrder is added to Yuki.Accounting.OutstandingCreditorItems

Optional.

  • importance 2
Parameter sortOrder is added to Yuki.Accounting.OutstandingCreditorItemsByDate

Optional.

  • importance 2
Parameter sortOrder is added to Yuki.Accounting.OutstandingDebtorItems

Optional.

  • importance 2
Parameter sortOrder is added to Yuki.Accounting.OutstandingDebtorItemsByDate

Optional.

  • importance 2
Parameter sortOrder is added to Yuki.Archive.Documents

Optional.

  • importance 2
Parameter sortOrder is added to Yuki.Archive.DocumentsByFolderId

Optional.

  • importance 2
Parameter sortOrder is added to Yuki.Archive.DocumentsBySearchCriteria

Optional.

  • importance 2
Parameter sortOrder is added to Yuki.Archive.DocumentsByTabId

Optional.

  • importance 2
Parameter sortOrder is added to Yuki.Contact.ContactsByDomainId

Optional.

  • importance 2

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.

  • 1 changes
  • model files

Engine-wide connection attributes change

27 attributes added, 2 removed and 6 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.

  • 0 changes
  • commits

No changes in this group.

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.

  • 3 changes
  • commits

Concurrent reads of Yuki domains could return data of the wrong domain

When several domains were read at the same time, the switch of the Yuki session to a domain and the call that depended on it could be separated by the switch of another reader. A gate now keeps the switch and the call together.

  • importance 4
  • confidence medium
Cache lifetime of Yuki answers follows the settings of the session

Answers of Yuki were always kept for up to 16 hours, whatever the cache settings of the user. The settings of the session are now used.

  • importance 3
  • confidence medium
XML answers of Yuki are no longer read with external entity resolution (security)

The XML and SOAP fault answers of Yuki are read with the resolution of external entities switched off, which closes the possibility of an XXE attack through a manipulated answer.

  • importance 3
  • confidence high

Enhancements

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

  • 3 changes
  • commits

Many more Yuki operations, columns and views, with paging and sorting

The driver reads more of the Yuki web services: outstanding items per date and with payment reference or language, transactions per period, archive projects and documents by type, contacts, suppliers and customers per domain, companies, supported languages, VAT codes and returns, sales items and more. Documents, contacts and administrations have extra columns, and several table functions accept a sort order. Large answers are read in pages of up to 1,000 records (100 for contacts), and a row limit is sent to Yuki when no filter or sort remains to be applied afterwards. Three new views join domain and folder lists to the table functions that need them, so tools that read tables and views only can reach them.

  • importance 4
  • confidence medium
Statements on Yuki can be cancelled while rows are read

A long statement on Yuki, such as a synchronisation, can be cancelled while the rows are read, also between pages.

  • importance 2
  • confidence medium
Throughput figures of Yuki calls included

The driver carries measured figures for latency and rows per minute of its main tables, taken from logged sessions. The engine uses such figures to estimate how long a statement takes.

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

  • 0 changes
  • commits

No changes in this group.

In Numbers

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

Objects 26.0 27.0 Change
tables 6 8 +2
views 3 6 +3
table functions 0 0 +0
columns 575 1,133 +558
function parameters 97 165 +68
attributes of driver 6 6 +0
tables that can insert 1 1 +0
tables that can update 0 0 +0
tables that can delete 0 0 +0

More Information

How This Note Was Made

  • 2026-11-01T12:10:08.0504434Z
  • 2026-11-01T11:59:30.5750408Z
  • 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.
  • 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.
  • 153 links between a change and a source commit are recorded.