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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Vehicle_Ledger_Entry] AS
SELECT [timestamp]
--      , [Entry No_]
     , [Entry Type]
     , [Document No_]
     , [Posting Date]
     , [Book No_]
     , [VIN]
--      , [Description]
--      , [Quantity]
--      , [Direct Unit Cost]
--      , [Unit Cost]
--      , [Total Cost]
--      , [Unit Price]
--      , [Total Price]
--      , [Department Code]
     , [Make Code]
--      , [User ID]
--      , [Source Code]
--      , [Journal Batch Name]
--      , [Reason Code]
--      , [Positive]
--      , [Document Date]
--      , [External Document No_]
--      , [No_ Series]
--      , [Type]
--      , [No_]
--      , [License No_]
--      , [Location Code]
     , [Date of Sale]
--      , [Open]
     , [Current Sales Ledger Entry]
--      , [Credit Memo]
--      , [Current Purchase Ledger Entry]
--      , [Sold]
--      , [Purchase Date]
--      , [Item Ledger Entry No_]
      , [Gen_ Prod_ Posting Group]
     , [VAT Prod_ Posting Group]
--      , [Phys_ Inventory Ledger Entry]
--      , [Bal_ Account No_]
--      , [VAT Calculation Type]
--      , [Neg_ Adjmt_ Date]
--      , [Taken Out of Inventory]
     , [Gen_ Bus_ Posting Group]
--      , [VAT Bus_ Posting Group]
     , [Salespers__Purch_ Code]
--      , [Reversed]
--      , [Reversed by Entry No_]
--      , [Reversed Entry No_]
--      , [Salesperson Code 2]
--      , [Chain Book No_]
--      , [Trade-In for Book No_]
--      , [Trade-In for VIN]
--      , [Model No_]
--      , [Vehicle]
--      , [Vehicle Status]
--      , [Vehicle Category Code]
--      , [Vehicle Type Code]
--      , [Market Segment Code]
--      , [Vehicle Portion]
--      , [Manuf_ Option Portion]
--      , [Own Option Portion]
--      , [Misc_ Portion]
--      , [Veh_ Transfer Portion]
--      , [Calculated Costs Portion]
--      , [Branch Fee Amount]
--      , [Service Order No_]
--      , [Service Order Line No_]
--      , [Service Order Completed]
--      , [Value Increasing Measure]
--      , [Branch Book No_]
--      , [Add_-Currency Direct Unit Cost]
--      , [Add_-Curr_ Unit Cost]
--      , [Add_-Curr_ Total Cost]
--      , [Add_ Curr_ Unit Price]
--      , [Add_-Currency Total Price]
--      , [Add_ Curr_ Vehicle Portion]
--      , [Mfg_ Option Add_-Curr_ Rate]
--      , [Add_ Curr_ Own Option Portion]
--      , [Add_ Curr_ Misc_ Portion]
--      , [Transfer Fees Add_-Curr_ Rate]
--      , [Add_-Curr_ Calc_ Costs Portion]
--      , [Source Type]
--      , [Source No_]
--      , [Source No_ (Payment)]
--      , [Source Group Code]
--      , [Main Customer]
--      , [Main Area]
--      , [Document Type]
--      , [Main Group Code]
--      , [Subgroup Code]
--      , [Line Group Code]
--      , [Item Group Code]
--      , [Trade-In for Document No_]
      , [Line Type]
--      , [Assoc_ No_]
--      , [Not Relevant for Statistics]
--      , [Serv_ Campaign No_]
--      , [Serv_ Camp_ Counter]
--      , [Branch Code]
--      , [Sales Incentive Group]
--      , [Bin Code]
--      , [Sales Incentive No_]
--      , [Item Charge No_]
--      , [Veh_ Status Change]
--      , [Sales Department Code]
--      , [Sales Branch Code]
--      , [G_L Entry No_]
--      , [Excessive Trade In-Price]
--      , [Service Advisor No_]
--      , [Dimension Set ID]
--      , [Sales Incentive Entry No_]
--      , [Factory No_]
--      , [Campaign Reversion]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Vehicle_Ledger_Entry]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO