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

CREATE TABLE [import].[VEHICLE_EXTENSION] (
   [BASIS_NUMBER] [varchar](20) NOT NULL,
   [EXTERNAL_ID] [numeric](10,0) NOT NULL,
   [MOT_TEST] [char](1) NOT NULL,
   [YELLOW_GREY] [numeric](10,0) NOT NULL,
   [REPLACE_MILEAGE] [numeric](6,0) NOT NULL,
   [LAST_ASU_DATE] [datetime] NOT NULL,
   [TRIM_TYPE_CODE] [char](5) NULL,
   [CLASSIFICATION_CD] [varchar](20) NULL,
   [FLEET_PRICE_LEVEL] [char](1) NULL,
   [DETAIL_REG_DATE] [datetime] NULL,
   [TRADE_IN_MAKE] [char](2) NULL,
   [TRADE_IN_MILEAGE] [numeric](6,0) NULL,
   [TRADE_IN_COLOUR] [varchar](30) NULL,
   [CONV_FLAG] [char](1) NULL,
   [timestamp] [binary](8) NOT NULL,
   [UNIQUE_IDENT] [numeric](12,0) NOT NULL,
   [ADDR_2_DELIVERY] [varchar](60) NULL,
   [CO2_EMISSION] [numeric](6,0) NULL,
   [EURO_EMISSION_STD] [char](3) NULL,
   [GASSYSTEM] [char](1) NULL,
   [KILOWATT] [numeric](6,0) NULL,
   [LOGIN_DEALER] [char](4) NULL,
   [LOGIN_RESV_DEALER] [char](4) NULL,
   [MAIL_ADDR_DELIVERY] [varchar](60) NULL,
   [MODEL_TEXT_2] [varchar](90) NULL,
   [NAME_DELIVERY] [varchar](60) NULL,
   [NOX_EXHAUST] [numeric](6,0) NULL,
   [PACKAGE_TEXT] [varchar](50) NULL,
   [PARTICLE_FILTER] [numeric](5,4) NULL,
   [PICK_SELF] [char](1) NULL,
   [ZIPCODE_DELIVERY] [varchar](10) NULL,
   [COC_NUMBER] [varchar](20) NULL,
   [DAM_NUMBER] [numeric](5,0) NULL,
   [DAMAGE_DESCRIPTION] [varchar](50) NULL,
   [DAMAGE_PRICE] [numeric](15,2) NULL,
   [GEAR_BOX_TYPE] [varchar](20) NULL,
   [LARGER_DAMAGE] [char](1) NULL,
   [MODEL] [varchar](200) NULL,
   [MODEL_VARIANT] [varchar](120) NULL,
   [PROD_DATE] [datetime] NULL,
   [SPECIAL_USE] [varchar](30) NULL,
   [WEIGHT] [numeric](5,0) NULL,
   [ADVICE_RECIPIENT] [char](1) NULL,
   [AIR_CONDITION] [char](1) NULL,
   [DAT_EURO_CODE] [varchar](50) NULL,
   [DRIVER] [varchar](10) NULL,
   [DSP_EXPIRY_DATE] [datetime] NULL,
   [DSP_MAKE_CD] [char](2) NULL,
   [DSP_NO_OF_SERVICES_USED] [numeric](3,0) NULL,
   [DSP_PROD_CODE] [varchar](22) NULL,
   [DSP_REST_AMOUNT] [numeric](15,2) NULL,
   [DSP_START_AMOUNT] [numeric](15,2) NULL,
   [GAS_SYSTEM_INSTALLED] [datetime] NULL,
   [HANDLER_SYSTEM] [numeric](2,0) NULL,
   [INSURANCE_COMPANY_CHANGED] [datetime] NULL,
   [LEAS_FINANCING_DOWN_PAY] [numeric](15,2) NULL,
   [LEAS_FINANCING_FINAL_PAY] [numeric](15,2) NULL,
   [LEAS_FINANCING_MONTH_PAY] [numeric](15,2) NULL,
   [LEASING_FINANCING_CONTRACT] [char](1) NULL,
   [LEASING_FINANCING_EXPIRE] [datetime] NULL,
   [LEASING_FINANCING_NAME] [char](6) NULL,
   [LEASING_FINANCING_PERIOD] [numeric](3,0) NULL,
   [LEASING_FINANCING_SALESMAN] [char](4) NULL,
   [LEASING_FINANCING_START] [datetime] NULL,
   [MAN_CALL_FOR_SERVICE] [char](1) NULL,
   [MISC_1_DD] [char](6) NULL,
   [MISC_2_DD] [char](6) NULL,
   [MISC_3_DD] [char](6) NULL,
   [MISC_4_DD] [char](6) NULL,
   [MISC_5_DD] [char](6) NULL,
   [MOBILE_SERVICE_EXPIRY_DATE] [datetime] NULL,
   [MOBILE_SERVICE_TYPE] [char](6) NULL,
   [NEXT_AIR_CONDITIONING_DATE] [datetime] NULL,
   [SERVICE_GUARANTEE] [char](6) NULL,
   [TYRES] [char](6) NULL,
   [TYRES_LOCATION] [varchar](30) NULL,
   [BATTERY_FINANCING] [char](1) NULL,
   [ELECTRICITY_CONSUMPTION] [numeric](6,1) NULL,
   [ELECTRICITY_EMISSION] [numeric](6,0) NULL,
   [GAS_CONSUMPTION] [numeric](6,1) NULL,
   [GAS_EMISSION] [numeric](6,0) NULL,
   [LOWEST_EMISSION_FUEL] [varchar](30) NULL,
   [MODEL_IDENTIFIER] [varchar](60) NULL,
   [OPTION_IDENTIFIER] [varchar](60) NULL,
   [PIN_CODE] [varchar](60) NULL,
   [PIN_IDENTIFIER] [varchar](60) NULL,
   [PIN_STATUS] [varchar](60) NULL,
   [SUPPORTED_FUEL] [varchar](30) NULL,
   [TYPE_APPROVAL_IDENTIFIER] [varchar](60) NULL,
   [VEHICLE_DESCRIPTION] [varchar](255) NULL,
   [TDK_CALL_DATE] [datetime] NULL,
   [DATE_ORDER_RECEIVED] [datetime] NULL,
   [EQUIPMENT_YES_NO] [char](1) NULL,
   [EMISSION_CODE] [varchar](30) NULL,
   [EMISSION_TEXT] [varchar](255) NULL,
   [ENGINE_CODE] [varchar](30) NULL,
   [ENGINE_TEXT] [varchar](255) NULL,
   [OWN_INSURANCE_SHARE] [char](6) NULL,
   [TRANSMISSION_CODE] [varchar](30) NULL,
   [TRANSMISSION_TEXT] [varchar](255) NULL,
   [TSV_VERSION] [varchar](30) NULL,
   [OWNER_CODE_2] [varchar](10) NULL,
   [CLIENT_DB] [varchar](20) NOT NULL
)


GO