-- 物料销售信息新增字段fisreturninspect，fisdeliverinspect，历史数据升级
UPDATE T_BD_MATERIALSALINFO AS MSI SET FISRETURNINSPECT='1', FISDELIVERINSPECT='1' WHERE MSI.FMASTERID IN (SELECT MS.FID FROM  T_BD_MATERIAL_S AS MS WHERE MS.FENABLEINSPECT = '1' ) AND MSI.FISRETURNINSPECT='0' AND MSI.FISDELIVERINSPECT='0';