Storage of PayPal Invoice ID in store database

Does the PayPal Invoice ID or Transaction ID get stored anywhere in the ZenCart database ? It would be nice to be able to link the PayPal transaction details to the transaction data in ZenCart. i.e. via PayPal transaction ID and invoice ID. I can then run some PayPal cross referencing reporting queries on the ZenCart database.

HeyIts007:

Does the PayPal Invoice ID or Transaction ID get stored anywhere in the ZenCart database ?

Yes.

zen_paypal (Transaction ID and order ID)
zen_paypal_payment_status_history (transaction ID only)

HeyIts007:

It would be nice to be able to link the PayPal transaction details to the transaction data in ZenCart. i.e. via PayPal transaction ID and invoice ID. I can then run some PayPal cross referencing reporting queries on the ZenCart database.

Customers->PayPal_IPN already does this. Is there something more that you need?

Cheers
RodG

Thanks for the advice. I note that "zen_paypal_payment_status_history" mostly seems to show refunded transactions, rather than all transactions. There is an invoice column in the paypal table, but it does not seem to show all invoices that the transaction generates in the email. Instead a different transaction ID is often shown. Perhaps it depends on the transaction type.