ETL_DWH_LOCOSOFT/schema/GC_ETL_LOCOSOFT/views/load.Umsatz_Belege_SKR.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE view load.Umsatz_Belege_SKR AS
select convert(varchar(10), Rechtseinheit_ID)      AS Rechtseinheit_ID,
       convert(varchar(50), Rechtseinheit_Name)    AS Rechtseinheit_Name,
       convert(varchar(10), Betrieb_ID)            AS Betrieb_ID,
       convert(varchar(50), Betrieb_Name)          AS Betrieb_Name,
       convert(varchar(255), Ebene1_)              AS Ebene1_,
       convert(varchar(255), Ebene2_)              AS Ebene2_,
       convert(varchar(255), Ebene3_)              AS Ebene3_,
       convert(varchar(255), Ebene4_)              AS Ebene4_,
       convert(varchar(255), Ebene5_)              AS Ebene5_,
       convert(varchar(255), Ebene6_)              AS Ebene6_,
       convert(varchar(300), Konto_)               AS Konto_,
       convert(varchar(150), Acct_Nr_)             AS Acct_Nr_,
       convert(varchar(350), Text)                 AS Text,
       convert(varchar(20), Kostenstelle)          AS Kostenstelle,
       convert(varchar(200), KST_mit_Bez)          AS KST_mit_Bez,
       convert(varchar(20), KST)                   AS KST,
       convert(varchar(50), Markencode)            AS Markencode,
       convert(varchar(100), Fahrgestellnummer)    AS Fahrgestellnummer,
       convert(varchar(300), Konto_Buchung)        AS Konto_Buchung,
       convert(varchar(200), Marke_mit_Bez)        AS Marke_mit_Bez,
       convert(varchar(100), Marke)                AS Marke,
       convert(varchar(100), Ebene21)              AS Ebene21,
       convert(varchar(200), Absatzkanal_mit_Bez)  AS Absatzkanal_mit_Bez,
       convert(varchar(10), Absatzkanal)           AS Absatzkanal,
       convert(varchar(20), Ebene31)               AS Ebene31,
       convert(varchar(250), Kostenträger_mit_Bez) AS Kostenträger_mit_Bez,
       convert(int, Kostenträger_FIBU)             AS Kostenträger_FIBU,
       convert(varchar(255), Ebene71)              AS Ebene71,
       convert(varchar(255), Ebene72)              AS Ebene72,
       convert(varchar(255), Ebene73)              AS Ebene73,
       convert(varchar(255), Ebene74)              AS Ebene74,
       convert(varchar(255), Ebene75)              AS Ebene75,
       convert(varchar(255), Ebene76)              AS Ebene76,
       convert(varchar(255), Ebene77)              AS Ebene77,
       convert(varchar(255), Ebene81)              AS Ebene81,
       convert(varchar(255), Ebene82)              AS Ebene82,
       convert(varchar(255), Ebene83)              AS Ebene83,
       convert(varchar(255), Ebene84)              AS Ebene84,
       convert(varchar(255), Ebene85)              AS Ebene85,
       convert(varchar(255), Ebene86)              AS Ebene86,
       convert(varchar(255), GuV_Bilanz)           AS GuV_Bilanz,
       convert(varchar(255), Susa)                 AS Susa,
       convert(varchar(50), Mandant)               AS Mandant,
       convert(decimal(28, 8), Ist_)               AS Ist_,
       convert(decimal(28, 8), Menge_)             AS Menge_,
       convert(varchar(10), Gruppe_ID)             AS Gruppe_ID,
       convert(varchar(50), Gruppe_Name)           AS Gruppe_Name,
       convert(datetime, Invoice_Date)             AS Invoice_Date,
       convert(varchar(100), Fabrikat)             AS Fabrikat,
       convert(int, Fabrikat_Order_By)             AS Fabrikat_Order_By,
       convert(decimal(28, 8), Umsatz_FIBU_gesamt) AS Umsatz_FIBU_gesamt
from transform.Umsatz_Belege_SKR
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO