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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Sales_Invoice_Line] AS
SELECT [timestamp]
     , [Document No_]
     , [Line No_]
--      , [Sell-to Customer No_]
     , [Type]
     , [No_]
--      , [Location Code]
--      , [Posting Group]
--      , [Quantity Disc_ Code]
--      , [Shipment Date]
     , [Description]
--      , [Description 2]
--      , [Unit of Measure]
     , [Quantity]
--      , [Unit Price]
     , [Unit Cost (LCY)]
--      , [VAT _]
--      , [Quantity Disc_ _]
--      , [Line Discount _]
     , [Line Discount Amount]
     , [Amount]
--      , [Amount Including VAT]
--      , [Allow Invoice Disc_]
--      , [Gross Weight]
--      , [Net Weight]
--      , [Units per Parcel]
--      , [Unit Volume]
--      , [Appl_-to Item Entry]
     , [Shortcut Dimension 1 Code]
--      , [Shortcut Dimension 2 Code]
--      , [Price Group Code]
--      , [Allow Quantity Disc_]
--      , [Work Type Code]
--      , [Serial No_]
--      , [Cust__Item Disc_ _]
--      , [Inv_ Discount Amount]
--      , [Drop Shipment]
--      , [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 Clause Code]
--      , [VAT Bus_ Posting Group]
--      , [VAT Prod_ Posting Group]
--      , [Blanket Order No_]
--      , [Blanket Order Line No_]
--      , [VAT Base Amount]
--      , [Unit Cost]
--      , [VAT Identifier]
--      , [IC Partner Ref_ Type]
--      , [IC Partner Reference]
--      , [IC Partner Code]
--      , [Posting Date]
--      , [Dimension Set ID]
--      , [Book No_]
--      , [Variant Code]
--      , [Bin Code]
--      , [Qty_ per Unit of Measure]
--      , [Unit of Measure Code]
--      , [Quantity (Base)]
--      , [Order No_]
--      , [Order Line No_]
--      , [Branch Book No_]
--      , [Currency Rounding Position]
--      , [Order Type]
--      , [Item Type]
--      , [VIN]
--      , [Vehicle Status]
--      , [Registration Date]
--      , [Mileage]
--      , [Expected Shipping Week]
--      , [License No_]
--      , [Indentation]
--      , [Totaling]
     , [Service Order No_]
     , [Service Order Line No_]
--      , [Labor Make Code]
     , [Labor No_]
--      , [Exch_ Parts Tax Base]
--      , [Exch_ Parts Tax _]
--      , [Exch_ Parts Tax Amount]
--      , [Exch_ Parts VAT _]
--      , [Allow Discount]
--      , [Service Type]
--      , [Cockpit Entry No_]
--      , [Printed Deposit Tickets]
--      , [Additional Item]
--      , [Customer Group Code]
--      , [Item Group Code]
--      , [Quantity Multiplier]
--      , [Cockpit Posting Entry No_]
--      , [Fair Deal]
--      , [Automatic Surcharge]
--      , [Service Surcharge Code]
--      , [From Veh_ Opt_Inv_ Doc_ Type]
--      , [From Veh_ Option Inv_ Doc_ No_]
--      , [From Veh_ Opt_Inv_ Doc_ Line]
--      , [From Veh_ Opt_Inv_ Line Type]
--      , [From Veh_ Option Inv_ No_]
--      , [From Veh_ Opt_Inv_ IntCode]
--      , [Sending Required]
--      , [Sales Line Document No_]
--      , [Sales Line Line No_]
--      , [Sales Line Document Type]
--      , [Main Customer]
--      , [Vehicle Unit Price Date]
--      , [Date of Re-motorization]
--      , [Shelf_Bin No_]
--      , [Print Option Line]
--      , [Print Unit Price]
--      , [Veh_ Opt_ Line No_]
--      , [Coded Part Type]
--      , [Shipment No_ not Closed]
--      , [Remaining Qty on Shipment]
--      , [Process Type]
--      , [Running Time]
--      , [VAT Difference Amount]
--      , [Manual VAT Amount]
--      , [VAT Amount]
--      , [Calculated VAT Amount]
--      , [Original Amount]
--      , [Original Amount Incl_ VAT]
--      , [Supply Req_ Template Name]
--      , [Supply Req_ Wksh_ Name]
--      , [Dealer Code]
--      , [Invoice No_]
--      , [Invoice Line No_]
--      , [Pick User ID]
--      , [Factory No_]
--      , [Supply VIN]
--      , [Engine No_]
--      , [Transmission Type Code]
--      , [Key No_]
--      , [Reference License No_]
--      , [Disable for Requisition]
--      , [Promotion]
--      , [Set Vehicle Line No_]
--      , [Promotion Price incl_ VAT]
--      , [Serv_ Preview Line Type]
--      , [Serv_ Preview Type]
--      , [Serv_ Preview Total Line Level]
--      , [Service No_]
--      , [Service Job No_]
--      , [Service Package No_]
--      , [Service Package Version No_]
--      , [Job Details Text Block]
--      , [Internal Comments Text Block]
--      , [EU Tire Data Code]
--      , [Prepayment Line]
--      , [Combined Consumption]
--      , [Cruising Range]
--      , [Efficiency Class]
--      , [Emission Test Procedure]
--      , [Your Reference Line No_]
--      , [Order Manuf_ Item No_]
--      , [Your Reference]
--      , [Parking Bay]
--      , [Parking Lot]
--      , [Autom_ Rounding Disc_ _]
--      , [Autom_ Rounding Disc_ Amount]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Sales_Invoice_Line]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO