locosoft.Zeit_ben_Std_LG.sql 1.0 KB

123456789101112131415161718192021222324252627282930
  1. CREATE TABLE [locosoft].[Zeit_ben_Std_LG] (
  2. [Order Number] [varchar](100) NULL,
  3. [Labour Type] [varchar](100) NULL,
  4. [Code_Labour_Types] [varchar](100) NULL,
  5. [Description_Labour_Types] [varchar](100) NULL,
  6. [Order Number_Labours] [varchar](100) NULL,
  7. [Subsidiary_Labours] [varchar](100) NULL,
  8. [Invoice Type_Labours] [varchar](100) NULL,
  9. [Mechanic No_Labours] [varchar](100) NULL,
  10. [AW Std ] [varchar](100) NULL,
  11. [Zeitkategorie] [varchar](100) NULL,
  12. [Zeitkategorie2] [varchar](100) NULL,
  13. [Employee Number_Employee] [varchar](100) NULL,
  14. [Name_Employee] [varchar](100) NULL,
  15. [Monteur] [varchar](100) NULL,
  16. [Invoice Date_Invoices] [datetime] NULL,
  17. [Datum] [datetime] NULL,
  18. [Duration Minutes_Times] [varchar](100) NULL,
  19. [ben Std ] [decimal](19,8) NULL,
  20. [Invoice Number] [varchar](100) NULL,
  21. [Is Canceled] [varchar](100) NULL,
  22. [Cancelation Number] [varchar](100) NULL,
  23. [Cancelation Date] [varchar](100) NULL,
  24. [Start Time] [datetime] NULL,
  25. [End Time] [datetime] NULL,
  26. [Min_Invoice_Date] [datetime] NULL
  27. )
  28. GO