gctools/cognos7/data/mdl/Fin_Belege_SKR_queries.sql

CREATE
	OR

ALTER VIEW [load].[current_date_Prognose]
AS
SELECT --Bundeslaender Id AS "Bundeslaender Id",
	Datum AS "Bookkeep Date",
	--Wochentage Id AS "Wochentage Id",
	Arbeitstag Mofr AS "Arbeitstag Mofr",
	Zaehler Mofr AS "Zaehler Mofr",
	Summe Mofr AS "Summe Mofr",
	--Arbeitstag Mosa AS "Arbeitstag Mosa",
	--Zaehler Mosa AS "Zaehler Mosa",
	--Summe Mosa AS "Summe Mosa",
	--Feiertage Id AS "Feiertage Id",
	--Jahr AS "Jahr",
	Arbeitstag Nr Jahr AS "Arbeitstag Nr Jahr",
	Gesamt Arbeitstage AS "Gesamt Arbeitstage" 
FROM [export_csv].[current_date_Prognose]
GO

CREATE
	OR

ALTER VIEW [load].[Kontenrahmen_GC_Struct_SKR]
AS
SELECT --Konto Nr AS "Konto Nr",
	--Konto Bezeichnung AS "Konto Bezeichnung",
	--Konto Art_ori AS "Konto Art_ori",
	Kostenstelle AS "Kostenstelle",
	--Stk AS "Stk",
	--Konto 1 AS "Konto 1",
	--Konto 2 AS "Konto 2",
	--Konto 3 AS "Konto 3",
	--Konto 4 AS "Konto 4",
	--Konto 5 AS "Konto 5",
	Ebene1 AS "Ebene1",
	Ebene2 AS "Ebene2",
	Ebene3 AS "Ebene3",
	Ebene4 AS "Ebene4",
	Ebene5 AS "Ebene5",
	Ebene6 AS "Ebene6",
	--Ebene7 AS "Ebene7",
	--Ebene8 AS "Ebene8",
	--Ebene9 AS "Ebene9",
	--Ebene10 AS "Ebene10",
	Ebene11 AS "Ebene11",
	--Ebene12 AS "Ebene12",
	--Ebene13 AS "Ebene13",
	--Ebene14 AS "Ebene14",
	--Ebene15 AS "Ebene15",
	--Ebene16 AS "Ebene16",
	--Ebene17 AS "Ebene17",
	--Ebene18 AS "Ebene18",
	--Ebene19 AS "Ebene19",
	--Ebene20 AS "Ebene20",
	Ebene21 AS "Ebene21",
	--Ebene22 AS "Ebene22",
	--Ebene23 AS "Ebene23",
	--Ebene24 AS "Ebene24",
	--Ebene25 AS "Ebene25",
	--Ebene26 AS "Ebene26",
	--Ebene27 AS "Ebene27",
	--Ebene28 AS "Ebene28",
	--Ebene29 AS "Ebene29",
	--Ebene30 AS "Ebene30",
	Ebene31 AS "Ebene31",
	--Ebene32 AS "Ebene32",
	--Ebene33 AS "Ebene33",
	--Ebene34 AS "Ebene34",
	--Ebene35 AS "Ebene35",
	--Ebene36 AS "Ebene36",
	--Ebene37 AS "Ebene37",
	--Ebene38 AS "Ebene38",
	--Ebene39 AS "Ebene39",
	--Ebene40 AS "Ebene40",
	--Ebene41 AS "Ebene41",
	--Ebene42 AS "Ebene42",
	--Ebene43 AS "Ebene43",
	--Ebene44 AS "Ebene44",
	--Ebene45 AS "Ebene45",
	--Ebene46 AS "Ebene46",
	--Ebene47 AS "Ebene47",
	--Ebene48 AS "Ebene48",
	--Ebene49 AS "Ebene49",
	--Ebene50 AS "Ebene50",
	--Ebene51 AS "Ebene51",
	--Ebene52 AS "Ebene52",
	--Ebene53 AS "Ebene53",
	--Ebene54 AS "Ebene54",
	--Ebene55 AS "Ebene55",
	--Ebene56 AS "Ebene56",
	--Ebene57 AS "Ebene57",
	--Ebene58 AS "Ebene58",
	--Ebene59 AS "Ebene59",
	--Ebene60 AS "Ebene60",
	--Ebene61 AS "Ebene61",
	--Ebene62 AS "Ebene62",
	--Ebene63 AS "Ebene63",
	--Ebene64 AS "Ebene64",
	--Ebene65 AS "Ebene65",
	--Ebene66 AS "Ebene66",
	--Ebene67 AS "Ebene67",
	--Ebene68 AS "Ebene68",
	--Ebene69 AS "Ebene69",
	--Ebene70 AS "Ebene70",
	Ebene71 AS "Ebene71",
	Ebene72 AS "Ebene72",
	Ebene73 AS "Ebene73",
	Ebene74 AS "Ebene74",
	Ebene75 AS "Ebene75",
	Ebene76 AS "Ebene76",
	Ebene77 AS "Ebene77",
	--Ebene78 AS "Ebene78",
	--Ebene79 AS "Ebene79",
	--Ebene80 AS "Ebene80",
	Ebene81 AS "Ebene81",
	Ebene82 AS "Ebene82",
	Ebene83 AS "Ebene83",
	Ebene84 AS "Ebene84",
	Ebene85 AS "Ebene85",
	Ebene86 AS "Ebene86",
	--Ebene87 AS "Ebene87",
	--Ebene88 AS "Ebene88",
	--Ebene89 AS "Ebene89",
	--Ebene90 AS "Ebene90",
	--Anzahl Stellen_Konto_Nr AS "Anzahl Stellen_Konto_Nr",
	--Konto Art AS "Konto Art",
	GuV_Bilanz AS "GuV_Bilanz",
	Acct Nr AS "Acct Nr",
	Konto AS "Konto",
	Susa AS "Susa" 
FROM [export_csv].[Kontenrahmen_GC_Struct_SKR]
GO

