CREATE TABLE [import].[Labor] ( [timestamp] [timestamp] NOT NULL, [Make Code] [varchar](10) NOT NULL, [No_] [varchar](20) NOT NULL, [Description] [varchar](255) NOT NULL, [Search Description] [varchar](255) NOT NULL, [Description 2] [varchar](255) NOT NULL, [Charging Group] [varchar](20) NOT NULL, [Main Group Code] [varchar](10) NOT NULL, [Subgroup Code] [varchar](10) NOT NULL, [Line Group Code] [varchar](10) NOT NULL, [Department Code] [varchar](10) NOT NULL, [No Charge] [tinyint] NOT NULL, [Fixed Price] [decimal](38,20) NOT NULL, [Last Date Modified] [datetime] NOT NULL, [Blocked] [tinyint] NOT NULL, [Gen_ Prod_ Posting Group] [varchar](10) NOT NULL, [No_ Series] [varchar](10) NOT NULL, [VAT Prod_ Posting Group] [varchar](10) NOT NULL, [Vehicle Appointment Code] [varchar](10) NOT NULL, [Update Description] [tinyint] NOT NULL, [No Service Surcharge] [tinyint] NOT NULL, [Automatic Ext_ Texts] [tinyint] NOT NULL, [No Update Charging Group] [tinyint] NOT NULL, [Using WIF] [tinyint] NOT NULL, [WIF Labor No_] [int] NOT NULL, [Fixed Price internal] [decimal](38,20) NOT NULL, [Not Accident Free] [tinyint] NOT NULL, [CLIENT_DB] [varchar](20) NOT NULL ,CONSTRAINT [Labor$0] PRIMARY KEY CLUSTERED ([Make Code], [No_], [CLIENT_DB]) ) GO