MPEKVertraegeBelege

Table Name:	MPEKVertraegeBelege
View Name:	MARIPurchaseProcessDocument
Group:	Group: MPEKVertraegeBelege
Description:	Purchase Process: Purchase Document (Header)
ClassID:	12. See Overview of ClassIDs by table.

Field	View(engl.field)/Type	Description	Related
MPBelID	MARIDocID INT Primary		MPEKVertraegeBelege.MPBelID
MPBelegart	MARIDocType INT Index		clsImportSalesContractDocument_eDocTypes
MPBelegartDetail	MARIDocTypeDetail INT
MPVertragsID	ContractID INT Index		MPEKVertraege.VertragsID
MPPeriode	MARIPeriod INT	Period from MARI	MPPerioden.PeriodeJahr
MPOptionMemo	OptionMemo NTEXT
MPUebergabeDatum	DocCreationDate Datetime
MPUebergabeID	DocCreationUser NVARCHAR (4)	Field was named wrongly PostingDate	MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
MPMitWirkung	WithEffect SMALLINT
MPDruckkennzeichen	PrintLabel INT
MPValutadatum	MARIDueDate Datetime
MPSammelBelID	MARICollectionDocumentID INT Index
BelID	DocEntry INT Index	OPOR.DocEntry	OPOR.DocEntry
Mandant	Company SMALLINT Index		MPSysConnections.CompanyID (WHERE ConnectionType=6)
Belegkennzeichen	DocumentTypeID INT	Changed to INT with 4.6
Belegart	DocumentTypeText NVARCHAR (50)
Belegjahr	DocumentYear SMALLINT
Belegnummer	DocumentNumber INT Index
MPBelegStatus	MPDocumentStatus INT
VisibleDocNum	VisibleDocNum NVARCHAR (20)
DocSeries	DocSeries INT		NNM1.Seris
DocNumSegment	DocNumSegment INT	OINV.Secment Visible Doc Num	OINV.Secment
DocSeriesString	DocSeriesString NVARCHAR (3)		OINV.SeriesStr
DocSeriesSubString	DocSeriesSubString NVARCHAR (3)		OINV.SubStr
SequenceCode	SequenceCode INT		OINV.SeqCode
SequenceSerial	SequenceSerial INT		OINV.Serial
SequenceModel	SequenceModel NVARCHAR (10)	Field for Brazil	OINV.Model
DeferrTax	DeferredTax SMALLINT (0=false,-1=true)		OINV.DeferrTax
ShipToCode	ShipToCode NVARCHAR (50)	V5.4 India Localization
GSTTranTyp	GSTTranTyp NVARCHAR (2)	V5.4 India Localization
BPLId	BPLId INT Index		OINF.BPLId
PTICode	PTICode NVARCHAR (5) Index	Localization Argentina	OPOR.PTICode
Letter	Letter NVARCHAR (1)	Localization Argentina	OPOR.Letter
FolNumFrom	FolNumFrom INT	Localization Argentina	OPOR.FolNumFrom
FolNumTo	FolNumTo INT	Localization Argentina	OPOR.FolNumTo
FolSeries	FolSeries INT	Localization Argentina	OPOR.FolSeries
Indicator	Indicator NVARCHAR (2)	Localization Argentina SELECT * FROM OIDC	OPOR.Indicator
ImportEnt	ImportEnt INT	Localization Argentina	OPOR.ImportEnt
INV12State	INV12State NVARCHAR (3)
INV12County	INV12County NVARCHAR (7)
FiscDocNum	FiscDocNum NVARCHAR (100)	Localization Poland	OPOR.FiscDocNum
VatFirst	VatFirst SMALLINT (0=false,-1=true)
Buchungstext	JournalRemark NVARCHAR (254)
Periode	ERPPeriod INT	Period from SBO
Interessent	Prospect SMALLINT
A0AdressNr	A0AddressNr INT
A0Empfaenger	A0CardCode NVARCHAR (20)		OCRD.CardCode
A0Anrede	A0Salutation NVARCHAR (50)
A0Name1	A0Name1 NVARCHAR (100)
A0Name2	A0Name2 NVARCHAR (50)
A0Zusatz	A0Name3 NVARCHAR (50)
A0Einmalkunde	A0SingleCustomer SMALLINT
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
A0EMailAnsprechpartner	A0EMailContactPerson INT
A1EMailAnsprechpartner	A1EMailContactPerson INT
FatherCard	FatherCard NVARCHAR (20)
FatherType	FatherType NVARCHAR (1)
Kundengruppe	CustomerGroup NVARCHAR (10)
Preiskennzeichen	PriceType SMALLINT
Rechnungsempfaenger	InvoiceCustomerCode NVARCHAR (20)
Lieferwoche	DeliveryWeek INT
Liefertermin	DeliveryDate Datetime	Delivery type doc=Date of delivery; invoice type documents=DueDate
MietStartDatum	RentalStartDate Datetime
QuellLager	SourceWareHouse NVARCHAR (8)		OWHS.WhsCode
QuellLagerPlaetze	SourceBinLocations NTEXT
CurrencySys	CurrencySys NVARCHAR (3)
CurrencyLoc	CurrencyLoc NVARCHAR (3)
WKz	CurrencyFC NVARCHAR (3)	ISO Currency Code
CurrencyRateSys2Loc	CurrencyRateSys2Loc Float
CurrencyRateLoc2Fc	CurrencyRateLoc2Fc Float
WKzKursFw	ExchangeRateFC2Sys Float
CurrencyRateSource	ExchangeRateSource INT
CurrencyRateDate	ExchangeRateDate Datetime
WkzKursHandling	ExchangeRateHandling INT
Incoterm	Incoterm NVARCHAR (4)
Revision	Revision NVARCHAR (20)
Belegdatum	DocDate Datetime
Steuerdatum	TaxDate Datetime
LeistungszeitraumVon	ServiceStartDate Datetime
LeistungszeitraumBis	ServiceEndDate Datetime
LeistungsZeitraumVorlage	ServiceRangeTemplate INT	Enum
VertriebsMitarbeiter	SalesEmployee NVARCHAR (128)		OSLP.SlpCode
Bearbeiter	HandledBy NVARCHAR (128)		OUSR.USER_Code
Rabatt1	DiscountPercent NUMERIC(19,6)
DiscountValueSys	DiscountValueSys NUMERIC(19,6)
DiscountValueLoc	DiscountValueLoc NUMERIC(19,6)
Rabattbetrag1	DiscountValueFC NUMERIC(19,6)
DiscountBaseSys	DiscountBaseSys NUMERIC(19,6)
DiscountBaseLoc	DiscountBaseLoc NUMERIC(19,6)
Rabattbasis1	DiscountBaseFC NUMERIC(19,6)
PaymentBlock	PaymentBlock SMALLINT (0=false,-1=true)
PaymentBlockRef	PaymentBlockRef INT
ClosingDate	ClosingDate Datetime	Localisation Japan
Kopftext	Header NTEXT
Fusstext	Footer NTEXT
Kostenstelle	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)
Kostentraeger	ProjectCode NVARCHAR (20)		OPRJ.PrjCode
Sprache	LanguageCode NVARCHAR (10)
SprachID	LanguageID INT
ReferenzBelID	ReferenceDocumentID INT Index
Referenznummer	ReferenceNumber NVARCHAR (100)
Referenzzeichen	ReferenceSign NVARCHAR (100)
NetValueSys	NetValueSys NUMERIC(19,6)
NetValueLoc	NetValueLoc NUMERIC(19,6)
Nettobetrag	NetValueFC NUMERIC(19,6)
TaxValueSys	TaxValueSys NUMERIC(19,6)
TaxValueLoc	TaxValueLoc NUMERIC(19,6)
Steuerbetrag	TaxValueFC NUMERIC(19,6)
TotalValueSys	TotalValueSys NUMERIC(19,6)
TotalValueLoc	TotalValueLoc NUMERIC(19,6)
Bruttobetrag	TotalValueFc NUMERIC(19,6)
Besteuerung	TaxModeCode SMALLINT
EULand	EUCountry NVARCHAR (2)
EUUStID	EUVATID NVARCHAR (32)
ShipmentType	ShipmentType INT
ERPVerweisID	ERPLinkID INT
ERPVerweisZeile	ERPDocPosID INT
ERPVerweisTyp	ERPLinkType INT
VKEKInternRefMPBelID	PurchaseSalesRefMARIDocID INT Index
PaymentRef	PaymentRef NVARCHAR (27)	Reference BE/NL
Memo	Memo NTEXT
WorflowStatus	WorkflowStatus INT
Freigabe	ApprovalMode SMALLINT Index
FreigegebenAm	ApprovedDate Datetime
FreigegebenID	ApprovedUser NVARCHAR (4)		MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Freigabetext	ApprovalText NTEXT
JournalBuchung	JounralEntry INT
JournalStornoBuchung	JournalEntryCancel INT
BelegErsteller	DocumentCreator NVARCHAR (20)
RevisionsVorgaengerBelID	RevisionReferenceDocumentID INT Index
CIG_Code	CIG_Code INT
CUP_Code	CUP_Code INT
EInvoiceMode	EInvoiceMode INT
GebindeID	ContainerID INT Index		MPGebinde.GebindeID
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
MPDocumentDraftHeadLink	Linked contracts and purchase processes
MPDocumentDraftPositionLink	Linked positions in the sales contract and or purchase process
MPEKVertraegeAnzahlungen	Purchase Process: Down Payments
MPEKVertraegeBelege	Purchase Process: Purchase Document (Header)
MPEKVertraegeBelegeAnhaenge	Purchase Process: Link to Attachments
MPEKVertraegeBelegeFehler	Purchase Process: Saved Errors
MPEKVertraegeBelegeFreigabe	Purchase Process: Document Approval Employee Link
MPEKVertraegeBelegeILVKopf	Purchase Process: Document Internal Service Change Head
MPEKVertraegeBelegePositionen	Purchase Process: Purchase Document (Positions)
MPEKVertraegeBelegePositionenSerie	Purchase Process: Purchase Document (Positions+Serial)
MPEKVertraegeBelegePositionenSteuer	Purchase Process: Purchase Document (Positions+Tax)
MPEKVertraegeBelegeZKD	Purchase Process: Purchase Document (Payment conditions)
MPEKVertraegeBelegeZuordnung	Purchase Process: Purchase Document Link to down payments

MARIProject Database Structure