---
title: "Release notes of Yuki"
description: "What changed in the drivers of Invantive UniversalSQL per release: tables, columns, attributes and capabilities, and what to change in statements and connection strings."
language: en
canonical: https://documentation.invantive.eu/en/release-notes/drivers?driver=yuki
---

# Release notes of Yuki

**Drivers:** [ActiveCampaign](/en/release-notes/drivers.md?driver=activecampaign&driver=yuki) | [Autotask](/en/release-notes/drivers.md?driver=autotask&driver=yuki) | [Bouw7](/en/release-notes/drivers.md?driver=bouw7&driver=yuki) | [Brevo](/en/release-notes/drivers.md?driver=brevo&driver=yuki) | [Calendly](/en/release-notes/drivers.md?driver=calendly&driver=yuki) | [CBS](/en/release-notes/drivers.md?driver=cbs&driver=yuki) | [Chargebee](/en/release-notes/drivers.md?driver=chargebee&driver=yuki) | [CompanyInfo](/en/release-notes/drivers.md?driver=companyinfo&driver=yuki) | [Conversion](/en/release-notes/drivers.md?driver=conversion&driver=yuki) | [Crisp](/en/release-notes/drivers.md?driver=crisp&driver=yuki) | [Data Cache](/en/release-notes/drivers.md?driver=data-cache&driver=yuki) | [Data Dictionary](/en/release-notes/drivers.md?driver=data-dictionary&driver=yuki) | [Discourse](/en/release-notes/drivers.md?driver=discourse&driver=yuki) | [Dummy](/en/release-notes/drivers.md?driver=dummy&driver=yuki) | [Easyflex](/en/release-notes/drivers.md?driver=easyflex&driver=yuki) | [ECB Exchange Rates](/en/release-notes/drivers.md?driver=ecb-exchange-rates&driver=yuki) | [Exact Online](/en/release-notes/drivers.md?driver=exact-online&driver=yuki) | [Fortnox](/en/release-notes/drivers.md?driver=fortnox&driver=yuki) | [Freshdesk](/en/release-notes/drivers.md?driver=freshdesk&driver=yuki) | [Freshservice](/en/release-notes/drivers.md?driver=freshservice&driver=yuki) | [Gripp CRM](/en/release-notes/drivers.md?driver=gripp-crm&driver=yuki) | [Horeko](/en/release-notes/drivers.md?driver=horeko&driver=yuki) | [HubSpot](/en/release-notes/drivers.md?driver=hubspot&driver=yuki) | [In-Memory Storage](/en/release-notes/drivers.md?driver=in-memory-storage&driver=yuki) | [ionBIZ](/en/release-notes/drivers.md?driver=ionbiz&driver=yuki) | [Kadaster](/en/release-notes/drivers.md?driver=kadaster&driver=yuki) | [KeePass](/en/release-notes/drivers.md?driver=keepass&driver=yuki) | [Knack](/en/release-notes/drivers.md?driver=knack&driver=yuki) | [KOOP (NL) BWB](/en/release-notes/drivers.md?driver=koop-nl-bwb&driver=yuki) | [KOOP (NL) CVDR](/en/release-notes/drivers.md?driver=koop-nl-cvdr&driver=yuki) | [KOOP (NL) Europese Richtlijnen](/en/release-notes/drivers.md?driver=koop-nl-europese-richtlijnen&driver=yuki) | [KOOP (NL) Officiele Publicaties](/en/release-notes/drivers.md?driver=koop-nl-officiele-publicaties&driver=yuki) | [KOOP (NL) PLOOI](/en/release-notes/drivers.md?driver=koop-nl-plooi&driver=yuki) | [KOOP (NL) PUC Open Data](/en/release-notes/drivers.md?driver=koop-nl-puc-open-data&driver=yuki) | [KOOP (NL) Samenwerkende Catalogi](/en/release-notes/drivers.md?driver=koop-nl-samenwerkende-catalogi&driver=yuki) | [KOOP (NL) Staatsalmanak](/en/release-notes/drivers.md?driver=koop-nl-staatsalmanak&driver=yuki) | [KOOP (NL) Staten Generaal Digitaal](/en/release-notes/drivers.md?driver=koop-nl-staten-generaal-digitaal&driver=yuki) | [KOOP (NL) Tuchtrecht](/en/release-notes/drivers.md?driver=koop-nl-tuchtrecht&driver=yuki) | [KOOP (NL) Verdragenbank](/en/release-notes/drivers.md?driver=koop-nl-verdragenbank&driver=yuki) | [KOOP (NL) Wetgevingskader](/en/release-notes/drivers.md?driver=koop-nl-wetgevingskader&driver=yuki) | [Localazy](/en/release-notes/drivers.md?driver=localazy&driver=yuki) | [LogiusCor](/en/release-notes/drivers.md?driver=logiuscor&driver=yuki) | [Loket.nl REST](/en/release-notes/drivers.md?driver=loket-nl-rest&driver=yuki) | [Mail](/en/release-notes/drivers.md?driver=mail&driver=yuki) | [Minox](/en/release-notes/drivers.md?driver=minox&driver=yuki) | [Mollie](/en/release-notes/drivers.md?driver=mollie&driver=yuki) | [Nmbrs](/en/release-notes/drivers.md?driver=nmbrs&driver=yuki) | [Odoo](/en/release-notes/drivers.md?driver=odoo&driver=yuki) | [Open Exchange Rates](/en/release-notes/drivers.md?driver=open-exchange-rates&driver=yuki) | [OpenArch](/en/release-notes/drivers.md?driver=openarch&driver=yuki) | [OpenSpending](/en/release-notes/drivers.md?driver=openspending&driver=yuki) | [OS](/en/release-notes/drivers.md?driver=os&driver=yuki) | [Outlook](/en/release-notes/drivers.md?driver=outlook&driver=yuki) | [Postman](/en/release-notes/drivers.md?driver=postman&driver=yuki) | [RDW](/en/release-notes/drivers.md?driver=rdw&driver=yuki) | [ROBAWS](/en/release-notes/drivers.md?driver=robaws&driver=yuki) | [Roller](/en/release-notes/drivers.md?driver=roller&driver=yuki) | [Simplicate](/en/release-notes/drivers.md?driver=simplicate&driver=yuki) | [SnelStart](/en/release-notes/drivers.md?driver=snelstart&driver=yuki) | [Teamleader Focus](/en/release-notes/drivers.md?driver=teamleader-focus&driver=yuki) | [Teamleader Orbit](/en/release-notes/drivers.md?driver=teamleaderorbit&driver=yuki) | [Teamleader Orbit](/en/release-notes/drivers.md?driver=teamleader-orbit&driver=yuki) | [Tixly](/en/release-notes/drivers.md?driver=tixly&driver=yuki) | [Tweede Kamer](/en/release-notes/drivers.md?driver=tweede-kamer&driver=yuki) | [Tweede Kamer NL](/en/release-notes/drivers.md?driver=tweede-kamer-nl&driver=yuki) | [Twinfield](/en/release-notes/drivers.md?driver=twinfield&driver=yuki) | [Visma Severa](/en/release-notes/drivers.md?driver=visma-severa&driver=yuki) | [Visma.net Financials](/en/release-notes/drivers.md?driver=visma-net-financials&driver=yuki) | [Visual FoxPro](/en/release-notes/drivers.md?driver=visual-foxpro&driver=yuki) | [Wikipedia](/en/release-notes/drivers.md?driver=wikipedia&driver=yuki) | **[Yuki](/en/release-notes/drivers.md)** (chosen)

