DELETE FROM t_bas_importtemplate WHERE FID = 412102866623307776;
DELETE FROM t_bas_importtemplate_l WHERE FID = 412102866623307776;
DELETE FROM t_bas_importtemplateentry WHERE FID = 412102866623307776;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FAPPLYSCOPE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (412102866623307776,'1',412102866623307776,'A','bcm_userdefinedmemberimp_IMPT_S',' ','IMPT',{ts'2018-08-08  18:08:08'},1,'1','0',{ts'2018-08-08  18:08:08'},' ',1,'bcm_userdefinedmemberimp'); 

INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (412102866623307776,'/9LAMI8/XWQI','zh_CN','出厂预置模板','自定义维度导入模板'); 

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 412102549710086144;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','0',NULL,0,412102549710086144,'bcm_userdefinedmemberimp',1,'0',' ',' ','自定义维度-导入'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 412102553157804032;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','0',NULL,412102549710086144,412102553157804032,'billhead',2,'0',' ',' ','单据头'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 412102553216524288;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524288,'number',3,'1',' ',' ','编码*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 412102553216524289;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524289,'name',4,'1',' ',' ','名称*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 412102553216524290;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1','number',412102553157804032,412102553216524290,'parent',5,'1',' ','name','上级*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 412102553216524291;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524291,'aggoprt',6,'0',' ',' ','聚合算法'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 412102553216524292;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524292,'storagetype',7,'1',' ',' ','存储类型'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 412102553216524293;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524293,'datatype',8,'0',' ',' ','数据类型'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 412102553216524294;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524294,'value',9,'0',' ',' ','枚举'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 412102553216524295;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524295,'description',10,'0',' ',' ','说明'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 412102553216524296;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1','number',412102553157804032,412102553216524296,'dimension',11,'1',' ','name','维度*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 412102553216524297;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1','number',412102553157804032,412102553216524297,'model',12,'1',' ','name','体系*'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 412102553216524298;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524298,'longnumber',13,'0',' ',' ','长编码'); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 412102553216524299;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',NULL,412102553157804032,412102553216524299,'definedpropertyvalue',14,'0',' ',' ','自定义属性值');
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',' ',412102553157804032,1039030781164510215,'memberpermissions',15,'0','数据格式：作用范围函数（用户类型，用户编码/用户组编码，读写权限）',' ',NULL); 
