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

delete from T_BAS_IMPORTTEMPLATE where fid = 772300762582738944;
delete from T_BAS_IMPORTTEMPLATE_L where fid = 772300762582738944;
delete from T_BAS_IMPORTTEMPLATEENTRY where fid = 772300762582738944;


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  00:00:00'},13466739,'1','0',{ts'2021-10-11  00:00:00'},' ',1,'bcm_accountmemberimp');

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

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',' ',' ','科目-导入');
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',7,'1',' ','name','上级*');
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',18,'1',' ','name','维度*');
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1','name',409827148245776384,1081651195002499081,'enumitem',34,'0',' ',' ',NULL);
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',' ',' ','单据头');
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'0','1',' ',409827148245776384,1078177923820772352,'id',3,'0',' ',' ',NULL);
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',4,'1',' ',' ','名称*');
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',5,'1',' ',' ','编码*');
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',6,'0',' ',' ','别名');
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',8,'1',' ',' ','存储类型');
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',9,'1',' ',' ','聚合算法');
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'0','1',' ',599738021637683200,599738021646071814,'accountuse',10,'0',' ',' ','科目用途');
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',11,'1',' ',' ','科目类型');
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',12,'1',' ',' ','借贷算法');
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',13,'1',' ',' ','数据类型');
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,'1',' ',' ','折算汇率');
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',' ',' ','是否参与合并');
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',16,'0',' ',' ','说明');
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',17,'0',' ',' ','长编码');
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',599738021637683200,599738021646071830,'isaccountoffset',19,'0',' ',' ','是否对账抵销');
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1017389005622580235,'iscaltype',20,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',409827148245776384,1078177923829160963,'entryrate',33,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',409827148245776384,1083316191168042001,'definedpropertyvalue',35,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'0','1',' ',409827148245776384,1223855933810026506,'bizchangerds',36,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',409827148245776384,1223855933810064395,'sectoryclass',37,'0',' ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',409827148245776384,1052091142465688592,'effectivecombinationat',21,'0','填写格式：作用范围函数（成员编码） ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1017389005622457355,'effectivecombinationct',22,'0','填写格式：作用范围函数（成员编码） ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1017389005622580236,'effectivecombinationic',23,'0','填写格式：作用范围函数（成员编码） ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1017389005622457356,'effectivecombinationmg',24,'0','填写格式：作用范围函数（成员编码） ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1017389005622580237,'effectivecombinationds',25,'0','填写格式：作用范围函数（成员编码） ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',409827148245776384,1306445105049124875,'accountscale',39,'0','科目精度',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1017389005622457357,'effectivecombinationc1',26,'0','填写格式：作用范围函数（成员编码） ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1017389005622580238,'effectivecombinationc2',27,'0','填写格式：作用范围函数（成员编码） ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1022247874441987072,'effectivecombinationc3',28,'0','填写格式：作用范围函数（成员编码） ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1022247874441986048,'effectivecombinationc4',29,'0','填写格式：作用范围函数（成员编码） ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1022247874441987073,'effectivecombinationc5',30,'0','填写格式：作用范围函数（成员编码） ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',981084989087142912,1022247874441986049,'effectivecombinationc6',31,'0','填写格式：作用范围函数（成员编码） ',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',876736190240312320,1033217596457010192,'memberpermissions',32,'0','数据格式：作用范围函数（用户类型，用户编码/用户组编码，读写权限）',' ',NULL);
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (409827330681223168,'1','1',' ',409827148245776384,1264346996647397394,'shielddim',38,'0','请填写维度简码并用英文逗号(,)分割',' ',NULL);