NEW3.01.00 · Released 23 February 2018

NEWfinPOWER Connect

Released in

3.01.00

23 February 2018

1. Opened29 Sep 2016
2. Closed20 Nov 2017
3. Released23 Feb

Article 15069 Job J018130

AccountTransaction table; review indexes

To improve performance of Direct Debit processing, the AccountTransaction table, "IX_AccountTransactionDirect" index, has been modified.

Previously this indexed the columns DirectDebitStatus, Date and AccountPk. This has been amended to DirectDebitStatus, ReversePk and Date. For SQL Server, the column "AccountPk" is an included column.