select name as GS1_ItemHierarchy from gs1..sysobjects with (nolock) where xtype = 'U' and name like '%itemHierarchy_%' select distinct m.mfr_id, m.mfr_name, m.gs1_gln GLN, d.operation, p.scc14 GTIN, s.sku, s.skuDesc, t.receiptDateTime, m.fseContactId, m.fseproductCatalogContactId from tbl_1SYNC_Documents d with(nolock) inner join tbl_1SYNC_Transactions t with(nolock) on t.txId = d.txId inner join gs1..#_ItemHierarchyTableName# h with(nolock) on h.publishedGTIN = d.publishedGTIN collate Compatibility_52_409_30003 inner join tblManufacturers m with(nolock) on m.gs1_gln = d.informationProviderGLN inner join tbl_PRD_Packaging p with(nolock) on p.scc14 in ( d.publishedGTIN, h.publishedGTIN collate Compatibility_52_409_30003, h.parentGTIN collate Compatibility_52_409_30003, h.childGTIN collate Compatibility_52_409_30003 ) and p.ownerId = m.mfr_id and p.fsl_tablecode = 'MFR' and p.linkType = 'SKU' inner join tbl_PRD_SKus s with(nolock) on s.skuId = p.linkId and s.gs1_syncDate is not null where receiptDateTime between and order by mfr_name, receiptDateTime, sku select * from qmd_gs1ActivityDetail_raw union select * from qmd_gs1ActivityDetail select mfr_id, mfr_name, fseContactId, fseProductCatalogContactId, count(*) as skuCount from qmd_gs1ActivityDetail group by mfr_id, mfr_name, fseContactId, fseProductCatalogContactId order by mfr_name select email, firstName, lastName from tbl_fspro_members where fspro_userid =
GS1 Activity Summary for #lsdateformat( url.filterDate, "MM/DD/YYYY")#
ManufacturerSKUsFSE PrimaryFSE Product Catalog
#htmleditformat( mfr_name )# #lsnumberformat( skuCount )# #htmleditformat( qmd_primaryContact.firstName )# #htmleditformat( qmd_primaryContact.lastName )#unassigned #htmleditformat( qmd_productCatalogContact.firstName )# #htmleditformat( qmd_productCatalogContact.lastName )#unassigned
GS1 Activity Detail for #lsdateformat( url.filterDate, "MM/DD/YYYY")#
Operation GTIN SKU Description Time
#htmleditformat( mfr_name )# (GLN: #htmleditformat( gln )#) top
#htmleditformat( operation )# #htmleditformat( gtin )# #htmleditformat( sku )# #htmleditformat( skuDesc )# #lstimeformat( receiptDateTime )#
#_emailBodyHTML#
Processing Complete