-- 制造报表扩展 - 组件替代方案报表注册模型（系统预置）
DELETE FROM t_msplan_reportextmodel WHERE FID = 1879823060438136832;
INSERT INTO t_msplan_reportextmodel(FID,FREPORTENTITY,FCREATETIME,FMODIFIERID,FENABLE,FISSYSSET,FMODIFYTIME,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (1879823060438136832,'pdm_replaceplanrep_set',{ts'2018-08-08  00:00:00'},1,'1','0',{ts'2018-08-08  00:00:00'},1879823060438136832,'C',1,'replacePlanExtSet_S'); 

DELETE FROM t_msplan_reportextmodel_l WHERE FPKID = '3WX0VGW45V=M';
INSERT INTO t_msplan_reportextmodel_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1879823060438136832,'3WX0VGW45V=M','zh_CN','组件替代方案报表注册模型（系统预置）','组件替代方案报表扩展设置'); 
DELETE FROM t_msplan_reportextmodel_l WHERE FPKID = '3WX0VGW45V=N';
INSERT INTO t_msplan_reportextmodel_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1879823060438136832,'3WX0VGW45V=N','zh_TW','組件替代方案報表注冊模型（係統預置）','組件替代方案報表擴展設置'); 

insert into t_mrp_bftransfer_u (fdataid,fuseorgid)
select fid ,fcreateorgid
from t_mrp_bftransfer a 
where a.fid in (1879823060438136832)
and not exists(select 1 from t_mrp_bftransfer_u b where b.fdataid  = a.fid and b.fuseorgid  = a.fcreateorgid );

