I am trying to query some data via suiteanalytics connect odbc - I need to get my purchase order data when I run query

SELECT DISTINCT Transaction_Type
FROM TRANSACTIONS

I dont see Purchase Orders as a transaction type What table is purchase order data located in ?

It's definitely there. Check that the role you are using for ODBC has right permissions for POs

@michoel Thank you, I am a moron who spent an hour reviewing all the table schemas when it was a permissions issue... -_-