CREATE
	OR

ALTER VIEW [load].[Kontenrahmen_GC_Struct_SKR_731000_Teile_intern]
AS
SELECT --Konto Nr_ori AS "Konto Nr_ori",
	--Konto Bezeichnung_ori AS "Konto Bezeichnung_ori",
	--Konto Art_ori AS "Konto Art_ori",
	Kostenstelle AS "Kostenstelle",
	--Stk AS "Stk",
	--Konto 1 AS "Konto 1",
	--Konto 2 AS "Konto 2",
	--Konto 3 AS "Konto 3",
	--Konto 4 AS "Konto 4",
	--Konto 5 AS "Konto 5",
	Ebene1 AS "Ebene1",
	Ebene2 AS "Ebene2",
	Ebene3 AS "Ebene3",
	--Ebene4_ori AS "Ebene4_ori",
	Ebene5 AS "Ebene5",
	Ebene6 AS "Ebene6",
	--Ebene7 AS "Ebene7",
	--Ebene8 AS "Ebene8",
	--Ebene9 AS "Ebene9",
	--Ebene10 AS "Ebene10",
	Ebene11 AS "Ebene11",
	--Ebene12 AS "Ebene12",
	--Ebene13 AS "Ebene13",
	--Ebene14 AS "Ebene14",
	--Ebene15 AS "Ebene15",
	--Ebene16 AS "Ebene16",
	--Ebene17 AS "Ebene17",
	--Ebene18 AS "Ebene18",
	--Ebene19 AS "Ebene19",
	--Ebene20 AS "Ebene20",
	Ebene21 AS "Ebene21",
	--Ebene22 AS "Ebene22",
	--Ebene23 AS "Ebene23",
	--Ebene24 AS "Ebene24",
	--Ebene25 AS "Ebene25",
	--Ebene26 AS "Ebene26",
	--Ebene27 AS "Ebene27",
	--Ebene28 AS "Ebene28",
	--Ebene29 AS "Ebene29",
	--Ebene30 AS "Ebene30",
	Ebene31 AS "Ebene31",
	--Ebene32 AS "Ebene32",
	--Ebene33 AS "Ebene33",
	--Ebene34 AS "Ebene34",
	--Ebene35 AS "Ebene35",
	--Ebene36 AS "Ebene36",
	--Ebene37 AS "Ebene37",
	--Ebene38 AS "Ebene38",
	--Ebene39 AS "Ebene39",
	--Ebene40 AS "Ebene40",
	--Ebene41 AS "Ebene41",
	--Ebene42 AS "Ebene42",
	--Ebene43 AS "Ebene43",
	--Ebene44 AS "Ebene44",
	--Ebene45 AS "Ebene45",
	--Ebene46 AS "Ebene46",
	--Ebene47 AS "Ebene47",
	--Ebene48 AS "Ebene48",
	--Ebene49 AS "Ebene49",
	--Ebene50 AS "Ebene50",
	--Ebene51 AS "Ebene51",
	--Ebene52 AS "Ebene52",
	--Ebene53 AS "Ebene53",
	--Ebene54 AS "Ebene54",
	--Ebene55 AS "Ebene55",
	--Ebene56 AS "Ebene56",
	--Ebene57 AS "Ebene57",
	--Ebene58 AS "Ebene58",
	--Ebene59 AS "Ebene59",
	--Ebene60 AS "Ebene60",
	--Ebene61 AS "Ebene61",
	--Ebene62 AS "Ebene62",
	--Ebene63 AS "Ebene63",
	--Ebene64 AS "Ebene64",
	--Ebene65 AS "Ebene65",
	--Ebene66 AS "Ebene66",
	--Ebene67 AS "Ebene67",
	--Ebene68 AS "Ebene68",
	--Ebene69 AS "Ebene69",
	--Ebene70 AS "Ebene70",
	Ebene71 AS "Ebene71",
	Ebene72 AS "Ebene72",
	Ebene73 AS "Ebene73",
	Ebene74 AS "Ebene74",
	Ebene75 AS "Ebene75",
	Ebene76 AS "Ebene76",
	Ebene77 AS "Ebene77",
	--Ebene78 AS "Ebene78",
	--Ebene79 AS "Ebene79",
	--Ebene80 AS "Ebene80",
	Ebene81 AS "Ebene81",
	Ebene82 AS "Ebene82",
	Ebene83 AS "Ebene83",
	Ebene84 AS "Ebene84",
	Ebene85 AS "Ebene85",
	Ebene86 AS "Ebene86",
	--Ebene87 AS "Ebene87",
	--Ebene88 AS "Ebene88",
	--Ebene89 AS "Ebene89",
	--Ebene90 AS "Ebene90",
	--Anzahl Stellen_Konto_Nr AS "Anzahl Stellen_Konto_Nr",
	--Konto Art AS "Konto Art",
	GuV_Bilanz AS "GuV_Bilanz",
	Acct Nr AS "Acct Nr",
	Konto AS "Konto",
	Susa AS "Susa",
	--Konto Nr AS "Konto Nr",
	--Konto Bezeichnung AS "Konto Bezeichnung",
	Ebene4 AS "Ebene4" 
FROM [export_csv].[Kontenrahmen_GC_Struct_SKR_731000_Teile_intern]
GO

CREATE
	OR

