T_USER
|
Name |
Data Type |
Allows Null |
Description |
|
|---|---|---|---|---|
|
|
UserId |
int |
No |
Auto-generated unique ID |
|
|
LoginId |
nvarchar (50) |
No |
Unique login ID |
|
|
ExpiresOn |
datetime |
Yes |
Expiry date for the user account |
|
|
IsEnabled |
bit |
No |
Indicates whether the user is active or not |
|
|
EmailId |
nvarchar (50) |
No |
User’s e-mail ID |
|
|
UserPassword |
nvarchar (50) |
No |
User’s password |
|
|
RefId1 |
nvarchar (250) |
Yes |
Reference ID. Used to connect to an external CRM |
|
|
RefId2 |
nvarchar (250) |
Yes |
Alternate reference ID. Used to connect to an external CRM. |
|
|
LocaleId |
int |
Yes |
Maps user to the locale |
|
|
PartnerId |
int |
No |
Associates Channel partner to a user |
|
|
DateCreated |
datetime |
No |
Date and time when user was created |
|
|
CreatedBy |
nvarchar (50) |
Yes |
User who created this user |
