| View Name: | MARIUserCompanyLogin |
| Based on table: | MPBenutzerERP |
| Group: | Group: User |
| Description: | ProjectManagement User Link to SBO Users |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| UserCode | Benutzer NVARCHAR (4) Primary |
MARIUser.UserCode (WHERE BenutzerTyp=1) | |
| Company | Mandant SMALLINT Primary |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| Active | CompanyEnabled SMALLINT |
||
| ERPUser | ERPUserName NVARCHAR (128) Index |
||
| ERPPassword | ERPUserPWD NTEXT |
||
| EncryptionMethod | EncryptionMethod SMALLINT |
||
| EncryptionSalt | EncryptionSalt NVARCHAR (40) |
||
| LastPasswordChange | LastPasswordChange Datetime |
||
| UpdateStamp | UpdateStamp INT |