领用件是真实存在的产品,有实物存在,虚拟件只是一个概念性的东西,没有实物,用于挂子件,在BOM里面虚拟件和领用件的差异比较大,影响后续生产订单的领料和入库已经生产
select iSupplyType,* from Inventory where cInvCode like '6%' and iSupplyType ='0'
--update Inventory set iSupplyType='3' where cInvCode like '6%' and iSupplyType ='0'
3是虚拟件,0是领用件