DELETE FROM t_bas_importtemplate WHERE FID = 409827330681223168;
DELETE FROM t_bas_importtemplate_l WHERE FID = 409827330681223168;
DELETE FROM t_bas_importtemplateentry WHERE FID = 409827330681223168;


DELETE FROM t_bas_importtemplate WHERE FID = 876736441000971264;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (876736441000971264,'1',876736441000971264,'C','bcm_accountmemberimp_IMPT_S1',' ','IMPT',{ts'2020-04-24  15:58:18'},13466739,'1',{ts'2020-04-24  16:02:46'},' ',13466739,'bcm_accountmemberimp'); 

DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0QOBEEZ80YM=';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (876736441000971264,'0QOBEEZ80YM=','zh_CN',' ','科目导入模板'); 


DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190206870528;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'0','0',' ',0,876736190206870528,'bcm_accountmemberimp',1,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240312320;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'0','0',' ',876736190206870528,876736190240312320,'billhead',2,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240424960;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1',' ',876736190240312320,876736190240424960,'name',5,'1',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240312321;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1',' ',876736190240312320,876736190240312321,'number',7,'1',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240424961;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1',' ',876736190240312320,876736190240424961,'simplename',6,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240312322;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1','number',876736190240312320,876736190240312322,'parent',9,'1',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240424962;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1',' ',876736190240312320,876736190240424962,'storagetype',10,'1',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240312323;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1',' ',876736190240312320,876736190240312323,'aggoprt',11,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240424963;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'0','1',' ',876736190240312320,876736190240424963,'accountuse',21,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240312324;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1',' ',876736190240312320,876736190240312324,'accounttype',12,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240424964;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1',' ',876736190240312320,876736190240424964,'drcrdirect',13,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240312325;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1',' ',876736190240312320,876736190240312325,'datatype',14,'1',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240424965;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1',' ',876736190240312320,876736190240424965,'value',15,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240312326;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1',' ',876736190240312320,876736190240312326,'exchange',16,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240424966;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1',' ',876736190240312320,876736190240424966,'isparticipmerge',17,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240312327;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1',' ',876736190240312320,876736190240312327,'isaccountoffset',18,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240424967;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1',' ',876736190240312320,876736190240424967,'description',20,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240312328;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1',' ',876736190240312320,876736190240312328,'longnumber',8,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240424968;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1','number',876736190240312320,876736190240424968,'dimension',4,'1',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240312329;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1','number',876736190240312320,876736190240312329,'model',3,'1',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 876736190240424969;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (876736441000971264,'1','1',' ',876736190240312320,876736190240424969,'definedpropertyvalue',19,'0',' ',' ',NULL); 
