Extract credit card numbers form database

I have a client that needs to extract the credit cards numbers from RMS for the month of April so she can re-enter them using a new credit card processor. Is there a SQL command to do this? They are using RMS 2.0.

Thanks in advance

Phil

Reply to
Phil V
Loading thread data ...

One of the security features new to 2.0 is that only the last 4 digits of the number are kept in the rms database. Normally credit cards get processed the same day the transaction was made, so there is no need to 're-enter' or the customers would get double charged. If they were not doing EDC processing with a card company, and the number was not recorded any other way, then bad news for that client.

Here is the sql statement:

select t.storeid, t.transacti> I have a client that needs to extract the credit cards numbers from RMS for

Reply to
Matt Hurst

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.