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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[G_L_Account] AS
SELECT [timestamp]
     , [No_]
     , [Name]
--      , [Search Name]
     , [Account Type]
     , [Global Dimension 1 Code]
     , [Global Dimension 2 Code]
     , [Income_Balance]
--      , [Debit_Credit]
--      , [No_ 2]
--      , [Blocked]
--      , [Direct Posting]
--      , [Reconciliation Account]
--      , [New Page]
--      , [No_ of Blank Lines]
--      , [Indentation]
--      , [Last Date Modified]
--      , [Totaling]
--      , [Consol_ Translation Method]
--      , [Consol_ Debit Acc_]
--      , [Consol_ Credit Acc_]
--      , [Gen_ Posting Type]
     , [Gen_ Bus_ Posting Group]
     , [Gen_ Prod_ Posting Group]
--      , [Picture]
--      , [Automatic Ext_ Texts]
--      , [Department Posting]
--      , [Make Posting]
--      , [Tax Area Code]
--      , [Tax Liable]
--      , [Tax Group Code]
--      , [VAT Bus_ Posting Group]
--      , [VAT Prod_ Posting Group]
--      , [Exchange Rate Adjustment]
--      , [Default IC Partner G_L Acc_ No]
--      , [Cost Type Code]
--      , [Make Account Code]
--      , [Vehicle Posting]
--      , [Book No_ Posting]
--      , [Account Group]
--      , [G_L Account for Reconciliation]
--      , [Recon_ Group Field No_ 1]
--      , [Recon_ Group Field No_ 2]
--      , [Recon_ Group Field No_ 3]
--      , [Recon_ Group Field No_ 4]
--      , [Recon_ Group Field No_ 5]
--      , [OPP Dim_ for System Entries]
--      , [OPP Check Tax Key]
--      , [OPP Last Posting at]
--      , [OPP Acc_ Schedule Name 1]
--      , [OPP Acc_ Schedule Name 2]
--      , [OPP Acc_ Schedule Name 3]
--      , [OPP Acc_ Schedule Line 1]
--      , [OPP Acc_ Schedule Line 2]
--      , [OPP Acc_ Schedule Line 3]
--      , [OPP Account Group 1]
--      , [OPP Account Group 2]
--      , [OPP Account Group 3]
--      , [OPP Account Group 4]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[G_L_Account]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO