MARIProject Database Structure

View Name:MARITravelTemplate
Based on table:MPReise2Template
Group:Group: TravelTemplate
Description:Travel Expenses Module: Template Header
ClassID: 152. See Overview of ClassIDs by table.

Field Table(Germ.field)/Type Description Related
TravelTemplate Reisetemplate

INT Primary

Matchcode Matchcode

NVARCHAR (50) Index

TemplateMemo TemplateMemo

NTEXT

CountryShort LaenderKuerzel

NVARCHAR (2)

CreateDate Erstanlage

Datetime

CreateUser ErstanlageID

NVARCHAR (4)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate Aenderung

Datetime

ChangeUser AenderungID

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)
Inactive InAktiv

SMALLINT Index

Hide dataset
UpdateStamp UpdateStamp

INT


Linked by

Table Description
MARIEmployeesPeriod Employee Master: One line per employee and valid from period and business unit
MARIEmployeesTrip2TravelMilage Travel Expenses Module: Employee Mileage type (header)
MARIEmployeesTrip2TravelMilageSub Travel Expenses Module: Employee Mileage type (sub)
MARIJournalEntryISCRule Definitions for Internal Service Charge Wizard


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany