| View Name: | MARITravelTripProjectLink |
| Based on table: | MPReise2Grundprojekte |
| Group: | Group: TravelTrip |
| Description: | Travel Expenses Module: Business Trip Project Link |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| TripBaseProjectID | ReiseGrundprojektID INT Primary |
||
| TripID | ReiseID INT Index |
MARITravelTrip.TripID | |
| ProjectOrder | Reihenfolge SMALLINT Index |
||
| ProjectNumber | Projektnummer NVARCHAR (20) |
MARIProjectMaster.ProjectNumber | |
| PhaseID | PhasenID INT |
MARIProjectPhases.PhaseID | |
| ContractID | VertragsID INT |
MARIContract.ContractID | |
| PercentValue | Prozent NUMERIC(19,6) |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARITravelTripLineProject | Travel Expenses Module: Trip receipt project line for invoice |