#_xml# select g1.gln, m.mfr_id, m.mfr_name, count(*) files from tbl_1SYNC_Files f inner join tbl_1SYNC_FileInformationProviderGLNs g on g.fileId = f.FileId inner join tbl_Gs1_GLNs g1 on g1.gln = g.gln and g1.partnerType = 'MFR' inner join tblManufacturers m on m.mfr_id = g1.partnerId group by m.mfr_id, m.mfr_name, g1.gln order by mfr_name

Production Data

Non-Production Data

select fg.gln, m.mfr_Id, f.fileId, m.mfr_name, f.name, f.size, f.dateLastModified, f.messageType, f.messageId, f.messageVersion, fg.dataRecipientGLN from tbl_1SYNC_Files f left outer join tbl_1SYNC_FileInformationProviderGLNs fg on fg.fileId = f.fileId left outer join tbl_GS1_GLNs gln on gln.gln = fg.gln and gln.partnerType = 'MFR' left outer join tblManufacturers m on m.mfr_id = gln.partnerId where f.parseStatus = 'Y' and messageId in ( select tx.messageId from tbl_1SYNC_Transactions tx inner join tbl_1SYNC_Documents d on d.txId = tx.txId where d.publishedGTIN = ) and f.dateLastModified >= and f.dateLastModified >= and gln.gln = and f.name like '%preprod%' and ( f.name not like '%preprod%' ) and messageType = 'catalogueItemNotification' and messageVersion = '2.0' order by f.dateLastModified desc

select batchId, status, message, batchTime from tbl_EAI_inboundBatches where ownerId = and ownerType = 'MFR' and fileFormat = '$GS1_CatalogItemNotification' and fileName like order by batchId desc

		File
GLN	Manufacturer	Name	Size	Date	Type	Reprocess	Batch	Recipient
#htmleditformat( gln )#	#htmleditformat( mfr_name )# (#mfr_id#)	#htmleditformat( name )#	#lsnumberformat( size / 1024.0 / 1024.0, "0.00" )# MB	#dateLastModified#	#htmleditformat( messageType )#	&##160;	#batchTime# #lsnumberformat( batchId, "0000000" )# #htmleditformat( status )# #htmleditformat( message )#	#htmleditformat( dataRecipientGLN )#

Parse Only:

Selected files will be processed in oldest to newest (the way they were received).