select distinct b.broker_Id, coalesce( b.BrokerAbbrevName, b.broker_name ) brokerName, b.broker_name brokerFullName from tblBrokers b with (nolock) inner join tblMfrBrokerLink mbl with (nolock) on mbl.broker_id = b.broker_id where 1 = 1 order by brokerName select d.informationProviderGLN, count( distinct tx.txId ) notifications, min( tx.receiptDateTime ) firstNotification, max( tx.receiptDateTime ) lastNotification from tbl_1SYNC_Transactions tx with (nolock) inner join tbl_1SYNC_Documents d with (nolock) on d.txId = tx.txId group by d.informationProviderGLN select m.mfr_id, m.mfr_name, mbr.firstName, mbr.lastName, m.gs1_gln, m.gs1_syncEnabled from tblManufacturers m with (nolock) left outer join tbl_Fspro_members mbr with (nolock) on mbr.fspro_userid = m.fseContactId where exists ( select * from tblMfrBrokerLink mbl with (nolock) where mbl.mfr_id = m.mfr_Id and mbl.broker_id = ) order by mfr_name select distinct b.broker_Id, bo.broker_office_name brokerName, bo.broker_office_id from tblBrokers b with (nolock) inner join tblBrokerOffices bo with (nolock) on bo.broker_id = b.broker_Id where b.broker_id = order by brokerName select * from tblMfrBrokerLink mbl with (nolock) where mbl.broker_Id =

FS Enablers' GLN Number is 1100001017829

GS1 Activity
GS1 Status					Offices
Manufacturer (#_mfrCount#)	Notifications	First	Last	Days Ago	#htmleditformat( brokerName )# #broker_id#
#htmleditformat( mfr_name )#^#mfr_id# GLN: #htmleditformat( gs1_gln )#	#lsnumberformat( notifications )#	#lsdateformat( firstNotification, "MM/DD/YY")#	#lsdateformat( lastNotification, "MM/DD/YY")#	#lsnumberformat( daysAgo )#	&##160;	&##160;	&##160;	&##160	GS1&##160;	&##160;

If a cell for a broker office is grey, that means that particular broker office does not have a relationship with the manufacturer.