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

CREATE TABLE [import].[VEH_ORDER_HEADER] (
   [ORDER_NUMBER] [numeric](7,0) NOT NULL,
   [DEBIT_ACCOUNT] [varchar](10) NOT NULL,
   [STATUS] [char](2) NOT NULL,
   [STATE_KEY_DATE] [datetime] NOT NULL,
   [INVOICE_NUMBER] [numeric](7,0) NOT NULL,
   [DEPARTMENT] [char](4) NOT NULL,
   [STATE_DELIV_DATE] [datetime] NOT NULL,
   [STATE_CODE_VO] [char](1) NOT NULL,
   [TRANSACT_DATE] [datetime] NOT NULL,
   [HANDLER] [char](4) NOT NULL,
   [DELIVERY_ACCOUNT] [varchar](10) NOT NULL,
   [USER_UPDATE_VO] [char](1) NOT NULL,
   [SALESMAN] [varchar](20) NOT NULL,
   [DEBIT_PERM] [char](1) NOT NULL,
   [ORDER_DATE] [datetime] NOT NULL,
   [DELIVERY_DATE] [datetime] NOT NULL,
   [DELIVERY_PLACE] [varchar](20) NOT NULL,
   [INVOICE_DATE] [datetime] NOT NULL,
   [PMT_TERM] [char](2) NOT NULL,
   [NEXT_LINE_NUMBER] [numeric](4,0) NOT NULL,
   [PAYMENT_TEXT] [varchar](20) NOT NULL,
   [INVOICE_COPY_CODE] [char](1) NOT NULL,
   [TEXT_CODE_1] [char](2) NOT NULL,
   [TEXT_CODE_2] [char](2) NOT NULL,
   [TEXT_CODE_3] [char](2) 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,
   [FLEET_OWNER] [char](1) NOT NULL,
   [OPTION_SPECIFIC] [char](1) NOT NULL,
   [VEHICLE_LINES_VO] [numeric](3,0) NOT NULL,
   [ORDER_SUM_VO] [numeric](15,2) NOT NULL,
   [REQ_NO] [varchar](50) NOT NULL,
   [REFERENCE_NUMBER] [numeric](7,0) NOT NULL,
   [DUEDATE_1] [datetime] NOT NULL,
   [TITLE] [varchar](15) NOT NULL,
   [NAME] [varchar](100) NOT NULL,
   [STREET_ADDR] [varchar](60) NOT NULL,
   [ADDR_2] [varchar](60) NOT NULL,
   [ZIPCODE] [varchar](10) NOT NULL,
   [MAIL_ADDR] [varchar](60) NOT NULL,
   [ADDR_3] [varchar](60) NULL,
   [COUNTY] [varchar](60) NULL,
   [VEHICLE_SOLD] [varchar](10) NOT NULL,
   [VEHICLE_SOLD_SUM] [numeric](15,2) NOT NULL,
   [VEHICLE_PURCH] [varchar](10) NOT NULL,
   [VEHICLE_PURCH_SUM] [numeric](15,2) NOT NULL,
   [CHAIN_NUMBER] [numeric](7,0) NOT NULL,
   [SYSTEM_INV_PERM] [char](1) NOT NULL,
   [INTERNAL_CODE] [char](1) NOT NULL,
   [PREV_STATUS] [char](2) NOT NULL,
   [CREDIT_ORDER_VEH] [char](1) NOT NULL,
   [TAX_HANDLING] [char](1) NOT NULL,
   [TAX_PERC] [numeric](4,2) NOT NULL,
   [DELIVERY_WAY_CODE] [char](2) NOT NULL,
   [DELIVERY_TERM] [char](2) NOT NULL,
   [CUSTOMER_GROUP] [char](2) NOT NULL,
   [PRICE_CODE] [char](2) NOT NULL,
   [STOCK] [char](2) NOT NULL,
   [PLACE_CODE_2] [char](2) NOT NULL,
   [INVOICE_DISC_PERC] [numeric](5,2) NOT NULL,
   [ORDER_ARR_DATE_VO] [datetime] NOT NULL,
   [OFFER] [char](1) NOT NULL,
   [VEH_ORDER_TYPE] [char](1) NOT NULL,
   [MAIN_ORDER_NO] [numeric](7,0) NOT NULL,
   [SUB_ORDER_NO_1] [numeric](7,0) NOT NULL,
   [SUB_ORDER_NO_2] [numeric](7,0) NOT NULL,
   [SUB_ORDER_NO_3] [numeric](7,0) NOT NULL,
   [SUB_ORDER_NO_4] [numeric](7,0) NOT NULL,
   [SUB_ORDER_NO_5] [numeric](7,0) NOT NULL,
   [SUB_ORDER_NO_6] [numeric](7,0) NOT NULL,
   [SUB_ORDER_NO_7] [numeric](7,0) NOT NULL,
   [SUB_ORDER_NO_8] [numeric](7,0) NOT NULL,
   [SUB_ORDER_NO_9] [numeric](7,0) NOT NULL,
   [SUB_ORDER_NO_10] [numeric](7,0) NOT NULL,
   [TO_MICROFICHE] [char](1) NOT NULL,
   [LANGUAGE_CODE] [char](2) NOT NULL,
   [TAX_CODE_VO] [char](1) NULL,
   [INV_ROUNDING_VO] [numeric](15,2) NULL,
   [DEBT_NEW] [numeric](15,2) NULL,
   [CASH_AMOUNT] [numeric](15,2) NULL,
   [CNTRACT_DUE_DATE] [datetime] NULL,
   [CONTRACT_DATE] [datetime] NULL,
   [FAC_MODEL_CODE_L] [varchar](20) NULL,
   [CUSTOMER_SOLD] [char](1) NULL,
   [EXP_ARRIVAL_TIME] [char](6) NULL,
   [BOOK_NO] [char](3) NULL,
   [BOOK_NO_FLAG] [char](1) NULL,
   [REFERENCE_DATE] [datetime] NULL,
   [DEBET_DEPARTMENT] [char](4) NULL,
   [CUSTOMER_EAN_NUMBER] [numeric](14,0) NULL,
   [EAN_DEPARTMENT] [varchar](30) NULL,
   [EAN_REFERENCE] [varchar](30) NULL,
   [EAN_INTERNAL_ACCT] [varchar](30) NULL,
   [NWFAKT_MARKING] [numeric](1,0) NULL,
   [EXT_ORDER_NUMBER] [numeric](10,0) NULL,
   [DEAL_ID] [varchar](20) NULL,
   [PREORDER_ID] [varchar](10) NULL,
   [CONV_FLAG] [char](1) NULL,
   [timestamp] [binary](8) NOT NULL,
   [UNIQUE_IDENT] [numeric](12,0) NOT NULL,
   [E_INVOICE] [bit] NOT NULL,
   [ACTUAL_INV_DATE_TIME] [datetime] NULL,
   [INV_FORM_CODE] [char](4) NULL,
   [START_INTEREST_DATE] [datetime] NULL,
   [NOVA_CONTACT_ORDER] [bit] NULL,
   [REQ_REFERENCE] [varchar](30) NULL,
   [CONS_OCR] [varchar](30) NULL,
   [DEBIT_NO_CONS] [varchar](10) NULL,
   [CORRECTION_ORDER] [char](1) NULL,
   [DRIVER] [varchar](10) NULL,
   [OWNER_CODE] [varchar](10) NULL,
   [OWNER_CODE_2] [varchar](10) NULL,
   [ORIGINAL_INVOICE_NO] [numeric](7,0) NULL,
   [CLIENT_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [PK_VEH_ORDER_HEADERORDER_NUMBER] PRIMARY KEY CLUSTERED ([ORDER_NUMBER], [CLIENT_DB])
)


GO