Share via


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.

Bb520962.alert_note(en-US,CS.70).gifNote:
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.

See Also

Other Resources

Profiles System Database Tables