ETL_DWH_ARI/schema/GC_ETL_ARI/views/xtract.Cust_Ledger_Entry.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Cust_Ledger_Entry] AS
SELECT [timestamp]
     , [Entry No_]
     , [Customer No_]
--      , [Posting Date]
     , [Document Type]
     , [Document No_]
     , [Description]
--      , [Currency Code]
--      , [Sales (LCY)]
--      , [Profit (LCY)]
--      , [Inv_ Discount (LCY)]
--      , [Sell-to Customer No_]
--      , [Customer Posting Group]
--      , [Global Dimension 1 Code]
--      , [Global Dimension 2 Code]
     , [Salesperson Code]
     , [User ID]
--      , [Source Code]
     , [On Hold]
--      , [Applies-to Doc_ Type]
--      , [Applies-to Doc_ No_]
     , [Open]
     , [Due Date]
--      , [Pmt_ Discount Date]
--      , [Original Pmt_ Disc_ Possible]
--      , [Pmt_ Disc_ Given (LCY)]
--      , [Positive]
--      , [Closed by Entry No_]
--      , [Closed at Date]
--      , [Closed by Amount]
--      , [Applies-to ID]
--      , [Journal Batch Name]
--      , [Reason Code]
--      , [Bal_ Account Type]
--      , [Bal_ Account No_]
--      , [Transaction No_]
--      , [Closed by Amount (LCY)]
--      , [Document Date]
--      , [External Document No_]
--      , [Calculate Interest]
--      , [Closing Interest Calculated]
--      , [No_ Series]
--      , [Closed by Currency Code]
--      , [Closed by Currency Amount]
--      , [Adjusted Currency Factor]
--      , [Original Currency Factor]
--      , [Remaining Pmt_ Disc_ Possible]
--      , [Pmt_ Disc_ Tolerance Date]
--      , [Max_ Payment Tolerance]
     , [Last Issued Reminder Level]
--      , [Accepted Payment Tolerance]
--      , [Accepted Pmt_ Disc_ Tolerance]
--      , [Pmt_ Tolerance (LCY)]
--      , [Amount to Apply]
--      , [IC Partner Code]
--      , [Applying Entry]
--      , [Reversed]
--      , [Reversed by Entry No_]
--      , [Reversed Entry No_]
--      , [Prepayment]
--      , [Payment Method Code]
--      , [Applies-to Ext_ Doc_ No_]
--      , [Recipient Bank Account]
     , [Message to Recipient]
--      , [Exported to Payment File]
--      , [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]
--      , [Discount Accumulated _]
     , [Service Advisor No_]
--      , [Prepayment Order No_]
--      , [Salesperson Code 2]
--      , [OPP Pmt_ Import Entry No_]
--      , [OPP Original Pmt_ Discount _]
--      , [OPP Orig_ Pmt_ Disc_Poss_(LCY)]
--      , [OPP Reopen-to ID]
--      , [OPP Payback]
--      , [OPP Posted on]
--      , [OPP Association No_]
--      , [OPP Transaction No_]
--      , [OPP Mandate ID]
--      , [OPP Installment Show Control]
--      , [OPP Installment Entry]
--      , [OPP Installment Reversal]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Cust_Ledger_Entry]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO