| View Name: | MARISysUserTable |
| Based on table: | MPSysUserTable |
| Group: | Group: SysUserTable |
| Description: | SDK: User-Defined Tables: Table description |
| ClassID: | 316. See Overview of ClassIDs by table. |
| Field | Table(Germ.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 |
MARIUserGroups.ViewRightsWeb (WHERE BenutzerTyp=1) | |
| ViewRightsCustomer | ViewRightsCustomer BIGINT |
MARIUserGroups.ViewRightsCustomer (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) |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Inactive | InAktiv SMALLINT (0=false,-1=true) Index |
Hide dataset |
| Table | Description |
|---|---|
| MARIQualityProcess | QualityProcess Definition |
| MARISysUserFormFields | SDK: User-Defined Tables: Form Fields |
| MARISysUserTableClassDelete | SDK: User-Defined Tables: Delete conditions |
| MARISysUserTableClassIndex | SDK: User-Defined Tables: Search Conditions |
| MARISysUserTableClassIndexCol | SDK: User-Defined Tables: Columns for search conditions |
| MARISysUserTableClassTree | SDK: User-Defined Tables: Search Tree |
| MARISysFilterDefinition | Definition of dynamic filter forms |