ETL_DWH_LOCOSOFT/schema/GC_ETL_LOCOSOFT/views/xtract.models.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[models] AS

SELECT [client_db]
     , [make_number]
     , [model_code]
--      , [is_actual_model]
--      , [model_currently_available]
--      , [replacing_model_code]
     , [description]
--      , [gear_count]
--      , [seat_count]
--      , [door_count]
--      , [cylinder_count]
--      , [vehicle_body]
--      , [model_labour_group]
--      , [has_hour_meter]
--      , [source_extern]
--      , [free_form_vehicle_class]
--      , [vin_begin]
--      , [vehicle_pool_code]
--      , [vehicle_pool_engine_code]
--      , [is_manual_transmission]
--      , [is_all_wheel_drive]
--      , [is_plugin_hybride]
--      , [unloaded_weight]
--      , [gross_vehicle_weight]
--      , [power_kw]
--      , [power_kw_at_rotation]
--      , [cubic_capacity]
--      , [german_kba_hsn]
--      , [german_kba_tsn]
--      , [annual_tax]
--      , [model_year]
--      , [model_year_postfix]
--      , [suggested_net_retail_price]
--      , [suggested_net_shipping_cost]
--      , [european_pollutant_class]
--      , [efficiency_class]
--      , [emission_code]
--      , [carbondioxid_emission]
--      , [nox_exhoust]
--      , [particle_exhoust]
--      , [external_schwacke_code]
--      , [skr_carrier_flag]
--      , [free_form_model_specification]
--      , [external_technical_type]
--      , [european_fuel_consumption_over]
--      , [european_fuel_consumption_coun]
--      , [european_fuel_consumption_city]
--      , [energy_consumption]
--      , [insurance_class_liability]
--      , [insurance_class_part_comprehen]
--      , [insurance_class_full_comprehen]

FROM [LOCOSOFT].[dbo].[models]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO