Pulling Paypal Payment Fee Information

I'm exporting some info from the database and one piece of information I cannot find is the Paypal "Payment Fee" field. If a user pays by paypal, it does show up in the "paypal" table under the "mc_fee" field, however if they pay by credit card through paypal that field is blank. In both cases, on the admin order details page, it does show all of the paypal transaction information along with the fee...so that info must be somewhere.

Thanks.

It is in the table "paypal" and is the record "payment_fee" I believe

My "Payment_Fee" field is "NULL" throughout the entire table. The "MC_Fee" field is the only place that I've found something related to the payment fee.

The mc_fee field (all lower case) contains the fee you paid to PayPal.

my mc_field contains data IF they paid via paypal. If they paid using a credit card via paypal website payments pro, that data is "NULL"

If the data is in the table, you can report on it.
If the data is not in the table, but displays in the Admin, then in the admin it is being retrieved in real-time directly from PayPal, and is not stored locally in your database ... thus you will not be able to run reports on it.