DELETE FROM t_bas_importtemplate WHERE FID = 874520621034329088;
DELETE FROM t_bas_importtemplate_l WHERE FID = 874520621034329088;
DELETE FROM t_bas_importtemplateentry WHERE FID = 874520621034329088;

INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FAPPLYSCOPE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (874520621034329088,'1',874520621034329088,'C','bcm_currencymemberimp_IMPT_S','币别导入模板','IMPT',{ts'2020-04-21  00:00:00'},13466739,'1','0',{ts'2021-10-11  00:00:00'},' ',13466739,'bcm_currencymemberimp'); 

INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (874520621034329088,'0QDQDT44VRRN','zh_CN',' ','币别导入模板'); 

INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (874520621034329088,'0','0',' ',0,874520440444376064,'bcm_currencymemberimp',1,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (874520621034329088,'0','1','number',874520440452760576,874520440452760579,'model',6,'0',' ','name',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (874520621034329088,'1','1','number',874520440452760576,874520440452764674,'dimension',7,'1',' ','name',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (874520621034329088,'0','0',' ',874520440444376064,874520440452760576,'billhead',2,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (874520621034329088,'0','1',' ',874520440452760576,878180213031350272,'id',3,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (874520621034329088,'1','1',' ',874520440452760576,874520440452764672,'number',4,'1',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (874520621034329088,'1','1',' ',874520440452760576,874520440452760577,'name',5,'1',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (874520621034329088,'1','1',' ',874520440452760576,874520440452764673,'storagetype',8,'1',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (874520621034329088,'1','1',' ',874520440452760576,874520440452760578,'aggoprt',9,'1',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (874520621034329088,'1','1',' ',874520440452760576,874520440452764675,'description',10,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (874520621034329088,'1','1',' ',874520440452760576,874520440452760580,'definedpropertyvalue',11,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (874520621034329088,'1','1',' ',874520440452760576,1084151752896282629,'memberpermissions',12,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (874520621034329088,'1','1',' ',874520440452760576,1264462658363460614,'shielddim',13,'0','请填写维度简码并用英文逗号(,)分割',' ',NULL); 
