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

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

SELECT [client_db]
     , [internal_number]
     , [vin]
     , [license_plate]
--      , [license_plate_country]
--      , [license_plate_season]
     , [make_number]
--      , [free_form_make_text]
     , [model_code]
     , [free_form_model_text]
--      , [is_roadworthy]
--      , [is_customer_vehicle]
     , [dealer_vehicle_type]
     , [dealer_vehicle_number]
     , [first_registration_date]
--      , [readmission_date]
--      , [next_service_date]
--      , [next_service_km]
--      , [next_service_miles]
--      , [production_year]
     , [owner_number]
     , [holder_number]
     , [previous_owner_number]
--      , [previous_owner_counter]
--      , [last_holder_change_date]
--      , [german_kba_hsn]
--      , [german_kba_tsn]
--      , [austria_nat_code]
--      , [is_prefer_km]
     , [mileage_km]
--      , [mileage_miles]
--      , [odometer_reading_date]
--      , [engine_number]
--      , [gear_number]
--      , [unloaded_weight]
--      , [gross_vehicle_weight]
--      , [power_kw]
--      , [cubic_capacity]
--      , [is_all_accidents_repaired]
--      , [accidents_counter]
--      , [has_tyre_pressure_sensor]
--      , [carkey_number]
--      , [internal_source_flag]
--      , [emission_code]
--      , [first_sold_country]
--      , [first_sold_dealer_code]
--      , [body_paint_code]
     , [body_paint_description]
--      , [is_body_paint_metallic]
--      , [interior_paint_code]
--      , [interior_paint_description]
--      , [trim_code]
--      , [trim_description]
--      , [fine_dust_label]
--      , [internal_assignment]
--      , [ricambi_free_input]
--      , [document_number]
     , [salesman_number]
--      , [sale_date]
--      , [next_emission_test_date]
--      , [next_general_inspection_date]
--      , [next_rust_inspection_date]
--      , [next_exceptional_inspection_da]
--      , [last_change_date]
--      , [last_change_employee_no]
--      , [created_date]
--      , [created_employee_no]
--      , [subsidiary]
--      , [last_change_subsidiary]
--      , [lock_by_workstation]
--      , [lock_time]
--      , [lock_trace]
--      , [lock_trigger]
--      , [lock_by_employee]
--      , [lock_sourcecode]

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

GO