Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The UserObject table in the profiles database contains information about registered users.
The following table describes the columns in the UserObject table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
u_user_id |
nvarchar(50) |
no |
The ID of the user. This is the primary key. |
u_org_id |
nvarchar(50) |
yes |
The ID of the organization that is associated with the user. |
u_user_type |
nvarchar(50) |
yes |
The type of user. |
u_first_name |
nvarchar(50) |
yes |
The user's first name. |
u_last_name |
nvarchar(50) |
yes |
The user's last name. |
u_email_address |
nvarchar(64) |
no |
The user's e-mail address. |
u_preferred_address |
nvarchar(50) |
yes |
The ID of the user's preferred address. |
u_addresses |
nvarchar(255) |
yes |
The IDs of all the addresses that are associated with the user. |
u_preferred_credit_card |
nvarchar(50) |
yes |
The ID of the user's preferred credit card. |
u_credit_cards |
nvarchar(255) |
yes |
The IDs of all credit cards that are associated with the user. |
u_tel_number |
nvarchar(32) |
yes |
The user's telephone number. |
u_tel_extension |
nvarchar(50) |
yes |
The extension of the user's telephone number. |
u_fax_number |
nvarchar(32) |
yes |
The user's fax number. |
u_fax_extension |
nvarchar(50) |
yes |
The extension of the user's fax number. |
u_user_security_password |
nvarchar(100) |
yes |
The user's logon password. .gif "Note") Note:
By default, the value is encrypted.
|
u_user_id_changed_by |
nvarchar(50) |
yes |
The Windows user ID of the person who last modified the profile. |
u_account_status |
nvarchar(50) |
yes |
The status of the user's account. |
u_user_catalog_set |
nvarchar(50) |
yes |
The ID of the catalog set that is associated with the user. |
dt_date_registered |
datetime |
yes |
The date that the user registered. |
u_campaign_history |
nvarchar(50) |
yes |
Not used. You can use this column for your extensions to Commerce Server Core Systems. |
dt_date_last_changed |
datetime |
yes |
The date that changes were last made to the user profile. |
dt_csadapter_date_last_changed |
datetime |
yes |
The date the user profile was last updated by BizTalk Server. |
dt_date_created |
datetime |
yes |
The date the user profile was created. |
u_language |
nvarchar(128) |
yes |
The user's preferred language. |
u_Pref1 |
nvarchar(50) |
yes |
Not used. You can use this column for your extensions to Commerce Server Core Systems. |
u_Pref2 |
nvarchar(50) |
yes |
Not used. You can use this column for your extensions to Commerce Server Core Systems. |
u_Pref3 |
nvarchar(50) |
yes |
Not used. You can use this column for your extensions to Commerce Server Core Systems. |
u_Pref4 |
nvarchar(50) |
yes |
Not used. You can use this column for your extensions to Commerce Server Core Systems. |
u_Pref5 |
nvarchar(50) |
yes |
Not used. You can use this column for your extensions to Commerce Server Core Systems. |
u_password_question |
nvarchar(255) |
yes |
The question to ask the user when the user forgets the password. |
u_password_answer |
nvarchar(255) |
yes |
The answer to the question to ask the user when the user forgets the password. Note:
By default, the value is encrypted.
|
u_logon_error_dates |
nvarchar(255) |
yes |
The dates the user unsuccessfully tried to log on. |
u_password_answer_error_dates |
nvarchar(255) |
yes |
The dates the user entered an incorrect password. |
i_keyindex |
int |
yes |
The index of the encryption key. |
i_access_level_id |
int |
yes |
Not used. You can use this column for your extensions to Commerce Server Core Systems. |
b_change_password |
bit |
yes |
Whether periodic password changes are required. |
dt_date_last_password_changed |
datetime |
yes |
The date the user's password was last changed. |
dt_last_logon |
datetime |
yes |
The last date the user logged on. |
dt_last_lockedout_date |
datetime |
yes |
The last date the user was locked out of the account. |
u_application_name |
nvarchar(256) |
yes |
Not used. You can use this column for your extensions to Commerce Server Core Systems. |
dt_last_activity_date |
datetime |
yes |
The last date the user interacted with the Commerce Server Core Systems application. |
b_direct_mail_opt_out |
bit |
yes |
Whether the user has opted out of receiving direct mail. |
b_express_checkout |
bit |
yes |
Whether the user can use the express checkout functionality. |
dt_date_address_list_last_changed |
datetime |
yes |
The date that any address associated with the user was last changed. |
dt_date_credit_card_list_last_changed |
datetime |
yes |
The date that any credit card associated with the user was last changed. |