**Releases:** [26.0 to 27.0](/en/release-notes/drivers.md?driver=yuki&step=26.0-to-27.0) | [new in 27.0](/en/release-notes/drivers.md?driver=yuki&step=new-in-27.0)

<div class="rn-block" id="yuki-26.0-to-27.0">

<div class="rn-head">

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

</div>

<div class="rn-layout">

<div class="rn-index">

**This Note**

- [By Group](#yuki-26.0-to-27.0-groups)
- [Before You Upgrade](#yuki-26.0-to-27.0-before)
- [Top 14 Changes](#yuki-26.0-to-27.0-top)

**Groups**

- [Data model](#yuki-26.0-to-27.0-g-data_model) 148
- [Provider attributes](#yuki-26.0-to-27.0-g-provider_attributes) 1
- [Capabilities](#yuki-26.0-to-27.0-g-capabilities) 0
- [Performance](#yuki-26.0-to-27.0-g-performance) 0
- [Bug fixes](#yuki-26.0-to-27.0-g-bug_fixes) 3
- [Enhancements](#yuki-26.0-to-27.0-g-enhancements) 3
- [Log-on and platform](#yuki-26.0-to-27.0-g-authentication_platform) 0

**More**

- [In Numbers](#yuki-26.0-to-27.0-numbers)
- [More Information](#yuki-26.0-to-27.0-more)

</div>

<div class="rn-main">

<a id="yuki-26.0-to-27.0-groups"></a>

### What Changed, by Group

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

<div class="rn-cards">

- [Data model](#yuki-26.0-to-27.0-g-data_model)
  - 148
  - Do my statements and views still work?
- [Provider attributes](#yuki-26.0-to-27.0-g-provider_attributes)
  - 1
  - Do I have to change my connection string, provider file or settings?
- [Capabilities](#yuki-26.0-to-27.0-g-capabilities)
  - 0
  - What can the driver do with a table?
- [Performance](#yuki-26.0-to-27.0-g-performance)
  - 0
  - Is it faster, and does it call the platform less?
- [Bug fixes](#yuki-26.0-to-27.0-g-bug_fixes)
  - 3
  - Is the defect that I met repaired?
- [Enhancements](#yuki-26.0-to-27.0-g-enhancements)
  - 3
  - What can I do now that I could not?
- [Log-on and platform](#yuki-26.0-to-27.0-g-authentication_platform)
  - 0
  - Do I have to log on again, or change something because of the platform?

</div>

[Download Changes as CSV](/en/release-notes/drivers/yuki/26.0-to-27.0.csv)

<div class="rn-before" id="yuki-26.0-to-27.0-before">

### Before You Upgrade

No change of this step is marked as breaking.

</div>

<a id="yuki-26.0-to-27.0-top"></a>

### Top 14 Changes

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

<div class="rn-top">

1. [Concurrent reads of Yuki domains could return data of the wrong domain](#YKI-27.0-B001)
   - *Bug fixes*
   - Importance 4 of 5.
2. [Many more Yuki operations, columns and views, with paging and sorting](#YKI-27.0-E001)
   - *Enhancements*
   - Importance 4 of 5.
3. [Cache lifetime of Yuki answers follows the settings of the session](#YKI-27.0-B002)
   - *Bug fixes*
   - Importance 3 of 5.
4. [XML answers of Yuki are no longer read with external entity resolution (security)](#YKI-27.0-B003)
   - *Bug fixes*
   - Importance 3 of 5.
5. [Table Yuki.General.Companies is added](#YKI-27.0-D003)
   - *Data model*
   - Importance 3 of 5.
6. [Table Yuki.General.SupportedLanguages is added](#YKI-27.0-D004)
   - *Data model*
   - Importance 3 of 5.
7. [Yuki.Accounting.OutstandingCreditorItems: table parameters changes](#YKI-27.0-D005)
   - *Data model*
   - Importance 3 of 5.
8. [Yuki.Accounting.OutstandingCreditorItemsByDate: table parameters changes](#YKI-27.0-D006)
   - *Data model*
   - Importance 3 of 5.
9. [Table function Yuki.Accounting.OutstandingCreditorItemsByDateOutstanding is added](#YKI-27.0-D007)
   - *Data model*
   - Importance 3 of 5.
10. [Table function Yuki.Accounting.OutstandingCreditorItemsWithPaymentReference is added](#YKI-27.0-D008)
    - *Data model*
    - Importance 3 of 5.
11. [Yuki.Accounting.OutstandingDebtorItems: table parameters changes](#YKI-27.0-D009)
    - *Data model*
    - Importance 3 of 5.
12. [Yuki.Accounting.OutstandingDebtorItemsByDate: table parameters changes](#YKI-27.0-D010)
    - *Data model*
    - Importance 3 of 5.
13. [Statements on Yuki can be cancelled while rows are read](#YKI-27.0-E002)
    - *Enhancements*
    - Importance 2 of 5.
14. [Throughput figures of Yuki calls included](#YKI-27.0-E003)
    - *Enhancements*
    - Importance 2 of 5.

</div>

<a id="yuki-26.0-to-27.0-g-data_model"></a>

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

<div class="rn-chips">

- 148 changes
- model files

</div>

#### Tables, Views and Table Functions

<div class="rn-item" id="YKI-27.0-D003">

##### Table Yuki.General.Companies is added

The table has 5 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D004">

##### Table Yuki.General.SupportedLanguages is added

The table has 5 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D007">

##### Table function Yuki.Accounting.OutstandingCreditorItemsByDateOutstanding is added

The table function has 33 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D008">

##### Table function Yuki.Accounting.OutstandingCreditorItemsWithPaymentReference is added

The table function has 33 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D011">

##### Table function Yuki.Accounting.OutstandingDebtorItemsByDateOutstanding is added

The table function has 33 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D012">

##### Table function Yuki.Accounting.OutstandingDebtorItemsWithLanguage is added

The table function has 33 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D013">

##### Table function Yuki.Accounting.OutstandingDebtorItemsWithPaymentReference is added

The table function has 33 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D014">

##### Table function Yuki.AccountingInfo.ContactDefaultValuesByContactId is added

The table function has 17 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D015">

##### Table function Yuki.AccountingInfo.CustomPaymentMethods is added

The table function has 6 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D016">

##### Table function Yuki.AccountingInfo.FinancialYearModifiedDatesByYear is added

The table function has 5 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D017">

##### Table function Yuki.AccountingInfo.TransactionsByPeriod is added

The table function has 42 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D018">

##### Table function Yuki.Archive.ArchiveProjects is added

The table function has 6 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D019">

##### Table function Yuki.Archive.DocumentDownloadUrlByDocumentId is added

The table function has 3 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D020">

##### Table function Yuki.Archive.DocumentXmlDataByDocumentId is added

The table function has 3 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D025">

##### Table function Yuki.Archive.DocumentsByType is added

The table function has 23 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D026">

##### Table function Yuki.Archive.ModifiedDocumentsByFolderId is added

The table function has 23 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D027">

##### Table function Yuki.Archive.ModifiedDocumentsByType is added

The table function has 23 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D029">

##### Table function Yuki.Contact.SuppliersAndCustomersByDomainId is added

The table function has 33 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D030">

##### Table function Yuki.Domains.DomainFunctionsByDomainId is added

The table function has 6 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D031">

##### Table function Yuki.Purchase.PurchaseInvoiceSchemas is added

The table function has 5 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D032">

##### Table function Yuki.Sales.SalesItems is added

The table function has 6 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D033">

##### Table function Yuki.Vat.ActiveVatCodes is added

The table function has 11 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D034">

##### Table function Yuki.Vat.VatReturnsByYear is added

The table function has 11 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D035">

##### View Yuki.Views.DocumentFolderTabs is added

The view has 11 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D036">

##### View Yuki.Views.DomainFunctions is added

The view has 11 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D037">

##### View Yuki.Views.SuppliersAndCustomers is added

The view has 38 columns and can select.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D005">

##### Yuki.Accounting.OutstandingCreditorItems: table parameters changes

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

<div class="rn-chips">

- `administrationID, includeBankTransactions` &rarr; `administrationID, includeBankTransactions, sortOrder`
- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D006">

##### Yuki.Accounting.OutstandingCreditorItemsByDate: table parameters changes

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

<div class="rn-chips">

- `administrationID, includeBankTransactions, startDate, endDate` &rarr; `administrationID, includeBankTransactions, startDate, endDate, sortOrder`
- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D009">

##### Yuki.Accounting.OutstandingDebtorItems: table parameters changes

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

<div class="rn-chips">

- `administrationID, includeBankTransactions` &rarr; `administrationID, includeBankTransactions, sortOrder`
- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D010">

##### Yuki.Accounting.OutstandingDebtorItemsByDate: table parameters changes

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

<div class="rn-chips">

- `administrationID, includeBankTransactions, startDate, endDate` &rarr; `administrationID, includeBankTransactions, startDate, endDate, sortOrder`
- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D021">

##### Yuki.Archive.Documents: table parameters changes

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

<div class="rn-chips">

- `startDate, endDate` &rarr; `startDate, endDate, sortOrder`
- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D022">

##### Yuki.Archive.DocumentsByFolderId: table parameters changes

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

<div class="rn-chips">

- `folderID, startDate, endDate` &rarr; `folderID, startDate, endDate, sortOrder`
- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D023">

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

<div class="rn-chips">

- `documentID, searchOption, searchText, folderID, tabID, startDate, endDate` &rarr; `documentID, searchOption, searchText, folderID, tabID, startDate, endDate, sortOrder`
- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D024">

##### Yuki.Archive.DocumentsByTabId: table parameters changes

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

<div class="rn-chips">

- `tabID, startDate, endDate` &rarr; `tabID, startDate, endDate, sortOrder`
- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D028">

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

<div class="rn-chips">

- `domainId, searchOption, searchValue, modifiedAfter, active` &rarr; `domainId, searchOption, searchValue, modifiedAfter, active, sortOrder`
- importance 3

</div>

</div>

#### Columns

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

<a id="YKI-27.0-D038"></a><a id="YKI-27.0-D039"></a><a id="YKI-27.0-D040"></a>

<details>
<summary>

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

</summary>

- `+` `DEDUCTABLEVATPERCENTAGE` (`decimal`)
- `+` `ISVATAPPLICABLE` (`char`)
- `+` `PROFESSIONALPERCENTAGE` (`decimal`)

</details>

<a id="YKI-27.0-D041"></a><a id="YKI-27.0-D042"></a><a id="YKI-27.0-D043"></a>

<details>
<summary>

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

</summary>

- `+` `PAYMENTID` (`varchar2`)
- `+` `PAYMENTREFERENCE` (`varchar2`)
- `+` `VATAMOUNT` (`decimal`)

</details>

<a id="YKI-27.0-D044"></a><a id="YKI-27.0-D045"></a><a id="YKI-27.0-D046"></a>

<details>
<summary>

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

</summary>

- `+` `PAYMENTID` (`varchar2`)
- `+` `PAYMENTREFERENCE` (`varchar2`)
- `+` `VATAMOUNT` (`decimal`)

</details>

<a id="YKI-27.0-D047"></a><a id="YKI-27.0-D048"></a><a id="YKI-27.0-D049"></a>

<details>
<summary>

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

</summary>

- `+` `PAYMENTID` (`varchar2`)
- `+` `PAYMENTREFERENCE` (`varchar2`)
- `+` `VATAMOUNT` (`decimal`)

</details>

<a id="YKI-27.0-D050"></a><a id="YKI-27.0-D051"></a><a id="YKI-27.0-D052"></a>

<details>
<summary>

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

</summary>

- `+` `PAYMENTID` (`varchar2`)
- `+` `PAYMENTREFERENCE` (`varchar2`)
- `+` `VATAMOUNT` (`decimal`)

</details>

<a id="YKI-27.0-D053"></a><a id="YKI-27.0-D054"></a><a id="YKI-27.0-D055"></a>

<details>
<summary>

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

</summary>

- `+` `PAYMENTID` (`varchar2`)
- `+` `PAYMENTREFERENCE` (`varchar2`)
- `+` `VATAMOUNT` (`decimal`)

</details>

<a id="YKI-27.0-D056"></a><a id="YKI-27.0-D057"></a><a id="YKI-27.0-D058"></a><a id="YKI-27.0-D059"></a><a id="YKI-27.0-D060"></a><a id="YKI-27.0-D061"></a><a id="YKI-27.0-D062"></a><a id="YKI-27.0-D063"></a><a id="YKI-27.0-D064"></a><a id="YKI-27.0-D065"></a><a id="YKI-27.0-D066"></a><a id="YKI-27.0-D067"></a><a id="YKI-27.0-D068"></a><a id="YKI-27.0-D069"></a><a id="YKI-27.0-D070"></a><a id="YKI-27.0-D071"></a><a id="YKI-27.0-D072"></a><a id="YKI-27.0-D073"></a><a id="YKI-27.0-D074"></a><a id="YKI-27.0-D075"></a><a id="YKI-27.0-D076"></a><a id="YKI-27.0-D077"></a><a id="YKI-27.0-D078"></a><a id="YKI-27.0-D079"></a><a id="YKI-27.0-D080"></a><a id="YKI-27.0-D081"></a><a id="YKI-27.0-D082"></a><a id="YKI-27.0-D083"></a><a id="YKI-27.0-D084"></a><a id="YKI-27.0-D085"></a><a id="YKI-27.0-D086"></a><a id="YKI-27.0-D087"></a><a id="YKI-27.0-D088"></a><a id="YKI-27.0-D089"></a><a id="YKI-27.0-D090"></a>

<details>
<summary>

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

</summary>

- `+` `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`)

</details>

<a id="YKI-27.0-D091"></a><a id="YKI-27.0-D092"></a>

<details>
<summary>

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

</summary>

- `+` `ACTIVE` (`char`)
- `+` `ADDRESSLINE2` (`varchar2`)

</details>

<a id="YKI-27.0-D093"></a><a id="YKI-27.0-D094"></a>

<details>
<summary>

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

</summary>

- `+` `STATUS` (`varchar2`)
- `+` `STATUSID` (`varchar2`)

</details>

<a id="YKI-27.0-D147"></a><a id="YKI-27.0-D148"></a>

<details>
<summary>

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

</summary>

- `~` `DURATION_MS` (`database_data_type`: `int64` &rarr; `double`)
- `~` `DURATION_MS` (`dotnet_data_type`: `int64` &rarr; `double`)

</details>

<a id="YKI-27.0-D095"></a><a id="YKI-27.0-D096"></a><a id="YKI-27.0-D097"></a><a id="YKI-27.0-D098"></a><a id="YKI-27.0-D099"></a><a id="YKI-27.0-D100"></a><a id="YKI-27.0-D101"></a><a id="YKI-27.0-D102"></a><a id="YKI-27.0-D103"></a><a id="YKI-27.0-D104"></a><a id="YKI-27.0-D105"></a><a id="YKI-27.0-D106"></a><a id="YKI-27.0-D107"></a><a id="YKI-27.0-D108"></a><a id="YKI-27.0-D109"></a><a id="YKI-27.0-D110"></a><a id="YKI-27.0-D111"></a><a id="YKI-27.0-D112"></a><a id="YKI-27.0-D113"></a><a id="YKI-27.0-D114"></a><a id="YKI-27.0-D115"></a><a id="YKI-27.0-D116"></a><a id="YKI-27.0-D117"></a><a id="YKI-27.0-D118"></a><a id="YKI-27.0-D119"></a><a id="YKI-27.0-D120"></a><a id="YKI-27.0-D121"></a><a id="YKI-27.0-D122"></a><a id="YKI-27.0-D123"></a><a id="YKI-27.0-D124"></a><a id="YKI-27.0-D125"></a><a id="YKI-27.0-D126"></a><a id="YKI-27.0-D127"></a><a id="YKI-27.0-D128"></a><a id="YKI-27.0-D129"></a><a id="YKI-27.0-D130"></a><a id="YKI-27.0-D131"></a><a id="YKI-27.0-D132"></a><a id="YKI-27.0-D133"></a>

<details>
<summary>

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

</summary>

- `+` `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`)

</details>

<a id="YKI-27.0-D134"></a><a id="YKI-27.0-D135"></a><a id="YKI-27.0-D136"></a><a id="YKI-27.0-D137"></a>

<details>
<summary>

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

</summary>

- `+` `DOMAINNAME` (`varchar2`)
- `+` `DOMAINNAME2` (`varchar2`)
- `+` `domain_STATUS` (`varchar2`)
- `+` `domain_STATUSID` (`varchar2`)

</details>

#### Parameters, Packages and Procedures, Keys and Code Values

<div class="rn-item" id="YKI-27.0-D001">

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

<div class="rn-chips">

- `false` &rarr; `true`
- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D002">

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

<div class="rn-chips">

- `false` &rarr; `true`
- importance 3

</div>

</div>

<div class="rn-item" id="YKI-27.0-D138">

##### Parameter sortOrder is added to Yuki.Accounting.OutstandingCreditorItems

Optional.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="YKI-27.0-D139">

##### Parameter sortOrder is added to Yuki.Accounting.OutstandingCreditorItemsByDate

Optional.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="YKI-27.0-D140">

##### Parameter sortOrder is added to Yuki.Accounting.OutstandingDebtorItems

Optional.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="YKI-27.0-D141">

##### Parameter sortOrder is added to Yuki.Accounting.OutstandingDebtorItemsByDate

Optional.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="YKI-27.0-D142">

##### Parameter sortOrder is added to Yuki.Archive.Documents

Optional.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="YKI-27.0-D143">

##### Parameter sortOrder is added to Yuki.Archive.DocumentsByFolderId

Optional.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="YKI-27.0-D144">

##### Parameter sortOrder is added to Yuki.Archive.DocumentsBySearchCriteria

Optional.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="YKI-27.0-D145">

##### Parameter sortOrder is added to Yuki.Archive.DocumentsByTabId

Optional.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="YKI-27.0-D146">

##### Parameter sortOrder is added to Yuki.Contact.ContactsByDomainId

Optional.

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="yuki-26.0-to-27.0-g-provider_attributes"></a>

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

<div class="rn-chips">

- 1 changes
- model files

</div>

<div class="rn-item" id="YKI-27.0-A001">

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

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="yuki-26.0-to-27.0-g-capabilities"></a>

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

<div class="rn-chips">

- 0 changes
- model files

</div>

No changes in this group.

<a id="yuki-26.0-to-27.0-g-performance"></a>

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

<div class="rn-chips">

- 0 changes
- commits

</div>

No changes in this group.

<a id="yuki-26.0-to-27.0-g-bug_fixes"></a>

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

<div class="rn-chips">

- 3 changes
- commits

</div>

<div class="rn-item" id="YKI-27.0-B001">

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

<div class="rn-chips">

- importance 4
- confidence medium

</div>

</div>

<div class="rn-item" id="YKI-27.0-B002">

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

<div class="rn-chips">

- importance 3
- confidence medium

</div>

</div>

<div class="rn-item" id="YKI-27.0-B003">

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

<div class="rn-chips">

- importance 3
- confidence high

</div>

</div>

<a id="yuki-26.0-to-27.0-g-enhancements"></a>

### Enhancements

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

<div class="rn-chips">

- 3 changes
- commits

</div>

<div class="rn-item" id="YKI-27.0-E001">

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

<div class="rn-chips">

- importance 4
- confidence medium

</div>

</div>

<div class="rn-item" id="YKI-27.0-E002">

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

<div class="rn-chips">

- importance 2
- confidence medium

</div>

</div>

<div class="rn-item" id="YKI-27.0-E003">

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

<div class="rn-chips">

- importance 2
- confidence medium

</div>

</div>

<a id="yuki-26.0-to-27.0-g-authentication_platform"></a>

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

<div class="rn-chips">

- 0 changes
- commits

</div>

No changes in this group.

<a id="yuki-26.0-to-27.0-numbers"></a>

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

<a id="yuki-26.0-to-27.0-more"></a>

### More Information

- [Data model documentation of the driver](https://documentation.invantive.com/)
- [Questions and answers on the forum](https://forums.invantive.com/tag/yuki)
- [Invantive Cloud page of the driver](https://cloud.invantive.com/yuki)
- [Documentation of the platform](http://help.yuki.nl/documents/homepage/startpagina-yuki-api-documentatie)
- [All release notes](https://go.invantive.com/releasenotes/)

### How This Note Was Made

<div class="rn-small">

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

</div>

</div>

</div>

</div>

