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

CREATE TABLE [import].[VEH_TRANSACT_GRID] (
   [LINE_NO] [numeric](4,0) NOT NULL,
   [GROUP_ID] [char](2) NOT NULL,
   [COLUMN_NO] [numeric](1,0) NOT NULL,
   [VALUE_TEXT] [varchar](30) NOT NULL,
   [VALUE_TRANSACT] [char](3) NOT NULL,
   [VALUE_GROUP] [char](2) NOT NULL,
   [VALUE_COLUMN] [numeric](1,0) NOT NULL,
   [TRANSACT_DATE] [datetime] NOT NULL,
   [HANDLER] [char](4) NOT NULL,
   [UNIQUE_IDENT] [numeric](12,0) NOT NULL,
   [CONV_FLAG] [char](1) NULL,
   [timestamp] [binary](8) NOT NULL,
   [CLIENT_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [PK_VEH_TRANSACT_GRIDUNIQUE_IDENT] PRIMARY KEY CLUSTERED ([UNIQUE_IDENT], [CLIENT_DB])
)


GO