MARITravelPostingDocument

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

Field	Table(Germ.field)/Type	Description	Related
TravelDocumentID	ReiseBuchungsBelegID INT Primary
TravelEntryID	ReiseBuchungsID INT Index		MARITravelAccountingHeader.TravelEntryID
TravelDocumentType	ReiseBuchungsBelegtyp INT
DocumentTypeText	Belegart 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)
ERPTransferDate	ERPUebergabedatum Datetime
ERPTransferUser	ERPUebergabeUser NVARCHAR (4)		MARIUser.ERPTransferUser (WHERE BenutzerTyp=1)
ERPTransactionID	ERPTan 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
BusinessPartner	Geschaeftspartner NVARCHAR (20)		OCRD.CardCode
Company	Mandant SMALLINT Index		MARISysConnections.Company (WHERE ConnectionType=6)
OpenItemNumber	OPNr NVARCHAR (20)
DocDate	Belegdatum Datetime
DueDate	Faelligkeit Datetime
PostingDate	Buchungsdatum Datetime
Period	Periode INT		MARIPeriods.Period
NetSysCur	NettoSys NUMERIC(19,6)
NetCompCur	NettoMA NUMERIC(19,6)
NetFC	NettoFW NUMERIC(19,6)
GrossSysCur	BruttoSys NUMERIC(19,6)
GrossCompCur	BruttoMA NUMERIC(19,6)
GrossFC	BruttoFW NUMERIC(19,6)
TaxSysCur	SteuerSys NUMERIC(19,6)
TaxCompCur	SteuerMA NUMERIC(19,6)
TaxFC	SteuerFW NUMERIC(19,6)
CurrencySys	WKZSys NVARCHAR (3)
CurrencyCompany	WKZMa NVARCHAR (3)
CurrencyForeign	WKZBeleg NVARCHAR (3)
ExchangeRateCompany	WkzMaKurs Float
ExchangeRateFC2Sys	WKzKursFw Float
A0CardCode	A0Empfaenger NVARCHAR (20)		OCRD.CardCode
A0Salutation	A0Anrede NVARCHAR (50)
A0Name1	A0Name1 NVARCHAR (100)
A0Name2	A0Name2 NVARCHAR (50)
A0Name3	A0Zusatz NVARCHAR (50)
A0SingleCustomer	A0Einmalkunde SMALLINT
A0Matchcode	A0Matchcode NVARCHAR (100)
A0Street	A0Strasse NVARCHAR (100)
A0StreetNumber	A0Hausnummer NVARCHAR (100)
A0Country	A0Land NVARCHAR (3)
A0ZIP	A0PLZ NVARCHAR (20)
A0City	A0Ort NVARCHAR (100)
A0County	A0Bezirk NVARCHAR (100)
A0State	A0Bundesland NVARCHAR (3)
A0Block	A0Gebaeude NVARCHAR (100)
A0ContactPerson	A0AnsprechpartnerID INT		OCPR.CntctCode
A0AddressName1	A0AdressName NVARCHAR (50)
A0AddressName2	A0AdressName2 NVARCHAR (50)
A0AddressName3	A0AdressName3 NVARCHAR (50)
A0Building	A0GebaeudeStockwerk NTEXT
A0AddressMemo	A0AdressMemo NTEXT
A0CardFName	A0CardFName NVARCHAR (100)
A0AddrType	A0AddrType NVARCHAR (100)
A0AddressLineNum	A0AdressLineNum INT
A0GlbLocNum	A0GlbLocNum NVARCHAR (50)
A0Longitude	A0Longitude Float
A0Latitude	A0Latitude Float
A1CardCode	A1Empfaenger NVARCHAR (20)		OCRD.CardCode
A1Salutation	A1Anrede NVARCHAR (50)
A1Name1	A1Name1 NVARCHAR (100)
A1Name2	A1Name2 NVARCHAR (50)
A1Name3	A1Zusatz NVARCHAR (50)
A1SingleCustomer	A1Einmalkunde SMALLINT
A1Matchcode	A1Matchcode NVARCHAR (100)
A1Street	A1Strasse NVARCHAR (100)
A1StreetNum	A1Hausnummer NVARCHAR (100)
A1Country	A1Land NVARCHAR (3)
A1ZIP	A1PLZ NVARCHAR (20)
A1City	A1Ort NVARCHAR (100)
A1County	A1Bezirk NVARCHAR (100)
A1State	A1Bundesland NVARCHAR (3)
A1Block	A1Gebaeude NVARCHAR (100)
A1ContactPerson	A1AnsprechpartnerID INT		OCPR.CntctCode
A1AddressName1	A1AdressName NVARCHAR (50)
A1AddressName2	A1AdressName2 NVARCHAR (50)
A1AddressName3	A1AdressName3 NVARCHAR (50)
A1Building	A1GebaeudeStockwerk NTEXT
A1AddressMemo	A1AdressMemo NTEXT
A1CardFName	A1CardFName NVARCHAR (100)
A1AddrType	A1AddrType NVARCHAR (100)
A1AddressLineNum	A1AdressLineNum INT
A1GlbLocNum	A1GlbLocNum NVARCHAR (50)
A1Longitude	A1Longitude Float
A1Latitude	A1Latitude Float
TravelExpenseDocumentIDFollowing	ReiseBuchungsBelegIDNachfolger INT		MARITravelPostingDocument.TravelExpenseDocumentIDFollowing
TravelExpenseDocumentIDPrevious	ReiseBuchungsBelegIDVorgaenger INT		MARITravelPostingDocument.TravelExpenseDocumentIDPrevious
LocationID	LocationID INT Index
CreateDate	Erstanlage Datetime
CreateUser	ErstanlageID NVARCHAR (4)		MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate	Aenderung Datetime
ChangeUser	AenderungID NVARCHAR (4)		MARIUser.ChangeUser (WHERE BenutzerTyp=1)
UpdateStamp	UpdateStamp INT

Table	Description
MARITravelPostingDocument	Travel Expenses Module: Posting document
MARITravelPostingDocumentLine	Travel Expenses Module: Posting document lines
MARITravelPostingDocumentLineTax	Travel Expenses Module: Posting document lines sub tax

MARIProject Database Structure