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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Service_Ledger_Entry] AS
SELECT [timestamp]
     , [Entry No_]
     , [Order No_]
     , [Posting Date]
     , [Document No_]
     , [Type]
     , [No_]
--      , [Description]
--      , [Quantity]
--      , [Direct Unit Cost]
--      , [Unit Cost]
--      , [Total Cost]
--      , [Unit Price]
     , [Total Price]
--      , [Unit of Measure Code]
--      , [Res_ Efficiency Level _]
--      , [Location Code]
--      , [Chargeable]
--      , [Resource Type]
--      , [Service Posting Group]
--      , [Department Code]
--      , [Make Code]
--      , [Work Type Code]
--      , [Price Group Code]
--      , [User ID]
--      , [Source Code]
--      , [Serial No_]
--      , [Related to Budget]
--      , [Amt_ to Post to G_L]
--      , [Amt_ Posted to G_L]
--      , [Amt_ to Recognize]
--      , [Amt_ Recognized]
--      , [Entry Type]
--      , [Positive]
     , [Qty_ Evaluated]
--      , [Journal Batch Name]
--      , [Reason Code]
--      , [Transaction Type]
--      , [Transport Method]
--      , [Country Code]
--      , [Gen_ Bus_ Posting Group]
     , [Gen_ Prod_ Posting Group]
--      , [Entry_Exit Point]
--      , [Document Date]
--      , [External Document No_]
--      , [Area]
--      , [Transaction Specification]
--      , [No_ Series]
--      , [Add_-Curr_ Total Cost]
--      , [Add_-Currency Total Price]
--      , [Add_-Curr_ Amount to Recognize]
--      , [Add_-Curr_ Amt_ to Post to G_L]
--      , [Add_-Curr_ Amount Recognized]
--      , [Add_-Curr_ Amt_ Posted to G_L]
--      , [Corrected]
--      , [Dimension Set ID]
--      , [Book No_]
--      , [Variant Code]
--      , [Bin Code]
--      , [Qty_ per Unit of Measure]
--      , [Quantity (Base)]
--      , [Time Type]
--      , [Service Job No_]
--      , [Assoc_ Entry]
--      , [Vehicle Type]
--      , [Package No_]
--      , [Sales Department Code]
--      , [WIP Posting]
--      , [Closed]
--      , [VIN]
--      , [Assoc_ Vehicle Entry No_]
--      , [Data Make Code]
--      , [Qty_ per Hour]
--      , [Qty_ (Hour)]
--      , [Item Group Code]
--      , [Document Type]
--      , [Vehicle Type Code]
--      , [Vehicle Category Code]
--      , [Vehicle Status]
--      , [Branch Book No_]
--      , [Market Segment Code]
--      , [Main Group Code]
--      , [Subgroup Code]
--      , [Line Group Code]
--      , [Customer Group Code]
--      , [Charging Group No_]
--      , [Standard Time]
--      , [Standard Time Type]
--      , [Source Type]
--      , [Source No_]
--      , [Source No_ (Payment)]
--      , [Main Customer]
--      , [Order Line No_]
--      , [Time From]
--      , [Time Until]
--      , [Internal Charged]
--      , [Branch Code]
--      , [Standard Time (Hours)]
--      , [Order Completed]
--      , [Value Increasing Measure]
--      , [Time Clock Entry No_]
--      , [Inventory Posting Group Type]
--      , [Inventory Posting Group]
--      , [Option Code]
--      , [Sales Branch Code]
--      , [Posting Date (last Invoice)]
--      , [Open]
--      , [Closed by Entry No_]
--      , [Closed at Date]
--      , [Closed by Quantity]
--      , [Open Quantity]
--      , [Int_ Customer Portion _]
--      , [Int_ Chargeable Amount]
--      , [Amount Internally (Add_ Curr_)]
--      , [Int_ Charged Amount]
--      , [Add_-Curr_ Int_ Charged Amount]
--      , [Labor Standard Time Type]
--      , [Salesperson__Purch_ Code]
--      , [Service Advisor No_]
--      , [Employee No_]
--      , [Task Type Code]
--      , [License No_]
--      , [Mileage]
--      , [Running Time]
     , [Discount Amount]
--      , [Package Version No_]
--      , [Creation Date]
--      , [Creation Time]
--      , [Res_ Assignm_ Posted]
--      , [Cust_ Split Portion _]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Service_Ledger_Entry]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO