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

CREATE TABLE [import].[VEHICLE_ACCRUALS] (
   [UNIT_NUMBER] [varchar](10) NOT NULL,
   [CALC_RULE_DETAIL_ID] [numeric](12,0) NOT NULL,
   [TRANSACT_DATE] [datetime] NOT NULL,
   [HANDLER] [char](4) NOT NULL,
   [CALC_AMOUNT] [numeric](15,2) NOT NULL,
   [MANUALLY_CHANGED] [bit] NOT NULL,
   [AUTHORIZATION_CODE] [varchar](60) NOT NULL,
   [UNIQUE_IDENT] [numeric](12,0) NOT NULL,
   [timestamp] [binary](8) NOT NULL,
   [CONV_FLAG] [char](1) NULL,
   [CLIENT_DB] [varchar](20) NOT NULL

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


GO