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.