C11/System/ARI/SQL/schema/GC_ETL_ARI/views/xtract.Service_Line.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Service_Line] AS
SELECT [timestamp]
     , [Document Type]
     , [Document No_]
     , [Line No_]
--      , [Sell-to Customer No_]
--      , [Type]
--      , [No_]
--      , [Location Code]
--      , [Posting Group]
--      , [Quantity Disc_ Code]
--      , [Order Date]
--      , [Description]
--      , [Description 2]
--      , [Unit of Measure]
--      , [Quantity]
--      , [Outstanding Quantity]
--      , [Qty_ to Invoice]
--      , [Qty_ to Ship]
--      , [Unit Price]
--      , [Unit Cost (LCY)]
--      , [VAT _]
--      , [Quantity Disc_ _]
--      , [Line Discount _]
--      , [Line Discount Amount]
     , [Amount]
--      , [Amount Including VAT]
--      , [Gross Weight]
--      , [Net Weight]
--      , [Units per Parcel]
--      , [Unit Volume]
--      , [Appl_-to Item Entry]
--      , [Department Code]
--      , [Make Code]
--      , [Price Group Code]
--      , [Allow Quantity Disc_]
--      , [Serial No_]
--      , [Cust__Item Disc_ _]
--      , [Outstanding Amount]
--      , [Qty_ Shipped Not Invoiced]
--      , [Shipped Not Invoiced]
--      , [Quantity Shipped]
--      , [Quantity Invoiced]
--      , [Profit _]
--      , [Bill-to Customer No_]
--      , [Gen_ Bus_ Posting Group]
--      , [Gen_ Prod_ Posting Group]
--      , [VAT Calculation Type]
--      , [Transaction Type]
--      , [Transport Method]
--      , [Attached to Line No_]
--      , [Exit Point]
--      , [Area]
--      , [Transaction Specification]
--      , [Tax Area Code]
--      , [Tax Liable]
--      , [Tax Group Code]
--      , [VAT Bus_ Posting Group]
--      , [VAT Prod_ Posting Group]
--      , [Currency Code]
--      , [Outstanding Amount (LCY)]
--      , [Shipped Not Invoiced (LCY)]
--      , [Reserved Quantity]
--      , [Reserve]
--      , [VAT Base Amount]
--      , [Unit Cost]
--      , [System-Created Entry]
--      , [Activity Creation]
--      , [Appointment Line]
--      , [Option Code]
--      , [Dimension Set ID]
--      , [Last Changed]
--      , [Virtual Record]
--      , [Book No_]
--      , [Variant Code]
--      , [Bin Code]
--      , [Qty_ per Unit of Measure]
--      , [Planned]
--      , [Unit of Measure Code]
--      , [Quantity (Base)]
--      , [Outstanding Qty_ (Base)]
--      , [Qty_ to Invoice (Base)]
--      , [Qty_ to Ship (Base)]
--      , [Qty_ Shipped Not Invd_ (Base)]
--      , [Qty_ Shipped (Base)]
--      , [Qty_ Invoiced (Base)]
--      , [Reserved Qty_ (Base)]
--      , [Appl_-from Item Entry]
--      , [Qty_ Invoiced (Hour)]
--      , [No Service Surcharge]
--      , [Service Job No_]
--      , [Standard Time]
--      , [Qty_ per Hour]
--      , [Qty_ (Hour)]
--      , [Outstanding Qty_ (Hour)]
--      , [Qty_ Rcd_ Not Invoiced (Hour)]
--      , [Qty_ Shipped (Hour)]
--      , [Package No_]
--      , [Data Make Code]
--      , [Vehicle Appointment Code]
--      , [Next Appointment on]
--      , [Next Appointment at Mileage]
--      , [Additional Item]
--      , [Quantity Multiplier]
--      , [Package Version No_]
--      , [No Charge]
--      , [Allow Discount]
--      , [Exch_ Parts Tax Base]
--      , [Exch_ Parts Tax _]
--      , [Exch_ Parts Tax Amount]
--      , [Exch_ Parts VAT _]
--      , [Service Posting Group]
--      , [Sales Department Code]
--      , [Fixed Price]
--      , [Standard Time Type]
--      , [Fair Deal]
--      , [Text Line Link]
--      , [Surcharge Code]
--      , [Post with Book No_]
--      , [Sending Required]
--      , [Suppress in Order]
--      , [Purchase Receipt]
--      , [Purch_ Rcpt_ Line]
--      , [Find No_]
--      , [Dimension Change]
--      , [Value Increasing Measure]
--      , [Inventory Posting Group Type]
--      , [Inventory Posting Group]
--      , [Shelf_Bin No_]
--      , [Sales Branch Code]
--      , [Coded Part Type]
--      , [Line Document Status]
--      , [Process Type]
--      , [Availability Entry No_]
--      , [Next Appoint_ at Running Time]
--      , [VAT Difference Amount]
--      , [Manual VAT Amount]
--      , [VAT Amount]
--      , [Calculated VAT Amount]
--      , [Original Amount]
--      , [Original Amount Incl_ VAT]
--      , [Req_ Worksheet Name]
--      , [Disable for Requisition]
--      , [Labor Standard Time Type]
--      , [Open Autom_ Stock Info_ Page]
--      , [Blocked]
--      , [Serv_ Contract Type]
--      , [VAT Identifier]
--      , [Has Fixed Price]
--      , [EU Tire Data Code]
--      , [Resource No_]
--      , [Pickup Date]
--      , [Availability]
--      , [Autom_ Rounding Disc_ _]
--      , [Autom_ Rounding Disc_ Amount]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Service_Line]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO