| View Name: | MARIFolderDocumentsGroups |
| Based on table: | MPSammelmappeGruppen |
| Group: | Group: FolderDocuments |
| Description: | Document Tab Registers |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ClassID | ClassID INT Primary |
ClassID | |
| GroupID | GruppenID INT Primary |
||
| Indent | Indent INT |
||
| Parent | Parent INT |
MARIFolderDocumentsGroups.Parent | |
| TreeType | BlattTyp SMALLINT |
||
| PositionID | Position SMALLINT |
||
| Description | Bezeichnung NVARCHAR (40) |
||
| PageType | PageTyp INT |
DMS Method | |
| LinkToClassID | LinkToClassID INT |
Link to folder from a sub class (Item) | ClassID |
| LinkToGroup | LinkToGroup INT |
FolderGroupID | MARIFolderDocumentsGroups.LinkToGroup |
| GroupMemo | GruppenMemo NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| DefaultFolder | DefaultVerzeichnis NVARCHAR (200) |
||
| LinkPrefix | LinkPrefix NVARCHAR (200) |
||
| InAllFolder | InAllFolder SMALLINT (0=false,-1=true) |
||
| ShowDocInAttachments | ShowDocInAttachments INT |
||
| DefaultPreSelectFilter | DefaultPreSelectFilter INT |
||
| DefaultPreSelectEmail | DefaultPreSelectEmail INT |
||
| ComapnyFilter | MandantFilter INT |
||
| CompanySource | MandantQuelle SMALLINT |
||
| ArchivePatternID | ArchivePatternID INT Index |
MARISysArchivePattern.ArchivePatternID | |
| DMSAdditionalFilter | DMSAdditionalFilter NVARCHAR (255) |
||
| IconID | IconID INT |
||
| GroupIDParent | GruppenIDParent INT Index |
Link to the main folder for projects | MARIFolderDocumentsGroups.GroupIDParent |
| ForClassKey | FuerClassKey NVARCHAR (50) Index |
Key for project specific special folder | |
| FolderSettings | MappenSettings NTEXT |
Special settings for a project document site | |
| TitlePlaceHolder | TitelPlatzhalter NVARCHAR (255) |
||
| 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) | |
| RightsWebLanRead | LesenWebLan BIGINT |
MARIUserGroups.RightsWebLanRead (WHERE BenutzerTyp=1) | |
| RightsWebLanChange | AendernWebLan BIGINT |
MARIUserGroups.RightsWebLanChange (WHERE BenutzerTyp=1) | |
| RightsWebLanCreate | EinfuegenWebLan BIGINT |
MARIUserGroups.RightsWebLanCreate (WHERE BenutzerTyp=1) | |
| RightsWebLanDelete | LoeschenWebLan BIGINT |
MARIUserGroups.RightsWebLanDelete (WHERE BenutzerTyp=1) | |
| RightsWebLanAll | AllesWebLan BIGINT |
MARIUserGroups.RightsWebLanAll (WHERE BenutzerTyp=1) | |
| RightsWebWanRead | LesenWebWan BIGINT |
MARIUserGroups.RightsWebWanRead (WHERE BenutzerTyp=1) | |
| RightsWebWanChange | AendernWebWan BIGINT |
MARIUserGroups.RightsWebWanChange (WHERE BenutzerTyp=1) | |
| RightsWebWanCreate | EinfuegenWebWan BIGINT |
MARIUserGroups.RightsWebWanCreate (WHERE BenutzerTyp=1) | |
| RightsWebWanDelete | LoeschenWebWan BIGINT |
MARIUserGroups.RightsWebWanDelete (WHERE BenutzerTyp=1) | |
| RightsWebWanAll | AllesWebWan BIGINT |
MARIUserGroups.RightsWebWanAll (WHERE BenutzerTyp=1) | |
| CustomerPortalRightsRead | KundeLesen BIGINT |
MARIUserGroups.CustomerPortalRightsRead (WHERE BenutzerTyp=2) | |
| CustomerPortalRightsChange | KundeAendern BIGINT |
MARIUserGroups.CustomerPortalRightsChange (WHERE BenutzerTyp=2) | |
| CustomerPortalRightsCreate | KundeEinfuegen BIGINT |
MARIUserGroups.CustomerPortalRightsCreate (WHERE BenutzerTyp=2) | |
| CustomerPortalRightsDelete | KundeLoeschen BIGINT |
MARIUserGroups.CustomerPortalRightsDelete (WHERE BenutzerTyp=2) | |
| CustomerPortalRightsAll | KundeAlles BIGINT |
MARIUserGroups.CustomerPortalRightsAll (WHERE BenutzerTyp=2) | |
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIQualityProcess | QualityProcess Definition |
| MARIFolderDocuments | Master Data Folder Documents |
| MARIFolderDocumentsGroups | Document Tab Registers |
| MARIFolderDocumentTree | Master Data Folder Search Tree |
| MARIBookPrintFolder | Project Dokumentation: Print Defnition Linked Folder Documents |
| MARIBookPageElements | Project Dokumentation: Book Page Content Element |
| MARIBookPageElementArchive | Project Dokumentation: Book Page Content Element Archive |
| MARIPurchaseProcessDocumentAttachments | Purchase Process: Link to Attachments |
| MARIContractDocumentAttachments | Contract Management: Attachment Selection |