ETL_DWH_ARI/schema/GC_CONFIG/tables/ari.AH_Standort.sql

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,
   [Erstellungsdatum] [datetime] NULL,
   [Gruppe_ID] [varchar](20) NULL,
   [Hauptbetrieb_ID] [varchar](20) NULL,
   [Standort_ID] [varchar](20) NULL,
   [Standort_Name] [varchar](50) NULL,
   [Department_No_2] [varchar](2) NULL,
   [Bestand] [tinyint] NULL

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


GO