Removed All Credit Card Fields from the Visioncore SQL Databases

All credit card fields from the Visioncore SQL Database and from the Find Form > Settings form were removed due to PCI Compliancy.  Since all the credit card data were already removed from our previous release, there’s no need to keep these credit card fields from the Visioncore SQL database.

But the following fields are retained because the data are needed to allow the user to re-print the receipt.  Also, VisionCore has a feature to print a credit card receipt report that uses the these fields.

1.Card Name

2.Card Expiry Date

In line with this enhancement, the following new fields are added in VisionCore.

1.Batch Number - this is the batch number returned by the MercuryShield integration

2.Ref Number - this is the reference number returned by the MercuryShield integration.

The tables that are affected by these changes are:

a)tblARInvoice

b)tblARCustomer

c)tblOESales

d)tblARCustomerPayment

e)tblSMPreferenceUser

All credit card fields were removed from the Visioncore SQL Database.

All credit card fields were removed from the Find form > Settings form.

Reference: Project 1119