ari.AH_Standort.sql 468 B

12345678910111213141516
  1. CREATE TABLE [ari].[AH_Standort] (
  2. [Client_DB] [varchar](20) NOT NULL,
  3. [Branch Code] [varchar](20) NOT NULL,
  4. [Branch ID] [varchar](10) NULL,
  5. [Description] [varchar](50) NULL,
  6. [Erstellungsdatum] [datetime] NULL,
  7. [Gruppe_ID] [varchar](20) NULL,
  8. [Hauptbetrieb_ID] [varchar](20) NULL,
  9. [Standort_ID] [varchar](20) NULL,
  10. [Standort_Name] [varchar](50) NULL
  11. ,CONSTRAINT [PK_AH_Standort] PRIMARY KEY CLUSTERED ([Client_DB], [Branch Code])
  12. )
  13. GO