| View Name: | MARIContractDocumentAttachments |
| Based on table: | MPVKVertraegeBelegeAnhaenge |
| Group: | Group: ContractDocument |
| Description: | Contract Management: Attachment Selection |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| MARIDocAttachmentID | MPBelAnhangID INT Primary |
internal key | |
| MARIDocID | MPBelID INT Index |
Link to the document | MARIContractDocument.MARIDocID |
| SourceClassID | SourceClassID INT Index |
Link to source object | ClassID |
| SourceClassKey | SourceClassKey NVARCHAR (50) Index |
Internal key of the source object | |
| Selection | Auswahl INT |
Selection 1=attachment, 2=embeded | |
| OnIndex | InVerzeichnis SMALLINT (0=false,-1=true) |
||
| AttachmentType | AnhangTyp INT Index |
Source type, Document, Picture, DMS | |
| GroupID | GruppenID INT Index |
MARIFolderDocumentsGroups.GroupID | |
| FolderID | MappenID INT |
Uses the groupID for DMS documents | MARIFolderDocuments.FolderID |
| DocID | DocID INT Index |
MARIFolderDocuments.DocID | |
| VersionID | VersionsID INT |
MARIFolderDocuments.VersionID | |
| PictureID | BildID INT Index |
MARIPictures.PictureID | |
| DMSSystem | DMSSystem INT |
Code for the DMS System | |
| DMSDocumentID | DMSDokumentID NVARCHAR (255) Index |
Internal Key in the DMS System | |
| PageFilter | SeitenFilter NVARCHAR (100) |
1-3,6,9-122 | |
| FileName | Dateiname NVARCHAR (255) |
||
| SortOrder | Reihenfolge 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 |