| 123456789101112131415161718192021222324252627282930313233343536373839404142434445 |
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_NULLS ON
- GO
- CREATE VIEW [dbo].[TFM_fMonteurStempelzeiten]
- AS
- SELECT [Mandant ID]
- ,[Standort_ID]
- ,[Monteurnr]
- ,[Monteurnr_Fil]
- ,[Datum]
- ,[Order Number]
- ,[Monteur_Gruppe_2]
- ,[Monteur_Gruppe]
- ,[Activity_Codes_Group1]
- ,[Activity_Codes_Group2]
- ,[Activity_Desc]
- ,[noch nicht verr. Std.]
- ,[prod.]
- ,[unprod.]
- ,[Abw.]
- ,[prod_unprod]
- ,[Anw.]
- ,[ben.Zeit_ohne_LG]
- ,[ben.Zeit]
- ,[Kostenstelle]
- ,[Hauptbetrieb_ID]
- ,[Monteur_Azubi]
- ,[Extern]
- ,[GWL]
- ,[Intern]
- ,[Sollzeit]
- ,[Monteur]
- ,[Hauptbetrieb_Name]
- ,[Standort_Name]
- FROM [dbo].[TFM_fMonteurStempelzeiten95_3]
- GO
- SET QUOTED_IDENTIFIER OFF
- GO
- SET ANSI_NULLS OFF
- GO
- GO
|
