| Table Name: | MPTenantMonitorAppUsers |
| View Name: | MARITenantMonitorAppUsers |
| Group: | Group: TenantMonitorMachines |
| Description: | Bucket to store installation data at client location: assigned users |
| ClassID: | 651. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| UserID | UserID INT Primary |
||
| DatabaseID | DatabaseID INT Index |
MPTenantMonitorDatabases.DatabaseID | |
| MachineID | MachineID INT |
MPTenantMonitorMachines.MachineID | |
| UserCode | UserCode NVARCHAR (100) Index |
||
| UserName | UserName NVARCHAR (100) |
||
| UserInfo | UserInfo NVARCHAR (255) |
||
| UserType | UserType INT |
||
| UserGroups | UserGroups BIGINT |
||
| UserLevelMode | UserLevelMode INT |
||
| AccountingMode | AccountingMode INT |
||
| LicenseType | LicenseType INT |
||
| LicenseValues | LicenseValues NTEXT |
||
| RightsType | RightsType INT |
||
| RightsValues | RightsValues NTEXT |
||
| Credentials1 | Credentials1 NTEXT |
||
| Credentials2 | Credentials2 NTEXT |
||
| RightsInfo | RightsInfo NVARCHAR (255) |
||
| EnvironmentID | EnvironmentID INT Index |
MPTenantEnvironments.EnvironmentID | |
| ERPUserName | ERPUserName NVARCHAR (128) |
||
| ERPUserByCompany | ERPUserByCompany BIGINT |
||
| EncryptionMethod | EncryptionMethod INT |
||
| SecondFactorMode | SecondFactorMode INT |
||
| AppSettings | AppSettings NTEXT |
||
| EmployeeMatchcode | EmployeeMatchcode NVARCHAR (100) Index |
MPPersonenstamm.Matchcode | |
| EmployeeEMail | EmployeeEMail NVARCHAR (255) |
MPPersonenstamm.Email | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) |