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

INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FAPPLYSCOPE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1028785650482145280,'1',1028785650482145280,'C','bcm_audittrialmemberimp_IMPT_S','审计线索引入模板','IMPT',{ts'2020-11-20  00:00:00'},13466739,'1','0',{ts'2021-10-11  00:00:00'},' ',13466739,'bcm_audittrialmemberimp'); 

INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1028785650482145280,'17BT5EISRK5V','zh_CN',' ','审计线索引入模板'); 

INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'0','0',' ',0,1028785354431488000,'bcm_audittrialmemberimp',1,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'1','1','number',1028785354439780352,1028785354439780356,'dimension',10,'1',' ','name',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'1','1','number',1028785354439780352,1028785354439876610,'parent',6,'1',' ','name',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'0','1',' ',1028785354439780352,1028785354439876608,'id',3,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'0','0',' ',1028785354431488000,1028785354439780352,'billhead',2,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'1','1',' ',1028785354439780352,1028785354439780353,'number',4,'1',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'1','1',' ',1028785354439780352,1028785354439876609,'name',5,'1',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'1','1',' ',1028785354439780352,1028785354439780355,'aggoprt',7,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'1','1',' ',1028785354439780352,1028785354439780354,'storagetype',8,'1',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'1','1',' ',1028785354439780352,1028785354439876611,'description',9,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'1','1',' ',1028785354439780352,1028785354439780357,'longnumber',11,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'1','1',' ',1028785354439780352,1028785354439876613,'definedpropertyvalue',12,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'1','1',' ',1028785354439780352,1081969245199272965,'memberpermissions',13,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'1','1',' ',1028785354439780352,1082721283990367237,'datasource',14,'0',' ',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'1','1',' ',1028785354439780352,1082721283990455301,'shielddim',15,'0','请填写维度简码并用英文逗号(,)分割',' ',NULL); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP,FFIELDNAME) VALUES (1028785650482145280,'0','1',' ',1028785354439780352,1264466017162103815,'sectoryclass',16,'0',' ',' ',NULL); 
