DELETE FROM t_ai_recdataruleentry WHERE FENTRYID = 1336967948660684802;
INSERT INTO t_ai_recdataruleentry(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FDISABLE,FCOMMONFILTER,FAMOUNT) VALUES (1336967948618850304,' ',1336967948660684802,'4','cdm_draftbillf7',' ',1336943339915862017,'amount','收付类型 等于 开票   and    票据状态 在……中 (已登记) 且 登记日期  <=  结束日期 ',' ','{"expression":"bizdate  <=  con_enddata ","exprTran":"收付类型 等于 开票   and    票据状态 在……中 (已登记) 且 登记日期  <=  结束日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2674SMZ==VW2","leftBracket":"","compareType":"105","fieldName":"rptype","rightBracket":"","logic":"0","value":[{"id":"2674SMZ=BP89","value":"paybill"}],"baseDataIds":[]},{"id":"2674SMZ==VW3","leftBracket":"","compareType":"17","fieldName":"draftbillstatus","rightBracket":"","logic":"0","value":[{"id":"2674SMZ=BP8=","value":"registered"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2674SMZ==VW2\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"rptype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2674SMZ=BP89\",\"value\":\"paybill\"}],\"baseDataIds\":[]},{\"id\":\"2674SMZ==VW3\",\"leftBracket\":\"\",\"compareType\":\"17\",\"fieldName\":\"draftbillstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2674SMZ=BP8=\",\"value\":\"registered\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"收付类型 等于 开票   and    票据状态 在……中 (已登记) 且 登记日期  <=  结束日期 "},"exprDesc":"收付类型 等于 开票   and    票据状态 在……中 (已登记) 且 登记日期  <=  结束日期 "}',1,'1',1336939911022010368,'票面金额');
DELETE FROM t_ai_recdataruleentry WHERE FENTRYID = 1336967948660684803;
INSERT INTO t_ai_recdataruleentry(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FDISABLE,FCOMMONFILTER,FAMOUNT) VALUES (1336967948618850304,' ',1336967948660684803,'4','cdm_drafttradebill',' ',1336943339915862017,'draftbill.amount ','业务处理 在……中 (票据解付) 且 业务日期  >  结束日期 ',' ','{"expression":"bizdate  >  con_enddata ","exprTran":"业务处理 在……中 (票据解付) 且 业务日期  >  结束日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2675U5TE0V4Q","leftBracket":"","compareType":"17","fieldName":"tradetype","rightBracket":"","logic":"0","value":[{"id":"2675U5TE//SJ","value":"payoff"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2675U5TE0V4Q\",\"leftBracket\":\"\",\"compareType\":\"17\",\"fieldName\":\"tradetype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2675U5TE//SJ\",\"value\":\"payoff\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"业务处理 在……中 (票据解付) 且 业务日期  >  结束日期 "},"exprDesc":"业务处理 在……中 (票据解付) 且 业务日期  >  结束日期 "}',2,'1',1336946015244171264,'票面金额 ');
DELETE FROM t_ai_recdataruleentry WHERE FENTRYID = 1336967948660684806;
INSERT INTO t_ai_recdataruleentry(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FDISABLE,FCOMMONFILTER,FAMOUNT) VALUES (1336967948618850304,' ',1336967948660684806,'4','cdm_drafttradebill',' ',1336943339915862016,'draftbill.amount','业务处理 在……中 (背书转让,票据贴现,票据托收) 且 业务日期  >  结束日期 ',' ','{"expression":"bizdate  >  con_enddata ","exprTran":"业务处理 在……中 (背书转让,票据贴现,票据托收) 且 业务日期  >  结束日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2677HG59VN1=","leftBracket":"","compareType":"17","fieldName":"tradetype","rightBracket":"","logic":"0","value":[{"id":"2677HG59XGEG","value":"endorse"},{"id":"2677HG59VN1A","value":"discount"},{"id":"2677HG59XGEH","value":"collect"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2677HG59VN1=\",\"leftBracket\":\"\",\"compareType\":\"17\",\"fieldName\":\"tradetype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2677HG59XGEG\",\"value\":\"endorse\"},{\"id\":\"2677HG59VN1A\",\"value\":\"discount\"},{\"id\":\"2677HG59XGEH\",\"value\":\"collect\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"业务处理 在……中 (背书转让,票据贴现,票据托收) 且 业务日期  >  结束日期 "},"exprDesc":"业务处理 在……中 (背书转让,票据贴现,票据托收) 且 业务日期  >  结束日期 "}',5,'1',1336946015244171264,'票面金额');
DELETE FROM t_ai_recdataruleentry WHERE FENTRYID = 1336967948660684807;
INSERT INTO t_ai_recdataruleentry(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FDISABLE,FCOMMONFILTER,FAMOUNT) VALUES (1336967948618850304,' ',1336967948660684807,'4','cdm_draftbillf7',' ',1336943339915862016,'amount','收付类型 等于 收票   and    票据状态 在……中 (已登记,已质押,已托管) 且 登记日期  <=  结束日期 ',' ','{"expression":"bizdate  <=  con_enddata ","exprTran":"收付类型 等于 收票   and    票据状态 在……中 (已登记,已质押,已托管) 且 登记日期  <=  结束日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2678+Y4HE3HL","leftBracket":"","compareType":"105","fieldName":"rptype","rightBracket":"","logic":"0","value":[{"id":"2678+Y4HC=4E","value":"receivebill"}],"baseDataIds":[]},{"id":"2678+Y4HE3HM","leftBracket":"","compareType":"17","fieldName":"draftbillstatus","rightBracket":"","logic":"0","value":[{"id":"2678+Y4HC=4F","value":"registered"},{"id":"2678+Y4HE3HN","value":"pledged"},{"id":"2678+Y4HC=4G","value":"collocated"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2678+Y4HE3HL\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"rptype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2678+Y4HC=4E\",\"value\":\"receivebill\"}],\"baseDataIds\":[]},{\"id\":\"2678+Y4HE3HM\",\"leftBracket\":\"\",\"compareType\":\"17\",\"fieldName\":\"draftbillstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2678+Y4HC=4F\",\"value\":\"registered\"},{\"id\":\"2678+Y4HE3HN\",\"value\":\"pledged\"},{\"id\":\"2678+Y4HC=4G\",\"value\":\"collocated\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"收付类型 等于 收票   and    票据状态 在……中 (已登记,已质押,已托管) 且 登记日期  <=  结束日期 "},"exprDesc":"收付类型 等于 收票   and    票据状态 在……中 (已登记,已质押,已托管) 且 登记日期  <=  结束日期 "}',6,'1',1336939911022010368,'票面金额');
DELETE FROM t_ai_recdataruleentry WHERE FENTRYID = 1566506734858569728;
INSERT INTO t_ai_recdataruleentry(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FDISABLE,FCOMMONFILTER,FAMOUNT) VALUES (1336967948618850304,' ',1566506734858569728,'4','cdm_draftbillf7',' ',1336943339915862016,'amount','收付类型 等于 收票   and    票据状态 在……中 (已登记,已背书,已贴现,已托收) 且 登记日期   <=   结束日期 ',' ','{"expression":"bizdate   <=   con_enddata ","exprTran":"收付类型 等于 收票   and    票据状态 在……中 (已登记,已背书,已贴现,已托收) 且 登记日期   <=   结束日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2XDZL0JU313P","leftBracket":"","compareType":"105","fieldName":"rptype","rightBracket":"","logic":"0","value":[{"id":"2XDZL0JU3TR+","value":"receivebill"}],"baseDataIds":[]},{"id":"2XDZL0JU313Q","leftBracket":"","compareType":"17","fieldName":"draftbillstatus","rightBracket":"","logic":"0","value":[{"id":"2XDZL0JU3TR/","value":"registered"},{"id":"2XDZL0JU313R","value":"endorsed"},{"id":"2XDZL0JU3TR0","value":"discounted"},{"id":"2XDZL0JU313S","value":"collected"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2XDZL0JU313P\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"rptype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2XDZL0JU3TR+\",\"value\":\"receivebill\"}],\"baseDataIds\":[]},{\"id\":\"2XDZL0JU313Q\",\"leftBracket\":\"\",\"compareType\":\"17\",\"fieldName\":\"draftbillstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2XDZL0JU3TR/\",\"value\":\"registered\"},{\"id\":\"2XDZL0JU313R\",\"value\":\"endorsed\"},{\"id\":\"2XDZL0JU3TR0\",\"value\":\"discounted\"},{\"id\":\"2XDZL0JU313S\",\"value\":\"collected\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"收付类型 等于 收票   and    票据状态 在……中 (已登记,已背书,已贴现,已托收) 且 登记日期   <=   结束日期 "},"exprDesc":"收付类型 等于 收票   and    票据状态 在……中 (已登记,已背书,已贴现,已托收) 且 登记日期   <=   结束日期 "}',9,'0',1336939911022010368,'票面金额(子票包金额)');
DELETE FROM t_ai_recdataruleentry WHERE FENTRYID = 1566506734858569729;
INSERT INTO t_ai_recdataruleentry(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FDISABLE,FCOMMONFILTER,FAMOUNT) VALUES (1336967948618850304,' ',1566506734858569729,'4','cdm_drafttradebill',' ',1336943339915862016,' - amount','单据状态 等于 已审核   and    业务处理 在……中 (背书转让,票据贴现,票据托收) 且 业务日期   <=   结束日期 ',' ','{"expression":"bizdate   <=   con_enddata ","exprTran":"单据状态 等于 已审核   and    业务处理 在……中 (背书转让,票据贴现,票据托收) 且 业务日期   <=   结束日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2XDZDFVG54BR","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2XDZDFVG4CQG","value":"C"}],"baseDataIds":[]},{"id":"2XDZDFVG54BS","leftBracket":"","compareType":"17","fieldName":"tradetype","rightBracket":"","logic":"0","value":[{"id":"2XDZDFVG4CQH","value":"endorse"},{"id":"2XDZDFVG54BT","value":"discount"},{"id":"2XDZDFVG4CQI","value":"collect"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2XDZDFVG54BR\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2XDZDFVG4CQG\",\"value\":\"C\"}],\"baseDataIds\":[]},{\"id\":\"2XDZDFVG54BS\",\"leftBracket\":\"\",\"compareType\":\"17\",\"fieldName\":\"tradetype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2XDZDFVG4CQH\",\"value\":\"endorse\"},{\"id\":\"2XDZDFVG54BT\",\"value\":\"discount\"},{\"id\":\"2XDZDFVG4CQI\",\"value\":\"collect\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 等于 已审核   and    业务处理 在……中 (背书转让,票据贴现,票据托收) 且 业务日期   <=   结束日期 "},"exprDesc":"单据状态 等于 已审核   and    业务处理 在……中 (背书转让,票据贴现,票据托收) 且 业务日期   <=   结束日期 "}',10,'0',1336946015244171264,' - 合计金额');
DELETE FROM t_ai_recdataruleentry WHERE FENTRYID = 1566506734858569730;
INSERT INTO t_ai_recdataruleentry(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FDISABLE,FCOMMONFILTER,FAMOUNT) VALUES (1336967948618850304,' ',1566506734858569730,'4','cdm_draftbillf7',' ',1336943339915862017,'amount','收付类型 等于 开票   and    票据状态 在……中 (已登记,已解付) 且 登记日期    <=   结束日期 ',' ','{"expression":"bizdate    <=   con_enddata ","exprTran":"收付类型 等于 开票   and    票据状态 在……中 (已登记,已解付) 且 登记日期    <=   结束日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2XDZR1O09D6U","leftBracket":"","compareType":"105","fieldName":"rptype","rightBracket":"","logic":"0","value":[{"id":"2XDZR1O08MKJ","value":"paybill"}],"baseDataIds":[]},{"id":"2XDZR1O09D6V","leftBracket":"","compareType":"17","fieldName":"draftbillstatus","rightBracket":"","logic":"0","value":[{"id":"2XDZR1O08MKK","value":"registered"},{"id":"2XDZR1O09D6W","value":"payoffed"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2XDZR1O09D6U\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"rptype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2XDZR1O08MKJ\",\"value\":\"paybill\"}],\"baseDataIds\":[]},{\"id\":\"2XDZR1O09D6V\",\"leftBracket\":\"\",\"compareType\":\"17\",\"fieldName\":\"draftbillstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2XDZR1O08MKK\",\"value\":\"registered\"},{\"id\":\"2XDZR1O09D6W\",\"value\":\"payoffed\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"收付类型 等于 开票   and    票据状态 在……中 (已登记,已解付) 且 登记日期    <=   结束日期 "},"exprDesc":"收付类型 等于 开票   and    票据状态 在……中 (已登记,已解付) 且 登记日期    <=   结束日期 "}',11,'0',1336939911022010368,'票面金额(子票包金额)');
DELETE FROM t_ai_recdataruleentry WHERE FENTRYID = 1566506734858569731;
INSERT INTO t_ai_recdataruleentry(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FDISABLE,FCOMMONFILTER,FAMOUNT) VALUES (1336967948618850304,' ',1566506734858569731,'4','cdm_drafttradebill',' ',1336943339915862017,' - amount','单据状态 等于 已审核   and    业务处理 等于 票据解付 且 业务日期   <=   结束日期 ',' ','{"expression":"bizdate   <=   con_enddata ","exprTran":"单据状态 等于 已审核   and    业务处理 等于 票据解付 且 业务日期   <=   结束日期 ","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2XE+/CX+E2JF","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2XE+/CX+DAY5","value":"C"}],"baseDataIds":[]},{"id":"2XE+/CX+E2JG","leftBracket":"","compareType":"105","fieldName":"tradetype","rightBracket":"","logic":"0","value":[{"id":"2XE+/CX+DAY6","value":"payoff"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2XE+/CX+E2JF\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2XE+/CX+DAY5\",\"value\":\"C\"}],\"baseDataIds\":[]},{\"id\":\"2XE+/CX+E2JG\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"tradetype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2XE+/CX+DAY6\",\"value\":\"payoff\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 等于 已审核   and    业务处理 等于 票据解付 且 业务日期   <=   结束日期 "},"exprDesc":"单据状态 等于 已审核   and    业务处理 等于 票据解付 且 业务日期   <=   结束日期 "}',12,'0',1336946015244171264,' - 合计金额');