ALTER VIEW [load].[Kontenrahmen_Stk_GC_Struct_SKR]
AS
SELECT --Konto Nr AS "Konto Nr",
	--Konto Bezeichnung AS "Konto Bezeichnung",
	--Konto Art_ori AS "Konto Art_ori",
	Kostenstelle AS "Kostenstelle",
	--Stk AS "Stk",
	--Konto 1 AS "Konto 1",
	--Konto 2 AS "Konto 2",
	--Konto 3 AS "Konto 3",
	--Konto 4 AS "Konto 4",
	--Konto 5 AS "Konto 5",
	--Ebene1_ori AS "Ebene1_ori",
	--Ebene2_ori AS "Ebene2_ori",
	Ebene3 AS "Ebene3",
	Ebene4 AS "Ebene4",
	Ebene5 AS "Ebene5",
	Ebene6 AS "Ebene6",
	--Ebene7 AS "Ebene7",
	--Ebene8 AS "Ebene8",
	--Ebene9 AS "Ebene9",
	--Ebene10 AS "Ebene10",
	Ebene11 AS "Ebene11",
	--Ebene12 AS "Ebene12",
	--Ebene13 AS "Ebene13",
	--Ebene14 AS "Ebene14",
	--Ebene15 AS "Ebene15",
	--Ebene16 AS "Ebene16",
	--Ebene17 AS "Ebene17",
	--Ebene18 AS "Ebene18",
	--Ebene19 AS "Ebene19",
	--Ebene20 AS "Ebene20",
	Ebene21 AS "Ebene21",
	--Ebene22 AS "Ebene22",
	--Ebene23 AS "Ebene23",
	--Ebene24 AS "Ebene24",
	--Ebene25 AS "Ebene25",
	--Ebene26 AS "Ebene26",
	--Ebene27 AS "Ebene27",
	--Ebene28 AS "Ebene28",
	--Ebene29 AS "Ebene29",
	--Ebene30 AS "Ebene30",
	Ebene31 AS "Ebene31",
	--Ebene32 AS "Ebene32",
	--Ebene33 AS "Ebene33",
	--Ebene34 AS "Ebene34",
	--Ebene35 AS "Ebene35",
	--Ebene36 AS "Ebene36",
	--Ebene37 AS "Ebene37",
	--Ebene38 AS "Ebene38",
	--Ebene39 AS "Ebene39",
	--Ebene40 AS "Ebene40",
	--Ebene41 AS "Ebene41",
	--Ebene42 AS "Ebene42",
	--Ebene43 AS "Ebene43",
	--Ebene44 AS "Ebene44",
	--Ebene45 AS "Ebene45",
	--Ebene46 AS "Ebene46",
	--Ebene47 AS "Ebene47",
	--Ebene48 AS "Ebene48",
	--Ebene49 AS "Ebene49",
	--Ebene50 AS "Ebene50",
	--Ebene51 AS "Ebene51",
	--Ebene52 AS "Ebene52",
	--Ebene53 AS "Ebene53",
	--Ebene54 AS "Ebene54",
	--Ebene55 AS "Ebene55",
	--Ebene56 AS "Ebene56",
	--Ebene57 AS "Ebene57",
	--Ebene58 AS "Ebene58",
	--Ebene59 AS "Ebene59",
	--Ebene60 AS "Ebene60",
	--Ebene61 AS "Ebene61",
	--Ebene62 AS "Ebene62",
	--Ebene63 AS "Ebene63",
	--Ebene64 AS "Ebene64",
	--Ebene65 AS "Ebene65",
	--Ebene66 AS "Ebene66",
	--Ebene67 AS "Ebene67",
	--Ebene68 AS "Ebene68",
	--Ebene69 AS "Ebene69",
	--Ebene70 AS "Ebene70",
	Ebene71 AS "Ebene71",
	Ebene72 AS "Ebene72",
	Ebene73 AS "Ebene73",
	Ebene74 AS "Ebene74",
	Ebene75 AS "Ebene75",
	Ebene76 AS "Ebene76",
	Ebene77 AS "Ebene77",
	--Ebene78 AS "Ebene78",
	--Ebene79 AS "Ebene79",
	--Ebene80 AS "Ebene80",
	--Anzahl Stellen_Konto_Nr AS "Anzahl Stellen_Konto_Nr",
	--Konto Art AS "Konto Art",
	GuV_Bilanz AS "GuV_Bilanz",
	Acct Nr AS "Acct Nr",
	Konto AS "Konto",
	Susa AS "Susa",
	Ebene1 AS "Ebene1",
	Ebene2 AS "Ebene2" 
FROM [export_csv].[Kontenrahmen_Stk_GC_Struct_SKR]
GO

CREATE
	OR

ALTER VIEW [load].[SKR_Herkunft_KST]
AS
SELECT Ebene11 AS "Ebene11",
	--Ebene13 AS "Ebene13",
	--Ebene14 AS "Ebene14",
	--Ebene15 AS "Ebene15",
	--Ebene16 AS "Ebene16",
	--Ebene17 AS "Ebene17",
	--Ebene18 AS "Ebene18",
	--Ebene19 AS "Ebene19",
	--Ebene20 AS "Ebene20",
	KST AS "KST",
	KST_mit_Bez AS "KST_mit_Bez" 
FROM [export_csv].[SKR_Herkunft_KST]
GO

CREATE
	OR

ALTER VIEW [load].[SKR_Marke]
AS
SELECT Marke_mit_Bez AS "Marke_mit_Bez",
	Marke AS "Marke",
	--Ebene42 AS "Ebene42",
	--Ebene43 AS "Ebene43",
	--Ebene44 AS "Ebene44",
	--Ebene45 AS "Ebene45",
	--Ebene46 AS "Ebene46",
	--Ebene47 AS "Ebene47",
	--Ebene48 AS "Ebene48",
	--Ebene49 AS "Ebene49",
	--Ebene50 AS "Ebene50" 
FROM [export_csv].[SKR_Marke]
GO

CREATE
	OR

ALTER VIEW [load].[SKR_Absatzkanal]
AS
SELECT Ebene21 AS "Ebene21",
	Absatzkanal_mit_Bez AS "Absatzkanal_mit_Bez",
	--Ebene23 AS "Ebene23",
	--Ebene24 AS "Ebene24",
	--Ebene25 AS "Ebene25",
	--Ebene26 AS "Ebene26",
	--Ebene27 AS "Ebene27",
	--Ebene28 AS "Ebene28",
	--Ebene29 AS "Ebene29",
	--Ebene30 AS "Ebene30",
	Absatzkanal AS "Absatzkanal" 
FROM [export_csv].[SKR_Absatzkanal]
GO

CREATE
	OR

ALTER VIEW [load].[SKR_Kostenträger]
AS
SELECT Ebene31 AS "Ebene31",
	--Ebene32 AS "Ebene32",
	--Ebene33 AS "Ebene33",
	--Ebene34 AS "Ebene34",
	--Ebene35 AS "Ebene35",
	--Ebene36 AS "Ebene36",
	--Ebene37 AS "Ebene37",
	--Ebene38 AS "Ebene38",
	--Ebene39 AS "Ebene39",
	--Ebene40 AS "Ebene40",
	Kostenträger_mit_Bez AS "Kostenträger_mit_Bez",
	Kostenträger AS "Kostenträger",
	--Ebene_Marke AS "Ebene_Marke" 
FROM [export_csv].[SKR_Kostenträger]
GO

CREATE
	OR

ALTER VIEW [load].[Belege_EDS_SKR_mit_Kto_KST]
AS
SELECT --Nr AS "Nr",
	--Name AS "Name",
	--Kontoart AS "Kontoart",
	--Guv Bilanz AS "Guv Bilanz",
	--Soll Haben AS "Soll Haben",
	--Kostenstellen Buchung AS "Kostenstellen Buchung",
	--Lfd Nr AS "Lfd Nr",
	--Sachkontonr AS "Sachkontonr",
	--Buchungsdatum AS "Buchungsdatum",
	--Belegart AS "Belegart",
	--Belegnr AS "Belegnr",
	--Beschreibung AS "Beschreibung",
	--Gegenkontonr AS "Gegenkontonr",
	--Betrag_ori AS "Betrag_ori",
	--Kostenstellencode AS "Kostenstellencode",
	--Markencode AS "Markencode",
	--Benutzer Id AS "Benutzer Id",
	--Herkunftscode AS "Herkunftscode",
	--Nachbuchung AS "Nachbuchung",
	--Menge_ori AS "Menge_ori",
	--Mwst Betrag AS "Mwst Betrag",
	--Buchungsart AS "Buchungsart",
	--Geschäftsbuchungsgruppe AS "Geschäftsbuchungsgruppe",
	--Geschäftsbuchungsgruppe_Beschreibung AS "Geschäftsbuchungsgruppe_Beschreibung",
	--Produktbuchungsgruppe AS "Produktbuchungsgruppe",
	--Produktbuchungsgruppe_Beschreibung AS "Produktbuchungsgruppe_Beschreibung",
	--Gegenkontoart AS "Gegenkontoart",
	--Transaktionsnr AS "Transaktionsnr",
	--Sollbetrag AS "Sollbetrag",
	--Habenbetrag AS "Habenbetrag",
	--Belegdatum AS "Belegdatum",
	--Externe Belegnummer AS "Externe Belegnummer",
	--Herkunftsart AS "Herkunftsart",
	--Herkunftsnr AS "Herkunftsnr",
	--Filialcode AS "Filialcode",
	--Hauptbereich AS "Hauptbereich",
	--Fahrgestellnummer AS "Fahrgestellnummer",
	--Buchnummer AS "Buchnummer",
	--Fahrzeug-kz AS "Fahrzeug-kz",
	--Umgebucht AS "Umgebucht",
	--Storniert AS "Storniert",
	--Fahrzeugklassecode AS "Fahrzeugklassecode",
	--Code AS "Code",
	--Name AS "(2) Name",
	--Code AS "(2) Code",
	--Bezeichnung AS "Bezeichnung",
	--Betrag_1 AS "Betrag_1",
	Rechtseinheit AS "Rechtseinheit",
	--Betrieb_Nr AS "Betrieb_Nr",
	--Betrieb_1 AS "Betrieb_1",
	--Marke_ori AS "Marke_ori",
	Mandant AS "Mandant",
	--Menge_1 AS "Menge_1",
	Bookkeep Date AS "Bookkeep Date",
	Text AS "Text",
	--KST_aus_Code AS "KST_aus_Code",
	--Kostenstelle_ori AS "Kostenstelle_ori",
	--KST_1 AS "KST_1",
	--KST_2 AS "KST_2",
	--Acct Nr_ori AS "Acct Nr_ori",
	Acct Nr AS "Acct Nr",
	Betrag AS "Betrag",
	Menge AS "Menge",
	Betrieb AS "Betrieb",
	--Benutzer AS "Benutzer",
	--Fahrgestellnummer AS "(2) Fahrgestellnummer",
	--Modell_neu AS "Modell_neu",
	--Markencode AS "(2) Markencode",
	--Verkäufer Nr Verkauf AS "Verkäufer Nr Verkauf",
	--Konto KZ AS "Konto KZ",
	--Plausibilität AS "Plausibilität",
	--Marke aus KST AS "Marke aus KST",
	Marke AS "Marke",
	--Susa AS "Susa_",
	--GuV_Bilanz AS "GuV_Bilanz_",
	--Absatzkanal_Code AS "Absatzkanal_Code",
	--KST_ori AS "KST_ori",
	KST AS "KST",
	--Mb Makecode AS "Mb Makecode",
	--Mb Locationcode AS "Mb Locationcode",
	--Mb Costcentercode AS "Mb Costcentercode",
	--Mb Distributionchannelcode AS "Mb Distributionchannelcode",
	--Mb Costunitcode AS "Mb Costunitcode",
	--Mb Taxationcode AS "Mb Taxationcode",
	Kostenträger AS "Kostenträger",
	Absatzkanal AS "Absatzkanal",
	Buchungen ohne Marke AS "Buchungen mit/ohne Marke",
	Buchungen ohne KST AS "Buchungen mit/ohne KST",
	Kto_KST_Service AS "Kto_KST_Service" 
FROM [export_csv].[Belege_EDS_SKR_mit_Kto_KST]
GO

CREATE
	OR

ALTER VIEW [load].[Auftraege_EDS_FIBU_SKR51]
AS
SELECT --A_Belegart AS "A_Belegart",
	--A_Nr AS "A_Nr",
	--A_Verk An Deb -nr AS "A_Verk An Deb -nr",
	--A_Rech An Deb -nr AS "A_Rech An Deb -nr",
	--A_Auftragsdatum AS "A_Auftragsdatum",
	--A_Buchungsdatum AS "A_Buchungsdatum",
	--A_Filialcode AS "A_Filialcode",
	--B_Belegart AS "B_Belegart",
	--B_Nr AS "B_Nr",
	--B_Verk An Deb -nr AS "B_Verk An Deb -nr",
	--B_Rech An Deb -nr AS "B_Rech An Deb -nr",
	--B_Auftragsdatum AS "B_Auftragsdatum",
	--B_Buchungsdatum AS "B_Buchungsdatum",
	--B_Interne Belegnr AS "B_Interne Belegnr",
	--A_Interner Auftrag AS "A_Interner Auftrag",
	--A_Interne Belegnr AS "A_Interne Belegnr",
	--B_Filialcode AS "B_Filialcode",
	--Belegart AS "Belegart",
	--Nr AS "Nr",
	--Verk An Deb -nr AS "Verk An Deb -nr",
	--Auftragsdatum AS "Auftragsdatum",
	--Buchungsdatum AS "Buchungsdatum",
	--Filialcode AS "Filialcode",
	--Belegnr AS "Belegnr",
	--Art AS "Art",
	--APO_TEILE_Nr AS "APO_TEILE_Nr",
	--Beschreibung AS "Beschreibung",
	--Menge_ori AS "Menge_ori",
	--Ek-preis AS "Ek-preis",
	--Einstandspreis AS "Einstandspreis",
	--Einstandsbetrag_ori AS "Einstandsbetrag_ori",
	--Vk-preis AS "Vk-preis",
	--Verkaufsbetrag_ori AS "Verkaufsbetrag_ori",
	--Fakturierbar AS "Fakturierbar",
	--Werkstattbuchungsgruppe AS "Werkstattbuchungsgruppe",
	--Kostenstellencode AS "Kostenstellencode",
	--Markencode AS "Markencode",
	--Arbeitstypencode AS "Arbeitstypencode",
	--Benutzer Id AS "Benutzer Id",
	--Herkunftscode AS "Herkunftscode",
	--Postenart AS "Postenart",
	--Positiv AS "Positiv",
	--Geschäftsbuchungsgruppe AS "Geschäftsbuchungsgruppe",
	--Produktbuchungsgruppe AS "Produktbuchungsgruppe",
	--Belegdatum AS "Belegdatum",
	--Nummernserie AS "Nummernserie",
	--Storniert AS "Storniert",
	--Buchnr AS "Buchnr",
	--Zeitart AS "Zeitart",
	--Fahrzeugtyp AS "Fahrzeugtyp",
	--Paketnr AS "Paketnr",
	--Kostenstellencode Verkauf AS "Kostenstellencode Verkauf",
	--Verrechnungspreis AS "Verrechnungspreis",
	--Verrechnungsbetrag_ori AS "Verrechnungsbetrag_ori",
	--Verrechnungsbetrag (bw) AS "Verrechnungsbetrag (bw)",
	--Abgeschlossen AS "Abgeschlossen",
	--Fahrgestellnummer AS "Fahrgestellnummer",
	--Menge Pro Stunde AS "Menge Pro Stunde",
	--Menge (stunde) AS "Menge (stunde)",
	--Artikelgruppencode AS "Artikelgruppencode",
	--Belegtyp AS "Belegtyp",
	--Fahrzeugartencode AS "Fahrzeugartencode",
	--Fahrzeugstatus AS "Fahrzeugstatus",
	--Marktsegmentcode AS "Marktsegmentcode",
	--Hauptgruppencode AS "Hauptgruppencode",
	--Untergruppencode AS "Untergruppencode",
	--Positionsgruppencode AS "Positionsgruppencode",
	--Kundengruppencode AS "Kundengruppencode",
	--Ist-menge (stunde) AS "Ist-menge (stunde)",
	--Vorgabezeit AS "Vorgabezeit",
	--Vorgabezeitart AS "Vorgabezeitart",
	--Herkunftsart AS "Herkunftsart",
	--Herkunftsnr AS "Herkunftsnr",
	--Auftragszeilennr AS "Auftragszeilennr",
	--Interne Verrechnung Erfolgt AS "Interne Verrechnung Erfolgt",
	--Verrechnungspreis Fix AS "Verrechnungspreis Fix",
	--Auftrag Erledigt AS "Auftrag Erledigt",
	--Buchungsdatum (letzte Rechn ) AS "Buchungsdatum (letzte Rechn )",
	--Offen AS "Offen",
	--Betrag Int Zu Verrechnen AS "Betrag Int Zu Verrechnen",
	--Betrag Int Zu Verrechnen (bw) AS "Betrag Int Zu Verrechnen (bw)",
	--Betrag Int Verrechnet AS "Betrag Int Verrechnet",
	--Betrag Int Verrechnet (bw) AS "Betrag Int Verrechnet (bw)",
	--Serviceberaternr AS "Serviceberaternr",
	--Mitarbeiternr AS "Mitarbeiternr",
	--Tätigkeitsartcode AS "Tätigkeitsartcode",
	--Monteur Nr 1 AS "Monteur Nr 1",
	--Aw Mont 1 AS "Aw Mont 1",
	--Monteur Nr 2 AS "Monteur Nr 2",
	--Aw Mont 2 AS "Aw Mont 2",
	--Hauptbetrieb AS "Hauptbetrieb",
	--Standort AS "Standort",
	--FIL-Code AS "FIL-Code",
	--FIL-Bezeichnung AS "FIL-Bezeichnung",
	--Standort_1 AS "Standort_1",
	--Vorname AS "Vorname",
	--Nachname AS "Nachname",
	--Serviceberater AS "Serviceberater",
	--Menge AS "Menge_",
	--Einstandsbetrag AS "Einstandsbetrag",
	--Verkaufsbetrag AS "Verkaufsbetrag",
	--Rech An Deb -nr AS "Rech An Deb -nr",
	--Umsatzart_ori AS "Umsatzart_ori",
	--KD_Nr AS "KD_Nr",
	--KD_Name AS "KD_Name",
	--Kunde AS "Kunde",
	--Invoice Date AS "Invoice Date",
	--Order Number AS "Order Number",
	--Fabrikat AS "Fabrikat",
	--Modell AS "Modell",
	--Model AS "Model",
	--Fahrzeug AS "Fahrzeug",
	--KST_aus_Code AS "KST_aus_Code",
	--Kostenstelle_alt AS "Kostenstelle_alt",
	--Auftragsart AS "Auftragsart",
	--Lines Net Value AS "Lines Net Value",
	--Umsatz Lohn AS "Umsatz Lohn",
	--Umsatz Teile Service AS "Umsatz Teile Service",
	--Umsatz Sonstiges AS "Umsatz Sonstiges",
	--Einsatz Teile Service_ori AS "Einsatz Teile Service_ori",
	--Einsatz Teile Service AS "Einsatz Teile Service",
	--Einsatz Sonstiges AS "Einsatz Sonstiges",
	--Menge_pro_Stunde AS "Menge_pro_Stunde",
	--Menge_stunde AS "Menge_stunde",
	--Sollzeit AS "Sollzeit",
	--Sollzeit_Art AS "Sollzeit_Art",
	--AW_Mont_1 AS "AW_Mont_1",
	--AW_Mont_2 AS "AW_Mont_2",
	verk. Stunden AS "verk. Stunden",
	--Soll-Stunden AS "Soll-Stunden",
	--benutzte Zeit_ori AS "benutzte Zeit_ori",
	--Auftragsnr AS "Auftragsnr",
	--A_Belegnr AS "A_Belegnr",
	--A_Zeilennr AS "A_Zeilennr",
	--Archivierungsdatum AS "Archivierungsdatum",
	--Arch Durch Benutzer Id AS "Arch Durch Benutzer Id",
	--Archivierungsgrund AS "Archivierungsgrund",
	--Umsatzart AS "Umsatzart",
	Marke AS "Marke",
	--Kundenart AS "Kundenart",
	--DG_1 AS "DG_1",
	--Herkunftsnr (zahlung) AS "Herkunftsnr (zahlung)",
	--Hauptdebitor AS "Hauptdebitor",
	--DB Teile AS "DB Teile",
	--Verr_Betrag AS "Verr_Betrag",
	--Nr AS "(2) Nr",
	--Beschreibung AS "(2) Beschreibung",
	--Basiseinheitencode AS "Basiseinheitencode",
	--Vk-preis AS "(2) Vk-preis",
	--Einstandspreis_ART AS "Einstandspreis_ART",
	--Ek-preis (neuester)_ART AS "Ek-preis (neuester)_ART",
	--Einstandspreis (durchschn )_ART AS "Einstandspreis (durchschn )_ART",
	--Einstandspreis_Art AS "Einstandspreis_Art",
	--EK_preis_neu_Art AS "EK_preis_neu_Art",
	--Einstandspreis_Durch_Art AS "Einstandspreis_Durch_Art",
	--Heute AS "Heute",
	--Tag AS "Tag",
	--Buchungsdatum_Datum AS "Buchungsdatum_Datum",
	--Rechnungsausgang AS "Rechnungsausgang",
	--Order_Number_RG_Ausg AS "Order_Number_RG_Ausg",
	--DG_1 AS "(2) DG_1",
	--DG_2 AS "DG_2",
	--Durchgänge AS "Durchgänge",
	Bookkeep Date AS "Bookkeep Date",
	Rechtseinheit AS "Rechtseinheit",
	Betrieb AS "Betrieb",
	Ebene1 AS "Ebene1",
	Ebene2 AS "Ebene2",
	Ebene3 AS "Ebene3",
	Ebene4 AS "Ebene4",
	Kostenstelle AS "Kostenstelle",
	Ebene11 AS "Ebene11",
	--KST_vor_Produktbuchungsgruppe AS "KST_vor_Produktbuchungsgruppe",
	KST AS "KST",
	--Code_Kostenstelle AS "Code_Kostenstelle",
	--Name_Kostenstelle AS "Name_Kostenstelle",
	KST_mit_Bez AS "KST_mit_Bez" 
