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:
| Name | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | CCRFNBR | Primary Key |
| I0000069 | CCTYPE+CCLENGTH+CCPREFIX | Unique Index |