DELETE FROM t_bas_importtemplate WHERE FID = 850449642465360896;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (850449642465360896,'1',850449642465360896,'C','bcm_linkagemapping_IMPT_S',' ','IMPT',{ts'2020-03-19  09:30:47'},13466739,'1',{ts'2020-05-23  17:37:35'},' ',13466739,'bcm_linkagemapping'); 

DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0NFDV+=JXGTG';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (850449642465360896,'0NFDV+=JXGTG','zh_CN',' ','联动映射导入'); 

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366194960384;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'0','0',' ',0,850449366194960384,'bcm_linkagemapping',1,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366228499456;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','0',' ',850449366194960384,850449366228499456,'billhead',2,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366245292032;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1','number',850449366228499456,850449366245292032,'model',4,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366262053888;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1','number',850449366228499456,850449366262053888,'scenario',5,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366278846464;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366228499456,850449366278846464,'number',6,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366287219712;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366228499456,850449366287219712,'name',7,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366304012288;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366228499456,850449366304012288,'description',8,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366312385536;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366228499456,850449366312385536,'status',9,'0','非必填，系统默认为“禁用”',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366320789504;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366228499456,850449366320789504,'dimtxt',10,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366471769088;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','0',' ',850449366194960384,850449366471769088,'entryentity',11,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366505338880;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366505338880,'groupnum',13,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366513712128;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366513712128,'groupname',14,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366530504704;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366530504704,'operator',15,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366538877952;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1','number',850449366471769088,850449366538877952,'account',16,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366555670528;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366555670528,'linkagetype',17,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366564043776;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366564043776,'weight',18,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366572447744;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1','number',850449366471769088,850449366572447744,'template',19,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366589209600;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1','number',850449366471769088,850449366589209600,'changetype',20,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366597613568;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1','number',850449366471769088,850449366597613568,'mycompany',21,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366605986816;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1','number',850449366471769088,850449366605986816,'intercompany',22,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366614390784;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1','number',850449366471769088,850449366614390784,'userdefined1',23,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366622764032;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1','number',850449366471769088,850449366622764032,'userdefined2',24,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366631168000;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1','number',850449366471769088,850449366631168000,'userdefined3',25,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366639541248;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1','number',850449366471769088,850449366639541248,'userdefined4',26,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366656333824;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1','number',850449366471769088,850449366656333824,'userdefined5',27,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366664707072;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1','number',850449366471769088,850449366664707072,'userdefined6',28,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366673111040;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366673111040,'dimshow',29,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366689872896;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366689872896,'accountrange',30,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366698276864;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366698276864,'changetyperange',31,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366715038720;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366715038720,'mycompanyrange',32,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366723442688;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366723442688,'intercompanyrange',33,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366731815936;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366731815936,'userdefinedrange1',34,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366740219904;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366740219904,'userdefinedrange2',35,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366756981760;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366756981760,'userdefinedrange3',36,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366765385728;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366765385728,'userdefinedrange4',37,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366773758976;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366773758976,'userdefinedrange5',38,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449366782162944;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449366471769088,850449366782162944,'userdefinedrange6',39,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449367117691904;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'0','0',' ',850449366194960384,850449367117691904,'memberrange',40,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449367134484480;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'0','1',' ',850449367117691904,850449367134484480,'memberid',42,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449367142857728;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'0','1',' ',850449367117691904,850449367142857728,'membbound',43,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449367159650304;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'0','1','number',850449367117691904,850449367159650304,'dimension',44,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449367168023552;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'0','1','number',850449367117691904,850449367168023552,'propertyid',45,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449367184816128;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'0','1',' ',850449367117691904,850449367184816128,'limittype',46,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449367277075456;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','0',' ',850449366194960384,850449367277075456,'effective',47,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449367293868032;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1','number',850449367277075456,850449367293868032,'effectiveyear',49,'0','如需设置有效财年，此处编码必填','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449367302241280;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1','number',850449367277075456,850449367302241280,'effectiveperiod',50,'0','如需设置有效期间，此处编码必填','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 850449367319033856;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449367277075456,850449367319033856,'applytype',51,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 889774166574757888;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'0','1',' ',850449366228499456,889774166574757888,'id',3,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 889774166583144448;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'0','1',' ',850449366471769088,889774166583144448,'entryentity.id',12,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 889774166599923712;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'0','1',' ',850449367117691904,889774166599923712,'memberrange.id',41,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 889774166599921668;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'0','1',' ',850449367277075456,889774166599921668,'effective.id',48,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 889774166599921670;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (850449642465360896,'1','1',' ',850449367277075456,889774166599921670,'yearscope',52,'0',' ',' ',NULL); 

DELETE FROM t_bas_importtemplate WHERE FID = 839561300785853440;
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (839561300785853440,'1',839561300785853440,'C','bcm_linkagemapping_EXPT_S',' ','EXPT',{ts'2020-03-04  08:55:36'},357314926525546533,'1',{ts'2020-05-13  14:48:35'},' ',13466739,'bcm_linkagemapping'); 

DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0M38DU2VFVN5';
INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (839561300785853440,'0M38DU2VFVN5','zh_CN',' ','联动映射导出'); 

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 890467269136700416;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'0','1',' ',839604396940673024,890467269136700416,'id',3,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 890467269145086976;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'0','1',' ',839604396949061632,890467269145086976,'entryentity.id',12,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 890467269153477632;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'0','1',' ',839604396957450240,890467269153477632,'memberrange.id',41,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 890467269153475588;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'0','1',' ',839604396957450243,890467269153475588,'effective.id',48,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 890467269153475590;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'0','1',' ',839604396957450243,890467269153475590,'yearscope',52,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396923921408;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'0','0',' ',0,839604396923921408,'bcm_linkagemapping',1,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396940673024;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','0',' ',839604396923921408,839604396940673024,'billhead',2,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396940698624;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1','number',839604396940673024,839604396940698624,'model',4,'1',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396940673025;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1','number',839604396940673024,839604396940673025,'scenario',5,'1',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396940698625;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396940673024,839604396940698625,'number',6,'1',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396940673026;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396940673024,839604396940673026,'name',7,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396940698626;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396940673024,839604396940698626,'description',8,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396940673027;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396940673024,839604396940673027,'status',9,'0','非必填，系统默认为“禁用”',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396940698627;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396940673024,839604396940698627,'dimtxt',10,'1',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949061632;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','0',' ',839604396923921408,839604396949061632,'entryentity',11,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949087232;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949087232,'groupnum',13,'1',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949061633;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949061633,'groupname',14,'1',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949087233;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949087233,'operator',15,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949061634;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1','number',839604396949061632,839604396949061634,'account',16,'1',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949087234;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949087234,'linkagetype',17,'1',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949061635;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949061635,'weight',18,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949087235;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1','number',839604396949061632,839604396949087235,'template',19,'1',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949061636;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1','number',839604396949061632,839604396949061636,'changetype',20,'1',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949087236;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1','number',839604396949061632,839604396949087236,'mycompany',21,'1',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949061637;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1','number',839604396949061632,839604396949061637,'intercompany',22,'1',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949087237;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1','number',839604396949061632,839604396949087237,'userdefined1',23,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949061638;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1','number',839604396949061632,839604396949061638,'userdefined2',24,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949087238;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1','number',839604396949061632,839604396949087238,'userdefined3',25,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949061639;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1','number',839604396949061632,839604396949061639,'userdefined4',26,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949087239;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1','number',839604396949061632,839604396949087239,'userdefined5',27,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949061640;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1','number',839604396949061632,839604396949061640,'userdefined6',28,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949087240;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949087240,'dimshow',29,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949061641;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949061641,'accountrange',30,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949087241;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949087241,'changetyperange',31,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949061642;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949061642,'mycompanyrange',32,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949087242;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949087242,'intercompanyrange',33,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949061643;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949061643,'userdefinedrange1',34,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949087243;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949087243,'userdefinedrange2',35,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949061644;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949061644,'userdefinedrange3',36,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949087244;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949087244,'userdefinedrange4',37,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949061645;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949061645,'userdefinedrange5',38,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396949087245;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396949061632,839604396949087245,'userdefinedrange6',39,'0','10：仅自己 90：所有下级_仅明细成员',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396957450240;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'0','0',' ',839604396923921408,839604396957450240,'memberrange',40,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396957475840;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'0','1',' ',839604396957450240,839604396957475840,'memberid',42,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396957450241;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'0','1',' ',839604396957450240,839604396957450241,'membbound',43,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396957475841;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'0','1','number',839604396957450240,839604396957475841,'dimension',44,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396957450242;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'0','1','number',839604396957450240,839604396957450242,'propertyid',45,'0',' ','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396957475842;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'0','1',' ',839604396957450240,839604396957475842,'limittype',46,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396957450243;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','0',' ',839604396923921408,839604396957450243,'effective',47,'0',' ',' ',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396957475843;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1','number',839604396957450243,839604396957475843,'effectiveyear',49,'0','如需设置有效财年，此处编码必填','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396957450244;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1','number',839604396957450243,839604396957450244,'effectiveperiod',50,'0','如需设置有效期间，此处编码必填','name',NULL); 
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 839604396957475844;
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (839561300785853440,'1','1',' ',839604396957450243,839604396957475844,'applytype',51,'0',' ',' ',NULL); 
