ODBC connected to excel. How to get all Order transactions?

Hi All,

I have connected ODBC using a connector and I am able to get all Orders through to excel, but i cant seem to find Order Transactions.

I need the same report as the picture attached.

https://cdn.shopify.com/s/files/1/0613/4074/5877/files/order_transactions.jpg?v=1748493560

To get this report I usually go here
HOME → NEXT PAYOUT → VIEW ORDER TRANSACTION → EXPORT

Any help would be much appreciated.