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;

INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FAPPLYSCOPE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (409827330681223168,'1',409827330681223168,'A','bcm_accountmemberimp_IMPT_S',' ','IMPT',{ts'2018-08-08  18:08:08'},1,'1','0',{ts'2018-08-08  18:08:08'},' ',1,'bcm_accountmemberimp'); 

DELETE FROM t_bas_importtemplate_l WHERE FPKID = '/9AEFQC41NDN';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (409827330681223168,'/9AEFQC41NDN','zh_CN','出厂预置模板','科目导入模板'); 

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827147658573824;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','0',NULL,0,409827147658573824,'bcm_accountmemberimp',1,'0',' ',' ','科目-导入'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148245776384;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','0',NULL,409827147658573824,409827148245776384,'billhead',2,'0',' ',' ','单据头'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148254164992;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148254164992,'name',3,'1',' ',' ','名称*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148262553600;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148262553600,'number',4,'1',' ',' ','编码*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148262553601;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148262553601,'simplename',5,'0',' ',' ','别名'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148279330816;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1','number',409827148245776384,409827148279330816,'parent',6,'1',' ','name','上级*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148279330817;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148279330817,'storagetype',7,'1',' ',' ','存储类型'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148279330818;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148279330818,'aggoprt',8,'0',' ',' ','聚合算法'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148279330820;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148279330820,'accounttype',10,'0',' ',' ','科目类型'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148279330821;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148279330821,'drcrdirect',11,'0',' ',' ','借贷算法'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148296108032;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148296108032,'datatype',12,'0',' ',' ','数据类型'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148296108033;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148296108033,'value',13,'0',' ',' ','枚举'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148296108034;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148296108034,'exchange',14,'0',' ',' ','折算汇率'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148296108035;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148296108035,'isparticipmerge',15,'0',' ',' ','是否参与合并'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148296108036;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148296108036,'isrelateorg',16,'0',' ',' ','是否关联往来组织'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148304496640;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148304496640,'isyearendcarried',17,'0',' ',' ','年结时是否自动结转'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148304496641;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148304496641,'islosscarry',18,'0',' ',' ','是否损益年结科目'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148304496642;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1','number',409827148245776384,409827148304496642,'losscarryto',19,'0',' ','name','年度结转至科目'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148304496643;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148304496643,'description',20,'0',' ',' ','说明'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148312885248;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148312885248,'longnumber',21,'0',' ',' ','长编码'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148312885249;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1','number',409827148245776384,409827148312885249,'dimension',22,'1',' ','name','维度*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148312885250;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1','number',409827148245776384,409827148312885250,'model',23,'1',' ','name','体系*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 409827148312885251;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',NULL,409827148245776384,409827148312885251,'definedpropertyvalue',24,'0',' ',' ','自定义属性值'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 599738021646071814;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'0','1',' ',599738021637683200,599738021646071814,'accountuse',9,'0',' ',' ','科目用途'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 599738021646071830;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',599738021637683200,599738021646071830,'isaccountoffset',25,'0',' ',' ','是否对账抵销'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1017389005622580235;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1017389005622580235,'iscaltype',26,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1017389005622457355;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1017389005622457355,'effectivecombinationct',27,'0','填写格式：作用范围函数（成员编码） ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1017389005622580236;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1017389005622580236,'effectivecombinationic',28,'0','填写格式：作用范围函数（成员编码） ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1017389005622457356;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1017389005622457356,'effectivecombinationmg',29,'0','填写格式：作用范围函数（成员编码） ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1017389005622580237; 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1017389005622580237,'effectivecombinationds',30,'0','填写格式：作用范围函数（成员编码） ',' ',NULL);
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1017389005622457357; 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1017389005622457357,'effectivecombinationc1',31,'0','填写格式：作用范围函数（成员编码） ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1017389005622580238;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1017389005622580238,'effectivecombinationc2',32,'0','填写格式：作用范围函数（成员编码） ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1022247874441987072;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1022247874441987072,'effectivecombinationc3',33,'0','填写格式：作用范围函数（成员编码） ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1022247874441986048;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1022247874441986048,'effectivecombinationc4',34,'0','填写格式：作用范围函数（成员编码） ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1022247874441987073;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1022247874441987073,'effectivecombinationc5',35,'0','填写格式：作用范围函数（成员编码） ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1022247874441986049;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1022247874441986049,'effectivecombinationc6',36,'0','填写格式：作用范围函数（成员编码） ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 1033217596457010192;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',876736190240312320,1033217596457010192,'memberpermissions',37,'0','数据格式：作用范围函数（用户类型，用户编码/用户组编码，读写权限）',' ',NULL); 
