| View Name: | MARIProjectBookingsFavorits |
| Based on table: | MPProjektBuchungFavoriten |
| Group: | Group: ProjectTimeKeepingHeader |
| Description: | Time Keeping: Favorits |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| FavoritsID | FavoritenID INT Primary |
||
| LineOrder | Reihenfolge INT Index |
||
| EmployeeNumber | Personalnummer NVARCHAR (20) Index |
MARIEmployeeMaster.EmployeeNumber | |
| ProjectNumber | Projektnummer NVARCHAR (20) Index |
MARIProjectMaster.ProjectNumber | |
| PhaseID | PhasenID INT Index |
MARIProjectPhases.PhaseID | |
| ContractID | VertragsID INT Index |
MARIContract.ContractID | |
| ContractPositionID | Vertragsposition INT |
MARIContractPositions.ContractPositionID | |
| ActivityText | Aktivitaet NVARCHAR (100) |
||
| ProductAddOn | ProduktZusatz NVARCHAR (20) |
||
| Quantity | Menge NUMERIC(19,6) |
||
| WorkingDays | MengeTage NUMERIC(19,6) |
||
| InvQty | MengeFAK NUMERIC(19,6) |
||
| QtyDaysInv | MengeTageFAK NUMERIC(19,6) |
||
| Overtime | MengeUeb NUMERIC(19,6) |
||
| Costs | Kosten NUMERIC(19,6) |
||
| TargetedRevenues | Erloese NUMERIC(19,6) |
||
| DefaultStart | Beginn Datetime |
||
| DefaultEnd | Ende Datetime |
||
| DefaultStartInv | BeginnFak Datetime |
||
| DefaultEndInv | EndeFak Datetime |
||
| OptionFlag | OptionFlag INT |
Indicates default for trips | |
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |