xtract.Time_Entry_T.sql 839 B

123456789101112131415161718192021222324252627282930313233343536
  1. SET QUOTED_IDENTIFIER ON
  2. GO
  3. SET ANSI_NULLS ON
  4. GO
  5. CREATE VIEW [xtract].[Time_Entry_T] AS
  6. SELECT [timestamp]
  7. , [Employee No_]
  8. , [Current Date]
  9. -- , [Department No_]
  10. -- , [Order No_]
  11. -- , [Task No_]
  12. -- , [Dimension 1]
  13. -- , [Dimension 2]
  14. -- , [Dimension 3]
  15. -- , [Dimension 4]
  16. , [Time Account No_]
  17. , [Time Account Value]
  18. -- , [TA Class (General)]
  19. -- , [TA Class (Statistics)]
  20. -- , [TA Class (Absent Days)]
  21. -- , [TA Class (Time Processing)]
  22. -- , [TA Class (Individual)]
  23. -- , [TA Class (Employee Info)]
  24. -- , [TA Class (Vacation Reduction)]
  25. -- , [TA Formatting]
  26. -- , [Generating Function]
  27. -- , [Record protected]
  28. , [Client_DB]
  29. FROM [GC_TRANSIT_ARI].[import].[Time_Entry_T]
  30. GO
  31. SET QUOTED_IDENTIFIER OFF
  32. GO
  33. SET ANSI_NULLS OFF
  34. GO
  35. GO