U8 供需政策 LP件转PE件

U8  供需政策  LP件转PE件

先查询确定数据

select bTrackSaleBill ,csrpolicy from inventory where cinvcode=N'物料号'

select  * from inventory_sub where cInvSubCode=N'物料号'

更新物料档案

update inventory set csrpolicy = 'PE',bTrackSaleBill = 0 where cinvcode in ('物料号')

update inventory_sub  set iRequireTrackStyle=0  where cinvsubcode in ('物料号')

更新 销售订单子表

update set idemandtype = '0'  where cSOCode = '销售订单号'