--查询有入库但是未完全开采购发票的采购订单selectdistinctpo.vordercodefrombd_corpbp,po_orderpo,po_order_bpb,bd_busitypebusiwherepo.dr=0andpb.dr=0andpo.pk_corp=bp.pk_corpandpb.pk_corp=bp.pk_corpandpo.corderid=pb.corderidandpo.cbiztype=busi.pk_busitypeandpb.naccuminvoicenum
=0andpo.dorderdate<='2013-12-31'andbusi.busicode='c001'andbusi.pk_corp='1001'andpb.iisactive=0--未关闭采购订单--查询有入库但是未开采购发票的采购订单selectdistinctpo.vordercodefrombd_corpbp,po_orderpo,po_order_bpb,bd_busitypebusiwherepo.dr=0andpb.dr=0andpo.pk_corp=bp.pk_corpandpb.pk_corp=bp.pk_corpandpo.corderid=pb.corderidandpo.cbiztype=busi.pk_busitype--andpb.naccuminvoicenum=0andpb.naccuminvoicenumisnull--已经存在入库，但是累计发票数量字段是空值andpo.dorderdate<='2013-12-31'andbusi.busicode='c001'andbusi.pk_corp='1001'andpb.iisactive=0--未关闭采购订单
