I need to add the PayPal Transaction number to the 'orders' table in pp_confirm.php
I'm using eCart 6 with PayPal Express checkout. The order information is being stored correctly in the database, but I'd also like to store the PayPal transaction number in the 'orders' table. I can easily add it to the insert query in the pp_confirm.php page, but I don't know what variable to use. Does PayPal send back the transaction number to the pp_confirm.php page? I see where it's storing the session ID, but my client wants the PayPal Transaction number.
TIA -
Phil