C11/System/ARI/Models/mdl/F_Forderungen_queries.sql

CREATE
	OR

ALTER VIEW [load].[current_date_Prognose]
AS
SELECT --[Bundeslaender Id] AS [Bundeslaender Id],
	[Datum] AS [Invoice 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].[OP_ARI]
AS
SELECT --[Entry No] AS [Entry No],
	--[Customer No] AS [Customer No],
	--[Posting Date] AS [Posting Date],
	[Document Type] AS [Document Type],
	[Document No] AS [Document No],
	--[Description] AS [Description],
	--[Sales (lcy)] AS [Sales (lcy)],
	--[Profit (lcy)] AS [Profit (lcy)],
	--[Sell-to Customer No] AS [Sell-to Customer No],
	--[Customer Posting Group] AS [Customer Posting Group],
	--[Global Dimension 1 Code] AS [Global Dimension 1 Code],
	--[Global Dimension 2 Code] AS [Global Dimension 2 Code],
	--[Salesperson Code] AS [Salesperson Code],
	[User Id] AS [User Id],
	--[Source Code] AS [Source Code],
	--[On Hold_ori] AS [On Hold_ori],
	[On Hold] AS [On Hold],
	--[Applies-to Doc Type] AS [Applies-to Doc Type],
	--[Applies-to Doc No] AS [Applies-to Doc No],
	--[Open] AS [Open],
	--[Due Date] AS [Due Date],
	--[Pmt Discount Date] AS [Pmt Discount Date],
	--[Positive] AS [Positive],
	--[Closed By Entry No] AS [Closed By Entry No],
	--[Closed At Date] AS [Closed At Date],
	--[Closed By Amount] AS [Closed By Amount],
	--[Journal Batch Name] AS [Journal Batch Name],
	--[Closed By Amount (lcy)] AS [Closed By Amount (lcy)],
	--[Document Date] AS [Document Date],
	--[No Series] AS [No Series],
	--[Last Issued Reminder Level] AS [Last Issued Reminder Level],
	--[Dimension Set Id] AS [Dimension Set Id],
	--[Direct Debit Mandate Id] AS [Direct Debit Mandate Id],
	--[Customer Group Code] AS [Customer Group Code],
	[Branch Code] AS [Branch Code],
	--[Main Area] AS [Main Area],
	--[Pmt Disc Base] AS [Pmt Disc Base],
	[Vin] AS [Vin],
	--[Factory No] AS [Factory No],
	--[Cash Reg Receipt No] AS [Cash Reg Receipt No],
	[Comment] AS [Comment],
	--[Service Advisor No] AS [Service Advisor No],
	--[Salesperson Code 2] AS [Salesperson Code 2],
	--[Cust Ledger Entry No] AS [Cust Ledger Entry No],
	--[Entry Type] AS [Entry Type],
	--[Document Type_detail_cust] AS [Document Type_detail_cust],
	--[Document No_detail] AS [Document No_detail],
	--[User Id_detail_cust] AS [User Id_detail_cust],
	--[Amount] AS [Amount],
	--[Debit Amount] AS [Debit Amount],
	--[Credit Amount] AS [Credit Amount],
	--[Initial Entry Due Date] AS [Initial Entry Due Date],
	--[Initial Entry Global Dim 1] AS [Initial Entry Global Dim 1],
	--[Initial Entry Global Dim 2] AS [Initial Entry Global Dim 2],
	--[Gen Bus Posting Group] AS [Gen Bus Posting Group],
	--[Gen Prod Posting Group] AS [Gen Prod Posting Group],
	--[Initial Document Type] AS [Initial Document Type],
	--[Saldo_Beleg_1] AS [Saldo_Beleg_1],
	--[Anzahl_Sätze_Entry_No] AS [Anzahl_Sätze_Entry_No],
	[offen] AS [offen],
	[Gesamt offen KD (Info)] AS [Gesamt offen KD (Info)],
	--[Sel Name_alt] AS [Sel Name_alt],
	[Invoice Date] AS [Invoice Date],
	[Hauptbetrieb] AS [Hauptbetrieb],
	[Standort] AS [Standort],
	[Sel Name] AS [Sel Name],
	--[No_Customer] AS [No_Customer],
	--[Name_Customer] AS [Name_Customer],
	--[Last Name_Customer] AS [Last Name_Customer],
	--[First Name_Customer] AS [First Name_Customer],
	[Kunde] AS [Kunde],
	[Beleg] AS [Beleg],
	[Bereich] AS [Bereich],
	[Tage] AS [Tage],
	[Staffel] AS [Staffel],
	--[Salesperson Code_Sales_Inv_Header] AS [Salesperson Code_Sales_Inv_Header],
	--[Service Advisor No_Sales_Inv_Header] AS [Service Advisor No_Sales_Inv_Header],
	--[Code_Salesperson_Purchaser_Verkauf] AS [Code_Salesperson_Purchaser_Verkauf],
	--[Name_Salesperson_Purchaser_Verkauf] AS [Name_Salesperson_Purchaser_Verkauf],
	--[Code_Salesperson_Purchaser_Service] AS [Code_Salesperson_Purchaser_Service],
	--[Name_Salesperson_Purchaser_Service] AS [Name_Salesperson_Purchaser_Service],
	--[No_Employee_Service_Advisor] AS [No_Employee_Service_Advisor],
	--[First Name_Employee_Service_Advisor] AS [First Name_Employee_Service_Advisor],
	--[Last Name_Employee_Service_Advisor] AS [Last Name_Employee_Service_Advisor],
	--[No_Employee_Salesperson_Code] AS [No_Employee_Salesperson_Code],
	--[First Name_Employee_Salesperson_Code] AS [First Name_Employee_Salesperson_Code],
	--[Last Name_Employee_Salesperson_Code] AS [Last Name_Employee_Salesperson_Code],
	--[Sel Name_ori] AS [Sel Name_ori],
	[Mahnstufe] AS [Mahnstufe],
	--[Betrag Rg.] AS [Betrag Rg.],
	[Forderungsart] AS [Forderungsart],
	[Abwarten] AS [Abwarten],
	--[Leasing] AS [Leasing],
	[Message To Recipient] AS [Message To Recipient],
	[Haft_Kasko] AS [Haft_Kasko] 
FROM [export_csv].[OP_ARI]
GO