MPReise2BuchungBeleg

Table Name:	MPReise2BuchungBeleg
View Name:	MARITravelPostingDocument
Group:	Group: TravelTrip
Description:	Travel Expenses Module: Posting document
ClassID:	160. See Overview of ClassIDs by table.

Field	View(engl.field)/Type	Description	Related
ReiseBuchungsBelegID	TravelDocumentID INT Primary
ReiseBuchungsID	TravelEntryID INT Index		MPReise2BuchungKopf.ReiseBuchungsID
ReiseBuchungsBelegtyp	TravelDocumentType INT
Belegart	DocumentTypeText NVARCHAR (50)
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		MPPerioden.PeriodeJahr
NettoSys	NetSysCur NUMERIC(19,6)
NettoMA	NetCompCur NUMERIC(19,6)
NettoFW	NetFC NUMERIC(19,6)
BruttoSys	GrossSysCur NUMERIC(19,6)
BruttoMA	GrossCompCur NUMERIC(19,6)
BruttoFW	GrossFC NUMERIC(19,6)
SteuerSys	TaxSysCur 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
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
A1Empfaenger	A1CardCode NVARCHAR (20)		OCRD.CardCode
A1Anrede	A1Salutation NVARCHAR (50)
A1Name1	A1Name1 NVARCHAR (100)
A1Name2	A1Name2 NVARCHAR (50)
A1Zusatz	A1Name3 NVARCHAR (50)
A1Einmalkunde	A1SingleCustomer 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		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
ReiseBuchungsBelegIDNachfolger	TravelExpenseDocumentIDFollowing INT		MPReise2BuchungBeleg.ReiseBuchungsBelegID
ReiseBuchungsBelegIDVorgaenger	TravelExpenseDocumentIDPrevious INT		MPReise2BuchungBeleg.ReiseBuchungsBelegID
LocationID	LocationID 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
MPReise2BuchungBeleg	Travel Expenses Module: Posting document
MPReise2BuchungBelegPos	Travel Expenses Module: Posting document lines
MPReise2BuchungBelegPosSteuer	Travel Expenses Module: Posting document lines sub tax

MARIProject Database Structure