SELECT
dbo.SALESQUOTATIONTABLE.CUSTACCOUNT AS 'Account_Number__c',
dbo.SALESQUOTATIONTABLE.BUSRELACCOUNT AS 'Business_Relation_Number__c',
DIMENSION2_ AS 'Division__c',
QUOTATIONEXPIRYDATE AS 'Expiration__c',
PMF_NOOFITEMS AS 'Number_of_Items__c',
CREATEDDATE AS 'Quote_Date__c',
QUOTATIONID AS 'Quote_Number_Ext_ID__c',
QUOTATIONID AS 'Name',
PAYMENT AS 'Terms__c',
SALESGROUP AS 'Territory__c',
dbo.SALESQUOTATIONTABLE.BUSRELACCOUNT AS 'Account_CBusiness_Relation_Number__c',
CASE dbo.SALESQUOTATIONTABLE.QUOTATIONSTATUS
    WHEN 0 THEN 'Created'
    WHEN 1 THEN 'Sent'
    WHEN 2 THEN 'Confirmed'
    WHEN 3 THEN 'Lost'
    WHEN 4 THEN 'Cancelled'
    WHEN 5 THEN 'Won'
    ELSE 'Unknown' END AS 'Quote_Status__c',
'"' + REPLACE(NAME, '"', '') + '"' AS 'Contact_Name__c',
PHONE AS 'Contact_Phone__c',
dbo.CONTACTPERSON.EMAIL AS 'Contact_Email__c',
PMF_RFQRECEIVEDDATE AS 'Quote_Recieved_Date__c',
PMF_QUOTESENTDATE AS 'Quote_Sent_Date__c',
PGMNAME AS 'Program_Name__c',
OEM AS 'OEM_c',
(SELECT TOP 1(NAME) from USERINFO where SALESQUOTATIONTABLE.SalesTaker = USERINFO.NETWORKALIAS) as 'Pricing_Specialist_c'