--删除老的房产税税率模板
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 910747969416940544;

DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0UV=AVIQMTXC';
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0UV=AVIQMTXD';

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350094402560;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350102789120;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350102791168;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350102789121;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350102791169;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350102789122;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350102791170;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350102789123;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350102791171;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350102789124;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350102791172;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350102789125;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350102791173;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350102789126;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111179776;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111177728;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111179777;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111177729;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111179778;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111177730;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111179779;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111177731;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111179780;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111177732;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111179781;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111177733;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111179782;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111177734;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111179783;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111177735;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 910747350111179784;

--新增单独的税率模板。
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 957854925587606528;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (957854925587606528,957854925587606528,'C','tpo_tcret_taxratio_IMPT_S',' ','IMPT',{ts'2020-08-14  14:04:30'},13466739,'1',{ts'2020-08-14  14:06:45'},' ',13466739,'tpo_tcret_taxrate'); 

DELETE FROM t_bas_importtemplate_l WHERE FPKID = '1+N+1FAJE2KE';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (957854925587606528,'1+N+1FAJE2KE','zh_CN',' ','房产税和城镇土地使用税引入模板'); 
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '1+N+1FAJE2KF';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (957854925587606528,'1+N+1FAJE2KF','zh_TW',' ','房產稅和城鎮土地使用稅引入模板'); 

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386939399;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1',' ',957853797386945536,957853797386939399,'createtime1','0',30,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386945544;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1','number',957853797386945536,957853797386945544,'creator1','0',31,'name',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386939400;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'1','1',' ',957853797386945536,957853797386939400,'subdescription','0',32,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386945545;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1',' ',957853797386945536,957853797386945545,'conditionjson','0',33,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797336613888;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','0',' ',0,957853797336613888,'tpo_tcret_taxrate','0',1,',,',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797344996352;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','0',' ',957853797336613888,957853797344996352,'billhead','0',2,',,',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797345002496;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1',' ',957853797344996352,957853797345002496,'id','0',3,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797344996353;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'1','1',' ',957853797344996352,957853797344996353,'number','1',4,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797345002497;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'1','1',' ',957853797344996352,957853797345002497,'name','1',5,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797344996354;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'1','1',' ',957853797344996352,957853797344996354,'startdate','1',6,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797345002498;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'1','1',' ',957853797344996352,957853797345002498,'taxpayertype','1',7,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797344996355;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'1','1',' ',957853797344996352,957853797344996355,'enddate','0',8,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797345002499;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'1','1',' ',957853797344996352,957853797345002499,'policybasis','0',9,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797344996356;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'1','1',' ',957853797344996352,957853797344996356,'description','0',10,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797345002500;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1',' ',957853797344996352,957853797345002500,'status','0',11,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797344996357;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1','number',957853797344996352,957853797344996357,'creator','0',12,'name',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797345002501;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1',' ',957853797344996352,957853797345002501,'enable','0',13,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797344996358;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1',' ',957853797344996352,957853797344996358,'createtime','0',14,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386945536;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','0',' ',957853797336613888,957853797386945536,'entryentity','0',15,',,',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386939392;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1',' ',957853797386945536,957853797386939392,'entryentity.id','0',16,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386945537;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'1','1',' ',957853797386945536,957853797386945537,'mergecode','1',17,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386939393;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'1','1',' ',957853797386945536,957853797386939393,'subname','1',18,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386945538;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'1','1',' ',957853797386945536,957853797386945538,'taxrate','0',19,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386939394;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'1','1',' ',957853797386945536,957853797386939394,'taxmethod','0',20,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386945539;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'1','1',' ',957853797386945536,957853797386945539,'sumitem','0',21,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386939395;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1',' ',957853797386945536,957853797386939395,'filtercondition','0',22,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386945540;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1',' ',957853797386945536,957853797386945540,'longnumber','0',23,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386939396;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1',' ',957853797386945536,957853797386939396,'subnumber','0',24,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386945541;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1','number',957853797386945536,957853797386945541,'parent','0',25,'name',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386939397;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1',' ',957853797386945536,957853797386939397,'subenable','0',26,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386945542;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1',' ',957853797386945536,957853797386945542,'substatus','0',27,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386939398;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1',' ',957853797386945536,957853797386939398,'isleaf','0',28,' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 957853797386945543;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FMUSTINPUT,FSEQ,FEXPORTPROP,FDESCRIPTION,FFIELDNAME) VALUES (957854925587606528,'0','1',' ',957853797386945536,957853797386945543,'level','0',29,' ',' ',NULL); 
