Q - I am in the process of implementing Elliott online credit card charge processing with pre-authorization through the COP Order Payment window. I need to develop a separate process to identify orders that have been pre-authorized for credit card charges. Could you suggest what would be the quick and easy way to identify a pre-authorized order?
A -For the order that has been preauthorized, you should be able to see the order_comment1 with text like:
PreA *3546 $194.19 TX#179235969
See sample screen below:
So you could use the following SQL statement to find the pre-authorized orders:
select order_no, order_comment1 from cpordhdr where order_comment1 like 'PreA%';