DELETE FROM t_bas_importtemplate WHERE FID = 828883167405630464;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FTEMPLATETYPE,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (828883167405630464,'1',828883167405630464,'C','bcm_chkformulasetting_IMPT_S','IMPT',' ',{ts'2018-08-08  18:08:08'},1,'1',{ts'2018-08-08  18:08:08'},' ',1,'bcm_chkformulasetting'); 

DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0KT28FEJ0F9I';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (828883167405630464,'0KT28FEJ0F9I','zh_CN',' ','勾稽关系导入'); 

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720099622912;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','0',' ',0,828896720099622912,'bcm_chkformulasetting',1,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149547008;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','0',' ',828896720099622912,828896720149547008,'billhead',2,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149547009;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720149547008,828896720149547009,'name',5,'1',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149547010;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720149547008,828896720149547010,'lformulatemp',7,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149547011;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720149547008,828896720149547011,'rformulatemp',9,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149547012;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720149547008,828896720149547012,'allowamount',11,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149547013;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1','number',828896720149547008,828896720149547013,'org',13,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149547014;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1','number',828896720149547008,828896720149547014,'multitemplate',15,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149547015;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','1','number',828896720149547008,828896720149547015,'creator',17,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149547016;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720149547008,828896720149547016,'status',19,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149547017;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720149547008,828896720149547017,'islink',21,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149547018;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720149547008,828896720149547018,'chineseformula',23,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149547019;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720149547008,828896720149547019,'fixdimtxt',25,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149954560;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720149547008,828896720149954560,'number',4,'1',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149954561;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','1',' ',828896720149547008,828896720149954561,'leftformula',6,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149954562;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','1',' ',828896720149547008,828896720149954562,'rightformula',8,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149954563;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720149547008,828896720149954563,'comparetype',10,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149954564;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720149547008,828896720149954564,'chkeffecttype',12,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149954565;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','1','number',828896720149547008,828896720149954565,'template',14,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149954566;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1','number',828896720149547008,828896720149954566,'model',16,'1',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149954567;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720149547008,828896720149954567,'createtime',18,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149954568;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720149547008,828896720149954568,'description',20,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149954569;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','1',' ',828896720149547008,828896720149954569,'vformula',22,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720149954570;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720149547008,828896720149954570,'rangetxt',24,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720157935616;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','1',' ',828896720158343168,828896720157935616,'memberid',29,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720157935617;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','1','number',828896720158343168,828896720157935617,'dimension',31,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720157935618;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','1',' ',828896720158343168,828896720157935618,'membboundtype',33,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720157935619;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','0',' ',828896720099622912,828896720157935619,'effective',35,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720157935620;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1','number',828896720157935619,828896720157935620,'effectiveperiod',38,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720158343168;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','0',' ',828896720099622912,828896720158343168,'memberrange',27,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720158343169;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','1',' ',828896720158343168,828896720158343169,'membbound',30,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720158343170;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','1','number',828896720158343168,828896720158343170,'propertyid',32,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720158343171;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','1',' ',828896720158343168,828896720158343171,'limittype',34,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720158343172;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1','number',828896720157935619,828896720158343172,'effectiveyear',37,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 828896720158343173;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720157935619,828896720158343173,'applytype',39,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1022232975141525504;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','1',' ',828896720149547008,1022232975141525504,'id',3,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1022232975141526540;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','1',' ',828896720149547008,1022232975141526540,'periodtxt',26,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1022232975175079936;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','1',' ',828896720158343168,1022232975175079936,'memberrange.id',28,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1022232975191858176;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'0','1',' ',828896720157935619,1022232975191858176,'effective.id',36,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1022232975191858178;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (828883167405630464,'1','1',' ',828896720157935619,1022232975191858178,'yearscope',40,'0',' ',' ',NULL); 
