| View Name: | MARIUserGroups |
| Based on table: | MPBenutzergruppen |
| Group: | Group: User |
| Description: | ProjectManagement: User Groups |
| ClassID: | 102. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| UserGroup | Gruppe SMALLINT Primary |
||
| UserType | BenutzerTyp INT Primary |
1=Fulluser, 2=Customer Portal User | |
| Description | Bezeichnung NVARCHAR (50) Index |
||
| UserLevel | UserLevel SMALLINT |
||
| AccountingMode | FiBuLevel INT |
||
| GroupOrder | Reihenfolge INT |
||
| Color | Farbe INT |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| CreateDate | Erstanlage Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIUser | ProjectManagement User + Customer Portal User |
| MARIFormAuthorization | Authorization for each form and report |
| MARIInfoScreenManagementUserColumns | Info Screen Management: User-defined columns |
| MARIInfoScreenManagementUserStore | Info Screen Management: Store filter settings (Header) |
| MARIInfoScreenManagementBreakEven | Info Screen Management: Breakeven Analysis (Header) |
| MARIKnowledgeBaseEntry | Support Module: Knowledge Base Header |
| MARIQualityProcess | QualityProcess Definition |
| MARIFolderDocumentsGroups | Document Tab Registers |
| MARISysMenu | System: Menu contents for the different clients (Fat, Web, customer portal..) |
| MARISysReports | Reporting: User Report definition |
| MARISysUserFormPages | SDK: User-Defined Tables: Form Pages |
| MARISysUserTable | SDK: User-Defined Tables: Table description |
| MARIEquipmentCategory | EquipmentCategory: Cagetory Master |
| MARISysUserQueryGroup | System: User Defined Groups for Queries |
| MARISysUserFieldsGroup | System: Header for user defined groups |
| MARIInfoScreenManagementBreakEvenColumnHead | Info Screen Management: Column Definition Head |
| MARICustomerServiceObjectCategory | Group to manage properties by group |
| MARISupportWorkflowTransition | Support Module: Workflow definition for the status transition |
| MARISysMenuFavorites | System: User Menu |
| MARIFolderDocumentTree | Master Data Folder Search Tree |
| MARIChefInfoDashboard | Project Dash Board Settings |
| MARISysAddOns | Manage Programm Add Ons in MARI |
| MARITenantMonitorAppUserGroups | Bucket to store installation data at client location: installed user groups |
| MARITenantUserGroups | Management of MARIProject/SBO client installations user groups |
| MARISupportClassType | Support Module: Settings by class type (Ticket, Task, Idea, DevTask, HR Task) |
| MARIBook | Project Dokumentation: Book Header |
| MARIBookArchive | Project Dokumentation: Archived Book Content |
| MARIBookLink | Project Dokumentation: externale links to pages |
| MARIBookLinkArchive | Project Dokumentation: externale link archive |
| MARIBookPage | Project Dokumentation: Book Page (Left hierarchy) |
| MARIBookPageArchive | Project Dokumentation: Book Page Archive (Left hierarchy) |