/* 2022-7-18 单据关系属性图-单据摘要-主表  */

DELETE FROM t_wf_mbillsummarycfg WHERE FID = 1465360222129267712;
IF NOT EXISTS (select fid from t_wf_mbillsummarycfg where fbilltype = 'src_apply')
INSERT INTO t_wf_mbillsummarycfg(FID,FTPLNAME,FSCENE,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSUMMARYTPL,FENABLE,FMODIFIERID,FBILLTYPE,FDEFAULTDATAROWS,FMODIFYTIME,FCREATORID,FDEFAULTROWS) VALUES (1465360222129267712,'单据关系图卡片模板','billRelationCardSummary',1465360222129267712,'A','src_apply_BBC_S',' ',{ts'2022-07-15  00:00:00'},'bpm_billrelation_cardtpl','1',1292577788431177728,'src_apply',3,{ts'2022-07-18  00:00:00'},13466739,6); 
DELETE FROM t_wf_mbillsummarycfg WHERE FID = 1465368259850183680;
IF NOT EXISTS (select fid from t_wf_mbillsummarycfg where fbilltype = 'src_contract')
INSERT INTO t_wf_mbillsummarycfg(FID,FTPLNAME,FSCENE,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSUMMARYTPL,FENABLE,FMODIFIERID,FBILLTYPE,FDEFAULTDATAROWS,FMODIFYTIME,FCREATORID,FDEFAULTROWS) VALUES (1465368259850183680,'单据关系图卡片模板','billRelationCardSummary',1465368259850183680,'A','src_contract_BBC_S',' ',{ts'2022-07-15  00:00:00'},'bpm_billrelation_cardtpl','1',1292577788431177728,'src_contract',3,{ts'2022-07-18  00:00:00'},13466739,6); 
DELETE FROM t_wf_mbillsummarycfg WHERE FID = 1465371252360366080;
IF NOT EXISTS (select fid from t_wf_mbillsummarycfg where fbilltype = 'src_demand')
INSERT INTO t_wf_mbillsummarycfg(FID,FTPLNAME,FSCENE,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSUMMARYTPL,FENABLE,FMODIFIERID,FBILLTYPE,FDEFAULTDATAROWS,FMODIFYTIME,FCREATORID,FDEFAULTROWS) VALUES (1465371252360366080,'单据关系图卡片模板','billRelationCardSummary',1465371252360366080,'A','src_demand_BBC_S',' ',{ts'2022-07-15  00:00:00'},'bpm_billrelation_cardtpl','1',1292577788431177728,'src_demand',3,{ts'2022-07-18  00:00:00'},13466739,6); 

/* 2022-7-18 消息主题-单据流程属性预置-多语言表  */

DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2L+D8VTHAHLO';
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465360222129267712')
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1465360222129267712,'2L+D8VTHAHLO','en_US','寻源申请单据摘要'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2L+D8VTHAHLM';
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465360222129267712')
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1465360222129267712,'2L+D8VTHAHLM','zh_CN','寻源申请卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2L+D8VTHAHLN';
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465360222129267712')
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1465360222129267712,'2L+D8VTHAHLN','zh_TW','尋源申請卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2L+ERF/FBITK';
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465368259850183680')
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1465368259850183680,'2L+ERF/FBITK','zh_CN','签约单卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2L+ERF/FBITL';
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465368259850183680')
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1465368259850183680,'2L+ERF/FBITL','zh_TW','簽約單卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2L+ERF/FBITM';
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465368259850183680')
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1465368259850183680,'2L+ERF/FBITM','en_US','签约单卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2L+FA8FUQ625';
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465371252360366080')
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1465371252360366080,'2L+FA8FUQ625','zh_CN','项目立项卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2L+FA8FUQ626';
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465371252360366080')
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1465371252360366080,'2L+FA8FUQ626','zh_TW','項目立項卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2L+FA8FUQ627';
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465371252360366080')
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1465371252360366080,'2L+FA8FUQ627','en_US','项目立项卡片'); 

/* 2022-7-18 消息主题-单据流程属性预置-分录表  */

DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1465368259892126720;
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465368259850183680')
INSERT INTO t_wf_mbillsumarycfgentry(FID,FFONTSIZE,FENTRYLOCATION,FCONTENT,FENTRYID,FFIELDID,FENTRYLOCATIONNAME,FFIELDTYPE,FENTRYLOCATIONID,FISHEADFIELD,FFONTCOLOR,FFIELDPERCEN,FEDITABLE,FFIELDKEY,FAGGREGATEFUNCTION,FSEQ,FFIELDNAME,FISDEFAULTSHOW,FSHOWCONTENT) VALUES (1465368259850183680,0,' ',' ',1465368259892126720,' ',' ',' ',' ','0',' ',' ','0',' ',' ',1,' ','1','采购组织：{model.org.name}'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1465371252393920512;
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465371252360366080')
INSERT INTO t_wf_mbillsumarycfgentry(FID,FFONTSIZE,FENTRYLOCATION,FCONTENT,FENTRYID,FFIELDID,FENTRYLOCATIONNAME,FFIELDTYPE,FENTRYLOCATIONID,FISHEADFIELD,FFONTCOLOR,FFIELDPERCEN,FEDITABLE,FFIELDKEY,FAGGREGATEFUNCTION,FSEQ,FFIELDNAME,FISDEFAULTSHOW,FSHOWCONTENT) VALUES (1465371252360366080,0,' ',' ',1465371252393920512,' ',' ',' ',' ','0',' ',' ','0',' ',' ',1,' ','1','采购组织：{model.org.name}'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1467400353908564992;
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465360222129267712')
INSERT INTO t_wf_mbillsumarycfgentry(FID,FFONTSIZE,FENTRYLOCATION,FCONTENT,FENTRYID,FFIELDID,FENTRYLOCATIONNAME,FFIELDTYPE,FENTRYLOCATIONID,FISHEADFIELD,FFONTCOLOR,FFIELDPERCEN,FEDITABLE,FFIELDKEY,FAGGREGATEFUNCTION,FSEQ,FFIELDNAME,FISDEFAULTSHOW,FSHOWCONTENT) VALUES (1465360222129267712,0,' ',' ',1467400353908564992,' ',' ',' ',' ','0',' ',' ','0',' ',' ',1,' ','1','需求组织：{model.org.name}'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1467400353908564993;
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465360222129267712')
INSERT INTO t_wf_mbillsumarycfgentry(FID,FFONTSIZE,FENTRYLOCATION,FCONTENT,FENTRYID,FFIELDID,FENTRYLOCATIONNAME,FFIELDTYPE,FENTRYLOCATIONID,FISHEADFIELD,FFONTCOLOR,FFIELDPERCEN,FEDITABLE,FFIELDKEY,FAGGREGATEFUNCTION,FSEQ,FFIELDNAME,FISDEFAULTSHOW,FSHOWCONTENT) VALUES (1465360222129267712,0,' ',' ',1467400353908564993,' ',' ',' ',' ','0',' ',' ','0',' ',' ',2,' ','1','创建人：{model.creator.id}'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1467400353908564994;
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465360222129267712')
INSERT INTO t_wf_mbillsumarycfgentry(FID,FFONTSIZE,FENTRYLOCATION,FCONTENT,FENTRYID,FFIELDID,FENTRYLOCATIONNAME,FFIELDTYPE,FENTRYLOCATIONID,FISHEADFIELD,FFONTCOLOR,FFIELDPERCEN,FEDITABLE,FFIELDKEY,FAGGREGATEFUNCTION,FSEQ,FFIELDNAME,FISDEFAULTSHOW,FSHOWCONTENT) VALUES (1465360222129267712,0,' ',' ',1467400353908564994,' ',' ',' ',' ','0',' ',' ','0',' ',' ',3,' ','1','申请日期：{reqdatetime}'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1467401470163854337;
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465368259850183680')
INSERT INTO t_wf_mbillsumarycfgentry(FID,FFONTSIZE,FENTRYLOCATION,FCONTENT,FENTRYID,FFIELDID,FENTRYLOCATIONNAME,FFIELDTYPE,FENTRYLOCATIONID,FISHEADFIELD,FFONTCOLOR,FFIELDPERCEN,FEDITABLE,FFIELDKEY,FAGGREGATEFUNCTION,FSEQ,FFIELDNAME,FISDEFAULTSHOW,FSHOWCONTENT) VALUES (1465368259850183680,0,' ',' ',1467401470163854337,' ',' ',' ',' ','0',' ',' ','0',' ',' ',2,' ','1','审核日期：{auditdate}'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1467403147977836544;
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465371252360366080')
INSERT INTO t_wf_mbillsumarycfgentry(FID,FFONTSIZE,FENTRYLOCATION,FCONTENT,FENTRYID,FFIELDID,FENTRYLOCATIONNAME,FFIELDTYPE,FENTRYLOCATIONID,FISHEADFIELD,FFONTCOLOR,FFIELDPERCEN,FEDITABLE,FFIELDKEY,FAGGREGATEFUNCTION,FSEQ,FFIELDNAME,FISDEFAULTSHOW,FSHOWCONTENT) VALUES (1465371252360366080,0,' ',' ',1467403147977836544,' ',' ',' ',' ','0',' ',' ','0',' ',' ',2,' ','1','创建人：{model.creator.name}'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1467403147977836545;
IF EXISTS (select fid from t_wf_mbillsummarycfg where fid = '1465371252360366080')
INSERT INTO t_wf_mbillsumarycfgentry(FID,FFONTSIZE,FENTRYLOCATION,FCONTENT,FENTRYID,FFIELDID,FENTRYLOCATIONNAME,FFIELDTYPE,FENTRYLOCATIONID,FISHEADFIELD,FFONTCOLOR,FFIELDPERCEN,FEDITABLE,FFIELDKEY,FAGGREGATEFUNCTION,FSEQ,FFIELDNAME,FISDEFAULTSHOW,FSHOWCONTENT) VALUES (1465371252360366080,0,' ',' ',1467403147977836545,' ',' ',' ',' ','0',' ',' ','0',' ',' ',3,' ','1','审核日期：{auditdate}'); 
