CREATE TABLE [import].[Service_Header] ( [timestamp] [binary](8) NOT NULL, [Document Type] [int] NOT NULL, [No_] [varchar](20) NOT NULL, [Sell-to Customer No_] [varchar](20) NOT NULL, [Bill-to Customer No_] [varchar](20) NOT NULL, [Bill-to Name] [varchar](100) NOT NULL, [Order Date] [datetime] NOT NULL, [Location Code] [varchar](10) NOT NULL, [Department Code] [varchar](20) NOT NULL, [Make Code] [varchar](20) NOT NULL, [Sell-to Customer Name] [varchar](100) NOT NULL, [VIN] [varchar](20) NOT NULL, [Model] [varchar](50) NOT NULL, [Pickup Date] [datetime] NOT NULL, [Service Advisor No_] [varchar](20) NOT NULL, [Client_DB] [varchar](20) NOT NULL ,CONSTRAINT [Service Header$0] PRIMARY KEY CLUSTERED ([No_], [Document Type], [Client_DB]) ) GO