Debtor Transaction Custom fields impacts performance of Debtor Maintenance

Even if no debtor transaction custom fields are defined, clicking on the Transaction tab of Debtor Maintenance will cause a query (SELECT FROM DB_TransCustomFieldValues) to execute for every debtor transaction to retrieve custom field values.

This greatly impacts performance.

Ideally this should be performed as a single query and the results parsed to create the custom field value objects.  We could make it a single query if we not only had the DB_Trans_TransID column in the DB_TransCustomFieldValues table, but also the DebtorID.  Redundancy for such performance gains is acceptable.