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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Vehicle_Option] AS
SELECT [timestamp]
     , [VIN]
--      , [Line No_]
--      , [Make Code]
--      , [Model No_]
--      , [Option Code]
--      , [Internal Code]
     , [Option Type]
--      , [Short Description]
     , [Description]
--      , [Description 2]
--      , [Unit Price]
--      , [Unit Cost]
--      , [Total Price]
--      , [Total Cost]
--      , [Purchase Discount Amount]
--      , [Purchase Discount _]
--      , [Bill of Materials]
--      , [Series Option]
     , [Built-in Date]
--      , [Type]
--      , [Quantity]
--      , [Copy-to Setting]
--      , [Sorting]
--      , [Total Price Incl_ VAT]
--      , [VAT _]
--      , [VAT Base Amount]
--      , [Differential Taxation]
--      , [List Price]
--      , [List Price Incl_ VAT]
--      , [Inventory Posting Group]
--      , [Gen_ Product Posting Group]
--      , [Service Order No_]
--      , [Option Class]
--      , [Used Car Management Assignment]
--      , [Search Internal Code]
--      , [Replaced Option Code]
--      , [Replaced Internal Code]
--      , [Corrected on]
--      , [Corrected at]
--      , [Description Document Language]
--      , [Description2 Document Language]
--      , [Serial No_]
--      , [Vehicle Ledger Entry No_]
--      , [Print Option Line]
--      , [Print Unit Price]
--      , [Priced Series Option]
--      , [Basic Color]
--      , [Model Line Option]
--      , [Belongs to Model Line]
--      , [Emission Relevant]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Vehicle_Option]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO