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