Share via


RegisteredUser

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

This class represents user profile data. By default, the Commerce Server 2007 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 2007 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.

Email

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

See Also

Other Resources

Data Warehouse Classes