CreditCard Profile Schema
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
An instance of this profile schema stores credit card information for users. The profile is mapped to the physical CreditCards table. The Commerce Server 2007 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 |
expiration_date |
Unicode String |
T |
F |
GeneralInfo |
Expiration date 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 |