C11/System/OPTIMA/SQL/schema/OPTIMA4/tables/import.UNIT_STATUS_HIST.sql

CREATE TABLE [import].[UNIT_STATUS_HIST] (
   [UNIT_NUMBER] [varchar](10) 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,
   [DOCUMENT_DATE] [datetime] NOT NULL,
   [UNIT_HIST_STATUS] [char](3) NOT NULL,
   [CLASSIFICATION_DTE] [datetime] NOT NULL,
   [INT_EXT_CODE] [char](1) NULL,
   [DESTINATION] [char](2) NULL,
   [ACTIVITY] [char](2) NULL,
   [CONV_FLAG] [char](1) NULL,
   [timestamp] [binary](8) NOT NULL,
   [UNIQUE_IDENT] [numeric](12,0) NOT NULL,
   [CUSTOMER_NUMBER] [varchar](10) NULL,
   [CLIENT_DB] [varchar](20) NOT NULL
)


GO