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 Description(s):
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 to be called by the default CheckCCNumber task command to perform an algorithmic check of the credit card number after passing the length and prefix check. Example: com.ibm.commerce.payment.commands.DoLuhnCheckCmd |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000069 |
CCTYPE+CCLENGTH+CCPREFIX |
Unique Index |
SQL050212031210970 |
CCRFNBR |
Primary Key |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.