-- 银行代发单、银行付款单、付款申请单消息场景
DELETE FROM t_msg_tplscene WHERE FID = 1949364322971251712;
INSERT INTO t_msg_tplscene(FID,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1949364322971251712,'bei_bankagentpay','bei_bankagentpay_payfail','代发处理同步银行代发单交易失败');
DELETE FROM t_msg_tplscene WHERE FID = 1949364612344673280;
INSERT INTO t_msg_tplscene(FID,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1949364612344673280,'bei_bankagentpay','bei_bankagentpay_notconfirm','代发处理同步银行代发单交易结果未确认');
DELETE FROM t_msg_tplscene WHERE FID = 1949364948576735232;
INSERT INTO t_msg_tplscene(FID,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1949364948576735232,'bei_bankagentpay','bei_bankagentpay_partpayfail','代发处理同步银行代发单部分交易失败');
DELETE FROM t_msg_tplscene WHERE FID = 1949360165954614272;
INSERT INTO t_msg_tplscene(FID,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1949360165954614272,'bei_bankpaybill','bei_bankpaybill_notconfirm','付款处理同步银行单据交易结果未确认');
DELETE FROM t_msg_tplscene WHERE FID = 1949359714085467136;
INSERT INTO t_msg_tplscene(FID,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1949359714085467136,'bei_bankpaybill','bei_bankpaybill_payfail','付款处理同步银行单据交易失败');
DELETE FROM t_msg_tplscene WHERE FID = 1949361733122749440;
INSERT INTO t_msg_tplscene(FID,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1949361733122749440,'cas_payapplybill','cas_payapplybill_paysuccess','付款申请单付款明细付款成功');
DELETE FROM t_msg_tplscene WHERE FID = 1949362206517064704;
INSERT INTO t_msg_tplscene(FID,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1949362206517064704,'cas_payapplybill','cas_payapplybill_backbill','付款申请单付款明细退单');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '43F7G0AAZ2B9';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1949364948576735232,'43F7G0AAZ2B9','zh_CN','代发处理同步银行代发单部分交易失败');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43F7G0AAZ2B=';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1949364948576735232,'43F7G0AAZ2B=','zh_TW','代發處理同步銀行代發單部分交易失敗');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43F7DKRPB3MC';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1949364612344673280,'43F7DKRPB3MC','zh_CN','代发处理同步银行代发单交易结果未确认');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43F7DKRPB3MD';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1949364612344673280,'43F7DKRPB3MD','zh_TW','代發處理同步銀行代發單交易結果未確認');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43F7BGIESIF3';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1949364322971251712,'43F7BGIESIF3','zh_CN','代发处理同步银行代发单交易失败');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43F7BGIESIF4';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1949364322971251712,'43F7BGIESIF4','zh_TW','代發處理同步銀行代發單交易失敗');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43F6K64455HB';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1949360165954614272,'43F6K64455HB','zh_CN','付款处理同步银行单据交易结果未确认');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43F6K64455HC';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1949360165954614272,'43F6K64455HC','zh_TW','付款處理同步銀行單據交易結果未確認');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43F6GWPURTR8';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1949359714085467136,'43F6GWPURTR8','zh_CN','付款处理同步银行单据交易失败');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43F6GWPURTR9';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1949359714085467136,'43F6GWPURTR9','zh_TW','付款處理同步銀行單據交易失敗');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43F6VLHUUG0+';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1949361733122749440,'43F6VLHUUG0+','zh_CN','付款申请单付款明细付款成功');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43F6VLHUUG0/';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1949361733122749440,'43F6VLHUUG0/','zh_TW','付款申請單付款明細付款成功');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43F6Z10PM72+';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1949362206517064704,'43F6Z10PM72+','zh_CN','付款申请单付款明细退单');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43F6Z10PM72/';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1949362206517064704,'43F6Z10PM72/','zh_TW','付款申請單付款明細退單');

