| Table Name: | MPSysUserTable |
| View Name: | MARISysUserTable |
| Group: | Group: SysUserTable |
| Description: | SDK: User-Defined Tables: Table description |
| ClassID: | 316. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| TableID | TableID SMALLINT Primary |
||
| TableNameShort | TableNameShort NVARCHAR (50) |
||
| TableNameLong | TableNameLong NVARCHAR (50) |
||
| Caption | Caption NVARCHAR (50) Index |
||
| CaptionLang | CaptionLang INT |
||
| TableType | TableType INT |
0=Tables from User Processes, 1=Info Screen Management Info Store, 2=User Defined Table,3=UDF Forms, 4=User View, 8=DMS Search Forms | |
| Clause | Clause NVARCHAR (255) |
||
| KeyName | KeyName NVARCHAR (64) |
||
| Lookup | Lookup NVARCHAR (64) |
||
| KeyHandling | KeyHandling INT |
||
| KeyFormat | KeyFormat NVARCHAR (50) |
||
| SecurityMode | SecurityMode INT |
||
| SecurityForm | SecurityForm NVARCHAR (50) |
||
| SecurityFormMode | SecurityFormMode INT |
||
| ViewRightsWeb | ViewRightsWeb BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=1) | |
| ViewRightsCustomer | ViewRightsCustomer BIGINT |
MPBenutzergruppen.Gruppe (WHERE BenutzerTyp=2) | |
| ViewModeCoreData | ViewModeCoreData INT |
||
| EditModeCodeData | EditModeCodeData INT |
||
| Option1 | Option1 INT |
||
| Option2 | Option2 INT |
||
| OptionMemo | OptionMemo NTEXT |
||
| DefaultReport | DefaultReport INT |
||
| ParentMenu | ParentMenu INT |
||
| MenuItem | MenuItem NVARCHAR (50) |
||
| FilterClassID | FilterClassID INT |
||
| PictureID | PictureID INT |
||
| InAktivClause | InAktivClause NVARCHAR (50) |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| InAktiv | Inactive SMALLINT (0=false,-1=true) Index |
Hide dataset |
| Table | Description |
|---|---|
| MPQualityProcess | QualityProcess Definition |
| MPSysFilterDefinition | Definition of dynamic filter forms |
| MPSysUserFormFields | SDK: User-Defined Tables: Form Fields |
| MPSysUserTableClassDelete | SDK: User-Defined Tables: Delete conditions |
| MPSysUserTableClassIndex | SDK: User-Defined Tables: Search Conditions |
| MPSysUserTableClassIndexCol | SDK: User-Defined Tables: Columns for search conditions |
| MPSysUserTableClassTree | SDK: User-Defined Tables: Search Tree |