Share via


CreditCard Profile Schema

An instance of this profile schema stores credit card information for users. The profile is mapped to the physical CreditCards table. The Commerce Server Core Systems User Import DTS Task extends and exports data into the Data Warehouse for properties with the Exported (Exp) attribute marked as True (1). For information about the table entries, see Conventions.

Property Name

Data

Type

Req

Exp

Group

Display Name/

Description

id (primary and join key)

GUID

T

T

GeneralInfo

Unique ID of this credit card

payment_group_id

GUID

T

F

GeneralInfo

ID of an Orders System payment group

cc_number

Unicode String

T

F

GeneralInfo

Account number of this credit card

i_expiration_month

Integer

T

F

GeneralInfo

Expiration month of this credit card

i_expiration_year

Integer

T

F

GeneralInfo

Expiration year of this credit card

last_4_digits

Unicode String

T

F

GeneralInfo

Last four digits of this credit card account number

billing_address

GUID

T

F

GeneralInfo

ID of the billing addresses associated with this credit card

KeyIndex

Integer

F

F

ProfileSystem

Key index for encryption

user_id_changed_by

Unicode String

F

F

ProfileSystem

ID of the user that last changed this credit card

date_last_changed

Date

Time

F

F

ProfileSystem

Date that this credit card was last changed

date_created

Date

Time

F

F

ProfileSystem

Date that this credit card was created

csadapter_date_last_changed

Date

Time

F

F

ProfileSystem

Reserved for BizTalk adapter functionality

See Also

Other Resources

Address Profile Schema

BlanketPOs Profile Schema

Currency Profile Schema

Organization Profile Schema

UserObject Profile Schema

Profiles Schema