-- 通用映射配置6个库存报表配置
DELETE FROM t_sbs_billfieldmap WHERE FID = 1935682334569500672;
INSERT INTO t_sbs_billfieldmap(FID,FMODIFYDATE,FTARGETOBJ,FSOURCEBILL,FMODIFIERID,FCREATEDATE,FBIZAPPID,FISENABLE,FCREATERID,FNUMBER,FNAME,FISSYSINIT) VALUES (1935682334569500672,{ts'2024-04-28  00:00:00'},'msbd_datactrlmodel','im_sum_repo',13466739,{ts'2024-04-24  00:00:00'},'1UYTX8AD4TSG','1',13466739,'msbd_datactrlmodel_im_sum_rpt','数据控制模型_物料收发汇总表','1');
DELETE FROM t_sbs_billfieldmap WHERE FID = 1938564182924594176;
INSERT INTO t_sbs_billfieldmap(FID,FMODIFYDATE,FTARGETOBJ,FSOURCEBILL,FMODIFIERID,FCREATEDATE,FBIZAPPID,FISENABLE,FCREATERID,FNUMBER,FNAME,FISSYSINIT) VALUES (1938564182924594176,{ts'2024-04-28  00:00:00'},'msbd_datactrlmodel','im_detail_repo',13466739,{ts'2024-04-28  00:00:00'},'1UYTX8AD4TSG','1',13466739,'msbd_datactrlmodel_im_detail_rpt','数据控制模型_物料收发明细表','1');
DELETE FROM t_sbs_billfieldmap WHERE FID = 1938566306542528512;
INSERT INTO t_sbs_billfieldmap(FID,FMODIFYDATE,FTARGETOBJ,FSOURCEBILL,FMODIFIERID,FCREATEDATE,FBIZAPPID,FISENABLE,FCREATERID,FNUMBER,FNAME,FISSYSINIT) VALUES (1938566306542528512,{ts'2024-04-28  00:00:00'},'msbd_datactrlmodel','im_shelf_life_repo',13466739,{ts'2024-04-28  00:00:00'},'1UYTX8AD4TSG','1',13466739,'msbd_datactrlmodel_im_shelf_life_rpt','数据控制模型_保质期分析表','1');
DELETE FROM t_sbs_billfieldmap WHERE FID = 1938568982550547456;
INSERT INTO t_sbs_billfieldmap(FID,FMODIFYDATE,FTARGETOBJ,FSOURCEBILL,FMODIFIERID,FCREATEDATE,FBIZAPPID,FISENABLE,FCREATERID,FNUMBER,FNAME,FISSYSINIT) VALUES (1938568982550547456,{ts'2024-04-28  00:00:00'},'msbd_datactrlmodel','im_age_repo',13466739,{ts'2024-04-28  00:00:00'},'1UYTX8AD4TSG','1',13466739,'msbd_datactrlmodel_im_age_rpt','数据控制模型_库存账龄分析表','1');
DELETE FROM t_sbs_billfieldmap WHERE FID = 1938569664510823424;
INSERT INTO t_sbs_billfieldmap(FID,FMODIFYDATE,FTARGETOBJ,FSOURCEBILL,FMODIFIERID,FCREATEDATE,FBIZAPPID,FISENABLE,FCREATERID,FNUMBER,FNAME,FISSYSINIT) VALUES (1938569664510823424,{ts'2024-04-28  00:00:00'},'msbd_datactrlmodel','im_dull_repo',13466739,{ts'2024-04-28  00:00:00'},'1UYTX8AD4TSG','1',13466739,'msbd_datactrlmodel_im_dull_rpt','数据控制模型_库存呆滞料分析表','1');
DELETE FROM t_sbs_billfieldmap WHERE FID = 1915879371722201088;
INSERT INTO t_sbs_billfieldmap(FID,FMODIFYDATE,FTARGETOBJ,FSOURCEBILL,FMODIFIERID,FCREATEDATE,FBIZAPPID,FISENABLE,FCREATERID,FNUMBER,FNAME,FISSYSINIT) VALUES (1915879371722201088,{ts'2024-04-03  00:00:00'},'msbd_datactrlmodel','im_real_bal_repo',397177616412442636,{ts'2024-03-28  00:00:00'},'1UYTX8AD4TSG','1',397177616412442636,'msbd_datactrlmodel_im_real_bal','数据控制模型_即时库存报表','1');


