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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Salesperson_Purchaser] AS
SELECT [timestamp]
     , [Code]
     , [Name]
--      , [Commission _]
--      , [Global Dimension 1 Code]
--      , [Global Dimension 2 Code]
--      , [E-Mail]
--      , [Phone No_]
--      , [Job Title]
--      , [Search E-Mail]
--      , [E-Mail 2]
--      , [Dealer Code]
--      , [Type Salesperson_Purchaser]
--      , [Use Opportunity Templates]
--      , [Sales Lead Channel Code]
--      , [Sales Lead Source Code]
--      , [Sales Cycle Code]
--      , [Preferred Vehicle Status]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Salesperson_Purchaser]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO