

DELETE FROM t_bas_importtemplate WHERE FID = 1211668235691241472;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FAPPLYSCOPE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1211668235691241472,'1',1211668235691241472,'C','bcm_memberlist_EXPT','维度成员列表引出','EXPT',{ts'2021-07-30  00:00:00'},13466739,'1','0',{ts'2021-08-09  00:00:00'},' ',1189782647094670336,'bcm_memberlistimp'); 

DELETE FROM t_bas_importtemplate_l WHERE FID = 1211668235691241472;
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1211668235691241472,'1SU++P5559NS','zh_CN',' ','维度成员列表引出'); 

DELETE FROM t_bas_importtemplateentry WHERE FID = 1211668235691241472;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1211668235691241472,'0','0',' ',0,1211667975711502336,'bcm_memberlistimp',1,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1211668235691241472,'0','0',' ',1211667975711502336,1211667975761821696,'billhead',2,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1211668235691241472,'0','1',' ',1211667975761821696,1211667975778611200,'id',3,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1211668235691241472,'1','1',' ',1211667975761821696,1211667975786987520,'number',4,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1211668235691241472,'1','1',' ',1211667975761821696,1211667975795388416,'name',5,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1211668235691241472,'1','1',' ',1211667975761821696,1211667975812153344,'isdyn',6,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1211668235691241472,'1','1',' ',1211667975761821696,1211667975820554240,'isenable',7,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1211668235691241472,'1','1',' ',1211667975761821696,1211667975862484992,'creator',12,'0',' ','name',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1211668235691241472,'1','1',' ',1211667975761821696,1211667975870885888,'modifier',13,'0',' ','name',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1211668235691241472,'1','1',' ',1211667975761821696,1211667975879262208,'modifydate',14,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1211668235691241472,'1','1',' ',1211667975761821696,1211667975887663104,'bcmstaticlist',9,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1211668235691241472,'1','1',' ',1211667975761821696,1211667975929593856,'bcmdynamiclist',10,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1211668235691241472,'1','1',' ',1211667975761821696,1213589594444982276,'modelid',11,'0',' ','shownumber',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1211668235691241472,'1','1',' ',1211667975761821696,1213589594444983300,'dimensionid',8,'0',' ','number,name',NULL); 



DELETE FROM t_bas_importtemplate WHERE FID = 1214453469109288960;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FAPPLYSCOPE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1214453469109288960,'1',1214453469109288960,'C','bcm_memberlist_IMPT','维度成员列表引入','IMPT',{ts'2021-08-03  00:00:00'},13466739,'1','0',{ts'2021-08-09  00:00:00'},' ',1189782647094670336,'bcm_memberlistimp'); 

DELETE FROM t_bas_importtemplate_l WHERE FID = 1214453469109288960;
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1214453469109288960,'1T5ADN4IZ9H1','zh_CN',' ','维度成员列表引入'); 

DELETE FROM t_bas_importtemplateentry WHERE FID = 1214453469109288960;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1214453469109288960,'0','0',' ',0,1214452140756447232,'bcm_memberlistimp',1,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1214453469109288960,'0','0',' ',1214452140756447232,1214452140806766592,'billhead',2,'0','成员列表中#号表示行分隔符；| 表示列分隔符',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1214453469109288960,'0','1',' ',1214452140806766592,1214452140815167488,'id',3,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1214453469109288960,'1','1',' ',1214452140806766592,1214452140831932416,'number',4,'1',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1214453469109288960,'1','1',' ',1214452140806766592,1214452140840333312,'name',5,'1',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1214453469109288960,'1','1',' ',1214452140806766592,1214452140848709632,'isdyn',6,'1',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1214453469109288960,'1','1',' ',1214452140806766592,1214452140857110528,'isenable',7,'1',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1214453469109288960,'0','1','number',1214452140806766592,1214452140873875456,'modelid',8,'0',' ','name',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1214453469109288960,'1','1','number',1214452140806766592,1214452140882276352,'dimensionid',9,'1',' ','name',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1214453469109288960,'0','1','number',1214452140806766592,1214452140890652672,'creator',10,'0',' ','number',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1214453469109288960,'0','1','number',1214452140806766592,1214452140907442176,'modifier',11,'0',' ','number',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1214453469109288960,'0','1',' ',1214452140806766592,1214452140915818496,'modifydate',12,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1214453469109288960,'1','1',' ',1214452140806766592,1214452140957773824,'bcmstaticlist',13,'0','成员编码#成员编码',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1214453469109288960,'1','1',' ',1214452140806766592,1214452140966150144,'bcmdynamiclist',14,'0','成员编码|基础成员编码|动态关系编码|公式#成员编码|基础成员编码|动态关系编码|公式',' ',NULL); 
