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

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