用友U8 ERP 生产订单跟踪检验SQL

SELECT T0.MoCode AS 生产订单号 ,

T0.MoSeq AS 生产订单行号 ,

T0.StartDate AS 开工日期 ,

T0.DueDate AS 完工日期,

T0.OrderCode AS 销售订单号 ,

T0.OrderSeq AS 销售订单行号 ,

T0.InvCode AS 物料编码 ,

T0.InvName AS 物料名称 ,

T0.InvStd AS 物料规格 ,

T0.MoTypeDesc AS 类别说明 ,

T0.Qty AS 生产数量 ,

T0.DeclaredQty AS 报检数量 ,

SUM(T2.FQUANTITY) AS 检验数量 ,

T0.DeclaredQty - SUM(T2.FQUANTITY) AS 未检验数量 ,

SUM(T2.FCONQUANTIY) AS 让步接收数量 ,

SUM(T2.FDISQUANTITY) AS 不良品数量 ,

SUM(T2.FREGQUANTITY) AS 合格接收数量 ,

T0.QualifiedInQty AS 完成入库数量 ,

(T0.Qty - T0.QualifiedInQty) AS 未入库数量

FROM v_mom_orderdetail T0

LEFT JOIN QmInspectvouchers T1 ON T1.SOURCEAUTOID = T0.MoDId --报检单子表

LEFT JOIN QMCHECKVOUCHER T2 ON T1.AUTOID =T2.INSPECTAUTOID --成品检验单主表

--WHERE T0.MoCode='STS-21-062'

GROUP BY T0.MoCode ,

T0.MoSeq ,

T0.OrderCode ,

T0.OrderSeq ,

T0.InvCode ,

T0.InvName ,

T0.InvStd ,

T0.MoTypeDesc ,

T0.Qty ,

T0.DeclaredQty ,

T0.QualifiedInQty,

T0.StartDate,

T0.DueDate