select companyname, address, city + ' ' + state + ', ' + zipcode as citystatezip from tbl_opr_clientoperators where ownerid = and fsltablecode = and operatorid = select cdr_dstname as companyname, cdr_dstaddress1 as address, cdr_dstcity + ' ' + cdr_dststate + ', ' + cdr_dstzip as citystatezip from tbl_cdr_distributors where ownerid = and fsl_tablecode = and cdr_recordid = select * from qmd_taskTemplates order by sortOrder, taskDescription
Add New Opportunity
#qryAccountInfo.companyname#
#qryAccountInfo.address#
#qryAccountInfo.citystatezip#
Account*
    SKU*
    Opp Type
    Est Order Date*
    Est Annual Volume*
    select min(sequence) as sequence from qmd_stages where statuscode = 'A'
    New Stage*
    New Comment*
    Was this an interaction with the Customer?*
    If "Yes", a Sales Call on the date below will be created.
    Actionable Next Step*
    Due Date
    Sales Person
    #client.user#