CREATE TABLE [data].[GC_Auftragsart] (
   [Client_DB] [varchar](20) NOT NULL,
   [State_Code] [varchar](20) NOT NULL,
   [State_Specify] [varchar](50) NOT NULL,
   [Auftagsart] [varchar](20) NULL,
   [Auftragsstatus] [varchar](20) NULL,
   [Status_Filter] [int] NOT NULL,
   [Rechnung_Gutschrift] [varchar](20) NOT NULL

   ,CONSTRAINT [PK_GC_Auftragsart] PRIMARY KEY CLUSTERED ([Client_DB], [State_Code])
)


GO