ETL_DWH_ARI/schema/GC_TRANSIT_ARI/tables/import.Service_Header.sql

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