| Table Name: | MPReise2TemplateRegel |
| View Name: | MARITravelTemplateSetting |
| Group: | Group: TravelTemplate |
| Description: | Travel Expenses Module: Template Settings |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ReiseTemplateVersion | TravelTemplateVersion INT Primary |
||
| RegelEigenschaft | SettingID INT Primary |
||
| RegelEigenschaftIndex | SettingIndex SMALLINT Primary |
||
| Mandant | Company SMALLINT Primary |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| WertText | ValueText NTEXT |
||
| WertZahl | ValueNumber NUMERIC(19,6) |
||
| WertDatum | ValueDate Datetime |
||
| WertTyp | ValueType TINYINT |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |