WebSphere Commerce database table: CCCHECK

The Credit Card Check table stores the length and prefix of credit cards. This information is used by the default CheckCCNumber task command to help determine the validity of the credit card number. Initially, the CCCHECK table is empty. If no entry is found in the table for the credit card brand, the default CheckCCNumber task command calls the DoLuhnCheck task command.

Column Descriptions

Column Name	Column Type	Description
CCRFNBR	INTEGER NOT NULL	This is the primary key. The combination of CCTYPE, CCLENGTH and CCPREFIX must be unique.
CCTYPE	VARCHAR(40) NOT NULL	The credit card brand. This is a case-sensitive string and is used as a search key for a query to this table.
CCLENGTH	INTEGER NOT NULL	This is the credit card number length.
CCPREFIX	CHAR(16) NOT NULL	This is the credit card prefix.
CCALGTASKRN	VARCHAR(256)	The task command interface name called by the default CheckCCNumber task command after passing the length and prefix check. It will perform an algorithmic check of the credit card number. Example: com.ibm.commerce.payment.commands.DoLuhnCheckCmd
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
I0000069	CCTYPE+CCLENGTH+CCPREFIX	Unique Index
SQL060903235140030	CCRFNBR	Primary Key