select companyname from qmd_affiliations where affiliationtype = 'CMC' order by companyname select companyname from qmd_affiliations where affiliationtype = 'GPO' order by companyname
Segment Segment #qcfAccountDetails.segmentDesc#
Distributor Distributor #qcf_distDetail.primaryDistrib#
Num of Units #year(now())-1#: #qcfAccountDetails.num_units_lastYr#
#year(now())#: #qcfAccountDetails.num_units_thisYr#
#year(now())+1#: #qcfAccountDetails.num_units_nextYr#
Food Mgmt Co #companyname#
GPO #companyname#
#_mdmType# ID #qcfAccountDetails.mdmid#
#_mdmType# ID
#qcfAccountDetails.mdmid# - #htmleditformat(qcfAccountDetails.mdmCompanyName)#
#label# #data#
#label# #data#
Addl Profile Info
#htmleditformat(qcfAccountDetails.comments)#