Release notes of Twinfield
Driver Release Note - Cloud
Twinfield 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.
- 340 changes
- 2 can break a statement
- 0 groups not available
This Note
Groups
- Data model 325
- Provider attributes 3
- Capabilities 0
- Performance 3
- Bug fixes 3
- Enhancements 3
- Log-on and platform 3
More
What Changed, by Group
Every change is in one group: the group answers the question that you ask before you upgrade.
- Data model
- 325
- Do my statements and views still work?
- Provider attributes
- 3
- 1 can break a statement
- Do I have to change my connection string, provider file or settings?
- Capabilities
- 0
- What can the driver do with a table?
- Performance
- 3
- Is it faster, and does it call the platform less?
- Bug fixes
- 3
- Is the defect that I met repaired?
- Enhancements
- 3
- 1 can break a statement
- What can I do now that I could not?
- Log-on and platform
- 3
- Do I have to log on again, or change something because of the platform?
Before You Upgrade
These changes can stop an existing statement, view, connection string or script from working:
- Attribute transaction-tables-page-size is removed
- Check statements, views and scripts that use it before the upgrade.
- Twinfield page size is set with the general requested page size attribute
- Remove the transaction-tables-page-size attribute from connection strings and provider files and use requested-page-size instead. A connection that still sets it is rejected.
Top 22 Changes
Changes that can break a statement first, then by importance. Columns are summarised per table in the data model.
- Twinfield page size is set with the general requested page size attribute
- Enhancements
- Breaks an existing statement or script.
- Attribute transaction-tables-page-size is removed
- Provider attributes
- Breaks an existing statement or script.
- Counts and code filters on Twinfield master data are answered by Twinfield
- Performance
- Importance 4 of 5.
- Large Twinfield transaction tables are read in smaller calls; counts need no rows
- Performance
- Importance 4 of 5.
- Queries on Twinfield transaction tables ask for fewer columns and stop at a row limit
- Performance
- Importance 4 of 5.
- Twinfield calls move off the retired compressed XML method
- Log-on and platform
- Importance 4 of 5.
- Own Twinfield client IDs are no longer blocked by the office check
- Bug fixes
- Importance 3 of 5.
- Twinfield answers are read without processing DTDs
- Bug fixes
- Importance 3 of 5.
- Wrapped OAuth errors from Twinfield lead to a new log-on attempt
- Bug fixes
- Importance 3 of 5.
- Table Twinfield.Twinfield.IctCountries is added
- Data model
- Importance 3 of 5.
- Table Twinfield.Twinfield.PlatformVersion is added
- Data model
- Importance 3 of 5.
- Table function Twinfield.Settings.ArticleLinesByCode is added
- Data model
- Importance 3 of 5.
- Table function Twinfield.Settings.ArticleSettingsByCode is added
- Data model
- Importance 3 of 5.
- Table function Twinfield.Settings.OfficeSettingsByCode is added
- Data model
- Importance 3 of 5.
- Table function Twinfield.Settings.PaymentTypeSettingsByCode is added
- Data model
- Importance 3 of 5.
- Table function Twinfield.Settings.ProjectRateChangesByCode is added
- Data model
- Importance 3 of 5.
- Table function Twinfield.Settings.ProjectRateSettingsByCode is added
- Data model
- Importance 3 of 5.
- Driver setting technical documentation url changes
- Provider attributes
- Importance 3 of 5.
- A cancelled statement stops Twinfield retrieval sooner
- Enhancements
- Importance 2 of 5.
- A setting allows extra Twinfield offices beyond the built-in list
- Enhancements
- Importance 2 of 5.
- Incomplete Twinfield log-on answers are reported with a clear message
- Log-on and platform
- Importance 2 of 5.
- More Twinfield offices can be used with the Invantive client ID
- Log-on and platform
- 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.
- 325 changes
- model files
Tables, Views and Table Functions
Table Twinfield.Twinfield.IctCountries is added
The table has 4 columns and can select.
- importance 3
Table Twinfield.Twinfield.PlatformVersion is added
The table has 1 columns and can select.
- importance 3
Table function Twinfield.Settings.ArticleLinesByCode is added
The table function has 11 columns and can select.
- importance 3
Table function Twinfield.Settings.ArticleSettingsByCode is added
The table function has 18 columns and can select.
- importance 3
Table function Twinfield.Settings.OfficeSettingsByCode is added
The table function has 47 columns and can select.
- importance 3
Table function Twinfield.Settings.PaymentTypeSettingsByCode is added
The table function has 23 columns and can select.
- importance 3
Table function Twinfield.Settings.ProjectRateChangesByCode is added
The table function has 8 columns and can select.
- importance 3
Table function Twinfield.Settings.ProjectRateSettingsByCode is added
The table function has 15 columns and can select.
- importance 3
Table function Twinfield.Settings.SalesInvoiceByNumber is added
The table function has 18 columns and can select.
- importance 3
Table function Twinfield.Settings.SalesInvoiceLinesByNumber is added
The table function has 21 columns and can select.
- importance 3
Table function Twinfield.Settings.SalesInvoiceVatLinesByNumber is added
The table function has 8 columns and can select.
- importance 3
Table function Twinfield.Settings.TransactionByNumber is added
The table function has 21 columns and can select.
- importance 3
Table function Twinfield.Settings.TransactionLinesByNumber is added
The table function has 31 columns and can select.
- importance 3
Table function Twinfield.Settings.UserSettingsByUserCode is added
The table function has 35 columns and can select.
- importance 3
Table function Twinfield.Settings.VatCodePercentagesByCode is added
The table function has 6 columns and can select.
- importance 3
Table function Twinfield.Settings.VatCodeSettingsByCode is added
The table function has 14 columns and can select.
- importance 3
Table function Twinfield.Twinfield.BankBookByCode is added
The table function has 5 columns and can select.
- importance 3
Table function Twinfield.Twinfield.BankStatementLinesByStatementDate is added
The table function has 17 columns and can select.
- importance 3
Table function Twinfield.Twinfield.BankStatementsByStatementDate is added
The table function has 12 columns and can select.
- importance 3
Table function Twinfield.Twinfield.CashBookByCode is added
The table function has 5 columns and can select.
- importance 3
Table function Twinfield.Twinfield.DeclarationsByYear is added
The table function has 12 columns and can select.
- importance 3
Table function Twinfield.Twinfield.DeclarationsByYearSinceModified is added
The table function has 12 columns and can select.
- importance 3
Table function Twinfield.Twinfield.DeclarationsSinceModified is added
The table function has 12 columns and can select.
- importance 3
Table function Twinfield.Twinfield.PayAndCollectRunById is added
The table function has 17 columns and can select.
- importance 3
Table function Twinfield.Twinfield.PayAndCollectRuns is added
The table function has 17 columns and can select.
- importance 3
Table function Twinfield.Twinfield.PeriodYears is added
The table function has 3 columns and can select.
- importance 3
Table function Twinfield.Twinfield.PeriodsByYear is added
The table function has 6 columns and can select.
- importance 3
View Twinfield.CodeValues.AccessTypes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.AddressTypes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.ArticleTypes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.AssetCalculationMethods is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.AssetStatuses is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.BankTransactionTypeFilters is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.BrowseCodes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.BrowseOperators is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.BrowseSortOrders is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.CollectionSchemas is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.Cultures is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.DebitCredits is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.DepreciationStartMoments is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.DimensionBehaviours is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.DimensionLevels is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.DimensionStatuses is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.DimensionTypeCodes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.FinderSearchFields is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.FinderTypeCodes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.FreeTextTypes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.InvitationStatuses is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.ItemValueVatInclusions is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.MatchStatuses is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.MatchTypes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.MatchingTypeCodes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.MeansOfPayment is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.PayAddresses is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.PerformanceTypes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.RateTypes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.SalesInvoicePaymentMethods is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.SalesInvoiceStatuses is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.SendReminders is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.SendTypes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.SepaDirectDebitSchemes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.SingleSignOnSettings is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.SmsLogonServices is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.SubAnalyses is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.SubscriptionChangeReasons is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.SubstitutionLevels is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.SubstitutionTypes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.TemplateCompanyAccesses is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.TimeEntryTypes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.TimeTransactionCodes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.TransactionLineTypes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.TransactionStatuses is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.UserTypes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.VatCodeLineTypes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.VatCodeTypes is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.WaysOfPayment is added
The view has 4 columns and can select.
- importance 3
View Twinfield.CodeValues.WordTemplateKinds is added
The view has 4 columns and can select.
- importance 3
View Twinfield.Views.ArticleLines is added
The view has 13 columns and can select.
- importance 3
View Twinfield.Views.ArticleSettings is added
The view has 18 columns and can select.
- importance 3
View Twinfield.Views.OfficeSettings is added
The view has 47 columns and can select.
- importance 3
View Twinfield.Views.PaymentTypeSettings is added
The view has 23 columns and can select.
- importance 3
View Twinfield.Views.Periods is added
The view has 7 columns and can select.
- importance 3
View Twinfield.Views.ProjectRateChanges is added
The view has 10 columns and can select.
- importance 3
View Twinfield.Views.ProjectRateSettings is added
The view has 15 columns and can select.
- importance 3
View Twinfield.Views.UserSettings is added
The view has 35 columns and can select.
- importance 3
View Twinfield.Views.VatCodePercentages is added
The view has 8 columns and can select.
- importance 3
View Twinfield.Views.VatCodeSettings is added
The view has 14 columns and can select.
- importance 3
Columns
0 added, 0 removed, 2 changed, in 1 tables.
Twinfield.Native.NATIVEPLATFORMSCALARREQUESTS: 0 added, 0 removed, 2 changed
Twinfield.Native.NATIVEPLATFORMSCALARREQUESTS: 0 added, 0 removed, 2 changed~DURATION_MS(database_data_type:int64→double)~DURATION_MS(dotnet_data_type:int64→double)
Parameters, Packages and Procedures, Keys and Code Values
Parameter hierarchy of Twinfield.Twinfield.HierarchyNodes: presence required changes
Presence required changes from false to true. Without the parameter Twinfield answered no rows, so a statement without it never returned data.
false→true- importance 3
Code value is added: AccessTypes / bind
- importance 2
Code value is added: AccessTypes / edit
- importance 2
Code value is added: AccessTypes / use
- importance 2
Code value is added: AddressTypes / contact
- importance 2
Code value is added: AddressTypes / invoice
- importance 2
Code value is added: AddressTypes / postal
- importance 2
Code value is added: ArticleTypes / discount
- importance 2
Code value is added: ArticleTypes / normal
- importance 2
Code value is added: ArticleTypes / premium
- importance 2
Code value is added: AssetCalculationMethods / linear
- importance 2
Code value is added: AssetCalculationMethods / linearpercentage
- importance 2
Code value is added: AssetCalculationMethods / none
- importance 2
Code value is added: AssetCalculationMethods / reducebalance
- importance 2
Code value is added: AssetStatuses / Active
- importance 2
Code value is added: AssetStatuses / Inactive
- importance 2
Code value is added: AssetStatuses / Sold
- importance 2
Code value is added: AssetStatuses / ToBeActivated
- importance 2
Code value is added: BankTransactionTypeFilters / -1
- importance 2
Code value is added: BankTransactionTypeFilters / 0
- importance 2
Code value is added: BankTransactionTypeFilters / 1
- importance 2
Code value is added: BrowseCodes / 000
- importance 2
Code value is added: BrowseCodes / 010
- importance 2
Code value is added: BrowseCodes / 020
- importance 2
Code value is added: BrowseCodes / 030_1
- importance 2
Code value is added: BrowseCodes / 030_2
- importance 2
Code value is added: BrowseCodes / 030_3
- importance 2
Code value is added: BrowseCodes / 031
- importance 2
Code value is added: BrowseCodes / 031_2
- importance 2
Code value is added: BrowseCodes / 040_1
- importance 2
Code value is added: BrowseCodes / 050_1
- importance 2
Code value is added: BrowseCodes / 060
- importance 2
Code value is added: BrowseCodes / 100
- importance 2
Code value is added: BrowseCodes / 130_1
- importance 2
Code value is added: BrowseCodes / 130_2
- importance 2
Code value is added: BrowseCodes / 130_3
- importance 2
Code value is added: BrowseCodes / 164
- importance 2
Code value is added: BrowseCodes / 200
- importance 2
Code value is added: BrowseCodes / 230_1
- importance 2
Code value is added: BrowseCodes / 230_2
- importance 2
Code value is added: BrowseCodes / 300
- importance 2
Code value is added: BrowseCodes / 301
- importance 2
Code value is added: BrowseCodes / 302_1
- importance 2
Code value is added: BrowseCodes / 400
- importance 2
Code value is added: BrowseCodes / 410
- importance 2
Code value is added: BrowseCodes / 610_1
- importance 2
Code value is added: BrowseCodes / 620
- importance 2
Code value is added: BrowseCodes / 650_1
- importance 2
Code value is added: BrowseCodes / 651_1
- importance 2
Code value is added: BrowseCodes / 652_1
- importance 2
Code value is added: BrowseCodes / 660_1
- importance 2
Code value is added: BrowseCodes / 661_1
- importance 2
Code value is added: BrowseCodes / 662_1
- importance 2
Code value is added: BrowseCodes / 670
- importance 2
Code value is added: BrowseCodes / 680
- importance 2
Code value is added: BrowseCodes / 680_2
- importance 2
Code value is added: BrowseCodes / 690
- importance 2
Code value is added: BrowseCodes / 700
- importance 2
Code value is added: BrowseCodes / 900
- importance 2
Code value is added: BrowseOperators / between
- importance 2
Code value is added: BrowseOperators / equal
- importance 2
Code value is added: BrowseOperators / none
- importance 2
Code value is added: BrowseSortOrders / ascending
- importance 2
Code value is added: BrowseSortOrders / descending
- importance 2
Code value is added: CollectionSchemas / b2b
- importance 2
Code value is added: CollectionSchemas / core
- importance 2
Code value is added: Cultures / cs-CZ
- importance 2
Code value is added: Cultures / da-DK
- importance 2
Code value is added: Cultures / de-DE
- importance 2
Code value is added: Cultures / en-GB
- importance 2
Code value is added: Cultures / fr-FR
- importance 2
Code value is added: Cultures / hu-HU
- importance 2
Code value is added: Cultures / nl-NL
- importance 2
Code value is added: DebitCredits / credit
- importance 2
Code value is added: DebitCredits / debit
- importance 2
Code value is added: DepreciationStartMoments / from_purchase_date
- importance 2
Code value is added: DepreciationStartMoments / from_reconciliation
- importance 2
Code value is added: DimensionBehaviours / normal
- importance 2
Code value is added: DimensionBehaviours / system
- importance 2
Code value is added: DimensionBehaviours / template
- importance 2
Code value is added: DimensionLevels / 1
- importance 2
Code value is added: DimensionLevels / 2
- importance 2
Code value is added: DimensionLevels / 3
- importance 2
Code value is added: DimensionLevels / 4
- importance 2
Code value is added: DimensionLevels / 5
- importance 2
Code value is added: DimensionLevels / 6
- importance 2
Code value is added: DimensionStatuses / active
- importance 2
Code value is added: DimensionStatuses / deleted
- importance 2
Code value is added: DimensionStatuses / hide
- importance 2
Code value is added: DimensionTypeCodes / ACT
- importance 2
Code value is added: DimensionTypeCodes / AST
- importance 2
Code value is added: DimensionTypeCodes / BAS
- importance 2
Code value is added: DimensionTypeCodes / CRD
- importance 2
Code value is added: DimensionTypeCodes / DEB
- importance 2
Code value is added: DimensionTypeCodes / KPL
- importance 2
Code value is added: DimensionTypeCodes / PNL
- importance 2
Code value is added: DimensionTypeCodes / PRJ
- importance 2
Code value is added: FinderSearchFields / 0
- importance 2
Code value is added: FinderSearchFields / 1
- importance 2
Code value is added: FinderSearchFields / 2
- importance 2
Code value is added: FinderSearchFields / 3
- importance 2
Code value is added: FinderTypeCodes / ART
- importance 2
Code value is added: FinderTypeCodes / ASM
- importance 2
Code value is added: FinderTypeCodes / BDS
- importance 2
Code value is added: FinderTypeCodes / BNK
- importance 2
Code value is added: FinderTypeCodes / BSN
- importance 2
Code value is added: FinderTypeCodes / CDA
- importance 2
Code value is added: FinderTypeCodes / CER
- importance 2
Code value is added: FinderTypeCodes / CQT
- importance 2
Code value is added: FinderTypeCodes / CTR
- importance 2
Code value is added: FinderTypeCodes / CUR
- importance 2
Code value is added: FinderTypeCodes / DIM
- importance 2
Code value is added: FinderTypeCodes / DMT
- importance 2
Code value is added: FinderTypeCodes / DVT
- importance 2
Code value is added: FinderTypeCodes / FLT
- importance 2
Code value is added: FinderTypeCodes / FMT
- importance 2
Code value is added: FinderTypeCodes / GRP
- importance 2
Code value is added: FinderTypeCodes / GWY
- importance 2
Code value is added: FinderTypeCodes / HIE
- importance 2
Code value is added: FinderTypeCodes / HND
- importance 2
Code value is added: FinderTypeCodes / ICTCOUNTRY
- importance 2
Code value is added: FinderTypeCodes / INV
- importance 2
Code value is added: FinderTypeCodes / IVT
- importance 2
Code value is added: FinderTypeCodes / MAT
- importance 2
Code value is added: FinderTypeCodes / OFF
- importance 2
Code value is added: FinderTypeCodes / OFG
- importance 2
Code value is added: FinderTypeCodes / OIC
- importance 2
Code value is added: FinderTypeCodes / PAY
- importance 2
Code value is added: FinderTypeCodes / PIS
- importance 2
Code value is added: FinderTypeCodes / PRD
- importance 2
Code value is added: FinderTypeCodes / REP
- importance 2
Code value is added: FinderTypeCodes / REW
- importance 2
Code value is added: FinderTypeCodes / RMD
- importance 2
Code value is added: FinderTypeCodes / ROL
- importance 2
Code value is added: FinderTypeCodes / SAR
- importance 2
Code value is added: FinderTypeCodes / SPM
- importance 2
Code value is added: FinderTypeCodes / TEQ
- importance 2
Code value is added: FinderTypeCodes / TRS
- importance 2
Code value is added: FinderTypeCodes / TRT
- importance 2
Code value is added: FinderTypeCodes / TXG
- importance 2
Code value is added: FinderTypeCodes / USR
- importance 2
Code value is added: FinderTypeCodes / VAT
- importance 2
Code value is added: FinderTypeCodes / VATN
- importance 2
Code value is added: FinderTypeCodes / VGM
- importance 2
Code value is added: FinderTypeCodes / VTB
- importance 2
Code value is added: FinderTypeCodes / XLT
- importance 2
Code value is added: FreeTextTypes / amount
- importance 2
Code value is added: FreeTextTypes / text
- importance 2
Code value is added: InvitationStatuses / Active
- importance 2
Code value is added: InvitationStatuses / Invited
- importance 2
Code value is added: InvitationStatuses / NotInvited
- importance 2
Code value is added: ItemValueVatInclusions / exclusive
- importance 2
Code value is added: ItemValueVatInclusions / inclusive
- importance 2
Code value is added: MatchStatuses / available
- importance 2
Code value is added: MatchStatuses / matched
- importance 2
Code value is added: MatchStatuses / notmatchable
- importance 2
Code value is added: MatchStatuses / proposed
- importance 2
Code value is added: MatchTypes / matchable
- importance 2
Code value is added: MatchTypes / notmatchable
- importance 2
Code value is added: MatchTypes / relation
- importance 2
Code value is added: MatchingTypeCodes / 070
- importance 2
Code value is added: MatchingTypeCodes / 170
- importance 2
Code value is added: MatchingTypeCodes / 270
- importance 2
Code value is added: MatchingTypeCodes / 370
- importance 2
Code value is added: MeansOfPayment / cheques
- importance 2
Code value is added: MeansOfPayment / none
- importance 2
Code value is added: MeansOfPayment / paymentfile
- importance 2
Code value is added: PayAddresses / 1
- importance 2
Code value is added: PayAddresses / 2
- importance 2
Code value is added: PayAddresses / 3
- importance 2
Code value is added: PerformanceTypes / goods
- importance 2
Code value is added: PerformanceTypes / services
- importance 2
Code value is added: RateTypes / quantity
- importance 2
Code value is added: RateTypes / time
- importance 2
Code value is added: SalesInvoicePaymentMethods / bank
- importance 2
Code value is added: SalesInvoicePaymentMethods / cash
- importance 2
Code value is added: SalesInvoicePaymentMethods / cashondelivery
- importance 2
Code value is added: SalesInvoicePaymentMethods / cheque
- importance 2
Code value is added: SalesInvoicePaymentMethods / da
- importance 2
Code value is added: SalesInvoiceStatuses / concept
- importance 2
Code value is added: SalesInvoiceStatuses / default
- importance 2
Code value is added: SalesInvoiceStatuses / final
- importance 2
Code value is added: SendReminders / email
- importance 2
Code value is added: SendReminders / false
- importance 2
Code value is added: SendReminders / true
- importance 2
Code value is added: SendTypes / ByEmail
- importance 2
Code value is added: SendTypes / ToFileManager
- importance 2
Code value is added: SepaDirectDebitSchemes / 0
- importance 2
Code value is added: SepaDirectDebitSchemes / 1
- importance 2
Code value is added: SingleSignOnSettings / 0
- importance 2
Code value is added: SingleSignOnSettings / 1
- importance 2
Code value is added: SingleSignOnSettings / 2
- importance 2
Code value is added: SmsLogonServices / 0
- importance 2
Code value is added: SmsLogonServices / 1
- importance 2
Code value is added: SubAnalyses / false
- importance 2
Code value is added: SubAnalyses / maybe
- importance 2
Code value is added: SubAnalyses / true
- importance 2
Code value is added: SubscriptionChangeReasons / changetwfsubscription
- importance 2
Code value is added: SubscriptionChangeReasons / defaulting
- importance 2
Code value is added: SubscriptionChangeReasons / nolongeroperative
- importance 2
Code value is added: SubscriptionChangeReasons / pricingnew
- importance 2
Code value is added: SubscriptionChangeReasons / product
- importance 2
Code value is added: SubscriptionChangeReasons / servicenew
- importance 2
Code value is added: SubstitutionLevels / 0
- importance 2
Code value is added: SubstitutionLevels / 1
- importance 2
Code value is added: SubstitutionLevels / 2
- importance 2
Code value is added: SubstitutionLevels / 3
- importance 2
Code value is added: SubstitutionLevels / 4
- importance 2
Code value is added: SubstitutionTypes / code
- importance 2
Code value is added: SubstitutionTypes / group
- importance 2
Code value is added: SubstitutionTypes / type
- importance 2
Code value is added: TemplateCompanyAccesses / NoUse
- importance 2
Code value is added: TemplateCompanyAccesses / UseAndManage
- importance 2
Code value is added: TemplateCompanyAccesses / UseOnlyForCompanyCreation
- importance 2
Code value is added: TimeEntryTypes / QUANTITY
- importance 2
Code value is added: TimeEntryTypes / TIME
- importance 2
Code value is added: TimeTransactionCodes / DIRECT
- importance 2
Code value is added: TimeTransactionCodes / INDIRECT
- importance 2
Code value is added: TimeTransactionCodes / PERSONAL
- importance 2
Code value is added: TransactionLineTypes / detail
- importance 2
Code value is added: TransactionLineTypes / total
- importance 2
Code value is added: TransactionLineTypes / vat
- importance 2
Code value is added: TransactionStatuses / final
- importance 2
Code value is added: TransactionStatuses / temporary
- importance 2
Code value is added: UserTypes / accountant
- importance 2
Code value is added: UserTypes / accountantcustomer
- importance 2
Code value is added: UserTypes / regular
- importance 2
Code value is added: VatCodeLineTypes / detail
- importance 2
Code value is added: VatCodeLineTypes / vat
- importance 2
Code value is added: VatCodeTypes / purchase
- importance 2
Code value is added: VatCodeTypes / sales
- importance 2
Code value is added: WaysOfPayment / 0
- importance 2
Code value is added: WaysOfPayment / 1
- importance 2
Code value is added: WaysOfPayment / 2
- importance 2
Code value is added: WordTemplateKinds / 0
- importance 2
Code value is added: WordTemplateKinds / 1
- 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.
- 3 changes
- model files
Attribute transaction-tables-page-size is removed
A connection string or provider file that sets the attribute is rejected after the upgrade. Use the requested-page-size attribute instead.
What to Do
Check statements, views and scripts that use it before the upgrade.
- can break a statement
- importance 4
Driver setting technical documentation url changes
Technical documentation url changes from https://c3.twinfield.com/webservices/documentation/ to https://developers.twinfield.com/documentation/.
https://c3.twinfield.com/webservices/documentation/→https://developers.twinfield.com/documentation/- importance 3
Engine-wide connection attributes change
27 attributes added, 2 removed and 0 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.
- 3 changes
- commits
Counts and code filters on Twinfield master data are answered by Twinfield
A count of all rows of a master data table uses the total that Twinfield states in its answer, so no rows are read. A filter on the code is sent as a search pattern, so a question about one record no longer reads the whole table.
- importance 4
- confidence medium
Large Twinfield transaction tables are read in smaller calls; counts need no rows
A financial period with more lines than one call should carry is now split by journal, and the default call size is 10,000 lines instead of 50,000. This avoids Twinfield time-outs on large companies. A count on a transaction table asks for one narrow column instead of all columns and uses the total that Twinfield states. The column specifications of browse tables now report the correct table name.
- importance 4
- confidence medium
Queries on Twinfield transaction tables ask for fewer columns and stop at a row limit
Statements on the transaction tables now ask Twinfield only for the columns that the statement uses, and stop reading when a row limit has been reached. New rows also start with a smaller store. The year and period columns are kept together, so filters on them still give correct results.
- importance 4
- confidence high
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
Own Twinfield client IDs are no longer blocked by the office check
A check on which Twinfield offices may be used with the Invantive client ID also refused users who connect with their own client ID. The check now applies to the Invantive client ID only. For other client IDs the use of the office is only logged.
- importance 3
- confidence high
Twinfield answers are read without processing DTDs
Answers from Twinfield that contain a document type definition or an external entity are no longer processed. This closes a possible XML external entity attack through a manipulated answer.
- importance 3
- confidence high
Wrapped OAuth errors from Twinfield lead to a new log-on attempt
When an OAuth error was wrapped inside another error, the driver did not recognise it and did not try to log on again. It now also looks at the inner errors.
- 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
Twinfield page size is set with the general requested page size attribute
The Twinfield-specific attribute for the page size of transaction tables is removed. The general attribute for the requested page size now applies, with a default of 10,000 rows instead of 50,000.
What to Do
Remove the transaction-tables-page-size attribute from connection strings and provider files and use requested-page-size instead. A connection that still sets it is rejected.
- can break a statement
- importance 4
- confidence high
A cancelled statement stops Twinfield retrieval sooner
Cancellation is now checked while rows are read and before each retry. A stopped statement no longer starts a further attempt on a platform that nobody waits for.
- importance 2
- confidence high
A setting allows extra Twinfield offices beyond the built-in list
A new connection setting lets an administrator name additional offices that are allowed with the Invantive client ID. This avoids a refusal for an office that is not in the built-in list yet.
- 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.
- 3 changes
- commits
Twinfield calls move off the retired compressed XML method
Twinfield ended support for its compressed XML method on 31 July 2025, according to a remark in the code. Browse, dimension and similar calls now use the document method instead. The same change reads master data in pages, so tables above 10,000 rows no longer fail, limits the calls running at the same time to 20 per process, and follows the waiting time that Twinfield states when it rejects calls for exceeding the rate limit.
- importance 4
- confidence medium
Incomplete Twinfield log-on answers are reported with a clear message
Twinfield seems to return a partial answer when an OAuth token expires. The driver now checks that the cluster address, times, client, organisation and user are present, and stops with a specific message when one is missing. The same applies to a missing base address of the API.
- importance 2
- confidence medium
More Twinfield offices can be used with the Invantive client ID
Office codes of further customers were added to the list of offices that may be used with the Invantive client ID. Twinfield charges per office that is accessed, and offices outside the list are refused.
- importance 2
- confidence high
In Numbers
Objects of the data model at both ends of the step.
| Objects | 26.0 | 27.0 | Change |
|---|---|---|---|
| tables | 109 | 111 | +2 |
| views | 25 | 85 | +60 |
| table functions | 0 | 0 | +0 |
| columns | 13,851 | 14,640 | +789 |
| function parameters | 118 | 183 | +65 |
| attributes of driver | 13 | 12 | -1 |
| tables that can insert | 1 | 1 | +0 |
| tables that can update | 0 | 0 | +0 |
| tables that can delete | 0 | 0 | +0 |
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:06:41.4850315Z
- 2026-11-01T11:56:59.6979124Z
- 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.
- 359 links between a change and a source commit are recorded.
- 1 exclusions are recorded in the audit of the note.