-- 银行代发单、银行付款单、付款申请单消息模板
DELETE FROM t_msg_template WHERE FID = 1939801589124866048;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1939801589124866048,{ts'2024-06-05  00:00:00'},'银行代发单交易失败',{ts'2024-04-30  00:00:00'},'{"title":"银行代发单交易失败通知","content":"银行代发单：{billno} 交易失败，请及时处理。"}','bei_bankagentpay','bei_bankagentpay_payfail_notice','银行代发单交易失败通知','message','mcenter',' ',NULL,'bei_bankagentpay_payfail');
DELETE FROM t_msg_template WHERE FID = 1939806386813050880;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1939806386813050880,{ts'2024-05-13  00:00:00'},'银行代发单部分交易失败',{ts'2024-04-30  00:00:00'},'{"title":"银行代发单部分交易失败通知","content":"银行代发单：{billno} 部分交易失败，请及时处理。"}','bei_bankagentpay','bei_bankagentpay_partpayfail_notice','银行代发单部分交易失败通知','message','mcenter',' ',NULL,'bei_bankagentpay_partpayfail');
DELETE FROM t_msg_template WHERE FID = 1939312400814049280;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1939312400814049280,{ts'2024-05-13  00:00:00'},'银行代发单交易结果未确认',{ts'2024-04-29  00:00:00'},'{"title":"银行代发单交易结果未确认通知","content":"银行代发单：{billno} 交易结果未确认，请及时查看和处理。"}','bei_bankagentpay','bei_bankagentpay_notconfirm_notice','银行代发单交易结果未确认通知','message','mcenter',' ',NULL,'bei_bankagentpay_notconfirm');
DELETE FROM t_msg_template WHERE FID = 1949332229398433792;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1949332229398433792,{ts'2024-05-13  00:00:00'},'付款申请单付款成功',{ts'2024-05-13  00:00:00'},'{"title":"付款申请单付款成功通知","content":"付款申请单：{billno} 已完成付款，请知悉。"}','cas_payapplybill','cas_payapplybill_paysuccess_notice','付款申请单付款成功通知','message','mcenter',' ',NULL,'cas_payapplybill_paysuccess');
DELETE FROM t_msg_template WHERE FID = 1949344451885626368;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1949344451885626368,{ts'2024-05-13  00:00:00'},'付款申请单付款明细退单',{ts'2024-05-13  00:00:00'},'{"title":"付款申请单付款明细退单通知","content":"付款申请单：{billno} 存在退单记录，请及时查看和处理。"}','cas_payapplybill','cas_payapplybill_backbill_notice','付款申请单付款明细退单通知','message','mcenter',' ',NULL,'cas_payapplybill_backbill');
DELETE FROM t_msg_template WHERE FID = 1939830425308797952;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1939830425308797952,{ts'2024-05-13  00:00:00'},'银行付款单交易结果未确认',{ts'2024-04-30  00:00:00'},'{"title":"银行付款单交易结果未确认通知","content":"银行付款单：{billno} 交易结果未确认，请及时处理。"}','bei_bankpaybill','bei_bankpaybill_notconfirm_notice','银行付款单交易结果未确认通知','message','mcenter',' ',NULL,'bei_bankpaybill_notconfirm');
DELETE FROM t_msg_template WHERE FID = 1938393790054681600;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1938393790054681600,{ts'2024-05-13  00:00:00'},'银行付款单交易失败',{ts'2024-04-28  00:00:00'},'{"title":"银行付款单交易失败通知","content":"银行付款单：{billno} 交易失败，请及时查看和处理。"}','bei_bankpaybill','bei_bankpaybill_payfail_notice','银行付款单交易失败通知','message','mcenter',' ',NULL,'bei_bankpaybill_payfail');

