C11/System/ARI/Export/SQL/views_load/load.Time_Clock_Entry.sql

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_NULLS ON
GO

CREATE
	OR

ALTER VIEW [load].[Time_Clock_Entry]
AS
SELECT [Entry No],
	[Employee No],
	[Resource No],
	[Address No],
	[Date],
	[Time],
	[Sorting],
	[Duration],
	[Task Type Code],
	[Type],
	[Linked To Entry No],
	[Leaving],
	[Service Order No],
	[Service Job No],
	[Service Line No],
	[Labor Standard Time Type],
	[Approved],
	[Approved By Employee No],
	[Approval Timestamp],
	[Canceled],
	[Canceled By User Id],
	[Cancelation Timestamp],
	[Created By User Id],
	[Creation Timestamp],
	[Productive],
	[Statistics Group],
	[Considered As Working],
	[Order Location Code],
	[Resource Location Code],
	[Make Code],
	[Branch Code],
	[Labor No],
	[Description],
	[Source Code],
	[Efficiency],
	[Automatic],
	[Passed],
	[Code_Task_Type],
	[Description_Task_Type],
	[No_Employee_T],
	[Name_Employee_T],
	[Last Name_Employee_T],
	[First Name_Employee_T],
	[Group No 1_Employee_T],
	[Group No 2_Employee_T],
	[Group No 3_Employee_T],
	[Leaving Date_Employee_T],
	[produktiv/unproduktiv],
	[Monteur],
	[Monteur_Gruppe_ori],
	[Tage Heute Leaving Date],
	[Monteur_Gruppe_2],
	[Datum],
	[Monatserster],
	[Monatsletzter],
	[Heute],
	[Datum Tagesbericht],
	[Hauptbetrieb_ID],
	[Standort],
	[prod.],
	[unprod.],
	[Abw.],
	[produktiv_für_Berechnung_LG],
	[Servicemobil],
	[krank],
	[Meistervertr.],
	[Activity_Desc],
	[Standort_ID],
	[Monteur_Gruppe],
	[Department No],
	[Order Number],
	[Task Type Group],
	[Extern],
	[Intern],
	[Home Page 2],
	[Employment Date]
FROM [export_csv].[Time_Clock_Entry]
GO

SET QUOTED_IDENTIFIER OFF
GO

SET ANSI_NULLS OFF
GO


GO