-- 租赁合同有新增字段，需要调整模板，直接把原来的删掉，重新预制，其实fid没变
-- 1.删除
DELETE FROM t_bas_importtemplate
WHERE fid=952074244924247040;

DELETE FROM t_bas_importtemplate_l
WHERE fid=952074244924247040;

DELETE FROM t_bas_importtemplateentry
WHERE fid=952074244924247040;

-- 2.保存新模板
DELETE FROM t_bas_importtemplate WHERE fid = 952074244924247040;
INSERT INTO t_bas_importtemplate(fid,fenableimport,fmasterid,fstatus,fname,ftemplatetype,fnumber,fcreatetime,fmodifierid,fapplyscope,fenable,fmodifytime,fcomment,fcreatorid,fbizobject) VALUES (952074244924247040,'1',952074244924247040,'C',' ','IMPT','fa_lease_contract_IMPT_S',{ts'2018-08-08  00:00:00'},1152675720162577408,'0','1',{ts'2021-06-01  00:00:00'},' ',1,'fa_lease_contract');

DELETE FROM t_bas_importtemplate_l WHERE fpkid = '0ZY9ZQ6X8UTH';
INSERT INTO t_bas_importtemplate_l(fid,fpkid,flocaleid,fcomment,fname) VALUES (952074244924247040,'0ZY9ZQ6X8UTH','zh_CN','系统预置模板','租赁合同引入模板');
DELETE FROM t_bas_importtemplate_l WHERE fpkid = '0ZY9ZQ6X8UTI';
INSERT INTO t_bas_importtemplate_l(fid,fpkid,flocaleid,fcomment,fname) VALUES (952074244924247040,'0ZY9ZQ6X8UTI','zh_TW','係統預置模板','租賃合同引入模板');

DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740001328128;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0',' ','0',0,1168655740001328128,'fa_lease_contract',1,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034894848;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0',' ','0',1168655740001328128,1168655740034894848,'billhead',2,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034882560;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0',' ','1',1168655740034894848,1168655740034882560,'id',3,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034894849;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740034894848,1168655740034894849,'number',4,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034882561;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740034894848,1168655740034882561,'name',5,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034894850;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740034894848,1168655740034894850,'leasestartdate',6,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034882562;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740034894848,1168655740034882562,'leaseenddate',7,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034894851;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740034894848,1168655740034894851,'assetname',8,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034882563;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740034894848,1168655740034882563,'assetamount',9,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034894852;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1','number','1',1168655740034894848,1168655740034894852,'assetunit',10,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034882564;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1','number','1',1168655740034894848,1168655740034882564,'org',11,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034894853;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1','number','1',1168655740034894848,1168655740034894853,'leaser',12,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034882565;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0','number','1',1168655740034894848,1168655740034882565,'currency',13,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034894854;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740034894848,1168655740034894854,'contrsigndate',14,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034882566;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740034894848,1168655740034882566,'freeleasestartdate',15,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034894855;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0','number','1',1168655740034894848,1168655740034894855,'creator',16,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034882567;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0',' ','1',1168655740034894848,1168655740034882567,'createtime',17,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034894856;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0','number','1',1168655740034894848,1168655740034894856,'modifier',18,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034882568;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0',' ','1',1168655740034894848,1168655740034882568,'modifytime',19,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034894857;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0','number','1',1168655740034894848,1168655740034894857,'auditor',20,'0',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034882569;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0',' ','1',1168655740034894848,1168655740034882569,'auditdate',21,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034894858;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1','number','1',1168655740034894848,1168655740034894858,'assetcat',22,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034882570;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1','number','1',1168655740034894848,1168655740034882570,'storeplace',23,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034894859;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1','number','1',1168655740034894848,1168655740034894859,'unit',24,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740034882571;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740034894848,1168655740034882571,'discountrate',25,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740110380032;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0',' ','0',1168655740001328128,1168655740110380032,'payplanentryentity',26,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740118780928;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0',' ','1',1168655740110380032,1168655740118780928,'payplanentryentity.id',27,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740143934464;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0',' ','0',1168655740001328128,1168655740143934464,'payruleentryentity',28,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740143946752;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0',' ','1',1168655740143934464,1168655740143946752,'payruleentryentity.id',29,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740143934465;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740143934464,1168655740143934465,'frequency',30,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740143946753;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740143934464,1168655740143946753,'rule_startdate',31,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740143934466;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740143934464,1168655740143934466,'rule_enddate',32,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740143946754;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740143934464,1168655740143946754,'relativepaydate',33,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740143934467;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740143934464,1168655740143934467,'rule_invoicetype',34,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740143946755;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740143934464,1168655740143946755,'rule_deductible',35,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740143934468;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740143934464,1168655740143934468,'amount',36,'1',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740143946756;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1','number','1',1168655740143934464,1168655740143946756,'rule_payitem',37,'1',' ','name',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740143934469;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740143934464,1168655740143934469,'rule_taxrate',38,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740143946757;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'1',' ','1',1168655740143934464,1168655740143946757,'rule_tax',39,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740169100288;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0',' ','0',1168655740001328128,1168655740169100288,'terminationentry',40,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740169112576;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0',' ','1',1168655740169100288,1168655740169112576,'terminationentry.id',41,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740177488896;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0',' ','0',1168655740001328128,1168655740177488896,'srccontractentity',42,'0',' ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE fentryid = 1168655740177501184;
INSERT INTO t_bas_importtemplateentry(fid,fisimport,fimportprop,fisfield,fparententryid,fentryid,ffieldkey,fseq,fmustinput,fdescription,fexportprop,ffieldname) VALUES (952074244924247040,'0',' ','1',1168655740177488896,1168655740177501184,'srccontractentity.id',43,'0',' ',' ',NULL);


