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

[aas88]

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.