How to bind apple_Id and transaction_id in apple store connect api to track refunds?

Good day,

There is a need to track returns in the application in order to write off the intra-system balance

With verifyReceipt -

https://developer.apple.com/documentation/appstorereceipts/verifyreceipt

I can get a list of transaction_id for a specific purchase token.

With salesReports -

https://developer.apple.com/documentation/appstoreconnectapi/download_sales_and_trends_reports

I can get a list of all operations with appleId, but without transaction_id.

1. What are the ways to associate appleId data of users and purchases via API?
2. Are there any ways to visualize purchase statistics https://appstoreconnect.apple.com/trends/sales

output transaction_id besides appleId?