| Table Name: | MPSammelmappe |
| View Name: | MARIFolderDocuments |
| Group: | Group: FolderDocuments |
| Description: | Master Data Folder Documents |
| ClassID: | 403. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| MappenID | FolderID INT Primary |
||
| ClassID | ClassID INT Index |
Dimension | ClassID |
| ClassKey | ClassKey NVARCHAR (50) Index |
Key of core data | |
| Gruppe | GroupId SMALLINT |
Link to folder | MPSammelmappeGruppen.GruppenID |
| SammelMappeBaumID | SammelMappeBaumID INT Index |
||
| Datum | DocDate Datetime |
||
| Benutzer | UserCode NVARCHAR (255) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Titel | Title NVARCHAR (255) |
||
| Quelle | Source NVARCHAR (255) |
File name while import | |
| Dokument | Document NTEXT |
||
| DokumentenTyp | DocumentType INT |
1=MPDokumente;2=MPBilder (Pictures) | clsImportDocument_eDocumentType |
| DokumentenID | DocumentID INT Index |
MARIDocuments | MPDokumente.DocID |
| DocumentVersionID | DocumentVersionID INT Index |
||
| DMSSystem | DMSSystem INT |
Code for the DMS System | |
| DMSDokumentID | DMSDocumentID NVARCHAR (255) Index |
Internal Key in the DMS System | |
| IndexFormID | IndexFormID INT Index |
MPSammelmappeIndexForms.IndexFormID | |
| IndexDocumentType | IndexDocumentType INT |
||
| StatusPosteingang | StatusInbox INT |
||
| OCRMode | OCRMode INT |
||
| MessageActionID | MessageActionID INT Index |
||
| AttachmentID | AttachmentID INT Index |
MPSysMessagesAttachment.AttachmentID | |
| Freigabe | ApprovalMode SMALLINT (0=false,-1=true) |
||
| FreigegebenAm | ApprovedDate Datetime |
||
| FreigegebenID | ApprovedUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| FreigabeText | ApprovalText NTEXT |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPEKVertraegeBelegeAnhaenge | Purchase Process: Link to Attachments |
| MPSammelmappeIndex | Document tagging |
| MPSammelmappeIndexValues | Index Form Values for MARIDMS |
| MPSammelmappeOCR | Additional Information via Document Recognition Services |
| MPVKVertraegeBelegeAnhaenge | Contract Management: Attachment Selection |