检测单据上的供应和需求日期是不是为空sql语句

chenchenjie

共享一下，方便大家使用。

--检查请购单上面是不是存在需求日期为空的记录
select b.ccode,* from pu_appvouchs a left join pu_appvouch b on a.id=b.id where a.drequirdate is null
--检查采购订单上面是不是存在计划到货日期为空的记录
select b.cPOID ,* from po_podetails a left join po_pomain b on a.poid=b.poid where a.dArriveDate is null
--检查委外订单上面是不是存在计划到货日期为空的记录
select b.ccode ,* from OM_MODetails a left join OM_MOMain b on a.moid=b.moid where a.dArriveDate is null
--检查生产订单上面是不是存在开工完工日期为空的记录
select b.mocode,* from mom_morder a left join mom_order b on a.moid=b.moid where a.startdate is null or duedate is null
--检查计划订单上面是不是存在开工完工日期为空的记录
select * from mps_netdemand a where a.startdate is null or a.duedate is null
--检查进口订单上面是不是存在计划到货日期为空的记录
select b.ccode,* from IM_OrderDetail  a left join IM_Order b on a.id=b.id where a.darrivedate is null

--需求日期
--检查销售订单上面的预计完工日期是不是存在空值
select csocode,* from so_sodetails a where a.dPreMoDate is null
--检查预测订单上面的开工完工日期是不是存在空值
SELECT * FROM mps_forecastdetail  A LEFT JOIN mps_forecast B ON A.ForecastId=B.ForecastId
where a.startdate is null or a.enddate is null
SELECT * FROM mps_forecastDATA A where a.demdate is null or a.supplydate is null
--检查生产订单上面的子件需求日期是不是存在空值
select c.mocode,b.sortseq,* from mom_moallocate a  left join mom_orderdetail b on a.modid=b.modid
left join mom_order c on c.moid=b.moid
where a.startdemdate is null or a.enddemdate is null
--检查委外订单上面的子件需求日期是不是存在空值
select C.CCODE,* FROM om_momaterialS A  LEFT JOIN OM_MODetails B ON A.MODETAILSID=B.MODETAILSID
LEFT JOIN OM_MOMAIN C ON C.MOID=B.MOID
WHERE A.drequireDDate IS NULL


该贴已经同步到 chenchenjie的微博