| View Name: | MARIDocumentDraftHeadLink |
| Based on table: | MPDocumentDraftHeadLink |
| Group: | Group: DocumentDraftHead |
| Description: | Linked contracts and purchase processes |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| DocumentDraftLinkID | DocumentDraftLinkID INT Primary |
||
| DocumentDraftID | DocumentDraftID INT Index |
MARIDocumentDraftHead.DocumentDraftID | |
| LinkType | LinkType INT |
||
| OrderLine | OrderLine INT |
||
| Project | Project NVARCHAR (20) |
MARIProjectMaster.Project | |
| PhaseID | Phase INT |
MARIProjectPhases.PhaseID | |
| SalesContract | SalesContract INT |
MARIContract.SalesContract | |
| PurchaseProcess | PurchaseProcess INT |
MARIPurchaseProcess.PurchaseProcess | |
| WorkItemID | WorkItemID INT Index |
MARIWorkItem.WorkItemID | |
| LinkPercent | LinkPercent NUMERIC(19,6) |
||
| MARIDocID | MPBelID INT Index |
MARIPurchaseProcessDocument.MARIDocID | |
| SourceMPBelID | SourceMPBelID INT Index |
MARIPurchaseProcessDocument.SourceMPBelID | |
| SourceERPDocType | SourceERPDocType INT |
||
| SourceERPDocEntry | SourceERPDocEntry INT |
OINV.DocEntry | |
| TimeBookingEmployee | TimeBookingEmployee NVARCHAR (20) |
MARIEmployeeMaster.TimeBookingEmployee | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |