-- 核心单据设置通用主题 应收

IF NOT EXISTS (select 1 from t_wf_billsubjectmodel where fentitynumber = 'ar_busbill')
INSERT INTO t_wf_billsubjectmodel(FID,FMODIFYDATE,FPUSHSTATUSPLUGIN,FBILLSUBJECTMOB,FBILLSUBJECT,FCREATEDATE,FMOBILEFORMKEY,FFORMKEYNAME,FBIZTRACENO,FFORMKEY,FBILLSUBJECTNAME,FENTITYNUMBER,FREFERORGANIZATION,FMAINFIELD,FBILLSUBMOBNAME,FSUBJECTSHOWNAME,FBILLID,FMODIFIERID,FMOBILEFORMKEYNAME,FBIZTRACENODESC,FBILLNAME,FPERMISSIONSPLUGIN,FCREATORID,FSAMPLE) VALUES (1468149929342947328,{ts'2022-07-19  00:00:00'},' ',' ','[{"sv_rule":"","customSubject":"结算组织：{model.org.name}  往来户：{model.asstact.name} 单据编号：{model.billno}  款项性质：{model.payproperty.name} 应收金额：{model.recamount}","rule":"","type":"expression","scene":"task"}]',{ts'2022-07-19  00:00:00'},' ','暂估应收单(ar_busbill)',' ','ar_busbill',' ','ar_busbill',' ',' ',' ','结算组织：{model.org.name}  往来户：{model.asstact.name} 单据编号：{model.billno}  款项性质：{model.payproperty.name} 应收金额：{model.recamount}','01DPPLJQ7A+H',13466739,' ',' ','暂估应收单',' ',13466739,' '); 

IF NOT EXISTS (select 1 from t_wf_billsubjectmodel where fentitynumber = 'ar_finarbill')
INSERT INTO t_wf_billsubjectmodel(FID,FMODIFYDATE,FPUSHSTATUSPLUGIN,FBILLSUBJECTMOB,FBILLSUBJECT,FCREATEDATE,FMOBILEFORMKEY,FFORMKEYNAME,FBIZTRACENO,FFORMKEY,FBILLSUBJECTNAME,FENTITYNUMBER,FREFERORGANIZATION,FMAINFIELD,FBILLSUBMOBNAME,FSUBJECTSHOWNAME,FBILLID,FMODIFIERID,FMOBILEFORMKEYNAME,FBIZTRACENODESC,FBILLNAME,FPERMISSIONSPLUGIN,FCREATORID,FSAMPLE) VALUES (1468152926055715840,{ts'2022-07-19  00:00:00'},' ',' ','[{"sv_rule":"","customSubject":"结算组织：{model.org.name} 往来户：{model.asstact.name} 单据编号：{model.billno} 款项性质：{model.payproperty.name} 应收金额：{model.recamount}","rule":"","type":"expression","scene":"task"}]',{ts'2022-07-19  00:00:00'},' ','财务应收单(ar_finarbill)',' ','ar_finarbill',' ','ar_finarbill',' ',' ',' ','结算组织：{model.org.name} 往来户：{model.asstact.name} 单据编号：{model.billno} 款项性质：{model.payproperty.name} 应收金额：{model.recamount}','/BFWSPAO6/SQ',13466739,' ',' ','财务应收单',' ',13466739,' '); 

