CREATE TABLE [import].[UNIT_FILE] ( [UNIT_NUMBER] [varchar](10) NOT NULL, [BASIS_NUMBER] [varchar](20) NOT NULL, [ECC_STATUS] [char](2) NOT NULL, [VEHICLE_TYPE] [char](1) NOT NULL, [CATEGORY] [char](8) NOT NULL, [CHAIN_NUMBER] [numeric](7,0) NOT NULL, [STATE_CODE_UNIT] [varchar](20) NOT NULL, [TRANSACT_DATE] [datetime] NOT NULL, [HANDLER] [char](4) NOT NULL, [CAR_CREATION_DATE] [datetime] NOT NULL, [PMT_TERM] [char](2) NOT NULL, [INVOICE_COPY_CODE] [char](1) NOT NULL, [DELIVERY_WAY_CODE] [char](2) NOT NULL, [SMALL_ACCESSORIES] [char](1) NOT NULL, [SMALL_INV_CHARGE] [char](1) NOT NULL, [DELIVERY_STOP_CODE] [char](1) NOT NULL, [PRICE_CODE] [char](2) NOT NULL, [DISCOUNT_PERC_WORK] [numeric](5,2) NOT NULL, [DISCOUNT_LIMIT] [char](1) NOT NULL, [INTERNAL_CODE] [char](1) NOT NULL, [TAX_CODE] [char](1) NOT NULL, [UNIT_LAST_UPD_DTE] [datetime] NOT NULL, [DEPRECIATION] [numeric](15,2) NOT NULL, [TRANSFER_TAX] [numeric](15,2) NOT NULL, [BOOK_KEEPING_CODE] [varchar](12) NOT NULL, [TAX_HANDLING] [char](1) NOT NULL, [INTEREST_CODE] [char](1) NOT NULL, [MILEAGE] [numeric](6,0) NOT NULL, [PURCH_DEPARTMENT] [char](4) NOT NULL, [PURCH_SALSMAN_CODE] [varchar](20) NOT NULL, [PURCH_INVNO] [varchar](30) NOT NULL, [PURCH_DATE] [datetime] NOT NULL, [SALES_DEPARTMENT] [char](4) NOT NULL, [SALE_SALESMAN] [varchar](20) NOT NULL, [SALE_INV_NUMBER] [char](7) NOT NULL, [SALE_DATE] [datetime] NOT NULL, [SCRAP_CODE] [char](1) NOT NULL, [UNIT_IN_CHANGE] [varchar](10) NOT NULL, [BUD_SALE_DET] [numeric](15,2) NOT NULL, [BUD_PURCH_PRICE] [numeric](15,2) NOT NULL, [BUD_REG_FEE] [numeric](15,2) NOT NULL, [BUD_DEDUCT_FEE] [numeric](15,2) NOT NULL, [BUD_COST] [numeric](15,2) NOT NULL, [PREV_OWNER] [varchar](60) NOT NULL, [OWNER] [varchar](60) NOT NULL, [PURCH_PRICE_UNIT] [numeric](15,2) NOT NULL, [COST_UNIT] [numeric](15,2) NOT NULL, [SALES_PRICE_UNIT] [numeric](15,2) NOT NULL, [REG_FEE] [numeric](15,2) NOT NULL, [INTEREST_1] [numeric](15,2) NOT NULL, [INTEREST_2] [numeric](15,2) NOT NULL, [NEXT_LINE_UNIT] [numeric](4,0) NOT NULL, [NEXT_LINE_1] [numeric](4,0) NOT NULL, [TRANSFER_LINE] [numeric](4,0) NOT NULL, [TRANSFER_TAX_HAND] [char](1) NOT NULL, [TRANSFER_ACC_CODE] [varchar](10) NOT NULL, [TRANSFER_TAX_BASIS] [numeric](15,2) NOT NULL, [TRANSFER_TAX_PCT] [numeric](5,2) NOT NULL, [TRANSFER_SOLD] [char](1) NOT NULL, [PURCH_TAX] [numeric](15,2) NOT NULL, [COST_TAX] [numeric](15,2) NOT NULL, [OR_MARK] [char](1) NULL, [TRANSFER_DATE] [datetime] NOT NULL, [STOCK_DAYS] [char](4) NOT NULL, [DELETE_PROPOSAL] [char](1) NOT NULL, [TRANSFER_BBDB] [datetime] NOT NULL, [CONDITION_UNIT] [char](3) NOT NULL, [BUYING_ORDER_NO] [varchar](20) NOT NULL, [BUYING_ORDER_DATE] [datetime] NOT NULL, [PA_NUMBER] [varchar](10) NOT NULL, [VEHICLE_UPDATE] [char](1) NOT NULL, [LATEST_UPDATE] [datetime] NOT NULL, [INVOICE_PERMISSION] [char](1) NOT NULL, [LOCATION_CODE] [varchar](20) NOT NULL, [ACCOUNT_PURCHASE] [varchar](10) NOT NULL, [ACCOUNT_SALES] [varchar](10) NOT NULL, [BUDG_PRICE_VAT] [char](1) NOT NULL, [RECALC_CODE] [char](1) NOT NULL, [COMMISION_NO] [varchar](10) NOT NULL, [DELIVERY_DATE_VEH] [datetime] NOT NULL, [RESERVATION_DATE] [datetime] NOT NULL, [RESERVATION_PERSON] [varchar](20) NOT NULL, [RESERVATION_TEXT] [varchar](50) NOT NULL, [FREIGHT_BALANCE] [numeric](15,2) NOT NULL, [TRF_TAXBASIS_SALES] [numeric](15,2) NOT NULL, [TRF_TAXBASIS_PURCH] [numeric](15,2) NOT NULL, [SALE_ORDER_NO] [char](7) NOT NULL, [UNIT_SOLD] [varchar](10) NOT NULL, [TRF_DEPARTMENT] [char](4) NOT NULL, [ORDER_ARRIVAL_DATE] [datetime] NOT NULL, [ORDER_CONFIRM_DATE] [datetime] NOT NULL, [PRICE_LABEL_DATE] [datetime] NOT NULL, [VAT_TABLE_WORK] [char](1) NOT NULL, [VAT_TABLE_NORMAL] [char](1) NOT NULL, [VAT_RATE_CODE] [char](2) NOT NULL, [TRANSFER_VAT_RC] [char](2) NOT NULL, [CNTRACT_DUE_DATE] [datetime] NULL, [CONTRACT_DATE] [datetime] NULL, [EXP_ARRIVAL_TIME] [char](6) NULL, [DEALER_MARKING] [char](2) NULL, [BOOKING_DEALER_NR] [varchar](10) NULL, [DESIRED_DELIV_DATE] [datetime] NULL, [VALUATION_DATE] [datetime] NULL, [NOVA_CALC_FLAG] [char](1) NULL, [NOVA_CALC_BASE] [char](1) NULL, [NOVA_PERCENT] [numeric](5,2) NULL, [NOVA_AMOUNT] [numeric](15,2) NULL, [NOVA_EXCEPT_CODE] [char](2) NULL, [NOVA_EXCEPT_TEXT] [varchar](50) NULL, [PID_TYPE] [varchar](15) NULL, [PID_NUMBER] [varchar](15) NULL, [PID_ISSUE_DATE] [datetime] NULL, [PID_ISSUE_AUTH] [varchar](15) NULL, [EXP_DESTINATION] [char](1) NULL, [ARGUS_PURCH_PRICE] [numeric](15,2) NULL, [ARGUS_SALES_PRICE] [numeric](15,2) NULL, [TRANSFER_BOOK_NO] [char](3) NULL, [SUB_DEALER_ID] [varchar](15) NULL, [CUST_COMPANY_NO] [char](8) NULL, [IQ_USED_VEHICLE] [char](1) NULL, [STOCK_VALUE_BPM] [numeric](15,2) NULL, [FORD_SUBTOTAL] [numeric](15,2) NULL, [FORD_INT_DATE] [datetime] NULL, [EST_SALES_PRICE] [numeric](15,2) NULL, [EST_REFERENCE_NO] [varchar](50) NULL, [OPT_VALID_DATE] [datetime] NULL, [WASTE_DISPOSAL_FEE] [numeric](15,2) NULL, [POLICE_REG_NUMBER] [numeric](10,0) NULL, [RECEPTION_DATE] [datetime] NULL, [BUD_OPT_PRICE] [numeric](15,2) NULL, [NOVA_AMOUNT_NEW] [numeric](15,2) NULL, [SALE_PRICE_DATE] [datetime] NULL, [VARIATION_PCT] [numeric](5,2) NULL, [POSTPONE_BOOKKEEPING] [char](1) NULL, [USED_VEH_DEST_CODE] [char](1) NULL, [PURCH_ORIGIN_CODE] [char](2) NULL, [PRICE_LIST_VERSION] [char](3) NULL, [PRICE_LIST_DATE] [datetime] NULL, [NOVA_MERIT_AMOUNT] [numeric](15,2) NULL, [TRANSFER_MARKETPLACE] [bit] NOT NULL, [PRICE_VALUE_HOUSE] [numeric](15,2) NULL, [PRICE_VALUE_INTERNET] [numeric](15,2) NULL, [LOWEST_SALESPRICE] [numeric](15,2) NULL, [SALES_PROGRAM] [varchar](30) NULL, [DRIVER_DEMO] [varchar](30) NULL, [DEALER_PRICE] [numeric](15,2) NULL, [NOVA_LEASING] [char](1) NULL, [EXPORT_PRICE] [numeric](15,2) NULL, [CONV_FLAG] [char](1) NULL, [timestamp] [binary](8) NOT NULL, [UNIQUE_IDENT] [numeric](12,0) NOT NULL, [AD_SALES_WAY] [char](2) NULL, [CLIENT_DB] [varchar](20) NOT NULL ,CONSTRAINT [PK_UNIT_FILEUNIT_NUMBER] PRIMARY KEY CLUSTERED ([UNIT_NUMBER], [CLIENT_DB]) ) GO