123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447 |
- 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]
- AS
- SELECT --[Konto_Nr] AS [Konto_Nr],
- --[Konto_Bezeichnung] AS [Konto_Bezeichnung],
- --[Konto_Art] AS [Konto_Art],
- [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],
- [Konto_Art] AS [GuV_Bilanz],
- left ( [Konto_Nr] , 1 ) AS [Susa],
- [Konto_Nr] AS [Acct Nr],
- [Konto_Nr] + ' - ' + [Konto_Bezeichnung] AS [Konto]
- FROM [export_csv].[Kontenrahmen]
- GO
- CREATE
- OR
- ALTER VIEW [load].[Kontenrahmen_STK]
- AS
- SELECT --[Konto_Nr] AS [Konto_Nr],
- --[Konto_Bezeichnung] AS [Konto_Bezeichnung],
- --[Konto_Art] AS [Konto_Art],
- [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],
- [GuV_Bilanz] AS [GuV_Bilanz],
- [Susa] AS [Susa],
- [Konto_Nr] AS [Acct Nr],
- [Konto_Nr] + ' - ' + [Konto_Bezeichnung] AS [Konto]
- FROM [export_csv].[Kontenrahmen_STK]
- GO
- CREATE
- OR
- ALTER VIEW [load].[Belege]
- AS
- SELECT --[No] AS [No],
- --[Name] AS [Name],
- --[Account Type] AS [Account Type],
- --[Income Balance] AS [Income Balance],
- --[Last Date Modified] AS [Last Date Modified],
- --[Entry No] AS [Entry No],
- --[G L Account No] AS [G L Account No],
- --[Posting Date] AS [Posting Date],
- --[Document Type] AS [Document Type],
- --[Document No] AS [Document No],
- --[Description] AS [Description],
- --[Bal Account No] AS [Bal Account No],
- --[Department Code] AS [Department Code],
- --[Make Code] AS [Make Code],
- --[User Id] AS [User Id],
- --[Source Code] AS [Source Code],
- --[Quantity] AS [Quantity],
- --[Reason Code] AS [Reason Code],
- --[Gen Posting Type] AS [Gen Posting Type],
- --[Gen Bus Posting Group] AS [Gen Bus Posting Group],
- --[Gen Prod Posting Group] AS [Gen Prod Posting Group],
- --[Bal Account Type] AS [Bal Account Type],
- --[Transaction No] AS [Transaction No],
- --[Document Date] AS [Document Date],
- --[External Document No] AS [External Document No],
- --[Source Type] AS [Source Type],
- --[Source No] AS [Source No],
- --[No Series] AS [No Series],
- --[Branch Code] AS [Branch Code],
- --[Main Area] AS [Main Area],
- --[Vin] AS [Vin],
- --[Book No] AS [Book No],
- --[Veh Source Code] AS [Veh Source Code],
- --[Reposted] AS [Reposted],
- --[Corrected] AS [Corrected],
- --[Correction To Curr No] AS [Correction To Curr No],
- --[Reposting To Curr No] AS [Reposting To Curr No],
- --[Code] AS [Code],
- [Bookkeep Date] AS [Bookkeep Date],
- [Betrieb] AS [Betrieb Nr],
- [Acct Nr] AS [Acct Nr],
- [Betrag] AS [Betrag],
- --[Amount_1] AS [Amount_1],
- [Text] AS [Text],
- [Hauptbetrieb] AS [Hauptbetrieb],
- [Marke] AS [Marke]
- FROM [export_csv].[Belege]
- GO
- CREATE
- OR
- ALTER VIEW [load].[NW_GW_GK_Stk_fuer_FIBU_Betrag]
- AS
- SELECT --[Entry No] AS [Entry No],
- --[Entry Type] AS [Entry Type],
- --[Document No] AS [Document No],
- --[Posting Date] AS [Posting Date],
- --[Book No] AS [Book No],
- --[Vin] AS [Vin],
- --[Description] AS [Description],
- --[Quantity] AS [Quantity],
- --[Department Code_veh_ledger_entry] AS [Department Code_veh_ledger_entry],
- --[Make Code] AS [Make Code],
- --[Document Date] AS [Document Date],
- --[Type] AS [Type],
- --[No] AS [No],
- --[License No] AS [License No],
- --[Location Code] AS [Location Code],
- [Date Of Sale] AS [Bookkeep Date],
- --[Open] AS [Open],
- --[Current Sales Ledger Entry] AS [Current Sales Ledger Entry],
- --[Credit Memo] AS [Credit Memo],
- --[Sold] AS [Sold],
- --[Gen Prod Posting Group] AS [Gen Prod Posting Group],
- --[Vat Prod Posting Group] AS [Vat Prod Posting Group],
- --[Bal Account No] AS [Bal Account No],
- --[Gen Bus Posting Group] AS [Gen Bus Posting Group],
- --[Vat Bus Posting Group] AS [Vat Bus Posting Group],
- --[Salespers Purch Code] AS [Salespers Purch Code],
- --[Model No] AS [Model No],
- --[Vehicle] AS [Vehicle],
- --[Vehicle Status] AS [Vehicle Status],
- --[Branch Book No] AS [Branch Book No],
- --[Source Type] AS [Source Type],
- --[Source No] AS [Source No],
- --[Source No (payment)] AS [Source No (payment)],
- --[Source Group Code] AS [Source Group Code],
- --[Main Customer] AS [Main Customer],
- --[Main Area] AS [Main Area],
- --[Document Type] AS [Document Type],
- --[Value Ledger Entry No] AS [Value Ledger Entry No],
- --[Veh Status Change] AS [Veh Status Change],
- --[Item Ledger Entry Type] AS [Item Ledger Entry Type],
- --[Inventory Posting Group] AS [Inventory Posting Group],
- --[Source Posting Group] AS [Source Posting Group],
- --[Valued Quantity] AS [Valued Quantity],
- --[Invoiced Quantity] AS [Invoiced Quantity],
- --[Cost Posted To G L] AS [Cost Posted To G L],
- --[Amount_Value_ledger_entry] AS [Amount_Value_ledger_entry],
- --[Amount] AS [Amount],
- --[Variance Type] AS [Variance Type],
- --[Item Type_value_ledger_entry] AS [Item Type_value_ledger_entry],
- --[Menge_ori] AS [Menge_ori],
- --[Summe_Menge] AS [Summe_Menge],
- --[Menge] AS [Menge],
- --[Summe (Menge) Nr.4] AS [Summe (Menge) Nr.4],
- --[Summe (Menge) Nr.3] AS [Summe (Menge) Nr.3],
- --[G L Account No] AS [G L Account No],
- --[Source Code] AS [Source Code],
- --[Veh Source Code] AS [Veh Source Code],
- --[Document No_GL_Entry] AS [Document No_GL_Entry],
- --[Department Code] AS [Department Code],
- --[Vat Prod Posting Group_GL_Account] AS [Vat Prod Posting Group_GL_Account],
- --[Branch Code] AS [Branch Code],
- --[Geschäftsart] AS [Geschäftsart],
- --[Filter_Document_No] AS [Filter_Document_No],
- --[Filter_Vehicle_Source_Code] AS [Filter_Vehicle_Source_Code],
- --[Jahr] AS [Jahr],
- [Betrieb Nr] AS [Betrieb Nr],
- --[Konto Nr] AS [Konto Nr],
- --[Description_GL_Entry] AS [Description_GL_Entry],
- [Text] AS [Text],
- [Betrag] AS [Betrag],
- [Hauptbetrieb] AS [Hauptbetrieb],
- [Marke] AS [Marke],
- [Acct Nr] AS [Acct Nr]
- FROM [export_csv].[NW_GW_GK_Stk_fuer_FIBU_Betrag]
- GO
- CREATE
- OR
- ALTER VIEW [load].[NW_GW_GK_Stk_fuer_FIBU_Menge]
- AS
- SELECT --[Entry No] AS [Entry No],
- --[Entry Type] AS [Entry Type],
- --[Document No] AS [Document No],
- --[Posting Date] AS [Posting Date],
- --[Book No] AS [Book No],
- --[Vin] AS [Vin],
- --[Description] AS [Description],
- --[Quantity] AS [Quantity],
- --[Department Code_veh_ledger_entry] AS [Department Code_veh_ledger_entry],
- --[Make Code] AS [Make Code],
- --[Document Date] AS [Document Date],
- --[Type] AS [Type],
- --[No] AS [No],
- --[License No] AS [License No],
- --[Location Code] AS [Location Code],
- [Date Of Sale] AS [Bookkeep Date],
- --[Open] AS [Open],
- --[Current Sales Ledger Entry] AS [Current Sales Ledger Entry],
- --[Credit Memo] AS [Credit Memo],
- --[Sold] AS [Sold],
- --[Gen Prod Posting Group] AS [Gen Prod Posting Group],
- --[Vat Prod Posting Group] AS [Vat Prod Posting Group],
- --[Bal Account No] AS [Bal Account No],
- --[Gen Bus Posting Group] AS [Gen Bus Posting Group],
- --[Vat Bus Posting Group] AS [Vat Bus Posting Group],
- --[Salespers Purch Code] AS [Salespers Purch Code],
- --[Model No] AS [Model No],
- --[Vehicle] AS [Vehicle],
- --[Vehicle Status] AS [Vehicle Status],
- --[Branch Book No] AS [Branch Book No],
- --[Source Type] AS [Source Type],
- --[Source No] AS [Source No],
- --[Source No (payment)] AS [Source No (payment)],
- --[Source Group Code] AS [Source Group Code],
- --[Main Customer] AS [Main Customer],
- --[Main Area] AS [Main Area],
- --[Document Type] AS [Document Type],
- --[Value Ledger Entry No] AS [Value Ledger Entry No],
- --[Veh Status Change] AS [Veh Status Change],
- --[Item Ledger Entry Type] AS [Item Ledger Entry Type],
- --[Inventory Posting Group] AS [Inventory Posting Group],
- --[Source Posting Group] AS [Source Posting Group],
- --[Valued Quantity] AS [Valued Quantity],
- --[Invoiced Quantity] AS [Invoiced Quantity],
- --[Cost Posted To G L] AS [Cost Posted To G L],
- --[Amount_Value_ledger_entry] AS [Amount_Value_ledger_entry],
- --[Amount] AS [Amount],
- --[Variance Type] AS [Variance Type],
- --[Item Type_value_ledger_entry] AS [Item Type_value_ledger_entry],
- --[Menge_ori] AS [Menge_ori],
- --[Summe_Menge] AS [Summe_Menge],
- --[Menge_alt] AS [Menge_alt],
- --[Summe (Menge) Nr.4] AS [Summe (Menge) Nr.4],
- --[Summe (Menge) Nr.3] AS [Summe (Menge) Nr.3],
- --[G L Account No] AS [G L Account No],
- --[Source Code] AS [Source Code],
- --[Veh Source Code] AS [Veh Source Code],
- --[Document No_GL_Entry] AS [Document No_GL_Entry],
- --[Department Code] AS [Department Code],
- --[Vat Prod Posting Group_GL_Account] AS [Vat Prod Posting Group_GL_Account],
- --[Branch Code] AS [Branch Code],
- --[Geschäftsart] AS [Geschäftsart],
- --[Filter_Document_No] AS [Filter_Document_No],
- --[Filter_Vehicle_Source_Code] AS [Filter_Vehicle_Source_Code],
- --[Jahr] AS [Jahr],
- [Betrieb Nr] AS [Betrieb Nr],
- --[Konto Nr] AS [Konto Nr],
- --[Description_GL_Entry] AS [Description_GL_Entry],
- [Text] AS [Text],
- [Menge_FIBU] AS [Menge_FIBU],
- [Hauptbetrieb] AS [Hauptbetrieb],
- [Marke] AS [Marke],
- [Acct Nr] AS [Acct Nr]
- FROM [export_csv].[NW_GW_GK_Stk_fuer_FIBU_Menge]
- GO
- CREATE
- OR
- ALTER VIEW [load].[Service_Plan_ohne_FL]
- AS
- SELECT [Hauptbetrieb] AS [Hauptbetrieb],
- [Betrieb Nr] AS [Betrieb Nr],
- [Kostenstelle] AS [Kostenstelle],
- [Ebene1] AS [Ebene1],
- [Ebene2] AS [Ebene2],
- [Ebene3] AS [Ebene3],
- --[Gesamt] AS [Gesamt],
- --[Periode13] AS [Periode13],
- --[Jan] AS [Jan],
- --[Feb] AS [Feb],
- --[Mar] AS [Mar],
- --[Apr] AS [Apr],
- --[Mai] AS [Mai],
- --[Jun] AS [Jun],
- --[Jul] AS [Jul],
- --[Aug] AS [Aug],
- --[Sep] AS [Sep],
- --[Okt] AS [Okt],
- --[Nov] AS [Nov],
- --[Dez] AS [Dez],
- [Version] AS [Version],
- --[Jahr] AS [Jahr],
- --[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],
- --[Monat] AS [Monat],
- --[Plan] AS [Plan_ori],
- [Plan_ori] * - 1 AS [Plan]
- FROM [export_csv].[Service_Plan_ohne_FL]
- GO
|