SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE VIEW [dbo].[TFM_vdPLZ]

AS

/* Hier findet das Mapping der Spalten zwischen DWH und Transformer statt, der historisch bedingt ist. */

SELECT [Mandant ID]
      ,[PLZ]					AS [PLZ]			
      --,[Ort]					AS [Ort]			
      ,[PLZ Ort]				AS [PLZ Ort]		
      ,[PLZ 1-stellig]			AS [PLZ 1-stellig]
      ,[PLZ 2-stellig]			AS [PLZ 2-stellig]
      ,[PLZ 3-stellig]			AS [PLZ 3-stellig]
      ,[PLZ 4-stellig]			AS [PLZ 4-stellig]
  FROM [dPLZ]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO
