reporting on Retail vs. Moto

Does anybody out there have a report that separates Moto vs. Retail credit card transactions?  Is there anything in the Tessitura data that indicates whether a transaction was sent to the ccserver and TranScend as Moto or Retail?

I'm thinking that the only solution to this might be a report that references data in both the Tessitura and TranScend tables???