--预设检查项

DELETE FROM t_msplan_checkfilterentry WHERE FENTRYID = 1963201113796730880;
INSERT INTO t_msplan_checkfilterentry(FID,FFILTERENTITY,FFILTERRULE,FFILTERRULEVALUE_TAG,FENTRYID,FSEQ,FFILTERRULEVALUE,FENTITYTYPE) VALUES (1963201113771565056,'bd_materialmftinfo','数据状态 等于 已审核并且 使用状态 等于 可用 ','{"filterRow":[{"id":"454HKV4O/D24","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"454HKV4O04PE","value":"C"}],"baseDataIds":[],"lock":false},{"id":"454HKV4O/D25","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"454HKV4O04PF","value":"1"}],"baseDataIds":[],"lock":false}],"forList":false}',1963201113796730880,1,' ','A'); 

DELETE FROM t_msplan_checkfilterentry WHERE FENTRYID = 1963201113796730881;
INSERT INTO t_msplan_checkfilterentry(FID,FFILTERENTITY,FFILTERRULE,FFILTERRULEVALUE_TAG,FENTRYID,FSEQ,FFILTERRULEVALUE,FENTITYTYPE) VALUES (1963201113771565056,'mpdm_materialplan','数据状态 等于 已审核并且 使用状态 等于 可用 ','{"filterRow":[{"id":"454HLOO0AH00","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"454HLOO0B8NA","value":"C"}],"baseDataIds":[],"lock":false},{"id":"454HLOO0AH01","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"454HLOO0B8NB","value":"1"}],"baseDataIds":[],"lock":false}],"forList":false}',1963201113796730881,2,' ','B'); 

DELETE FROM t_msplan_checkfilterentry WHERE FENTRYID = 1963203548833472512;
INSERT INTO t_msplan_checkfilterentry(FID,FFILTERENTITY,FFILTERRULE,FFILTERRULEVALUE_TAG,FENTRYID,FSEQ,FFILTERRULEVALUE,FENTITYTYPE) VALUES (1963203548808306688,'pdm_mftbom','使用状态 等于 可用并且 数据状态 等于 已审核并且 组件信息.组件编码.物料编码.编码 为 不为空 ','{"filterRow":[{"id":"454HZ1LU7MFY","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"45A2KBH9UJZG","value":"1"}],"baseDataIds":[],"lock":false},{"id":"454HZ1LXV0NF","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"45A2KBHCG05R","value":"C"}],"baseDataIds":[],"lock":false},{"id":"45A2KBHCG+5+","leftBracket":"","compareType":"9","fieldName":"entrymaterial.masterid.number","rightBracket":"","logic":"0","value":[{"id":"45A2KBHCG05S","value":""}],"baseDataIds":[],"lock":false}],"forList":false}',1963203548833472512,1,' ','A'); 


DELETE FROM t_msplan_checkfilterentry WHERE FENTRYID = 1963203548833472513;
INSERT INTO t_msplan_checkfilterentry(FID,FFILTERENTITY,FFILTERRULE,FFILTERRULEVALUE_TAG,FENTRYID,FSEQ,FFILTERRULEVALUE,FENTITYTYPE) VALUES (1963203548808306688,'bd_materialmftinfo','数据状态 等于 已审核并且 使用状态 等于 可用 ','{"filterRow":[{"id":"454I+AV0MO+7","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"454I+AV0NELH","value":"C"}],"baseDataIds":[],"lock":false},{"id":"454I+AV0MO+8","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"454I+AV0NELI","value":"1"}],"baseDataIds":[],"lock":false}],"forList":false}',1963203548833472513,2,' ','B'); 

DELETE FROM t_msplan_checkmatchentry WHERE FENTRYID = 1963201113796685826;
INSERT INTO t_msplan_checkmatchentry(FID,FTARGETFIELDNUMBER,FENTRYID,FCALCULATEEXC,FCALCULATEEXC_TAG,FENTRYSRCENTITY,FSRCFIELDNUMBER,FSRCFIELDNAME,FTARGETFIELDNAME,FCALCULATETEXT,FSEQ,FCONVERTTYPE,FENTRYTARGETENTITY) VALUES (1963201113771565056,'masterid',1963201113796685826,' ',' ','mpdm_materialplan','masterid','单据头.物料','单据头.物料编码',' ',1,'0','bd_materialmftinfo'); 

DELETE FROM t_msplan_checkmatchentry WHERE FENTRYID = 1963201113796685827;
INSERT INTO t_msplan_checkmatchentry(FID,FTARGETFIELDNUMBER,FENTRYID,FCALCULATEEXC,FCALCULATEEXC_TAG,FENTRYSRCENTITY,FSRCFIELDNUMBER,FSRCFIELDNAME,FTARGETFIELDNAME,FCALCULATETEXT,FSEQ,FCONVERTTYPE,FENTRYTARGETENTITY) VALUES (1963201113771565056,'createorg',1963201113796685827,' ',' ','mpdm_materialplan','createorg','单据头.计划信息创建组织','单据头.生产信息创建组织',' ',2,'0','bd_materialmftinfo'); 

DELETE FROM t_msplan_checkmatchentry WHERE FENTRYID = 1963203548833427458;
INSERT INTO t_msplan_checkmatchentry(FID,FTARGETFIELDNUMBER,FENTRYID,FCALCULATEEXC,FCALCULATEEXC_TAG,FENTRYSRCENTITY,FSRCFIELDNUMBER,FSRCFIELDNAME,FTARGETFIELDNAME,FCALCULATETEXT,FSEQ,FCONVERTTYPE,FENTRYTARGETENTITY) VALUES (1963203548808306688,'entry.entrymaterial',1963203548833427458,' ',' ','bd_materialmftinfo','id','单据头.id','组件信息.组件编码',' ',1,'0','pdm_mftbom'); 

DELETE FROM t_msplan_checklogicentry WHERE FENTRYID = 1963201113796730882;
INSERT INTO t_msplan_checklogicentry(FRIGHTCHAR,FID,FCONDITION,FENTRYRIGHTFIELDNUMBER,FENTRYRIGHTENTITYTYPE,FENTRYID,FENTRYLEFTENTITYTYPE,FENTRYLEFTFIELDNUMBER,FENTRYRIGHTENTITY,FENTRYLEFTFIELDNAME,FLEFTCHAR,FENTRYRIGHTFIELDNAME,FSEQ,FENTRYLEFTENTITY,FORAND) VALUES ('A',1963201113771565056,'G',' ',' ',1963201113796730882,'B','id',' ','单据头.id','A',' ',1,'mpdm_materialplan','A');
 
DELETE FROM t_msplan_checklogicentry WHERE FENTRYID = 1963203548833472514;
INSERT INTO t_msplan_checklogicentry(FRIGHTCHAR,FID,FCONDITION,FENTRYRIGHTFIELDNUMBER,FENTRYRIGHTENTITYTYPE,FENTRYID,FENTRYLEFTENTITYTYPE,FENTRYLEFTFIELDNUMBER,FENTRYRIGHTENTITY,FENTRYLEFTFIELDNAME,FLEFTCHAR,FENTRYRIGHTFIELDNAME,FSEQ,FENTRYLEFTENTITY,FORAND) VALUES ('A',1963203548808306688,'B','materialattr','B',1963203548833472514,'A','entry.entrymaterialattr','bd_materialmftinfo','组件信息.物料属性','A','单据头.物料属性',1,'pdm_mftbom','A'); 

--DELETE FROM t_msplan_checkresource WHERE FID = 1963188679757312000;
IF NOT EXISTS (SELECT 1 FROM t_msplan_checkresource WHERE FID = 1963188679757312000) 
INSERT INTO t_msplan_checkresource(FLASTCHECKER,FAUDITORID,FISDEFAULT,FMASTERID,FERRCOUNTLIMIT,FENABLETIME,FDISABLETIME,FCREATETIME,FLASTCHECKTIME,FRESULTENTITYNUMBER,FENABLE,FLASTCHECKRESULTID,FDISABLEUSERID,FJAVAPLUGINCLASS,FJAVAFILTERRULE,FTXTSQL_TAG,FID,FCHECKTYPE,FOPNUMBER,FSQLEXECDB,FISSYS,FCHECKRANGE,FJAVAFILTERRULEVALUE,FSTATUS,FMAINENTITY,FTXTSQL,FNUMBER,FRESULTFIELDSETTYPE,FMODIFIERID,FSRCENTITY,FCHECKLOGSAVEDAYS,FJAVAFILTERRULEVALUE_TAG,FMODIFYTIME,FLASTCHECKRESULT,FAUDITTIME,FENABLEUSERID,FOPNAME,FCREATORID,FIDSETFIELDTAG,FFIELDAPPID) VALUES (0,1,'0',1963188679757312000,5000,{ts'2018-08-08  08:008:08'},NULL,{ts'2018-08-08  08:008:08'},NULL,'msplan_checkresult','1',0,0,'kd.mpscmm.msplan.mservice.service.resourcecheck.bizplugin.GetLoopErrorByBomExpandPlugin','数据状态 等于 已审核并且 使用状态 等于 可用 ',' ',1963188679757312000,'C','resourcecheckop','SCM','1','A',' ','C','pdm_mftbom',' ','Bom_EndLessLoopCheck_S','B',1,' ',3,'{"filterRow":[{"id":"454F=WTXN+24","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"464+CGXEIUO8","value":"C"}],"baseDataIds":[],"lock":false},{"id":"454F=WU/9D9N","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"464+CGXEI2Q7","value":"1"}],"baseDataIds":[],"lock":false}],"forList":false}',{ts'2018-08-08  08:008:08'},' ',{ts'2018-08-08  08:008:08'},1,'资源检查',1,'id','pdm'); 

--DELETE FROM t_msplan_checkresource WHERE FID = 1963201113771565056;
IF NOT EXISTS (SELECT 1 FROM t_msplan_checkresource WHERE FID = 1963201113771565056) 
INSERT INTO t_msplan_checkresource(FLASTCHECKER,FAUDITORID,FISDEFAULT,FMASTERID,FERRCOUNTLIMIT,FENABLETIME,FDISABLETIME,FCREATETIME,FLASTCHECKTIME,FRESULTENTITYNUMBER,FENABLE,FLASTCHECKRESULTID,FDISABLEUSERID,FJAVAPLUGINCLASS,FJAVAFILTERRULE,FTXTSQL_TAG,FID,FCHECKTYPE,FOPNUMBER,FSQLEXECDB,FISSYS,FCHECKRANGE,FJAVAFILTERRULEVALUE,FSTATUS,FMAINENTITY,FTXTSQL,FNUMBER,FRESULTFIELDSETTYPE,FMODIFIERID,FSRCENTITY,FCHECKLOGSAVEDAYS,FJAVAFILTERRULEVALUE_TAG,FMODIFYTIME,FLASTCHECKRESULT,FAUDITTIME,FENABLEUSERID,FOPNAME,FCREATORID,FIDSETFIELDTAG,FFIELDAPPID) VALUES (0,1,'0',1963201113771565056,5000,{ts'2018-08-08  08:008:08'},NULL,{ts'2018-08-08  08:008:08'},NULL,'msplan_checkresult','1',0,0,' ',' ',' ',1963201113771565056,'A','resourcecheckop','SCM','1','A',' ','C','bd_materialmftinfo',' ','MaterialMftInfo_notExistsMatPlan_S','B',1,'mpdm_materialplan',3,' ',{ts'2018-08-08  08:008:08'},' ',{ts'2018-08-08  08:008:08'},1,'资源检查',1,'id','pdm'); 

--DELETE FROM t_msplan_checkresource WHERE FID = 1963206497445916672;
IF NOT EXISTS (SELECT 1 FROM t_msplan_checkresource WHERE FID = 1963206497445916672) 
INSERT INTO t_msplan_checkresource(FLASTCHECKER,FAUDITORID,FISDEFAULT,FMASTERID,FERRCOUNTLIMIT,FENABLETIME,FDISABLETIME,FCREATETIME,FLASTCHECKTIME,FRESULTENTITYNUMBER,FENABLE,FLASTCHECKRESULTID,FDISABLEUSERID,FJAVAPLUGINCLASS,FJAVAFILTERRULE,FTXTSQL_TAG,FID,FCHECKTYPE,FOPNUMBER,FSQLEXECDB,FISSYS,FCHECKRANGE,FJAVAFILTERRULEVALUE,FSTATUS,FMAINENTITY,FTXTSQL,FNUMBER,FRESULTFIELDSETTYPE,FMODIFIERID,FSRCENTITY,FCHECKLOGSAVEDAYS,FJAVAFILTERRULEVALUE_TAG,FMODIFYTIME,FLASTCHECKRESULT,FAUDITTIME,FENABLEUSERID,FOPNAME,FCREATORID,FIDSETFIELDTAG,FFIELDAPPID) VALUES (0,1,'0',1963206497445916672,5000,{ts'2018-08-08  08:008:08'},NULL,{ts'2018-08-08  08:008:08'},NULL,'msplan_checkresult','1',0,0,' ',' ','select d.fentryid 
from t_pdm_mftbomentry d
inner join t_pdm_mftbom h on h.fid = d.fid
where d.fmaterialattr  = ''10020''
and d.fisjumplevel  = ''0''
and d.ftype = ''A''
and h.fstatus  = ''C''
and h.fenable  = ''1''',1963206497445916672,'B','resourcecheckop','SCM','1','A',' ','C','pdm_mftbom','select fentryid 
from t_pdm_mftbomentry d
where d.fmaterialattr  = ''10020''
and d.fisjumplevel  = ''0''','Bom_JumpLevelCheck_S','B',1,' ',3,' ',{ts'2018-08-08  08:008:08'},' ',{ts'2018-08-08  08:008:08'},1,'资源检查',1,'entry.id','pdm'); 

--DELETE FROM t_msplan_checkresource WHERE FID = 1963203548808306688;
IF NOT EXISTS (SELECT 1 FROM t_msplan_checkresource WHERE FID = 1963203548808306688) 
INSERT INTO t_msplan_checkresource(FLASTCHECKER,FAUDITORID,FISDEFAULT,FMASTERID,FERRCOUNTLIMIT,FENABLETIME,FDISABLETIME,FCREATETIME,FLASTCHECKTIME,FRESULTENTITYNUMBER,FENABLE,FLASTCHECKRESULTID,FDISABLEUSERID,FJAVAPLUGINCLASS,FJAVAFILTERRULE,FTXTSQL_TAG,FID,FCHECKTYPE,FOPNUMBER,FSQLEXECDB,FISSYS,FCHECKRANGE,FJAVAFILTERRULEVALUE,FSTATUS,FMAINENTITY,FTXTSQL,FNUMBER,FRESULTFIELDSETTYPE,FMODIFIERID,FSRCENTITY,FCHECKLOGSAVEDAYS,FJAVAFILTERRULEVALUE_TAG,FMODIFYTIME,FLASTCHECKRESULT,FAUDITTIME,FENABLEUSERID,FOPNAME,FCREATORID,FIDSETFIELDTAG,FFIELDAPPID) VALUES (0,1,'0',1963203548808306688,5000,{ts'2018-08-08  08:008:08'},NULL,{ts'2018-08-08  08:008:08'},NULL,'msplan_checkresult','1',0,0,' ',' ',' ',1963203548808306688,'A','resourcecheckop','SCM','1','A',' ','C','pdm_mftbom',' ','Bom_MaterialAttrCheck_S','B',1,'bd_materialmftinfo',3,' ',{ts'2018-08-08  08:008:08'},' ',{ts'2018-08-08  08:008:08'},1,'资源检查',1,'entry.id','pdm'); 

DELETE FROM t_msplan_checkresource_l WHERE FID = 1963201113771565056 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1963201113771565056,'454HOYDDVG6J','zh_CN','检查存在审核可用的物料生产信息，但不存在审核可用的物料计划信息的数据','检查存在物料生产信息但不存在物料计划信息的数据'); 
DELETE FROM t_msplan_checkresource_l WHERE FID = 1963201113771565056 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1963201113771565056,'454HOYDDVG6K','zh_TW','檢查存在審核可用的物料生產信息，但不存在審核可用的物料計劃信息的數據','檢查存在物料生產信息但不存在物料計劃信息的數據'); 
DELETE FROM t_msplan_checkresource_l WHERE FID = 1963203548808306688 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1963203548808306688,'454I4OE4E2HK','zh_CN','检查已审核可用的BOM的组件分录的物料属性与物料生产信息中的物料属性不一致的数据','检查BOM的组件分录的物料属性字段与物料生产信息中不一致的数据'); 
DELETE FROM t_msplan_checkresource_l WHERE FID = 1963203548808306688 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1963203548808306688,'454I4OE4E2HL','zh_TW','檢查已審核可用的BOM的組件分錄的物料屬性與物料生產信息中的物料屬性不一致的數據','檢查BOM的組件分錄的物料屬性字段與物料生產信息中不一致的數據'); 
DELETE FROM t_msplan_checkresource_l WHERE FID = 1963188679757312000 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1963188679757312000,'454FCN/+BRU0','zh_CN','用于检查BOM数据的展开检查，包括死循环及展开错误信息，展开配置固定为PP01类型。','BOM展开死循环及展开错误检查'); 
DELETE FROM t_msplan_checkresource_l WHERE FID = 1963188679757312000 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1963188679757312000,'454FCN/+BRU1','zh_TW','用於檢查BOM數據的展開檢查，包括死循環及展開錯誤信息，展開配置固定為PP01類型。','BOM展開死循環及展開錯誤檢查'); 
DELETE FROM t_msplan_checkresource_l WHERE FID = 1963206497445916672 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1963206497445916672,'454IP5DCB8SU','zh_CN','检查BOM分录物料属性为虚拟件但未勾选跳层的数据','BOM分录物料属性为虚拟件但未勾选跳层的数据'); 
DELETE FROM t_msplan_checkresource_l WHERE FID = 1963206497445916672 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1963206497445916672,'454IP5DCB8SV','zh_TW','檢查BOM分錄物料屬性為虛擬件但未勾選跳層的數據','BOM分錄物料屬性為虛擬件但未勾選跳層的數據'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967487075955561472;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963203548808306688,1967487075955561472,' ','pdm_mftbom','组件信息.id','0','bizbillentryid','entry.id',' ','业务单据分录ID',' ',1,'长整数','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967487075955561473;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963203548808306688,1967487075955561473,' ','pdm_mftbom','单据头.创建组织','0','bizorg','createorg',' ','业务组织',' ',2,'组织','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967487075955561474;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963203548808306688,1967487075955561474,' ','pdm_mftbom','单据头.id','0','bizbillid','id',' ','业务单据表头ID',' ',3,'长整数','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967487075955561475;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963203548808306688,1967487075955561475,' ','pdm_mftbom','单据头.名称','0','bizotherinfo','name',' ','其他信息',' ',4,'文本型','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967487075955561476;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963203548808306688,1967487075955561476,' ','pdm_mftbom','单据头.BOM编码','0','bizbillno','number',' ','业务单据号',' ',5,'文本型','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967487075955561477;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963203548808306688,1967487075955561477,' ','pdm_mftbom','组件信息.组件编码','0','bizmaterial','entry.entrymaterialid',' ','物料编码',' ',6,'物料','msplan_checkresult'); 


DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1963206497471082496;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963206497445916672,1963206497471082496,' ','pdm_mftbom','组件信息.id','0','bizbillentryid','entry.id',' ','业务单据分录ID',' ',1,'长整数','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1963206497471082497;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963206497445916672,1963206497471082497,' ','pdm_mftbom','单据头.创建组织','0','bizorg','createorg',' ','业务组织',' ',2,'组织','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1963206497471082498;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963206497445916672,1963206497471082498,' ','pdm_mftbom','单据头.id','0','bizbillid','id',' ','业务单据表头ID',' ',3,'长整数','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1963206497471082499;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963206497445916672,1963206497471082499,' ','pdm_mftbom','单据头.名称','0','bizotherinfo','name',' ','其他信息',' ',4,'文本型','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1963206497471082500;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963206497445916672,1963206497471082500,' ','pdm_mftbom','单据头.BOM编码','0','bizbillno','number',' ','业务单据号',' ',5,'文本型','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1963206497471082501;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963206497445916672,1963206497471082501,' ','pdm_mftbom','组件信息.组件编码','0','bizmaterial','entry.entrymaterialid',' ','物料编码',' ',6,'物料','msplan_checkresult');
 
DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967486758287365120;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963188679757312000,1967486758287365120,' ','pdm_mftbom',' ','0','bizbillentryid',' ',' ','业务单据分录ID',' ',1,'长整数','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967486758287365121;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963188679757312000,1967486758287365121,' ','pdm_mftbom','单据头.创建组织','0','bizorg','createorg',' ','业务组织',' ',2,'组织','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967486758287365122;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963188679757312000,1967486758287365122,' ','pdm_mftbom','单据头.id','0','bizbillid','id',' ','业务单据表头ID',' ',3,'长整数','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967486758287365123;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963188679757312000,1967486758287365123,' ','pdm_mftbom','单据头.名称','0','bizotherinfo','name',' ','其他信息',' ',4,'文本型','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967486758287365124;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963188679757312000,1967486758287365124,' ','pdm_mftbom','单据头.BOM编码','0','bizbillno','number',' ','业务单据号',' ',5,'文本型','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967486758287365125;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963188679757312000,1967486758287365125,' ','pdm_mftbom','单据头.产品编码','0','bizmaterial','materialid',' ','物料编码',' ',6,'物料','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967487229584528384;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963201113771565056,1967487229584528384,' ','bd_materialmftinfo',' ','0','bizbillentryid',' ',' ','业务单据分录ID',' ',1,'长整数','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967487229584528385;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963201113771565056,1967487229584528385,' ','bd_materialmftinfo','单据头.生产信息创建组织','0','bizorg','createorg',' ','业务组织',' ',2,'组织','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967487229584528386;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963201113771565056,1967487229584528386,' ','bd_materialmftinfo','单据头.id','0','bizbillid','id',' ','业务单据表头ID',' ',3,'长整数','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967487229584528387;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963201113771565056,1967487229584528387,' ','bd_materialmftinfo','单据头.名称','0','bizotherinfo','name',' ','其他信息',' ',4,'文本型','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967487229584528388;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963201113771565056,1967487229584528388,' ','bd_materialmftinfo','单据头.编码','0','bizbillno','number',' ','业务单据号',' ',5,'文本型','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1967487229584528389;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1963201113771565056,1967487229584528389,' ','bd_materialmftinfo','单据头.物料编码','0','bizmaterial','masterid',' ','物料编码',' ',6,'物料','msplan_checkresult'); 



UPDATE T_MSPLAN_CHECKLOGICENTRY SET FENTRYFILTERTYPE = 'A' WHERE FENTRYFILTERTYPE IS NULL OR FENTRYFILTERTYPE = ' ' OR FENTRYFILTERTYPE = '' ;
UPDATE T_MSPLAN_CHECKRESOURCE SET FONETYPE = '0' WHERE FONETYPE IS NULL OR FONETYPE = ' ' OR FONETYPE = '' ;





DELETE FROM t_msplan_checkfilterentry WHERE FENTRYID = 1971225412512046080;
INSERT INTO t_msplan_checkfilterentry(FID,FFILTERENTITY,FFILTERRULE,FFILTERRULEVALUE_TAG,FENTRYID,FSEQ,FFILTERRULEVALUE,FENTITYTYPE) VALUES (1971225412444937216,'bd_materialmftinfo','数据状态 等于 已审核并且 使用状态 等于 可用并且 物料属性 在……中 自制件;外协件;虚拟件 ','{"filterRow":[{"id":"463YWA90PT9X","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"463YWA90QJ7Y","value":"C"}],"baseDataIds":[],"lock":false},{"id":"463YWA94B7GE","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"463YWA94BZEF","value":"1"}],"baseDataIds":[],"lock":false},{"id":"463YWA94B7GF","leftBracket":"","compareType":"17","fieldName":"materialattr","rightBracket":"","logic":"0","value":[{"id":"463YWA94BZEG","value":"10030"},{"id":"463YWA94B7GG","value":"10050"},{"id":"463YWA94BZEH","value":"10020"}],"baseDataIds":[],"lock":false}],"forList":false}',1971225412512046080,1,' ','A'); 

DELETE FROM t_msplan_checkfilterentry WHERE FENTRYID = 1971225412512046081;
INSERT INTO t_msplan_checkfilterentry(FID,FFILTERENTITY,FFILTERRULE,FFILTERRULEVALUE_TAG,FENTRYID,FSEQ,FFILTERRULEVALUE,FENTITYTYPE) VALUES (1971225412444937216,'pdm_mftbom','数据状态 等于 已审核并且 使用状态 等于 可用 ','{"filterRow":[{"id":"463YXL5V5KWV","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"463YXL5V6AUW","value":"C"}],"baseDataIds":[],"lock":false},{"id":"463YXL5V5KWW","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"463YXL5V6AUX","value":"1"}],"baseDataIds":[],"lock":false}],"forList":false}',1971225412512046081,2,' ','B'); 

DELETE FROM t_msplan_checkfilterentry WHERE FENTRYID = 1971226888865111040;
INSERT INTO t_msplan_checkfilterentry(FID,FFILTERENTITY,FFILTERRULE,FFILTERRULEVALUE_TAG,FENTRYID,FSEQ,FFILTERRULEVALUE,FENTITYTYPE) VALUES (1971226888831556608,'bd_materialmftinfo','数据状态 等于 已审核并且 使用状态 等于 可用并且 物料属性 等于 自制件 ','{"filterRow":[{"id":"463YWA90PT9X","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"463Z52H10BUB","value":"C"}],"baseDataIds":[],"lock":false},{"id":"463YWA94B7GE","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"463Z52H1/LWA","value":"1"}],"baseDataIds":[],"lock":false},{"id":"463YWA94B7GF","leftBracket":"","compareType":"105","fieldName":"materialattr","rightBracket":"","logic":"0","value":[{"id":"463Z52H4NS/V","value":"10030"}],"baseDataIds":[],"lock":false}],"forList":false}',1971226888865111040,1,' ','A'); 

DELETE FROM t_msplan_checkfilterentry WHERE FENTRYID = 1971226888865111041;
INSERT INTO t_msplan_checkfilterentry(FID,FFILTERENTITY,FFILTERRULE,FFILTERRULEVALUE_TAG,FENTRYID,FSEQ,FFILTERRULEVALUE,FENTITYTYPE) VALUES (1971226888831556608,'pdm_route','数据状态 等于 已审核并且 使用状态 等于 可用 ','{"filterRow":[{"id":"463Z618L2GVC","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"463Z618L37TD","value":"C"}],"baseDataIds":[],"lock":false},{"id":"463Z618L2GVD","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"463Z618L37TE","value":"1"}],"baseDataIds":[],"lock":false}],"forList":false}',1971226888865111041,2,' ','B'); 

DELETE FROM t_msplan_checkmatchentry WHERE FENTRYID = 1971225412512002050;
INSERT INTO t_msplan_checkmatchentry(FID,FTARGETFIELDNUMBER,FENTRYID,FCALCULATEEXC,FCALCULATEEXC_TAG,FENTRYSRCENTITY,FSRCFIELDNUMBER,FSRCFIELDNAME,FTARGETFIELDNAME,FCALCULATETEXT,FSEQ,FCONVERTTYPE,FENTRYTARGETENTITY) VALUES (1971225412444937216,'id',1971225412512002050,' ',' ','pdm_mftbom','material','单据头.产品编码','单据头.id',' ',1,'0','bd_materialmftinfo'); 

DELETE FROM t_msplan_checkmatchentry WHERE FENTRYID = 1971226888865067010;
INSERT INTO t_msplan_checkmatchentry(FID,FTARGETFIELDNUMBER,FENTRYID,FCALCULATEEXC,FCALCULATEEXC_TAG,FENTRYSRCENTITY,FSRCFIELDNUMBER,FSRCFIELDNAME,FTARGETFIELDNAME,FCALCULATETEXT,FSEQ,FCONVERTTYPE,FENTRYTARGETENTITY) VALUES (1971226888831556608,'masterid',1971226888865067010,' ',' ','pdm_route','material','单据头.物料编码','单据头.物料编码',' ',1,'0','bd_materialmftinfo'); 

DELETE FROM t_msplan_checkmatchentry WHERE FENTRYID = 1971226888865067011;
INSERT INTO t_msplan_checkmatchentry(FID,FTARGETFIELDNUMBER,FENTRYID,FCALCULATEEXC,FCALCULATEEXC_TAG,FENTRYSRCENTITY,FSRCFIELDNUMBER,FSRCFIELDNAME,FTARGETFIELDNAME,FCALCULATETEXT,FSEQ,FCONVERTTYPE,FENTRYTARGETENTITY) VALUES (1971226888831556608,'createorg',1971226888865067011,' ',' ','pdm_route','createorg','单据头.创建组织','单据头.生产信息创建组织',' ',2,'0','bd_materialmftinfo'); 

DELETE FROM t_msplan_checklogicentry WHERE FENTRYID = 1971225412512046082;
INSERT INTO t_msplan_checklogicentry(FRIGHTCHAR,FID,FCONDITION,FENTRYRIGHTFIELDNUMBER,FENTRYRIGHTENTITYTYPE,FENTRYFILTERRULE,FENTRYID,FENTRYLEFTENTITYTYPE,FENTRYLEFTFIELDNUMBER,FENTRYRIGHTENTITY,FENTRYFILTERVALUE,FENTRYFILTERVALUE_TAG,FENTRYLEFTFIELDNAME,FLEFTCHAR,FENTRYRIGHTFIELDNAME,FSEQ,FENTRYLEFTENTITY,FENTRYFILTERTYPE,FORAND) VALUES ('A',1971225412444937216,'G',' ',' ',' ',1971225412512046082,'B','id',' ',' ',' ','单据头.id','A',' ',1,'pdm_mftbom','A','A'); 

DELETE FROM t_msplan_checklogicentry WHERE FENTRYID = 1971226888865111042;
INSERT INTO t_msplan_checklogicentry(FRIGHTCHAR,FID,FCONDITION,FENTRYRIGHTFIELDNUMBER,FENTRYRIGHTENTITYTYPE,FENTRYFILTERRULE,FENTRYID,FENTRYLEFTENTITYTYPE,FENTRYLEFTFIELDNUMBER,FENTRYRIGHTENTITY,FENTRYFILTERVALUE,FENTRYFILTERVALUE_TAG,FENTRYLEFTFIELDNAME,FLEFTCHAR,FENTRYRIGHTFIELDNAME,FSEQ,FENTRYLEFTENTITY,FENTRYFILTERTYPE,FORAND) VALUES ('A',1971226888831556608,'G',' ',' ',' ',1971226888865111042,'B','id',' ',' ',' ','单据头.id','A',' ',1,'pdm_route','A','A'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971225412512002051;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971225412444937216,1971225412512002051,' ','bd_materialmftinfo',' ','0','bizbillentryid',' ',' ','业务单据分录ID',' ',1,'长整数','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971225412512002052;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971225412444937216,1971225412512002052,' ','bd_materialmftinfo','单据头.生产信息创建组织','0','bizorg','createorg',' ','业务组织',' ',2,'组织','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971225412512002053;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971225412444937216,1971225412512002053,' ','bd_materialmftinfo','单据头.id','0','bizbillid','id',' ','业务单据表头ID',' ',3,'长整数','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971225412512002054;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971225412444937216,1971225412512002054,' ','bd_materialmftinfo','单据头.名称','0','bizotherinfo','name',' ','其他信息',' ',4,'文本型','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971225412512002055;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971225412444937216,1971225412512002055,' ','bd_materialmftinfo','单据头.编码','0','bizbillno','number',' ','业务单据编码',' ',5,'文本型','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971225412512002056;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971225412444937216,1971225412512002056,' ','bd_materialmftinfo','单据头.物料编码','0','bizmaterial','masterid',' ','物料编码',' ',6,'物料','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971226888865067012;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971226888831556608,1971226888865067012,' ','bd_materialmftinfo',' ','0','bizbillentryid',' ',' ','业务单据分录ID',' ',1,'长整数','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971226888865067013;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971226888831556608,1971226888865067013,' ','bd_materialmftinfo','单据头.生产信息创建组织','0','bizorg','createorg',' ','业务组织',' ',2,'组织','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971226888865067014;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971226888831556608,1971226888865067014,' ','bd_materialmftinfo','单据头.id','0','bizbillid','id',' ','业务单据表头ID',' ',3,'长整数','msplan_checkresult'); 

DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971226888865067015;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971226888831556608,1971226888865067015,' ','bd_materialmftinfo','单据头.名称','0','bizotherinfo','name',' ','其他信息',' ',4,'文本型','msplan_checkresult');
 
DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971226888865067016;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971226888831556608,1971226888865067016,' ','bd_materialmftinfo','单据头.编码','0','bizbillno','number',' ','业务单据编码',' ',5,'文本型','msplan_checkresult');
 
DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971226888865067017;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971226888831556608,1971226888865067017,' ','bd_materialmftinfo','单据头.物料编码','0','bizmaterial','masterid',' ','物料编码',' ',6,'物料','msplan_checkresult'); 

--DELETE FROM t_msplan_checkresource WHERE FID = 1971226888831556608;
IF NOT EXISTS (SELECT 1 FROM t_msplan_checkresource WHERE FID = 1971226888831556608) 
INSERT INTO t_msplan_checkresource(FLASTCHECKER,FAUDITORID,FISDEFAULT,FMASTERID,FERRCOUNTLIMIT,FENABLETIME,FDISABLETIME,FCREATETIME,FLASTCHECKTIME,FRESULTENTITYNUMBER,FENABLE,FLASTCHECKRESULTID,FONETYPE,FDISABLEUSERID,FJAVAPLUGINCLASS,FJAVAFILTERRULE,FTXTSQL_TAG,FID,FCHECKTYPE,FOPNUMBER,FSQLEXECDB,FISSYS,FBIZRESULTFIELDNAME,FCHECKRANGE,FJAVAFILTERRULEVALUE,FSTATUS,FMAINENTITY,FTXTSQL,FNUMBER,FBIZRESULTFIELDNUMBER,FRESULTFIELDSETTYPE,FMODIFIERID,FSRCENTITY,FCHECKLOGSAVEDAYS,FJAVAFILTERRULEVALUE_TAG,FMODIFYTIME,FLASTCHECKRESULT,FAUDITTIME,FENABLEUSERID,FOPNAME,FCREATORID,FIDSETFIELDTAG,FFIELDAPPID) VALUES (0,1,'0',1971226888831556608,5000,{ts'2018-08-08  08:008:08'},NULL,{ts'2018-08-08  08:008:08'},NULL,'msplan_checkresult','1',0,'0',0,' ',' ',' ',1971226888831556608,'A','resourcecheckop','SCM','1',' ','A',' ','C','bd_materialmftinfo',' ','MaterialMftInfo_notExistsRoute_S',' ','B',1,'pdm_route',3,' ',{ts'2018-08-08  08:008:08'},' ',{ts'2018-08-08  08:008:08'},1,'资源检查',1,'id','pdm'); 