IF NOT EXISTS (select 1 from t_wf_billsubjectmodel where fentitynumber = 'ar_revcfmbill')
INSERT INTO t_wf_billsubjectmodel(FID,FMODIFYDATE,FPUSHSTATUSPLUGIN,FBILLSUBJECTMOB,FBILLSUBJECT,FCREATEDATE,FMOBILEFORMKEY,FFORMKEYNAME,FBIZTRACENO,FFORMKEY,FBILLSUBJECTNAME,FENTITYNUMBER,FREFERORGANIZATION,FMAINFIELD,FBILLSUBMOBNAME,FSUBJECTSHOWNAME,FBILLID,FMODIFIERID,FMOBILEFORMKEYNAME,FBIZTRACENODESC,FBILLNAME,FPERMISSIONSPLUGIN,FCREATORID,FSAMPLE) VALUES (1468154902889911296,{ts'2022-07-19  00:00:00'},' ',' ','[{"sv_rule":"","customSubject":"结算组织：{model.org.name}  往来户：{model.asstact.name}  单据编号：{model.billno}  款项性质：{model.payproperty.name} 确认金额：{model.confirmamt}","rule":"","type":"expression","scene":"task"}]',{ts'2022-07-19  00:00:00'},' ','收入确认单(ar_revcfmbill)',' ','ar_revcfmbill',' ','ar_revcfmbill',' ',' ',' ','结算组织：{model.org.name}  往来户：{model.asstact.name}  单据编号：{model.billno}  款项性质：{model.payproperty.name} 确认金额：{model.confirmamt}','09B144H15HKQ',13466739,' ',' ','收入确认单',' ',13466739,' '); 

IF NOT EXISTS (select 1 from t_wf_billsubjectmodel where fentitynumber = 'ar_invoice')
INSERT INTO t_wf_billsubjectmodel(FID,FMODIFYDATE,FPUSHSTATUSPLUGIN,FBILLSUBJECTMOB,FBILLSUBJECT,FCREATEDATE,FMOBILEFORMKEY,FFORMKEYNAME,FBIZTRACENO,FFORMKEY,FBILLSUBJECTNAME,FENTITYNUMBER,FREFERORGANIZATION,FMAINFIELD,FBILLSUBMOBNAME,FSUBJECTSHOWNAME,FBILLID,FMODIFIERID,FMOBILEFORMKEYNAME,FBIZTRACENODESC,FBILLNAME,FPERMISSIONSPLUGIN,FCREATORID,FSAMPLE) VALUES (1468158968546217984,{ts'2022-07-19  00:00:00'},' ',' ','[{"sv_rule":"","customSubject":"单据编号：{model.billno} 购买方：{model.buyername} 销售方：{model.sellername} 价税合计：{model.recamount}","rule":"","type":"expression","scene":"task"}]',{ts'2022-07-19  00:00:00'},' ','开票单(ar_invoice)',' ','ar_invoice',' ','ar_invoice',' ',' ',' ','单据编号：{model.billno} 购买方：{model.buyername} 销售方：{model.sellername} 价税合计：{model.recamount}','/BX04G167J9U',13466739,' ',' ','开票单',' ',13466739,' '); 

IF NOT EXISTS (select 1 from t_wf_billsubjectmodel where fentitynumber = 'ar_liquidation')
INSERT INTO t_wf_billsubjectmodel(FID,FMODIFYDATE,FPUSHSTATUSPLUGIN,FBILLSUBJECTMOB,FBILLSUBJECT,FCREATEDATE,FMOBILEFORMKEY,FFORMKEYNAME,FBIZTRACENO,FFORMKEY,FBILLSUBJECTNAME,FENTITYNUMBER,FREFERORGANIZATION,FMAINFIELD,FBILLSUBMOBNAME,FSUBJECTSHOWNAME,FBILLID,FMODIFIERID,FMOBILEFORMKEYNAME,FBIZTRACENODESC,FBILLNAME,FPERMISSIONSPLUGIN,FCREATORID,FSAMPLE) VALUES (1468192819448402944,{ts'2022-07-19  00:00:00'},' ',' ','[{"sv_rule":"","customSubject":"结算组织：{model.org.name}  往来户：{model.asstact.name}  单据编号：{model.billno}  清理金额：{model.liquidationamt}","rule":"","type":"expression","scene":"task"}]',{ts'2022-07-19  00:00:00'},' ','月末清理单(ar_liquidation)',' ','ar_liquidation',' ','ar_liquidation',' ',' ',' ','结算组织：{model.org.name}  往来户：{model.asstact.name}  单据编号：{model.billno}  清理金额：{model.liquidationamt}','0=GCYQ5RR9TJ',13466739,' ',' ','月末清理单',' ',13466739,' '); 

