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;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FAPPLYSCOPE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (772300762582738944,'1',772300762582738944,'C','bcm_entitymemberimp_IMPT_S',' ','IMPT',{ts'2018-08-08  18:08:08'},1,'1','0',{ts'2018-08-08  18:08:08'},' ',1,'bcm_entitymemberimp'); 

INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (772300762582738944,'0DV/1ES2QG7G','zh_CN','出厂预置模板','组织导入模板'); 

INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','0',' ',0,772298295803504640,'bcm_entitymemberimp',1,'0',' ',' ','组织-导入'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','0',' ',772298295803504640,772298295811886080,'billhead',2,'0',' ',' ','单据头'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811886081,'name',4,'1',' ',' ','名称*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811886082,'storagetype',6,'1',' ',' ','存储类型*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1','number',772298295811886080,772298295811886083,'ctrlorg',8,'0',' ','name','控股组织'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811886084,'isinnerorg',10,'0',' ',' ','内部往来组织'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811886085,'isindependentorg',12,'0',' ',' ','是否独立法人公司'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811886086,'expdate',14,'0',' ',' ','失效日期'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811886087,'description',16,'0',' ',' ','说明'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1','number',772298295811886080,772298295811886088,'model',18,'1',' ','name','体系*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811886089,'definedpropertyvalue',20,'0',' ',' ','自定义属性值'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811893248,'number',3,'1',' ',' ','编码*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811893249,'simplename',5,'0',' ',' ','简称'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811893250,'aggoprt',7,'0',' ',' ','聚合算法'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1','number',772298295811886080,772298295811893251,'currency',9,'1',' ','name','默认币别'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811893252,'isouterorg',11,'0',' ',' ','外部往来组织'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811893253,'effdate',13,'0',' ',' ','生效日期'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,772298295811893254,'isclearorg',15,'0',' ',' ','是否清算'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1','number',772298295811886080,772298295811893255,'parent',17,'1',' ','name','上级*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1','number',772298295811886080,772298295811893256,'dimension',19,'1',' ','name','维度*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1','number',772298295811886080,873962862454862850,'cslscheme',21,'1',' ','name','组织视图'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (772300762582738944,'1','1',' ',772298295811886080,1039030990351216651,'memberpermissions',22,'0','数据格式：作用范围函数（用户类型，用户编码/用户组编码，读写权限）',' ',NULL); 
