delete from sys_noun where NOUNITEM = 'TERM';
insert into sys_noun
select 'TERM', '202412', '默认上季度期次', nounsuper, nounlevel, nounorder, nounmodule, nounvalidity, readonly, nounprop, nounremarks, nounrelation, orgflag from sys_noun a where a.NOUNITEM = 'WORKDATE';


DELETE FROM SYS_NOUN WHERE NOUNITEM = 'CALC_STATE';

INSERT INTO sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG)
VALUES ('CALC_STATE', 'CALC_STATE', '计算任务执行状态', 'BUSDICT', 2.000000000000000000000000000000, 0.000000000000000000000000000000, 'common', '0', '0', null, null, '1', '0');
INSERT INTO sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG)
VALUES ('CALC_STATE', 'READY', '准备中', 'BUSDICT', 3.000000000000000000000000000000, 1.000000000000000000000000000000, 'common', '1', '0', null, null, '1', '0');
INSERT INTO sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG)
VALUES ('CALC_STATE', 'RUNNING', '执行中', 'BUSDICT', 3.000000000000000000000000000000, 2.000000000000000000000000000000, 'common', '1', '0', null, null, '1', '0');
INSERT INTO sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG)
VALUES ('CALC_STATE', 'END', '已完成', 'BUSDICT', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'common', '1', '0', null, null, '1', '0');
INSERT INTO sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG)
VALUES ('CALC_STATE', 'ERROR', '异常', 'BUSDICT', 3.000000000000000000000000000000, 4.000000000000000000000000000000, 'common', '1', '0', null, null, '1', '0');


DELETE FROM sys_funinfo WHERE FUNCCODE IN ('BL100000','BL100001','BL100002','BL100003','BL100004','BL100006');
insert into sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) values ('BL100000', '数据补录', '0', 1.000000000000000000000000000000, '0', 'null', 1.000000000000000000000000000000, null, '4tailbranch', 'null');
insert into sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) values ('BL100001', 'Excel补录模板配置', 'BL100000', 1.000000000000000000000000000000, '1', '/rdp/rdpAnalysis/analTemplate/query/ExcelTmpQueryList', 2.000000000000000000000000000000, null, '4tailbranch', 'null');
insert into sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) values ('BL100002', '数据补录任务管理', 'BL100000', 2.000000000000000000000000000000, '1', '/rdp/rdpAnalysis/analTemplate/query/SupplementTaskQueryList', 2.000000000000000000000000000000, null, '4tailbranch', 'null');
insert into sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) values ('BL100003', '数据补录及审核', 'BL100000', 3.000000000000000000000000000000, '1', '/rdp/rdpAnalysis/analTemplate/query/SupplementTaskReviewList', 2.000000000000000000000000000000, null, '4tailbranch', 'null');
insert into sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) values ('BL100004', '数据补录任务进度查询', 'BL100000', 4.000000000000000000000000000000, '1', '/rdp/rdpAnalysis/analTemplate/query/SupplementPlanQuery', 2.000000000000000000000000000000, null, '4tailbranch', 'null');
insert into sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) values ('BL100006', '补录数据查询', 'BL100000', 6.000000000000000000000000000000, '1', '/rdp/rdpAnalysis/analTemplate/query/SupplementResultQuery', 2.000000000000000000000000000000, null, '4tailbranch', 'null');

-- 删除原有的补录功能配置
delete from sys_funorginfo where FUNCCODE in ('M110000','M110001','M110002','M110003');
DELETE FROM sys_funorginfo WHERE FUNCCODE IN ('BL100000','BL100001','BL100002','BL100003','BL100004','BL100006');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100000', '000000');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100000', '351001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100000', '355001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100000', '355101');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100000', '355102');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100000', '355103');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100000', '355104');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100000', '355105');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100000', '355106');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100001', '000000');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100001', '351001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100001', '355001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100001', '355101');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100001', '355102');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100001', '355103');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100001', '355104');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100001', '355105');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100001', '355106');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100002', '000000');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100002', '351001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100002', '355001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100002', '355101');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100002', '355102');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100002', '355103');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100002', '355104');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100002', '355105');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100002', '355106');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100003', '000000');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100003', '351001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100003', '355001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100003', '355101');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100003', '355102');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100003', '355103');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100003', '355104');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100003', '355105');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100003', '355106');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100004', '000000');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100004', '351001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100004', '355001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100004', '355101');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100004', '355102');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100004', '355103');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100004', '355104');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100004', '355105');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100004', '355106');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100006', '000000');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100006', '351001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100006', '355001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100006', '355101');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100006', '355102');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100006', '355103');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100006', '355104');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100006', '355105');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('BL100006', '355106');

-- 删除原有的补录功能配置
delete from sys_roleright where FUNCCODE in ('M110000','M110001','M110002','M110003');
-- 增加新的数据补录功能配置
delete from sys_roleright where FUNCCODE in ('BL100000','BL100001','BL100002','BL100003','BL100004','BL100006');
INSERT INTO sys_roleright (ROLEID, FUNCCODE, DATASCOPE, BLINE) VALUES ('sysadmin', 'BL100000', null, '0');
INSERT INTO sys_roleright (ROLEID, FUNCCODE, DATASCOPE, BLINE) VALUES ('sysadmin', 'BL100001', null, '0');
INSERT INTO sys_roleright (ROLEID, FUNCCODE, DATASCOPE, BLINE) VALUES ('sysadmin', 'BL100002', null, '0');
INSERT INTO sys_roleright (ROLEID, FUNCCODE, DATASCOPE, BLINE) VALUES ('sysadmin', 'BL100003', null, '0');
INSERT INTO sys_roleright (ROLEID, FUNCCODE, DATASCOPE, BLINE) VALUES ('sysadmin', 'BL100004', null, '0');
INSERT INTO sys_roleright (ROLEID, FUNCCODE, DATASCOPE, BLINE) VALUES ('sysadmin', 'BL100006', null, '0');

-- 监管报表菜单 G4B-2 G4B-5
delete from sys_funinfo where FUNCCODE in ('M150002','M150003');
insert into sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) values ('M150002', '第二档银行：G4B-2表外信用风险加权资产计算表（权重法）', 'M150000', 4.000000000000000000000000000000, '1', '/G4B_2', 2.000000000000000000000000000000, null, '4tailbranch', 'null');
insert into sys_funinfo (FUNCCODE, FUNCNAME, PARENTCODE, ORDERNO, LEAF, URL, LEVELCODE, REMARK, ORGTYPE, TERMINALTYPE) values ('M150003', '第二档银行：G4B-5表外信用风险加权资产计算表（权重法）', 'M150000', 6.000000000000000000000000000000, '1', '/G4B_5', 2.000000000000000000000000000000, null, '4tailbranch', 'null');

delete from sys_funorginfo where FUNCCODE in ('M150002','M150003');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150002', '000000');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150002', '351001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150002', '355001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150002', '355101');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150002', '355102');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150002', '355103');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150002', '355104');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150002', '355105');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150002', '355106');

insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150003', '000000');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150003', '351001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150003', '355001');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150003', '355101');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150003', '355102');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150003', '355103');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150003', '355104');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150003', '355105');
insert into sys_funorginfo (FUNCCODE, ORGCODE) values ('M150003', '355106');

delete from sys_roleright where FUNCCODE in ('M150003','M150002');
INSERT INTO sys_roleright (ROLEID, FUNCCODE, DATASCOPE, BLINE) VALUES ('sysadmin', 'M150003', null, '0');
INSERT INTO sys_roleright (ROLEID, FUNCCODE, DATASCOPE, BLINE) VALUES ('sysadmin', 'M150002', null, '0');


-- 2025-4-1

