.*$", "", "ALL")>

Deleting #UID# From: #htmleditformat( from )# To: #htmleditformat( to )#

select broker_name, broker_id from tblBrokers where emailDomain = and exists ( select * from tbl_OPR_ClientOperators where ownerId = broker_id and fsltablecode = 'BRO' )

Broker is #htmleditformat( qmd_lookupBroker.broker_Name )#

select fspro_userid, firstName, lastName from tbl_FSPro_members where ownerId = and fsl_tablecode = and staffMember = 1 and loginEnabled = 1 and email = .*$", "", "ALL"))> select fspro_userid, orgId, orgType, firstName, lastName from tbl_FSPro_Members where ownerId = and fsl_tablecode = and orgType = 'OPR' and staffMember = 0 and email =

Message from #_from# to #_toList# is not a known contact

select popSourceId, ownerId, ownerType, popServer, popPassword, popUserName, msgSubjectRegEx, msgFrom from tbl_EAI_InboundPOPSources Inboxes update tbl_EAI_InboundBatches set dependentBatchId = where batchId =

Client

Mailbox

From

Subject

#_ownerType##_ownerId#

#_popUserName#@#_popServer#

#_msgFrom#

#_msgSubjectRegEx#

Messages select popMessageId, dateProcessed from tbl_EAI_InboundPOPSourceHistory where popSourceId = and popMessageId = select fileProcessor, fileFormat, clientProcessEmail, fseProcessEmail, fileName, batchName, batchSequence from tbl_EAI_InboundFileProcessors where ownerId= and ownerType= select fileProcessor, fileFormat, clientProcessEmail, fseProcessEmail, batchName, batchSequence from qmd_rawFileProcessors where fileName= QueryAddRow( qmd_fileProcessors, 1 ); QuerySetCell( qmd_fileProcessors, "fileProcessor", fileProcessor, qmd_fileProcessors.recordCount ); QuerySetCell( qmd_fileProcessors, "fileFormat", fileFormat, qmd_fileProcessors.recordCount ); QuerySetCell( qmd_fileProcessors, "clientProcessEmail", clientProcessEmail, qmd_fileProcessors.recordCount ); QuerySetCell( qmd_fileProcessors, "fseProcessEmail", fseProcessEmail, qmd_fileProcessors.recordCount ); QuerySetCell( qmd_fileProcessors, "batchName", batchName, qmd_fileProcessors.recordCount ); QuerySetCell( qmd_fileProcessors, "batchSequence", batchSequence, qmd_fileProcessors.recordCount ); set nocount off insert into tbl_EAI_InboundBatches ( ownerId, ownerType, fileName, fileFormat, fileProcessor, clientProcessEmail, fseProcessEmail, batchName, batchSequence, status, message ) values ( , , , , , , , , , , ) select batchId = @@identity set nocount off update tbl_EAI_InboundBatches set taskURL = , taskName = where batchId = update tbl_EAI_InboundBatches set status = where batchId =

Status	From	Subject	Date Processed	Message Id
Ignored	#qmd_messages.from#	#qmd_messages.subject#	#lsdateformat( qmd_historyLookup.dateProcessed )# #lstimeformat( qmd_historyLookup.dateProcessed )#	#qmd_messages.messageId#
New	#from#	#subject#	#LSDateFormat( now() )# #lstimeformat( now() )#	#messageId#
&##160;	#_localFile#
&##160;	Created task #_batchName# [#_runDate# #_runTime#]for #fileProcessor#(#_localFile#)

insert into tbl_EAI_InboundPOPSourceHistory ( popSourceId, popMessageId, dateProcessed ) values( , , { fn now() }) Delete Msg Nbr: #_messageNumber#
select batchId, batchName, batchSequence, taskURL, taskName, fileProcessor, fileName from tbl_EAI_InboundBatches where batchId in ( ) order by batchName, batchSequence update tbl_EAI_InboundBatches set status = where batchId =

&##160;

Created task #batchName# [#_runDate# #_runTime#]for #fileProcessor#(#fileName#)

select fileProcessor, fileFormat, clientProcessEmail, fseProcessEmail, batchName, batchSequence from qmd_rawFileProcessors where fileName= QueryAddRow( qmd_fileProcessors, 1 ); QuerySetCell( qmd_fileProcessors, "fileProcessor", fileProcessor, qmd_fileProcessors.recordCount ); QuerySetCell( qmd_fileProcessors, "fileFormat", fileFormat, qmd_fileProcessors.recordCount ); QuerySetCell( qmd_fileProcessors, "clientProcessEmail", clientProcessEmail, qmd_fileProcessors.recordCount ); QuerySetCell( qmd_fileProcessors, "fseProcessEmail", fseProcessEmail, qmd_fileProcessors.recordCount ); QuerySetCell( qmd_fileProcessors, "batchName", batchName, qmd_fileProcessors.recordCount ); QuerySetCell( qmd_fileProcessors, "batchSequence", batchSequence, qmd_fileProcessors.recordCount ); set nocount off insert into tbl_EAI_InboundBatches ( ownerId, ownerType, fileName, fileFormat, fileProcessor, clientProcessEmail, fseProcessEmail, batchName, batchSequence, status, message ) values ( , , , , , , , , , , ) select batchId = @@identity set nocount off update tbl_EAI_InboundBatches set taskURL = , taskName = where batchId = update tbl_EAI_InboundBatches set status = where batchId = Created task #_batchName# [#_runDate# #_runTime#]for #fileProcessor#(#_localFile#)
Deleted #_baseName#
select batchId, batchName, batchSequence, taskURL, taskName, fileProcessor, fileName from tbl_EAI_InboundBatches where batchId in ( ) order by batchName, batchSequence update tbl_EAI_InboundBatches set status = where batchId = Created task #batchName# [#_runDate# #_runTime#]for #fileProcessor#(#fileName#)
update tbl_EAI_InboundBatches set dependentBatchId = where batchId = --->