DELETE FROM t_msg_template_l WHERE FPKID = '429DL+W9C1=A';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1939801589124866048,'银行代发单交易失败','429DL+W9C1=A','zh_CN','{"title":"银行代发单交易失败通知","content":"银行代发单：{billno} 交易失败，请及时处理。"}','银行代发单交易失败通知');
DELETE FROM t_msg_template_l WHERE FPKID = '429DL+W9C1=B';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1939801589124866048,'銀行代發單交易失敗','429DL+W9C1=B','zh_TW',' ','銀行代發單交易失敗通知');
DELETE FROM t_msg_template_l WHERE FPKID = '429EGZBFFLAI';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1939806386813050880,'银行代发单部分交易失败','429EGZBFFLAI','zh_CN','{"title":"银行代发单部分交易失败通知","content":"银行代发单：{billno} 部分交易失败，请及时处理。"}','银行代发单部分交易失败通知');
DELETE FROM t_msg_template_l WHERE FPKID = '429EGZBFFLAJ';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1939806386813050880,'銀行代發單部分交易失敗','429EGZBFFLAJ','zh_TW',' ','銀行代發單部分交易失敗通知');
DELETE FROM t_msg_template_l WHERE FPKID = '42716=A464LY';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1939312400814049280,'银行代发单交易结果未确认','42716=A464LY','zh_CN','{"title":"银行代发单交易结果未确认通知","content":"银行代发单：{billno} 交易结果未确认，请及时查看和处理。"}','银行代发单交易结果未确认通知');
DELETE FROM t_msg_template_l WHERE FPKID = '42716=A464LZ';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1939312400814049280,'銀行代發單交易結果未確認','42716=A464LZ','zh_TW',' ','銀行代發單交易結果未確認通知');
DELETE FROM t_msg_template_l WHERE FPKID = '43F1BLS=5XFS';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1949332229398433792,'付款申請單付款成功','43F1BLS=5XFS','zh_TW',' ','付款申請單付款成功通知');
DELETE FROM t_msg_template_l WHERE FPKID = '43F1BLS=5XFR';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1949332229398433792,'付款申请单付款成功','43F1BLS=5XFR','zh_CN','{"title":"付款申请单付款成功通知","content":"付款申请单：{billno} 已完成付款，请知悉。"}','付款申请单付款成功通知');
DELETE FROM t_msg_template_l WHERE FPKID = '43F3MOA84A9P';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1949344451885626368,'付款申请单付款明细退单','43F3MOA84A9P','zh_CN','{"title":"付款申请单付款明细退单通知","content":"付款申请单：{billno} 存在退单记录，请及时查看和处理。"}','付款申请单付款明细退单通知');
DELETE FROM t_msg_template_l WHERE FPKID = '43F3MOA84A9Q';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1949344451885626368,'付款申請單付款明細退單','43F3MOA84A9Q','zh_TW',' ','付款申請單付款明細退單通知');
DELETE FROM t_msg_template_l WHERE FPKID = '429J+3X4ENWW';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1939830425308797952,'银行付款单交易结果未确认','429J+3X4ENWW','zh_CN','{"title":"银行付款单交易结果未确认通知","content":"银行付款单：{billno} 交易结果未确认，请及时处理。"}','银行付款单交易结果未确认通知');
DELETE FROM t_msg_template_l WHERE FPKID = '429J+3X4ENWX';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1939830425308797952,'銀行付款單交易結果未確認','429J+3X4ENWX','zh_TW',' ','銀行付款單交易結果未確認通知');
DELETE FROM t_msg_template_l WHERE FPKID = '422NJD5VIGN1';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1938393790054681600,'银行付款单交易失败','422NJD5VIGN1','zh_CN','{"title":"银行付款单交易失败通知","content":"银行付款单：{billno} 交易失败，请及时查看和处理。"}','银行付款单交易失败通知');
DELETE FROM t_msg_template_l WHERE FPKID = '422NJD5VIGN2';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1938393790054681600,'銀行付款單交易失敗','422NJD5VIGN2','zh_TW',' ','銀行付款單交易失敗通知');


