CreditCards Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The CreditCards table in the profiles database contains information about the credit cards that are associated with registered users.
The following table describes the columns in the CreditCards table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
u_id |
nvarchar(50) |
no |
The ID of the credit card. This is the primary key. |
u_payment_group_id |
nvarchar(50) |
no |
The ID of the payment group. |
u_cc_number |
nvarchar(512) |
no |
The credit card number. .gif "Note") Note:
This value is encrypted.
|
u_expiration_date |
nvarchar(12) |
no |
The date the credit card expires. |
u_last_4_digits |
nvarchar(10) |
no |
The last four digits of the credit card. |
u_billing_address |
nvarchar(50) |
no |
The ID of the billing address that is associated with the credit card. |
i_keyindex |
int |
yes |
The index of the encryption key. |
u_user_id_changed_by |
nvarchar(50) |
yes |
The Microsoft Windows user ID of the person who last modified the credit card record. |
dt_date_last_changed |
datetime |
yes |
The date that changes were last made to the credit card record. |
dt_csadapter_date_last_changed |
datetime |
yes |
The date the credit card record was last updated by BizTalk Server. |
dt_date_created |
datetime |
yes |
The date the credit card record was created. |