delete from sys_noun a where a.NOUNITEM  in ('TEMPLATE_TYPE','TEMPLATE_VERIFY_TIME','FREQUENCY','ATTACHFUNCTYPE','taskStatus');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('ATTACHFUNCTYPE', 'ATTACHFUNCTYPE', '附件功能分类', 'SYSDICT', 2.000000000000000000000000000000, 1.000000000000000000000000000000, 'common', '1', '0', null, '用于登记系统中所有使用的附件功能分类，参数属性为附件是否保存到数据库yes/no，默认yes', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('ATTACHFUNCTYPE', 'EXCEL', '补录模板的路径', 'ATTACHFUNCTYPE', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'common', '1', '1', 'no', '用于补录数据的处理', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('ATTACHFUNCTYPE', 'IMPUTSUBTASKRUNNING', '补录任务的路径', 'ATTACHFUNCTYPE', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'common', '1', '1', 'no', '用于补录数据的处理', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('ATTACHFUNCTYPE', 'TMPFILE_ONE', 'Excel补录模板的路径', 'ATTACHFUNCTYPE', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'common', '1', '1', 'no', '用于补录数据的处理', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('ATTACHFUNCTYPE', 'TMPFILE_ZIP', '压缩包的路径', 'ATTACHFUNCTYPE', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'common', '1', '1', 'no', '用于补录数据的处理', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('ATTACHFUNCTYPE', 'importTemplate', '标准导入功能', 'ATTACHFUNCTYPE', 3.000000000000000000000000000000, 1.000000000000000000000000000000, 'common', '1', '1', 'yes', '用于存放每个导入类型的模板及说明文件', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('ATTACHFUNCTYPE', 'messagemanage', '信息管理功能', 'ATTACHFUNCTYPE', 3.000000000000000000000000000000, 2.000000000000000000000000000000, 'common', '1', '1', 'yes', '用于存放每条发布信息的对应文件', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('ATTACHFUNCTYPE', 'reportuploadconfig', '报表模板文件管理', 'ATTACHFUNCTYPE', 3.000000000000000000000000000000, 1.000000000000000000000000000000, 'common', '1', '1', 'no', '用于存放报表信息的对应文件', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('FREQUENCY', '1', '月初', 'FREQUENCY', 3.000000000000000000000000000000, 1.000000000000000000000000000000, null, '1', '0', '', null, '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('FREQUENCY', '2', '季初', 'FREQUENCY', 3.000000000000000000000000000000, 2.000000000000000000000000000000, null, '1', '0', '', null, '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('FREQUENCY', '3', '年初', 'FREQUENCY', 3.000000000000000000000000000000, 3.000000000000000000000000000000, null, '1', '0', null, null, '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('FREQUENCY', '4', '月末', 'FREQUENCY', 3.000000000000000000000000000000, 4.000000000000000000000000000000, null, '1', '0', null, null, '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('FREQUENCY', '5', '季末', 'FREQUENCY', 3.000000000000000000000000000000, 5.000000000000000000000000000000, null, '1', '0', null, null, '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('FREQUENCY', '6', '年末', 'FREQUENCY', 3.000000000000000000000000000000, 6.000000000000000000000000000000, null, '1', '0', null, null, '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('FREQUENCY', 'FREQUENCY', '补录频率', 'BUSDICT', 2.000000000000000000000000000000, 0.000000000000000000000000000000, null, '0', '0', null, null, '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('TEMPLATE_TYPE', 'FIXED_COLUMN', '固定列', 'TEMPLATE_TYPE', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'common', '1', '0', null, null, '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('TEMPLATE_TYPE', 'FIXED_ROW', '固定行', 'TEMPLATE_TYPE', 3.000000000000000000000000000000, 2.000000000000000000000000000000, 'common', '1', '0', null, null, '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('TEMPLATE_TYPE', 'FIXED_ROW_COLUMN', '固定行列', 'TEMPLATE_TYPE', 3.000000000000000000000000000000, 1.000000000000000000000000000000, 'common', '1', '0', null, null, '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('TEMPLATE_TYPE', 'TEMPLATE_TYPE', '模板类型', 'BUSDICT', 2.000000000000000000000000000000, 0.000000000000000000000000000000, 'common', '0', '0', null, null, '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('TEMPLATE_VERIFY_TIME', 'AFTER_IMPORT', '导入后', 'TEMPLATE_VERIFY_TIME', 3.000000000000000000000000000000, 2.000000000000000000000000000000, 'common', '1', '0', null, null, '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('TEMPLATE_VERIFY_TIME', 'BEFORE_EXPORT', '导出前', 'TEMPLATE_VERIFY_TIME', 3.000000000000000000000000000000, 1.000000000000000000000000000000, 'common', '1', '0', null, null, '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('TEMPLATE_VERIFY_TIME', 'NOT_VERIFY', '不验证', 'TEMPLATE_VERIFY_TIME', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'common', '1', '0', null, null, '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('TEMPLATE_VERIFY_TIME', 'TEMPLATE_VERIFY_TIME', '模板验证时点', 'BUSDICT', 2.000000000000000000000000000000, 0.000000000000000000000000000000, 'common', '0', '0', null, null, '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('taskStatus', '01', '未补录', 'taskStatus', 3.000000000000000000000000000000, 1.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('taskStatus', '02', '补录中', 'taskStatus', 3.000000000000000000000000000000, 2.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('taskStatus', '03', '审核中', 'taskStatus', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('taskStatus', '04', '已审核', 'taskStatus', 3.000000000000000000000000000000, 4.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('taskStatus', '05', '审核退回', 'taskStatus', 3.000000000000000000000000000000, 5.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('taskStatus', 'taskStatus', '数据补录审核状态', 'SYSDICT', 2.000000000000000000000000000000, 0.000000000000000000000000000000, 'common', '0', '0', 'null', 'null', '1', '0');


delete from sys_noun a where a.NOUNITEM in ('tmptype','tmpverrowcoltype');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('tmptype', 'FixedAll', '固定行列', 'tmptype', 3.000000000000000000000000000000, 1.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('tmptype', 'FixedCol', '固定列', 'tmptype', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('tmptype', 'FixedRow', '固定行', 'tmptype', 3.000000000000000000000000000000, 2.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('tmptype', 'tmptype', '模板类型', 'BUSDICT', 2.000000000000000000000000000000, 0.000000000000000000000000000000, 'common', '0', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('tmpverrowcoltype', 'AnyCol', '任意列', 'tmpverrowcoltype', 3.000000000000000000000000000000, 1.000000000000000000000000000000, 'null', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('tmpverrowcoltype', 'AnyRow', '任意行', 'tmpverrowcoltype', 3.000000000000000000000000000000, 2.000000000000000000000000000000, 'null', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('tmpverrowcoltype', 'Cell', '单元格', 'tmpverrowcoltype', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'null', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('tmpverrowcoltype', 'Region', '区域', 'tmpverrowcoltype', 3.000000000000000000000000000000, 4.000000000000000000000000000000, 'null', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('tmpverrowcoltype', 'TitleRow', '标题行', 'tmpverrowcoltype', 3.000000000000000000000000000000, 5.000000000000000000000000000000, 'null', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('tmpverrowcoltype', 'tmpverrowcoltype', '行列类型', 'BUSDICT', 2.000000000000000000000000000000, 0.000000000000000000000000000000, 'null', '0', '0', 'null', 'null', '1', '0');



delete from sys_noun a where a.NOUNITEM in ('frequencm','frequencr','frequency','frequencv','checktype','exceedtype');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('checktype', '1', '数据类型', 'checktype', 3.000000000000000000000000000000, 1.000000000000000000000000000000, 'null', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('checktype', 'checktype', '约束方式', 'BUSDICT', 2.000000000000000000000000000000, 0.000000000000000000000000000000, 'null', '0', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('exceedtype', '1', '抛出异常', 'exceedtype', 3.000000000000000000000000000000, 1.000000000000000000000000000000, 'null', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('exceedtype', '2', '截断处理', 'exceedtype', 3.000000000000000000000000000000, 2.000000000000000000000000000000, 'null', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('exceedtype', '3', '忽略跳过', 'exceedtype', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'null', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('exceedtype', 'exceedtype', '越界处理方式', 'BUSDICT', 2.000000000000000000000000000000, 0.000000000000000000000000000000, 'null', '0', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequencm', 'FixedAll', '固定行列', 'frequencm', 3.000000000000000000000000000000, 1.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequencm', 'FixedCol', '固定列', 'frequencm', 3.000000000000000000000000000000, 2.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequencm', 'FixedRow', '固定行', 'frequencm', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequencm', 'frequencm', '模板类型', 'BUSDICT', 2.000000000000000000000000000000, 0.000000000000000000000000000000, 'common', '0', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequencr', 'AnyCol', '任意列', 'frequencr', 3.000000000000000000000000000000, 1.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequencr', 'AnyRow', '任意行', 'frequencr', 3.000000000000000000000000000000, 2.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequencr', 'Cell', '单元格', 'frequencr', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequencr', 'Region', '区域', 'frequencr', 3.000000000000000000000000000000, 4.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequencr', 'TitleRow', '标题行', 'frequencr', 3.000000000000000000000000000000, 5.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequencr', 'frequencr', '行列类型', 'BUSDICT', 2.000000000000000000000000000000, 0.000000000000000000000000000000, 'common', '0', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequencv', '1', '导出前', 'frequencv', 3.000000000000000000000000000000, 1.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequencv', '2', '导入后', 'frequencv', 3.000000000000000000000000000000, 2.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequencv', '3', '不验证', 'frequencv', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'common', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequencv', 'frequencv', '模板验证时点', 'BUSDICT', 2.000000000000000000000000000000, 0.000000000000000000000000000000, 'common', '0', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequency', '1', '月初', 'frequency', 3.000000000000000000000000000000, 1.000000000000000000000000000000, 'null', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequency', '2', '季初', 'frequency', 3.000000000000000000000000000000, 2.000000000000000000000000000000, 'null', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequency', '3', '年初', 'frequency', 3.000000000000000000000000000000, 3.000000000000000000000000000000, 'null', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequency', '4', '月末', 'frequency', 3.000000000000000000000000000000, 4.000000000000000000000000000000, 'null', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequency', '5', '季末', 'frequency', 3.000000000000000000000000000000, 5.000000000000000000000000000000, 'null', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequency', '6', '年末', 'frequency', 3.000000000000000000000000000000, 6.000000000000000000000000000000, 'null', '1', '0', 'null', 'null', '1', '0');
insert into sys_noun (NOUNITEM, NOUNVALUE, NOUNNAME, NOUNSUPER, NOUNLEVEL, NOUNORDER, NOUNMODULE, NOUNVALIDITY, READONLY, NOUNPROP, NOUNREMARKS, NOUNRELATION, ORGFLAG) values ('frequency', 'frequency', '补录频率', 'BUSDICT', 2.000000000000000000000000000000, 0.000000000000000000000000000000, 'null', '0', '0', 'null', 'null', '1', '0');
