ETL_DWH_LOCOSOFT/schema/GC_ETL_LOCOSOFT/views/load.Zeit_Stempelungen_Pausen.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE view load.Zeit_Stempelungen_Pausen AS
select convert(varchar(10), Hauptbetrieb_ID)        AS Hauptbetrieb_ID,
       convert(varchar(50), Hauptbetrieb_Name)      AS Hauptbetrieb_Name,
       convert(varchar(10), Standort_ID)            AS Standort_ID,
       convert(varchar(50), Standort_Name)          AS Standort_Name,
       convert(varchar(50), Monteur_Gruppe)         AS Monteur_Gruppe,
       convert(varchar(50), Monteur_Gruppe_2)       AS Monteur_Gruppe_2,
       convert(varchar(250), Monteur)               AS Monteur,
       convert(int, Order_Number)                   AS Order_Number,
       convert(varchar(20), Activity_Codes_Group1)  AS Activity_Codes_Group1,
       convert(varchar(20), Activity_Codes_Group2)  AS Activity_Codes_Group2,
       convert(varchar(20), Activity_Desc)          AS Activity_Desc,
       convert(varchar(20), Kostenstelle)           AS Kostenstelle,
       convert(datetime, Invoice_Date)              AS Invoice_Date,
       convert(decimal(28, 8), prod_)               AS prod_,
       convert(decimal(28, 8), unprod__falsch)      AS unprod__falsch,
       convert(decimal(28, 8), Abw_)                AS Abw_,
       convert(decimal(28, 8), Extern)              AS Extern,
       convert(decimal(28, 8), GWL)                 AS GWL,
       convert(decimal(28, 8), Intern)              AS Intern,
       convert(decimal(28, 8), Sollzeit)            AS Sollzeit,
       convert(decimal(28, 8), TOY_produktiv_Zeit)  AS TOY_produktiv_Zeit,
       convert(decimal(28, 8), verr__Zeit_ohne_TOY) AS verr__Zeit_ohne_TOY,
       convert(decimal(28, 8), ben__Zeit_ohne_TOY)  AS ben__Zeit_ohne_TOY,
       convert(decimal(28, 8), Anz__AT)             AS Anz__AT,
       convert(decimal(28, 8), Anw_)                AS Anw_
from transform.Zeit_Stempelungen_Pausen
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO