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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Vehicle] AS
SELECT [timestamp]
     , [VIN]
     , [Vehicle Status]
     , [Model]
--      , [Search Description]
--      , [Type]
--      , [Class]
--      , [Unit of Measure Code]
     , [Model No_]
--      , [Statistics Group]
--      , [Unit Price]
--      , [Price_Profit Calculation]
--      , [Profit _]
--      , [Unit Cost]
--      , [Standard Cost]
--      , [Last Direct Cost]
--      , [Average Cost]
--      , [Minimum Unit Price]
--      , [Indirect Cost _]
--      , [Vendor No_]
--      , [Vendor Item No_]
--      , [Lead Time Calculation]
--      , [Unit List Price]
--      , [Gross Weight]
--      , [Net Weight]
--      , [Tariff No_]
--      , [Duty Unit Conversion]
--      , [Country Purchased Code]
--      , [Blocked]
--      , [Last Date Modified]
     , [Location Code]
--      , [Price Includes VAT]
--      , [VAT Bus_ Posting Gr_ (Price)]
     , [Gen_ Prod_ Posting Group]
--      , [Picture]
     , [VAT Prod_ Posting Group]
--      , [Country of Origin Code]
--      , [No_ Series]
--      , [Department Code]
     , [Make Code]
--      , [Variant Code]
     , [Customer No_]
--      , [License No_]
--      , [Mileage]
--      , [Annual Mileage]
--      , [Prod_ Year]
     , [Initial Registration]
--      , [No_ of Previous Owners]
--      , [Registration Certificate]
--      , [Data Processing No_]
--      , [Engine Code]
--      , [Engine No_]
--      , [Key No_]
--      , [Vehicle Category Code]
--      , [Emissions Test Category Code]
--      , [Cylinder Capacity (ccm)]
--      , [Vehicle Type Code]
--      , [Labor Type]
--      , [Customer Registration Date]
--      , [Creation Date]
--      , [Model Code]
--      , [Transmission Type Code]
--      , [Engine Type Code]
--      , [Market Segment Code]
--      , [No_ of Cylinders]
--      , [Power (kW)]
--      , [Power (hp)]
--      , [Tires]
--      , [Empty Weight (kg)]
--      , [Total Weight (kg)]
--      , [Roof Load (kg)]
--      , [Trailer Load (kg)]
--      , [Trailer Tongue Load (kg)]
--      , [4WD]
--      , [No_ of Axles]
--      , [Wheel Distance (mm)]
--      , [Front Axle Load (kg)]
--      , [Rear Axle Load (kg)]
--      , [Deregistration Date]
--      , [No_ of Doors]
     , [Dealer Status]
--      , [Own Sale]
--      , [Purchase Invoice Date]
--      , [Neg_ Adjmt_ Date]
--      , [Current Branch Book No_]
--      , [Import Vehicle]
      , [Old Vehicle Status]
     , [Old Customer No_]
--      , [Old Sales Date]
--      , [Old Own Sale]
--      , [Address No_]
--      , [Old Book No_]
--      , [Old Branch Book No_]
     , [Purchase Receipt Date]
     , [Inventory Posting Group]
--      , [Text 1]
--      , [Text 2]
--      , [Yes_No]
--      , [Yes_No 2]
--      , [Date 1]
--      , [Date 2]
--      , [Extra Code 1]
--      , [Extra Code 2]
--      , [Text 3]
--      , [Text 4]
     , [Current Book No_]
--      , [Gross Profit (LCY)]
--      , [Gross Profit _]
     , [Date of Sale]
     , [Current Price Sticker]
--      , [Manual Price Calculation]
--      , [Labor Charging Code]
--      , [Schwacke Code]
--      , [Bin Code]
--      , [Last Time Modified]
--      , [Fabrication Code]
--      , [License No_ Compressed]
--      , [License No_ Check Code]
--      , [VIN Check Code]
--      , [Model Year]
--      , [Top Speed]
--      , [Acceleration]
--      , [Running Time]
--      , [Date of Re-motorization]
--      , [Dealer Request User ID]
--      , [Dealer Customer No_]
--      , [Dealer Salesperson Code]
--      , [Dealer Request Status]
--      , [Dealer Sold Criteria]
--      , [Last Dealer Request Date]
--      , [Retail Customer Name]
--      , [Dealer Note]
--      , [Dealer Sales Order No_]
--      , [Importer Note]
--      , [Dealer Location]
--      , [Retail Customer No_]
--      , [Current Veh_ Owner Address No_]
--      , [No_ of Seats]
--      , [Profile Status]
--      , [Factory No_]
--      , [Max_ Hold Date]
--      , [Dealer Request Code]
--      , [Tracking Code]
--      , [Tracking Comment]
--      , [Ready for Sale]
--      , [Creation Time]
--      , [Contact No_]
--      , [National Tariff No_]
--      , [City Consumption]
--      , [Long-Distance Consumption]
--      , [CO2 Emission City]
--      , [CO2 Emission Long-Distance]
--      , [Particle Mass]
--      , [Logo]
--      , [Emission Standard Code]
--      , [Diesel Particulate Filter]
--      , [Combined Consumption]
--      , [CO2 Emission Combined]
--      , [NOx Emission]
--      , [PM Emission]
--      , [THC Emission]
--      , [NMHC Emission]
--      , [HC+NOx Emission]
--      , [Efficiency Class]
--      , [Emission Test Procedure]
--      , [Cruising Range]
--      , [Telematics Account No_]
--      , [Date Last Maintenance]
--      , [Mileage Last Maintenance]
--      , [Drive]
--      , [Engine Speed Rate Output]
--      , [Maximum Torque]
--      , [Axle -3 Load (kg)]
--      , [Axle -4 Load (kg)]
--      , [Length (mm)]
--      , [Width (mm)]
--      , [Height (mm)]
--      , [Current Vehicle Position]
--      , [Current Parking Bay]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Vehicle]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO