select 'S' type, fspro_userId, firstName, lastName, email, title
from tbl_FSpro_Members
where ownerId =
and fsl_tablecode =
and fspro_userid =
and loginEnabled = 1
select 'B' type, teamMemberUserId fspro_userid, title, firstName, lastName, email
from qmd_territoryTeam
where
teamMemberId = -1 and ( teamMemberRole = 'MRR:Distributor Management' or teamMemberRole like 'MPR%' )
union
select 'S' type, teamMemberUserId fspro_userid, title, firstName, lastName, email
from qmd_territoryTeam
where teamMemberId > 0
union
select 'S' type, customerManagerUserId fspro_userId, title, firstName, lastName, email
from qmd_customerManagerChain
where customerManagerUserId =
union
select 'S' type, teamMemberUserId fspro_userid, title, firstName, lastName, email
from qmd_territoryTeam
where teamMemberId =
union
select type, fspro_userid, title, firstName, lastName, email
from qmd_currentSalesPerson
select type, fspro_userid, title, firstName, lastName, email
from qmd_territoryTeam
order by type desc, lastName, firstName
select '' as type, fspro_userid, title, firstName, lastName, email
from tbl_FSPro_Members
where fspro_userid IN (#valueList(qmd_customermanagerChain.customerManagerUserId)#)
Select the Sales Person that made or will make this call.
What method of interaction was or will be used for this Interaction.
Enter the date on which the sales call was made or will be made.
[mm/dd/yyyy] (tentative)
The system can send an email reminder to the Sales Person for this interaction.