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

CREATE TABLE [import].[VEH_IN_TRANSIT] (
   [CHASSIS_NUMBER] [varchar](18) NOT NULL,
   [UNIT_NUMBER] [varchar](10) NOT NULL,
   [BASIS_NUMBER] [varchar](10) NOT NULL,
   [ORDER_NUMBER] [numeric](7,0) NOT NULL,
   [HANDLER] [char](4) NOT NULL,
   [PROGRAM] [char](6) NOT NULL,
   [FUNCTION_CODE] [char](4) NOT NULL,
   [CREATION_DATE] [datetime] NOT NULL,
   [TRANSACTION_DATE] [datetime] NOT NULL,
   [STATUS_CODE] [char](1) NOT NULL,
   [SUPPLIER_CODE] [varchar](10) NOT NULL,
   [INVOICE_DATE] [datetime] NOT NULL,
   [INVOICE_NUMBER] [numeric](7,0) NOT NULL,
   [ORDER_SUM] [numeric](15,2) NOT NULL,
   [VAT_AMOUNT] [numeric](15,2) NOT NULL,
   [COMMENT_1] [varchar](30) NOT NULL,
   [COMMENT_2] [varchar](30) NOT NULL,
   [CURRENCY_CODE] [char](3) NOT NULL,
   [VEHICLE_ON_STOCK] [char](1) NOT NULL,
   [APPROVED] [char](1) NOT NULL,
   [BOOKKEEP_DATE] [datetime] NOT NULL,
   [ADP_EX_VEH_ID] [numeric](10,0) NOT NULL,
   [STATUS] [bit] NOT NULL,
   [DELETE_MARKED] [char](1) NULL,
   [PRICE_LIST_VERSION] [char](3) NULL,
   [EXTERNAL_SYSTEM] [numeric](2,0) 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