--调整预置数据的编码
--数据源
UPDATE  t_mrp_rsdataconfig SET FNUMBER  = 'DS_er_inv_realbala_S' WHERE FNUMBER = 'DS-ys-01-ecoeffectrange-init';
UPDATE  t_mrp_rsdataconfig SET FNUMBER  = 'DS_er_pom_mftorder_S' WHERE FNUMBER = 'DS-ys-02-ecoeffectrange-init';
UPDATE  t_mrp_rsdataconfig SET FNUMBER  = 'DS_er_om_mftorder_S' WHERE FNUMBER = 'DS-ys-03-ecoeffectrange-init';
UPDATE  t_mrp_rsdataconfig SET FNUMBER  = 'DS_er_pm_purapply_S' WHERE FNUMBER = 'DS-ys-04-ecoeffectrange-init';
UPDATE  t_mrp_rsdataconfig SET FNUMBER  = 'DS_er_pm_purorder_S' WHERE FNUMBER = 'DS-ys-05-ecoeffectrange-init';
UPDATE  t_mrp_rsdataconfig SET FNUMBER  = 'DS_er_c_pdm_eco_S' WHERE FNUMBER = 'DS-ys-06-ecoeffectrange-init';
UPDATE  t_mrp_rsdataconfig SET FNUMBER  = 'DS_er_om_purorder_S' WHERE FNUMBER = 'DS-ys-07-ecoeffectrange-init';
UPDATE  t_mrp_rsdataconfig SET FNUMBER  = 'DS_er_mrp_planorder_S' WHERE FNUMBER = 'DS-ys-08-ecoeffectrange-init';
UPDATE  t_mrp_rsdataconfig SET FNUMBER  = 'DS_er_mrp_planorder_cp_S' WHERE FNUMBER = 'DS-ys-09-ecoeffectrange-init';
UPDATE  t_mrp_rsdataconfig SET FNUMBER  = 'DS_er_p_pdm_eco_S' WHERE FNUMBER = 'DS-ys-16-ecoeffectrange-init';
UPDATE  t_mrp_rsdataconfig SET FNUMBER  = 'DS_estimate_pdm_eco_S' WHERE FNUMBER = 'DS-ys-01-ecoinit';
UPDATE  t_mrp_rsdataconfig SET FNUMBER  = 'DS_estimate_om_mftstock_S' WHERE FNUMBER = 'DS-ys-02-ecoinit';
UPDATE  t_mrp_rsdataconfig SET FNUMBER  = 'DS_estimate_pom_mftstock_S' WHERE FNUMBER = 'DS-ys-03-ecoinit';



--实体字段映射
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'er_c_pdm_eco_S' WHERE FNUMBER = 'ys_ecoeffectrange_c_pdm_eco';
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'er_inv_realbala_S' WHERE FNUMBER = 'ys_ecoeffectrange_inv_realbala';
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'er_mrp_planorder_S' WHERE FNUMBER = 'ys_ecoeffectrange_mrp_planord';
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'er_mrp_planorder_cp_S' WHERE FNUMBER = 'ys_ecoeffectrange_mrp_planorde';
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'er_om_mftorder_S' WHERE FNUMBER = 'ys_ecoeffectrange_om_mftorder';
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'er_om_purorder_S' WHERE FNUMBER = 'ys_ecoeffectrange_om_purorder';
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'er_pdm_eco_S' WHERE FNUMBER = 'ys_ecoeffectrange_pdm_eco';
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'er_pm_purapply_S' WHERE FNUMBER = 'ys_ecoeffectrange_pm_purapply';
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'er_pm_purorder_S' WHERE FNUMBER = 'ys_ecoeffectrange_pm_purorder';
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'er_pom_mftorder_S' WHERE FNUMBER = 'ys_ecoeffectrange_pom_mftorder';
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'er_p_pdm_eco_S' WHERE FNUMBER = 'ys_ecoeffectrange_p_pdm_eco';
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'estimate_om_stock_S' WHERE FNUMBER = 'ys_ecoestimate_om_stock';
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'estimate_pdm_eco_S' WHERE FNUMBER = 'ys_ecoestimate_pdm_eco';
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'estimate_pom_stock_S' WHERE FNUMBER = 'ys_ecoestimate_pom_stock';
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'estimate_s_r_S' WHERE FNUMBER = 'ys_ecoestimate_s_r';
UPDATE  t_mrp_bftransfer SET FNUMBER  = 'er_s_r_S' WHERE FNUMBER = 'ys_ecoeffectrange_s_r';

--资源注册模型
UPDATE  t_mrp_rsregister SET FNUMBER  = 'eco_effectrange_demand_S' WHERE FNUMBER = 'ys_eco_effectrange_demand';
UPDATE  t_mrp_rsregister SET FNUMBER  = 'eco_effectrange_supply_S' WHERE FNUMBER = 'ys_eco_effectrange_supply';
UPDATE  t_mrp_rsregister SET FNUMBER  = 'eco_estimate_require_S' WHERE FNUMBER = 'ys_eco_estimate_require';
UPDATE  t_mrp_rsregister SET FNUMBER  = 'eco_estimate_sypply_S' WHERE FNUMBER = 'ys_eco_estimate_sypply';

--算法注册
UPDATE  t_mrp_algoregister SET FNUMBER  = 'ecoeffectrange_getrequire_S' WHERE FNUMBER = 'ys_ecoeffectrange_getrequire';
UPDATE  t_mrp_algoregister SET FNUMBER  = 'ecoeffectrange_getsupply_S' WHERE FNUMBER = 'ys_ecoeffectrange_getsupply';
UPDATE  t_mrp_algoregister SET FNUMBER  = 'ecoeffectrange_srmatch_S' WHERE FNUMBER = 'ys_ecoeffectrange_srmatch';
UPDATE  t_mrp_algoregister SET FNUMBER  = 'ecoestimate_clearhisdata_S' WHERE FNUMBER = 'ys_ecoestimate_clearhisdata';
UPDATE  t_mrp_algoregister SET FNUMBER  = 'ecoestimate_effectorder_S' WHERE FNUMBER = 'ys_ecoestimate_effectorder';
UPDATE  t_mrp_algoregister SET FNUMBER  = 'ecoestimate_getrequire_S' WHERE FNUMBER = 'ys_ecoestimate_getrequire';
UPDATE  t_mrp_algoregister SET FNUMBER  = 'ecoestimate_getsupply_S' WHERE FNUMBER = 'ys_ecoestimate_getsupply';
UPDATE  t_mrp_algoregister SET FNUMBER  = 'ecoestimate_srbalance_S' WHERE FNUMBER = 'ys_ecoestimate_srbalance';
UPDATE  t_mrp_algoregister SET FNUMBER  = 'ecoestimate_writedata_S' WHERE FNUMBER = 'ys_ecoestimate_writedata';

--业务配置方案
UPDATE  t_mrp_businessplan SET FNUMBER  = 'eco_eatimate_bizset_S' WHERE FNUMBER = 'ys_eco_eatimate_bizset';
UPDATE  t_mrp_businessplan SET FNUMBER  = 'eco_effectrange_bizset_S' WHERE FNUMBER = 'ys_eco_effectrange_bizset';

--计算方案
UPDATE  t_mrp_calplanconfig SET FNUMBER  = 'ecoeffectrange_S' WHERE FNUMBER = 'ys_ecoeffectrange';
UPDATE  t_mrp_calplanconfig SET FNUMBER  = 'ecoestimate_S' WHERE FNUMBER = 'ys_ecoestimate';
