optima.Transaction_Code.sql 406 B

1234567891011121314
  1. CREATE TABLE [optima].[Transaction_Code] (
  2. [CLIENT_DB] [varchar](20) NOT NULL,
  3. [TRANSACTION_CODE] [varchar](12) NOT NULL,
  4. [SPECIFY] [varchar](50) NULL,
  5. [TRANSFER_CODE] [varchar](2) NULL,
  6. [Umsatz_Einsatz] [varchar](7) NULL,
  7. [Kennzahl] [varchar](13) NULL,
  8. [Kennzahl2] [varchar](9) NULL
  9. ,CONSTRAINT [PK_Transaction_Code] PRIMARY KEY CLUSTERED ([CLIENT_DB], [TRANSACTION_CODE])
  10. )
  11. GO