--pengfei_he 销售订单设置  要删
DELETE FROM T_BD_DefaultCtrlStrategy WHERE FID = 961344694938390528;
--INSERT INTO T_BD_DefaultCtrlStrategy(FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FDATATYPE,FDISABLEDATE,FMASTERID,FSTATUS,FAPPSYSTEMID,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID)
--VALUES (961344694938390528,914427355726916608,'1','2',NULL,961344694938390528,'C','0MBB4=9D3YI9',' ','5','mds_salorderst',{ts'2018-08-18  00:00:00'},'1',1,' ',{ts'2018-08-18  00:00:00'},1,'1',0);

--pengfei_he 冲减控制 要删
DELETE FROM T_BD_DefaultCtrlStrategy WHERE FID = 961389149552789504;
--INSERT INTO T_BD_DefaultCtrlStrategy(FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FDATATYPE,FDISABLEDATE,FMASTERID,FSTATUS,FAPPSYSTEMID,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID)
--VALUES (961389149552789504,914427355726916608,'1','2',NULL,961389149552789504,'C','0MBB4=9D3YI9',' ','5','mds_writeoff',{ts'2018-08-18  00:00:00'},'1',1,' ',{ts'2018-08-18  00:00:00'},1,'1',0);


--pengfei_he  需求类型  要删
DELETE FROM T_BD_DefaultCtrlStrategy WHERE FID = 859269812772565000;
--INSERT INTO T_BD_DefaultCtrlStrategy(FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FDATATYPE,FDISABLEDATE,FMASTERID,FSTATUS,FAPPSYSTEMID,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (859269812772565000,4,'1','2',NULL,859269812772565000,'A','0MBB4=9D3YI9',' ','5','mds_dmtp',{ts'2020-08-18  00:00:00'},'1',1,' ',{ts'2020-08-18  00:00:00'},1,'0',0);

--pengfei_he 版本定义  要删
DELETE FROM T_BD_DefaultCtrlStrategy WHERE FID = 859270438646699000;
--INSERT INTO T_BD_DefaultCtrlStrategy(FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FDATATYPE,FDISABLEDATE,FMASTERID,FSTATUS,FAPPSYSTEMID,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (859270438646699000,16,'1','2',NULL,859270438646699000,'A','0MBB4=9D3YI9',' ','5','mds_vrds',{ts'2020-08-18  00:00:00'},'1',1,' ',{ts'2020-08-18  00:00:00'},1,'0',0);

-- mds_assigned  要删
DELETE FROM T_BD_DefaultCtrlStrategy WHERE FID = 1021501065813713920;


--hongbiao_du 预测关联关系
DELETE FROM T_BD_DefaultCtrlStrategy WHERE FID = 866612028025156608;
INSERT INTO T_BD_DefaultCtrlStrategy(FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FDATATYPE,FDISABLEDATE,FMASTERID,FSTATUS,FAPPSYSTEMID,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID)
VALUES (866612028025156608,914427355726916608,'1','2',NULL,866612028025156608,'C','0MBB4=9D3YI9',' ','5','mds_fccorl',{ts'2018-08-18  00:00:00'},'1',1,' ',{ts'2018-08-18  00:00:00'},1,'1',0);

--hongbiao_du 预测关联关系
DELETE FROM T_BD_DefaultCtrlStrategy WHERE FID = 930389643768254464;
INSERT INTO T_BD_DefaultCtrlStrategy(FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FDATATYPE,FDISABLEDATE,FMASTERID,FSTATUS,FAPPSYSTEMID,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID)
VALUES (930389643768254464,914427355726916608,'1','2',NULL,930389643768254464,'C','0MBB4=9D3YI9',' ','5','mds_corl',{ts'2018-08-18  00:00:00'},'1',1,' ',{ts'2018-08-18  00:00:00'},1,'1',0);



--pengfei_he 版本定义
DELETE FROM T_BD_DefaultCtrlStrategy WHERE FID = 930362787035783168;
INSERT INTO T_BD_DefaultCtrlStrategy(FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FDATATYPE,FDISABLEDATE,FMASTERID,FSTATUS,FAPPSYSTEMID,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID)
VALUES (930362787035783168,914427355726916608,'1','2',NULL,930362787035783168,'C','0MBB4=9D3YI9',' ','5','mds_vrds',{ts'2018-08-18  00:00:00'},'1',1,' ',{ts'2018-08-18  00:00:00'},1,'1',0);

--pengfei_he  需求类型
DELETE FROM T_BD_DefaultCtrlStrategy WHERE FID = 930364427587461120;
INSERT INTO T_BD_DefaultCtrlStrategy(FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FDATATYPE,FDISABLEDATE,FMASTERID,FSTATUS,FAPPSYSTEMID,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID)
VALUES (930364427587461120,914427355726916608,'1','2',NULL,930364427587461120,'C','0MBB4=9D3YI9',' ','5','mds_dmtp',{ts'2018-08-18  00:00:00'},'1',1,' ',{ts'2018-08-18  00:00:00'},1,'1',0);

--huanghaiyang 配额 2020-10-31 全局共享
DELETE FROM T_BD_DefaultCtrlStrategy WHERE FID = 1014405761209737216;
INSERT INTO T_BD_DefaultCtrlStrategy(FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FDATATYPE,FDISABLEDATE,FMASTERID,FSTATUS,FAPPSYSTEMID,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID)
VALUES (1014405761209737216,914427355726916608,'1','2',NULL,1014405761209737216,'C','0MBB4=9D3YI9',' ','5','mds_quotadata',{ts'2018-08-18  00:00:00'},'1',1,' ',{ts'2018-08-18  00:00:00'},1,'1',0);

--huanghaiyang dps计算表设置 全局共享
DELETE FROM T_BD_DefaultCtrlStrategy WHERE FID = 1027321971161157632;
INSERT INTO T_BD_DefaultCtrlStrategy(FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FDATATYPE,FDISABLEDATE,FMASTERID,FSTATUS,FAPPSYSTEMID,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID)
VALUES (1027321971161157632,914427355726916608,'1','2',NULL,1027321971161157632,'C','0MBB4=9D3YI9',' ','5','mds_dpsarrangeset',{ts'2018-08-18  00:00:00'},'1',1,' ',{ts'2018-08-18  00:00:00'},1,'1',0);

-- 安全库存 全局共享
DELETE FROM T_BD_DefaultCtrlStrategy WHERE FID = 994817856552055808;
INSERT INTO T_BD_DefaultCtrlStrategy(FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FDATATYPE,FDISABLEDATE,FMASTERID,FSTATUS,FAPPSYSTEMID,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FCREATETIME,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID)
VALUES (994817856552055808,914427355726916608,'1','2',NULL,994817856552055808,'C','0MBB4=9D3YI9',' ','5','mds_safetystock',{ts'2018-08-08 18:08:08'},'1',1,' ',{ts'2018-08-08 18:08:08'},1,'1',0);