Filtering manual credit card contribs and payment processor contribs

[SarahG (FountainTribe)]

In the CiviCRM back-office, the bookkeeper occasionally creates contributions with a payment instrument of "Credit Card" but DOES NOT use the integrated payment processor: ie they click "Create New ... Contribution"

Other times they use the integrated payment processor to create a contribution:  ie they click "Create New ... Contribution(Credit Card) 

I am trying do build a SQL query ( for a custom search) that will allow the user to filer on manually-posted credit card contributions vs credit card contributions that were processed via the payment processor.   Since both types have the same payment instrument of "Credit Card",  how can I distinguish the different types of records?

I already checked the table "civicrm_financial_trxn" but the field "payment_processor_id" is empty. Other ideas? or tables to check?

[joanne]

I can tell the difference in our system because the transaction ids have quite different formats and our payment gateway enters data into the invoice id (again in a distinctive format) whereas we leave that blank for manual transactions.  I realise neither of those might be applicable in your situation.

Also, although I could separate by payment path based on those fields, I actually don't need to, as I have set up a payment instrument type of credit card man specifically for when the integrated payment processor has not been used. Is that an option for your system? (possibly not if you are feeding contributions directly into Quickbooks)?

[SarahG (FountainTribe)]

I cannot use a different payment instrument such as "credit card (man)" because the data is getting exported later to QuickBooks.

As far as I can tell, the tranx_id is almost the same for both manual and payment processor -connected contributions.   Invoice # seems  to be a good idea. Was hoping there was something more reliable, such as "payment processor id" in one of the tables.