C11/System/OPTIMA/SQL/schema/OPTIMA2/tables/import.UNIT_CLASSIFICAT.sql

CREATE TABLE [import].[UNIT_CLASSIFICAT] (
   [UNIT_NUMBER] [char](10) NOT NULL,
   [BATCH_NUMBER_S] [numeric](7,0) NOT NULL,
   [ACCTNG_PERIOD] [char](6) NOT NULL,
   [LINE_NO] [numeric](4,0) NOT NULL,
   [ACCT_NR] [char](10) NOT NULL,
   [DEPARTMENT] [char](4) NOT NULL,
   [BOOK_KEEPING_CODE] [char](10) NOT NULL,
   [TRANSFER_CODE] [char](2) NOT NULL,
   [TRANSACTION_DATE] [datetime] NOT NULL,
   [TRANSACTION_CODE] [char](3) NOT NULL,
   [TRANSACTION_AMOUNT] [numeric](15,2) NOT NULL,
   [DOCUMENT_NR] [numeric](15,0) NOT NULL,
   [TRANSFER_DIFFTAX] [char](1) NOT NULL,
   [TRF_TAXBASIS_SALES] [numeric](15,2) NOT NULL,
   [TRF_TAXBASIS_PURCH] [numeric](15,2) NOT NULL,
   [BOOK_NO] [char](3) NULL,
   [PURCH_INVNO] [varchar](30) NULL,
   [ORIGINAL_BATCH_NO] [numeric](7,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

   ,CONSTRAINT [PK_UNIT_NUMBER] PRIMARY KEY CLUSTERED ([UNIT_NUMBER], [BATCH_NUMBER_S], [ACCTNG_PERIOD], [LINE_NO], [CLIENT_DB])
)


GO