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

CREATE TABLE [import].[VEH_LINK_EXT] (
   [BASIS_NUMBER] [varchar](10) NOT NULL,
   [HANDLER] [char](4) NOT NULL,
   [TIME_STAMP_DATE] [datetime] NOT NULL,
   [TIME_STAMP_TIME_8] [numeric](8,0) NOT NULL,
   [REGISTER_NUMBER] [varchar](12) NOT NULL,
   [CHASSIS_NUMBER] [varchar](18) NOT NULL,
   [ACTION_CODE] [char](1) NOT NULL,
   [SALES_LOCATION] [varchar](10) NULL,
   [SERVICE_LOCATION] [varchar](10) NULL,
   [EXTERNAL_SYSTEM] [numeric](2,0) NOT NULL,
   [CONV_FLAG] [char](1) NULL,
   [timestamp] [binary](8) NOT NULL,
   [UNIQUE_IDENT] [numeric](12,0) NOT NULL,
   [PRIORITY] [numeric](1,0) NOT NULL,
   [CLIENT_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [PK_VEH_LINK_EXTBASIS_NUMBER] PRIMARY KEY CLUSTERED ([BASIS_NUMBER], [EXTERNAL_SYSTEM], [CLIENT_DB])
)


GO