--付款处理退款、退票、打回消息场景与消息模板
DELETE FROM t_msg_tplscene WHERE FID = 1950787134269030400;
INSERT INTO t_msg_tplscene(FID,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1950787134269030400,'cas_paybill','cas_paybill_bitback','银行付款单打回');
DELETE FROM t_msg_tplscene WHERE FID = 1950850405521347584;
INSERT INTO t_msg_tplscene(FID,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1950850405521347584,'cas_paybill','cas_paybill_refund','付款处理单退款');
DELETE FROM t_msg_tplscene WHERE FID = 1950851122873162752;
INSERT INTO t_msg_tplscene(FID,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1950851122873162752,'cas_paybill','cas_paybill_renote','付款处理单退票');
DELETE FROM t_msg_template WHERE FID = 1950709060252859392;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1950709060252859392,{ts'2024-05-15  00:00:00'},'银行付款单打回',{ts'2024-05-15  00:00:00'},'{"title":"付款处理单打回通知","content":"付款处理单：{billno} 已打回，打回意见：{repulsedreason}，请尽快查看和处理。"}','cas_paybill','cas_paybill_bitback_notice','银行付款单打回通知','message','mcenter',' ',NULL,'cas_paybill_bitback');
DELETE FROM t_msg_template WHERE FID = 1950851955048240128;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1950851955048240128,{ts'2024-05-16  00:00:00'},'付款处理单退票',{ts'2024-05-15  00:00:00'},'{"title":"付款处理单退票通知","content":"付款处理单：{billno} 已被退票，请知悉。"}','cas_paybill','cas_paybill_renote_notice','付款处理单退票通知','message','mcenter',' ',NULL,'cas_paybill_renote');
DELETE FROM t_msg_template WHERE FID = 1950849550369870848;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1950849550369870848,{ts'2024-05-16  00:00:00'},'付款处理单退款',{ts'2024-05-15  00:00:00'},'{"title":"付款处理单退款通知","content":"付款处理单：{billno} 发生退款，请知悉。"}','cas_paybill','cas_paybill_refund_notice','付款处理单退款通知','message','mcenter',' ',NULL,'cas_paybill_refund');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '43M06GKW5=X6';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1950787134269030400,'43M06GKW5=X6','zh_CN','银行付款单打回');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43M06GKW5=X7';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1950787134269030400,'43M06GKW5=X7','zh_TW','銀行付款單打回');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43MB/ISVPS7O';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1950850405521347584,'43MB/ISVPS7O','zh_CN','付款处理单退款');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43MB/ISVPS7P';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1950850405521347584,'43MB/ISVPS7P','zh_TW','付款處理單退款');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43MB4RNMQ76/';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1950851122873162752,'43MB4RNMQ76/','zh_CN','付款处理单退票');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43MB4RNMQ760';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1950851122873162752,'43MB4RNMQ760','zh_TW','付款處理單退票');
DELETE FROM t_msg_template_l WHERE FPKID = '43LNLJJF4HW1';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1950709060252859392,'銀行付款單打回','43LNLJJF4HW1','zh_TW',' ','銀行付款單打回通知');
DELETE FROM t_msg_template_l WHERE FPKID = '43LNLJJF4HW0';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1950709060252859392,'银行付款单打回','43LNLJJF4HW0','zh_CN','{"title":"付款处理单打回通知","content":"付款处理单：{billno} 已打回，打回意见：{repulsedreason}，请尽快查看和处理。"}','银行付款单打回通知');
DELETE FROM t_msg_template_l WHERE FPKID = '43MB=U50UW=C';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1950851955048240128,'付款处理单退票','43MB=U50UW=C','zh_CN','{"title":"付款处理单退票通知","content":"付款处理单：{billno} 已被退票，请知悉。"}','付款处理单退票通知');
DELETE FROM t_msg_template_l WHERE FPKID = '43MB=U50UW=D';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1950851955048240128,'付款處理單退票','43MB=U50UW=D','zh_TW',' ','付款處理單退票通知');
DELETE FROM t_msg_template_l WHERE FPKID = '43MAV=RSWWGQ';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1950849550369870848,'付款处理单退款','43MAV=RSWWGQ','zh_CN','{"title":"付款处理单退款通知","content":"付款处理单：{billno} 发生退款，请知悉。"}','付款处理单退款通知');
DELETE FROM t_msg_template_l WHERE FPKID = '43MAV=RSWWGR';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1950849550369870848,'付款處理單退款','43MAV=RSWWGR','zh_TW',' ','付款處理單退款通知');

