| Table Name: | MPVKVertraegeBelegePositionen |
| View Name: | MARIContractDocumentPositions |
| Group: | Group: ContractDocument |
| Description: | Contract Management: Document Positions |
| ClassID: | 112. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| MPBelID | MARIDocID INT Index |
MPVKVertraegeBelege.MPBelID | |
| MPBelPosID | MARIDocPosID INT Primary |
||
| MPPosTyp | MARIDocType SMALLINT |
Position type for this position. | clsImportProjectContractPosition_eContractPositionType |
| MPSammelBelPosID | CollectingPosID INT Index |
||
| BelPosID | DocumentPosID INT Index |
INV1.LineNum | INV1.LineNum |
| Mandant | Company SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| BelID | DocEntry INT Index |
INV1.DocEntry | INV1.DocEntry |
| DocLineNum | DocLineNum INT |
||
| DocLineSeq | DocLineSeq INT |
||
| VorPosID | LinkedPositionType INT |
MPVKVertraegePositionen.Vertragsposition | |
| Index | PositionIndex INT |
||
| Position | PositionText NVARCHAR (50) |
||
| PosType | PosType SMALLINT |
clsImportSalesContractDocument_clsDocumentPositions_ePosTypes | |
| Status | Status SMALLINT |
||
| Artikelnummer | ItemCode NVARCHAR (50) Index |
Mandatory item number field for each line type positions. OITM.ItemCode | OITM.ItemCode |
| SubCatNum | SubCatNum NVARCHAR (50) |
not used right now | |
| SourceKeyType | SourceKeyType INT |
||
| SourceKey | SourceKey NVARCHAR (20) |
||
| Artikelgruppe | ItemGroup NVARCHAR (15) |
not used | |
| StuecklistenTyp | BillOfMaterialType SMALLINT |
not used | |
| StuecklistenAndruck | BillOfMaterialPrint SMALLINT |
not used | |
| Nachweispflicht | BatchMode SMALLINT |
1=Serial,2=batch | |
| Bezeichnung1 | Description1 NVARCHAR (200) |
First text field for this position. | |
| Bezeichnung2 | Description2 NVARCHAR (200) |
Second text field for this position. | |
| Lieferwoche | DeliveryWeek INT |
Delivery Week calculated based on the delivery date. | |
| Liefertermin | DeliveryDate Datetime |
Delivery date for this position. This field is also used as requested delivey dates (purchase order) | |
| Lieferzeit | LeadTime INT |
Lead Time in days | |
| MietStartDatum | RentalStartDate Datetime |
not used | |
| Lagerort | WarehouseCode NVARCHAR (10) |
OWHS.WhsCode | OWHS.WhsCode |
| LagerPlaetze | BinLocations NTEXT |
||
| Gebinde | ContainerBins NTEXT |
||
| QuellLagerOrt | SourceWarehouse NVARCHAR (10) |
OWHS.WhsCode | OWHS.WhsCode |
| QuellLagerPlaetze | SourceBinLocations NTEXT |
||
| QuellGebinde | SourceContainerBins NTEXT |
||
| LinkedBusinessPartner | LinkedBusinessPartner NVARCHAR (20) |
||
| Steuercode | TaxCode NVARCHAR (10) |
SAP Tax Code for US Tax mechanism. MARI Tax Code via mapping for European tax mechanism.
''' Leave this field empty to use the standard from the contract/purchase process position or if empty from the SBO default |
|
| 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 |
Not used | |
| Sachkonto | GLAccount NVARCHAR (20) |
OACT.AcctCode | OACT.AcctCode |
| SachkontoManuell | GLAccountManual SMALLINT (0=false,-1=true) |
||
| Kostenstelle | OcrCode1 NVARCHAR (20) |
OOCR.OcrCode | OOCR.OcrCode (WHERE [DimCode]=1) |
| OcrCode2 | OcrCode2 NVARCHAR (20) |
OOCR.OcrCode | OOCR.OcrCode (WHERE [DimCode]=2) |
| OcrCode3 | OcrCode3 NVARCHAR (20) |
OOCR.OcrCode | OOCR.OcrCode (WHERE [DimCode]=3) |
| OcrCode4 | OcrCode4 NVARCHAR (20) |
OOCR.OcrCode | OOCR.OcrCode (WHERE [DimCode]=4) |
| OcrCode5 | OcrCode5 NVARCHAR (20) |
OOCR.OcrCode | OOCR.OcrCode (WHERE [DimCode]=5) |
| Kostentraeger | ProjectCode NVARCHAR (20) |
OPRJ.PrjCode | 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) |
Rebate amount in document currency | |
| 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 |
not used | |
| PurchasePriceAvgSys | PurchasePriceAvgSys NUMERIC(19,6) |
not used | |
| PurchasePriceAvgLoc | PurchasePriceAvgLoc NUMERIC(19,6) |
not used | |
| MittlererEK | PurchasePriceAvgFC NUMERIC(19,6) |
||
| Menge | Quantity NUMERIC(19,6) |
||
| Mengeneinheit | UoM NVARCHAR (20) |
||
| MengeArt | QuantityType SMALLINT |
||
| MengeBasis | QuantityBasis NUMERIC(19,6) |
not used | |
| MengeBasiseinheit | BaseUoM NVARCHAR (5) |
not used | |
| MengeBasisNKS | QtyDecimals SMALLINT |
||
| MengeVKEinheit | QtySalesUnit NVARCHAR (20) |
not used | |
| 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, when item code is substituted | 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 |
Document Link to the ERP Document INV1.BaseEntry= INV1.DocEntry | |
| ERPVerweisZeile | ERPDocPosID INT |
Document Link to the ERP document INV1.BaseLineNum = INV1.LineNum | |
| ERPVerweisTyp | ERPLinkType INT |
Document Link to the ERP document INV1.BaseType | clsImportSalesContractDocument_clsDocumentPositions_eBaseType |
| ERPActualBaseEntry | ERPActualBaseEntry INT |
||
| ERPActualBaseLine | ERPActualBaseLine INT |
||
| QualityStatus | QualityStatus INT |
||
| RequestPhaseID | RequestPhaseID INT Index |
MPProjektPhasen.PhasenID | |
| ProRataID | ProRataID INT Index |
MPSysProRata.ProRataID (WHERE ProRataType=478) | |
| ProRataStartDate | ProRataStartDate Datetime |
||
| ProRataEndDate | ProRataEndDate Datetime |
||
| ProRataNumberOfPeriods | ProRataNumberOfPeriods INT |
||
| ProRataMPTAN | ProRataMPTAN INT Index |
MPFiBuPositionen.TAN (WHERE HerkunftsTyp=14) | |
| 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=661) | |
| AccrualMPTAN | AccrualMPTAN INT |
MPFiBuPositionen.TAN (WHERE HerkunftsTyp=18) | |
| 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 |
|---|---|
| MPCommissionDocumentPositions | Commission: Sales Rep A/P Invoice Position Link |
| MPCustomerEquipmentLocation | Current location of a CSO at the client/Project |
| MPDocumentInvoiceFlowPosition | InvoicePaymentReportStore Positions |
| MPEKVertraegePositionen | Purchase Process: PO Process Position (equivilant to contract position) |
| MPEquipmentLocation | Equipment: Current Location of this equipment |
| MPEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MPGebindeLocation | Current location of a container |
| MPGebindeZeile | Container Lines to see the goods in the container |
| 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 |
| MPTmpRptPrintPositionen | Reporting: Temporary Table: Document Positions |
| MPVKVertraegeBelegeILVPos | Contract Management: Document Internal Service Charges Positions |
| MPVKVertraegeBelegePositionenCharge | Contract Management: Document Positions Batches |
| MPVKVertraegeBelegePositionenSerie | Contract Management: Document Positions Serial Numbers |
| MPVKVertraegeBelegePositionenSteuer | Contract Management: Document Positions Tax |
| MPVKVertraegePos2BelPos | Contract Management: Contract document position to document position link |
| MPVKVertraegePositionen | Contract Management: Contract positions (also service master positions) |
| MPWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |