| View Name: | MARIContractDocumentPositions |
| Based on table: | MPVKVertraegeBelegePositionen |
| Group: | Group: ContractDocument |
| Description: | Contract Management: Document Positions |
| ClassID: | 112. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| MARIDocID | MPBelID INT Index |
MARIContractDocument.MARIDocID | |
| MARIDocPosID | MPBelPosID INT Primary |
||
| MARIDocType | MPPosTyp SMALLINT |
Position type for this position. | clsImportProjectContractPosition_eContractPositionType |
| CollectingPosID | MPSammelBelPosID INT Index |
||
| DocumentPosID | BelPosID INT Index |
INV1.LineNum | INV1.LineNum |
| Company | Mandant SMALLINT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| DocEntry | BelID INT Index |
INV1.DocEntry | INV1.DocEntry |
| DocLineNum | DocLineNum INT |
||
| DocLineSeq | DocLineSeq INT |
||
| LinkedPositionType | VorPosID INT |
MARIContractPositions.LinkedPositionType | |
| PositionIndex | Index INT |
||
| PositionText | Position NVARCHAR (50) |
||
| PosType | PosType SMALLINT |
clsImportSalesContractDocument_clsDocumentPositions_ePosTypes | |
| Status | Status SMALLINT |
||
| ItemCode | Artikelnummer 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) |
||
| ItemGroup | Artikelgruppe NVARCHAR (15) |
not used | |
| BillOfMaterialType | StuecklistenTyp SMALLINT |
not used | |
| BillOfMaterialPrint | StuecklistenAndruck SMALLINT |
not used | |
| BatchMode | Nachweispflicht SMALLINT |
1=Serial,2=batch | |
| Description1 | Bezeichnung1 NVARCHAR (200) |
First text field for this position. | |
| Description2 | Bezeichnung2 NVARCHAR (200) |
Second text field for this position. | |
| DeliveryWeek | Lieferwoche INT |
Delivery Week calculated based on the delivery date. | |
| DeliveryDate | Liefertermin Datetime |
Delivery date for this position. This field is also used as requested delivey dates (purchase order) | |
| LeadTime | Lieferzeit INT |
Lead Time in days | |
| RentalStartDate | MietStartDatum Datetime |
not used | |
| WarehouseCode | Lagerort NVARCHAR (10) |
OWHS.WhsCode | OWHS.WhsCode |
| BinLocations | LagerPlaetze NTEXT |
||
| ContainerBins | Gebinde NTEXT |
||
| SourceWarehouse | QuellLagerOrt NVARCHAR (10) |
OWHS.WhsCode | OWHS.WhsCode |
| SourceBinLocations | QuellLagerPlaetze NTEXT |
||
| SourceContainerBins | QuellGebinde NTEXT |
||
| LinkedBusinessPartner | LinkedBusinessPartner NVARCHAR (20) |
||
| TaxCode | Steuercode 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 |
|
| 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 |
Not used | |
| GLAccount | Sachkonto NVARCHAR (20) |
OACT.AcctCode | OACT.AcctCode |
| GLAccountManual | SachkontoManuell SMALLINT (0=false,-1=true) |
||
| OcrCode1 | Kostenstelle 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) |
| ProjectCode | Kostentraeger NVARCHAR (20) |
OPRJ.PrjCode | 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) |
Rebate amount in document currency | |
| 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 |
not used | |
| PurchasePriceAvgSys | PurchasePriceAvgSys NUMERIC(19,6) |
not used | |
| PurchasePriceAvgLoc | PurchasePriceAvgLoc NUMERIC(19,6) |
not used | |
| PurchasePriceAvgFC | MittlererEK NUMERIC(19,6) |
||
| Quantity | Menge NUMERIC(19,6) |
||
| UoM | Mengeneinheit NVARCHAR (20) |
||
| QuantityType | MengeArt SMALLINT |
||
| QuantityBasis | MengeBasis NUMERIC(19,6) |
not used | |
| BaseUoM | MengeBasiseinheit NVARCHAR (5) |
not used | |
| QtyDecimals | MengeBasisNKS SMALLINT |
||
| QtySalesUnit | MengeVKEinheit NVARCHAR (20) |
not used | |
| 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, when item code is substituted | 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 |
Document Link to the ERP Document INV1.BaseEntry= INV1.DocEntry | |
| ERPDocPosID | ERPVerweisZeile INT |
Document Link to the ERP document INV1.BaseLineNum = INV1.LineNum | |
| ERPLinkType | ERPVerweisTyp 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 |
MARIProjectPhases.RequestPhaseID | |
| ProRataID | ProRataID INT Index |
MARISysProRata.ProRataID (WHERE ProRataType=478) | |
| ProRataStartDate | ProRataStartDate Datetime |
||
| ProRataEndDate | ProRataEndDate Datetime |
||
| ProRataNumberOfPeriods | ProRataNumberOfPeriods INT |
||
| ProRataMPTAN | ProRataMPTAN INT Index |
MARIJournalEntryExport.ProRataMPTAN (WHERE HerkunftsTyp=14) | |
| 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=661) | |
| AccrualMPTAN | AccrualMPTAN INT |
MARIJournalEntryExport.AccrualMPTAN (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 |
|---|---|
| MARIPurchaseProcessPositions | Purchase Process: PO Process Position (equivilant to contract 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 |
| MARITempReportDocumentPos | Reporting: Temporary Table: Document Positions |
| MARIContractPosition2DocumentPosition | Contract Management: Contract document position to document position link |
| MARIContractPositions | Contract Management: Contract positions (also service master positions) |
| MARIContractDocumentISCPos | Contract Management: Document Internal Service Charges Positions |
| MARIEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MARIContractDocumentPositionsSerialNumbers | Contract Management: Document Positions Serial Numbers |
| MARIEquipmentLocation | Equipment: Current Location of this equipment |
| MARIContractDocumentPositionsBatches | Contract Management: Document Positions Batches |
| MARIDocumentInvoiceFlowPosition | InvoicePaymentReportStore Positions |
| MARIWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |
| MARICustomerServiceObjectLocation | Current location of a CSO at the client/Project |
| MARIContractDocumentPositionsTax | Contract Management: Document Positions Tax |
| MARIProjectWorkPackageEntry | Work Packages progress reporting by day |
| MARICommissionDocumentPositions | Commission: Sales Rep A/P Invoice Position Link |
| MARIContainerLocation | Current location of a container |
| MARIContainerLine | Container Lines to see the goods in the container |