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
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
Have something to add? Share your thoughts — no account required.
Ask the community — no account required