--删除报表模板导入模板
DELETE FROM t_bas_importtemplate WHERE FID = 772159924254833664;

DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0DUAR4M+XUAS';
DELETE FROM t_bas_importtemplate_l WHERE FPKID = '0DUAR4M+XUAT';

DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509723362304;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899541504;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899523072;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899541505;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899523073;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899541506;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899523074;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899541507;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899523075;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899541508;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899523076;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899541509;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899523077;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899541510;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899523078;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899541511;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899523079;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899541512;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899523080;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899541513;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899523081;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899541514;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899523082;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509899541515;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907911680;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907930112;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907911681;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907930113;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907911682;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907930114;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907911683;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907930115;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907911684;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907930116;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907911685;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907930117;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907911686;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907930118;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907911687;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907930119;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907911688;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907930120;
DELETE FROM t_bas_importtemplateentry WHERE FENTRYID = 772159509907911689;

--预置报表模板导入模板
INSERT INTO t_bas_importtemplate(FID,FENABLEIMPORT,FMASTERID,FSTATUS,FNUMBER,FNAME,FTEMPLATETYPE,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCOMMENT,FCREATORID,FBIZOBJECT) VALUES (772159924254833664,'1',772159924254833664,'C','bcm_templateentity_IMPT_S',' ','IMPT',{ts'2019-12-02  09:03:06'},13466739,'1',{ts'2019-12-02  09:03:56'},' ',13466739,'bcm_templateentity'); 

INSERT INTO t_bas_importtemplate_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (772159924254833664,'0DUAR4M+XUAS','zh_CN',' ','报表模板导入导出'); 

INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','0',' ',0,' ',772159509723362304,'bcm_templateentity',1,'0',' ','报表模板'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','0',' ',772159509723362304,' ',772159509899541504,'billhead',2,'0',' ','单据头'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899523072,'number',3,'1',' ','编码*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899541505,'name',4,'1',' ','名称*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1','number',772159509899541504,'name',772159509899523073,'templatecatalog',5,'0',' ','分类'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899541506,'usage',6,'1',' ','用途*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899523074,'dataunit',7,'0',' ','金额单位*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899541507,'isonlyread',8,'0',' ','整表只读'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899523075,'isshowdescription',9,'0',' ','是否自动提示'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1','number',772159509899541504,'name',772159509899541508,'createorg',10,'0',' ','创建组织'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899523076,'createtime',11,'0',' ','创建日期'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1','number',772159509899541504,'name',772159509899541509,'model',12,'0',' ','体系'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899523077,'spreadjson',13,'0',' ','spreadJson内容'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899541510,'data',14,'0',' ','设计期模型对象'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899523078,'rptdata',15,'0',' ','报表编制期模型对象'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899541511,'rptspreadjson',16,'0',' ','报表编制期spreadjson'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899523079,'versionnumber',17,'0',' ','版本号'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899541512,'versionstatus',18,'0',' ','版本'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899523080,'group',19,'0',' ','模板组'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899541513,'isfintemplate',20,'1',' ','是否非财务信息*'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899523081,'templatetype',21,'0',' ','模板类型'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899541504,' ',772159509899541514,'description',22,'0',' ',' '); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','0',' ',772159509723362304,' ',772159509899523082,'viewpointmembentry',23,'0',' ','视点维维度成员列表'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509899523082,' ',772159509899541515,'viewmembid',24,'0',' ','成员'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1','number',772159509899523082,'name',772159509907911680,'viewdimension',25,'0',' ','维度'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','0',' ',772159509723362304,' ',772159509907930112,'pagemembentry',26,'0',' ','页面维列表'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509907930112,' ',772159509907911681,'pagemembid',27,'0',' ','成员'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1','number',772159509907930112,'name',772159509907930113,'pagedimension',28,'0',' ','维度'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509907930112,' ',772159509907911682,'membbound',29,'0',' ','成员范围'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','0',' ',772159509723362304,' ',772159509907930114,'areapositionentry',30,'0',' ','区域范围列表'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509907930114,' ',772159509907911683,'arearange',31,'0',' ','区域范围'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509907930114,' ',772159509907930115,'startposition',32,'0',' ','开始位置'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','0',' ',772159509907930114,' ',772159509907911684,'colmembdetail',33,'0',' ','列维成员列表'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509907911684,' ',772159509907930116,'colmembid',34,'0',' ','成员'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1','number',772159509907911684,'name',772159509907911685,'coldimension',35,'0',' ','维度'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','0',' ',772159509907930114,' ',772159509907930117,'rowmembdetail',36,'0',' ','行维成员列表'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509907930117,' ',772159509907911686,'rowmembid',37,'0',' ','成员'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1','number',772159509907930117,'name',772159509907930118,'rowdimension',38,'0',' ','维度'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','0',' ',772159509723362304,' ',772159509907911687,'pagepropentry',39,'0',' ','属性明细'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1','number',772159509907911687,'name',772159509907930119,'pagepropdim',40,'0',' ','维度'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1','number',772159509907911687,'name',772159509907911688,'property',41,'0',' ','自定义属性分类'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1','number',772159509907911687,'name',772159509907930120,'membprop',42,'0',' ','成员属性'); 
INSERT INTO t_bas_importtemplateentry(FID,FISIMPORT,FISFIELD,FIMPORTPROP,FPARENTENTRYID,FEXPORTPROP,FENTRYID,FFIELDKEY,FSEQ,FMUSTINPUT,FDESCRIPTION,FFIELDNAME) VALUES (772159924254833664,'1','1',' ',772159509907911687,' ',772159509907911689,'propbound',43,'0',' ','属性范围'); 

