Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
c3s_credit_card_issues [2019/01/30 16:17]
kcifreo [***Always ensure that you are using the most current version of the C3S files***]
c3s_credit_card_issues [2019/02/06 10:52] (current)
admin
Line 1: Line 1:
-======  ====== +==== Description ====
- +
- +
- +
-Description +
- +
- +
 ====== Unmask credit card number only shows first four digits ====== ====== Unmask credit card number only shows first four digits ======
  
Line 17: Line 10:
 **Solution** **Solution**
   - For SSLIP versions 04.40.1003.0501 and later, update the C3SHost to version 1.0.1002.2601.   - For SSLIP versions 04.40.1003.0501 and later, update the C3SHost to version 1.0.1002.2601.
- 
  
  
Line 24: Line 16:
   - Run this query:   - Run this query:
  
-**UPDATE** StoreData.dbo.AccountContact +<code sql> 
- +UPDATE StoreData.dbo.AccountContact 
- +SET ModifiedDate = GETDATE() 
- +, ModifiedByUser = 'CyriousTech' 
-<html><div style="margin-left: 20px;"> **SET** ModifiedDate = **GETDATE**() </div></html> +, IsCCNumEncrypt = 1 
- +, DefaultPaymentTrackingNumber = OldAC.DefaultPaymentTrackingNumber 
- +, CCCSCustomerGuid = NULL 
- +FROM [StoreData].dbo.AccountContact 
-<html><div style="margin-left: 20px;"> , ModifiedByUser = 'CyriousTech' </div></html> +LEFT JOIN [43_StoreData].dbo.AccountContact OldAC ON OldAC.ID = AccountContact.ID 
- +WHERE CCCSCustomerGuid IS NOT NULL 
- +</code
- +
-<html><div style="margin-left: 20px;"> , IsCCNumEncrypt = 1 </div></html> +
- +
- +
- +
-<html><div style="margin-left: 20px;"> , DefaultPaymentTrackingNumber = OldAC.DefaultPaymentTrackingNumber </div></html> +
- +
- +
- +
-<html><div style="margin-left: 20px;"> , CCCSCustomerGuid = NULL </div></html> +
- +
- +
- +
-<html><div style="margin-left: 20px;"> **FROM** [StoreData].dbo.AccountContact </div></html> +
- +
- +
- +
-<html><div style="margin-left: 20px;"> **LEFT JOIN** [43_StoreData].dbo.AccountContact OldAC **ON** OldAC.ID = AccountContact.ID </div></html> +
- +
- +
- +
-<html><div style="margin-left: 20px;"> **WHERE** CCCSCustomerGuid **IS NOT NULL** </div></html>+
   - Restart the SSLIP.   - Restart the SSLIP.
   - Start Control. Control will again run through the process of updating existing credit card number to C3S.   - Start Control. Control will again run through the process of updating existing credit card number to C3S.
Line 62: Line 32:
  
  
-===== Elevon information fields not appearing in Account Setup\Unable to Process Credit cards =====+===== Elavon information fields not appearing in Account Setup\Unable to Process Credit cards =====