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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[G_L_Entry] AS
SELECT [timestamp]
--      , [Entry No_]
     , [G_L Account No_]
     , [Posting Date]
--      , [Document Type]
     , [Document No_]
     , [Description]
--      , [Bal_ Account No_]
     , [Amount]
     , [Global Dimension 1 Code]
     , [Global Dimension 2 Code]
     , [User ID]
--      , [Source Code]
--      , [System-Created Entry]
--      , [Prior-Year Entry]
--      , [Job No_]
--      , [Quantity]
--      , [VAT Amount]
--      , [Business Unit Code]
--      , [Journal Batch Name]
--      , [Reason Code]
--      , [Gen_ Posting Type]
--      , [Gen_ Bus_ Posting Group]
--      , [Gen_ Prod_ Posting Group]
--      , [Bal_ Account Type]
--      , [Transaction No_]
--      , [Debit Amount]
--      , [Credit Amount]
--      , [Document Date]
--      , [External Document No_]
--      , [Source Type]
--      , [Source No_]
--      , [No_ Series]
--      , [Tax Area Code]
--      , [Tax Liable]
--      , [Tax Group Code]
--      , [Use Tax]
--      , [VAT Bus_ Posting Group]
     , [VAT Prod_ Posting Group]
--      , [Additional-Currency Amount]
--      , [Add_-Currency Debit Amount]
--      , [Add_-Currency Credit Amount]
--      , [Close Income Statement Dim_ ID]
--      , [IC Partner Code]
--      , [Reversed]
--      , [Reversed by Entry No_]
--      , [Reversed Entry No_]
--      , [Dimension Set ID]
--      , [Prod_ Order No_]
--      , [FA Entry Type]
--      , [FA Entry No_]
--      , [Value Entry No_]
--      , [Exch_ Parts Tax Amount]
     , [Branch Code]
--      , [Main Area]
     , [VIN]
     , [Book No_]
     , [Veh_ Source Code]
--      , [Reposted]
--      , [Corrected]
--      , [Correction to curr_ No_]
--      , [Reposting to curr_ No_]
--      , [Register Date]
--      , [Service Ledger Entry No_]
--      , [Factory No_]
--      , [Main Group Code]
--      , [Subgroup Code]
--      , [Line Group Code]
--      , [Deleted G_L Account No_]
--      , [Import Costing No_]
--      , [OPP Pmt_ Import Entry No_]
--      , [OPP Orig_ Currency Code]
--      , [OPP Original Amount (FCY)]
--      , [OPP Posted at]
--      , [OPP Transaction No_]
--      , [OPP Invoice Entrance Date]
--      , [Cash Register Posting]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[G_L_Entry]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO