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

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

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',' ',' ','自定义维度-导入'); 
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',' ',' ','单据头'); 
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',4,'1',' ',' ','编码*'); 
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',5,'1',' ',' ','名称*'); 
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',6,'1',' ','name','上级*'); 
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',7,'0',' ',' ','聚合算法'); 
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',8,'1',' ',' ','存储类型'); 
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',9,'0',' ',' ','数据类型'); 
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',' ',' ','说明'); 
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','维度*'); 
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',12,'0',' ',' ','长编码'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'0','1',' ',412102553157804032,1083263542469068800,'id',3,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1','number',412102553157804032,1083263542469071879,'enumitem',16,'0',' ','name',NULL); 
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',13,'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',14,'0','数据格式：作用范围函数（用户类型，用户编码/用户组编码，读写权限）',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'1','1',' ',412102553157804032,1083263542469068806,'shielddim',15,'0','请填写维度简码并用英文逗号(,)分割',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (412102866623307776,'0','1',' ',412102553157804032,1264467311021000711,'sectoryclass',17,'0',' ',' ',NULL); 
