CREATE TABLE [import].[VEH_ORDER_OPTION] (
   [ORDER_NUMBER] [numeric](7,0) NOT NULL,
   [UNIT_NUMBER] [varchar](10) NOT NULL,
   [LINE_TYPE_SPEC] [char](1) NOT NULL,
   [LINE_NO_VO] [numeric](3,0) NOT NULL,
   [OPTION_TYPE] [char](1) NOT NULL,
   [OPTION_CODE_PF] [varchar](20) NOT NULL,
   [HANDLER] [char](4) NOT NULL,
   [CREATION_DATE] [datetime] NOT NULL,
   [OPTION_TEXT_1] [varchar](50) NOT NULL,
   [OPTION_TEXT_2] [varchar](50) NOT NULL,
   [OPTION_TEXT_3] [varchar](50) NOT NULL,
   [OPTION_TEXT_4] [varchar](50) NOT NULL,
   [OPTION_UPDATE] [char](1) NOT NULL,
   [PRINT_OPTION] [char](1) NOT NULL,
   [LIST_PRICE] [numeric](15,2) NOT NULL,
   [REAL_PRICE] [numeric](15,2) NOT NULL,
   [PURCHASE_PRICE] [numeric](15,2) NOT NULL,
   [VAT_CODE] [char](2) NOT NULL,
   [TRANSACTION_CODE] [char](3) NOT NULL,
   [REG_CODE] [char](2) NOT NULL,
   [DEDUCT_CODE] [char](2) NOT NULL,
   [DISCOUNT_PERC_VEH] [numeric](5,2) NOT NULL,
   [LIST_PRICE_DATE] [datetime] NOT NULL,
   [PURCH_PRICE_DATE] [datetime] NOT NULL,
   [PACKAGE_VEH] [char](1) NOT NULL,
   [CONNECT_PACK_NO] [char](5) NOT NULL,
   [TAX_PERC] [numeric](4,2) NOT NULL,
   [ACCT_NR] [varchar](10) NOT NULL,
   [LINE_NO_OLD_VO] [numeric](3,0) NOT NULL,
   [PRINT_TEXT_VO] [char](1) NOT NULL,
   [PRINT_PRICE_VO] [char](1) NOT NULL,
   [VAT_PRINT_CHARS] [char](2) NOT NULL,
   [PAYER_NO] [varchar](10) NOT NULL,
   [SUB_ORDER_NO] [numeric](7,0) NOT NULL,
   [WUST_CODE] [char](1) NOT NULL,
   [ACCOUNT_TYPE] [char](1) NOT NULL,
   [BOOKKEEP_ACCT] [varchar](10) NOT NULL,
   [BOOKKEEP_DEPT] [char](4) NOT NULL,
   [REMAIN_DEBT] [char](1) NOT NULL,
   [REQUISITION] [varchar](10) NULL,
   [BPM_AMOUNT] [numeric](15,2) NULL,
   [REFERENCE_IDENT] [numeric](12,0) NULL,
   [ACCT_SCHEDULE_ID] [varchar](10) NULL,
   [DEPOSIT_PRINTED] [char](1) NULL,
   [QUANTITY] [numeric](15,2) NULL,
   [PRICE] [numeric](15,2) NULL,
   [DISCOUNT_PERCENTAGE] [numeric](8,2) NULL,
   [DISCOUNT_AMOUNT] [numeric](15,2) NULL,
   [CONV_FLAG] [char](1) NULL,
   [timestamp] [binary](8) NOT NULL,
   [UNIQUE_IDENT] [numeric](12,0) NOT NULL,
   [PMT_LINE_TYPE] [char](1) NULL,
   [CLIENT_DB] [varchar](20) NOT NULL

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


GO
