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

Question

Apple App Store

Good afternoon,

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

With the help of verifyReceipt - https://developer.apple.com/documentation/appstore...
I can get a list of transaction_id for a specific purchase token.

With salesReports -
https://developer.apple.com/documentation/appstore...
I can get a list of all transactions with appleId but no transaction_id .

1) What are the ways to link user appleId data and API purchase transactions?
2) Are there ways to visualize purchase statisticshttps://appstoreconnect.apple.com/trends/sales
output transaction_id besides appleId ?