CREATE TABLE [optima].[Transaction_Code] (
   [CLIENT_DB] [varchar](20) NOT NULL,
   [TRANSACTION_CODE] [varchar](12) NOT NULL,
   [SPECIFY] [varchar](50) NULL,
   [TRANSFER_CODE] [varchar](2) NULL,
   [Umsatz_Einsatz] [varchar](7) NULL,
   [Kennzahl] [varchar](13) NULL,
   [Kennzahl2] [varchar](9) NULL

   ,CONSTRAINT [PK_Transaction_Code] PRIMARY KEY CLUSTERED ([CLIENT_DB], [TRANSACTION_CODE])
)


GO