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