RegisteredUser
This class represents user profile data. By default, the Commerce Server 2009 User Profile Data Import Data Transformation Services (DTS) Task imports data from the UserObject table into this class. Data in this table may not correspond to users of the Commerce Server 2009 Web site. This is because the site developer is free to modify the schema of the user's profile. If the site developer adds new properties to the schema, these properties will automatically be added using the DTS task if the Export to Data Warehouse option is used.
Data Members
Data Member Name |
Data Type |
Default Value |
Description |
|---|---|---|---|
AccountClass |
int |
None |
Stores a classification code for the user account. |
AccountStatus |
int |
None |
Stores the account status for the user: 0 - inactive 1 - active |
ApprovalLimit |
int |
None |
Stores the approved spending limit for the user. |
ApprovalLimitCurrency |
nvarchar(255) |
None |
Stores the type of currency for the spending limit. |
ApprovingManagerID |
int |
None |
Stores an identifier code for the manager who approved the spending limit for the user. |
AuthType |
smallint |
None |
Stores the type of authentication required for the user. |
DateCreated |
datetime |
None |
Records the time the object was created. |
DateLastChanged |
datetime |
None |
Records the time the object was last changed. |
DateRegistered |
datetime |
None |
Records the date and time when the user registered on the site. |
DefaultBlanketPONumber |
nvarchar(255) |
None |
Stores the default purchase order number for the user. |
DefaultBlanketPOProfileID |
int |
None |
Stores the default purchase order profile ID. |
DefaultCostCenterNumber |
nvarchar(255) |
None |
Stores the default cost center identifier. |
DefaultCostCenterProfileID |
int |
None |
Stores the default cost center profile identifier. |
nvarchar(255) |
None |
Stores the e-mail address for the user. |
|
EmployeeClassID |
int |
None |
Stores a classification code for the user employee ID. |
FaxNumber |
nvarchar(255) |
None |
Stores the fax number of the user. |
FirstName |
nvarchar(255) |
None |
Stores the first name of the user. |
IDCode |
nvarchar(255) |
None. |
Stores a code for the user ID. |
IDCodeQualifier |
nvarchar(255) |
None |
Stores a code for the qualifier of the user identification. |
LastName |
nvarchar(255) |
None |
Stores the last name of the user. |
LocationID |
int |
None |
Not used. |
Logon_Name |
nvarchar(255) |
None |
Stores the logon name of the user. |
Name |
nvarchar(255) |
None |
Not used. |
OrgID |
nvarchar(255) |
None |
Stores an identifier of the organization for the user. |
ShipToID |
int |
None |
Not used. |
ShipToMethodCode |
int |
None |
Stores a code for the method of shipping preferred by the user. |
TelephoneNumber |
nvarchar(255) |
None |
Stores the telephone number of the user. |
UserID |
nvarchar(255) |
Unknown |
Stores the unique key for the object. |
UserIDChangedBy |
nvarchar(255) |
None |
Records who last changed/set the UserID. |
UserTitle |
nvarchar(255) |
None |
Stores the title of the user. |
UserType |
int |
0 |
Stores the user type: 0 - Anonymous 1 - Registered |
AddressID |
binary |
1 |
None. |
Class Key
RegisteredUserKey is composed of a single data member, UserID.
Relations
For a description of the relation type, see Data Warehouse Classes.
Relation Name |
Parent |
Child |
Type |
|---|---|---|---|
AddressUserRel |
Address |
RegisteredUser |
2 |
RegisteredUserBasketRel |
RegisteredUser |
Basket |
2 |
RegisteredUserCampaignEventRel |
RegisteredUser |
CampaignEvent |
2 |
RegisteredUserOpenUserVisit |
RegisteredUser |
OpenUserVisit |
2 |
RegisteredUserOrderRel |
RegisteredUser |
Order |
2 |
RegisteredUserRequestRel |
RegisteredUser |
Request |
2 |
RegisteredUserUserRel |
RegisteredUser |
LogUser |
2 |
RegisteredUserVisitInfoRel |
RegisteredUser |
VisitInfo |
2 |
SiteRegisteredUserRel |
Site |
RegisteredUser |
3 |
SiteTermRegisterdUserRel |
SiteTerm |
RegisteredUser |
3 |
UserToOrderGroup |
RegisteredUser |
OrderGroup |
2 |