IF NOT EXISTS (select 1 from t_wf_billsubjectmodel where fentitynumber = 'ar_baddebtlossbill')
INSERT INTO t_wf_billsubjectmodel(FID,FMODIFYDATE,FPUSHSTATUSPLUGIN,FBILLSUBJECTMOB,FBILLSUBJECT,FCREATEDATE,FMOBILEFORMKEY,FFORMKEYNAME,FBIZTRACENO,FFORMKEY,FBILLSUBJECTNAME,FENTITYNUMBER,FREFERORGANIZATION,FMAINFIELD,FBILLSUBMOBNAME,FSUBJECTSHOWNAME,FBILLID,FMODIFIERID,FMOBILEFORMKEYNAME,FBIZTRACENODESC,FBILLNAME,FPERMISSIONSPLUGIN,FCREATORID,FSAMPLE) VALUES (1468194598487609344,{ts'2022-07-19  00:00:00'},' ',' ','[{"sv_rule":"","customSubject":"结算组织：{model.org.name} 往来户：{model.asstact.name} 单据编号：{model.billno} 损失原因：{model.baddebtcause} 损失金额：{model.baddebtamt}","rule":"","type":"expression","scene":"task"}]',{ts'2022-07-19  00:00:00'},' ','坏账损失单(ar_baddebtlossbill)',' ','ar_baddebtlossbill',' ','ar_baddebtlossbill',' ',' ',' ','结算组织：{model.org.name} 往来户：{model.asstact.name} 单据编号：{model.billno} 损失原因：{model.baddebtcause} 损失金额：{model.baddebtamt}','/YS0EZQF7FTB',13466739,' ',' ','坏账损失单',' ',13466739,' '); 


