select OrderDId,so.cMaker as 制单人,sos.cSCloser as 关闭人,sos.dbclosesystime as 关闭时间,SO.cCusCode AS 客户编码,c.cCusName as 客户名称 ,so.cSOCode as 销售订单,so.iverifystate ,

so.dDate as 订单日期,sos.cInvCode as 存货编码,i.cInvName as 存货名称,i.fGrossW as 毛重,sos.cFree1 as 色号 ,ie.cidefine10 as 是否定制,

sos.iQuantity as 订单数量,ISNULL(sos.foutquantity,0) as 累计出库数量 ,(sos.iQuantity-ISNULL(sos.foutquantity,0)) as 未出库数量 ,a.CreateDate as 生产日期,a.Qty as 生产数量,a.dDate as 入库日期,a.iQuantity as 入库数量,

 dis.cDLCode as 发货单号 ,dis.dDate as 发货日期,diss.iQuantity as 发货数量,

rd32.cCode as 出库单号,rd32.dDate as 出库日期,rds32.cBatch 系统出库批号,rds32.cDefine32 实际出库批号,rds32.iQuantity as 出库数量

 from  SO_SOMain so with (nolock) 

left join SO_SODetails sos with (nolock) on so.ID=sos.ID

left join (select OrderDId,sum(qty)as qty,sum(rd10.iQuantity)as iQuantity,

min(mom.CreateDate) as CreateDate ,max(rd10.ddate) as ddate

from  mom_orderdetail momo with  (nolock) 

left join  mom_order mom with (nolock) on mom.MoId=momo.MoId

left join  (select max(ddate) as ddate,cmocode,iMPoIds,sum(iQuantity) iQuantity

 from rdrecords10 rds10 with (nolock) 

 inner join  rdrecord10  rd10 with (nolock) on rd10.ID=rds10.ID

 group by cmocode,iMPoIds

 ) rd10 on rd10.cmocode=mom.MoCode and rd10.iMPoIds=momo.MoDId group by OrderDId) a on a.OrderDId=sos.iSOsID 

left join DispatchLists diss with (nolock) on diss.cSoCode=so.cSoCode  and diss.iSOsID=sos.iSOsID

left join DispatchList dis with (nolock) on dis.DLID=diss.DLID 

left join  rdrecords32 rds32 with (nolock) on  rds32.iDLsID=diss.iDLsID 

left join rdrecord32 rd32 with (nolock) on rd32.id=rds32.ID

left join Inventory  I with(nolock) on sos.cinvcode=i.cinvcode

left join Inventory_extradefine ie with(nolock) on ie.cInvCode=sos.cInvCode

left join Customer  c with (nolock) on c.cCusCode=so.cCusCode