| Table Name: | MPEKVertraegeBelegePositionen |
| View Name: | MARIPurchaseProcessDocumentPositions |
| Group: | Group: MPEKVertraegeBelege |
| Description: | Purchase Process: Purchase Document (Positions) |
| ClassID: | 140. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| MPBelID | MARIDocID INT Index |
MPEKVertraegeBelege.MPBelID | |
| MPBelPosID | MARIDocPosID INT Primary |
MPEKVertraegeBelegePositionen.MPBelPosID | |
| MPPosTyp | MARIDocType SMALLINT |
clsImportSalesContractDocument_clsDocumentPositions_eMPPosTypes | |
| MPSammelBelPosID | CollectingPosID INT Index |
||
| BelPosID | DocumentPosID INT Index |
OPOR.LineNum | OPOR.LineNum |
| Mandant | Company SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| BelID | DocEntry INT Index |
POR1.DocEntry | |
| DocLineNum | DocLineNum INT |
||
| DocLineSeq | DocLineSeq INT |
||
| VorPosID | LinkedPositionType INT |
||
| Index | PositionIndex INT |
||
| Position | PositionText NVARCHAR (50) |
||
| PosType | PosType SMALLINT |
||
| Status | Status SMALLINT |
||
| Artikelnummer | ItemCode NVARCHAR (50) |
OITM.ItemCode | |
| SubCatNum | SubCatNum NVARCHAR (50) |
||
| SourceKeyType | SourceKeyType INT |
||
| SourceKey | SourceKey NVARCHAR (20) |
||
| Artikelgruppe | ItemGroup NVARCHAR (15) |
||
| StuecklistenTyp | BillOfMaterialType SMALLINT |
||
| StuecklistenAndruck | BillOfMaterialPrint SMALLINT |
||
| Nachweispflicht | BatchMode SMALLINT |
||
| Bezeichnung1 | Description1 NVARCHAR (200) |
||
| Bezeichnung2 | Description2 NVARCHAR (200) |
||
| Lieferwoche | DeliveryWeek INT |
||
| Liefertermin | DeliveryDate Datetime |
||
| Lieferzeit | LeadTime INT |
||
| MietStartDatum | RentalStartDate Datetime |
||
| Lagerort | WarehouseCode NVARCHAR (10) |
OWHS.WhsCode | |
| LagerPlaetze | BinLocations NTEXT |
||
| Gebinde | ContainerBins NTEXT |
||
| QuellLagerOrt | SourceWarehouse NVARCHAR (10) |
OWHS.WhsCode | |
| QuellLagerPlaetze | SourceBinLocations NTEXT |
||
| QuellGebinde | SourceContainerBins NTEXT |
||
| LinkedBusinessPartner | LinkedBusinessPartner NVARCHAR (20) |
OCRD.CardCode | |
| Steuercode | TaxCode NVARCHAR (10) |
||
| Steuersatz | TaxRate NUMERIC(19,6) |
||
| Steuerklasse | TaxClass SMALLINT |
||
| SteuerManuell | TaxManual SMALLINT (0=false,-1=true) |
||
| SteuerPosSub | SteuerPosSub SMALLINT (0=false,-1=true) |
||
| TaxWtLiable | TaxWtLiable SMALLINT (0=false,-1=true) |
||
| TaxUsage | TaxUsage INT |
||
| TaxCSTcode | TAXCSTcode NVARCHAR (4) |
||
| TaxCFOPcode | TaxCFOPCode NVARCHAR (6) |
||
| LocationID | LocationID INT |
||
| Erloescode | RevenueCode SMALLINT |
||
| Sachkonto | GLAccount NVARCHAR (20) |
OACT.AcctCode | |
| SachkontoManuell | GLAccountManual SMALLINT (0=false,-1=true) |
||
| Kostenstelle | OcrCode1 NVARCHAR (20) |
OOCR.OcrCode (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) | |
| Kostentraeger | ProjectCode NVARCHAR (20) |
OPRJ.PrjCode | |
| NetUnitPriceSys | NetUnitPriceSys NUMERIC(19,6) |
||
| NetUnitPriceLoc | NetUnitPriceLoc NUMERIC(19,6) |
||
| Einzelpreis | NetUnitPriceFC NUMERIC(19,6) |
||
| EinzelpreisNks | UnitPriceDecimals SMALLINT |
||
| EinzelpreisManuell | UnitPriceManual SMALLINT |
||
| RabattfaehigPos | DiscountFlag SMALLINT |
||
| RabattfaehigArtikel | DiscountFlagItem SMALLINT |
||
| Rabatt | DiscountPercent NUMERIC(19,6) |
||
| DiscountValueSys | DiscountValueSys NUMERIC(19,6) |
||
| DiscountValueLoc | DiscountValueLoc NUMERIC(19,6) |
||
| Rabattbetrag | DiscountValueFc NUMERIC(19,6) |
||
| NetTotalSys | NetTotalSys NUMERIC(19,6) |
||
| NetTotalLoc | NetTotalLoc NUMERIC(19,6) |
||
| Gesamtpreis | NetTotalFC NUMERIC(19,6) |
||
| GesamtpreisIntern | NetDiscountedTotalFC NUMERIC(19,6) |
||
| GesamtpreisInternEW | NetDiscountedTotalSys NUMERIC(19,6) |
||
| NetDiscountedTotalLoc | NetDiscountedTotalLoc NUMERIC(19,6) |
||
| IstGewaehrleistung | WarrantyPos SMALLINT |
||
| PurchasePriceAvgSys | PurchasePriceAvgSys NUMERIC(19,6) |
||
| PurchasePriceAvgLoc | PurchasePriceAvgLoc NUMERIC(19,6) |
||
| MittlererEK | PurchasePriceAvgFC NUMERIC(19,6) |
||
| Menge | Quantity NUMERIC(19,6) |
||
| Mengeneinheit | UoM NVARCHAR (20) |
||
| MengeArt | QuantityType SMALLINT |
||
| MengeBasis | QuantityBasis NUMERIC(19,6) |
||
| MengeBasiseinheit | BaseUoM NVARCHAR (5) |
||
| MengeBasisNKS | QtyDecimals SMALLINT |
||
| MengeVKEinheit | QtySalesUnit NVARCHAR (20) |
||
| MengeVKUmrechnung | QtySalesFactor NUMERIC(19,6) |
||
| MengeVKBerechnung | QtySalesFactorCalc NVARCHAR (50) |
||
| MengeVKDimensionen | StySalesDimension NVARCHAR (50) |
||
| MengeVKNKS | QtySalesDecimals SMALLINT |
||
| MengeVPEinheit | QtyPackageUnit NVARCHAR (20) |
||
| MengeVPUmrechnung | QtyPackageFactor NUMERIC(19,6) |
||
| MengeVPNKS | QtyPackageDecimal SMALLINT |
||
| MengeOffen | QtyOpen NUMERIC(19,6) |
||
| MengeAnzahl | QuantityCount NUMERIC(19,6) |
||
| MengeDauer | QuantityDuration NUMERIC(19,6) |
||
| MengeAnzahlText | QuantityCountText NVARCHAR (100) |
||
| MengenFormelID | QuantityFormularID INT Index |
MPSetupMengenFormel.MengenFormelID | |
| BasisAnzahl | BasisAnzahl NUMERIC(19,6) |
||
| Dimensionstext | PositionInfo NTEXT |
||
| Langtext | AccountingInfo NTEXT |
||
| Preiseinheit | PriceUnit INT |
||
| IstErledigt | IsClosed SMALLINT |
||
| Seitenumbruch | Pagination SMALLINT |
||
| LagerbuchungID | WarehouseTransaction INT Index |
||
| ReferenzMPBelPosID | ReferenceMPBelPosID INT Index |
||
| ReferenceItem | ReferenceItem NVARCHAR (50) |
Original item code: Used, when item code is substitured | OITM.ItemCode |
| Provisionsfaehig | ProvisionYesNo SMALLINT |
||
| Provisionssatz | ProvisionRate NUMERIC(19,6) |
||
| Chargenpflicht | Batch SMALLINT |
||
| Einzelgewicht | SingleWeight NUMERIC(19,6) |
||
| Gesamtgewicht | TotalWeight NUMERIC(19,6) |
||
| Hauptartikelgruppe | MainItemGroup NVARCHAR (15) |
||
| Vaterartikelgruppe | ParentItemGroup NVARCHAR (15) |
||
| MengeGPEinheit | QtyBaseUnit NVARCHAR (5) |
||
| MengeGPUmrechnung | QtyBaseFactor NUMERIC(19,6) |
||
| ERPVerweisID | ERPLinkID INT Index |
DocEntry of source line | OPOR.DocEntry |
| ERPVerweisZeile | ERPDocPosID INT |
||
| ERPVerweisTyp | ERPLinkType INT |
SBO Tablle ID | |
| ERPActualBaseEntry | ERPActualBaseEntry INT |
||
| ERPActualBaseLine | ERPActualBaseLine INT |
||
| QualityStatus | QualityStatus INT |
||
| RequestPhaseID | RequestPhaseID INT Index |
MPProjektPhasen.PhasenID | |
| ProRataID | ProRataID INT Index |
MPSysProRata.ProRataID (WHERE ProRataType=479) | |
| ProRataStartDate | ProRataStartDate Datetime |
||
| ProRataEndDate | ProRataEndDate Datetime |
||
| ProRataNumberOfPeriods | ProRataNumberOfPeriods INT |
||
| ProRataMPTAN | ProRataMPTAN INT Index |
MPFiBuPositionen.TAN (WHERE HerkunftsTyp=15) | |
| WartungStart | ServiceStartDate Datetime |
||
| WartungEnde | ServiceEndDate Datetime |
||
| SacEntry | SacEntry INT |
V5.4 India Localization | OSAC.AbsEntry |
| KeineLagerbewegung | NoInvtryMv SMALLINT (0=false,-1=true) |
INV1.NoInvtryMv for CreditMemos to supress the delivery | INV1.NoInvtryMv |
| AusgabeMethode | IssueMethod INT |
||
| AccrualRuleID | AccrualRuleID INT |
MPSysProRata.ProRataID (WHERE ProRataType=662) | |
| AccrualMPTAN | AccrualMPTAN INT |
MPFiBuPositionen.TAN (WHERE HerkunftsTyp=19) | |
| Height1 | Height1 NUMERIC(19,6) |
||
| Hght1Unit | Hght1Unit SMALLINT |
||
| Width1 | Width1 NUMERIC(19,6) |
||
| Wdth1Unit | Wdth1Unit SMALLINT |
||
| Length1 | Length1 NUMERIC(19,6) |
||
| Len1Unit | Len1Unit SMALLINT |
||
| Volume | Volume NUMERIC(19,6) |
||
| VolUnit | VolUnit SMALLINT |
||
| Weight1 | Weight1 NUMERIC(19,6) |
||
| Wght1Unit | Wght1Unit SMALLINT |
||
| WorkItemID | WorkItemID INT Index |
||
| WorkItemPosID | WorkItemPosID NVARCHAR (255) |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPDocumentDraftPositionLink | Linked positions in the sales contract and or purchase process |
| MPEKVertraegeBelegeILVPos | Purchase Process: Document Internal Service Change Positions |
| MPEKVertraegeBelegePositionen | Purchase Process: Purchase Document (Positions) |
| MPEKVertraegeBelegePositionenCharge | Purchase Process: Purchase Document (Positions+Batches) |
| MPEKVertraegeBelegePositionenSerie | Purchase Process: Purchase Document (Positions+Serial) |
| MPEKVertraegeBelegePositionenSteuer | Purchase Process: Purchase Document (Positions+Tax) |
| MPEKVertraegeBelegeSteuer | Purchase Process: Purchase Document (Tax) |
| MPEKVertraegePos2BelPos | Purchase Process: Link between PO document line and PO process position |
| MPEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MPProjektArbeitspaketerfassung | Work Packages progress reporting by day |
| MPProjektArtikelerfassung | Time Keeping: ProjectTimeKeepingItems: For items used in a project each entry is stored in this table. This table is also linked to the header: MPProjectBuchungskopf |
| MPProjektBuchungserfassung | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |
| MPProjektLeistungserfassung | Time Keeping: ProjectTimeKeepingLinesServices: additional lines for the MPProjectBuchungserfassung for the project types: customer project and internal project with contract. This table stores the link to the contract and contract position |