| Table Name: | MPEKVertraegePositionen |
| View Name: | MARIPurchaseProcessPositions |
| Group: | Group: MPEKVertraege |
| Description: | Purchase Process: PO Process Position (equivilant to contract position) |
| ClassID: | 147. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Vertragsposition | ContractPositionID INT Primary |
MPEKVertraegePositionen.Vertragsposition | |
| VertragsID | ContractID INT Index |
MPEKVertraege.VertragsID | |
| ParentID | ParentID INT Index |
||
| VKPosIndex | SalesContractPosition INT Index |
||
| Position | PositionID SMALLINT Index |
||
| Indent | Indent INT |
||
| PositionText | Position NVARCHAR (50) |
||
| PosTyp | PositionType SMALLINT |
clsImportProjectContractPosition_eContractPositionType | |
| Leistungsnummer | ServiceNumber NVARCHAR (20) Index |
MPLeistung.Leistungsnummer | |
| Artikel | ItemCode NVARCHAR (50) |
OITM.ItemCode | |
| Mandant | Company SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| ReisekostenArt | TravelCategory NVARCHAR (20) |
MPReise2KostenArten.Reisekostenart | |
| EquipmentCategory | EquipmentCategory INT |
MPEquipmentCategory.EquipmentCategory | |
| EquipmentSubject | EquipmentSubject NVARCHAR (20) |
MPEquipmentCategorySubject.EquipmentSubject | |
| EquipmentParentPos | EquipmentParentPos INT |
||
| ArbeitspaketNumber | WorkpackageNumber NVARCHAR (20) |
MPArbeitspaket.ArbeitspaketNumber | |
| Bezeichnung1 | Description1 NVARCHAR (200) |
||
| Bezeichnung2 | Description2 NVARCHAR (200) |
||
| Matchcode | Matchcode NVARCHAR (200) Index |
||
| Menge | Quantity NUMERIC(19,6) |
Quantity=BaseQty*ParentQty | |
| MengeMax | MaximumQuantity NUMERIC(19,6) |
||
| MengeMaxTyp | MaxQuantityType TINYINT |
||
| MengeVorgabe | DefaultQuantity NUMERIC(19,6) |
||
| MengenTyp | QuantityType INT |
||
| MengenOptionen | QuantityOption SMALLINT (0=false,-1=true) |
||
| BasisMenge | BaseQuantity NUMERIC(19,6) |
Quantity per contract | |
| MengeAnzahl | QuantityCount NUMERIC(19,6) |
Quantity of equipment for rental | |
| MengeAnzahlText | QuantityCountText NVARCHAR (100) |
||
| MengenFormelID | QuantityFormularID INT Index |
MPSetupMengenFormel.MengenFormelID | |
| BasisAnzahl | BasisAnzahl NUMERIC(19,6) |
||
| ZusammenfassungMode | SummaryMode INT |
||
| RundungsMethode | RoundingMethodID INT |
MPVertragRundung.RundungsMethode (WHERE ClassID=103) | |
| CalculationMethod | CalculationMethod INT Index |
MPContractCalculation.CalculationMethod | |
| Einzelpreis | NetUnitPriceFC NUMERIC(19,6) |
||
| EinzelPreisFW | UnitPriceFC NUMERIC(19,6) |
||
| PreisTyp | PriceType SMALLINT |
||
| PreisOptionen | PriceOption SMALLINT (0=false,-1=true) |
||
| EinzelpreisBeleg | UnitPriceDocument NUMERIC(19,6) |
||
| Rabatt | DiscountPercent NUMERIC(19,6) |
||
| EKEinzelpreis | POUnitPrice NUMERIC(19,6) |
||
| EKPreisTyp | POPriceType SMALLINT |
||
| EKEinzelpreisFW | POUnitPriceFC NUMERIC(19,6) |
||
| EKPreisWKZ | POPriceCurrency NVARCHAR (3) |
||
| EKPreisKurs | POPriceExchangeRate Float |
||
| EKPreisKursHandling | POPriceExchangeHandling INT |
||
| EKPreisOptionen | POPriceOption SMALLINT |
||
| EKModus | POMode INT |
||
| EKPreisAufschlag | POPriceSurplus NUMERIC(19,6) |
||
| KostenAufschlagKalkulatorisch | CostMarginImputed Float |
||
| VerkaufsAufschlagKalkulatorisch | SalesMarginImputed Float |
||
| Abrechnungstyp | StandardAccountingType INT |
||
| AbrechnungTag | AccountingDate SMALLINT |
||
| Lieferant | Vendor NVARCHAR (20) |
OCRD.CardCode | |
| Lieferart | PurchaseType SMALLINT |
||
| AusgabeMethode | IssueMethod INT |
||
| Lieferdatum | DeliveryDate Datetime |
||
| Lieferzeit | LeadTime INT |
||
| MietStartDatum | RentalStartDate Datetime |
||
| Lagerort | Warehouse NVARCHAR (10) |
OWHS.WhsCode | |
| QuellLagerOrt | SourceWarehouse NVARCHAR (10) |
OWHS.WhsCode | |
| VorPosID | LinkedPositionType INT Index |
||
| Fremdnummer | ExternalNumber NVARCHAR (40) |
||
| Fertigstellungsgrad | DegreeOfCompletion Single |
||
| HatFertigstellungsgrad | UsesDegreeOfCompleation SMALLINT (0=false,-1=true) |
||
| Zuschlaege | TimeSurcharges NVARCHAR (255) |
||
| Langtext | AccountingInfo NTEXT |
||
| Dimensionstext | PositionInfo NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| Rabattfaehig | EntitledDiscount SMALLINT (0=false,-1=true) |
||
| Mengeneinheit | UoM NVARCHAR (20) |
||
| BPCatalogNumber | BPCatalogNumber NVARCHAR (50) |
||
| AktivTyp | ActiveType SMALLINT |
||
| BelegHandling | DocumentHandling INT |
||
| HatFremdnummer | HasExternalNumber SMALLINT (0=false,-1=true) |
||
| IndexBehandlung | IndexTreatment SMALLINT |
||
| HatNummer | HasNumber SMALLINT (0=false,-1=true) |
||
| NummernKreisVon | NumberRangeFrom INT |
||
| NummernKreisBis | NumberRangeTo INT |
||
| SortierKZ | OrderFlag SMALLINT |
||
| ERDefinition | RevenueReturnAccountDefinition INT |
||
| GVPosID | BaseContractPosition INT Index |
||
| GGMengeBestellt | BalanceOrdered NUMERIC(19,6) |
||
| GGMengeGeliefert | BalanceDelivered NUMERIC(19,6) |
||
| GGMengeRechnung | BalanceInvoiced NUMERIC(19,6) |
||
| GGDocReference | BalanceLastDocReference INT |
||
| Steuercode | TaxCode NVARCHAR (10) |
||
| Steuersatz | TaxRate NUMERIC(19,6) |
||
| Steuerklasse | TaxClass SMALLINT |
||
| SteuerManuell | TaxManual SMALLINT (0=false,-1=true) |
||
| SachkontoManuell | GLAccountManual SMALLINT (0=false,-1=true) |
||
| Sachkonto | GLAccount NVARCHAR (20) |
OACT.AcctCode | |
| OcrCode1 | 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) | |
| TaxWtLiable | TaxWtLiable SMALLINT (0=false,-1=true) |
||
| TaxUsage | TaxUsage INT |
||
| TaxCSTcode | TaxCSTcode NVARCHAR (4) |
||
| TaxCFOPcode | TaxCFOPcode NVARCHAR (6) |
||
| LocationID | LocationID INT Index |
||
| ProduktID | ProductID INT Index |
MPHotlineProdukt.ProduktID | |
| Kostenbehandlung | CostHandling INT |
||
| KostenProzent | CostPercentage NUMERIC(19,6) |
||
| KostenAbschlag | CostReduction NUMERIC(19,6) |
||
| Lohnart | PayrollType NVARCHAR (20) |
MPLohnArten.LohnArt | |
| WartungsTyp | MaintenanceType INT |
||
| WartungsPeriodik | RecurrentAccounting INT |
clsImportProjectContractPosition_eMaintenancePeriodic | |
| WartungsSatz | MaintenancePercent NUMERIC(19,6) |
||
| WartungBasisPreis | MaintenanceBasicPrice NUMERIC(19,6) |
||
| WartungsReferenz | MaintenanceReference INT |
||
| WartungStart | ServiceStartDate Datetime |
||
| WartungEnde | ServiceEndDate Datetime |
||
| WartungsStichtagsTyp | ServiceDueDateType SMALLINT |
||
| WartungsStichtagsOffset | ServiceDueDateOffset SMALLINT |
||
| WartungsVertragsEnde | ServiceContractEnd Datetime |
||
| QualityProcess | QualityProcess INT |
MPQualityProcess.QualityProcess | |
| QualityProcessVK | QualityProcessSales INT |
MPQualityProcess.QualityProcess | |
| QualityStatus | QualityStatus INT |
||
| AlternativPosition | Alternative SMALLINT (0=false,-1=true) |
||
| AnzeigeImBelegFlagg | DisplayInDocMode INT |
||
| AbrechnungsHandling | InvoiceHandling INT |
||
| SubVertragsID | SubContractID INT Index |
Link to a sub contract | |
| SubVertragsPosition | SubContractPosition INT |
Link to a sub contract Posiiotn | |
| QuellVKBelPosID | SourceSalesDocPosID INT Index |
MPVKVertraegeBelegePositionen.MPBelPosID | |
| ProvisionsMode | CommissionMode INT |
||
| ProvisionsProzent | CommissionPercent NUMERIC(19,6) |
||
| ContractCommissionID | ContractCommissionID INT Index |
||
| AddOnCategory | AddOnCategory INT |
MPTimeBookingAddOnCategory.AddOnCategory | |
| WorkItemPosition | WorkItemPosition INT |
||
| ProRataID | ProRataID INT Index |
MPSysProRata.ProRataID (WHERE ProRataType=479) | |
| AccrualRuleID | AccrualRuleID INT Index |
MPSysProRata.ProRataID (WHERE ProRataType=662) | |
| ERPResourceCode | ERPResourceCode NVARCHAR (50) Index |
ORSC.ResCode | |
| ReiseZeitenMode | TravelTimeMode INT |
||
| ReiseZeitenErloeseFaktor | TravelTimeSalesFactor NUMERIC(19,6) |
||
| 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 |
||
| KundenDokumente | CustomerDocumentMode SMALLINT (0=false,-1=true) |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Erstanlage | CreateDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPDocumentDraftPositionLink | Linked positions in the sales contract and or purchase process |
| MPEKFremdBelegErfassungPos2EKPos | Purchase Order: Import external documents (Link to PO Process lines) |
| MPEKVertraegeCommissionPos | Purchase Process: Purchase Document Bonus position definition |
| MPEKVertraegePos2Service | Purchase Process: Link Position to Customer Service Object or parts |
| MPEKVertraegePositionen | Purchase Process: PO Process Position (equivilant to contract position) |
| MPEKVertraegePositionenDef | Purchase Process: Definition of extra fields by position type |
| MPEKVertraegePositionenEquipment | Purchase Process: Equipment linked to a position |
| MPEKVertraegePositionenPers | Purchase Process: Employees linked to a position |
| MPEKVertraegePositionenPhasen | Purchase Process: Phases linked to a position |
| MPEKVertraegePositionenTexte | Purchase Process: Text definition (master data) for positions |
| MPEKVertraegeZahlungsplan | Purchase Process: Payment plan (not used in PO) |
| MPEquipmentDetails | Equipment: Master Data "date from" based |
| MPEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MPGebinde | Definition of a container carrying other goods |
| 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 |
| 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 |
| MPProjektPlanungsZeilen | Planning: Master Planning lines |
| MPProjektPlanungsZeilenLog | Planning: Master Planning lines History |
| MPVKVertraegePos2EKPos | Contract Management: Contract position to PO position link |