| Table Name: | MPDocumentDraftPositionLink |
| View Name: | MARIDocumentDraftPositionLink |
| Group: | Group: DocumentDraftHead |
| Description: | Linked positions in the sales contract and or purchase process |
| ClassID: | 351. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| DocumentDraftPosLinkID | DocumentDraftPosLinkID INT Primary |
||
| DocumentDraftPosID | DocumentDraftPosID INT Index |
MPDocumentDraftPosition.DocumentDraftPosID | |
| DocumentDraftLinkID | DocumentDraftLinkID INT Index |
||
| DocumentDraftLinkStatus | DocumentDraftLinkStatus INT |
||
| Project | Project NVARCHAR (20) |
MPProjektstamm.Projektnummer | |
| Phase | PhaseID INT |
MPProjektPhasen.PhasenID | |
| SalesContract | SalesContract INT |
||
| SalesContractPos | SalesContractPos INT |
||
| SalesContractHandling | SalesContractHandling INT |
||
| PurchaseProcess | PurchaseProcess INT |
MPEKVertraege.VertragsID | |
| PurchaseProcessPos | PurchaseProcessPos INT |
MPEKVertraegePositionen.Vertragsposition | |
| PurchaseProcessHandling | PurchaseProcessHandling INT |
||
| Quantity | Quantity NUMERIC(19,6) |
||
| QuantityRequest | QuantityRequest NUMERIC(19,6) |
||
| QuantityMakeOrBuy | QuantityMakeOrBuy NUMERIC(19,6) |
||
| Quantity4Service | Quantity4Service NUMERIC(19,6) |
||
| QuantityCount | QuantityCount NUMERIC(19,6) |
||
| CountText | CountText NVARCHAR (100) |
||
| Warehouse | Warehouse NVARCHAR (20) |
OWHS.WhsCode | |
| BinLocations | BinLocations NTEXT |
||
| ContainerBin | ContainerBin NTEXT |
||
| SourceWarehouse | SourceWarehouse NVARCHAR (20) |
OWHS.WhsCode | |
| SourceBinLocations | SourceBinLocations NTEXT |
||
| SourceContainerBin | SourceContainerBin NTEXT |
||
| GLAccount | GLAccount NVARCHAR (20) |
OACT.AcctCode | |
| GLAccountManual | GLAccountManual SMALLINT (0=false,-1=true) |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) Index |
MPEquipment.EquipmentCode | |
| EquipmentSubject | EquipmentSubject NVARCHAR (20) |
MPEquipmentCategorySubject.EquipmentSubject | |
| EquipmentCategory | EquipmentCategory INT |
MPEquipmentCategory.EquipmentCategory | |
| MPInsID | MPInsID INT |
MPCustomerEquipmentCard.MPinsID | |
| ProjectCode | ProjectCode NVARCHAR (20) |
OPRJ.PrjCode | |
| CostCenter | CostCenter NVARCHAR (20) |
OPRC.PrcCode (WHERE [DimCode]=1) | |
| OcrCode2 | OcrCode2 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=2) | |
| OcrCode3 | OcrCode3 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=3) | |
| OcrCode4 | OcrCode4 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=4) | |
| OcrCode5 | OcrCode5 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=5) | |
| Company | Company SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| TransactionType | TransactionType INT |
||
| TransactionID | TransactionID INT |
||
| MPBelID | MARIDocID INT Index |
MPEKVertraegeBelege.MPBelID | |
| MPBelPosID | DocPosID INT Index |
MPEKVertraegeBelegePositionen.MPBelPosID | |
| ERPDocEntry | ERPDocEntry INT |
||
| ERPDocLine | ERPDocLine INT |
||
| SourceMPBelID | SourceMPBelID INT Index |
MPEKVertraegeBelege.MPBelID | |
| SourceMPBelPosID | SourceMPBelPosID INT Index |
MPEKVertraegeBelegePositionen.MPBelPosID | |
| SourceERPDocType | SourceERPDocType INT |
||
| SourceERPDocEntry | SourceERPDocEntry INT |
||
| SourceERPDocLine | SourceERPDocLine NVARCHAR (50) |
||
| SourceWorkItemPosition | SourceWorkItemPosition INT |
MPWorkItemPosition.WorkItemPosID | |
| QualityStatus | QualityStatus INT |
||
| LinkEditMode | LinkEditMode INT |
||
| InvoiceHandlingOption | InvoiceHandlingOption INT |
||
| IssueMethod | IssueMethod INT |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) |
| Table | Description |
|---|---|
| MPDocumentDraftPositionLinkBatch | Used batches |
| MPDocumentDraftPositionLinkSerial | Used/reserved serial numbers |
| MPDocumentDraftPositionLinkTax | Positions based on the order of the paper document sub tax |
| MPGebindeZeile | Container Lines to see the goods in the container |