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

CREATE TABLE [import].[VPP53] (
   [LINE_NO] [varchar](12) NOT NULL,
   [STATE_CODE_PARAM] [char](1) NOT NULL,
   [TRANSACT_DATE] [datetime] NOT NULL,
   [HANDLER] [char](4) NOT NULL,
   [NAME] [varchar](50) NOT NULL,
   [LINE_TYPE] [varchar](1) NOT NULL,
   [START_ACCT] [varchar](10) NOT NULL,
   [END_ACCT] [varchar](10) NOT NULL,
   [timestamp] [binary](8) NOT NULL,
   [UNIQUE_IDENT] [numeric](12,0) NOT NULL,
   [CLIENT_DB] [varchar](20) NOT NULL

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


GO