Extract credit card numbers form database

Apr 30, 2009 1 Replies

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


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

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required