Ubercart

Hello,
I am using Authorize.net 6.x-2.4., payments are charged immediately, by "Prior authorization" or by "Customer references". Works great.

My client, the store administrator, needs a report that clearly states when charges were actually cleared into their account (not authorization or order date/time) and this report needs to show charge total as well as what card Type was used (as Amex is part of another reporting system for them, they have other payments systems clearing thru Authorize.net as well).

I can do most of this with a query like this from the uc_payment_receipts & uc_orders tables:

$db_query = "SELECT r.receipt_id, r.received, r.amount, r.method, o.uid, r.order_id, o.primary_email, o.billing_last_name, o.billing_first_name, r.comment FROM {uc_payment_receipts} r, {uc_orders} o WHERE r.method = 'Credit card' AND r.received < '$t_end' AND  r.received > '$t_start' AND r.order_id = o.order_id ORDER BY r.received DESC";

I have been chopping away at this but am short of a solution and am hoping someone can provide me some insight.

I specifically need the card Type but the last 4 digits of the CC would be nice as well.

Thanks in advance.