--代发处理退款、退票、打回消息场景与消息模板
DELETE FROM t_msg_tplscene WHERE FID = 1950853539740179456;
INSERT INTO t_msg_tplscene(FID,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1950853539740179456,'cas_agentpaybill','cas_agentpaybill_renote','代发处理单退票');
DELETE FROM t_msg_tplscene WHERE FID = 1950853323834186752;
INSERT INTO t_msg_tplscene(FID,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1950853323834186752,'cas_agentpaybill','cas_agentpaybill_refund','代发处理单退款');
DELETE FROM t_msg_tplscene WHERE FID = 1950798963976615936;
INSERT INTO t_msg_tplscene(FID,FENTITYNUMBER,FNUMBER,FNAME) VALUES (1950798963976615936,'cas_agentpaybill','cas_agentpaybill_bitback','银行代发单打回');
DELETE FROM t_msg_template WHERE FID = 1950800359010514944;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1950800359010514944,{ts'2024-05-15  00:00:00'},'银行代发单打回',{ts'2024-05-15  00:00:00'},'{"title":"代发处理单打回通知","content":"代发处理单：{billno} 已打回，打回意见：{repulsedreason}，请尽快查看和处理。"}','cas_agentpaybill','cas_agentpaybill_bitback_notice','银行代发单打回通知','message','mcenter',' ',NULL,'cas_agentpaybill_bitback');
DELETE FROM t_msg_template WHERE FID = 1950856975613350912;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1950856975613350912,{ts'2024-05-16  00:00:00'},'代发处理单退票',{ts'2024-05-15  00:00:00'},'{"title":"代发处理单退款通知","content":"代发处理单：{billno} 发生退款，请知悉。"}','cas_agentpaybill','cas_agentpaybill_refund_notice','代发处理单退款通知','message','mcenter',' ',NULL,'cas_agentpaybill_refund');
DELETE FROM t_msg_template WHERE FID = 1950856049620079616;
INSERT INTO t_msg_template(FID,FMODIFYDATE,FMSGSCENENAME,FCREATEDATE,FCOMMONLANG,FMSGENTITY,FNUMBER,FNAME,FMSGTYPE,FMSGCHANNEL,FBIZPLUGIN,FMSGTEMPLATE,FMSGSCENE) VALUES (1950856049620079616,{ts'2024-05-16  00:00:00'},'代发处理单退款',{ts'2024-05-15  00:00:00'},'{"title":"代发处理单退票通知","content":"代发处理单：{billno} 已被退票，请知悉。"}','cas_agentpaybill','cas_agentpaybill_renote_notice','代发处理单退票通知','message','mcenter',' ',NULL,'cas_agentpaybill_renote');

DELETE FROM t_msg_tplscene_l WHERE FPKID = '43MBLCI+=I89';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1950853539740179456,'43MBLCI+=I89','zh_CN','代发处理单退票');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43MBLCI+=I8=';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1950853539740179456,'43MBLCI+=I8=','zh_TW','代發處理單退票');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43MBJT5+I75=';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1950853323834186752,'43MBJT5+I75=','zh_CN','代发处理单退款');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43MBJT5+I75A';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1950853323834186752,'43MBJT5+I75A','zh_TW','代發處理單退款');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43M2DOHFM367';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1950798963976615936,'43M2DOHFM367','zh_CN','银行代发单打回');
DELETE FROM t_msg_tplscene_l WHERE FPKID = '43M2DOHFM368';
INSERT INTO t_msg_tplscene_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1950798963976615936,'43M2DOHFM368','zh_TW','銀行代發單打回');
DELETE FROM t_msg_template_l WHERE FPKID = '43M2NUZA4PIL';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1950800359010514944,'银行代发单打回','43M2NUZA4PIL','zh_CN','{"title":"代发处理单打回通知","content":"代发处理单：{billno} 已打回，打回意见：{repulsedreason}，请尽快查看和处理。"}','银行代发单打回通知');
DELETE FROM t_msg_template_l WHERE FPKID = '43M2NUZA4PIM';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1950800359010514944,'銀行代發單打回','43M2NUZA4PIM','zh_TW',' ','銀行代發單打回通知');
DELETE FROM t_msg_template_l WHERE FPKID = '43MC8DZGYQTE';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1950856975613350912,'代发处理单退票','43MC8DZGYQTE','zh_CN','{"title":"代发处理单退款通知","content":"代发处理单：{billno} 发生退款，请知悉。"}','代发处理单退款通知');
DELETE FROM t_msg_template_l WHERE FPKID = '43MC8DZGYQTF';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1950856975613350912,'代發處理單退票','43MC8DZGYQTF','zh_TW',' ','代發處理單退款通知');
DELETE FROM t_msg_template_l WHERE FPKID = '43MC1NT8=I8P';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1950856049620079616,'代发处理单退款','43MC1NT8=I8P','zh_CN','{"title":"代发处理单退票通知","content":"代发处理单：{billno} 已被退票，请知悉。"}','代发处理单退票通知');
DELETE FROM t_msg_template_l WHERE FPKID = '43MC1NT8=I8Q';
INSERT INTO t_msg_template_l(FID,FMSGSCENENAME,FPKID,FLOCALEID,FMSGTEMPLATE,FNAME) VALUES (1950856049620079616,'代發處理單退款','43MC1NT8=I8Q','zh_TW',' ','代發處理單退票通知');
