01-26-2011 10:34 PM
Hello Experts,
Can any one please let me know what tables are affected by TWsecurityinstall..
Thank you.
01-27-2011 12:02 AM
The following columns and identified tables are affected by the
encryption implementation for your reference.
pa_customer
column 'address1'
column 'address2'
txn_authorization
column 'cardnum'
column 'authnum'
column 'creditresponse'
column 'captresp'
column 'cardholdername'
ptd_authorization
column 'cardnum'
column 'authnum'
column 'creditresponse'
column 'captresp'
column 'cardholdname'
txn_profile_prompt_response
column 'profileresponse1'
column 'profileresponse2'
column 'profileresponse3'
column 'profileresponse4
ptd_profile_prompt_response
column 'profileresponse1'
column 'profileresponse2'
column 'profileresponse3'
column 'profileresponse4'
txn_non_merch_sale
column 'refnum'
ptd_non_merch_sale
column 'refnum'
txn_method_of_payment
column 'refnum'
ptd_method_of_payment
column 'refnum'
employee
column 'password'
01-27-2011 12:02 AM
The following columns and identified tables are affected by the
encryption implementation for your reference.
pa_customer
column 'address1'
column 'address2'
txn_authorization
column 'cardnum'
column 'authnum'
column 'creditresponse'
column 'captresp'
column 'cardholdername'
ptd_authorization
column 'cardnum'
column 'authnum'
column 'creditresponse'
column 'captresp'
column 'cardholdname'
txn_profile_prompt_response
column 'profileresponse1'
column 'profileresponse2'
column 'profileresponse3'
column 'profileresponse4
ptd_profile_prompt_response
column 'profileresponse1'
column 'profileresponse2'
column 'profileresponse3'
column 'profileresponse4'
txn_non_merch_sale
column 'refnum'
ptd_non_merch_sale
column 'refnum'
txn_method_of_payment
column 'refnum'
ptd_method_of_payment
column 'refnum'
employee
column 'password'