-- 导入导出模板

DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1002132257529399296;
INSERT INTO T_BAS_IMPORTTEMPLATE(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (1002132257529399296,'1',1002132257529399296,'C','bos_importtemplate_IMPT_S',' ','IMPT',{ts'2020-10-29 18:08:08'},13466739,'1',{ts'2020-10-29 18:08:08'},' ',1,'bos_importtemplate'); 

-- 多语言
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FID = '1002132257529399296';
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1002132257529399296,'14232LL=IK2Z','zh_CN',' ','引入引出模板'); 
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1002132257529399296,'14232LL=IK3+','zh_TW',' ','引入引出模板'); 


-- 分录表，记录模板的详细规则信息
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FID = 1002132257529399296;
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131924694616064,0,'0','0',' ','bos_importtemplate',1,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131924904314880,1002131924694616064,'0','0',' ','billhead',2,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131924929497088,1002131924904314880,'1','1',' ','id',3,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131924954646528,1002131924904314880,'1','1',' ','number',4,'1',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131924979828736,1002131924904314880,'1','1',' ','name',5,'1',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131925013366784,1002131924904314880,'1','1',' ','templatetype',6,'1',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131925030160384,1002131924904314880,'1','1','number','bizobject',7,'1',' ','name');	
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131925055309824,1002131924904314880,'0','1',' ','status',8,'0',' ',' ');		
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131925080492032,1002131924904314880,'0','1','number','creator',9,'0',' ','name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131925097252864,1002131924904314880,'0','1',' ','enable',10,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131925114046464,1002131924904314880,'1','1',' ','comment',11,'0',' ',' ');		
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131925139195904,1002131924904314880,'0','1',' ','enableimport',12,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131925155989504,1002131924904314880,'0','1',' ','temporaryfield',13,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131925181138944,1002131924904314880,'1','1',' ','applyscope',14,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131925197932544,1002131924904314880,'1','1','number','users',15,'0',' ','name');	
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131925248247808,1002131924904314880,'0','1',' ','createtime',16,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131926078720000,1002131924694616064,'0','0',' ','treeentryentity',17,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131926120679424,1002131926078720000,'1','1',' ','treeentryentity.pid',19,'1',' ',' ');		
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131926145828864,1002131926078720000,'1','1',' ','treeentryentity.id',18,'1',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131926238103552,1002131926078720000,'1','1',' ','entitynumber',20,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131926296840192,1002131926078720000,'1','1',' ','ismustinput',21,'0',' ',' ');		
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131926330378240,1002131926078720000,'1','1',' ','isimport',22,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131926355560448,1002131926078720000,'0','1',' ','isfield',23,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131926372321280,1002131926078720000,'1','1',' ','importprop',24,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131926422652928,1002131926078720000,'1','1',' ','exportprop',25,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131926439446528,1002131926078720000,'1','1',' ','entitydescription',26,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131926464595968,1002131926078720000,'0','1',' ','isbasedata',27,'0',' ',' ');			
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID,FENTRYID,FPARENTENTRYID,FISIMPORT,FISFIELD,FIMPORTPROP,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FEXPORTPROP) VALUES (1002132257529399296,1002131926481389568,1002131926078720000,'0','1',' ','controlfield',28,'0',' ',' ');	