Question

金蝶k3 SQL3表查询问题

SELECT Z.FDate AS 产品入库日期,Z.FBILLNO AS 产品入库单号, k.FBillNo AS 生产任务单, a.FBillNo AS 投料单号 FROM dbo.PPBOM a INNER JOIN dbo.PPBOMEntry b ON a.FInterID = b.FInterID INNER JOIN dbo.ICMO k ON a.FICMOInterID = k.FInterID INNER JOIN dbo.icstockbillentry f ON a.FICMOInterID = f.FICMOInterID INNER JOIN dbo.icstockbill z ON z.FInterID = F.FInterID WHERE (k.FStatus IN (1, 5, 2)) AND (k.FWorkTypeID = 55) AND (k.FCancellation = 0)AND Z.FDate>='********'and Z.FDate<='########'ORDER BY Z.FDate只想过滤入库单为什么生产领料单也会过滤出来？

Answer 1

跟一个条件 z.FTranType=2 ，因为你生产领料单也是关联生产任务单生成的，所有出入库单据在icstockbill中，表中用FTranType字段来区分是材料入库还是产品入库还是销售出库还是生产领料