This query returns multiple transaction types and provides the detailed transaction-level information. It currently filters results using companyID, which can be substituted with any other set of IDs as needed.