Creditor Transaction Custom fields impacts performance of Creditor Maintenance

Even if no creditor transaction custom fields are defined, clicking on the Transaction tab of Creditor Maintenance will cause a query (SELECT FROM CR_TransCustomFieldValues) to execute for every creditor 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 CR_Trans_TransID column in the CR_TransCustomFieldValues table, but also the CreditorID.  Redundancy for such performance gains is acceptable.