C11/System/OPTIMA/SQL/schema/OPTIMA/tables/import.COMM_TRANS_UNIT.sql

CREATE TABLE [import].[COMM_TRANS_UNIT] (
   [PER_DATE] [datetime] NOT NULL,
   [UNIT_NO] [char](10) NOT NULL,
   [ROW_NO] [numeric](3,0) NOT NULL,
   [HANDLER] [char](4) NOT NULL,
   [DATE] [datetime] NOT NULL,
   [TEXT] [varchar](40) NOT NULL,
   [AMOUNT] [numeric](15,2) NOT NULL,
   [CONV_FLAG] [char](1) NULL,
   [timestamp] [binary](8) NOT NULL,
   [UNIQUE_IDENT] [numeric](12,0) NOT NULL,
   [CLIENT_DB] [varchar](20) NOT NULL
)


GO