DELETE FROM T_SBS_BILLFIELDMAP_L WHERE FPKID = '41RNY1A9PWLA';
INSERT INTO T_SBS_BILLFIELDMAP_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1935682334569500672,'41RNY1A9PWLA','zh_CN','数据控制模型_物料收发汇总表');
DELETE FROM T_SBS_BILLFIELDMAP_L WHERE FPKID = '41RNY1A9PWLB';

DELETE FROM T_SBS_BILLFIELDMAP_L WHERE FPKID = '423GD0IDTJKE';
INSERT INTO T_SBS_BILLFIELDMAP_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1938564182924594176,'423GD0IDTJKE','zh_CN','数据控制模型_物料收发明细表');
DELETE FROM T_SBS_BILLFIELDMAP_L WHERE FPKID = '423GD0IDTJKF';

DELETE FROM T_SBS_BILLFIELDMAP_L WHERE FPKID = '423GSI0IJC+G';
INSERT INTO T_SBS_BILLFIELDMAP_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1938566306542528512,'423GSI0IJC+G','zh_CN','数据控制模型_保质期分析表');
DELETE FROM T_SBS_BILLFIELDMAP_L WHERE FPKID = '423GSI0IJC+H';

DELETE FROM T_SBS_BILLFIELDMAP_L WHERE FPKID = '423H=/J1I+ET';
INSERT INTO T_SBS_BILLFIELDMAP_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1938568982550547456,'423H=/J1I+ET','zh_CN','数据控制模型_库存账龄分析表');
DELETE FROM T_SBS_BILLFIELDMAP_L WHERE FPKID = '423H=/J1I+EU';

DELETE FROM T_SBS_BILLFIELDMAP_L WHERE FPKID = '423HE+BK=R/1';
INSERT INTO T_SBS_BILLFIELDMAP_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1938569664510823424,'423HE+BK=R/1','zh_CN','数据控制模型_库存呆滞料分析表');
DELETE FROM T_SBS_BILLFIELDMAP_L WHERE FPKID = '423HE+BK=R/2';

DELETE FROM T_SBS_BILLFIELDMAP_L WHERE FPKID = '4/BB49ZUCA9V';

DELETE FROM T_SBS_BILLFIELDMAP_L WHERE FPKID = '4/ASU72Q08WJ';
INSERT INTO T_SBS_BILLFIELDMAP_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1915879371722201088,'4/ASU72Q08WJ','zh_CN','数据控制模型_即时库存报表');
DELETE FROM T_SBS_BILLFIELDMAP_L WHERE FPKID = '4/ASU72Q08WK';




DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1935682334569377792;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('org',' ',1935682334569500672,'组织',' ','库存组织','0',1935682334569377792,1,'org',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1935682334569377793;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('material',' ',1935682334569500672,'物料',' ','物料','0',1935682334569377793,2,'material',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1935682334569377794;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('warehouse',' ',1935682334569500672,'仓库',' ','仓库','0',1935682334569377794,3,'warehouse',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1938564182924470272;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('org',' ',1938564182924594176,'组织',' ','库存组织','0',1938564182924470272,1,'org',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1938564182924470273;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('material',' ',1938564182924594176,'物料',' ','物料','0',1938564182924470273,2,'material',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1938564182924470274;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('warehouse',' ',1938564182924594176,'仓库',' ','仓库','0',1938564182924470274,3,'warehouse',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1938566306542652416;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('org',' ',1938566306542528512,'组织',' ','库存组织','0',1938566306542652416,1,'org',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1938566306542652417;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('material',' ',1938566306542528512,'物料',' ','物料','0',1938566306542652417,2,'material',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1938566306542652418;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('warehouse',' ',1938566306542528512,'仓库',' ','仓库','0',1938566306542652418,3,'warehouse',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1938568982550423552;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('org',' ',1938568982550547456,'组织',' ','库存组织','0',1938568982550423552,1,'org',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1938568982550423553;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('material',' ',1938568982550547456,'物料',' ','物料','0',1938568982550423553,2,'material',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1938568982550423554;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('warehouse',' ',1938568982550547456,'仓库',' ','仓库','0',1938568982550423554,3,'warehouse',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1938569664510699520;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('org',' ',1938569664510823424,'组织',' ','库存组织','0',1938569664510699520,1,'org',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1938569664510699521;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('material',' ',1938569664510823424,'物料',' ','物料','0',1938569664510699521,2,'material',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1938569664510699522;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('warehouse',' ',1938569664510823424,'仓库',' ','仓库','0',1938569664510699522,3,'warehouse',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1915879371722202112;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('org',' ',1915879371722201088,'组织',' ','库存组织','0',1915879371722202112,1,'org',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1915879371722202113;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('material',' ',1915879371722201088,'物料',' ','物料','0',1915879371722202113,2,'material',' ');
DELETE FROM T_SBS_BILLFIELDMAP_E WHERE FENTRYID = 1915879371722202114;
INSERT INTO T_SBS_BILLFIELDMAP_E(FTARGETOBJCOL,FFORMULADESC,FID,FTARGETOBJCOLNO,FFORMULA_TAG,FSOURCEBILLCOLNO,FSELECTVALUE,FENTRYID,FSEQ,FSOURCEBILLCOL,FFORMULA) VALUES ('warehouse',' ',1915879371722201088,'仓库',' ','仓库','0',1915879371722202114,3,'warehouse',' ');



-- 库存报表共12个数据控制策略
DELETE FROM T_MSBD_DATACTRLSTRATEGY WHERE FID = 1916024910153652224;
INSERT INTO T_MSBD_DATACTRLSTRATEGY(FID,FCTRLFIELD,FBIZBILL,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FDISABLETIME,FCREATETIME,FBILLMAPPINGID,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1916024910153652224,'warehouse','im_real_bal_repo',' ',1916024910153652224,'C','im_real_bal_wh_ctrl','即时库存报表仓库数据控制策略',NULL,{ts'2024-03-28  00:00:00'},1915879371722201088,'1',397177616412442636,{ts'2024-04-03  00:00:00'},397177616412442636,'1',0);
DELETE FROM T_MSBD_DATACTRLSTRATEGY WHERE FID = 1920262981556399104;
INSERT INTO T_MSBD_DATACTRLSTRATEGY(FID,FCTRLFIELD,FBIZBILL,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FDISABLETIME,FCREATETIME,FBILLMAPPINGID,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1920262981556399104,'material','im_real_bal_repo',' ',1920262981556399104,'C','im_real_bal_mat_ctrl','即时库存报表物料数据控制策略',NULL,{ts'2024-04-03  00:00:00'},1915879371722201088,'1',397177616412442636,{ts'2024-04-03  00:00:00'},397177616412442636,'1',0);
DELETE FROM T_MSBD_DATACTRLSTRATEGY WHERE FID = 1961589222695737344;
INSERT INTO T_MSBD_DATACTRLSTRATEGY(FID,FCTRLFIELD,FBIZBILL,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FDISABLETIME,FCREATETIME,FBILLMAPPINGID,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1961589222695737344,'warehouse','im_age_repo',' ',1961589222695737344,'C','im_age_rpt_wh_ctrl','库存账龄分析表仓库数据控制策略',NULL,{ts'2024-05-30  00:00:00'},1938568982550547456,'1',13466739,{ts'2024-05-30  00:00:00'},13466739,'1',0);
DELETE FROM T_MSBD_DATACTRLSTRATEGY WHERE FID = 1938571585283951616;
INSERT INTO T_MSBD_DATACTRLSTRATEGY(FID,FCTRLFIELD,FBIZBILL,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FDISABLETIME,FCREATETIME,FBILLMAPPINGID,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1938571585283951616,'material','im_sum_repo',' ',1938571585283951616,'C','im_sum_rpt_mat_ctrl','物料收发汇总表物料数据控制策略',NULL,{ts'2024-04-28  00:00:00'},1935682334569500672,'1',13466739,{ts'2024-04-28  00:00:00'},13466739,'1',0);
DELETE FROM T_MSBD_DATACTRLSTRATEGY WHERE FID = 1938572392813300736;
INSERT INTO T_MSBD_DATACTRLSTRATEGY(FID,FCTRLFIELD,FBIZBILL,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FDISABLETIME,FCREATETIME,FBILLMAPPINGID,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1938572392813300736,'warehouse','im_sum_repo',' ',1938572392813300736,'C','im_sum_rpt_wh_ctrl','物料收发汇总表仓库数据策略',NULL,{ts'2024-04-28  00:00:00'},1935682334569500672,'1',13466739,{ts'2024-04-28  00:00:00'},13466739,'1',0);
DELETE FROM T_MSBD_DATACTRLSTRATEGY WHERE FID = 1961589950793357312;
INSERT INTO T_MSBD_DATACTRLSTRATEGY(FID,FCTRLFIELD,FBIZBILL,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FDISABLETIME,FCREATETIME,FBILLMAPPINGID,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1961589950793357312,'material','im_dull_repo',' ',1961589950793357312,'C','im_dull_rpt_mat_ctrl','库存呆滞料分析表物料数据控制策略',NULL,{ts'2024-05-30  00:00:00'},1938569664510823424,'1',13466739,{ts'2024-05-30  00:00:00'},13466739,'1',0);
DELETE FROM T_MSBD_DATACTRLSTRATEGY WHERE FID = 1961590396823909376;
INSERT INTO T_MSBD_DATACTRLSTRATEGY(FID,FCTRLFIELD,FBIZBILL,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FDISABLETIME,FCREATETIME,FBILLMAPPINGID,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1961590396823909376,'warehouse','im_dull_repo',' ',1961590396823909376,'C','im_dull_rpt_wh_ctrl','库存呆滞料分析表仓库数据控制策略',NULL,{ts'2024-05-30  00:00:00'},1938569664510823424,'1',13466739,{ts'2024-05-30  00:00:00'},13466739,'1',0);
DELETE FROM T_MSBD_DATACTRLSTRATEGY WHERE FID = 1961591166856304640;
INSERT INTO T_MSBD_DATACTRLSTRATEGY(FID,FCTRLFIELD,FBIZBILL,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FDISABLETIME,FCREATETIME,FBILLMAPPINGID,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1961591166856304640,'material','im_shelf_life_repo',' ',1961591166856304640,'C','im_shelf_life_rpt_mat_ctrl','保质期分析表物料数据控制策略',NULL,{ts'2024-05-30  00:00:00'},1938566306542528512,'1',13466739,{ts'2024-05-30  00:00:00'},13466739,'1',0);
DELETE FROM T_MSBD_DATACTRLSTRATEGY WHERE FID = 1961591557824033792;
INSERT INTO T_MSBD_DATACTRLSTRATEGY(FID,FCTRLFIELD,FBIZBILL,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FDISABLETIME,FCREATETIME,FBILLMAPPINGID,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1961591557824033792,'warehouse','im_shelf_life_repo',' ',1961591557824033792,'C','im_shelf_life_rpt_wh_ctrl','保质期分析表仓库数据控制策略',NULL,{ts'2024-05-30  00:00:00'},1938566306542528512,'1',13466739,{ts'2024-05-30  00:00:00'},13466739,'1',0);
DELETE FROM T_MSBD_DATACTRLSTRATEGY WHERE FID = 1961584629706241024;
INSERT INTO T_MSBD_DATACTRLSTRATEGY(FID,FCTRLFIELD,FBIZBILL,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FDISABLETIME,FCREATETIME,FBILLMAPPINGID,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1961584629706241024,'material','im_detail_repo',' ',1961584629706241024,'C','im_detail_rpt_mat_ctrl','物料收发明细表物料数据控制策略',NULL,{ts'2024-05-30  00:00:00'},1938564182924594176,'1',13466739,{ts'2024-05-30  00:00:00'},13466739,'1',0);
DELETE FROM T_MSBD_DATACTRLSTRATEGY WHERE FID = 1961585979575998464;
INSERT INTO T_MSBD_DATACTRLSTRATEGY(FID,FCTRLFIELD,FBIZBILL,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FDISABLETIME,FCREATETIME,FBILLMAPPINGID,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1961585979575998464,'warehouse','im_detail_repo',' ',1961585979575998464,'C','im_detail_rpt_wh_ctrl','物料收发明细表仓库数据控制策略',NULL,{ts'2024-05-30  00:00:00'},1938564182924594176,'1',13466739,{ts'2024-05-30  00:00:00'},13466739,'1',0);
DELETE FROM T_MSBD_DATACTRLSTRATEGY WHERE FID = 1961588758948197376;
INSERT INTO T_MSBD_DATACTRLSTRATEGY(FID,FCTRLFIELD,FBIZBILL,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FDISABLETIME,FCREATETIME,FBILLMAPPINGID,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1961588758948197376,'material','im_age_repo',' ',1961588758948197376,'C','im_age_rpt_mat_ctrl','库存账龄分析表物料数据控制策略',NULL,{ts'2024-05-30  00:00:00'},1938568982550547456,'1',13466739,{ts'2024-05-30  00:00:00'},13466739,'1',0);


DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '4/BH/R2AMBFZ';
INSERT INTO T_MSBD_DATACTRLSTRATEGY_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1916024910153652224,'4/BH/R2AMBFZ','zh_CN',' ','即时库存报表仓库数据控制策略');
DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '4/BH/R2AMBG+';

DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '4/VSWHGZHJNP';
INSERT INTO T_MSBD_DATACTRLSTRATEGY_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1920262981556399104,'4/VSWHGZHJNP','zh_CN',' ','即时库存报表物料数据控制策略');
DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '4/VSWHGZHJNQ';

DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '4/C6V3CJBXCW';

DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '4/W4=GICNQQ4';

DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '423HS+B3=FX7';
INSERT INTO T_MSBD_DATACTRLSTRATEGY_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1938571585283951616,'423HS+B3=FX7','zh_CN',' ','物料收发汇总表物料数据控制策略');
DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '423HS+B3=FX8';

DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '423HXVQ5ZLCT';
INSERT INTO T_MSBD_DATACTRLSTRATEGY_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1938572392813300736,'423HXVQ5ZLCT','zh_CN',' ','物料收发汇总表仓库数据策略');
DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '423HXVQ5ZLCU';

DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YRNN5HUIR=';
INSERT INTO T_MSBD_DATACTRLSTRATEGY_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1961584629706241024,'44YRNN5HUIR=','zh_CN',' ','物料收发明细表物料数据控制策略');
DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YRNN5HUIRA';

DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YRXGN/YRU/';
INSERT INTO T_MSBD_DATACTRLSTRATEGY_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1961585979575998464,'44YRXGN/YRU/','zh_CN',' ','物料收发明细表仓库数据控制策略');
DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YRXGN/YRU0';

DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YSEQI38/QT';
INSERT INTO T_MSBD_DATACTRLSTRATEGY_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1961588758948197376,'44YSEQI38/QT','zh_CN',' ','库存账龄分析表物料数据控制策略');
DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YSEQI38/QU';

DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YSI3A106T0';
INSERT INTO T_MSBD_DATACTRLSTRATEGY_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1961589222695737344,'44YSI3A106T0','zh_CN',' ','库存账龄分析表仓库数据控制策略');
DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YSI3A106T1';

DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YSNE8/LZ1A';
INSERT INTO T_MSBD_DATACTRLSTRATEGY_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1961589950793357312,'44YSNE8/LZ1A','zh_CN',' ','库存呆滞料分析表物料数据控制策略');
DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YSNE8/LZ1B';

DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YSQO+HQ///';
INSERT INTO T_MSBD_DATACTRLSTRATEGY_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1961590396823909376,'44YSQO+HQ///','zh_CN',' ','库存呆滞料分析表仓库数据控制策略');
DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YSQO+HQ//0';

DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YSW9U54TLB';
INSERT INTO T_MSBD_DATACTRLSTRATEGY_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1961591166856304640,'44YSW9U54TLB','zh_CN',' ','保质期分析表物料数据控制策略');
DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YSW9U54TLC';

DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YSZ3YFLY9D';
INSERT INTO T_MSBD_DATACTRLSTRATEGY_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1961591557824033792,'44YSZ3YFLY9D','zh_CN',' ','保质期分析表仓库数据控制策略');
DELETE FROM T_MSBD_DATACTRLSTRATEGY_l WHERE FPKID = '44YSZ3YFLY9E';



DELETE FROM T_MSBD_DCSTRATEGYENTRY WHERE FENTRYID = 1961584630259889152;
INSERT INTO T_MSBD_DCSTRATEGYENTRY(FID,FLEFTBRACKET,FENTRYID,FSEQ,FDATACTRLSCHEMEID,FRIGHTBRACKET,FLOGIC) VALUES (1961584629706241024,' ',1961584630259889152,1,1918983502997487616,' ','&');
DELETE FROM T_MSBD_DCSTRATEGYENTRY WHERE FENTRYID = 1916024910447253504;
INSERT INTO T_MSBD_DCSTRATEGYENTRY(FID,FLEFTBRACKET,FENTRYID,FSEQ,FDATACTRLSCHEMEID,FRIGHTBRACKET,FLOGIC) VALUES (1916024910153652224,' ',1916024910447253504,1,1916023357799798784,' ','&');
DELETE FROM T_MSBD_DCSTRATEGYENTRY WHERE FENTRYID = 1920262981850000384;
INSERT INTO T_MSBD_DCSTRATEGYENTRY(FID,FLEFTBRACKET,FENTRYID,FSEQ,FDATACTRLSCHEMEID,FRIGHTBRACKET,FLOGIC) VALUES (1920262981556399104,' ',1920262981850000384,1,1918983502997487616,' ','&');
DELETE FROM T_MSBD_DCSTRATEGYENTRY WHERE FENTRYID = 1938571585703382016;
INSERT INTO T_MSBD_DCSTRATEGYENTRY(FID,FLEFTBRACKET,FENTRYID,FSEQ,FDATACTRLSCHEMEID,FRIGHTBRACKET,FLOGIC) VALUES (1938571585283951616,' ',1938571585703382016,1,1918983502997487616,' ','&');
DELETE FROM T_MSBD_DCSTRATEGYENTRY WHERE FENTRYID = 1938572392855243776;
INSERT INTO T_MSBD_DCSTRATEGYENTRY(FID,FLEFTBRACKET,FENTRYID,FSEQ,FDATACTRLSCHEMEID,FRIGHTBRACKET,FLOGIC) VALUES (1938572392813300736,' ',1938572392855243776,1,1916023357799798784,' ','&');
DELETE FROM T_MSBD_DCSTRATEGYENTRY WHERE FENTRYID = 1961587032337789952;
INSERT INTO T_MSBD_DCSTRATEGYENTRY(FID,FLEFTBRACKET,FENTRYID,FSEQ,FDATACTRLSCHEMEID,FRIGHTBRACKET,FLOGIC) VALUES (1961585979575998464,' ',1961587032337789952,1,1916023357799798784,' ','&');
DELETE FROM T_MSBD_DCSTRATEGYENTRY WHERE FENTRYID = 1961588758973363200;
INSERT INTO T_MSBD_DCSTRATEGYENTRY(FID,FLEFTBRACKET,FENTRYID,FSEQ,FDATACTRLSCHEMEID,FRIGHTBRACKET,FLOGIC) VALUES (1961588758948197376,' ',1961588758973363200,1,1918983502997487616,' ','&');
DELETE FROM T_MSBD_DCSTRATEGYENTRY WHERE FENTRYID = 1961589222720903168;
INSERT INTO T_MSBD_DCSTRATEGYENTRY(FID,FLEFTBRACKET,FENTRYID,FSEQ,FDATACTRLSCHEMEID,FRIGHTBRACKET,FLOGIC) VALUES (1961589222695737344,' ',1961589222720903168,1,1916023357799798784,' ','&');
DELETE FROM T_MSBD_DCSTRATEGYENTRY WHERE FENTRYID = 1961589950826911744;
INSERT INTO T_MSBD_DCSTRATEGYENTRY(FID,FLEFTBRACKET,FENTRYID,FSEQ,FDATACTRLSCHEMEID,FRIGHTBRACKET,FLOGIC) VALUES (1961589950793357312,' ',1961589950826911744,1,1918983502997487616,' ','&');
DELETE FROM T_MSBD_DCSTRATEGYENTRY WHERE FENTRYID = 1961590396849075200;
INSERT INTO T_MSBD_DCSTRATEGYENTRY(FID,FLEFTBRACKET,FENTRYID,FSEQ,FDATACTRLSCHEMEID,FRIGHTBRACKET,FLOGIC) VALUES (1961590396823909376,' ',1961590396849075200,1,1916023357799798784,' ','&');
DELETE FROM T_MSBD_DCSTRATEGYENTRY WHERE FENTRYID = 1961591166881470464;
INSERT INTO T_MSBD_DCSTRATEGYENTRY(FID,FLEFTBRACKET,FENTRYID,FSEQ,FDATACTRLSCHEMEID,FRIGHTBRACKET,FLOGIC) VALUES (1961591166856304640,' ',1961591166881470464,1,1918983502997487616,' ','&');
DELETE FROM T_MSBD_DCSTRATEGYENTRY WHERE FENTRYID = 1961591557849199616;
INSERT INTO T_MSBD_DCSTRATEGYENTRY(FID,FLEFTBRACKET,FENTRYID,FSEQ,FDATACTRLSCHEMEID,FRIGHTBRACKET,FLOGIC) VALUES (1961591557824033792,' ',1961591557849199616,1,1916023357799798784,' ','&');