FROM [export_csv].[Auftraege_EDS_FIBU_SKR51]
GO

CREATE
	OR

ALTER VIEW [load].[Belege_EDS_SKR_Stk]
AS
SELECT --Nr AS "Nr",
	--Name AS "Name",
	--Kontoart AS "Kontoart",
	--Guv Bilanz AS "Guv Bilanz",
	--Soll Haben AS "Soll Haben",
	--Kostenstellen Buchung AS "Kostenstellen Buchung",
	--Lfd Nr AS "Lfd Nr",
	--Sachkontonr AS "Sachkontonr",
	--Buchungsdatum AS "Buchungsdatum",
	--Belegart AS "Belegart",
	--Belegnr AS "Belegnr",
	--Beschreibung AS "Beschreibung",
	--Gegenkontonr AS "Gegenkontonr",
	--Betrag_ori AS "Betrag_ori",
	--Kostenstellencode AS "Kostenstellencode",
	--Markencode AS "Markencode",
	--Benutzer Id AS "Benutzer Id",
	--Herkunftscode AS "Herkunftscode",
	--Nachbuchung AS "Nachbuchung",
	--Menge_ori AS "Menge_ori",
	--Mwst Betrag AS "Mwst Betrag",
	--Buchungsart AS "Buchungsart",
	--Geschäftsbuchungsgruppe AS "Geschäftsbuchungsgruppe",
	--Geschäftsbuchungsgruppe_Beschreibung AS "Geschäftsbuchungsgruppe_Beschreibung",
	--Produktbuchungsgruppe AS "Produktbuchungsgruppe",
	--Produktbuchungsgruppe_Beschreibung AS "Produktbuchungsgruppe_Beschreibung",
	--Gegenkontoart AS "Gegenkontoart",
	--Transaktionsnr AS "Transaktionsnr",
	--Sollbetrag AS "Sollbetrag",
	--Habenbetrag AS "Habenbetrag",
	--Belegdatum AS "Belegdatum",
	--Externe Belegnummer AS "Externe Belegnummer",
	--Herkunftsart AS "Herkunftsart",
	--Herkunftsnr AS "Herkunftsnr",
	--Filialcode AS "Filialcode",
	--Hauptbereich AS "Hauptbereich",
	--Fahrgestellnummer AS "Fahrgestellnummer",
	--Buchnummer AS "Buchnummer",
	--Fahrzeug-kz AS "Fahrzeug-kz",
	--Umgebucht AS "Umgebucht",
	--Storniert AS "Storniert",
	--Fahrzeugklassecode AS "Fahrzeugklassecode",
	--Code AS "Code",
	--Name AS "(2) Name",
	--Code AS "(2) Code",
	--Bezeichnung AS "Bezeichnung",
	--Betrag_1 AS "Betrag_1",
	Rechtseinheit AS "Rechtseinheit",
	--Betrieb_Nr AS "Betrieb_Nr",
	--Betrieb_1 AS "Betrieb_1",
	--Marke_ori AS "Marke_ori",
	Mandant AS "Mandant",
	--Menge_1 AS "Menge_1",
	Bookkeep Date AS "Bookkeep Date",
	Text AS "Text",
	--KST_aus_Code AS "KST_aus_Code",
	--Kostenstelle_ori AS "Kostenstelle_ori",
	--KST_1 AS "KST_1",
	--KST_2 AS "KST_2",
	--Acct Nr_ori AS "Acct Nr_ori",
	Betrag AS "Betrag",
	Menge AS "Menge",
	Betrieb AS "Betrieb",
	--Benutzer AS "Benutzer",
	--Fahrgestellnummer AS "(2) Fahrgestellnummer",
	--Modell_neu AS "Modell_neu",
	--Markencode AS "(2) Markencode",
	--Verkäufer Nr Verkauf AS "Verkäufer Nr Verkauf",
	--Konto KZ AS "Konto KZ",
	--Plausibilität AS "Plausibilität",
	--Marke aus KST AS "Marke aus KST",
	Marke AS "Marke",
	--Susa AS "Susa_",
	--GuV_Bilanz AS "GuV_Bilanz_",
	--Absatzkanal_Code AS "Absatzkanal_Code",
	--KST_ori AS "KST_ori",
	KST AS "KST",
	--Mb Makecode AS "Mb Makecode",
	--Mb Locationcode AS "Mb Locationcode",
	--Mb Costcentercode AS "Mb Costcentercode",
	--Mb Distributionchannelcode AS "Mb Distributionchannelcode",
	--Mb Costunitcode AS "Mb Costunitcode",
	--Mb Taxationcode AS "Mb Taxationcode",
	Kostenträger AS "Kostenträger",
	Acct Nr AS "Acct Nr",
	--Mb Makecode AS "(2) Mb Makecode",
	--Code_MB_Cost_Unit AS "Code_MB_Cost_Unit",
	--Description_MB_Cost_Unit AS "Description_MB_Cost_Unit",
	--Kostenträger_FIBU AS "Kostenträger_FIBU",
	Absatzkanal AS "Absatzkanal",
	Buchungen ohne Marke AS "Buchungen mit/ohne Marke",
	Buchungen ohne KST AS "Buchungen mit/ohne KST",
	Kto_KST_Service AS "Kto_KST_Service" 
