修改供应商是否启用供应商协同原创
1人赞赏了该文章
91次浏览
编辑于2023年05月13日 18:52:42
select a.FSUPPLIERID SpsBillRId --SRM数据ID ,FEnableSL --是否启用供应商协同 0不启用 1 启用 from t_BD_Supplier a left join T_ORG_ORGANIZATIONS org on a.FUSEORGID=org.FORGID left join t_BD_SupplierBusiness c on a.FSUPPLIERID=c.FSUPPLIERID where org.FNUMBER=10 and a.FNUMBER='VEN00104' --UPDATE t_BD_SupplierBusiness set -- FEnableSL=1 -- from t_BD_Supplier a -- left join T_ORG_ORGANIZATIONS org on a.FUSEORGID=org.FORGID --left join t_BD_SupplierBusiness c on a.FSUPPLIERID=c.FSUPPLIERID --where org.FNUMBER=10 and a.FNUMBER='VEN00104'
推荐阅读