MPEKVertraege

Table Name:	MPEKVertraege
View Name:	MARIPurchaseProcess
Group:	Group: MPEKVertraege
Description:	Purchase Process: Header
ClassID:	103. See Overview of ClassIDs by table.

Field	View(engl.field)/Type	Description	Related
VertragsID	ContractID INT Primary	Unique ID (invisible)	MPEKVertraege.VertragsID
Vertragsnummer	POProcessNo NVARCHAR (20) Unique	Unique Number visible	MPEKVertraege.Vertragsnummer
Vertragsart	PurchaseProcessType SMALLINT Index	Contract or Purchase process type	clsImportProjectContract_eContractTypes
Abrechnungstyp	StandardAccountingType INT		clsImportProjectContract_eAccountingType
Projektnummer	ProjectNumber NVARCHAR (20) Index		MPProjektstamm.Projektnummer
Volumenbehandlung	VolumeHandling SMALLINT		clsImportProjectContract_eVolumeHandling
Planungsbehandlung	AutoPlanningMode SMALLINT
Planungsversion	PlanningVersion INT	Link to a planning version for archive	MPProjektPlanungsversion.Planungsversion
Basisvertrag	BaseContract INT	Linked contract (only sales side)	MPEKVertraege.VertragsID
Vertragsgruppe	PurchaseProcessGroup1 INT		MPGruppen.GruppenID (WHERE Gruppenart=10016) clsImportGroups_eGroupType
Vertragsgruppe2	PurchaseProcessGroup2 INT		MPGruppen.GruppenID (WHERE Gruppenart=10017) clsImportGroups_eGroupType
Vertragsgruppe3	PurchaseProcessGroup3 INT		MPGruppen.GruppenID (WHERE Gruppenart=10018) clsImportGroups_eGroupType
Lieferant	Supplier NVARCHAR (20)		OCRD.CardCode
Mandant	Company SMALLINT		MPSysConnections.CompanyID (WHERE ConnectionType=6)
VorID	BaseContractID INT
Bezeichnung	PurchaseProcessName NVARCHAR (100) Index
Vertragsdatum	PurchaseProcessDate Datetime
Referenznummer	ReferenceNumber NVARCHAR (100)
Referenzzeichen	ReferenceSign NVARCHAR (100)
VKVolumen	SalesVolume NUMERIC(19,6)
VKVolumenFW	SalesVolumeFC NUMERIC(19,6)
VKVolumenLoc	SalesVolumeLoc NUMERIC(19,6)
VKVolumenLeistung	SalesVolumeService NUMERIC(19,6)
VKVolumenLeistungFW	SalesVolumeServiceFC NUMERIC(19,6)
VKVolumenLeistungLoc	SalesVolumeServiceLoc NUMERIC(19,6)
VKVolumenArtikel	SalesVolumeItem NUMERIC(19,6)
VKVolumenArtikelFW	SalesVolumeItemFC NUMERIC(19,6)
VKVolumenArtikelLoc	SalesVolumeItemLoc NUMERIC(19,6)
VKVolumenRK	SalesVolumeTravelExpenses NUMERIC(19,6)
VKVolumenRKFW	SalesVolumeTravelExpensesFC NUMERIC(19,6)
VKVolumenRKLoc	SalesVolumeTravelExpensesLoc NUMERIC(19,6)
VKVolumenEquipment	SalesVolumeEquipment NUMERIC(19,6)
VKVolumenEquipmentFW	SalesVolumeEquipmentFC NUMERIC(19,6)
VKVolumenEquipmentLoc	SalesVolumeEquipmentLoc NUMERIC(19,6)
VKVolumenFremdLeistung	SalesVolumeExternalService NUMERIC(19,6)
VKVolumenFremdLeistungFW	SalesVolumeExternalServiceFC NUMERIC(19,6)
VKVolumenFremdLeistungLoc	SalesVolumeExternalServiceLoc NUMERIC(19,6)
ContractHandlingPercentage	ContractHandlingPercentage NUMERIC(19,6)
Erfuellt	Completed SMALLINT (0=false,-1=true)	Completed
AuftragsWahrscheinlichkeit	OrderProbability Single
Status	Status INT	Status value
Wkz	Currency NVARCHAR (3)	ISO Currency Code
WkzKurs	ExchangeRate Float
WkzKursHandling	ExchangeRateHandling INT
WKZLoc	CurrencyLoc NVARCHAR (3)
WKZKursSys2Loc	CurrencyRateSys2Loc Float	Rate between (MARI)Sys and foreign currency
WKZKursLoc2FW	CurrencyRateLoc2Fc Float	Rate between company local and foreign currency
GueltigAb	ValidFrom INT		MPPerioden.PeriodeJahr
GueltigBis	ValidTo INT		MPPerioden.PeriodeJahr
VertragsMemo	ContractMemo NTEXT
VertragsMemoLevel	ContractMemoLevel SMALLINT
VertriebsMitarbeiter	SalesEmployee NVARCHAR (128)		OSLP.SlpCode
Bearbeiter	HandledBy NVARCHAR (128)		OUSR.USER_Code
Sprache	LanguageKey NVARCHAR (10)
SprachID	LanguageID INT
ZKD	PaymentCondition NVARCHAR (50)
PreislisteVK	PriceListSales INT
PreislisteVKWKZ	PriceListSalesCurrCode NVARCHAR (3)
PreislisteEK	PriceListPurchase INT
PreislisteEKWKZ	PriceListPurchaseCurrCode NVARCHAR (3)
PlanungsStichtag	PlanningDueDate Datetime
PlanungsTeamGroesse	PlanningTeamSize NUMERIC(19,6)
Rabatt1	DiscountPercent NUMERIC(19,6)
Rabatt2	DiscountPercent2 NUMERIC(19,6)
Rabatt3	DiscountPercent3 NUMERIC(19,6)
Interessent	Prospect SMALLINT
A0Anrede	A0Salutation NVARCHAR (50)
A0Name1	A0Name1 NVARCHAR (100)
A0Name2	A0Name2 NVARCHAR (50)
A0Zusatz	A0Name3 NVARCHAR (50)
A0Matchcode	A0Matchcode NVARCHAR (100)
A0Strasse	A0Street NVARCHAR (100)
A0Hausnummer	A0StreetNumber NVARCHAR (100)
A0Land	A0Country NVARCHAR (3)
A0PLZ	A0ZIP NVARCHAR (20)
A0Ort	A0City NVARCHAR (100)
A0Bezirk	A0County NVARCHAR (100)
A0Bundesland	A0State NVARCHAR (3)
A0Gebaeude	A0Block NVARCHAR (100)
A0AnsprechpartnerID	A0ContactPerson INT		OCPR.CntctCode
A0AdressName	A0AddressName1 NVARCHAR (50)
A0AdressName2	A0AddressName2 NVARCHAR (50)
A0AdressName3	A0AddressName3 NVARCHAR (50)
A0GebaeudeStockwerk	A0Building NTEXT
A0AdressMemo	A0AddressMemo NTEXT
A0CardFName	A0CardFName NVARCHAR (100)
A0AddrType	A0AddrType NVARCHAR (100)
A0AdressLineNum	A0AddressLineNum INT
A0GlbLocNum	A0GlbLocNum NVARCHAR (50)
A0Longitude	A0Longitude Float
A0Latitude	A0Latitude Float
A1BusinessPartner	A1BusinessPartner NVARCHAR (20)		OCRD.CardCode
A1Anrede	A1Salutation NVARCHAR (50)
A1Name1	A1Name1 NVARCHAR (100)
A1Name2	A1Name2 NVARCHAR (50)
A1Zusatz	A1Name3 NVARCHAR (50)
A1Matchcode	A1Matchcode NVARCHAR (100)
A1Strasse	A1Street NVARCHAR (100)
A1Hausnummer	A1StreetNum NVARCHAR (100)
A1Land	A1Country NVARCHAR (3)
A1PLZ	A1ZIP NVARCHAR (20)
A1Ort	A1City NVARCHAR (100)
A1Bezirk	A1County NVARCHAR (100)
A1Bundesland	A1State NVARCHAR (3)
A1Gebaeude	A1Block NVARCHAR (100)
A1AnsprechpartnerID	A1ContactPerson INT		OCPR.CntctCode
A1AdressName	A1AddressName1 NVARCHAR (50)
A1AdressName2	A1AddressName2 NVARCHAR (50)
A1AdressName3	A1AddressName3 NVARCHAR (50)
A1GebaeudeStockwerk	A1Building NTEXT
A1AdressMemo	A1AddressMemo NTEXT
A1CardFName	A1CardFName NVARCHAR (100)
A1AddrType	A1AddrType NVARCHAR (100)
A1AdressLineNum	A1AddressLineNum INT
A1GlbLocNum	A1GlbLocNum NVARCHAR (50)
A1Longitude	A1Longitude Float
A1Latitude	A1Latitude Float
A2BusinessPartner	A2BusinessPartner NVARCHAR (20)	Pay To Address	OCRD.CardCode
A2Anrede	A2Salutation NVARCHAR (50)
A2Name1	A2Name1 NVARCHAR (100)
A2Name2	A2Name2 NVARCHAR (50)
A2Zusatz	A2Line3 NVARCHAR (50)
A2Matchcode	A2Matchcode NVARCHAR (100)
A2Strasse	A2Street NVARCHAR (100)
A2Hausnummer	A2StreetNum NVARCHAR (100)
A2Land	A2Country NVARCHAR (3)
A2PLZ	A2ZIP NVARCHAR (20)
A2Ort	A2City NVARCHAR (100)
A2Bezirk	A2County NVARCHAR (100)
A2Bundesland	A2State NVARCHAR (3)
A2Gebaeude	A2Block NVARCHAR (100)
A2AnsprechpartnerID	A2ContactPerson INT		OCPR.CntctCode
A2AdressName	A2AddressName1 NVARCHAR (50)
A2AdressName2	A2AddressName2 NVARCHAR (50)
A2AdressName3	A2AddressName3 NVARCHAR (50)
A2GebaeudeStockwerk	A2Building NTEXT
A2AdressMemo	A2AddressMemo NTEXT
A2CardFName	A2CardFName NVARCHAR (100)
A2AddrType	A2AddrType NVARCHAR (100)
A2AdressLineNum	A2AddressLineNum INT
A2FatherType	A2FatherType NVARCHAR (1)
A2GlbLocNum	A2GlbLocNum NVARCHAR (50)
A2Longitude	A2Longitude Float
A2Latitude	A2Latitude Float
A0EMailAnsprechpartner	A0EMailContactPerson INT
A1EMailAnsprechpartner	A1EMailContactPerson INT
A2EMailAnsprechpartner	A2EMailContactPerson INT
Kopftext	Header NTEXT
Fusstext	Footer NTEXT
ZahlungsKonditionenAnzahl	PaymentConditionCount INT
Zahlungskond	PaymentConditionB NVARCHAR (10)		OCTG.GroupNum
Inkassoart	PaymentTerms NVARCHAR (15)		OPYM.PayMethCod
Nettobedingung	PaymentNetConditions NVARCHAR (255)
Skontobedingung1	CashDiscount1 NVARCHAR (255)
Skontobedingung2	CashDiscount2 NVARCHAR (255)
Skontoprozent1	CashDiscountPercent1 NUMERIC(19,6)
Skontoprozent2	CashDiscountPercent2 NUMERIC(19,6)
PaymentRef	PaymentRef NVARCHAR (27)	Reference for BE/NL
Incoterm	Incoterm NVARCHAR (4)
DeferrTax	DeferredTax SMALLINT (0=false,-1=true)	OINF.DeferrTax	OINV.DeferrTax
ShipToCode	ShipToCode NVARCHAR (50)	V5.4 India Localization
SammelProjekt	AkquisitionProject NVARCHAR (20)		MPProjektstamm.Projektnummer
SammelPhase	AkquisitionPhase INT		MPProjektPhasen.PhasenID
DocWorkflow	DocWorkflowID INT		MPSysDocWorkflow.DocWorkflow
ProvisionsMode	CommissionMode INT	Select the bonus method	MPCommissionTypes.CommissionTypeID
StandardLager	StandardWarehouse NVARCHAR (8)		OWHS.WhsCode
ShipmentType	ShipmentType INT
StandardSteuer	StandardTaxCode NVARCHAR (8)
BewertungsMode	Assessment INT
LeistungsZeitraumVorlage	ServiceRangeTemplate INT	Enum
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)
FreigabeTyp	ApprovalType INT
Freigebender	Approver NVARCHAR (20) Index		MPPersonenstamm.Personalnummer
Freigabe	ApprovalMode SMALLINT (0=false,-1=true) Index
FreigegebenAm	ApprovedDate Datetime
FreigegebenID	ApprovedUser NVARCHAR (4)		MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Freigabetext	ApprovalText NTEXT
CIG_Code	CIG_Code INT
CUP_Code	CUP_Code INT
InAktiv	Inactive SMALLINT (0=false,-1=true) Index	Hide dataset
ErstanlageID	CreateUser NVARCHAR (4)		MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Erstanlage	CreateDate Datetime
AenderungID	ChangeUser NVARCHAR (4)		MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Aenderung	ChangeDate Datetime
HidePageFlag	HidePageFlag BIGINT
UpdateStamp	UpdateStamp INT

