| Table Name: | MPEKVertraegeBelegeAnhaenge |
| View Name: | MARIPurchaseProcessDocumentAttachments |
| Group: | Group: MPEKVertraegeBelege |
| Description: | Purchase Process: Link to Attachments |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| MPBelAnhangID | MARIDocAttachmentID INT Primary |
internal key | |
| MPBelID | MARIDocID INT Index |
MPEKVertraegeBelege.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 |
MPSammelmappe.MappenID | |
| DocID | DocID INT Index |
||
| VersionsID | VersionID INT |
||
| BildID | PictureID INT Index |
||
| 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 |