FROM [export_csv].[Belege_EDS_SKR_Stk]
GO

CREATE
	OR

ALTER VIEW [load].[Service_EW_Lohn_Plan_2019_SKR51]
AS
SELECT Rechtseinheit AS "Rechtseinheit",
	Betrieb AS "Betrieb",
	Ebene1 AS "Ebene1",
	Ebene2 AS "Ebene2",
	Ebene3 AS "Ebene3",
	Ebene4 AS "Ebene4",
	Ebene5 AS "Ebene5",
	Kostenstelle AS "Kostenstelle",
	--Bookkeep Date_ori AS "Bookkeep Date_ori",
	--Wert1 AS "Wert1",
	--Wert2 AS "Wert2",
	--Wert3 AS "Wert3",
	--Wert4 AS "Wert4",
	--Wert5 AS "Wert5",
	--Wert6 AS "Wert6",
	--Wert7 AS "Wert7",
	--Wert8 AS "Wert8",
	--Wert9 AS "Wert9",
	--Wert10 AS "Wert10",
	--Wert11 AS "Wert11",
	--Wert12 AS "Wert12",
	--Datum AS "Datum",
	--Arbeitstag Mofr AS "Arbeitstag Mofr_",
	--Zaehler Mofr AS "Zaehler Mofr_",
	--Summe Mofr AS "Summe Mofr_",
	--Monat_Datum AS "Monat_Datum",
	EW Lohn Plan Tag AS "EW Lohn Plan Tag",
	Bookkeep Date AS "Bookkeep Date",
	Ebene11 AS "Ebene11",
	KST_mit_Bez AS "KST_mit_Bez" 
FROM [export_csv].[Service_EW_Lohn_Plan_2019_SKR51]
GO

CREATE
	OR

ALTER VIEW [load].[Service_Bruttoertrag_Plan_2019]
AS
SELECT Rechtseinheit AS "Rechtseinheit",
	Betrieb AS "Betrieb",
	Ebene1 AS "Ebene1",
	Ebene2 AS "Ebene2",
	Ebene3 AS "Ebene3",
	Ebene4 AS "Ebene4",
	Ebene5 AS "Ebene5",
	Kostenstelle AS "Kostenstelle",
	--Bookkeep Date_ori AS "Bookkeep Date_ori",
	--Wert1 AS "Wert1",
	--Wert2 AS "Wert2",
	--Wert3 AS "Wert3",
	--Wert4 AS "Wert4",
	--Wert5 AS "Wert5",
	--Wert6 AS "Wert6",
	--Wert7 AS "Wert7",
	--Wert8 AS "Wert8",
	--Wert9 AS "Wert9",
	--Wert10 AS "Wert10",
	--Wert11 AS "Wert11",
	--Wert12 AS "Wert12",
	--Datum AS "Datum",
	--Arbeitstag Mofr AS "Arbeitstag Mofr_",
	--Zaehler Mofr AS "Zaehler Mofr_",
	--Summe Mofr AS "Summe Mofr_",
	--Monat_Datum AS "Monat_Datum",
	Bruttoertrag Soll Tag AS "Bruttoertrag Soll Tag",
	Bookkeep Date AS "Bookkeep Date",
	Ebene11 AS "Ebene11",
	KST_mit_Bez AS "KST_mit_Bez" 
FROM [export_csv].[Service_Bruttoertrag_Plan_2019]
GO

CREATE
	OR

ALTER VIEW [load].[Belege_EDS_SKR_Bilanz_Teilebestand]
AS
SELECT --Nr AS "Nr",
	--Name AS "Name",
	--Kontoart AS "Kontoart",
	--Guv Bilanz AS "Guv Bilanz",
	--Soll Haben AS "Soll Haben",
	--Kostenstellen Buchung AS "Kostenstellen Buchung",
	--Lfd Nr AS "Lfd Nr",
	--Sachkontonr AS "Sachkontonr",
	--Buchungsdatum AS "Buchungsdatum",
	--Belegart AS "Belegart",
	--Belegnr AS "Belegnr",
	--Beschreibung AS "Beschreibung",
	--Gegenkontonr AS "Gegenkontonr",
	--Betrag_ori AS "Betrag_ori",
	--Kostenstellencode AS "Kostenstellencode",
	--Markencode AS "Markencode",
	--Benutzer Id AS "Benutzer Id",
	--Herkunftscode AS "Herkunftscode",
	--Nachbuchung AS "Nachbuchung",
	--Menge_ori AS "Menge_ori",
	--Mwst Betrag AS "Mwst Betrag",
	--Buchungsart AS "Buchungsart",
	--Geschäftsbuchungsgruppe AS "Geschäftsbuchungsgruppe",
	--Geschäftsbuchungsgruppe_Beschreibung AS "Geschäftsbuchungsgruppe_Beschreibung",
	--Produktbuchungsgruppe AS "Produktbuchungsgruppe",
	--Produktbuchungsgruppe_Beschreibung AS "Produktbuchungsgruppe_Beschreibung",
	--Gegenkontoart AS "Gegenkontoart",
	--Transaktionsnr AS "Transaktionsnr",
	--Sollbetrag AS "Sollbetrag",
	--Habenbetrag AS "Habenbetrag",
	--Belegdatum AS "Belegdatum",
	--Externe Belegnummer AS "Externe Belegnummer",
	--Herkunftsart AS "Herkunftsart",
	--Herkunftsnr AS "Herkunftsnr",
	--Filialcode AS "Filialcode",
	--Hauptbereich AS "Hauptbereich",
	--Fahrgestellnummer AS "Fahrgestellnummer",
	--Buchnummer AS "Buchnummer",
	--Fahrzeug-kz AS "Fahrzeug-kz",
	--Umgebucht AS "Umgebucht",
	--Storniert AS "Storniert",
	--Fahrzeugklassecode AS "Fahrzeugklassecode",
	--Code AS "Code",
	--Name AS "(2) Name",
	--Code AS "(2) Code",
	--Bezeichnung AS "Bezeichnung",
	--Betrag_1 AS "Betrag_1",
	Rechtseinheit AS "Rechtseinheit",
	--Betrieb_Nr AS "Betrieb_Nr",
	--Betrieb_1 AS "Betrieb_1",
	--Marke_ori AS "Marke_ori",
	Mandant AS "Mandant",
	--Menge_1 AS "Menge_1",
	Bookkeep Date AS "Bookkeep Date",
	--Text AS "Text_",
	--KST_aus_Code AS "KST_aus_Code",
	--Kostenstelle_ori AS "Kostenstelle_ori",
	--KST_1 AS "KST_1",
	--KST_2 AS "KST_2",
	--Acct Nr AS "Acct Nr_",
	Betrag AS "Betrag_Teilebestand",
	--Menge AS "Menge_",
	Betrieb AS "Betrieb",
	--Benutzer AS "Benutzer",
	--Fahrgestellnummer AS "(2) Fahrgestellnummer",
	--Modell_neu AS "Modell_neu",
	--Markencode AS "(2) Markencode",
	--Verkäufer Nr Verkauf AS "Verkäufer Nr Verkauf",
	--Konto KZ AS "Konto KZ",
	--Plausibilität AS "Plausibilität",
	--Marke aus KST AS "Marke aus KST",
	--Marke AS "Marke_",
	--Susa AS "Susa_",
	--GuV_Bilanz AS "GuV_Bilanz_",
	--Absatzkanal_Code AS "Absatzkanal_Code",
	--KST_ori AS "KST_ori",
	--KST AS "KST_",
	--Mb Makecode AS "Mb Makecode",
	--Mb Locationcode AS "Mb Locationcode",
	--Mb Costcentercode AS "Mb Costcentercode",
	--Mb Distributionchannelcode AS "Mb Distributionchannelcode",
	--Mb Costunitcode AS "Mb Costunitcode",
	--Mb Taxationcode AS "Mb Taxationcode",
	--Kostenträger AS "Kostenträger_",
	--Absatzkanal AS "Absatzkanal_",
	--Buchungen ohne Marke AS "Buchungen ohne Marke",
	--Buchungen ohne KST AS "Buchungen ohne KST",
	Ebene1 AS "Ebene1",
	Ebene2 AS "Ebene2",
	Ebene3 AS "Ebene3",
	Ebene4 AS "Ebene4",
	Ebene5 AS "Ebene5",
	Ebene6 AS "Ebene6",
	--Konto AS "Konto_" 
FROM [export_csv].[Belege_EDS_SKR_Bilanz_Teilebestand]
GO