invantive documentation
Invantive Support ForumsLog In / Sign Up

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

  • 340 changes
  • 2 can break a statement
  • 0 groups not available

What Changed, by Group

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

  • Data model
    • 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?

Download Changes as CSV

Before You Upgrade

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

Top 22 Changes

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

  1. Twinfield page size is set with the general requested page size attribute
    • Enhancements
    • Breaks an existing statement or script.
  2. Attribute transaction-tables-page-size is removed
    • Provider attributes
    • Breaks an existing statement or script.
  3. Counts and code filters on Twinfield master data are answered by Twinfield
    • Performance
    • Importance 4 of 5.
  4. Large Twinfield transaction tables are read in smaller calls; counts need no rows
    • Performance
    • Importance 4 of 5.
  5. Queries on Twinfield transaction tables ask for fewer columns and stop at a row limit
    • Performance
    • Importance 4 of 5.
  6. Twinfield calls move off the retired compressed XML method
    • Log-on and platform
    • Importance 4 of 5.
  7. Own Twinfield client IDs are no longer blocked by the office check
    • Bug fixes
    • Importance 3 of 5.
  8. Twinfield answers are read without processing DTDs
    • Bug fixes
    • Importance 3 of 5.
  9. Wrapped OAuth errors from Twinfield lead to a new log-on attempt
    • Bug fixes
    • Importance 3 of 5.
  10. Table Twinfield.Twinfield.IctCountries is added
    • Data model
    • Importance 3 of 5.
  11. Table Twinfield.Twinfield.PlatformVersion is added
    • Data model
    • Importance 3 of 5.
  12. Table function Twinfield.Settings.ArticleLinesByCode is added
    • Data model
    • Importance 3 of 5.
  13. Table function Twinfield.Settings.ArticleSettingsByCode is added
    • Data model
    • Importance 3 of 5.
  14. Table function Twinfield.Settings.OfficeSettingsByCode is added
    • Data model
    • Importance 3 of 5.
  15. Table function Twinfield.Settings.PaymentTypeSettingsByCode is added
    • Data model
    • Importance 3 of 5.
  16. Table function Twinfield.Settings.ProjectRateChangesByCode is added
    • Data model
    • Importance 3 of 5.
  17. Table function Twinfield.Settings.ProjectRateSettingsByCode is added
    • Data model
    • Importance 3 of 5.
  18. Driver setting technical documentation url changes
    • Provider attributes
    • Importance 3 of 5.
  19. A cancelled statement stops Twinfield retrieval sooner
    • Enhancements
    • Importance 2 of 5.
  20. A setting allows extra Twinfield offices beyond the built-in list
    • Enhancements
    • Importance 2 of 5.
  21. Incomplete Twinfield log-on answers are reported with a clear message
    • Log-on and platform
    • Importance 2 of 5.
  22. 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

  • ~ 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

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.