The App Store receipt data has transaction id but I don't see a transaction id available in any of the tables we get from App Store Connect data. The App Store receipt data has our internal user id tied to the transaction id which I want to join with App Store Connect data that has the price, currency, promo etc.
Linking App Store Receipt data with App Store Connect data
You cannot link them, except in the sense that the number of sales should be approximately the same.