MARIProject Database Structure

View Name:MARITravelTripLineDocument
Based on table:MPReise2ZeileDokumente
Group:Group: TravelTrip
Description:Travel Expenses Module: Trip receipt line (document link for scanned documents)

Field Table(Germ.field)/Type Description Related
TripLineDocID ReiseZeileDocumentID

INT Primary

TripLine ReiseZeile

INT Index

MARITravelTripLine.TripLine
DocumentID DokumentID

INT Index

MARIDocuments.DocumentID
VisibilityMode SichbarkeitsMode

INT

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




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany