| 123456789101112131415161718192021222324252627282930313233343536 |
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_NULLS ON
- GO
- CREATE VIEW [xtract].[Time_Entry_T] AS
- SELECT [timestamp]
- , [Employee No_]
- , [Current Date]
- -- , [Department No_]
- -- , [Order No_]
- -- , [Task No_]
- -- , [Dimension 1]
- -- , [Dimension 2]
- -- , [Dimension 3]
- -- , [Dimension 4]
- , [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]
- , [Client_DB]
- FROM [GC_TRANSIT_ARI].[import].[Time_Entry_T]
- GO
- SET QUOTED_IDENTIFIER OFF
- GO
- SET ANSI_NULLS OFF
- GO
- GO
|