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 |