--- 【单据关系图】按钮关联的单据摘要 预制数据
DELETE FROM t_wf_mbillsummarycfg WHERE FID = 1468896217978130432;
INSERT INTO t_wf_mbillsummarycfg(FID,FTPLNAME,FSCENE,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSUMMARYTPL,FENABLE,FMODIFIERID,FBILLTYPE,FDEFAULTDATAROWS,FMODIFYTIME,FCREATORID,FDEFAULTROWS) VALUES (1468896217978130432,'单据关系图卡片模板','billRelationCardSummary',1468896217978130432,'A','ar_baddebtlossbill_card',' ',{ts'2022-07-20  00:00:00'},'bpm_billrelation_cardtpl','1',13466739,'ar_baddebtlossbill',3,{ts'2022-07-20  00:00:00'},13466739,6); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LEAYLNT0LFW';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468896217978130432,'2LEAYLNT0LFW','zh_CN','坏账损失单卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LEAYLNT0LFX';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468896217978130432,'2LEAYLNT0LFX','zh_TW','壞賬損失單卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LEAYLNT0LFY';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468896217978130432,'2LEAYLNT0LFY','en_US','坏账损失单卡片'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468896218011684864;
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 (1468896217978130432,0,' ',' ',1468896218011684864,' ',' ',' ',' ','0',' ',' ','0',' ',' ',1,' ','1','结算组织：{model.org.name}'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468896218011684865;
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 (1468896217978130432,0,' ',' ',1468896218011684865,' ',' ',' ',' ','0',' ',' ','0',' ',' ',2,' ','1','损失日期：{model.bizdate}'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468896218011684866;
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 (1468896217978130432,0,' ',' ',1468896218011684866,' ',' ',' ',' ','0',' ',' ','0',' ',' ',3,' ','1','损失金额：{model.baddebtamt}');




DELETE FROM t_wf_mbillsummarycfg WHERE FID = 1468869409480135680;
INSERT INTO t_wf_mbillsummarycfg(FID,FTPLNAME,FSCENE,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSUMMARYTPL,FENABLE,FMODIFIERID,FBILLTYPE,FDEFAULTDATAROWS,FMODIFYTIME,FCREATORID,FDEFAULTROWS) VALUES (1468869409480135680,'单据关系图卡片模板','billRelationCardSummary',1468869409480135680,'A','ar_busbill_card',' ',{ts'2022-07-20  00:00:00'},'bpm_billrelation_cardtpl','1',13466739,'ar_busbill',3,{ts'2022-07-20  00:00:00'},13466739,6); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LE6Y8X1BYN2';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468869409480135680,'2LE6Y8X1BYN2','zh_CN','暂估应收卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LE6Y8X1BYN3';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468869409480135680,'2LE6Y8X1BYN3','zh_TW','暫估應收卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LE6Y8X1BYN4';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468869409480135680,'2LE6Y8X1BYN4','en_US','暂估应收卡片'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468869409538855936;
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 (1468869409480135680,0,' ',' ',1468869409538855936,' ',' ',' ',' ','0',' ',' ','0',' ',' ',1,' ','1','结算组织：{model.org.name}'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468869409538855937;
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 (1468869409480135680,0,' ',' ',1468869409538855937,' ',' ',' ',' ','0',' ',' ','0',' ',' ',2,' ','1','单据日期：{model.bizdate}'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468869409538855938;
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 (1468869409480135680,0,' ',' ',1468869409538855938,' ',' ',' ',' ','0',' ',' ','0',' ',' ',3,' ','1','应收金额：{model.recamount}');



DELETE FROM t_wf_mbillsummarycfg WHERE FID = 1468874231663055872;
INSERT INTO t_wf_mbillsummarycfg(FID,FTPLNAME,FSCENE,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSUMMARYTPL,FENABLE,FMODIFIERID,FBILLTYPE,FDEFAULTDATAROWS,FMODIFYTIME,FCREATORID,FDEFAULTROWS) VALUES (1468874231663055872,'单据关系图卡片模板','billRelationCardSummary',1468874231663055872,'A','ar_finarbill_card',' ',{ts'2022-07-20  00:00:00'},'bpm_billrelation_cardtpl','1',13466739,'ar_finarbill',3,{ts'2022-07-20  00:00:00'},13466739,6); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LE7UDAFKKXX';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468874231663055872,'2LE7UDAFKKXX','zh_CN','财务应收卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LE7UDAFKKXY';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468874231663055872,'2LE7UDAFKKXY','zh_TW','財務應收卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LE7UDAFKKXZ';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468874231663055872,'2LE7UDAFKKXZ','en_US','财务应收卡片'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468874231696610304;
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 (1468874231663055872,0,' ',' ',1468874231696610304,' ',' ',' ',' ','0',' ',' ','0',' ',' ',1,' ','1','结算组织：{model.org.name}');
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468874231696610305;
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 (1468874231663055872,0,' ',' ',1468874231696610305,' ',' ',' ',' ','0',' ',' ','0',' ',' ',2,' ','1','单据日期：{model.bizdate}');
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468874231696610306;
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 (1468874231663055872,0,' ',' ',1468874231696610306,' ',' ',' ',' ','0',' ',' ','0',' ',' ',3,' ','1','应收金额：{model.recamount}');



DELETE FROM t_wf_mbillsummarycfg WHERE FID = 1468883010366492672;
INSERT INTO t_wf_mbillsummarycfg(FID,FTPLNAME,FSCENE,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSUMMARYTPL,FENABLE,FMODIFIERID,FBILLTYPE,FDEFAULTDATAROWS,FMODIFYTIME,FCREATORID,FDEFAULTROWS) VALUES (1468883010366492672,'单据关系图卡片模板','billRelationCardSummary',1468883010366492672,'A','ar_invoice_card',' ',{ts'2022-07-20  00:00:00'},'bpm_billrelation_cardtpl','1',13466739,'ar_invoice',3,{ts'2022-07-20  00:00:00'},13466739,6); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LE9GC5A5OCW';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468883010366492672,'2LE9GC5A5OCW','zh_CN','开票单卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LE9GC5A5OCX';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468883010366492672,'2LE9GC5A5OCX','zh_TW','開票單卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LE9GC5A5OCY';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468883010366492672,'2LE9GC5A5OCY','en_US','开票单卡片'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468883010408435712;
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 (1468883010366492672,0,' ',' ',1468883010408435712,' ',' ',' ',' ','0',' ',' ','0',' ',' ',1,' ','1','购买方：{model.buyername}');
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468883010408435713;
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 (1468883010366492672,0,' ',' ',1468883010408435713,' ',' ',' ',' ','0',' ',' ','0',' ',' ',2,' ','1','销售方：{model.sellername}');
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468883010408435714;
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 (1468883010366492672,0,' ',' ',1468883010408435714,' ',' ',' ',' ','0',' ',' ','0',' ',' ',3,' ','1','价税合计：{model.recamount}');



DELETE FROM t_wf_mbillsummarycfg WHERE FID = 1468889091486535680;
INSERT INTO t_wf_mbillsummarycfg(FID,FTPLNAME,FSCENE,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSUMMARYTPL,FENABLE,FMODIFIERID,FBILLTYPE,FDEFAULTDATAROWS,FMODIFYTIME,FCREATORID,FDEFAULTROWS) VALUES (1468889091486535680,'单据关系图卡片模板','billRelationCardSummary',1468889091486535680,'A','ar_liquidation_card',' ',{ts'2022-07-20  00:00:00'},'bpm_billrelation_cardtpl','1',13466739,'ar_liquidation',3,{ts'2022-07-20  00:00:00'},13466739,6); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LE=LOCLAQXU';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468889091486535680,'2LE=LOCLAQXU','zh_CN','月末清理卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LE=LOCLAQXV';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468889091486535680,'2LE=LOCLAQXV','zh_TW','月末清理卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LE=LOCLAQXW';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468889091486535680,'2LE=LOCLAQXW','en_US','月末清理卡片'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468889091545255936;
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 (1468889091486535680,0,' ',' ',1468889091545255936,' ',' ',' ',' ','0',' ',' ','0',' ',' ',1,' ','1','结算组织：{model.org.name}'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468889091545255937;
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 (1468889091486535680,0,' ',' ',1468889091545255937,' ',' ',' ',' ','0',' ',' ','0',' ',' ',2,' ','1','清理日期：{model.liquidationdate}'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468889091545255938;
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 (1468889091486535680,0,' ',' ',1468889091545255938,' ',' ',' ',' ','0',' ',' ','0',' ',' ',3,' ','1','清理金额：{model.liquidationamt}');



DELETE FROM t_wf_mbillsummarycfg WHERE FID = 1468877127502811136;
INSERT INTO t_wf_mbillsummarycfg(FID,FTPLNAME,FSCENE,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FSUMMARYTPL,FENABLE,FMODIFIERID,FBILLTYPE,FDEFAULTDATAROWS,FMODIFYTIME,FCREATORID,FDEFAULTROWS) VALUES (1468877127502811136,'单据关系图卡片模板','billRelationCardSummary',1468877127502811136,'A','ar_revcfmbill_card',' ',{ts'2022-07-20  00:00:00'},'bpm_billrelation_cardtpl','1',13466739,'ar_revcfmbill',3,{ts'2022-07-20  00:00:00'},13466739,6); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LE8CH=KW6+Z';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468877127502811136,'2LE8CH=KW6+Z','zh_CN','收入确认单卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LE8CH=KW6/+';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468877127502811136,'2LE8CH=KW6/+','zh_TW','收入確認單卡片'); 
DELETE FROM t_wf_mbillsummarycfg_l WHERE FPKID = '2LE8CH=KW6//';
INSERT INTO t_wf_mbillsummarycfg_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1468877127502811136,'2LE8CH=KW6//','en_US','收入确认单卡片'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468877127544754176;
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 (1468877127502811136,0,' ',' ',1468877127544754176,' ',' ',' ',' ','0',' ',' ','0',' ',' ',1,' ','1','结算组织：{model.org.name}'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468877127544754177;
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 (1468877127502811136,0,' ',' ',1468877127544754177,' ',' ',' ',' ','0',' ',' ','0',' ',' ',2,' ','1','确认日期：{model.bizdate}'); 
DELETE FROM t_wf_mbillsumarycfgentry WHERE FENTRYID = 1468877127544754178;
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 (1468877127502811136,0,' ',' ',1468877127544754178,' ',' ',' ',' ','0',' ',' ','0',' ',' ',3,' ','1','确认金额：{model.confirmamt}');




















