已钩稽的单据不能再下推生成下游单据．

SELECT *
--UPDATE ICSTOCKBILL SET FHOOKSTATUS=''

from ICStockBill v1 INNER JOIN ICStockBillEntry u1 ON     v1.FInterID = u1.FInterID   AND u1.FInterID <>0
 INNER JOIN t_Supplier t4 ON     v1.FSupplyID = t4.FItemID   AND t4.FItemID <>0
 INNER JOIN t_ICItem t13 ON     u1.FItemID = t13.FItemID   AND t13.FItemID <>0
 INNER JOIN t_MeasureUnit t30 ON     t13.FUnitID = t30.FItemID   AND t30.FItemID <>0
 LEFT OUTER JOIN t_MeasureUnit t500 ON     t13.FStoreUnitID = t500.FItemID   AND t500.FItemID <>0
 LEFT OUTER JOIN t_SonCompany t560 ON     v1.FBrID = t560.FItemID   AND t560.FItemID <>0
 where 1=1 AND (    
ISNULL(t4.FNumber,'') = '021642'
)  AND (v1.FTranType=1 AND ((v1.FCheckerID>0)  and v1.FROB=1 and  v1.FCancellation = 0))
and fbillno=
--参数,订单号
--'WIN001358'
--'WIN001219'
--'WIN002465'
--'WIN001329'

-----------------------------------------------------------