CREATE TABLE [ari].[AH_Standort] (
   [Client_DB] [varchar](20) NOT NULL,
   [Branch Code] [varchar](20) NOT NULL,
   [Branch ID] [varchar](10) NULL,
   [Description] [varchar](50) NULL,
   [Gruppe_ID] [varchar](20) NULL,
   [Hauptbetrieb_ID] [varchar](20) NULL,
   [Standort_ID] [varchar](20) NULL,
   [Standort_Name] [varchar](50) NULL

   ,CONSTRAINT [PK_AH_Standort] PRIMARY KEY CLUSTERED ([Client_DB], [Branch Code])
)


GO