Where is Paypal Transaction ID in database?

[DaveS]

Not sure if anyone can help.

I'm trying to link Zen Cart up to our inventory/order management system. The order management system needs to know the Paypal transaction id so it can match orders to Paypal payments

I can find paypal.txn_id, but what I really need is the actual paypal reference. It shows in orders_status_history as PPRef: and shows up on the edit orders page of admin.

Is this PPRef held somewhere else in the database though? I need to send it through to our order management software.

Thanks,
Dave

[joe.davila]

I'm looking for the same thing. I was able to find a reference to it in orders_status_history, but it's in a comments field. Have you found it somewhere else?

[joe.davila]

Nevermind, I found it. It's in the PayPal table, which also contains a field called orders_id in case you need to combine it with data from another table.