Extract credit card numbers form database

Posted by Phil V on April 29, 2009, 8:11 pm

Please log in for more thread options

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

Posted by Matt Hurst on April 30, 2009, 1:15 am

Please log in for more thread options

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.transactionnumber, time, e.description,
creditcardnumber,creditcardexpiration,creditcardapprovalcode, e.amount
from [transaction] t join tenderentry e on t.storeid=e.storeid and
t.transactionnumber=e.transactionnumber where time>'4/1/09' and
creditcardnumber<>'' order by t.storeid, t.transactionnumber

"Phil V" wrote:

> 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