--DELETE FROM t_msplan_checkresource WHERE FID = 1971225412444937216;
IF NOT EXISTS (SELECT 1 FROM t_msplan_checkresource WHERE FID = 1971225412444937216) 
INSERT INTO t_msplan_checkresource(FLASTCHECKER,FAUDITORID,FISDEFAULT,FMASTERID,FERRCOUNTLIMIT,FENABLETIME,FDISABLETIME,FCREATETIME,FLASTCHECKTIME,FRESULTENTITYNUMBER,FENABLE,FLASTCHECKRESULTID,FONETYPE,FDISABLEUSERID,FJAVAPLUGINCLASS,FJAVAFILTERRULE,FTXTSQL_TAG,FID,FCHECKTYPE,FOPNUMBER,FSQLEXECDB,FISSYS,FBIZRESULTFIELDNAME,FCHECKRANGE,FJAVAFILTERRULEVALUE,FSTATUS,FMAINENTITY,FTXTSQL,FNUMBER,FBIZRESULTFIELDNUMBER,FRESULTFIELDSETTYPE,FMODIFIERID,FSRCENTITY,FCHECKLOGSAVEDAYS,FJAVAFILTERRULEVALUE_TAG,FMODIFYTIME,FLASTCHECKRESULT,FAUDITTIME,FENABLEUSERID,FOPNAME,FCREATORID,FIDSETFIELDTAG,FFIELDAPPID) VALUES (0,1,'0',1971225412444937216,5000,{ts'2018-08-08  08:008:08'},NULL,{ts'2018-08-08  08:008:08'},NULL,'msplan_checkresult','1',0,'0',0,' ',' ',' ',1971225412444937216,'A','resourcecheckop','SCM','1',' ','A',' ','C','bd_materialmftinfo',' ','MaterialMftInfo_notExistsBom_S',' ','B',1,'pdm_mftbom',3,' ',{ts'2018-08-08  08:008:08'},' ',{ts'2018-08-08  08:008:08'},1,'资源检查',1,'id','pdm'); 

DELETE FROM t_msplan_checkresource_l WHERE FID = 1971225412444937216 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1971225412444937216,'463Z+VK9+U+Z','zh_CN','检查物料生产信息中物料属性不等于外购，且不存在审核可用的BOM维护信息的数据。','物料生产信息非外购件不存在BOM维护信息检查'); 
DELETE FROM t_msplan_checkresource_l WHERE FID = 1971225412444937216 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1971225412444937216,'463Z+VK9+U/+','zh_TW','檢查物料生產信息中物料屬性不等於外購，且不存在審核可用的BOM維護信息的數據。','物料生產信息非外購件不存在BOM維護信息檢查'); 
DELETE FROM t_msplan_checkresource_l WHERE FID = 1971226888831556608 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1971226888831556608,'463Z9M4E970T','zh_TW','檢查物料生產信息中物料屬性為外購件，但不存在審核可用的工藝路線信息的數據。','物料生產信息自製件不存在工藝路線信息檢查'); 
DELETE FROM t_msplan_checkresource_l WHERE FID = 1971226888831556608 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1971226888831556608,'463Z9M4E970U','zh_CN','检查物料生产信息中物料属性为外购件，但不存在审核可用的工艺路线信息的数据。','物料生产信息自制件不存在工艺路线信息检查'); 






