CREATE TABLE [import].[UNIT_CHANGE_HIST] (
   [UNIT_NUMBER] [varchar](10) NOT NULL,
   [VAL_DATE] [datetime] NOT NULL,
   [SEQ_NO] [numeric](4,0) NOT NULL,
   [TRANSACT_DATE] [datetime] NOT NULL,
   [HANDLER] [char](4) NOT NULL,
   [PROGRAM] [char](6) NOT NULL,
   [FUNCTION_CODE] [char](4) NOT NULL,
   [BOOK_KEEPING_CODE] [varchar](10) NOT NULL,
   [TAX_HANDLING] [char](1) NOT NULL,
   [VAT_RATE_CODE] [char](2) NOT NULL,
   [DEPARTMENT] [char](4) NOT NULL,
   [CLASSIFICATION_DTE] [datetime] NOT NULL,
   [VEHICLE_TYPE] [char](1) NULL,
   [MAKE_CD] [char](2) NULL,
   [MAKE_FAMILY_CD] [char](2) NULL,
   [MODEL_LINE] [char](2) NULL,
   [WORKSHOP_MODEL] [varchar](10) NULL,
   [FAC_MODEL_CODE] [varchar](20) NULL,
   [USED_VEH_DEST_CODE] [char](1) NULL,
   [PURCH_ORIGIN_CODE] [char](2) NULL,
   [USE_OF_VEHICLE] [char](2) NULL,
   [CONV_FLAG] [char](1) NULL,
   [timestamp] [binary](8) NOT NULL,
   [UNIQUE_IDENT] [numeric](12,0) NOT NULL,
   [PURCH_SALESMAN] [char](4) NULL,
   [SALE_SALESMAN] [char](4) NULL,
   [CLIENT_DB] [varchar](20) NOT NULL

)

CREATE NONCLUSTERED INDEX [IX_UNIT_CHANGE_HIST] ON [import].[UNIT_CHANGE_HIST] ([DEPARTMENT])

GO