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

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

SELECT [client_db]
     , [customer_number]
     , [subsidiary]
--      , [is_supplier]
--      , [is_natural_person]
--      , [is_dummy_customer]
--      , [salutation_code]
--      , [name_prefix]
     , [first_name]
     , [family_name]
--      , [name_postfix]
--      , [country_code]
     , [zip_code]
--      , [home_city]
--      , [home_street]
--      , [contact_salutation_code]
--      , [contact_family_name]
--      , [contact_first_name]
--      , [contact_note]
--      , [contact_personal_known]
--      , [parts_rebate_group_buy]
--      , [parts_rebate_group_sell]
--      , [rebate_labour_percent]
--      , [rebate_material_percent]
--      , [rebate_new_vehicles_percent]
--      , [cash_discount_percent]
--      , [vat_id_number]
--      , [vat_id_number_checked_date]
--      , [vat_id_free_code_1]
--      , [vat_id_free_code_2]
--      , [birthday]
--      , [last_contact]
--      , [preferred_com_number_type]
--      , [created_date]
--      , [created_employee_no]
--      , [updated_date]
--      , [updated_employee_no]
--      , [name_updated_date]
--      , [name_updated_employee_no]
--      , [sales_assistant_employee_no]
--      , [service_assistant_employee_no]
--      , [parts_assistant_employee_no]
--      , [lock_by_workstation]
--      , [lock_time]
--      , [lock_trace]
--      , [lock_trigger]
--      , [lock_by_employee]
--      , [lock_sourcecode]

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

GO