C11/System/ARI/Export/SQL/views_load/load.OP_ARI.sql

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_NULLS ON
GO

CREATE
	OR

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

SET QUOTED_IDENTIFIER OFF
GO

SET ANSI_NULLS OFF
GO


GO