Table	Description
MPDocumentDraftHeadLink	Linked contracts and purchase processes
MPDocumentDraftPositionLink	Linked positions in the sales contract and or purchase process
MPEKFremdBelegErfassungPos2EKPos	Purchase Order: Import external documents (Link to PO Process lines)
MPEKVertraege	Purchase Process: Header
MPEKVertraegeAnzahlungen	Purchase Process: Down Payments
MPEKVertraegeBelege	Purchase Process: Purchase Document (Header)
MPEKVertraegeBelegeDruck	Purchase Process: Print history
MPEKVertraegeBelegeEInvoice	Purchase Process: Extra Information peparing an electronic document
MPEKVertraegeBelegeFehler	Purchase Process: Saved Errors
MPEKVertraegeBelegeSteuer	Purchase Process: Purchase Document (Tax)
MPEKVertraegeCommission	Purchase Process: Purchase Document Bonus definition
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)
MPEKVertraegeTexte	Purchase Process: Text definition (master data) for header, footer
MPEKVertraegeZahlungsplan	Purchase Process: Payment plan (not used in PO)
MPEKVertraegeZKD	Purchase Process: Installment Plan
MPEquipmentDetails	Equipment: Master Data "date from" based
MPEquipmentSubjectBooking	Time/Costbooking on Equipment data
MPGebinde	Definition of a container carrying other goods
MPProjektPlanungsZeilen	Planning: Master Planning lines
MPProjektPlanungsZeilenLog	Planning: Master Planning lines History
MPVKVertraegePos2EKPos	Contract Management: Contract position to PO position link

MARIProject Database Structure