| Table Name: | MPDocumentDraftHeadLink |
| View Name: | MARIDocumentDraftHeadLink |
| Group: | Group: DocumentDraftHead |
| Description: | Linked contracts and purchase processes |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| DocumentDraftLinkID | DocumentDraftLinkID INT Primary |
||
| DocumentDraftID | DocumentDraftID INT Index |
MPDocumentDraftHead.DocumentDraftID | |
| LinkType | LinkType INT |
||
| OrderLine | OrderLine INT |
||
| Project | Project NVARCHAR (20) |
MPProjektstamm.Projektnummer | |
| Phase | PhaseID INT |
MPProjektPhasen.PhasenID | |
| SalesContract | SalesContract INT |
MPVKVertraege.VertragsID | |
| PurchaseProcess | PurchaseProcess INT |
MPEKVertraege.VertragsID | |
| WorkItemID | WorkItemID INT Index |
MPWorkItem.WorkItemID | |
| LinkPercent | LinkPercent NUMERIC(19,6) |
||
| MPBelID | MARIDocID INT Index |
MPEKVertraegeBelege.MPBelID | |
| SourceMPBelID | SourceMPBelID INT Index |
MPEKVertraegeBelege.MPBelID | |
| SourceERPDocType | SourceERPDocType INT |
||
| SourceERPDocEntry | SourceERPDocEntry INT |
OINV.DocEntry | |
| TimeBookingEmployee | TimeBookingEmployee NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |