| 123456789101112131415161718192021222324252627282930313233343536373839404142434445 |
- SET QUOTED_IDENTIFIER ON
- GO
- SET ANSI_NULLS ON
- GO
- CREATE VIEW [dbo].[TFM_vfMonteurRechnungsausgangsbuch]
- AS
- /* Hier findet das Mapping der Spalten zwischen DWH und Transformer statt, der historisch bedingt ist. */
- SELECT [Mandant ID] AS [Mandant ID]
- --,[Faktenart_ID] AS [Faktenart_ID]
- --,[Faktenart_Name] AS [Faktenart_Name]
- ,[Vorgangsnummer] AS [Vorgangsnummer]
- ,[Invoice Date] AS [Invoice Date]
- ,[Datum] AS [Datum]
- ,[RechArt] AS [RechArt]
- ,[SplitNr] AS [SplitNr]
- ,[Order Number] AS [Order Number]
- ,[Filial_ID] AS [Filial_ID]
- ,[MonteurID1] AS [MonteurID1]
- ,[MonteurID2] AS [MonteurID2]
- ,[MonteurID3] AS [MonteurID3]
- ,[MonteurID4] AS [MonteurID4]
- ,[MonteurID5] AS [MonteurID5]
- ,[Monteurnr] AS [Monteurnr]
- ,[Monteurnr_Fil] AS [Monteurnr_Fil]
- ,[Positionskennzeichen] AS [Positionskennzeichen]
- ,[Positionsnummer] AS [Positionsnummer]
- ,[RE_Prozent] AS [RE_Prozent]
- ,[Mengemonteurid1] AS [Mengemonteurid1]
- ,[Mengemonteurid2] AS [Mengemonteurid2]
- ,[Mengemonteurid3] AS [Mengemonteurid3]
- ,[Mengemonteurid4] AS [Mengemonteurid4]
- ,[Mengemonteurid5] AS [Mengemonteurid5]
- ,[verr. Zeit] AS [verr. Zeit]
- FROM [ZdbSNCStaging].[WERWISO].[fMonteurRechnungsausgangsbuch]
- GO
- SET QUOTED_IDENTIFIER OFF
- GO
- SET ANSI_NULLS OFF
- GO
- GO
|
