--报表扩展模型数据处理 四个批量正反查报表及替代报表
update t_msplan_reportextmodel set ffieldappid  = 'pdm' where fid in(1879823060438136832,1759389678651401216,1759389934193566720,1754285651630507008,1754286130653578240);

update t_msplan_reportextmodel set fname  = '组件替代方案报表扩展设置' where fid = 1879823060438136832;

update t_mrp_bftransfer set ffieldtype  = 'pdm' where fid in(1754277959897726976,1754278751874597888,1754319862563357696,1754277175437050880,1759384113330041856,1759385840468976640,1759386671931024384,1759387615859094528,1892191013678622720,1892192201010587648);


DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT3EP6Z';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT3EP6Z','zh_CN',1754285651714392064,'文本型','BOM编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT3EOIP';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT3EOIP','zh_CN',1754286130695520260,'物料','子项物料编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT3EP7+';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT3EP7+','zh_CN',1754285651714392065,'物料','子项物料编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT3EOIQ';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT3EOIQ','zh_CN',1754285651714392066,'下拉列表','子项物料属性'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT3EP7/';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT3EP7/','zh_CN',1754285651714392067,'基础资料','计量单位'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT3EOIR';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT3EOIR','zh_CN',1754285651714392068,'基础资料','子项物料配置号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT3EP70';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT3EP70','zh_CN',1754285651714392069,'基础资料','子项BOM版本号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT3EOIS';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT3EOIS','zh_CN',1754285651714392070,'数量型','标准用量'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT3EP71';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT3EP71','zh_CN',1754286130695520272,'基础资料','特征类编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT3EOIT';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT3EOIT','zh_CN',1754285651714392072,'弹性域','辅助属性'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DG';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DG','zh_CN',1754285651714392073,'组织','生产组织'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712Q7';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712Q7','zh_CN',1754285651714392074,'文本型','BOM层级'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DH';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DH','zh_CN',1754285651714392075,'文本型','层级'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712Q8';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712Q8','zh_CN',1754285651714392076,'布尔型','跳层'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DI';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DI','zh_CN',1754285651714392077,'布尔型','辅料BOM'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712Q9';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712Q9','zh_CN',1754285651714392078,'物料','查询物料编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DJ';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DJ','zh_CN',1754285651714392079,'基础资料','查询配置号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712Q=';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712Q=','zh_CN',1754285651714392080,'文本型','子项物料名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DK';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DK','zh_CN',1754285651714392081,'文本型','子项物料规格型号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712QA';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712QA','zh_CN',1754285651714392082,'文本型','查询物料名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DL';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DL','zh_CN',1754285651714392083,'基础资料','查询版本号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712QB';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712QB','zh_CN',1754285651714392084,'基础资料','查询替代号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DM';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DM','zh_CN',1754286130695520263,'基础资料','子项物料配置号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712QC';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712QC','zh_CN',1754286130695520264,'基础资料','子项BOM版本号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DN';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DN','zh_CN',1895547692688455680,'布尔型','替代件'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712QD';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712QD','zh_CN',1919614820911466496,'文本型','采购组织提前期加5天测试'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DO';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DO','zh_CN',1754286130695520270,'下拉列表','用量类型'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712QE';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712QE','zh_CN',1754286130695520271,'下拉列表','组件类型'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DP';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DP','zh_CN',1754286130695520273,'弹性域','辅助属性'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712QF';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712QF','zh_CN',1754286130695520274,'日期型','生效时间'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DQ';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DQ','zh_CN',1754286130695520275,'日期型','失效时间'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712QG';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712QG','zh_CN',1754286130695520276,'长整数','BOM分录ID'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DR';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DR','zh_CN',1754286130695520277,'长整数','BOM表头ID'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712QH';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712QH','zh_CN',1754286130695520278,'组织','生产组织'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DS';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DS','zh_CN',1754286130695520279,'文本型','BOM层级'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712QI';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712QI','zh_CN',1754286130695520280,'文本型','层级'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DT';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DT','zh_CN',1754286130695520281,'布尔型','跳层'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712QJ';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712QJ','zh_CN',1754286130695520282,'布尔型','辅料BOM'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DU';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DU','zh_CN',1754286130695520283,'物料','查询物料编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712QK';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712QK','zh_CN',1754286130695520284,'基础资料','查询配置号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DV';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DV','zh_CN',1754286130695520285,'文本型','父项物料名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT712QL';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT712QL','zh_CN',1754286130695520286,'文本型','子项物料名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT713DW';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT713DW','zh_CN',1754286130695520287,'文本型','子项物料规格型号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHXQ';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHXQ','zh_CN',1754286130695520288,'文本型','查询物料名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OIL+';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OIL+','zh_CN',1754286130695520289,'基础资料','查询版本号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHXR';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHXR','zh_CN',1754286130695520290,'基础资料','子BOM替代号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OIL/';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OIL/','zh_CN',1754286130695520291,'基础资料','查询替代号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHXS';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHXS','zh_CN',1759389678693299202,'文本型','编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OIL0';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OIL0','zh_CN',1759389678693299203,'组织','生产组织'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHXT';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHXT','zh_CN',1759389678693299205,'物料','查询物料编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OIL1';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OIL1','zh_CN',1759389678693299206,'基础资料','查询版本号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHXU';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHXU','zh_CN',1759389678693299207,'基础资料','查询特征类编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OIL2';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OIL2','zh_CN',1759389678693299208,'基础资料','查询替代号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHXV';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHXV','zh_CN',1759389678693299209,'文本型','父项物料名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OIL3';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OIL3','zh_CN',1759389678693299210,'文本型','父项物料规格型号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHXW';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHXW','zh_CN',1759389678693299211,'文本型','查询物料名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OIL4';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OIL4','zh_CN',1759389678693299212,'文本型','查询特征类名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHXX';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHXX','zh_CN',1759389678693299213,'物料','父项物料编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OIL5';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OIL5','zh_CN',1759389934201910274,'文本型','BOM编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHXY';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHXY','zh_CN',1754286130695520262,'基础资料','计量单位'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OIL6';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OIL6','zh_CN',1754286130695520265,'数量型','用量：分子'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHXZ';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHXZ','zh_CN',1891461502888579072,'长整数','组件替代方案ID'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OIL7';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OIL7','zh_CN',1759389934201910275,'物料','子项物料编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHY+';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHY+','zh_CN',1759389934201910280,'数量型','标准用量'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OIL8';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OIL8','zh_CN',1759389934201910281,'基础资料','子项特征类编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHY/';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHY/','zh_CN',1759389934201910282,'弹性域','辅助属性'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OIL9';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OIL9','zh_CN',1759389934201910283,'组织','生产组织'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHY0';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHY0','zh_CN',1759389934201910284,'文本型','BOM层级'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OIL=';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OIL=','zh_CN',1759389934201910285,'文本型','层级'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHY1';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHY1','zh_CN',1759389934201910286,'物料','查询物料编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OILA';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OILA','zh_CN',1759389934201910287,'基础资料','查询版本号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHY2';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHY2','zh_CN',1759389934201910288,'基础资料','查询替代号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OILB';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OILB','zh_CN',1759389934201910289,'基础资料','子BOM替代号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHY3';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHY3','zh_CN',1759389934201910290,'文本型','父项物料名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OILC';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OILC','zh_CN',1759389934201910291,'文本型','子项物料名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHY4';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHY4','zh_CN',1759389934201910292,'文本型','子项物料规格型号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OILD';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OILD','zh_CN',1759389934201910293,'文本型','查询物料名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHY5';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHY5','zh_CN',1759389934201910294,'物料','父项物料编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OILE';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OILE','zh_CN',1759389934201910295,'数量型','用量：分子'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHY6';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHY6','zh_CN',1759389934201910296,'数量型','用量：分母'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OILF';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OILF','zh_CN',1759389934201910297,'下拉列表','用量类型'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHY7';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHY7','zh_CN',1759389934201910298,'长整数','BOM分录ID'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OILG';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OILG','zh_CN',1759389934201910300,'基础资料','查询特征类编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHY8';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHY8','zh_CN',1759389934201910301,'文本型','查询特征类名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OILH';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OILH','zh_CN',1759389678693299215,'数量型','标准用量'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OHY9';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OHY9','zh_CN',1759389678693299219,'下拉列表','用量类型'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMT=OILI';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMT=OILI','zh_CN',1759389678693299220,'弹性域','辅助属性'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y38';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y38','zh_CN',1759389678693299221,'基础资料','特征类编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YSH';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YSH','zh_CN',1759428679848518656,'基础资料','基本单位'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y39';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y39','zh_CN',1759428679848518657,'下拉列表','物料属性'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YSI';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YSI','zh_CN',1759428679848518658,'基础资料','父项版本号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y3=';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y3=','zh_CN',1759428679848518659,'基础资料','配置号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YSJ';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YSJ','zh_CN',1759389934201910276,'下拉列表','子项物料属性'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y3A';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y3A','zh_CN',1759389934201910279,'基础资料','子项物料版本号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YSK';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YSK','zh_CN',1759430314452673536,'下拉列表','物料属性'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y3B';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y3B','zh_CN',1759430314452673537,'基础资料','配置号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YSL';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YSL','zh_CN',1759430314452673538,'基础资料','基本单位'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y3C';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y3C','zh_CN',1759430314452673539,'基础资料','父项版本号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YSM';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YSM','zh_CN',1759389678693299204,'文本型','层级'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y3D';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y3D','zh_CN',1776932666021603328,'基础资料','特征类名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YSN';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YSN','zh_CN',1776932292971819008,'基础资料','特征类名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y3E';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y3E','zh_CN',1759389934201910299,'基础资料','子项特征类名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YSO';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YSO','zh_CN',1759389678693299222,'基础资料','特征类名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y3F';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y3F','zh_CN',1754285651714392071,'基础资料','特征类编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YSP';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YSP','zh_CN',1879873726212781063,'下拉列表','替代策略'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y3G';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y3G','zh_CN',1879873726212781064,'下拉列表','替代方式'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YSQ';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YSQ','zh_CN',1891458925119671296,'长整数','主料分录ID'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y3H';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y3H','zh_CN',1766042655009435649,'组织','单元测试组织1'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YSR';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YSR','zh_CN',1766042655009435650,'组织','单元测试组织2'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y3I';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y3I','zh_CN',1888330059085874181,'组织','创建组织'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YSS';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YSS','zh_CN',1759389934201910277,'基础资料','子项物料计量单位'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y3J';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y3J','zh_CN',1759389934201910278,'基础资料','子项物料配置号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YST';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YST','zh_CN',1919614820911466498,' ','分子乘分子'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y3K';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y3K','zh_CN',1879873726212781056,'文本型','替代编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YSU';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YSU','zh_CN',1910096126107830272,'多语言文本型','替代名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y3L';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y3L','zh_CN',1754286130695520258,'文本型','BOM编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YSV';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YSV','zh_CN',1754286130695520259,'物料','父项物料编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y3M';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y3M','zh_CN',1754286130695520261,'下拉列表','子项物料属性'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=YSW';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=YSW','zh_CN',1766042655009435648,'文本型','单元测试文本1'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTD=Y3N';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTD=Y3N','zh_CN',1891458925119671297,'多语言文本型','规格型号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYC+/';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYC+/','zh_CN',1754286130695520266,'数量型','用量：分母'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYB=R';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYB=R','zh_CN',1879873726212781080,'基础资料','BOM版本'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYC+0';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYC+0','zh_CN',1879873726212781081,'布尔型','替代主料'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYB=S';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYB=S','zh_CN',1879873726212781082,'基础资料','计量单位'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYC+1';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYC+1','zh_CN',1754286130695520267,'数量型','固定损耗率'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYB=T';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYB=T','zh_CN',1754286130695520268,' ','变动损耗'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYC+2';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYC+2','zh_CN',1754286130695520269,'数量型','标准用量'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYB=U';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYB=U','zh_CN',2001604139276106752,'基础资料','查询WBS'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYC+3';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYC+3','zh_CN',2001604139276106753,'基础资料','WBS'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYB=V';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYB=V','zh_CN',2001604545142083584,'基础资料','查询WBS'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYC+4';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYC+4','zh_CN',2001604545142083585,'基础资料','WBS'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYB=W';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYB=W','zh_CN',1879873726212781085,'整数','使用比例(%)'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYC+5';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYC+5','zh_CN',1891458925119671298,'长整数','替代料分录ID'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYB=X';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYB=X','zh_CN',1879873726212781096,'日期型','生效时间'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYC+6';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYC+6','zh_CN',1879873726212781097,'日期型','失效时间'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYB=Y';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYB=Y','zh_CN',1879873726212781079,'弹性域','辅助属性'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYC+7';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYC+7','zh_CN',2001605044415298560,'基础资料','查询WBS'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYB=Z';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYB=Z','zh_CN',2001605044415298561,'基础资料','WBS'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYC+8';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYC+8','zh_CN',2001605376067260416,'基础资料','查询WBS'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYBA+';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYBA+','zh_CN',1776972218971022336,'组织','采购组织取值测试函数'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYC+9';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYC+9','zh_CN',2001605376067260417,'基础资料','WBS'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYBA/';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYBA/','zh_CN',1817532728594228224,'文本型','查询物料规格型_测试'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYC+=';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYC+=','zh_CN',1879873726212781087,'物料','替代物料编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYBA0';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYBA0','zh_CN',1888383290583379968,'文本型','替代物料编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYC+A';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYC+A','zh_CN',1888383290583379969,'文本型','替代物料名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYBA1';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYBA1','zh_CN',1891458925119671299,'多语言文本型','规格型号'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYC+B';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYC+B','zh_CN',1879873726212781088,'弹性域','辅助属性'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTGYBA2';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTGYBA2','zh_CN',1879873726212781089,'基础资料','BOM版本'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5I';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5I','zh_CN',1879873726212781090,'布尔型','替代主料'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRH9';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRH9','zh_CN',1879873726212781091,'基础资料','计量单位'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5J';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5J','zh_CN',1879873726212781092,'下拉列表','用量类型'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRH=';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRH=','zh_CN',1879873726212781094,'整数','使用比例(%)'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5K';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5K','zh_CN',1879873726212781098,'数量型','固定损耗'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRHA';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRHA','zh_CN',1879873726212781099,' ','变动损耗率'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5L';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5L','zh_CN',1888330059085874176,'组织','组织'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRHB';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRHB','zh_CN',1888330059085874177,'长整数','原资料id'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5M';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5M','zh_CN',1888330059085874178,'组织','业务组织'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRHC';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRHC','zh_CN',1888330059085874179,'整数','位图'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5N';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5N','zh_CN',1888330059085874180,'整数','原资料位图'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRHD';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRHD','zh_CN',1888330059085874182,'日期型','生效日期'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5O';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5O','zh_CN',1888330059085874183,'日期型','失效日期'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRHE';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRHE','zh_CN',1888330059085874184,'下拉列表','控制策略'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5P';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5P','zh_CN',1888330059085874188,'用户','审核人'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRHF';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRHF','zh_CN',1888330059085874189,'日期型','审核时间'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5Q';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5Q','zh_CN',1888330059085874190,'用户','启用人'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRHG';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRHG','zh_CN',1888330059085874191,'日期型','启用时间'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5R';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5R','zh_CN',1888330059085874192,'用户','禁用人'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRHH';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRHH','zh_CN',1888330059085874193,'日期型','禁用时间'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5S';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5S','zh_CN',1888333554962755584,'下拉列表','BOM使用情况'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRHI';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRHI','zh_CN',1910104038872042496,'下拉列表','数据状态'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5T';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5T','zh_CN',1910104038872042497,'下拉列表','使用状态'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRHJ';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRHJ','zh_CN',1879873726212781086,'整数','替代物料优先级'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5U';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5U','zh_CN',1879873726212781093,'数量型','替代物料用量：分子'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRHK';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRHK','zh_CN',1879873726212781095,'数量型','替代物料用量：分母'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5V';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5V','zh_CN',1879873726212781083,'数量型','主物料用量：分子'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRHL';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRHL','zh_CN',1879873726212781084,'数量型','主物料用量：分母'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5W';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5W','zh_CN',1879873726212781078,'物料','主物料编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRHM';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRHM','zh_CN',1888355553927852032,'文本型','主物料编码'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJS5X';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJS5X','zh_CN',1888355553927852033,'文本型','主物料名称'); 
DELETE FROM t_msplan_reportextcolumn_l WHERE FPKID = '4CO1LMTKJRHN';
INSERT INTO t_msplan_reportextcolumn_l(FPKID,FLOCALEID,FENTRYID,FDATATYPE,FFIELDNAME) VALUES ('4CO1LMTKJRHN','zh_CN',1879873726212781077,'整数','主物料优先级'); 

