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

CREATE TABLE [import].[VEHICLE] (
   [BASIS_NUMBER] [varchar](20) NOT NULL,
   [STATE_CODE_CF] [char](1) NOT NULL,
   [TRANSACT_DATE] [datetime] NOT NULL,
   [HANDLER] [char](4) NOT NULL,
   [DEBIT_ACCOUNT] [varchar](10) NOT NULL,
   [REGISTER_NUMBER] [varchar](20) NOT NULL,
   [CHASSIS_NUMBER] [varchar](30) NOT NULL,
   [CAR_GROUP] [char](2) NOT NULL,
   [CAR_STATUS] [char](2) NOT NULL,
   [FAC_MODEL_CODE_L] [varchar](20) NOT NULL,
   [USER_CODE] [varchar](10) NOT NULL,
   [OWNER_CODE] [varchar](10) NOT NULL,
   [UNIT_ACCOUNTING_CF] [char](1) NOT NULL,
   [CONTACT_PERSON] [varchar](50) NOT NULL,
   [FIRST_REG_DATE] [datetime] NOT NULL,
   [LATEST_REG_DATE] [datetime] NOT NULL,
   [FIRST_OCCUR_DATE] [datetime] NOT NULL,
   [EXPECTED_ARR_DATE] [datetime] NOT NULL,
   [ARRIVAL_DATE] [datetime] NOT NULL,
   [LAST_OWNER_CHANGE] [datetime] NOT NULL,
   [SALESMAN_BUY] [varchar](20) NOT NULL,
   [SALESMAN_SALE] [varchar](20) NOT NULL,
   [MODEL_TEXT] [varchar](50) NOT NULL,
   [ORIG_MODEL_CODE1] [varchar](50) NOT NULL,
   [ORIG_MODEL_CODE2] [varchar](15) NOT NULL,
   [COLOUR_CF] [varchar](50) NOT NULL,
   [TRIM_TXT] [varchar](50) NOT NULL,
   [MODEL_LINE] [varchar](20) NOT NULL,
   [WORKSHOP_MODEL] [varchar](10) NOT NULL,
   [FAC_MODEL_CODE_S] [varchar](20) NOT NULL,
   [CLASSIFICATION] [varchar](20) NOT NULL,
   [MOTOR_NUMBER] [varchar](20) NOT NULL,
   [KEY_CODE] [varchar](20) NOT NULL,
   [YEAR_MODEL_CF] [char](5) NOT NULL,
   [CYLINDER_VOLUME] [numeric](4,3) NOT NULL,
   [SEATS] [varchar](20) NOT NULL,
   [DECLARATION_DATE] [datetime] NOT NULL,
   [DECLARATION_PLACE] [varchar](30) NOT NULL,
   [DECLARATION_NUMBER] [varchar](10) NOT NULL,
   [ARRIVAL_SHIP] [varchar](20) NOT NULL,
   [ARRIVAL_NUMBER] [varchar](10) NOT NULL,
   [BILL_OF_LANDING] [varchar](10) NOT NULL,
   [SCRUTINEERING_DATE] [datetime] NOT NULL,
   [EQUIPMENT_1] [varchar](50) NOT NULL,
   [EQUIPMENT_2] [varchar](50) NOT NULL,
   [EQUIPMENT_3] [varchar](50) NOT NULL,
   [EQUIPMENT_4] [varchar](50) NOT NULL,
   [INSURANCE] [varchar](50) NOT NULL,
   [INSURANCE_COMPANY] [varchar](50) NOT NULL,
   [MILEAGE] [numeric](6,0) NOT NULL,
   [MISC_1_CF] [varchar](50) NOT NULL,
   [MISC_2_CF] [varchar](50) NOT NULL,
   [MISC_3_CF] [varchar](50) NOT NULL,
   [MISC_4_CF] [varchar](20) NOT NULL,
   [MISC_5_CF] [varchar](20) NOT NULL,
   [MISC_6_CF] [varchar](20) NOT NULL,
   [MISC_7_CF] [varchar](20) NOT NULL,
   [MISC_8_CF] [varchar](20) NOT NULL,
   [MISC_9_CF] [varchar](20) NOT NULL,
   [MISC_10_CF] [varchar](20) NOT NULL,
   [LAST_INVOICE_DTE] [datetime] NOT NULL,
   [CONTACT_DATE] [datetime] NOT NULL,
   [MAIL_CODE_1] [varchar](30) NOT NULL,
   [MAIL_CODE_2] [char](4) NOT NULL,
   [MAIL_CODE_3] [char](4) NOT NULL,
   [MAIL_CODE_4] [char](4) NOT NULL,
   [MAIL_CODE_5] [char](4) NOT NULL,
   [MAIL_CODE_6] [char](4) NOT NULL,
   [MAIL_CODE_7] [char](4) NOT NULL,
   [MAIL_CODE_8] [char](4) NOT NULL,
   [MAIL_CODE_9] [char](4) NOT NULL,
   [MOTOR_CODE] [varchar](30) NOT NULL,
   [GEAR_CODE] [varchar](50) NOT NULL,
   [DRIVE_CODE] [char](5) NOT NULL,
   [COLOUR_CODE] [varchar](30) NOT NULL,
   [TRIM_CODE] [varchar](30) NOT NULL,
   [LATEST_UNIT_NO] [varchar](10) NOT NULL,
   [FOLLOW_UP] [varchar](20) NOT NULL,
   [NO_OF_OWNERS] [numeric](2,0) NOT NULL,
   [CAR_LETTER] [varchar](10) NOT NULL,
   [TUV_TYPE] [varchar](20) NOT NULL,
   [TUV_DATE] [datetime] NOT NULL,
   [TUV_INSP] [char](1) NOT NULL,
   [ASU_TYPE] [varchar](10) NOT NULL,
   [ASU_DATE] [datetime] NOT NULL,
   [ASU_INSP] [char](1) NOT NULL,
   [TYPE_YEAR] [char](2) NOT NULL,
   [PACKAGE_CF] [char](5) NOT NULL,
   [VEH_ASS_TYPE] [char](2) NOT NULL,
   [SALE_THIS_YEAR] [numeric](15,2) NOT NULL,
   [SALE_LAST_YEAR] [numeric](15,2) NOT NULL,
   [SALE_LAST_YEAR_1] [numeric](15,2) NOT NULL,
   [DELETE_PROPOSAL] [char](1) NOT NULL,
   [DUPLICATE_REG_NO] [char](1) NOT NULL,
   [LEASING] [char](1) NOT NULL,
   [SHIP_DATE] [datetime] NOT NULL,
   [FAC_ORDER_NUMBER] [varchar](10) NOT NULL,
   [AVAILABLE] [char](1) NOT NULL,
   [CAL_COST] [char](1) NOT NULL,
   [CAL_COST_DATE] [datetime] NOT NULL,
   [RUN_1] [char](1) NOT NULL,
   [RUN_2] [char](1) NOT NULL,
   [RUN_3] [char](1) NOT NULL,
   [RUN_4] [char](1) NOT NULL,
   [RUN_5] [char](1) NOT NULL,
   [RUN_6] [char](1) NOT NULL,
   [RUN_7] [char](1) NOT NULL,
   [RUN_8] [char](1) NOT NULL,
   [RUN_9] [char](1) NOT NULL,
   [RUN_10] [char](1) NOT NULL,
   [RUN_11] [char](1) NOT NULL,
   [RUN_12] [char](1) NOT NULL,
   [RUN_13] [char](1) NOT NULL,
   [RUN_14] [char](1) NOT NULL,
   [RUN_15] [char](1) NOT NULL,
   [RUN_16] [char](1) NOT NULL,
   [RUN_17] [char](1) NOT NULL,
   [RUN_18] [char](1) NOT NULL,
   [RUN_19] [char](1) NOT NULL,
   [RUN_20] [char](1) NOT NULL,
   [STOCK_DATE] [datetime] NOT NULL,
   [MARKING_1] [char](1) NOT NULL,
   [MARKING_2] [char](1) NOT NULL,
   [MARKING_3] [char](1) NOT NULL,
   [MARKING_4] [char](1) NOT NULL,
   [MARKING_5] [char](1) NOT NULL,
   [IMP_ORDER_NUMBER] [varchar](10) NOT NULL,
   [SCRAP_DATE] [datetime] NOT NULL,
   [TRANSMISSION_DATE] [datetime] NOT NULL,
   [PURCH_CAL_DATE] [datetime] NOT NULL,
   [SALES_CAL_DATE] [datetime] NOT NULL,
   [DEALER_DEL_DATE] [datetime] NOT NULL,
   [OPTIONAL_DATE_1] [datetime] NOT NULL,
   [OPTIONAL_DATE_2] [datetime] NOT NULL,
   [OPTIONAL_DATE_3] [datetime] NOT NULL,
   [OPTIONAL_DATE_4] [datetime] NOT NULL,
   [OPTIONAL_DATE_5] [datetime] NOT NULL,
   [MODEL_LINE_GROUP] [char](4) NOT NULL,
   [MODEL_TYPE_2] [char](2) NOT NULL,
   [MAKE] [char](1) NOT NULL,
   [HOUR_RATE_TABLE] [char](1) NOT NULL,
   [PAID_DATE] [datetime] NULL,
   [LATEST_INV_DATE] [datetime] NULL,
   [ORIG_INV_DATE] [datetime] NULL,
   [CREDIT_NOTE_DATE] [datetime] NULL,
   [EXTRACTION_DATE] [datetime] NULL,
   [PROD_INFO] [varchar](20) NULL,
   [REG_NUMBER_IMP] [varchar](10) NULL,
   [PRICE_CARD] [char](4) NULL,
   [PURCH_AMOUNT] [numeric](15,2) NULL,
   [DEALER_NUMBER] [varchar](10) NULL,
   [INVOICE_STATE] [char](1) NULL,
   [VEH_DUE_DATE] [datetime] NULL,
   [DEALER_MARKING] [char](2) NULL,
   [TRADE_IN_CAR] [varchar](25) NULL,
   [TRADE_IN_CAR_YEAR] [numeric](4,0) NULL,
   [EXPORT_VEHICLE] [char](1) NULL,
   [DOORS] [numeric](1,0) NULL,
   [KBA_CODE] [varchar](13) NULL,
   [FUELTYPE] [varchar](20) NULL,
   [FUEL_CONS_TOWN] [numeric](5,2) NULL,
   [FUEL_CONS_90KMH] [numeric](5,2) NULL,
   [FUEL_CONS_EUNORM] [numeric](5,2) NULL,
   [CALL_FOR_SERVICE] [char](1) NULL,
   [EXP_KM_PER_YEAR] [numeric](6,0) NULL,
   [EXP_SERVICE_DATE_1] [datetime] NULL,
   [EXP_SERVICE_DATE_2] [datetime] NULL,
   [EXP_SERVICE_DATE_3] [datetime] NULL,
   [EXP_SERVICE_DATE_4] [datetime] NULL,
   [EXP_SERVICE_DATE_5] [datetime] NULL,
   [DEALER_MESSAGE_NO] [char](5) NULL,
   [SERVICE_DAYS] [numeric](3,0) NULL,
   [HOURLY_REPAIR_RATE] [numeric](15,2) NULL,
   [WORKSHOP_PRICECODE] [char](2) NULL,
   [DISCOUNT_PERC_WORK] [numeric](5,2) NULL,
   [SOLDMARK_DATE] [datetime] NULL,
   [MOBIL_SC_DATE] [datetime] NULL,
   [TYPE_CER_TXT] [varchar](60) NULL,
   [MAKE_CD] [char](2) NULL,
   [VEH_LOCATION] [varchar](10) NULL,
   [IMP_COMMENT] [varchar](30) NULL,
   [DEALER_NOTE] [varchar](50) NULL,
   [DELIVER_TO_DEALER] [varchar](10) NULL,
   [TRADE_IN_CAR_CHAS] [varchar](20) NULL,
   [GMS_REFERENCE] [varchar](12) NULL,
   [USE_OF_VEHICLE] [char](2) NULL,
   [PAINT_TYPE] [char](5) NULL,
   [GEAR_NO] [varchar](15) NULL,
   [SERV_CONTRACT_NO] [varchar](19) NULL,
   [PRODUCTION_NO] [varchar](30) NULL,
   [PHOTO] [varchar](60) NULL,
   [UPLOAD_MARKING] [char](1) NULL,
   [DOOR_CODE] [char](5) NULL,
   [BPM_AMOUNT] [numeric](15,2) NULL,
   [RADIO_CODE] [varchar](20) NULL,
   [WARRENTY_END] [datetime] NULL,
   [LAST_MOT_DATE] [datetime] NULL,
   [LAST_SERVICE_DATE] [datetime] NULL,
   [LAST_SERVICE_TXT] [varchar](50) NULL,
   [REPLACEMENT_DATE] [datetime] NULL,
   [NEXT_SERVICE_TXT] [varchar](50) NULL,
   [MAINTAIN_INT_YEARS] [numeric](2,0) NULL,
   [MAINTAIN_INT_MILES] [numeric](6,0) NULL,
   [SALES_LOCATION] [varchar](10) NULL,
   [SERVICE_LOCATION] [varchar](10) NULL,
   [FISCAL_HORSEPOWER] [numeric](2,0) NULL,
   [EXPORT_EUROCASION] [char](1) NULL,
   [HORSEPOWER] [numeric](3,0) NULL,
   [GOV_CERT_REQUEST_DATE] [datetime] NULL,
   [GOV_CERT_RECEPTION_DATE] [datetime] NULL,
   [HANDLER_SYSTEM] [numeric](2,0) NULL,
   [ENGINE_HOURS] [numeric](9,2) NULL,
   [LICENCE_LOCATION] [char](2) NULL,
   [MD_MACHINE_ID] [numeric](12,0) NULL,
   [CHASSIS_UNIQUE] [varchar](30) NOT NULL,
   [COURTESY_CAR] [varchar](20) NULL,
   [CONV_FLAG] [char](1) NULL,
   [timestamp] [binary](8) NOT NULL,
   [UNIQUE_IDENT] [bigint] NOT NULL,
   [CLIENT_DB] [varchar](20) NOT NULL

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


GO