Reporting; Query optimisations and other minor changes

The following optimisations have been made in the Account Control query:

• Account Classes filter only included if neccessary

The following optimisations have been made in the Account Credit Card Expiry query:

• Account Classes filter only included if neccessary

The following optimisations have been made in the Account Exception List Account Correspondance Exception List queries:

• Account Classes filter only included if neccessary
• Account Statuses filter only included if neccessary

The following optimisations have been made in the Accounting Ledgers List query:

• Accounting Ledger Status filter only included if neccessary
• Account Classes filter only included if neccessary

The following changes and optimisations have been made in the Bank Account Suspense Item List query:

• If Allocated column is included, the BankTransactionPk column is forced to include
• If AllocatedTo column is included, the BankTransactionPk column is forced to include
• Question marks shown on the end of the 'Show Deleted' and 'Show Unallocated' parameters
• Was always joining on BatchHeader and GlExport tables

The following changes and optimisations have been made in the Bank Transaction List query:

• Minor structural changes
• CreatedUtcDate column is not longer always included
• ProcessedExternal columns can now be included, grouped and filtered

The following changes and optimisations have been made in the Client Invalid Address List query:

• ClientContactAddress.Pk column renamed to 'Pk' as per other queries

The following changes and optimisations have been made in the Australian PPSRG2B Transaction List query:

• Minor structural changes

The following changes and optimisations have been made in the New Zealand PPSRG2B Transaction List query:

• Minor structural changes