-- 字段
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1891461502888579072;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1891461502888579072,'长整数','1','id',' ',' ',' ',' ',1,'组件替代方案ID','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888330059085874181;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888330059085874181,'组织','0','createorg',' ',' ',' ',' ',2,'创建组织','0','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781056;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781056,'文本型','1','number',' ',' ',' ',' ',3,'替代编码','0','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1910096126107830272;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1910096126107830272,'多语言文本型','0','name',' ',' ',' ',' ',4,'替代名称','0','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781078;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781078,'物料','1','material',' ',' ',' ',' ',5,'主料编码','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888355553927852032;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888355553927852032,'文本型','1','maternumber',' ',' ',' ',' ',6,'主料编码','0','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888355553927852033;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888355553927852033,'文本型','1','matername',' ',' ',' ',' ',7,'主料名称','0','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781077;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781077,'整数','1','priority',' ',' ',' ',' ',8,'优先级','0','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781063;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781063,'下拉列表','1','replacestra',' ',' ',' ',' ',9,'替代策略','0','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781064;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781064,'下拉列表','1','replacemethod',' ',' ',' ',' ',10,'替代方式','0','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1891458925119671296;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1891458925119671296,'长整数','1','mainmaterentryid',' ',' ',' ',' ',11,'主料分录ID','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1891458925119671297;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1891458925119671297,'多语言文本型','1','modelnum',' ',' ',' ',' ',12,'规格型号','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781079;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781079,'弹性域','1','auxpty',' ',' ',' ',' ',13,'辅助属性','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781080;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781080,'基础资料','1','bomversion',' ',' ',' ',' ',14,'BOM版本','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781081;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781081,'布尔型','1','isreplace',' ',' ',' ',' ',15,'替代主料','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781082;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781082,'基础资料','1','unit',' ',' ',' ',' ',16,'计量单位','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781083;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781083,'数量型','1','mole',' ',' ',' ',' ',17,'用量：分子','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781084;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781084,'数量型','1','deno',' ',' ',' ',' ',18,'用量：分母','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781085;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781085,'整数','1','useratio',' ',' ',' ',' ',19,'使用比例(%)','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1891458925119671298;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1891458925119671298,'长整数','1','repmaterentryid',' ',' ',' ',' ',20,'替代料分录ID','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781086;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781086,'整数','1','reppriority',' ',' ',' ',' ',21,'优先级','0','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781087;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781087,'物料','1','repmaterial',' ',' ',' ',' ',22,'替代物料编码','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888383290583379968;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888383290583379968,'文本型','1','repmaternumber',' ',' ',' ',' ',23,'替代物料编码','0','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888383290583379969;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888383290583379969,'文本型','1','repmatername',' ',' ',' ',' ',24,'替代物料名称','0','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1891458925119671299;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1891458925119671299,'多语言文本型','1','repmodelnum',' ',' ',' ',' ',25,'规格型号','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781088;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781088,'弹性域','1','repauxpty',' ',' ',' ',' ',26,'辅助属性','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781089;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781089,'基础资料','1','repbomversion',' ',' ',' ',' ',27,'BOM版本','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781090;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781090,'布尔型','1','isrep',' ',' ',' ',' ',28,'替代主料','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781091;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781091,'基础资料','1','repunit',' ',' ',' ',' ',29,'计量单位','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781092;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781092,'下拉列表','1','repqtytype',' ',' ',' ',' ',30,'用量类型','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781093;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781093,'数量型','1','repmole',' ',' ',' ',' ',31,'用量：分子','0','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781095;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781095,'数量型','1','repdeno',' ',' ',' ',' ',32,'用量：分母','0','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781094;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781094,'整数','1','repuseratio',' ',' ',' ',' ',33,'使用比例(%)','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781096;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781096,'日期型','1','repeffectdate',' ',' ',' ',' ',34,'生效时间','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781097;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781097,'日期型','1','repinvaliddate',' ',' ',' ',' ',35,'失效时间','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781098;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781098,'数量型','1','repfixscrap',' ',' ',' ',' ',36,'固定损耗','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1879873726212781099;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1879873726212781099,' ','1','repscraprate',' ',' ',' ',' ',37,'变动损耗率','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888330059085874176;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888330059085874176,'组织','0','org',' ',' ',' ',' ',38,'组织','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888330059085874177;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888330059085874177,'长整数','0','sourcedata',' ',' ',' ',' ',39,'原资料id','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888330059085874178;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888330059085874178,'组织','0','useorg',' ',' ',' ',' ',40,'业务组织','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888330059085874179;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888330059085874179,'整数','0','bitindex',' ',' ',' ',' ',41,'位图','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888330059085874180;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888330059085874180,'整数','0','srcindex',' ',' ',' ',' ',42,'原资料位图','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888330059085874182;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888330059085874182,'日期型','0','effectdate',' ',' ',' ',' ',43,'生效日期','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888330059085874183;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888330059085874183,'日期型','0','invaliddate',' ',' ',' ',' ',44,'失效日期','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888330059085874184;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888330059085874184,'下拉列表','0','ctrlstrategy',' ',' ',' ',' ',45,'控制策略','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888330059085874188;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888330059085874188,'用户','0','auditor',' ',' ',' ',' ',46,'审核人','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888330059085874189;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888330059085874189,'日期型','0','audittime',' ',' ',' ',' ',47,'审核时间','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888330059085874190;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888330059085874190,'用户','0','enableor',' ',' ',' ',' ',48,'启用人','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888330059085874191;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888330059085874191,'日期型','0','enabletime',' ',' ',' ',' ',49,'启用时间','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888330059085874192;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888330059085874192,'用户','0','disableor',' ',' ',' ',' ',50,'禁用人','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888330059085874193;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888330059085874193,'日期型','0','disabletime',' ',' ',' ',' ',51,'禁用时间','1','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1888333554962755584;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1888333554962755584,'下拉列表','1','bomuser',' ',' ',' ',' ',52,'BOM使用情况','0','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1910104038872042496;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1910104038872042496,'下拉列表','0','status',' ',' ',' ',' ',53,'数据状态','0','1',' '); 
DELETE FROM t_msplan_reportextcolumn WHERE FENTRYID = 1910104038872042497;
INSERT INTO t_msplan_reportextcolumn(FID,FENTRYID,FDATATYPE,FISSYSSETFIELD,FFIELDNUMBER,FCALCULATEEXC,FCALCULATEEXC_TAG,FDATASOURCEENTITY,FCALCULATETEXT,FSEQ,FFIELDNAME,FFIELDUNVISIBLE,FCONVERTTYPE,FSRCDSNUMBER) VALUES (1879823060438136832,1910104038872042497,'下拉列表','0','enable',' ',' ',' ',' ',54,'使用状态','0','1',' '); 


-- 数据源
DELETE FROM t_msplan_reportextentity WHERE FENTRYID = 1891956824798661632;
INSERT INTO t_msplan_reportextentity(FMATCHDIMENSIONS,FID,FEXTENTITY,FFILTERRULE,FFILTERRULEVALUE_TAG,FENTRYID,FSEQ,FDSNUMBER,FFILTERRULEVALUE) VALUES (1892192201010587648,1879823060438136832,'pdm_replacerepentry',' ',' ',1891956824798661632,2,'DS_002',' '); 
DELETE FROM t_msplan_reportextentity WHERE FENTRYID = 1880668259016031232;
INSERT INTO t_msplan_reportextentity(FMATCHDIMENSIONS,FID,FEXTENTITY,FFILTERRULE,FFILTERRULEVALUE_TAG,FENTRYID,FSEQ,FDSNUMBER,FFILTERRULEVALUE) VALUES (1892191013678622720,1879823060438136832,'pdm_replacemasterentry',' ',' ',1880668259016031232,1,'DS_001',' '); 



