仓库-未领料生产物料在线管控表 济南用友
发布时间:2014-12-18 21:53 文章来源:未知 被浏览次数: 次
济南用友SELECT v_mom_order_rpt.MoCode AS [生产订单号码],v_mom_orderdetail_rpt.SortSeq AS [行号], v_mom_order_rpt.CreateDate AS [日期],
mom_morder.StartDate AS [开工日期],mom_morder.DueDate AS [完工日期] ,v_mom_orderdetail_rpt.InvCode AS [物料编码],
Inventory.cInvAddCode AS [存货代码],Inventory.cInvName AS [存货名称], Inventory.cInvStd AS [规格型号],
v_mom_orderdetail_rpt.Qty AS [生产订单数量], v_mom_orderdetail_rpt.QualifiedInQty AS [入库数量],v_mom_orderdetail_rpt.Status AS [状态],
v_mom_orderdetail_rpt.MDeptCode AS [生产部门],Department.cDepName AS [部门名称],v_mom_modetail.Remark AS [生产线别]
FROM v_mom_order_rpt INNER JOIN v_mom_orderdetail_rpt ON v_mom_order_rpt.MoId = v_mom_orderdetail_rpt.MoId
left JOIN Department ON v_mom_orderdetail_rpt.MDeptCode = Department.cDepCode
INNER JOIN Inventory ON v_mom_orderdetail_rpt.InvCode = Inventory.cInvCode
INNER JOIN mom_morder ON v_mom_orderdetail_rpt.MoDId = mom_morder.MoDId
INNER JOIN v_mom_modetail ON v_mom_order_rpt.MoCode=v_mom_modetail.MoCode
where v_mom_orderdetail_rpt.modid not in (select v_mom_moallocate_rpt.modid from v_mom_moallocate_rpt where v_mom_moallocate_rpt.IssQty>0)
最新文章
- ·仓库-已领料产成品入库表 济南用
- [12-18]
- ·仓库-未领料生产物料在线管控表
- [12-18]
- ·仓库-未领料产成品入库表 济南用
- [12-18]
- ·仓库-生产用料考核表
- [12-18]
- ·仓库-生产线物料管控表 济南用友
- [12-18]
- ·仓库-生产领料考核表
- [12-15]
- ·仓库-产成品入库跟踪表 www.jina
- [12-15]
- ·财务-总帐-凭证输出一二末级科目
- [12-15]
- ·UfSystem..Ua_identity 表中常用
- [12-15]
- ·总账管理数据管理 www.jinanyony
- [12-14]
推荐阅读