U8 脚本查询生产订单
SELECTMoCodeAS 生产订单号码 ,MoTypeDesc AS 订单类型,
UA_User.cUser_NameAS 制单人,
MakeDate AS 制单日期,
(CASEStatus
WHEN 1 THEN '未审核'
WHEN 2 THEN '锁定'
WHEN 3 THEN '审核'
WHEN 4 THEN '关闭' END) AS 生产订单状态,
MoSeq AS 行号 ,
StartDate AS 开工日期 ,
DueDate AS 完工日期 ,
DeptName AS 生产部门,
InvCode AS 存货编码 ,
InvName AS 存货名称 ,
InvStd AS 存货规格 ,
UnitCode AS 主计量单位 ,
Qty AS 数量,
QualifiedInQty AS 入库数量 FROM v_mom_orderdetailJOINUA_User ON v_mom_orderdetail.Maker=UA_User.cUser_IdWHEREQualifiedInQty<>Qty AND Status=3
感谢楼主的分享 感谢楼主的分享
页:
[1]