INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.021', 't_r_g06b_1', '[A列]{期初余额}[8]{净资本}=[2]{净资产}-[3.3]{应收账款合计}-[4.3]{其他资产合计}-[5]{或有负债}-[6.3]{国务院银行业监督管理机构认定的其他调减项目合计}', '[A列]{期初余额}[8]{净资本}=[2]{净资产}-[3.3]{应收账款合计}-[4.3]{其他资产合计}-[5]{或有负债}-[6.3]{国务院银行业监督管理机构认定的其他调减项目合计}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE in(\'8\'), T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in(\'2\'), T.V, 0))-SUM(IF(T.ITEM_CODE in (\'33\',\'43\',\'5\',\'63\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'BEG_BAL\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE in(\'8\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in(\'2\'), T.V, 0))-SUM(IF(T.ITEM_CODE in (\'33\',\'43\',\'5\',\'63\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE in(\'8\'), T.V, 0)) -\r\n (SUM(IF(T.ITEM_CODE in(\'2\'), T.V, 0))-SUM(IF(T.ITEM_CODE in (\'33\',\'43\',\'5\',\'63\'), T.V, 0)))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n BEG_BAL AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'8\',\'2\',\'33\',\'43\',\'5\',\'63\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.022', 't_r_g06b_1', '[B列]{期末余额}[8]{净资本}=[2]{净资产}-[3.3]{应收账款合计}-[4.3]{其他资产合计}-[5]{或有负债}-[6.3]{国务院银行业监督管理机构认定的其他调减项目合计}', '[B列]{期末余额}[8]{净资本}=[2]{净资产}-[3.3]{应收账款合计}-[4.3]{其他资产合计}-[5]{或有负债}-[6.3]{国务院银行业监督管理机构认定的其他调减项目合计}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE in(\'8\'), T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in(\'2\'), T.V, 0))-SUM(IF(T.ITEM_CODE in (\'33\',\'43\',\'5\',\'63\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE in(\'8\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in(\'2\'), T.V, 0))-SUM(IF(T.ITEM_CODE in (\'33\',\'43\',\'5\',\'63\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE in(\'8\'), T.V, 0)) -\r\n (SUM(IF(T.ITEM_CODE in(\'2\'), T.V, 0))-SUM(IF(T.ITEM_CODE in (\'33\',\'43\',\'5\',\'63\'), T.V, 0)))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'8\',\'2\',\'33\',\'43\',\'5\',\'63\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.023', 't_r_g06b_1', '[D列]{应计算金额期初金额}[8]{净资本}=[2]{净资产}-[3.3]{应收账款合计}-[4.3]{其他资产合计}-[5]{或有负债}-[6.3]{国务院银行业监督管理机构认定的其他调减项目合计}', '[D列]{应计算金额期初金额}[8]{净资本}=[2]{净资产}-[3.3]{应收账款合计}-[4.3]{其他资产合计}-[5]{或有负债}-[6.3]{国务院银行业监督管理机构认定的其他调减项目合计}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE in(\'8\'), T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in(\'2\'), T.V, 0))-SUM(IF(T.ITEM_CODE in (\'33\',\'43\',\'5\',\'63\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_BEG_BAL\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE in(\'8\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in(\'2\'), T.V, 0))-SUM(IF(T.ITEM_CODE in (\'33\',\'43\',\'5\',\'63\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE in(\'8\'), T.V, 0)) -\r\n (SUM(IF(T.ITEM_CODE in(\'2\'), T.V, 0))-SUM(IF(T.ITEM_CODE in (\'33\',\'43\',\'5\',\'63\'), T.V, 0)))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_BEG_BAL AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'8\',\'2\',\'33\',\'43\',\'5\',\'63\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.024', 't_r_g06b_1', '[E列]{应计算金额期末金额}[8]{净资本}=[2]{净资产}-[3.3]{应收账款合计}-[4.3]{其他资产合计}-[5]{或有负债}-[6.3]{国务院银行业监督管理机构认定的其他调减项目合计}', '[E列]{应计算金额期末金额}[8]{净资本}=[2]{净资产}-[3.3]{应收账款合计}-[4.3]{其他资产合计}-[5]{或有负债}-[6.3]{国务院银行业监督管理机构认定的其他调减项目合计}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE in(\'8\'), T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in(\'2\'), T.V, 0))-SUM(IF(T.ITEM_CODE in (\'33\',\'43\',\'5\',\'63\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_END_BAL\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE in(\'8\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in(\'2\'), T.V, 0))-SUM(IF(T.ITEM_CODE in (\'33\',\'43\',\'5\',\'63\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE in(\'8\'), T.V, 0)) -\r\n (SUM(IF(T.ITEM_CODE in(\'2\'), T.V, 0))-SUM(IF(T.ITEM_CODE in (\'33\',\'43\',\'5\',\'63\'), T.V, 0)))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_END_BAL AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'8\',\'2\',\'33\',\'43\',\'5\',\'63\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.025', 't_r_g06b_1', '对于1.注册资本：[D]{应计算金额期初金额}=[A]{期初金额}', '对于1.注册资本：[D]{应计算金额期初金额}=[A]{期初金额}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VD,0) = IFNULL(VA,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_BEG_BAL,BEG_BAL\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VD,0) AS VALUE1,\r\n IFNULL(VA,0) AS VALUE2,\r\n ABS(IFNULL(VD,0) - IFNULL(VA,0)) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_BEG_BAL AS VD, BEG_BAL AS VA, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.026', 't_r_g06b_1', '对于2.净资产：[D]{应计算金额期初金额}=[A]{期初金额}', '对于2.净资产：[D]{应计算金额期初金额}=[A]{期初金额}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VD,0) = IFNULL(VA,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_BEG_BAL,BEG_BAL\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VD,0) AS VALUE1,\r\n IFNULL(VA,0) AS VALUE2,\r\n ABS(IFNULL(VD,0) - IFNULL(VA,0)) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_BEG_BAL AS VD, BEG_BAL AS VA, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'2\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.027', 't_r_g06b_1', '对于1.注册资本：[E]{应计算金额期末金额}=[B]{期末金额}', '对于1.注册资本：[E]{应计算金额期末金额}=[B]{期末金额}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VE,0) = IFNULL(VB,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_END_BAL,END_BAL\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VE,0) AS VALUE1,\r\n IFNULL(VB,0) AS VALUE2,\r\n ABS(IFNULL(VE,0) - IFNULL(VB,0)) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_END_BAL AS VE, END_BAL AS VB, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.028', 't_r_g06b_1', '对于2.净资产：[E]{应计算金额期末金额}=[B]{期末金额}', '对于2.净资产：[E]{应计算金额期末金额}=[B]{期末金额}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VE,0) = IFNULL(VB,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_END_BAL,END_BAL\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VE,0) AS VALUE1,\r\n IFNULL(VB,0) AS VALUE2,\r\n ABS(IFNULL(VE,0) - IFNULL(VB,0)) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_END_BAL AS VE, END_BAL AS VB, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'2\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.029', 't_r_g06b_1', '对于3.1.1应收非关联方款项-账龄1个月至3个月（含）：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', '对于3.1.1应收非关联方款项-账龄1个月至3个月（含）：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VD,0) = IFNULL(VA,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_BEG_BAL,BEG_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VD,0)AS VALUE1,\r\n IFNULL(VA,0) *IFNULL(VC,0) AS VALUE2,\r\n ABS(IFNULL(VD,0) - IFNULL(VA,0) *IFNULL(VC,0)) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_BEG_BAL AS VD, BEG_BAL AS VA, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'311\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.030', 't_r_g06b_1', '对于3.1.2应收非关联方款项-账龄3个月至6个月（含）：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', '对于3.1.2应收非关联方款项-账龄3个月至6个月（含）：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VD,0) = IFNULL(VA,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_BEG_BAL,BEG_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VD,0)AS VALUE1,\r\n IFNULL(VA,0) *IFNULL(VC,0) AS VALUE2,\r\n ABS(IFNULL(VD,0) - IFNULL(VA,0) *IFNULL(VC,0)) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_BEG_BAL AS VD, BEG_BAL AS VA, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'312\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.031', 't_r_g06b_1', '对于3.1.3应收非关联方款项-账龄6个月至1年（含）：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', '对于3.1.3应收非关联方款项-账龄6个月至1年（含）：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VD,0) = IFNULL(VA,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_BEG_BAL,BEG_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VD,0)AS VALUE1,\r\n IFNULL(VA,0) *IFNULL(VC,0) AS VALUE2,\r\n ABS(IFNULL(VD,0) - IFNULL(VA,0) *IFNULL(VC,0)) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_BEG_BAL AS VD, BEG_BAL AS VA, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'313\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.032', 't_r_g06b_1', '对于3.1.4应收非关联方款项-账龄1年以上：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', '对于3.1.4应收非关联方款项-账龄1年以上：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VD,0) = IFNULL(VA,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_BEG_BAL,BEG_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VD,0)AS VALUE1,\r\n IFNULL(VA,0) *IFNULL(VC,0) AS VALUE2,\r\n ABS(IFNULL(VD,0) - IFNULL(VA,0) *IFNULL(VC,0)) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_BEG_BAL AS VD, BEG_BAL AS VA, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'314\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.033', 't_r_g06b_1', '对于3.2应收关联方款项：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', '对于3.2应收关联方款项：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VD,0) = IFNULL(VA,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_BEG_BAL,BEG_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VD,0)AS VALUE1,\r\n IFNULL(VA,0) *IFNULL(VC,0) AS VALUE2,\r\n ABS(IFNULL(VD,0) - IFNULL(VA,0) *IFNULL(VC,0)) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_BEG_BAL AS VD, BEG_BAL AS VA, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'32\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.034', 't_r_g06b_1', '对于4.1固定资产：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', '对于4.1固定资产：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VD,0) = IFNULL(VA,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_BEG_BAL,BEG_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VD,0)AS VALUE1,\r\n IFNULL(VA,0) *IFNULL(VC,0) AS VALUE2,\r\n ABS(IFNULL(VD,0) - IFNULL(VA,0) *IFNULL(VC,0)) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_BEG_BAL AS VD, BEG_BAL AS VA, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'41\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.035', 't_r_g06b_1', '对于4.2其他资产-其他：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', '对于4.2其他资产-其他：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VD,0) = IFNULL(VA,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_BEG_BAL,BEG_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VD,0)AS VALUE1,\r\n IFNULL(VA,0) *IFNULL(VC,0) AS VALUE2,\r\n ABS(IFNULL(VD,0) - IFNULL(VA,0) *IFNULL(VC,0)) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_BEG_BAL AS VD, BEG_BAL AS VA, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'42\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.036', 't_r_g06b_1', '对于5.或有负债：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', '对于5.或有负债：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VD,0) = IFNULL(VA,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_BEG_BAL,BEG_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VD,0)AS VALUE1,\r\n IFNULL(VA,0) *IFNULL(VC,0) AS VALUE2,\r\n ABS(IFNULL(VD,0) - IFNULL(VA,0) *IFNULL(VC,0)) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_BEG_BAL AS VD, BEG_BAL AS VA, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'5\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.037', 't_r_g06b_1', '对于6.1所有权受限等无法变现的资产（如被冻结）：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', '对于6.1所有权受限等无法变现的资产（如被冻结）：[D]{应计算金额期初金额}=[A]{期初金额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VD,0) = IFNULL(VA,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_BEG_BAL,BEG_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VD,0)AS VALUE1,\r\n IFNULL(VA,0) *IFNULL(VC,0) AS VALUE2,\r\n ABS(IFNULL(VD,0) - IFNULL(VA,0) *IFNULL(VC,0)) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_BEG_BAL AS VD, BEG_BAL AS VA, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'61\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.038', 't_r_g06b_1', '对于3.1.1应收非关联方款项-账龄1个月至3个月（含）：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', '对于3.1.1应收非关联方款项-账龄1个月至3个月（含）：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VBLUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VBLUE2) AS RIGHT_CALCULATION_VALUE, MAX(VBLUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VE,0) = IFNULL(VB,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_END_BAL,END_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VE,0)AS VBLUE1,\r\n IFNULL(VB,0) *IFNULL(VC,0) AS VBLUE2,\r\n ABS(IFNULL(VE,0) - IFNULL(VB,0) *IFNULL(VC,0)) AS VBLUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_END_BAL AS VE, END_BAL AS VB, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'311\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.039', 't_r_g06b_1', '对于3.1.2应收非关联方款项-账龄3个月至6个月（含）：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', '对于3.1.2应收非关联方款项-账龄3个月至6个月（含）：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VBLUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VBLUE2) AS RIGHT_CALCULATION_VALUE, MAX(VBLUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VE,0) = IFNULL(VB,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_END_BAL,END_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VE,0)AS VBLUE1,\r\n IFNULL(VB,0) *IFNULL(VC,0) AS VBLUE2,\r\n ABS(IFNULL(VE,0) - IFNULL(VB,0) *IFNULL(VC,0)) AS VBLUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_END_BAL AS VE, END_BAL AS VB, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'312\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.040', 't_r_g06b_1', '对于3.1.3应收非关联方款项-账龄6个月至1年（含）：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', '对于3.1.3应收非关联方款项-账龄6个月至1年（含）：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VBLUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VBLUE2) AS RIGHT_CALCULATION_VALUE, MAX(VBLUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VE,0) = IFNULL(VB,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_END_BAL,END_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VE,0)AS VBLUE1,\r\n IFNULL(VB,0) *IFNULL(VC,0) AS VBLUE2,\r\n ABS(IFNULL(VE,0) - IFNULL(VB,0) *IFNULL(VC,0)) AS VBLUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_END_BAL AS VE, END_BAL AS VB, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'313\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.041', 't_r_g06b_1', '对于3.1.4应收非关联方款项-账龄1年以上：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', '对于3.1.4应收非关联方款项-账龄1年以上：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VBLUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VBLUE2) AS RIGHT_CALCULATION_VALUE, MAX(VBLUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VE,0) = IFNULL(VB,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_END_BAL,END_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VE,0)AS VBLUE1,\r\n IFNULL(VB,0) *IFNULL(VC,0) AS VBLUE2,\r\n ABS(IFNULL(VE,0) - IFNULL(VB,0) *IFNULL(VC,0)) AS VBLUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_END_BAL AS VE, END_BAL AS VB, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'314\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.042', 't_r_g06b_1', '对于3.2应收关联方款项：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', '对于3.2应收关联方款项：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VBLUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VBLUE2) AS RIGHT_CALCULATION_VALUE, MAX(VBLUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VE,0) = IFNULL(VB,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_END_BAL,END_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VE,0)AS VBLUE1,\r\n IFNULL(VB,0) *IFNULL(VC,0) AS VBLUE2,\r\n ABS(IFNULL(VE,0) - IFNULL(VB,0) *IFNULL(VC,0)) AS VBLUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_END_BAL AS VE, END_BAL AS VB, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'32\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.043', 't_r_g06b_1', '对于4.1固定资产：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', '对于4.1固定资产：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VBLUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VBLUE2) AS RIGHT_CALCULATION_VALUE, MAX(VBLUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VE,0) = IFNULL(VB,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_END_BAL,END_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VE,0)AS VBLUE1,\r\n IFNULL(VB,0) *IFNULL(VC,0) AS VBLUE2,\r\n ABS(IFNULL(VE,0) - IFNULL(VB,0) *IFNULL(VC,0)) AS VBLUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_END_BAL AS VE, END_BAL AS VB, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'41\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.044', 't_r_g06b_1', '对于4.2其他资产-其他：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', '对于4.2其他资产-其他：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VBLUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VBLUE2) AS RIGHT_CALCULATION_VALUE, MAX(VBLUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VE,0) = IFNULL(VB,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_END_BAL,END_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VE,0)AS VBLUE1,\r\n IFNULL(VB,0) *IFNULL(VC,0) AS VBLUE2,\r\n ABS(IFNULL(VE,0) - IFNULL(VB,0) *IFNULL(VC,0)) AS VBLUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_END_BAL AS VE, END_BAL AS VB, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'42\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.045', 't_r_g06b_1', '对于5.或有负债：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', '对于5.或有负债：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VBLUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VBLUE2) AS RIGHT_CALCULATION_VALUE, MAX(VBLUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VE,0) = IFNULL(VB,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_END_BAL,END_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VE,0)AS VBLUE1,\r\n IFNULL(VB,0) *IFNULL(VC,0) AS VBLUE2,\r\n ABS(IFNULL(VE,0) - IFNULL(VB,0) *IFNULL(VC,0)) AS VBLUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_END_BAL AS VE, END_BAL AS VB, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'5\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.046', 't_r_g06b_1', '对于6.1所有权受限等无法变现的资产（如被冻结）：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', '对于6.1所有权受限等无法变现的资产（如被冻结）：[E]{应计算金额期末金额}=[B]{期末余额}*[C]{扣减比例}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VBLUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VBLUE2) AS RIGHT_CALCULATION_VALUE, MAX(VBLUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN IFNULL(VE,0) = IFNULL(VB,0) *IFNULL(VC,0) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'ACTUAL_END_BAL,END_BAL,DEDUCT_RATE\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n IFNULL(VE,0)AS VBLUE1,\r\n IFNULL(VB,0) *IFNULL(VC,0) AS VBLUE2,\r\n ABS(IFNULL(VE,0) - IFNULL(VB,0) *IFNULL(VC,0)) AS VBLUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_END_BAL AS VE, END_BAL AS VB, DEDUCT_RATE AS VC,N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'61\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.047', 't_r_g06b_1', '[表II]{银行理财子公司风险资本计算表}[5.A]{5.净资产（应计算金额）-A列-期初余额} =[表I]{银行理财子公司净资本计算表}[2.D]{2.理财业务对应的资本-D列-期初余额}', '[表II]{银行理财子公司风险资本计算表}[5.A]{5.净资产（应计算金额）-A列-期初余额} =[表I]{银行理财子公司净资本计算表}[2.D]{2.理财业务对应的资本-D列-期初余额}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE FROM(\r\nSELECT CASE\r\n WHEN IFNULL(A2.V,0) = IFNULL(A1.V,0)THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE,GROUP_CONCAT(DISTINCT A1.N_ID) AS N_ID_LIST,\r\n\'ACTUAL_BEG_BAL\' AS COLUMN_CODE,A1.FILE_DATE AS FILE_DATE,\r\nA1.FUND_CATEGORY AS INSTI_TYPE,\r\nIFNULL(A2.V,0) AS VALUE1,\r\nIFNULL(A1.V,0) AS VALUE2,\r\nABS(IFNULL(A2.V,0)-IFNULL(A1.V,0)) AS VALUE3\r\nFROM (\r\n(SELECT FILE_DATE,NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_BEG_BAL AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\nWHERE FILE_DATE=\'@FILE_DATE\'\r\nAND NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2)=\'2\')A1\r\nLEFT JOIN\r\n(SELECT FILE_DATE,NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n BEG_BAL AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_2\r\nWHERE FILE_DATE=\'@FILE_DATE\'\r\nAND NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2)=\'5\') A2\r\nON a1.FILE_DATE=a2.FILE_DATE ))T\r\nWHERE T.RESULT_CODE=\'0\'\r\nGROUP BY T.FILE_DATE,T.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.048', 't_r_g06b_1', '[表II]{银行理财子公司风险资本计算表}[5.B]{5.净资产（应计算金额）-B列-期末余额} =[表I]{银行理财子公司净资本计算表}[2.E]{2.理财业务对应的资本-E列-风险资本期末余额}', '[表II]{银行理财子公司风险资本计算表}[5.B]{5.净资产（应计算金额）-B列-期末余额} =[表I]{银行理财子公司净资本计算表}[2.E]{2.理财业务对应的资本-E列-风险资本期末余额}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2022-03-07 18:46:15', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE FROM(\r\nSELECT CASE\r\n WHEN IFNULL(A2.V,0) = IFNULL(A1.V,0)THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE,GROUP_CONCAT(DISTINCT A1.N_ID) AS N_ID_LIST,\r\n\'ACTUAL_END_BAL\' AS COLUMN_CODE,A1.FILE_DATE AS FILE_DATE,\r\nA1.FUND_CATEGORY AS INSTI_TYPE,\r\nIFNULL(A2.V,0) AS VALUE1,\r\nIFNULL(A1.V,0) AS VALUE2,\r\nABS(IFNULL(A2.V,0)-IFNULL(A1.V,0)) AS VALUE3\r\nFROM (\r\n(SELECT FILE_DATE,NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_END_BAL AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\nWHERE FILE_DATE=\'@FILE_DATE\'\r\nAND NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2)=\'2\')A1\r\nLEFT JOIN\r\n(SELECT FILE_DATE,NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_2\r\nWHERE FILE_DATE=\'@FILE_DATE\'\r\nAND NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2)=\'5\') A2\r\nON a1.FILE_DATE=a2.FILE_DATE ))T\r\nWHERE T.RESULT_CODE=\'0\'\r\nGROUP BY T.FILE_DATE,T.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.049', 't_r_g06b_1', '[表II]{银行理财子公司风险资本计算表}[6.A]{6.净资本（应计算金额）-A列-期初余额} =[表I]{银行理财子公司净资本计算表}[8.D]{8.净资本（应计算金额）/风险资本-D列-风险资本期初余额}', '[表II]{银行理财子公司风险资本计算表}[6.A]{6.净资本（应计算金额）-A列-期初余额} =[表I]{银行理财子公司净资本计算表}[8.D]{8.净资本（应计算金额）/风险资本-D列-风险资本期初余额}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2022-03-07 18:46:23', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE FROM(\r\nSELECT CASE\r\n WHEN IFNULL(A2.V,0) = IFNULL(A1.V,0)THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE,GROUP_CONCAT(DISTINCT A1.N_ID) AS N_ID_LIST,\r\n\'ACTUAL_BEG_BAL\' AS COLUMN_CODE,A1.FILE_DATE AS FILE_DATE,\r\nA1.FUND_CATEGORY AS INSTI_TYPE,\r\nIFNULL(A2.V,0) AS VALUE1,\r\nIFNULL(A1.V,0) AS VALUE2,\r\nABS(IFNULL(A2.V,0)-IFNULL(A1.V,0)) AS VALUE3\r\nFROM (\r\n(SELECT FILE_DATE,NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_BEG_BAL AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\nWHERE FILE_DATE=\'@FILE_DATE\'\r\nAND NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2)=\'8\')A1\r\nLEFT JOIN\r\n(SELECT FILE_DATE,NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n BEG_BAL AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_2\r\nWHERE FILE_DATE=\'@FILE_DATE\'\r\nAND NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2)=\'6\') A2\r\nON a1.FILE_DATE=a2.FILE_DATE ))T\r\nWHERE T.RESULT_CODE=\'0\'\r\nGROUP BY T.FILE_DATE,T.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.042.050', 't_r_g06b_1', '[表II]{银行理财子公司风险资本计算表}[6.B]{6.净资本（应计算金额）-B列-期末余额} =[表I]{银行理财子公司净资本计算表}[8.E]{8.净资本（应计算金额）/风险资本-E列-风险资本期末余额}', '[表II]{银行理财子公司风险资本计算表}[6.B]{6.净资本（应计算金额）-B列-期末余额} =[表I]{银行理财子公司净资本计算表}[8.E]{8.净资本（应计算金额）/风险资本-E列-风险资本期末余额}', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2022-03-07 18:46:27', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE FROM(\r\nSELECT CASE\r\n WHEN IFNULL(A2.V,0) = IFNULL(A1.V,0)THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE,GROUP_CONCAT(DISTINCT A1.N_ID) AS N_ID_LIST,\r\n\'ACTUAL_END_BAL\' AS COLUMN_CODE,A1.FILE_DATE AS FILE_DATE,\r\nA1.FUND_CATEGORY AS INSTI_TYPE,\r\nIFNULL(A2.V,0) AS VALUE1,\r\nIFNULL(A1.V,0) AS VALUE2,\r\nABS(IFNULL(A2.V,0)-IFNULL(A1.V,0)) AS VALUE3\r\nFROM (\r\n(SELECT FILE_DATE,NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ACTUAL_END_BAL AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_1\r\nWHERE FILE_DATE=\'@FILE_DATE\'\r\nAND NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2)=\'8\')A1\r\nLEFT JOIN\r\n(SELECT FILE_DATE,NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06b_2\r\nWHERE FILE_DATE=\'@FILE_DATE\'\r\nAND NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2)=\'6\') A2\r\nON a1.FILE_DATE=a2.FILE_DATE ))T\r\nWHERE T.RESULT_CODE=\'0\'\r\nGROUP BY T.FILE_DATE,T.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.001', 't_r_g06a_2', '期末余额（穿透前）{1.1.6 合计）}=(1.1.1 现金及活期存款)+(1.1.2 本行存款)+（1.1.3 他行存款）+（1.1.4 本行发行的大额存单）+（1.1.5 他行发行的大额存单）', '期末余额（穿透前）{1.1.6 合计）}=(1.1.1 现金及活期存款)+(1.1.2 本行存款)+（1.1.3 他行存款）+（1.1.4 本行发行的大额存单）+（1.1.5 他行发行的大额存单）', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE IN (\'116\'), T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'111\', \'112\',\'113\',\'114\',\'115\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE ,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE IN (\'116\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'111\', \'112\',\'113\',\'114\',\'115\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE IN (\'116\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'111\', \'112\',\'113\',\'114\',\'115\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\' AND ITEM_NAME <> \'1.15 合计\') T\r\n WHERE T.ITEM_CODE IN (\'116\', \'111\', \'112\',\'113\',\'114\',\'115\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.002', 't_r_g06a_2', '期末余额（穿透后）{1.1.6 合计）}=(1.1.1 现金及活期存款)+(1.1.2 本行存款)+（1.1.3 他行存款）+（1.1.4 本行发行的大额存单）+（1.1.5 他行发行的大额存单）', '期末余额（穿透后）{1.1.6 合计）}=(1.1.1 现金及活期存款)+(1.1.2 本行存款)+（1.1.3 他行存款）+（1.1.4 本行发行的大额存单）+（1.1.5 他行发行的大额存单）', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE IN (\'116\'), T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'111\', \'112\',\'113\',\'114\',\'115\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE ,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE IN (\'116\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'111\', \'112\',\'113\',\'114\',\'115\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE IN (\'116\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'111\', \'112\',\'113\',\'114\',\'115\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\' AND ITEM_NAME <> \'1.15 合计\') T\r\n WHERE T.ITEM_CODE IN (\'116\', \'111\', \'112\',\'113\',\'114\',\'115\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.003', 't_r_g06a_2', '期末余额（穿透前）(1.2.3 合计)=(1.2.1 本行发行的同业存单)+(1.2.2 他行发行的同业存单)', '期末余额（穿透前）(1.2.3 合计)=(1.2.1 本行发行的同业存单)+(1.2.2 他行发行的同业存单)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE IN (\'123\'), T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'121\', \'122\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE ,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE IN (\'123\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'121\', \'122\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE IN (\'123\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'121\', \'122\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'123\', \'121\', \'122\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.004', 't_r_g06a_2', '期末余额（穿透后）(1.2.3 合计)=(1.2.1 本行发行的同业存单)+(1.2.2 他行发行的同业存单)', '期末余额（穿透后）(1.2.3 合计)=(1.2.1 本行发行的同业存单)+(1.2.2 他行发行的同业存单)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE IN (\'123\'), T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'121\', \'122\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE ,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE IN (\'123\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'121\', \'122\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE IN (\'123\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'121\', \'122\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'123\', \'121\', \'122\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.005', 't_r_g06a_2', '期末余额（穿透前）(1.3.3 合计)=(1.3.1 拆放同业)+(1.3.2 债券买入返售)', '期末余额（穿透前）(1.3.3 合计)=(1.3.1 拆放同业)+(1.3.2 债券买入返售)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE IN (\'133\'), T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'131\', \'132\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE ,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE IN (\'133\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'131\', \'132\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE IN (\'133\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'131\', \'132\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'133\', \'131\', \'132\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.006', 't_r_g06a_2', '期末余额（穿透后）(1.3.3 合计)=(1.3.1 拆放同业)+(1.3.2 债券买入返售)', '期末余额（穿透后）(1.3.3 合计)=(1.3.1 拆放同业)+(1.3.2 债券买入返售)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE IN (\'133\'), T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'131\', \'132\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE ,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE IN (\'133\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'131\', \'132\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE IN (\'133\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'131\', \'132\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'133\', \'131\', \'132\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.007', 't_r_g06a_2', '期末余额（穿透前）(1.4.14 合计)=(1.4.1 国债)+(1.4.2 地方政府债券)+(1.4.3 中央银行票据)+(1.4.4 政府机构债券)+(1.4.5 政策性金融债券)+(1.4.6 商业性金融债券)+(1.4.7 企业债券)+(1.4.8 公司债券)+(1.4.9 企业债务融资工具)+(1.4.10 资产支持证券)+(1.4.11 外国债券（不含QDII债券）)+(1.4.12 非标转标资产)', '期末余额（穿透前）(1.4.14 合计)=(1.4.1 国债)+(1.4.2 地方政府债券)+(1.4.3 中央银行票据)+(1.4.4 政府机构债券)+(1.4.5 政策性金融债券)+(1.4.6 商业性金融债券)+(1.4.7 企业债券)+(1.4.8 公司债券)+(1.4.9 企业债务融资工具)+(1.4.10 资产支持证券)+(1.4.11 外国债券（不含QDII债券）)+(1.4.12 非标转标资产)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE IN (\'1414\'), T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'141\', \'142\',\'143\',\'144\',\'145\',\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE ,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE IN (\'1414\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'141\', \'142\',\'143\',\'144\',\'145\',\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE IN (\'1414\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'141\', \'142\',\'143\',\'144\',\'145\',\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1414\', \'141\', \'142\',\'143\',\'144\',\'145\',\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.008', 't_r_g06a_2', '期末余额（穿透后）(1.4.14 合计)=(1.4.1 国债)+(1.4.2 地方政府债券)+(1.4.3 中央银行票据)+(1.4.4 政府机构债券)+(1.4.5 政策性金融债券)+(1.4.6 商业性金融债券)+(1.4.7 企业债券)+(1.4.8 公司债券)+(1.4.9 企业债务融资工具)+(1.4.10 资产支持证券)+(1.4.11 外国债券（不含QDII债券）)+(1.4.12 非标转标资产)', '期末余额（穿透后）(1.4.14 合计)=(1.4.1 国债)+(1.4.2 地方政府债券)+(1.4.3 中央银行票据)+(1.4.4 政府机构债券)+(1.4.5 政策性金融债券)+(1.4.6 商业性金融债券)+(1.4.7 企业债券)+(1.4.8 公司债券)+(1.4.9 企业债务融资工具)+(1.4.10 资产支持证券)+(1.4.11 外国债券（不含QDII债券）)+(1.4.12 非标转标资产)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE IN (\'1414\'), T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'141\', \'142\',\'143\',\'144\',\'145\',\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE ,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE IN (\'1414\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'141\', \'142\',\'143\',\'144\',\'145\',\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE IN (\'1414\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'141\', \'142\',\'143\',\'144\',\'145\',\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1414\', \'141\', \'142\',\'143\',\'144\',\'145\',\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.009', 't_r_g06a_2', '期末余额（穿透前）(其中：1.4.2.a 专项债券)<=(1.4.2 地方政府债券)', '期末余额（穿透前）(其中：1.4.2.a 专项债券)<=(1.4.2 地方政府债券)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE IN (\'142a\'), T.V, 0)) <=\r\n SUM(IF(T.ITEM_CODE IN (\'142\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE ,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE IN (\'142a\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'142\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE IN (\'142a\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'142\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'142a\', \'142\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.010', 't_r_g06a_2', '期末余额（穿透后）(其中：1.4.2.a 专项债券)<=(1.4.2 地方政府债券)', '期末余额（穿透后）(其中：1.4.2.a 专项债券)<=(1.4.2 地方政府债券)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE IN (\'142a\'), T.V, 0)) <=\r\n SUM(IF(T.ITEM_CODE IN (\'142\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE ,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE IN (\'142a\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'142\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE IN (\'142a\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'142\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'142a\', \'142\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.011', 't_r_g06a_2', '期末余额（穿透前）( 其中：1.4.a AA+（含）以上信用债券)+(1.4.b AA+以下信用债券)+(1.4.c 无评级信用债券) <= (1.4.14 合计)', '期末余额（穿透前）( 其中：1.4.a AA+（含）以上信用债券)+(1.4.b AA+以下信用债券)+(1.4.c 无评级信用债券) <= (1.4.14 合计)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE IN (\'14a\',\'14b\',\'14c\'), T.V, 0)) <=\r\n SUM(IF(T.ITEM_CODE IN (\'1414\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE ,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE IN (\'14a\',\'14b\',\'14c\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'1414\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE IN (\'14a\',\'14b\',\'14c\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'1414\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'14a\', \'14b\',\'14c\',\'1414\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.012', 't_r_g06a_2', '期末余额（穿透后）( 其中：1.4.a AA+（含）以上信用债券)+(1.4.b AA+以下信用债券)+(1.4.c 无评级信用债券) <= (1.4.14 合计)', '期末余额（穿透后）( 其中：1.4.a AA+（含）以上信用债券)+(1.4.b AA+以下信用债券)+(1.4.c 无评级信用债券) <= (1.4.14 合计)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE IN (\'14a\',\'14b\',\'14c\'), T.V, 0)) <=\r\n SUM(IF(T.ITEM_CODE IN (\'1414\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE ,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE IN (\'14a\',\'14b\',\'14c\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'1414\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE IN (\'14a\',\'14b\',\'14c\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'1414\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'14a\', \'14b\',\'14c\',\'1414\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.013', 't_r_g06a_2', '期末余额（穿透前）( 其中：1.4.a AA+（含）以上信用债券)+(1.4.b AA+以下信用债券)+(1.4.c 无评级信用债券) =(1.4.6 商业性金融债券)+(1.4.7 企业债券)+(1.4.8 公司债券)+(1.4.9 企业债务融资工具)+(1.4.10 资产支持证券)+(1.4.11 外国债券（不含QDII债券）)+(1.4.12 非标转标资产)', '期末余额（穿透前）( 其中：1.4.a AA+（含）以上信用债券)+(1.4.b AA+以下信用债券)+(1.4.c 无评级信用债券) =(1.4.6 商业性金融债券)+(1.4.7 企业债券)+(1.4.8 公司债券)+(1.4.9 企业债务融资工具)+(1.4.10 资产支持证券)+(1.4.11 外国债券（不含QDII债券）)+(1.4.12 非标转标资产)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE IN (\'14a\',\'14b\',\'14c\'), T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE IN (\'14a\',\'14b\',\'14c\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE IN (\'14a\',\'14b\',\'14c\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'14a\', \'14b\',\'14c\',\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.014', 't_r_g06a_2', '期末余额（穿透后）( 其中：1.4.a AA+（含）以上信用债券)+(1.4.b AA+以下信用债券)+(1.4.c 无评级信用债券) =(1.4.6 商业性金融债券)+(1.4.7 企业债券)+(1.4.8 公司债券)+(1.4.9 企业债务融资工具)+(1.4.10 资产支持证券)+(1.4.11 外国债券（不含QDII债券）)+(1.4.12 非标转标资产)', '期末余额（穿透后）( 其中：1.4.a AA+（含）以上信用债券)+(1.4.b AA+以下信用债券)+(1.4.c 无评级信用债券) =(1.4.6 商业性金融债券)+(1.4.7 企业债券)+(1.4.8 公司债券)+(1.4.9 企业债务融资工具)+(1.4.10 资产支持证券)+(1.4.11 外国债券（不含QDII债券）)+(1.4.12 非标转标资产)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE IN (\'14a\',\'14b\',\'14c\'), T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE IN (\'14a\',\'14b\',\'14c\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE IN (\'14a\',\'14b\',\'14c\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'14a\', \'14b\',\'14c\',\'146\',\'147\',\'148\',\'149\',\'1410\',\'1411\',\'1412\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.015', 't_r_g06a_2', '期末余额（穿透前）（1.5.17 合计）=（1.5.1 票据类)+(1.5.2 信用证)+(1.5.3 信托贷款)+(1.5.4 委托贷款）+(1.5.5 信贷资产转让)+(1.5.6 收/受益权)+(1.5.7 委托债权)+(1.5.8 应收账款)+(1.5.9 带回购条款的股权性融资)+(1.5.10 债权融资类产品)+(1.5.11 同业借款)+(1.5.12 收益凭证)+(1.5.13 债权投资计划和资产支持计划)+(1.5.14 理财直接融资工具)+(1.5.15 信贷资产流转和收益权转让产品)+(1.5.16 其他非标准化债权类投资)', '期末余额（穿透前）（1.5.17 合计）=（1.5.1 票据类)+(1.5.2 信用证)+(1.5.3 信托贷款)+(1.5.4 委托贷款）+(1.5.5 信贷资产转让)+(1.5.6 收/受益权)+(1.5.7 委托债权)+(1.5.8 应收账款)+(1.5.9 带回购条款的股权性融资)+(1.5.10 债权融资类产品)+(1.5.11 同业借款)+(1.5.12 收益凭证)+(1.5.13 债权投资计划和资产支持计划)+(1.5.14 理财直接融资工具)+(1.5.15 信贷资产流转和收益权转让产品)+(1.5.16 其他非标准化债权类投资)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1517\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'151\',\'152\',\'153\',\'154\',\'155\',\'156\',\'157\',\'158\',\'159\',\'1510\',\'1511\',\'1512\',\'1513\',\'1514\',\'1515\',\'1516\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1517\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'151\',\'152\',\'153\',\'154\',\'155\',\'156\',\'157\',\'158\',\'159\',\'1510\',\'1511\',\'1512\',\'1513\',\'1514\',\'1515\',\'1516\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1517\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'151\',\'152\',\'153\',\'154\',\'155\',\'156\',\'157\',\'158\',\'159\',\'1510\',\'1511\',\'1512\',\'1513\',\'1514\',\'1515\',\'1516\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN ( \'151\',\'152\',\'153\',\'154\',\'155\',\'156\',\'157\',\'158\',\'159\',\'1510\',\'1511\',\'1512\',\'1513\',\'1514\',\'1515\',\'1516\',\'1517\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.016', 't_r_g06a_2', '期末余额（穿透后）（1.5.17 合计）=（1.5.1 票据类)+(1.5.2 信用证)+(1.5.3 信托贷款)+(1.5.4 委托贷款）+(1.5.5 信贷资产转让)+(1.5.6 收/受益权)+(1.5.7 委托债权)+(1.5.8 应收账款)+(1.5.9 带回购条款的股权性融资)+(1.5.10 债权融资类产品)+(1.5.11 同业借款)+(1.5.12 收益凭证)+(1.5.13 债权投资计划和资产支持计划)+(1.5.14 理财直接融资工具)+(1.5.15 信贷资产流转和收益权转让产品)+(1.5.16 其他非标准化债权类投资)', '期末余额（穿透后）（1.5.17 合计）=（1.5.1 票据类)+(1.5.2 信用证)+(1.5.3 信托贷款)+(1.5.4 委托贷款）+(1.5.5 信贷资产转让)+(1.5.6 收/受益权)+(1.5.7 委托债权)+(1.5.8 应收账款)+(1.5.9 带回购条款的股权性融资)+(1.5.10 债权融资类产品)+(1.5.11 同业借款)+(1.5.12 收益凭证)+(1.5.13 债权投资计划和资产支持计划)+(1.5.14 理财直接融资工具)+(1.5.15 信贷资产流转和收益权转让产品)+(1.5.16 其他非标准化债权类投资)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1517\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'151\',\'152\',\'153\',\'154\',\'155\',\'156\',\'157\',\'158\',\'159\',\'1510\',\'1511\',\'1512\',\'1513\',\'1514\',\'1515\',\'1516\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1517\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'151\',\'152\',\'153\',\'154\',\'155\',\'156\',\'157\',\'158\',\'159\',\'1510\',\'1511\',\'1512\',\'1513\',\'1514\',\'1515\',\'1516\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1517\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'151\',\'152\',\'153\',\'154\',\'155\',\'156\',\'157\',\'158\',\'159\',\'1510\',\'1511\',\'1512\',\'1513\',\'1514\',\'1515\',\'1516\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN ( \'151\',\'152\',\'153\',\'154\',\'155\',\'156\',\'157\',\'158\',\'159\',\'1510\',\'1511\',\'1512\',\'1513\',\'1514\',\'1515\',\'1516\',\'1517\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.017', 't_r_g06a_2', '期末余额（穿透前）（其中：1.5.1.a 标准化票据）<= (1.5.1 票据类)', '期末余额（穿透前）（其中：1.5.1.a 标准化票据）<= (1.5.1 票据类)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'151a\', T.V, 0)) <=\r\n SUM(IF(T.ITEM_CODE =\'151\', T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'151a\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE =\'151\', T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'151a\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE =\'151\', T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN ( \'151a\',\'151\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.018', 't_r_g06a_2', '期末余额（穿透后）（其中：1.5.1.a 标准化票据）<= (1.5.1 票据类)', '期末余额（穿透后）（其中：1.5.1.a 标准化票据）<= (1.5.1 票据类)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'151a\', T.V, 0)) <=\r\n SUM(IF(T.ITEM_CODE =\'151\', T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'151a\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE =\'151\', T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'151a\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE =\'151\', T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN ( \'151a\',\'151\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.019', 't_r_g06a_2', '期末余额（穿透前）(其中：1.5.16.a 场内股票质押回购)+(1.5.16.b 场外股票质押融资)<=(1.5.16 其他非标准化债权类投资)', '期末余额（穿透前）(其中：1.5.16.a 场内股票质押回购)+(1.5.16.b 场外股票质押融资)<=(1.5.16 其他非标准化债权类投资)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2022-03-15 14:12:26', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE in (\'1516a\',\'1516b\'), T.V, 0))<=\r\n SUM(IF(T.ITEM_CODE =\'1516\', T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE in (\'1516a\',\'1516b\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE =\'1516\', T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE in (\'1516a\',\'1516b\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE =\'1516\', T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN ( \'1516a\',\'1516b\',\'1516\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.020', 't_r_g06a_2', '期末余额（穿透后）(其中：1.5.16.a 场内股票质押回购)+(1.5.16.b 场外股票质押融资)<=(1.5.16 其他非标准化债权类投资)', '期末余额（穿透后）(其中：1.5.16.a 场内股票质押回购)+(1.5.16.b 场外股票质押融资)<=(1.5.16 其他非标准化债权类投资)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2022-03-15 14:12:58', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE in (\'1516a\',\'1516b\'), T.V, 0))<=\r\n SUM(IF(T.ITEM_CODE =\'1516\', T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE in (\'1516a\',\'1516b\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE =\'1516\', T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE in (\'1516a\',\'1516b\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE =\'1516\', T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN ( \'1516a\',\'1516b\',\'1516\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.021', 't_r_g06a_2', '期末余额（穿透前）(1.6.5 合计)=(1.6.1 股权)+(1.6.2 股票（一级市场）)+(1.6.3 股票)+（二级市场）)+(1.6.4 其他权益类投资)', '期末余额（穿透前）(1.6.5 合计)=(1.6.1 股权)+(1.6.2 股票（一级市场）)+(1.6.3 股票)+（二级市场）)+(1.6.4 其他权益类投资)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'165\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'161\',\'162\',\'163\',\'164\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'165\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'161\',\'162\',\'163\',\'164\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'165\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'161\',\'162\',\'163\',\'164\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN ( \'161\',\'162\',\'163\',\'164\',\'165\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.022', 't_r_g06a_2', '期末余额（穿透后）(1.6.5 合计)=(1.6.1 股权)+(1.6.2 股票（一级市场）)+(1.6.3 股票)+（二级市场）)+(1.6.4 其他权益类投资)', '期末余额（穿透后）(1.6.5 合计)=(1.6.1 股权)+(1.6.2 股票（一级市场）)+(1.6.3 股票)+（二级市场）)+(1.6.4 其他权益类投资)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'165\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'161\',\'162\',\'163\',\'164\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'165\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'161\',\'162\',\'163\',\'164\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'165\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'161\',\'162\',\'163\',\'164\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN ( \'161\',\'162\',\'163\',\'164\',\'165\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.023', 't_r_g06a_2', '期末余额（穿透前）(1.7.8 合计)=(1.7.1 远期)+(1.7.2 互换)+（1.7.3 期货）)+(1.7.4 期权)+（1.7.5 债券借贷）)+(1.7.6 权证)+（1.7.7 其他金融衍生品）', '期末余额（穿透前）(1.7.8 合计)=(1.7.1 远期)+(1.7.2 互换)+（1.7.3 期货）)+(1.7.4 期权)+（1.7.5 债券借贷）)+(1.7.6 权证)+（1.7.7 其他金融衍生品）', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'178\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'171\',\'172\',\'173\',\'174\',\'175\',\'176\',\'177\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'178\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'171\',\'172\',\'173\',\'174\',\'175\',\'176\',\'177\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'178\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'171\',\'172\',\'173\',\'174\',\'175\',\'176\',\'177\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN ( \'171\',\'172\',\'173\',\'174\',\'175\',\'176\',\'177\',\'178\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.024', 't_r_g06a_2', '期末余额（穿透后）(1.7.8 合计)=(1.7.1 远期)+(1.7.2 互换)+（1.7.3 期货）)+(1.7.4 期权)+（1.7.5 债券借贷）)+(1.7.6 权证)+（1.7.7 其他金融衍生品）', '期末余额（穿透后）(1.7.8 合计)=(1.7.1 远期)+(1.7.2 互换)+（1.7.3 期货）)+(1.7.4 期权)+（1.7.5 债券借贷）)+(1.7.6 权证)+（1.7.7 其他金融衍生品）', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'178\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'171\',\'172\',\'173\',\'174\',\'175\',\'176\',\'177\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'178\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'171\',\'172\',\'173\',\'174\',\'175\',\'176\',\'177\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'178\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'171\',\'172\',\'173\',\'174\',\'175\',\'176\',\'177\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN ( \'171\',\'172\',\'173\',\'174\',\'175\',\'176\',\'177\',\'178\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.025', 't_r_g06a_2', '期末余额(穿透前)(1.8.11 合计)=(1.8.1 QDII债券)+(1.8.2 QDII拆出)+（1.8.3 QDII逆回购）)+(1.8.4 QDII债券型基金)+（1.8.5 QDII货币型基金）+(1.8.6 QDII混合型基金)+（1.8.7 QDII股票型基金）+(1.8.8 QDII股票)+(1.8.9 QDII结构性票据)+(1.8.10 其他代客境外理财投资QDII)', '期末余额(穿透前)(1.8.11 合计)=(1.8.1 QDII债券)+(1.8.2 QDII拆出)+（1.8.3 QDII逆回购）)+(1.8.4 QDII债券型基金)+（1.8.5 QDII货币型基金）+(1.8.6 QDII混合型基金)+（1.8.7 QDII股票型基金）+(1.8.8 QDII股票)+(1.8.9 QDII结构性票据)+(1.8.10 其他代客境外理财投资QDII)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1811\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in ( \'181\',\'182\',\'183\',\'184\',\'185\',\'186\',\'187\',\'188\',\'189\',\'1810\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1811\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in ( \'181\',\'182\',\'183\',\'184\',\'185\',\'186\',\'187\',\'188\',\'189\',\'1810\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1811\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in ( \'181\',\'182\',\'183\',\'184\',\'185\',\'186\',\'187\',\'188\',\'189\',\'1810\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN ( \'181\',\'182\',\'183\',\'184\',\'185\',\'186\',\'187\',\'188\',\'189\',\'1810\',\'1811\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.026', 't_r_g06a_2', '期末余额(穿透后)(1.8.11 合计)=(1.8.1 QDII债券)+(1.8.2 QDII拆出)+（1.8.3 QDII逆回购）)+(1.8.4 QDII债券型基金)+（1.8.5 QDII货币型基金）+(1.8.6 QDII混合型基金)+（1.8.7 QDII股票型基金）+(1.8.8 QDII股票)+(1.8.9 QDII结构性票据)+(1.8.10 其他代客境外理财投资QDII)', '期末余额(穿透后)(1.8.11 合计)=(1.8.1 QDII债券)+(1.8.2 QDII拆出)+（1.8.3 QDII逆回购）)+(1.8.4 QDII债券型基金)+（1.8.5 QDII货币型基金）+(1.8.6 QDII混合型基金)+（1.8.7 QDII股票型基金）+(1.8.8 QDII股票)+(1.8.9 QDII结构性票据)+(1.8.10 其他代客境外理财投资QDII)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1811\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in ( \'181\',\'182\',\'183\',\'184\',\'185\',\'186\',\'187\',\'188\',\'189\',\'1810\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1811\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in ( \'181\',\'182\',\'183\',\'184\',\'185\',\'186\',\'187\',\'188\',\'189\',\'1810\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1811\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in ( \'181\',\'182\',\'183\',\'184\',\'185\',\'186\',\'187\',\'188\',\'189\',\'1810\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN ( \'181\',\'182\',\'183\',\'184\',\'185\',\'186\',\'187\',\'188\',\'189\',\'1810\',\'1811\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.027', 't_r_g06a_2', '期末余额（穿透前）(1.9.4 合计)=(1.9.1 贵金属类)+(1.9.2 大宗商品类)+（1.9.3 其他商品类资产)', '期末余额（穿透前）(1.9.4 合计)=(1.9.1 贵金属类)+(1.9.2 大宗商品类)+（1.9.3 其他商品类资产)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'194\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'191\',\'192\',\'193\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'194\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'191\',\'192\',\'193\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'194\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'191\',\'192\',\'193\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'191\',\'192\',\'193\',\'194\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.028', 't_r_g06a_2', '期末余额（穿透后）(1.9.4 合计)=(1.9.1 贵金属类)+(1.9.2 大宗商品类)+（1.9.3 其他商品类资产)', '期末余额（穿透后）(1.9.4 合计)=(1.9.1 贵金属类)+(1.9.2 大宗商品类)+（1.9.3 其他商品类资产)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'194\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'191\',\'192\',\'193\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'194\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'191\',\'192\',\'193\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'194\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'191\',\'192\',\'193\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'191\',\'192\',\'193\',\'194\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.029', 't_r_g06a_2', '期末余额（穿透前）(1.10.7 合计)=(1.10.1 字画类艺术品)+(1.10.2 古董类艺术品)+（1.10.3 其他类艺术品）)+(1.10.4 影视等知识产权)+（1.10.5 酒）+(1.10.6 其他另类资产)', '期末余额（穿透前）(1.10.7 合计)=(1.10.1 字画类艺术品)+(1.10.2 古董类艺术品)+（1.10.3 其他类艺术品）)+(1.10.4 影视等知识产权)+（1.10.5 酒）+(1.10.6 其他另类资产)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1107\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'1101\',\'1102\',\'1103\',\'1104\',\'1105\',\'1106\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1107\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'1101\',\'1102\',\'1103\',\'1104\',\'1105\',\'1106\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1107\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'1101\',\'1102\',\'1103\',\'1104\',\'1105\',\'1106\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1101\',\'1102\',\'1103\',\'1104\',\'1105\',\'1106\',\'1107\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.030', 't_r_g06a_2', '期末余额（穿透后）(1.10.7 合计)=(1.10.1 字画类艺术品)+(1.10.2 古董类艺术品)+（1.10.3 其他类艺术品）)+(1.10.4 影视等知识产权)+（1.10.5 酒）+(1.10.6 其他另类资产)', '期末余额（穿透后）(1.10.7 合计)=(1.10.1 字画类艺术品)+(1.10.2 古董类艺术品)+（1.10.3 其他类艺术品）)+(1.10.4 影视等知识产权)+（1.10.5 酒）+(1.10.6 其他另类资产)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1107\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'1101\',\'1102\',\'1103\',\'1104\',\'1105\',\'1106\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1107\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'1101\',\'1102\',\'1103\',\'1104\',\'1105\',\'1106\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1107\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'1101\',\'1102\',\'1103\',\'1104\',\'1105\',\'1106\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1101\',\'1102\',\'1103\',\'1104\',\'1105\',\'1106\',\'1107\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.031', 't_r_g06a_2', '期末余额（穿透前）(1.11.7 合计)=(1.11.1 债券基金)+(1.11.2 货币市场基金)+（1.11.3 股票基金）)+(1.11.4 基金中基金)+（1.11.5 混合基金）+(1.11.6 其他公募基金)', '期末余额（穿透前）(1.11.7 合计)=(1.11.1 债券基金)+(1.11.2 货币市场基金)+（1.11.3 股票基金）)+(1.11.4 基金中基金)+（1.11.5 混合基金）+(1.11.6 其他公募基金)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1117\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'1111\',\'1112\',\'1113\',\'1114\',\'1115\',\'1116\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1117\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'1111\',\'1112\',\'1113\',\'1114\',\'1115\',\'1116\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1117\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'1111\',\'1112\',\'1113\',\'1114\',\'1115\',\'1116\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1111\',\'1112\',\'1113\',\'1114\',\'1115\',\'1116\',\'1117\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.032', 't_r_g06a_2', '期末余额（穿透后）(1.11.7 合计)=(1.11.1 债券基金)+(1.11.2 货币市场基金)+（1.11.3 股票基金）)+(1.11.4 基金中基金)+（1.11.5 混合基金）+(1.11.6 其他公募基金)', '期末余额（穿透后）(1.11.7 合计)=(1.11.1 债券基金)+(1.11.2 货币市场基金)+（1.11.3 股票基金）)+(1.11.4 基金中基金)+（1.11.5 混合基金）+(1.11.6 其他公募基金)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1117\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'1111\',\'1112\',\'1113\',\'1114\',\'1115\',\'1116\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1117\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'1111\',\'1112\',\'1113\',\'1114\',\'1115\',\'1116\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1117\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'1111\',\'1112\',\'1113\',\'1114\',\'1115\',\'1116\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1111\',\'1112\',\'1113\',\'1114\',\'1115\',\'1116\',\'1117\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.033', 't_r_g06a_2', '期末余额（穿透前）(2.1.3 合计)=(2.1.2 卖出回购)+(2.1.1 同业拆入)', '期末余额（穿透前）(2.1.3 合计)=(2.1.2 卖出回购)+(2.1.1 同业拆入)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'213\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'211\',\'212\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'213\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'211\',\'212\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'213\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'211\',\'212\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'211\',\'212\',\'213\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.034', 't_r_g06a_2', '期末余额（穿透后）(2.1.3 合计)=(2.1.2 卖出回购)+(2.1.1 同业拆入)', '期末余额（穿透后）(2.1.3 合计)=(2.1.2 卖出回购)+(2.1.1 同业拆入)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'213\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'211\',\'212\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'213\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'211\',\'212\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'213\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'211\',\'212\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'211\',\'212\',\'213\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.035', 't_r_g06a_2', '期末余额（穿透前）(其中：2.2.1 同业借款) <= (2.2 其他(负债）)', '期末余额（穿透前）(其中：2.2.1 同业借款) <= (2.2 其他(负债）)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'221\', T.V, 0)) <=\r\n SUM(IF(T.ITEM_CODE =\'22\', T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'221\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE =\'22\', T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'221\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE =\'22\', T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'221\',\'22\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.036', 't_r_g06a_2', '期末余额（穿透后）(其中：2.2.1 同业借款) <= (2.2 其他(负债）)', '期末余额（穿透后）(其中：2.2.1 同业借款) <= (2.2 其他(负债）)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'221\', T.V, 0)) <=\r\n SUM(IF(T.ITEM_CODE =\'22\', T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'221\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE =\'22\', T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'221\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE =\'22\', T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'221\',\'22\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.037', 't_r_g06a_2', '期末余额（穿透前）(2.3 合计)=(2.1.3 合计)+(2.2 其他(负债)', '期末余额（穿透前）(2.3 合计)=(2.1.3 合计)+(2.2 其他(负债)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'23\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'213\',\'22\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'23\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'213\',\'22\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'23\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'213\',\'22\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'213\',\'22\',\'23\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.038', 't_r_g06a_2', '期末余额（穿透后）(2.3 合计)=(2.1.3 合计)+(2.2 其他(负债)', '期末余额（穿透后）(2.3 合计)=(2.1.3 合计)+(2.2 其他(负债)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'23\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'213\',\'22\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'23\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'213\',\'22\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'23\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'213\',\'22\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'213\',\'22\',\'23\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.039', 't_r_g06a_2', '期末余额（穿透前）(3.1.3 合计)=(3.1.1 创业投资基金)+(3.1.2 政府出资产业投资基金)', '期末余额（穿透前）(3.1.3 合计)=(3.1.1 创业投资基金)+(3.1.2 政府出资产业投资基金)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2022-03-15 11:07:25', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\nFROM (SELECT CASE\n WHEN SUM(IF(T.ITEM_CODE =\'313\', T.V, 0)) =\n SUM(IF(T.ITEM_CODE in (\'311\',\'312\'), T.V, 0)) THEN\n 1\n ELSE\n 0\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\n T.FUND_CATEGORY AS INSTI_TYPE,\n SUM(IF(T.ITEM_CODE =\'313\', T.V, 0)) AS VALUE1,\n SUM(IF(T.ITEM_CODE in (\'311\',\'312\'), T.V, 0)) AS VALUE2,\n ABS(SUM(IF(T.ITEM_CODE =\'313\', T.V, 0)) -\n SUM(IF(T.ITEM_CODE in (\'311\',\'312\'), T.V, 0))) AS VALUE3\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\n FROM t_r_g06a_2\n WHERE FILE_DATE = \'@FILE_DATE\') T\n WHERE T.ITEM_CODE IN (\'311\',\'312\',\'313\')\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\nWHERE T1.RESULT_CODE = \'0\'\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.040', 't_r_g06a_2', '期末余额（穿透后）(3.1.3 合计)=(3.1.1 创业投资基金)+(3.1.2 政府出资产业投资基金)', '期末余额（穿透后）(3.1.3 合计)=(3.1.1 创业投资基金)+(3.1.2 政府出资产业投资基金)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'313\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'311\',\'312\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'313\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'311\',\'312\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'313\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'311\',\'312\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'311\',\'312\',\'313\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.041', 't_r_g06a_2', '期末余额（穿透后）(3.2.6 合计)=(3.2.1 优先股)+(3.2.2 永续债)+(3.2.3 二级资本债)+(3.2.4 可转债)+(3.2.5 其他银行资本补充工具)', '期末余额（穿透后）(3.2.6 合计)=(3.2.1 优先股)+(3.2.2 永续债)+(3.2.3 二级资本债)+(3.2.4 可转债)+(3.2.5 其他银行资本补充工具)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'326\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'321\',\'322\',\'323\',\'324\',\'325\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'326\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'321\',\'322\',\'323\',\'324\',\'325\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'326\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'321\',\'322\',\'323\',\'324\',\'325\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'321\',\'322\',\'323\',\'324\',\'325\',\'326\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.042', 't_r_g06a_2', '期末余额（穿透前）(1.12.1 私募证券投资基金)=(其中：1.12.1.1 权益类基金)+(1.12.1.2 固收类基金)+(1.12.1.3 混合类基金)+(1.12.1.4 期货类及其他衍生品类基金)+(1.12.1.5 其他类基金)', '期末余额（穿透前）(1.12.1 私募证券投资基金)=(其中：1.12.1.1 权益类基金)+(1.12.1.2 固收类基金)+(1.12.1.3 混合类基金)+(1.12.1.4 期货类及其他衍生品类基金)+(1.12.1.5 其他类基金)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1121\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'11211\',\'11212\',\'11213\',\'11214\',\'11215\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1121\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'11211\',\'11212\',\'11213\',\'11214\',\'11215\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1121\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'11211\',\'11212\',\'11213\',\'11214\',\'11215\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'11211\',\'11212\',\'11213\',\'11214\',\'11215\',\'1121\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.043', 't_r_g06a_2', '期末余额（穿透前）(1.12.2 私募股权投资基金)=(其中：1.12.2.1 上市公司定增基金)+(1.12.2.2 并购基金)+(1.12.2.3 房地产基金)+(1.12.2.4 基础设施基金)+(1.12.2.5 其他类基金)', '期末余额（穿透前）(1.12.2 私募股权投资基金)=(其中：1.12.2.1 上市公司定增基金)+(1.12.2.2 并购基金)+(1.12.2.3 房地产基金)+(1.12.2.4 基础设施基金)+(1.12.2.5 其他类基金)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1122\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'11221\',\'11222\',\'11223\',\'11224\',\'11225\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1122\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'11221\',\'11222\',\'11223\',\'11224\',\'11225\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1122\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'11221\',\'11222\',\'11223\',\'11224\',\'11225\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'11221\',\'11222\',\'11223\',\'11224\',\'11225\',\'1122\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.044', 't_r_g06a_2', '期末余额（穿透前）(1.12.9 合计)=(1.12.1 私募证券投资基金)+(1.12.2 私募股权投资基金)+(1.12.3 创业投资基金)+(1.12.4 其他私募投资基金)+(1.12.5 私募证券类FOF基金)+(1.12.6 私募股权投资类FOF基金)+(1.12.7 创业投资类FOF基金)+(1.12.8 其他私募投资类FOF基金)', '期末余额（穿透前）(1.12.9 合计)=(1.12.1 私募证券投资基金)+(1.12.2 私募股权投资基金)+(1.12.3 创业投资基金)+(1.12.4 其他私募投资基金)+(1.12.5 私募证券类FOF基金)+(1.12.6 私募股权投资类FOF基金)+(1.12.7 创业投资类FOF基金)+(1.12.8 其他私募投资类FOF基金)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1129\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'1121\',\'1122\',\'1123\',\'1124\',\'1125\',\'1126\',\'1127\',\'1128\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1129\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'1121\',\'1122\',\'1123\',\'1124\',\'1125\',\'1126\',\'1127\',\'1128\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1129\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'1121\',\'1122\',\'1123\',\'1124\',\'1125\',\'1126\',\'1127\',\'1128\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1121\',\'1122\',\'1123\',\'1124\',\'1125\',\'1126\',\'1127\',\'1128\',\'1129\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.045', 't_r_g06a_2', '期末余额（穿透前）(1.13.7 合计)=(1.13.1 信托产品)+(1.13.2 券商资产管理产品)+(1.13.3 基金资产管理产品)+(1.13.4 期货资产管理产品)+(1.13.5 保险资产管理产品)+(1.13.6 其他资产管理产品)', '期末余额（穿透前）(1.13.7 合计)=(1.13.1 信托产品)+(1.13.2 券商资产管理产品)+(1.13.3 基金资产管理产品)+(1.13.4 期货资产管理产品)+(1.13.5 保险资产管理产品)+(1.13.6 其他资产管理产品)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1137\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'1131\',\'1132\',\'1133\',\'1134\',\'1135\',\'1136\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1137\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'1131\',\'1132\',\'1133\',\'1134\',\'1135\',\'1136\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1137\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'1131\',\'1132\',\'1133\',\'1134\',\'1135\',\'1136\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1131\',\'1132\',\'1133\',\'1134\',\'1135\',\'1136\',\'1137\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.046', 't_r_g06a_2', '期末余额（穿透前）(1.13.1 信托产品)=(其中:1.13.1.1 自主管理)+(1.13.1.2 委托管理 )', '期末余额（穿透前）(1.13.1 信托产品)=(其中:1.13.1.1 自主管理)+(1.13.1.2 委托管理 )', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1131\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'11311\',\'11312\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1131\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'11311\',\'11312\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1131\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'11311\',\'11312\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1131\',\'11311\',\'11312\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.047', 't_r_g06a_2', '期末余额（穿透前）(1.13.2 券商资产管理产品)=(其中:1.13.2.1 自主管理)+(1.13.2.2 委托管理)', '期末余额（穿透前）(1.13.2 券商资产管理产品)=(其中:1.13.2.1 自主管理)+(1.13.2.2 委托管理)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1132\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'11321\',\'11322\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1132\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'11321\',\'11322\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1132\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'11321\',\'11322\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1132\',\'11321\',\'11322\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.048', 't_r_g06a_2', '期末余额（穿透前）(1.13.3 基金资产管理产品)=(其中:1.13.3.1 自主管理)+(1.13.3.2 委托管理)', '期末余额（穿透前）(1.13.3 基金资产管理产品)=(其中:1.13.3.1 自主管理)+(1.13.3.2 委托管理)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1133\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'11331\',\'11332\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1133\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'11331\',\'11332\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1133\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'11331\',\'11332\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1133\',\'11331\',\'11332\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.049', 't_r_g06a_2', '期末余额（穿透前）(1.13.4 期货资产管理产品)=(其中:1.13.4.1 自主管理)+(1.13.4.2 委托管理)', '期末余额（穿透前）(1.13.4 期货资产管理产品)=(其中:1.13.4.1 自主管理)+(1.13.4.2 委托管理)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1134\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'11341\',\'11342\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1134\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'11341\',\'11342\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1134\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'11341\',\'11342\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1134\',\'11341\',\'11342\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.050', 't_r_g06a_2', '期末余额（穿透前）(1.13.5 保险资产管理产品)=(其中:1.13.5.1 自主管理)+(1.13.5.2 委托管理)', '期末余额（穿透前）(1.13.5 保险资产管理产品)=(其中:1.13.5.1 自主管理)+(1.13.5.2 委托管理)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1135\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'11351\',\'11352\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1135\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'11351\',\'11352\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1135\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'11351\',\'11352\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1135\',\'11351\',\'11352\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.051', 't_r_g06a_2', '期末余额（穿透前）(1.13.6 其他资产管理产品)=(其中:1.13.6.1 自主管理)+(1.13.6.2 委托管理)', '期末余额（穿透前）(1.13.6 其他资产管理产品)=(其中:1.13.6.1 自主管理)+(1.13.6.2 委托管理)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1136\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'11361\',\'11362\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1136\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'11361\',\'11362\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1136\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'11361\',\'11362\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1136\',\'11361\',\'11362\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.052', 't_r_g06a_2', '期末余额（穿透前）(1.14.8 合计)=(1.14.1 银行)+(1.14.2 信托公司)+(1.14.3 证券公司)+(1.14.4 基金公司)+(1.14.5 期货公司)+(1.14.6 保险公司)+(1.14.7 其他)', '期末余额（穿透前）(1.14.8 合计)=(1.14.1 银行)+(1.14.2 信托公司)+(1.14.3 证券公司)+(1.14.4 基金公司)+(1.14.5 期货公司)+(1.14.6 保险公司)+(1.14.7 其他)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'1148\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE in (\'1141\',\'1142\',\'1143\',\'1144\',\'1145\',\'1146\',\'1147\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'1148\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE in (\'1141\',\'1142\',\'1143\',\'1144\',\'1145\',\'1146\',\'1147\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'1148\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE in (\'1141\',\'1142\',\'1143\',\'1144\',\'1145\',\'1146\',\'1147\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1141\',\'1142\',\'1143\',\'1144\',\'1145\',\'1146\',\'1147\',\'1148\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.053', 't_r_g06a_2', '期末余额（穿透前）(1.15 合计)=(1.1.6 合计)+(1.2.3 合计)+(1.3.3 合计)+(1.4.14 合计)+(1.5.17 合计)+(1.6.5 合计)+(1.7.8 合计)+(1.8.11 合计)+(1.9.4 合计)+(1.10.7 合计)+(1.11.7 合计)+(1.12.9 合计)+(1.13.7 合计)+(1.14.8 合计)', '期末余额（穿透前）(1.15 合计)=(1.1.6 合计)+(1.2.3 合计)+(1.3.3 合计)+(1.4.14 合计)+(1.5.17 合计)+(1.6.5 合计)+(1.7.8 合计)+(1.8.11 合计)+(1.9.4 合计)+(1.10.7 合计)+(1.11.7 合计)+(1.12.9 合计)+(1.13.7 合计)+(1.14.8 合计)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2022-03-15 11:01:12', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\nFROM (SELECT CASE\n WHEN SUM(IF(T.ITEM_CODE =\'115\', T.V, 0)) =\n SUM(IF(T.ITEM_CODE in (\'116\',\'123\',\'133\',\'1414\',\'1517\',\'165\',\'178\',\'1811\',\'194\',\'1107\',\'1117\',\'1129\',\'1137\',\'1148\'), T.V, 0)) THEN\n 1\n ELSE\n 0\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\n T.FUND_CATEGORY AS INSTI_TYPE,\n SUM(IF(T.ITEM_CODE =\'115\', T.V, 0)) AS VALUE1,\n SUM(IF(T.ITEM_CODE in (\'116\',\'123\',\'133\',\'1414\',\'1517\',\'165\',\'178\',\'1811\',\'194\',\'1107\',\'1117\',\'1129\',\'1137\',\'1148\'), T.V, 0)) AS VALUE2,\n ABS(SUM(IF(T.ITEM_CODE =\'115\', T.V, 0)) -\n SUM(IF(T.ITEM_CODE in (\'116\',\'123\',\'133\',\'1414\',\'1517\',\'165\',\'178\',\'1811\',\'194\',\'1107\',\'1117\',\'1129\',\'1137\',\'1148\'), T.V, 0))) AS VALUE3\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\n FROM t_r_g06a_2\n WHERE FILE_DATE = \'@FILE_DATE\'\nAND ITEM_NAME <> \'1.1.5 他行发行的大额存单\') T\n WHERE T.ITEM_CODE IN (\'115\',\'116\',\'123\',\'133\',\'1414\',\'1517\',\'165\',\'178\',\'1811\',\'194\',\'1107\',\'1117\',\'1129\',\'1137\',\'1148\')\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\nWHERE T1.RESULT_CODE = \'0\'\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.054', 't_r_g06a_2', '期末余额（穿透前）(其中：1.15.b 投向市场化债转股相关产品的部分)<=(1.15 合计)', '期末余额（穿透前）(其中：1.15.b 投向市场化债转股相关产品的部分)<=(1.15 合计)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2022-03-15 11:01:48', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\nFROM (SELECT CASE\n WHEN SUM(IF(T.ITEM_CODE =\'115b\', T.V, 0)) <=\n SUM(IF(T.ITEM_CODE =\'115\', T.V, 0)) THEN\n 1\n ELSE\n 0\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\n T.FUND_CATEGORY AS INSTI_TYPE,\n SUM(IF(T.ITEM_CODE =\'115b\', T.V, 0)) AS VALUE1,\n SUM(IF(T.ITEM_CODE =\'115\', T.V, 0)) AS VALUE2,\n ABS(SUM(IF(T.ITEM_CODE =\'115b\', T.V, 0)) -\n SUM(IF(T.ITEM_CODE =\'115\', T.V, 0))) AS VALUE3\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\n FROM t_r_g06a_2\n WHERE FILE_DATE = \'@FILE_DATE\'\nAND ITEM_NAME <> \'1.1.5 他行发行的大额存单\') T\n WHERE T.ITEM_CODE IN (\'115\',\'115b\')\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\nWHERE T1.RESULT_CODE = \'0\'\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.055', 't_r_g06a_2', '期末余额（穿透前）( 其中：1.12.9.a投向金融资产投资公司或其附属机构发行的私募股权投资基金)+(其中：1.13.7.a投向金融资产投资公司发行的私募资产管理产品)<=(其中：1.15.b 投向市场化债转股相关产品的部分)', '期末余额（穿透前）( 其中：1.12.9.a投向金融资产投资公司或其附属机构发行的私募股权投资基金)+(其中：1.13.7.a投向金融资产投资公司发行的私募资产管理产品)<=(其中：1.15.b 投向市场化债转股相关产品的部分)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE IN (\'1129a\',\'1137a\'), T.V, 0)) <=\r\n SUM(IF(T.ITEM_CODE =\'115b\', T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_BEF_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE IN (\'1129a\',\'1137a\'), T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE =\'115b\', T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE IN (\'1129a\',\'1137a\'), T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE =\'115b\', T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',2), 2) AS ITEM_CODE,\r\n END_BAL_BEF_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1129a\',\'1137a\',\'115b\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.056', 't_r_g06a_2', '期末余额（穿透后）(其中：1.5.a 投向地方政府融资平台的部分) <=（1.5.17 合计）', '期末余额（穿透后）(其中：1.5.a 投向地方政府融资平台的部分) <=（1.5.17 合计）', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'15a\', T.V, 0)) <=\r\n SUM(IF(T.ITEM_CODE =\'1517\', T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'15a\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE =\'1517\', T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'15a\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE =\'1517\', T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'15a\',\'1517\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.057', 't_r_g06a_2', '期末余额（穿透后）(其中：1.15.a 投向“公共私营合作项目”（PPP）的部分）<=（1.15 合计）', '期末余额（穿透后）(其中：1.15.a 投向“公共私营合作项目”（PPP）的部分）<=（1.15 合计）', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2022-03-15 14:13:47', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\nFROM (SELECT CASE\n WHEN SUM(IF(T.ITEM_CODE =\'115a\', T.V, 0)) <=\n SUM(IF(T.ITEM_CODE =\'115\', T.V, 0)) THEN\n 1\n ELSE\n 0\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\n T.FUND_CATEGORY AS INSTI_TYPE,\n SUM(IF(T.ITEM_CODE =\'115a\', T.V, 0)) AS VALUE1,\n SUM(IF(T.ITEM_CODE =\'115\', T.V, 0)) AS VALUE2,\n ABS(SUM(IF(T.ITEM_CODE =\'115a\', T.V, 0)) -\n SUM(IF(T.ITEM_CODE =\'115\', T.V, 0))) AS VALUE3\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\n FROM t_r_g06a_2\n WHERE FILE_DATE = \'@FILE_DATE\'\nAND ITEM_NAME <> \'1.1.5 他行发行的大额存单\') T\n WHERE T.ITEM_CODE IN (\'115a\',\'115\')\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\nWHERE T1.RESULT_CODE = \'0\'\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.058', 't_r_g06a_2', '期末余额（穿透后）(1.15 合计)=(1.1.6 合计)+(1.2.3 合计)+(1.3.3 合计)+(1.4.14 合计)+(1.5.17 合计)+(1.6.5 合计)+(1.7.8 合计)+(1.8.11 合计)+(1.9.4 合计)+(1.10.7 合计)+(1.11.7 合计)', '期末余额（穿透后）(1.15 合计)=(1.1.6 合计)+(1.2.3 合计)+(1.3.3 合计)+(1.4.14 合计)+(1.5.17 合计)+(1.6.5 合计)+(1.7.8 合计)+(1.8.11 合计)+(1.9.4 合计)+(1.10.7 合计)+(1.11.7 合计)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2022-03-15 11:03:04', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\nFROM (SELECT CASE\n WHEN SUM(IF(T.ITEM_CODE =\'115\', T.V, 0)) =\n SUM(IF(T.ITEM_CODE IN (\'116\',\'123\',\'133\',\'1414\',\'1517\',\'165\',\'178\',\'1811\',\'194\',\'1107\',\'1117\'), T.V, 0)) THEN\n 1\n ELSE\n 0\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\n T.FUND_CATEGORY AS INSTI_TYPE,\n SUM(IF(T.ITEM_CODE =\'115\', T.V, 0)) AS VALUE1,\n SUM(IF(T.ITEM_CODE IN (\'116\',\'123\',\'133\',\'1414\',\'1517\',\'165\',\'178\',\'1811\',\'194\',\'1107\',\'1117\'), T.V, 0)) AS VALUE2,\n ABS(SUM(IF(T.ITEM_CODE =\'115\', T.V, 0)) -\n SUM(IF(T.ITEM_CODE IN (\'116\',\'123\',\'133\',\'1414\',\'1517\',\'165\',\'178\',\'1811\',\'194\',\'1107\',\'1117\'), T.V, 0))) AS VALUE3\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\n FROM t_r_g06a_2\n WHERE FILE_DATE = \'@FILE_DATE\'\nAND ITEM_NAME <> \'1.1.5 他行发行的大额存单\') T\n WHERE T.ITEM_CODE IN (\'115\',\'116\',\'123\',\'133\',\'1414\',\'1517\',\'165\',\'178\',\'1811\',\'194\',\'1107\',\'1117\')\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\nWHERE T1.RESULT_CODE = \'0\'\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.059', 't_r_g06a_2', '期末余额（穿透后）(3.2.6 合计)=(3.2.1 优先股)+(3.2.2 永续债)+(3.2.3 二级资本债)+(3.2.4 可转债)+(3.2.5 其他银行资本补充工具)', '期末余额（穿透后）(3.2.6 合计)=(3.2.1 优先股)+(3.2.2 永续债)+(3.2.3 二级资本债)+(3.2.4 可转债)+(3.2.5 其他银行资本补充工具)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'326\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'321\',\'322\',\'323\',\'324\',\'325\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'326\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'321\',\'322\',\'323\',\'324\',\'325\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'326\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'321\',\'322\',\'323\',\'324\',\'325\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'321\',\'322\',\'323\',\'324\',\'325\',\'326\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.060', 't_r_g06a_2', '期末余额（穿透后）(3.3.9 合计)=(3.3.1 农林牧渔业)+(3.3.2 制造业)+(3.3.3 采矿业)+(3.3.4 建筑业)+(3.3.5 基础设施建设)+(3.3.6 房地产业)+(3.3.7 金融业)+(3.3.8 其他服务业)', '期末余额（穿透后）(3.3.9 合计)=(3.3.1 农林牧渔业)+(3.3.2 制造业)+(3.3.3 采矿业)+(3.3.4 建筑业)+(3.3.5 基础设施建设)+(3.3.6 房地产业)+(3.3.7 金融业)+(3.3.8 其他服务业)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'339\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE IN (\'331\',\'332\',\'333\',\'334\',\'335\',\'336\',\'337\',\'338\'), T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'339\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE IN (\'331\',\'332\',\'333\',\'334\',\'335\',\'336\',\'337\',\'338\'), T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'339\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE IN (\'331\',\'332\',\'333\',\'334\',\'335\',\'336\',\'337\',\'338\'), T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'331\',\'332\',\'333\',\'334\',\'335\',\'336\',\'337\',\'338\',\'339\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.061', 't_r_g06a_2', '期末余额（穿透后）(3.3.9 合计)=(1.5.17 合计)', '期末余额（穿透后）(3.3.9 合计)=(1.5.17 合计)', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE\r\nFROM (SELECT CASE\r\n WHEN SUM(IF(T.ITEM_CODE =\'339\', T.V, 0)) =\r\n SUM(IF(T.ITEM_CODE =\'1517\', T.V, 0)) THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE, GROUP_CONCAT(DISTINCT T.N_ID) AS N_ID_LIST,\r\n \'END_BAL_AFT_PENET\' AS COLUMN_CODE, FILE_DATE,\r\n T.FUND_CATEGORY AS INSTI_TYPE,\r\n SUM(IF(T.ITEM_CODE =\'339\', T.V, 0)) AS VALUE1,\r\n SUM(IF(T.ITEM_CODE =\'1517\', T.V, 0)) AS VALUE2,\r\n ABS(SUM(IF(T.ITEM_CODE =\'339\', T.V, 0)) -\r\n SUM(IF(T.ITEM_CODE =\'1517\', T.V, 0))) AS VALUE3\r\n FROM (SELECT FILE_DATE , NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\n WHERE FILE_DATE = \'@FILE_DATE\') T\r\n WHERE T.ITEM_CODE IN (\'1517\',\'339\')\r\n GROUP BY FILE_DATE , FUND_CATEGORY) T1\r\nWHERE T1.RESULT_CODE = \'0\'\r\nGROUP BY T1.FILE_DATE, T1.INSTI_TYPE');
INSERT INTO ``(`RULE_CODE`, `REPORT_CODE`, `RULE_NAME`, `RULE_DESC`, `RULE_TYPE`, `STATUS`, `COL_CODE`, `EXP_TYPE`, `EXP_DEFINE`, `EXP_PARAM`, `UNION_TYPE`, `RULE_FORMULA`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `RULE_LEVEL`, `RULE_CODE_CREATE_TYPE`, `RULE_SQL`) VALUES ('LCZX.A.043.068', 't_r_g06a_2', '《理财子公司非保本理财业务月度统计表 资产负债情况》 1.15B 应与《理财子公司产品情况月度统计表 投资资产情况》 7A 相等', '《理财子公司非保本理财业务月度统计表 资产负债情况》 1.15B 应与《理财子公司产品情况月度统计表 投资资产情况》 7A 相等', 'sql', '1', '', NULL, NULL, NULL, '0', NULL, 'admin', '2021-09-22 11:30:33', 'admin', '2021-09-22 14:40:03', '严重', 'A', 'SELECT \'@BATCH_ID\' AS BATCH_ID, \'@RULE_CODE\' AS RULE_CODE, MAX(N_ID_LIST) AS N_ID_LIST,\r\n MAX(COLUMN_CODE) AS COLUMN_CODE, MAX(RESULT_CODE) AS RESULT_CODE, FILE_DATE, INSTI_TYPE,\r\n MAX(VALUE1) AS LEFT_CALCULATION_VALUE,\r\n MAX(VALUE2) AS RIGHT_CALCULATION_VALUE, MAX(VALUE3) AS DIFFERENCE FROM(\r\nSELECT CASE\r\n WHEN IFNULL(A2.V,0) = IFNULL(A1.V,0)THEN\r\n 1\r\n ELSE\r\n 0\r\n END AS RESULT_CODE,GROUP_CONCAT(DISTINCT A2.N_ID) AS N_ID_LIST,\r\n\'END_BAL_AFT_PENET\' AS COLUMN_CODE,A2.FILE_DATE AS FILE_DATE,\r\nA2.FUND_CATEGORY AS INSTI_TYPE,\r\nIFNULL(A2.V,0) AS VALUE1,\r\nIFNULL(A1.V,0) AS VALUE2,\r\nABS(IFNULL(A2.V,0)-IFNULL(A1.V,0)) AS VALUE3\r\nFROM (\r\n(SELECT FILE_DATE,NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,\r\n ALL_PRO AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_lc_invest_asset\r\nWHERE FILE_DATE=\'@FILE_DATE\'\r\nAND NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2)=\'7\')A1\r\nRIGHT JOIN\r\n(SELECT FILE_DATE,NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2) AS ITEM_CODE,ITEM_NAME,\r\n END_BAL_AFT_PENET AS V, N_ID, FUND_CATEGORY\r\n FROM t_r_g06a_2\r\nWHERE FILE_DATE=\'@FILE_DATE\'\r\nAND ITEM_NAME <>\'1.1.5 他行发行的大额存单\'\r\nAND NUM_CHAR_EXTRACT(SUBSTRING_INDEX(ltrim(ITEM_NAME),\' \',1), 2)=\'115\') A2\r\nON a1.FILE_DATE=a2.FILE_DATE ))T\r\nWHERE T.RESULT_CODE=\'0\'\r\nGROUP BY T.FILE_DATE,T.INSTI_TYPE');gouji开发sql15
最新推荐文章于 2024-07-24 14:50:40 发布
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
