CREATE TABLE [import].[VEHICLE_DOCKETCARD] (
   [CHASSIS_NUMBER] [varchar](20) NOT NULL,
   [STATUS_CODE] [char](1) NOT NULL,
   [DATE_DOC_STATUS] [datetime] NOT NULL,
   [FIRST_REG_NO] [varchar](11) NOT NULL,
   [UNIT_NUMBER] [varchar](20) NOT NULL,
   [SATZART] [char](3) NOT NULL,
   [STEERING_FIELD] [char](1) NOT NULL,
   [NSC_ORDER_NUMBER] [char](4) NULL,
   [DEALER_NUMBER_DOC] [char](5) NOT NULL,
   [AOD_SUB_DEALER] [char](5) NOT NULL,
   [SALES_DATE] [datetime] NOT NULL,
   [DELIVERY_DATE_VEHI] [datetime] NOT NULL,
   [FIRST_REG_DATE] [datetime] NOT NULL,
   [MACHINE_TIME] [char](4) NOT NULL,
   [DEALER_ORDER_FORD] [char](4) NULL,
   [SALESMAN] [char](5) NOT NULL,
   [USED_CAR_KEY] [char](7) NOT NULL,
   [MAILSTOP_FORD] [char](1) NULL,
   [LINE_OF_BUSINESS_K] [char](3) NOT NULL,
   [LEASING_NUMBER] [char](6) NOT NULL,
   [CARD_NUMBER] [char](7) NOT NULL,
   [DISCOUNT_DOCKED] [numeric](4,0) NOT NULL,
   [LEASING_G_P] [char](1) NOT NULL,
   [LEASING_RECIEPIENT] [char](6) NOT NULL,
   [LEASING_CARD_NUMB] [char](7) NOT NULL,
   [ECS_VEHICLE] [char](1) NOT NULL,
   [CATEGORY_DOCKED] [char](1) NOT NULL,
   [TITLE_CODE_DOCKED] [char](1) NOT NULL,
   [TITLE_DOCKED] [varchar](60) NOT NULL,
   [FIRST_NAME_DOCKED] [varchar](60) NOT NULL,
   [NAME_DOCKED] [varchar](60) NOT NULL,
   [COUNTRY_CODE] [char](5) NOT NULL,
   [POSTAL_CODE] [char](5) NOT NULL,
   [TOWN_DOCKED] [varchar](60) NOT NULL,
   [STREET_DOCKED] [varchar](60) NOT NULL,
   [STREET_NUMBER_DOC] [char](4) NOT NULL,
   [PHONE] [varchar](50) NULL,
   [SERVICE_DEALER] [char](5) NOT NULL,
   [AOS_DEAL_NUMBER] [char](4) NULL,
   [USER_NAME] [varchar](60) NULL,
   [USER_STREET] [varchar](60) NULL,
   [USER_ZIPCODE] [varchar](10) NULL,
   [USER_PHONE] [varchar](20) NULL,
   [COMPANY_NAME] [varchar](30) NULL,
   [COMPANY_ADDRESS] [varchar](30) NULL,
   [COMPANY_ZIPCODE] [varchar](10) NULL,
   [COMPANY_PHONE] [varchar](20) NULL,
   [OKB_VEHICLE] [char](1) NOT NULL,
   [BANK_DEPARTMENT] [char](1) NOT NULL,
   [EXTENSION_CODE] [char](1) NOT NULL,
   [RESERVED_1] [char](5) NOT NULL,
   [RESERVED_2] [char](5) NOT NULL,
   [RESERVED_3] [char](3) NOT NULL,
   [RESERVED_4] [char](2) NOT NULL,
   [RESERVED_5] [char](2) NOT NULL,
   [ERROR_TYPE_1] [numeric](2,0) NOT NULL,
   [ITEM_NO_1] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_2] [numeric](2,0) NOT NULL,
   [ITEM_NO_2] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_3] [numeric](2,0) NOT NULL,
   [ITEM_NO_3] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_4] [numeric](2,0) NOT NULL,
   [ITEM_NO_4] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_5] [numeric](2,0) NOT NULL,
   [ITEM_NO_5] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_6] [numeric](2,0) NOT NULL,
   [ITEM_NO_6] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_7] [numeric](2,0) NOT NULL,
   [ITEM_NO_7] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_8] [numeric](2,0) NOT NULL,
   [ITEM_NO_8] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_9] [numeric](2,0) NOT NULL,
   [ITEM_NO_9] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_10] [numeric](2,0) NOT NULL,
   [ITEM_NO_10] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_11] [numeric](2,0) NOT NULL,
   [ITEM_NO_11] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_12] [numeric](2,0) NOT NULL,
   [ITEM_NO_12] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_13] [numeric](2,0) NOT NULL,
   [ITEM_NO_13] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_14] [numeric](2,0) NOT NULL,
   [ITEM_NO_14] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_15] [numeric](2,0) NOT NULL,
   [ITEM_NO_15] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_16] [numeric](2,0) NOT NULL,
   [ITEM_NO_16] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_17] [numeric](2,0) NOT NULL,
   [ITEM_NO_17] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_18] [numeric](2,0) NOT NULL,
   [ITEM_NO_18] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_19] [numeric](2,0) NOT NULL,
   [ITEM_NO_19] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_20] [numeric](2,0) NOT NULL,
   [ITEM_NO_20] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_21] [numeric](2,0) NOT NULL,
   [ITEM_NO_21] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_22] [numeric](2,0) NOT NULL,
   [ITEM_NO_22] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_23] [numeric](2,0) NOT NULL,
   [ITEM_NO_23] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_24] [numeric](2,0) NOT NULL,
   [ITEM_NO_24] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_25] [numeric](2,0) NOT NULL,
   [ITEM_NO_25] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_26] [numeric](2,0) NOT NULL,
   [ITEM_NO_26] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_27] [numeric](2,0) NOT NULL,
   [ITEM_NO_27] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_28] [numeric](2,0) NOT NULL,
   [ITEM_NO_28] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_29] [numeric](2,0) NOT NULL,
   [ITEM_NO_29] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_30] [numeric](2,0) NOT NULL,
   [ITEM_NO_30] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_31] [numeric](2,0) NOT NULL,
   [ITEM_NO_31] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_32] [numeric](2,0) NOT NULL,
   [ITEM_NO_32] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_33] [numeric](2,0) NOT NULL,
   [ITEM_NO_33] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_34] [numeric](2,0) NOT NULL,
   [ITEM_NO_34] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_35] [numeric](2,0) NOT NULL,
   [ITEM_NO_35] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_36] [numeric](2,0) NOT NULL,
   [ITEM_NO_36] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_37] [numeric](2,0) NOT NULL,
   [ITEM_NO_37] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_38] [numeric](2,0) NOT NULL,
   [ITEM_NO_38] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_39] [numeric](2,0) NOT NULL,
   [ITEM_NO_39] [numeric](2,0) NOT NULL,
   [ERROR_TYPE_40] [numeric](2,0) NOT NULL,
   [ITEM_NO_40] [numeric](2,0) NOT 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
