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