--删除多余重复模板
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1123136958567050240;
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FID = 1123136958567050240;
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY where FID = 1123136958567050240;


--模板名称重命名
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 588145943023567872;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLESETNULL,FOVERRIDEENTRY,FENABLEIMPORT,FMASTERID,FEXCHANGENAMEANDMARK,FSTATUS,FNUMBER,FTEMPLATETYPE,FNAME,FCREATETIME,FHIDEFIELDROW,FMODIFIERID,FENABLE,FAPPLYSCOPE,FSPLITSUBENTRIES,FFORUPDATEMULTILANGFIELDS,FPLUGIN,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (588145943023567872,'1','0','1',588145943023567872,'0','C','bei_betransdetail_imp_IMPT_S','IMPT','离线明细引入预置模板',{ts'2022-11-24  00:00:00'},'0',1632483539985373184,'1','0','0','0',' ',{ts'2023-08-22  00:00:00'},' ',0,'bei_betransdetail_imp');
--多语言
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '3HUXOAG7=YNK';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (588145943023567872,'3HUXOAG7=YNK','zh_CN','引入模板（标准预置数据）','离线明细引入预置模板');
DELETE FROM T_BAS_IMPORTTEMPLATE_l WHERE FPKID = '3HUXOAG7=YNL';
INSERT INTO T_BAS_IMPORTTEMPLATE_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (588145943023567872,'3HUXOAG7=YNL','zh_TW','引入模板（標準預置數據）','離線明細引入預置模板');

--模板添加银行流水号字段
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1835714707559237651;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FCOLWIDTH,FIMPORTPROP,FENTRYID,FMUSTINPUT,FISDATE,FDESCRIPTION,FEXPORTPROP,FISIMPORT,FISFIELD,FEXPORTFORMAT,FSOURCENAME,FPARENTENTRYID,FFIELDKEY,FSEQ,FFIELDNAME,FEXPORTFORMATNAME,FSOURCEENTITY) VALUES (588145943023567872,0,' ',1835714707559237651,'0','0',' ',' ','1','1',' ',' ',588145071380087808,'bankdetailno',63,NULL,' ',' ');
