Query Transactions table for incident through ROQL

Summary

I have a report created through analytics for incident Transactions and need the same result set but query through ROQL

Content

It looks that the transaction table in Analytics/Data Dictionary is differently than the Transaction table that I query through ROQL. 

The transaction table only has three fields, while the transaction table in Analytics/Data Dictionary in the Agent Desktop/B2C has many more fields.  

These are the fields I am using in Analytics:
incidents.i_id, transactions.createdn transactions.acct_id, transactions.acct_id.id, transactions.tbl, transactions.trans_type

I need to get the same data/fields though ROQL