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

CREATE TABLE [import].[VEH_ORDER_LINE] (
   [ORDER_NUMBER] [numeric](7,0) NOT NULL,
   [LINE_NUMBER] [numeric](4,0) NOT NULL,
   [UNIT_NUMBER] [varchar](10) NOT NULL,
   [TRANSACT_DATE] [datetime] NOT NULL,
   [HANDLER] [char](4) NOT NULL,
   [STATE_CODE] [char](1) NOT NULL,
   [PERSON_CODE] [char](4) NOT NULL,
   [PROGRAM] [char](6) NOT NULL,
   [FUNCTION_CODE] [char](4) NOT NULL,
   [VEHICLE_TYPE_VO] [char](1) NOT NULL,
   [LAYOUT_TYPE] [char](1) NOT NULL,
   [REGISTER_NUMBER] [varchar](20) NOT NULL,
   [CHASSIS_NUMBER] [varchar](20) NOT NULL,
   [DELIVERY_DATE] [datetime] NOT NULL,
   [TEXT_CODE_1] [char](2) NOT NULL,
   [TEXT_CODE_2] [char](2) NOT NULL,
   [TEXT_CODE_3] [char](2) NOT NULL,
   [PROMISSED_PRICE] [numeric](15,2) NOT NULL,
   [VEHICLE_SUM_OLD] [numeric](15,2) NOT NULL,
   [VEHICLE_SUM_NEW] [numeric](15,2) NOT NULL,
   [OPTION_LINES] [numeric](3,0) NOT NULL,
   [VAT_HANDLING] [char](1) NOT NULL,
   [TEXT1_1_VO] [varchar](50) NOT NULL,
   [TEXT1_2_VO] [varchar](50) NOT NULL,
   [TEXT_FL1_VO] [char](1) NOT NULL,
   [TEXT2_1_VO] [varchar](50) NOT NULL,
   [TEXT2_2_VO] [varchar](50) NOT NULL,
   [TEXT_FL2_VO] [char](1) NOT NULL,
   [TEXT3_1_VO] [varchar](50) NOT NULL,
   [TEXT3_2_VO] [varchar](50) NOT NULL,
   [TEXT_FL3_VO] [char](1) NOT NULL,
   [TEXT4_1_VO] [varchar](50) NOT NULL,
   [TEXT4_2_VO] [varchar](50) NOT NULL,
   [TEXT_FL4_VO] [char](1) NOT NULL,
   [LINE_TYPE_VEH] [char](1) NOT NULL,
   [UPDATE_VO] [char](1) NOT NULL,
   [SALE_VO] [char](1) NOT NULL,
   [PRINT_LAYOUT] [char](1) NOT NULL,
   [MILEAGE] [numeric](6,0) NOT NULL,
   [SALEREF] [varchar](10) NOT NULL,
   [VAT_RATE_CODE] [char](2) NOT NULL,
   [DISC_CODE_1] [char](1) NOT NULL,
   [DISC_PCT_1] [numeric](5,2) NOT NULL,
   [DISC_PCT_2] [numeric](5,2) NOT NULL,
   [DISC_AMOUNT_1] [numeric](15,2) NOT NULL,
   [DISC_AMOUNT_2] [numeric](15,2) NOT NULL,
   [NOVA_CALC_FLAG] [char](1) NULL,
   [NOVA_AMOUNT] [numeric](15,2) NULL,
   [NOVA_EXCEPT_CODE] [char](2) NULL,
   [NOVA_EXCEPT_TEXT] [varchar](50) NULL,
   [ACCOUNTING_CODE] [varchar](10) NULL,
   [CREATE_MSC] [char](1) NULL,
   [BOOK_NO] [char](3) NULL,
   [CONTRACT_NUMBER] [varchar](10) NULL,
   [CONV_FLAG] [char](1) NULL,
   [timestamp] [binary](8) NOT NULL,
   [UNIQUE_IDENT] [numeric](12,0) NOT NULL,
   [CLIENT_DB] [varchar](20) NOT NULL
)


GO