Client is requesting the ability to see some card details when order payments fail (last 4, expiration date, etc.).
We are running https://www.drupal.org/project/commerce_cardonfile which exposes fields like Commerce card on file: Card number and Commerce card on file: Card expiration to views. The fields are associated with the user, not the order.
I attempted to build a view using the Commerce Payment Transaction table as the base table and, through a series of relationships, I have been able to locate all the credit cards associated with the user who placed the order, but I am not able to identify which card was used for this order.