[support] Drupal commerce

[Roger]

Hello
I need to get financial reports out of Drupal 7 Commerce module data.
mysql displays the data from:
select * from commerce_paypal_ipn;
select * from field_data_field_donation_amount;

I have problems getting views to provide the same data. It seems there 
is no way to select those tables.
  I cannot find which relationship/s to use.

Is there any easy way of gathering reconciliation/financial and tax data 
for the accountant?
Is there any way to show weekly totals for from receipts and from paypal?

Strangely there seems to be no mention on Google about getting data, 
only tuts on setting up commerce.

I really appreciate help in understanding the commerce set up and how to 
gather and display data from inputs.
Thanks in advance
Roger