MPVKVertraegeBelegeILVKopf

Table Name:	MPVKVertraegeBelegeILVKopf
View Name:	MARIContractDocumentISCHead
Group:	Group: ContractDocument
Description:	Contract Management: Document Internal Service Charges Head

Field	View(engl.field)/Type	Description	Related
ILVBelegID	ISCDocumentID INT Primary
MPBelID	MARIDocID INT Index		MPVKVertraegeBelege.MPBelID
ILVBelegTyp	ISCDocumentType INT
Belegart	DocumentTypeText NVARCHAR (50)
Stapel	Batch INT
ERPStatus	ERPStatus INT
ERPDocType	ERPDocType INT
ERPDocNum	ERPDocNum INT
ERPDocSeries	ERPDocSeries INT
ERPDocEntry	ERPDocEntry INT
ERPDocSeriesString	ERPDocSeriesString NVARCHAR (3)
ERPDocSeriesSubString	ERPDocSeriesSubString NVARCHAR (3)
ERPSequenceCode	ERPSequenceCode INT
ERPSequenceSerial	ERPSequenceSerial INT
ERPSequenceModel	ERPSequenceModel NVARCHAR (10)
ERPDeferrTax	ERPDeferrTax SMALLINT (0=false,-1=true)
ERPVatFirst	ERPVatFirst SMALLINT (0=false,-1=true)
ERPPaymentRef	ERPPaymentRef NVARCHAR (27)
ERPUebergabedatum	ERPTransferDate Datetime
ERPUebergabeUser	ERPTransferUser NVARCHAR (4)		MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
ERPTan	ERPTransactionID INT
ERPErrorCode	ERPErrorCode INT Index
ERPErrorText	ERPErrorText NTEXT
ERPBPLId	ERPBPLId INT		OINF.BPLId
PTICode	PTICode NVARCHAR (5)	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
FiscDocNum	FiscDocNum NVARCHAR (100)	Localization Poland	OPOR.FiscDocNum
Geschaeftspartner	BusinessPartner NVARCHAR (20)		OCRD.CardCode
Mandant	Company SMALLINT Index		MPSysConnections.CompanyID (WHERE ConnectionType=6)
OPNr	OpenItemNumber NVARCHAR (20)
Belegdatum	DocDate Datetime
Faelligkeit	DueDate Datetime
Buchungsdatum	PostingDate Datetime
Periode	Period INT	Period	MPPerioden.PeriodeJahr
NettoSys	NetAmountSys NUMERIC(19,6)
NettoMA	NetAmountCompany NUMERIC(19,6)
NettoFW	NetAmountForeign NUMERIC(19,6)
BruttoSys	BrutAmountSys NUMERIC(19,6)
BruttoMA	BrutAmountCompany NUMERIC(19,6)
BruttoFW	BrutAmountForgeign NUMERIC(19,6)
SteuerSys	TaxAmountSys NUMERIC(19,6)
SteuerMA	TaxCompCur NUMERIC(19,6)
SteuerFW	TaxFC NUMERIC(19,6)
WKZSys	CurrencySys NVARCHAR (3)
WKZMa	CurrencyCompany NVARCHAR (3)
WKZBeleg	CurrencyForeign NVARCHAR (3)
WkzMaKurs	ExchangeRateCompany Float
WKzKursFw	ExchangeRateFC2Sys Float
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	A0OneTimeAddress 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
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
A1AdressNr	A1AddressID INT
A1Empfaenger	A1CardCode NVARCHAR (20)		OCRD.CardCode
A1Anrede	A1Salutation NVARCHAR (50)
A1Name1	A1Name1 NVARCHAR (100)
A1Name2	A1Name2 NVARCHAR (50)
A1Zusatz	A1Name3 NVARCHAR (50)
A1Einmalkunde	A1OneTimeAddress SMALLINT
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
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
ILVBelegIDNachfolger	ISCDocumentFollowID INT		MPVKVertraegeBelegeILVKopf.ILVBelegID
ILVBelegIDVorgaenger	ISCDocumentPreviousID INT		MPVKVertraegeBelegeILVKopf.ILVBelegID
LocationID	LocationID INT
CIG_Code	CIG_Code INT
CUP_Code	CUP_Code INT Index
Erstanlage	CreateDate Datetime
ErstanlageID	CreateUser NVARCHAR (4)		MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Aenderung	ChangeDate Datetime
AenderungID	ChangeUser NVARCHAR (4)		MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
UpdateStamp	UpdateStamp INT

Table	Description
MPFiBuPositionen	Journal Entries Export (Travel Expenses, Internal Service Charges, Work in Progress)
MPFiBuPositionenStorno	Journal Entries Canceled Records (Travel Expenses, Internal Service Charges, Work in Progress)
MPVKVertraegeBelegeILVKopf	Contract Management: Document Internal Service Charges Head

MARIProject Database Structure