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