gemma-l
10/15/2019 - 3:24 PM

stephen dispatches for 2018

select orh.TraderCode as CustomerCode
		,orh.TraderName as CustomerName
		,plu.Code as PLUCode
		,plu.Text1 as PLUDescription
		,SUM(dms.NetWeight) as WGT
		,SUM(dms.units) as Cases

from vw_ce_dms_transactions dms
left join datafiles_data plu
	ON plu.datafiledataid = dms.PLUID
LEFT JOIN dbo.vw_ce_oms_order_header orh ON dms.WONo = orh.OrderNo

WHERE TransactionDateTime between '20180101' and '20181231'
and TransactionType = 'PALLET_DISPATCH_LOADING'
and Cancelled = 0

GROUP BY orh.TraderCode, orh.TraderName, plu.Code, plu.Text1