SET QUOTED_IDENTIFIER ON
GO

SET ANSI_NULLS ON
GO

CREATE
	OR

ALTER VIEW [load].[Zeit_2_Ryma]
AS
SELECT [Employee No],
	[Datum],
	[Department No_ori],
	[Time Account No],
	[Time Account Value],
	[Ta Class (general)],
	[Ta Class (statistics)],
	[Ta Class (absent Days)],
	[Ta Class (time Processing)],
	[Ta Class (individual)],
	[Ta Class (employee Info)],
	[Ta Class (vacation Reduction)],
	[Ta Formatting],
	[Generating Function],
	[Record Protected],
	[No],
	[Description],
	[Description 2],
	[Zeitdauer_ori],
	[gesamt Stunden],
	[krank],
	[Wehr- /Zivildienst],
	[Sonderurlaub],
	[Berufsschule],
	[Innung Azubi],
	[Feiertag],
	[Schulung extern],
	[Urlaub],
	[W-fix Stunden],
	[Hauptbetrieb_ID],
	[Standort],
	[First Name],
	[Last Name],
	[Monteur_Gruppe_ori],
	[Abteilung],
	[Order Number],
	[Monteur],
	[Zeitausgleich],
	[Überstunden],
	[Leaving Date],
	[Group No 1],
	[Group No 2],
	[Group No 3],
	[Tage Heute Leaving Date],
	[Monteur_Gruppe],
	[produktiv/unproduktiv],
	[Monatserster],
	[Monatsletzter],
	[Heute],
	[Datum Tagesbericht],
	[Employment Date],
	[Department No],
	[Datum_Monteurlisten],
	[Fehlzeiten genehm./ungenem.],
	[Activity Desc],
	[Monteur_Gruppe_2],
	[Standort_ID],
	[Department No_1],
	[Task Type Group],
	[Sollzeit],
	[abwesend],
	[Home Page 2],
	[Employment Date_1],
	[Summe Sollzeit],
	[Zeitdauer]
FROM [export_csv].[Zeit_2_Ryma]
GO

SET QUOTED_IDENTIFIER OFF
GO

SET ANSI_NULLS OFF
GO


GO