SELECT SUM(t0.DAm)
,SUM(t0.NoReg)
,SUM(t0.NoInvoAb)
,SUM(t0.NoRet)
,SUM(t0.NoComp)
,SUM(t0.NoScr)
,SUM(t0.Dc1Am)
,SUM(t0.Dc1DAm)
,SUM(t0.Dc2Am)
,SUM(t0.Dc2DAm)
,SUM(t0.Am)
,SUM(t0.DstDc)
,SUM(t0.DDstDc)
,SUM(t0.DstAd)
,SUM(t0.DDstAd)
,SUM(t0.SpcTxAm)
,SUM(t0.DSpcTxAm)
,SUM(t0.VatAm)
,SUM(t0.DVatAm)
,SUM(t0.IncCst)
,SUM(t0.ExQty)
,SUM(t0.NoInq)
,SUM(t0.NoPurc)
,SUM(t0.NoOf)
,SUM(t0.NoCf)
,SUM(t0.NoPic)
,SUM(t0.NoFin)
,SUM(t0.FinInc)
,SUM(t0.NoPac)
,SUM(t0.NoCon)
,SUM(t0.NoInvo)
,SUM(t0.CIncCst)
,SUM(t0.InvoSF)
,SUM(t0.DInvoSF)
,SUM(t0.IncSF)
,SUM(t0.InvoIF)
,SUM(t0.DInvoIF)
,SUM(t0.IncIF)
,SUM(t0.CIncSF)
,SUM(t0.CIncIF)
,SUM(t0.NoRsv)
,SUM(t0.Factor3)
,SUM(t0.Stat1)
,SUM(t0.Stat2)
,SUM(t0.FreeNo)
,SUM(t0.RlzFree)
,SUM(t0.NoUn)
,SUM(t0.NWgtL)
,SUM(t0.TareL)
,SUM(t0.LgtL)
,SUM(t0.AreaL)
,SUM(t0.VolL)
,SUM(t0.DFrAm1)
,SUM(t0.DFrAm2)
,SUM(t0.DFrAm3)
,SUM(t0.DFrAm4)
,SUM(t0.Alloc)
,SUM(t0.Dc3Am)
,SUM(t0.Dc3DAm)
,SUM(t0.Dc4Am)
,SUM(t0.Dc4DAm)
,SUM(t0.Dc5Am)
,SUM(t0.Dc5DAm)
,SUM(t0.Dc6Am)
,SUM(t0.Dc6DAm)
,SUM(t0.NoProd)
,SUM(t0.D1Hr)
,SUM(t0.D2Hr)
,SUM(t0.D3Hr)
,SUM(t0.D4Hr)
,SUM(t0.D5Hr)
,SUM(t0.D6Hr)
,SUM(t0.D7Hr)
,SUM(t0.Free1)
,SUM(t0.Free2)
,SUM(t0.Free3)
,SUM(t0.Free4)
,SUM(t0.PicNotR)
,SUM(t0.DCstAd)
,SUM(t0.NoRsvInc)
,SUM(t0.IINoInvoAb)
,SUM(t0.IIDcAm)
,SUM(t0.IIAm)
,SUM(t0.IIVatAm)
FROM OrdLn t0
LEFT OUTER JOIN Ord t1 ON t0.OrdNo = t1.OrdNo
WHERE t0.R2 = #
AND (
t1.OrdPrSt & # = #
AND t1.OrdDt >= #
AND t1.OrdDt <= #
AND t1.TrTp = #
) /*2528*/