DELETE FROM t_msplan_checkfilterentry WHERE FENTRYID = 1971239086253464576;
INSERT INTO t_msplan_checkfilterentry(FID,FFILTERENTITY,FFILTERRULE,FFILTERRULEVALUE_TAG,FENTRYID,FSEQ,FFILTERRULEVALUE,FENTITYTYPE) VALUES (1971239086228298752,'bd_materialmftinfo','数据状态 等于 已审核并且 使用状态 等于 可用 ','{"filterRow":[{"id":"454HKV4O/D24","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"454HKV4O04PE","value":"C"}],"baseDataIds":[],"lock":false},{"id":"454HKV4O/D25","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"454HKV4O04PF","value":"1"}],"baseDataIds":[],"lock":false}],"forList":false}',1971239086253464576,1,' ','A'); 
DELETE FROM t_msplan_checkfilterentry WHERE FENTRYID = 1971239086253464577;
INSERT INTO t_msplan_checkfilterentry(FID,FFILTERENTITY,FFILTERRULE,FFILTERRULEVALUE_TAG,FENTRYID,FSEQ,FFILTERRULEVALUE,FENTITYTYPE) VALUES (1971239086228298752,'mpdm_materialplan','数据状态 等于 已审核并且 使用状态 等于 可用 ','{"filterRow":[{"id":"454HLOO0AH00","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"454HLOO0B8NA","value":"C"}],"baseDataIds":[],"lock":false},{"id":"454HLOO0AH01","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"454HLOO0B8NB","value":"1"}],"baseDataIds":[],"lock":false}],"forList":false}',1971239086253464577,2,' ','B'); 
DELETE FROM t_msplan_checkfilterentry WHERE FENTRYID = 1971241574658486272;
INSERT INTO t_msplan_checkfilterentry(FID,FFILTERENTITY,FFILTERRULE,FFILTERRULEVALUE_TAG,FENTRYID,FSEQ,FFILTERRULEVALUE,FENTITYTYPE) VALUES (1971241574624931840,'pdm_mftbom','使用状态 等于 可用并且 数据状态 等于 已审核并且 组件信息.组件编码.物料编码.编码 为 不为空 ','{"filterRow":[{"id":"454HZ1LU7MFY","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"45A2KBH9UJZG","value":"1"}],"baseDataIds":[],"lock":false},{"id":"454HZ1LXV0NF","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"45A2KBHCG05R","value":"C"}],"baseDataIds":[],"lock":false},{"id":"45A2KBHCG+5+","leftBracket":"","compareType":"9","fieldName":"entrymaterial.masterid.number","rightBracket":"","logic":"0","value":[{"id":"45A2KBHCG05S","value":""}],"baseDataIds":[],"lock":false}],"forList":false}',1971241574658486272,1,' ','A'); 
DELETE FROM t_msplan_checkfilterentry WHERE FENTRYID = 1971241574658486273;
INSERT INTO t_msplan_checkfilterentry(FID,FFILTERENTITY,FFILTERRULE,FFILTERRULEVALUE_TAG,FENTRYID,FSEQ,FFILTERRULEVALUE,FENTITYTYPE) VALUES (1971241574624931840,'bd_material','数据状态 等于 已审核并且 使用状态 等于 可用 ','{"filterRow":[{"id":"464/WLPFI=KT","leftBracket":"","compareType":"105","fieldName":"status","rightBracket":"","logic":"0","value":[{"id":"464/WLPJ3ZU=","value":"C"}],"baseDataIds":[],"lock":false},{"id":"464/WLPJ4PSA","leftBracket":"","compareType":"105","fieldName":"enable","rightBracket":"","logic":"0","value":[{"id":"464/WLPJ3ZUA","value":"1"}],"baseDataIds":[],"lock":false}],"forList":false}',1971241574658486273,2,' ','B'); 
DELETE FROM t_msplan_checkmatchentry WHERE FENTRYID = 1971239086253420546;
INSERT INTO t_msplan_checkmatchentry(FID,FTARGETFIELDNUMBER,FENTRYID,FCALCULATEEXC,FCALCULATEEXC_TAG,FENTRYSRCENTITY,FSRCFIELDNUMBER,FSRCFIELDNAME,FTARGETFIELDNAME,FCALCULATETEXT,FSEQ,FCONVERTTYPE,FENTRYTARGETENTITY) VALUES (1971239086228298752,'masterid',1971239086253420546,' ',' ','mpdm_materialplan','masterid','单据头.物料','单据头.物料编码',' ',1,'0','bd_materialmftinfo'); 
DELETE FROM t_msplan_checkmatchentry WHERE FENTRYID = 1971239086253420547;
INSERT INTO t_msplan_checkmatchentry(FID,FTARGETFIELDNUMBER,FENTRYID,FCALCULATEEXC,FCALCULATEEXC_TAG,FENTRYSRCENTITY,FSRCFIELDNUMBER,FSRCFIELDNAME,FTARGETFIELDNAME,FCALCULATETEXT,FSEQ,FCONVERTTYPE,FENTRYTARGETENTITY) VALUES (1971239086228298752,'createorg',1971239086253420547,' ',' ','mpdm_materialplan','createorg','单据头.计划信息创建组织','单据头.生产信息创建组织',' ',2,'0','bd_materialmftinfo'); 
DELETE FROM t_msplan_checkmatchentry WHERE FENTRYID = 1971241574658530306;
INSERT INTO t_msplan_checkmatchentry(FID,FTARGETFIELDNUMBER,FENTRYID,FCALCULATEEXC,FCALCULATEEXC_TAG,FENTRYSRCENTITY,FSRCFIELDNUMBER,FSRCFIELDNAME,FTARGETFIELDNAME,FCALCULATETEXT,FSEQ,FCONVERTTYPE,FENTRYTARGETENTITY) VALUES (1971241574624931840,'entry.entrymaterialid',1971241574658530306,' ',' ','bd_material','id','单据头.id','组件信息.组件编码',' ',1,'0','pdm_mftbom'); 
DELETE FROM t_msplan_checklogicentry WHERE FENTRYID = 1971239086253464578;
INSERT INTO t_msplan_checklogicentry(FRIGHTCHAR,FID,FCONDITION,FENTRYRIGHTFIELDNUMBER,FENTRYRIGHTENTITYTYPE,FENTRYFILTERRULE,FENTRYID,FENTRYLEFTENTITYTYPE,FENTRYLEFTFIELDNUMBER,FENTRYRIGHTENTITY,FENTRYFILTERVALUE,FENTRYFILTERVALUE_TAG,FENTRYLEFTFIELDNAME,FLEFTCHAR,FENTRYRIGHTFIELDNAME,FSEQ,FENTRYLEFTENTITY,FENTRYFILTERTYPE,FORAND) VALUES ('A',1971239086228298752,'B','materialattr','A',' ',1971239086253464578,'B','materialattr','bd_materialmftinfo',' ',' ','单据头.物料属性','A','单据头.物料属性',1,'mpdm_materialplan','A','A'); 
DELETE FROM t_msplan_checklogicentry WHERE FENTRYID = 1971241574658486274;
INSERT INTO t_msplan_checklogicentry(FRIGHTCHAR,FID,FCONDITION,FENTRYRIGHTFIELDNUMBER,FENTRYRIGHTENTITYTYPE,FENTRYFILTERRULE,FENTRYID,FENTRYLEFTENTITYTYPE,FENTRYLEFTFIELDNUMBER,FENTRYRIGHTENTITY,FENTRYFILTERVALUE,FENTRYFILTERVALUE_TAG,FENTRYLEFTFIELDNAME,FLEFTCHAR,FENTRYRIGHTFIELDNAME,FSEQ,FENTRYLEFTENTITY,FENTRYFILTERTYPE,FORAND) VALUES ('A',1971241574624931840,'B','configproperties','B',' ',1971241574658486274,'A','entry.configproperties','bd_material',' ',' ','组件信息.配置属性','A','单据头.配置属性',1,'pdm_mftbom','A','A'); 
DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971239086253420548;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971239086228298752,1971239086253420548,' ','bd_materialmftinfo',' ','0','bizbillentryid',' ',' ','业务单据分录ID',' ',1,'长整数','msplan_checkresult'); 
DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971239086253420549;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971239086228298752,1971239086253420549,' ','bd_materialmftinfo','单据头.生产信息创建组织','0','bizorg','createorg',' ','业务组织',' ',2,'组织','msplan_checkresult'); 
DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971239086253420550;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971239086228298752,1971239086253420550,' ','bd_materialmftinfo','单据头.id','0','bizbillid','id',' ','业务单据表头ID',' ',3,'长整数','msplan_checkresult'); 
DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971239086253420551;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971239086228298752,1971239086253420551,' ','bd_materialmftinfo','单据头.名称','0','bizotherinfo','name',' ','其他信息',' ',4,'文本型','msplan_checkresult'); 
DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971239086253420552;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971239086228298752,1971239086253420552,' ','bd_materialmftinfo','单据头.编码','0','bizbillno','number',' ','业务单据号',' ',5,'文本型','msplan_checkresult'); 
DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971239086253420553;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971239086228298752,1971239086253420553,' ','bd_materialmftinfo','单据头.物料编码','0','bizmaterial','masterid',' ','物料编码',' ',6,'物料','msplan_checkresult'); 
DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971241574658530307;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971241574624931840,1971241574658530307,' ','pdm_mftbom','组件信息.id','0','bizbillentryid','entry.id',' ','业务单据分录ID',' ',1,'长整数','msplan_checkresult'); 
DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971241574658530308;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971241574624931840,1971241574658530308,' ','pdm_mftbom','单据头.创建组织','0','bizorg','createorg',' ','业务组织',' ',2,'组织','msplan_checkresult'); 
DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971241574658530309;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971241574624931840,1971241574658530309,' ','pdm_mftbom','单据头.id','0','bizbillid','id',' ','业务单据表头ID',' ',3,'长整数','msplan_checkresult'); 
DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971241574658530310;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971241574624931840,1971241574658530310,' ','pdm_mftbom','单据头.名称','0','bizotherinfo','name',' ','其他信息',' ',4,'文本型','msplan_checkresult'); 
DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971241574658530311;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971241574624931840,1971241574658530311,' ','pdm_mftbom','单据头.BOM编码','0','bizbillno','number',' ','业务单据号',' ',5,'文本型','msplan_checkresult'); 
DELETE FROM t_msplan_resultfieldentry WHERE FENTRYID = 1971241574658530312;
INSERT INTO t_msplan_resultfieldentry(FID,FENTRYID,FRESULTCALCULATEEXC,FRESULTSRCENTITYFLAG,FRESULTSRCFIELDNAME,FRESULTCONVERTTYPE,FRESULTFIELDFLAG,FRESULTSRCFIELDFLAG,FRESULTCALCULATEEXC_TAG,FRESULTFIELDNAME,FRESULTCALCULATETEXT,FSEQ,FRESULTDATATYPE,FRESULTENTITYFLAG) VALUES (1971241574624931840,1971241574658530312,' ','pdm_mftbom','组件信息.组件编码','0','bizmaterial','entry.entrymaterialid',' ','物料编码',' ',6,'物料','msplan_checkresult'); 
--DELETE FROM t_msplan_checkresource WHERE FID = 1971241574624931840;
IF NOT EXISTS (SELECT 1 FROM t_msplan_checkresource WHERE FID = 1971241574624931840) 
INSERT INTO t_msplan_checkresource(FLASTCHECKER,FAUDITORID,FISDEFAULT,FMASTERID,FERRCOUNTLIMIT,FENABLETIME,FDISABLETIME,FCREATETIME,FLASTCHECKTIME,FRESULTENTITYNUMBER,FENABLE,FLASTCHECKRESULTID,FONETYPE,FDISABLEUSERID,FJAVAPLUGINCLASS,FJAVAFILTERRULE,FTXTSQL_TAG,FID,FCHECKTYPE,FOPNUMBER,FSQLEXECDB,FISSYS,FBIZRESULTFIELDNAME,FCHECKRANGE,FJAVAFILTERRULEVALUE,FSTATUS,FMAINENTITY,FTXTSQL,FNUMBER,FBIZRESULTFIELDNUMBER,FRESULTFIELDSETTYPE,FMODIFIERID,FSRCENTITY,FCHECKLOGSAVEDAYS,FJAVAFILTERRULEVALUE_TAG,FMODIFYTIME,FLASTCHECKRESULT,FAUDITTIME,FENABLEUSERID,FOPNAME,FCREATORID,FIDSETFIELDTAG,FFIELDAPPID) VALUES (0,1,'0',1971241574624931840,5000,{ts'2018-08-08  08:008:08'},NULL,{ts'2018-08-08  08:008:08'},NULL,'msplan_checkresult','1',0,'0',0,' ',' ',' ',1971241574624931840,'A','resourcecheckop','SCM','1',' ','A',' ','C','pdm_mftbom',' ','Bom_MaterialConfigPropCheck_S',' ','B',1,'bd_material',3,' ',{ts'2018-08-08  08:008:08'},' ',{ts'2018-08-08  08:008:08'},1,'资源检查',1,'entry.id','pdm'); 
--DELETE FROM t_msplan_checkresource WHERE FID = 1971239086228298752;
IF NOT EXISTS (SELECT 1 FROM t_msplan_checkresource WHERE FID = 1971239086228298752) 
INSERT INTO t_msplan_checkresource(FLASTCHECKER,FAUDITORID,FISDEFAULT,FMASTERID,FERRCOUNTLIMIT,FENABLETIME,FDISABLETIME,FCREATETIME,FLASTCHECKTIME,FRESULTENTITYNUMBER,FENABLE,FLASTCHECKRESULTID,FONETYPE,FDISABLEUSERID,FJAVAPLUGINCLASS,FJAVAFILTERRULE,FTXTSQL_TAG,FID,FCHECKTYPE,FOPNUMBER,FSQLEXECDB,FISSYS,FBIZRESULTFIELDNAME,FCHECKRANGE,FJAVAFILTERRULEVALUE,FSTATUS,FMAINENTITY,FTXTSQL,FNUMBER,FBIZRESULTFIELDNUMBER,FRESULTFIELDSETTYPE,FMODIFIERID,FSRCENTITY,FCHECKLOGSAVEDAYS,FJAVAFILTERRULEVALUE_TAG,FMODIFYTIME,FLASTCHECKRESULT,FAUDITTIME,FENABLEUSERID,FOPNAME,FCREATORID,FIDSETFIELDTAG,FFIELDAPPID) VALUES (0,1,'0',1971239086228298752,5000,{ts'2018-08-08  08:008:08'},NULL,{ts'2018-08-08  08:008:08'},NULL,'msplan_checkresult','1',0,'0',0,' ',' ',' ',1971239086228298752,'A','resourcecheckop','SCM','1',' ','A',' ','C','bd_materialmftinfo',' ','MaterialMftInfo_MatPlanAttr_S',' ','B',1,'mpdm_materialplan',3,' ',{ts'2018-08-08  08:008:08'},' ',{ts'2018-08-08  08:008:08'},1,'资源检查',1,'id','pdm'); 
DELETE FROM t_msplan_checkresource_l WHERE FID = 1971239086228298752 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1971239086228298752,'464/JHJ64BHC','zh_TW','檢查物料生產信息中的物料屬性與物料計劃信息中的物料屬性不一致的數據。','檢查物料生產信息與物料計劃信息的物料屬性字段不一致的數據'); 
DELETE FROM t_msplan_checkresource_l WHERE FID = 1971239086228298752 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1971239086228298752,'464/JHJ64BHD','zh_CN','检查物料生产信息中的物料属性与物料计划信息中的物料属性不一致的数据。','检查物料生产信息与物料计划信息的物料属性字段不一致的数据'); 
DELETE FROM t_msplan_checkresource_l WHERE FID = 1971241574624931840 and FLOCALEID = 'zh_TW';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1971241574624931840,'4640/MQEI6A+','zh_TW','檢查已審核可用的BOM的組件分錄的配置屬性與物料主數據中的配置屬性不一致的數據','檢查BOM的組件分錄的配置屬性字段與物料主數據中不一致的數據'); 
DELETE FROM t_msplan_checkresource_l WHERE FID = 1971241574624931840 and FLOCALEID = 'zh_CN';
INSERT INTO t_msplan_checkresource_l(FID,FPKID,FLOCALEID,FREMARK,FNAME) VALUES (1971241574624931840,'4640/MQEI6A/','zh_CN','检查已审核可用的BOM的组件分录的配置属性与物料主数据中的配置属性不一致的数据','检查BOM的组件分录的配置属性字段与物料主数据中不一致的数据'); 




