| Table Name: | MPReise2Template |
| View Name: | MARITravelTemplate |
| Group: | Group: TravelTemplate |
| Description: | Travel Expenses Module: Template Header |
| ClassID: | 152. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Reisetemplate | TravelTemplate INT Primary |
||
| Matchcode | Matchcode NVARCHAR (50) Index |
||
| TemplateMemo | TemplateMemo NTEXT |
||
| LaenderKuerzel | CountryShort NVARCHAR (2) |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| InAktiv | Inactive SMALLINT Index |
Hide dataset | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPFibuBuchungsautomatRegel | Definitions for Internal Service Charge Wizard |
| MPPersonenPeriode | Employee Master: One line per employee and valid from period and business unit |
| MPPersonenReise2Fahrz | Travel Expenses Module: Employee Mileage type (header) |
| MPPersonenReise2FahrzSub | Travel Expenses Module: Employee Mileage type (sub) |