-- 实体字段映射
DELETE FROM t_mrp_bftransfer WHERE FID = 1892192201010587648;
INSERT INTO t_mrp_bftransfer(FID,FBITINDEX,FVERSION,FLARGETEXTFIELD,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FFIELDTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FSRCBILL,FISMATCHDIM,FCREATETIME,FSOURCEBITINDEX,FISSYSTEMINSERT,FMODIFIERID,FENABLE,FMODIFYTIME,FDESTBILL,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1892192201010587648,0,' ',' ',100000,0,1892192201010587648,100000,'D','C','5','repPlan_reportExtReplaceEntry','pdm_replacerepentry','1',{ts'2024-02-24  00:00:00'},0,'0',1625981297300078592,'1',{ts'2024-02-24  00:00:00'},'pdm_replaceplanrep_set',1625981297300078592,'{"filterRow":[],"forList":false}'); 
DELETE FROM t_mrp_bftransfer WHERE FID = 1892191013678622720;
INSERT INTO t_mrp_bftransfer(FID,FBITINDEX,FVERSION,FLARGETEXTFIELD,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FFIELDTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FSRCBILL,FISMATCHDIM,FCREATETIME,FSOURCEBITINDEX,FISSYSTEMINSERT,FMODIFIERID,FENABLE,FMODIFYTIME,FDESTBILL,FCREATORID,FLARGETEXTFIELD_TAG) VALUES (1892191013678622720,0,' ',' ',100000,0,1892191013678622720,100000,'D','C','5','repPlan_reportExtMatEntry','pdm_replacemasterentry','1',{ts'2024-02-24  00:00:00'},0,'0',1625981297300078592,'1',{ts'2024-02-24  00:00:00'},'pdm_replaceplanrep_set',1625981297300078592,'{"filterRow":[],"forList":false}'); 

DELETE FROM t_mrp_bftransfer_l WHERE FPKID = '3YEA+6SHJXKT';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1892192201010587648,'3YEA+6SHJXKT','zh_CN','组件替代方案-报表字段集（替代料分录）'); 
DELETE FROM t_mrp_bftransfer_l WHERE FPKID = '3YEA+6SHJXKU';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1892192201010587648,'3YEA+6SHJXKU','zh_TW','組件替代方案-報表字段集（替代料分錄）'); 
DELETE FROM t_mrp_bftransfer_l WHERE FPKID = '3YE=RJBT62U6';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1892191013678622720,'3YE=RJBT62U6','zh_CN','组件替代方案-报表字段集（主料分录）'); 
DELETE FROM t_mrp_bftransfer_l WHERE FPKID = '3YE=RJBT62U7';
INSERT INTO t_mrp_bftransfer_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1892191013678622720,'3YE=RJBT62U7','zh_TW','組件替代方案-報表字段集（主料分錄）'); 

DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1892191013695399936;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1892191013678622720,'mainmaterentryid',1892191013695399936,' ',' ','id ','{"expression":"id ","exprTran":"组件替代方案-主料分录（字段集）.内码 ","description":{"zh_CN":""},"exprDesc":"组件替代方案-主料分录（字段集）.内码 ","localeExprTran":{"zh_CN":"组件替代方案-主料分录（字段集）.内码 "}}',' ','组件替代方案-主料分录（字段集）.内码 ',1,'单据头.主料分录ID','mainmaterentryid','1'); 
DELETE FROM t_mrp_billtranferentry WHERE FENTRYID = 1892192201018976256;
INSERT INTO t_mrp_billtranferentry(FID,FDESTFIELDFLAG,FENTRYID,FSOURCEFIELDFLAG,FSOURCEENTITYFLAG,FCALCULATEEXC,FCALCULATEEXC_TAG,FSOURCEFIELDNAME,FCALCULATETEXT,FSEQ,FDESTFIELDNAME,FDESTENTITYFLAG,FCONVERTTYPE) VALUES (1892192201010587648,'repmaterentryid',1892192201018976256,' ',' ','id','{"expression":"id","exprTran":"组件替代方案-替代料分录（字段集）.内码","description":{"zh_CN":""},"exprDesc":"组件替代方案-替代料分录（字段集）.内码","localeExprTran":{"zh_CN":"组件替代方案-替代料分录（字段集）.内码"}}',' ','组件替代方案-替代料分录（字段集）.内码',1,'单据头.替代料分录ID','repmaterentryid','1'); 
