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