| Table Name: | MPBenutzergruppen |
| View Name: | MARIUserGroups |
| Group: | Group: User |
| Description: | ProjectManagement: User Groups |
| ClassID: | 102. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Gruppe | UserGroup SMALLINT Primary |
||
| BenutzerTyp | UserType INT Primary |
1=Fulluser, 2=Customer Portal User | |
| Bezeichnung | Description NVARCHAR (50) Index |
||
| UserLevel | UserLevel SMALLINT |
||
| FiBuLevel | AccountingMode INT |
||
| Reihenfolge | GroupOrder INT |
||
| Farbe | Color INT |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Erstanlage | CreateDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPBenutzer | ProjectManagement User + Customer Portal User |
| MPBerechtigungen | Authorization for each form and report |
| MPBuch | Project Dokumentation: Book Header |
| MPBuchArchiv | Project Dokumentation: Archived Book Content |
| MPBuchLink | Project Dokumentation: externale links to pages |
| MPBuchLinkArchiv | Project Dokumentation: externale link archive |
| MPBuchSeite | Project Dokumentation: Book Page (Left hierarchy) |
| MPBuchSeitenArchiv | Project Dokumentation: Book Page Archive (Left hierarchy) |
| MPChefInfoDashboard | Project Dash Board Settings |
| MPChefInfoUserColumns | Info Screen Management: User-defined columns |
| MPChefInfoUserStore | Info Screen Management: Store filter settings (Header) |
| MPCustomerEquipmentCardCategory | Group to manage properties by group |
| MPDBAuswertungen | Info Screen Management: Breakeven Analysis (Header) |
| MPDBColumnsDefinition | Info Screen Management: Column Definition Head |
| MPEquipmentCategory | EquipmentCategory: Cagetory Master |
| MPHotlineClassType | Support Module: Settings by class type (Ticket, Task, Idea, DevTask, HR Task) |
| MPHotlineWorkFlowTransition | Support Module: Workflow definition for the status transition |
| MPKBArtikel | Support Module: Knowledge Base Header |
| MPQualityProcess | QualityProcess Definition |
| MPSammelmappeBaum | Master Data Folder Search Tree |
| MPSammelmappeGruppen | Document Tab Registers |
| MPSysAddOns | Manage Programm Add Ons in MARI |
| MPSysMenu | System: Menu contents for the different clients (Fat, Web, customer portal..) |
| MPSysMenuFavorites | System: User Menu |
| MPSysReports | Reporting: User Report definition |
| MPSysUserFieldsGroup | System: Header for user defined groups |
| MPSysUserFormPages | SDK: User-Defined Tables: Form Pages |
| MPSysUserQueryGruppe | System: User Defined Groups for Queries |
| MPSysUserTable | SDK: User-Defined Tables: Table description |
| MPTenantMonitorAppUserGroups | Bucket to store installation data at client location: installed user groups |
| MPTenantUserGroups | Management of MARIProject/SBO client installations user groups |