How find Auth Only CC transactions? What field for query?

We are about to run the token migration from SDM to CRE and we’re trying to see if we have any “auth only” orders. I can’t find the field to create a query. Any ideas?

May not be exactly what you’re looking for, but try this as a starting point:

select * from erp.CreditTran
where TranType = ‘A’ and ordernum not in
(select ordernum from erp.CreditTran where TranType = ‘D’)

Thank you. Is TranType = “D” a deposit (thus a capture on the auth?)

Yes. My query would show Auth transactions on orders for which there is not also a Deposit transaction. It’s not going to give you a perfect list of all Auth transactions that were never captured, but it may be a decent approximation.