| View Name: | MARISysUserFieldsGroup |
| Based on table: | MPSysUserFieldsGroup |
| Group: | Group: SysUserTable |
| Description: | System: Header for user defined groups |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ClassID | ClassID INT Primary |
ClassID | |
| GroupID | GruppenID INT Primary |
||
| Indent | Indent INT |
||
| Parent | Parent INT |
||
| TreeType | BlattTyp SMALLINT |
||
| PositionID | Position SMALLINT |
||
| Description | Bezeichnung NVARCHAR (40) |
||
| PageType | PageTyp INT |
||
| Memo | GruppenMemo NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| ConditionType | ConditionType INT |
||
| ConditionKey | ConditionKey NVARCHAR (200) |
||
| RightsMode | RechteMode INT |
||
| RightsRead | Lesen BIGINT |
MARIUserGroups.RightsRead (WHERE BenutzerTyp=1) | |
| RightsChange | Aendern BIGINT |
MARIUserGroups.RightsChange (WHERE BenutzerTyp=1) | |
| RightsInsert | Einfuegen BIGINT |
MARIUserGroups.RightsInsert (WHERE BenutzerTyp=1) | |
| RightsDelete | Loeschen BIGINT |
MARIUserGroups.RightsDelete (WHERE BenutzerTyp=1) | |
| RightsAll | Alles BIGINT |
MARIUserGroups.RightsAll (WHERE BenutzerTyp=1) | |
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) |
| Table | Description |
|---|---|
| MARISysUserFields | System: User-defined fields: Additional fields by master data |