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

CREATE TABLE [import].[UNIT_TRANSFER_TAB] (
   [DEPARTMENT] [char](4) NOT NULL,
   [BOOK_KEEPING_CODE] [varchar](10) NOT NULL,
   [TRANSFER_CODE] [char](2) NOT NULL,
   [INT_EXT_FLAG] [char](1) NOT NULL,
   [ACCT_NR_UNIT_CL_1] [varchar](10) NOT NULL,
   [ACCT_NR_UNIT_CL_2] [varchar](10) NOT NULL,
   [ACCT_NR_UNIT_CL_3] [varchar](10) NOT NULL,
   [ACCT_NR_UNIT_CL_4] [varchar](10) NOT NULL,
   [ACCT_NR_UNIT_CL_5] [varchar](10) NOT NULL,
   [ACCT_NR_UNIT_CL_6] [varchar](10) NOT NULL,
   [ACCT_NR_UNIT_CL_7] [varchar](10) NOT NULL,
   [ACCT_NR_UNIT_CL_8] [varchar](10) NOT NULL,
   [ACCT_NR_UNIT_CL_9] [varchar](10) NOT NULL,
   [TRANSFER_DEPT] [char](4) NOT NULL,
   [timestamp] [binary](8) NOT NULL,
   [UNIQUE_IDENT] [numeric](12,0) NOT NULL,
   [CONV_FLAG] [char](1) NULL,
   [SUSPENSE_ACCOUNT] [varchar](10) NULL,
   [CLIENT_DB] [varchar](20) NOT NULL
)


GO