C11/System/LOCOSOFT/SQL/schema/LOCOSOFT/views/load.loc_belege_bilanz.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
/****** Skript für SelectTopNRows-Befehl aus SSMS ******/
CREATE VIEW [load].[loc_belege_bilanz]
AS
SELECT [Rechtseinheit_ID],
	[Rechtseinheit_Name],
	[Betrieb_ID],
	[Betrieb_Name],
	[Ebene1],
	[Ebene2],
	[Ebene3],
	[Ebene4],
	[Ebene5],
	[Ebene6],
	[Konto],
	[Acct_Nr],
	[Text],
	[Kostenstelle],
	[KST_mit_Bez],
	[KST],
	[Markencode],
	[Fahrgestellnummer],
	[Konto_Buchung],
	[Marke_mit_Bez],
	[Marke],
	[Ebene21],
	[Absatzkanal_mit_Bez],
	[Absatzkanal],
	[Ebene31],
	[Kostenträger_mit_Bez],
	[Kostenträger_FIBU],
	[Ebene71],
	[Ebene72],
	[Ebene73],
	[Ebene74],
	[Ebene75],
	[Ebene76],
	[Ebene77],
	[Ebene81],
	[Ebene82],
	[Ebene83],
	[Ebene84],
	[Ebene85],
	[Ebene86],
	[GuV_Bilanz],
	[Susa],
	[Mandant],
	[Ist],
	[Menge],
	[Gruppe_ID],
	[Gruppe_Name],
	[Invoice_Date],
	[Fabrikat],
	[Fabrikat_Order_By]
FROM [LOCOSOFT].[staging].[loc_belege_bilanz_0]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO