| Table Name: | MPVKVertraegeBelegeAnhaenge |
| View Name: | MARIContractDocumentAttachments |
| Group: | Group: ContractDocument |
| Description: | Contract Management: Attachment Selection |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| MPBelAnhangID | MARIDocAttachmentID INT Primary |
internal key | |
| MPBelID | MARIDocID INT Index |
Link to the document | MPVKVertraegeBelege.MPBelID |
| SourceClassID | SourceClassID INT Index |
Link to source object | ClassID |
| SourceClassKey | SourceClassKey NVARCHAR (50) Index |
Internal key of the source object | |
| Auswahl | Selection INT |
Selection 1=attachment, 2=embeded | |
| InVerzeichnis | OnIndex SMALLINT (0=false,-1=true) |
||
| AnhangTyp | AttachmentType INT Index |
Source type, Document, Picture, DMS | |
| GruppenID | GroupID INT Index |
MPSammelmappeGruppen.GruppenID | |
| MappenID | FolderID INT |
Uses the groupID for DMS documents | MPSammelmappe.MappenID |
| DocID | DocID INT Index |
MPSammelmappe.DokumentenID | |
| VersionsID | VersionID INT |
MPSammelmappe.DocumentVersionID | |
| BildID | PictureID INT Index |
MPBilder.BildID | |
| DMSSystem | DMSSystem INT |
Code for the DMS System | |
| DMSDokumentID | DMSDocumentID NVARCHAR (255) Index |
Internal Key in the DMS System | |
| SeitenFilter | PageFilter NVARCHAR (100) |
1-3,6,9-122 | |
| Dateiname | FileName NVARCHAR (255) |
||
| Reihenfolge | SortOrder INT |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Erstanlage | CreateDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| UpdateStamp | UpdateStamp INT |