locosoft.Zeit_verk_Std.sql 1.5 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. CREATE TABLE [locosoft].[Zeit_verk_Std] (
  2. [Order Number] [varchar](100) NULL,
  3. [Order Position] [varchar](100) NULL,
  4. [Labour Type] [varchar](100) NULL,
  5. [Code_Labour_Types] [varchar](100) NULL,
  6. [Description_Labour_Types] [varchar](100) NULL,
  7. [Order Number_Labours] [varchar](100) NULL,
  8. [Order Position_Labours] [varchar](100) NULL,
  9. [Order Position Line_Labours] [varchar](100) NULL,
  10. [Subsidiary_Labours] [varchar](100) NULL,
  11. [Is Invoiced_Labours] [varchar](100) NULL,
  12. [Invoice Type_Labours] [varchar](100) NULL,
  13. [Invoice Number_Labours] [varchar](100) NULL,
  14. [Employee No_Labours] [varchar](100) NULL,
  15. [Mechanic No_Labours] [varchar](100) NULL,
  16. [Labour Operation Id_Labours] [varchar](100) NULL,
  17. [Is Nominal_Labours] [varchar](100) NULL,
  18. [Net Price In Order_Labours] [decimal](19,8) NULL,
  19. [Rebate Percent_Labours] [decimal](19,8) NULL,
  20. [Goodwill Percent_Labours] [decimal](19,8) NULL,
  21. [Charge Type_Labours] [varchar](100) NULL,
  22. [Text Line_Labours] [varchar](100) NULL,
  23. [AW Std ] [varchar](100) NULL,
  24. [verk Std ] [decimal](19,8) NULL,
  25. [Zeitkategorie] [varchar](100) NULL,
  26. [Zeitkategorie2] [varchar](100) NULL,
  27. [Employee Number_Employee] [varchar](100) NULL,
  28. [Name_Employee] [varchar](100) NULL,
  29. [Monteur] [varchar](100) NULL,
  30. [Invoice Number_Invoices] [varchar](100) NULL,
  31. [Invoice Date_Invoices] [datetime] NULL,
  32. [Datum] [datetime] NULL,
  33. [Time Units_Labours] [varchar](100) NULL,
  34. [Time_Units_Zahl] [varchar](100) NULL
  35. )
  36. GO