| View Name: | MARIDocumentDraftPositionLink |
| Based on table: | MPDocumentDraftPositionLink |
| Group: | Group: DocumentDraftHead |
| Description: | Linked positions in the sales contract and or purchase process |
| ClassID: | 351. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| DocumentDraftPosLinkID | DocumentDraftPosLinkID INT Primary |
||
| DocumentDraftPosID | DocumentDraftPosID INT Index |
MARIDocumentDraftPosition.DocumentDraftPosID | |
| DocumentDraftLinkID | DocumentDraftLinkID INT Index |
||
| DocumentDraftLinkStatus | DocumentDraftLinkStatus INT |
||
| Project | Project NVARCHAR (20) |
MARIProjectMaster.Project | |
| PhaseID | Phase INT |
MARIProjectPhases.PhaseID | |
| SalesContract | SalesContract INT |
||
| SalesContractPos | SalesContractPos INT |
||
| SalesContractHandling | SalesContractHandling INT |
||
| PurchaseProcess | PurchaseProcess INT |
MARIPurchaseProcess.PurchaseProcess | |
| PurchaseProcessPos | PurchaseProcessPos INT |
MARIPurchaseProcessPositions.PurchaseProcessPos | |
| 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 |
MARIEquipmentMaster.EquipmentCode | |
| EquipmentSubject | EquipmentSubject NVARCHAR (20) |
MARIEquipmentCategorySubject.EquipmentSubject | |
| EquipmentCategory | EquipmentCategory INT |
MARIEquipmentCategory.EquipmentCategory | |
| MPInsID | MPInsID INT |
MARICustomerServiceObject.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 |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| TransactionType | TransactionType INT |
||
| TransactionID | TransactionID INT |
||
| MARIDocID | MPBelID INT Index |
MARIPurchaseProcessDocument.MARIDocID | |
| DocPosID | MPBelPosID INT Index |
MARIPurchaseProcessDocumentPositions.DocPosID | |
| ERPDocEntry | ERPDocEntry INT |
||
| ERPDocLine | ERPDocLine INT |
||
| SourceMPBelID | SourceMPBelID INT Index |
MARIPurchaseProcessDocument.SourceMPBelID | |
| SourceMPBelPosID | SourceMPBelPosID INT Index |
MARIPurchaseProcessDocumentPositions.SourceMPBelPosID | |
| SourceERPDocType | SourceERPDocType INT |
||
| SourceERPDocEntry | SourceERPDocEntry INT |
||
| SourceERPDocLine | SourceERPDocLine NVARCHAR (50) |
||
| SourceWorkItemPosition | SourceWorkItemPosition INT |
MARIWorkItemPosition.SourceWorkItemPosition | |
| QualityStatus | QualityStatus INT |
||
| LinkEditMode | LinkEditMode INT |
||
| InvoiceHandlingOption | InvoiceHandlingOption INT |
||
| IssueMethod | IssueMethod INT |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) |
| Table | Description |
|---|---|
| MARIDocumentDraftPositionLinkBatch | Used batches |
| MARIDocumentDraftPositionLinkSerial | Used/reserved serial numbers |
| MARIDocumentDraftPositionTax | Positions based on the order of the paper document sub tax |
| MARIContainerLine | Container Lines to see the goods in the container |