| View Name: | MARITravelMilageAllowanceHeader |
| Based on table: | MPReise2KostenFahrzeugarten |
| Group: | Group: TravelExpenseTypes |
| Description: | Travel Expenses Module: Mileage allowances header |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| VehicleType | Fahrzeugart INT Primary |
||
| TravelTemplateVersion | ReiseTemplateVersion INT Primary |
||
| Description | Bezeichnung NVARCHAR (50) |
||
| CompanyCarID | Firmenfahrzeug SMALLINT (0=false,-1=true) |
||
| Inactive | InAktiv SMALLINT (0=false,-1=true) 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 |
|---|---|
| MARIEmployeesTravelMilage | Employee Master: Linked mileage allowances |
| MARIEmployeesTrip2TravelMilage | Travel Expenses Module: Employee Mileage type (header) |
| MARIEmployeesTrip2TravelMilageSub | Travel Expenses Module: Employee Mileage type (sub) |
| MARITravelTripLine | Travel Expenses Module: Trip receipt line |