-- 取数类型
DELETE FROM t_ai_amounttype WHERE FID = 1266768924964473856;
INSERT INTO t_ai_amounttype(FID,FCREATETIME,FMODIFIERID,FBIZAPP,FMODIFYTIME,FORGID,FMASTERID,FNUMBER,FNAME) VALUES (1266768924964473856,{ts'2021-10-14  00:00:00'},0,'0=GV6L3QZ3D+',{ts'2021-10-15  00:00:00'},0,1266768924964473856,'preset','preset');

--取数类型分录
DELETE FROM t_ai_amounttypeentry WHERE FENTRYID = 1336943339915862017;
INSERT INTO t_ai_amounttypeentry(FID,FCREATETIME,FMODIFIERID,FBIZAPP,FENTRYID,FSEQ,FMODIFYTIME,FORGID,FMASTERID,FNUMBER,FNAME) VALUES (1266768924964473856,NULL,0,' ',1336943339915862017,2,NULL,0,0,'paybill','应付票据');
DELETE FROM t_ai_amounttypeentry WHERE FENTRYID = 1336943339915862016;
INSERT INTO t_ai_amounttypeentry(FID,FCREATETIME,FMODIFIERID,FBIZAPP,FENTRYID,FSEQ,FMODIFYTIME,FORGID,FMASTERID,FNUMBER,FNAME) VALUES (1266768924964473856,NULL,0,' ',1336943339915862016,1,NULL,0,0,'recbill','应收票据');

--取数类型分录多语言
DELETE FROM T_AI_AMOUNTTYPEENTRY_L WHERE FPKID = '267538B83LX4';
INSERT INTO T_AI_AMOUNTTYPEENTRY_L(FPKID,FLOCALEID,FENTRYID,FNAME) VALUES ('267538B83LX4','zh_CN',1336943339915862016,'应收票据');
DELETE FROM T_AI_AMOUNTTYPEENTRY_L WHERE FPKID = '267538B83LX5';
INSERT INTO T_AI_AMOUNTTYPEENTRY_L(FPKID,FLOCALEID,FENTRYID,FNAME) VALUES ('267538B83LX5','zh_TW',1336943339915862016,'應收票據');
DELETE FROM T_AI_AMOUNTTYPEENTRY_L WHERE FPKID = '267538B83LX6';
INSERT INTO T_AI_AMOUNTTYPEENTRY_L(FPKID,FLOCALEID,FENTRYID,FNAME) VALUES ('267538B83LX6','zh_CN',1336943339915862017,'应付票据');
DELETE FROM T_AI_AMOUNTTYPEENTRY_L WHERE FPKID = '267538B83LX7';
INSERT INTO T_AI_AMOUNTTYPEENTRY_L(FPKID,FLOCALEID,FENTRYID,FNAME) VALUES ('267538B83LX7','zh_TW',1336943339915862017,'應付票據');

--取数规则对账维度
DELETE FROM t_ai_recdatarule_assist WHERE FPKID = 1336967948660793344;
INSERT INTO t_ai_recdatarule_assist(FID,FBASEDATAID,FPKID) VALUES (1336967948618850304,'bd_currency',1336967948660793344);

--通用设置的对账维度
DELETE FROM t_ai_rec_common_assist WHERE FPKID = 1336938549123112961;
INSERT INTO t_ai_rec_common_assist(FID,FBASEDATAID,FPKID) VALUES (1336938549123112960,'bd_currency',1336938549123112961);
DELETE FROM t_ai_rec_common_assist WHERE FPKID = 1336939394669524993;
INSERT INTO t_ai_rec_common_assist(FID,FBASEDATAID,FPKID) VALUES (1336939394669524992,'bd_currency',1336939394669524993);
DELETE FROM t_ai_rec_common_assist WHERE FPKID = 1336939911030398976;
INSERT INTO t_ai_rec_common_assist(FID,FBASEDATAID,FPKID) VALUES (1336939911022010368,'bd_currency',1336939911030398976);
DELETE FROM t_ai_rec_common_assist WHERE FPKID = 1336946015260948480;
INSERT INTO t_ai_rec_common_assist(FID,FBASEDATAID,FPKID) VALUES (1336946015244171264,'bd_currency',1336946015260948480);
DELETE FROM t_ai_rec_common_assist WHERE FPKID = 1336948766489491457;
INSERT INTO t_ai_rec_common_assist(FID,FBASEDATAID,FPKID) VALUES (1336948766489491456,'bd_currency',1336948766489491457);

--通用设置 将 13466739 改为 0
DELETE FROM t_ai_rec_common_filter WHERE FID = 1336948766489491456;
INSERT INTO t_ai_rec_common_filter(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (1336948766489491456,{ts'2022-01-19  00:00:00'},0,'company',{ts'2022-01-19  00:00:00'},'bizdate','1',0,1336948766489491456,'cdm_drafttradebill',' ','billdealbus');
DELETE FROM t_ai_rec_common_filter WHERE FID = 1336946015244171264;
INSERT INTO t_ai_rec_common_filter(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (1336946015244171264,{ts'2022-01-19  00:00:00'},0,'company',{ts'2022-01-19  00:00:00'},' ','1',0,1336946015244171264,'cdm_drafttradebill',' ','balancebus_end');
DELETE FROM t_ai_rec_common_filter WHERE FID = 1336939394669524992;
INSERT INTO t_ai_rec_common_filter(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (1336939394669524992,{ts'2022-01-19  00:00:00'},0,'company',{ts'2022-01-19  00:00:00'},'bizdate','1',0,1336939394669524992,'cdm_draftbillf7',' ','billpay');
DELETE FROM t_ai_rec_common_filter WHERE FID = 1336938549123112960;
INSERT INTO t_ai_rec_common_filter(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (1336938549123112960,{ts'2022-01-19  00:00:00'},0,'company',{ts'2022-01-19  00:00:00'},'bizdate','1',0,1336938549123112960,'cdm_draftbillf7',' ','billrec');
DELETE FROM t_ai_rec_common_filter WHERE FID = 1336939911022010368;
INSERT INTO t_ai_rec_common_filter(FID,FCREATETIME,FMODIFIERID,FBIZORG,FMODIFYTIME,FBIZDATE,FPRESET,FORGID,FMASTERID,FENTITY,FPERIOD,FNUMBER) VALUES (1336939911022010368,{ts'2022-01-19  00:00:00'},0,'company',{ts'2022-01-19  00:00:00'},' ','1',0,1336939911022010368,'cdm_draftbillf7',' ','balancebill_end');

--通用设置多语言
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '26747AUGMCWR';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1336938549123112960,'26747AUGMCWR','zh_CN','收入票据');
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '26747AUGMCWS';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1336938549123112960,'26747AUGMCWS','zh_TW','收入票據');
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '2674CH42OPEP';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1336939394669524992,'2674CH42OPEP','zh_CN','支出票据');
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '2674CH42OPEQ';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1336939394669524992,'2674CH42OPEQ','zh_TW','支出票據');
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '2674G8W5Z8T6';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1336939911022010368,'2674G8W5Z8T6','zh_CN','票据期末余额');
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '2674G8W5Z8T7';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1336939911022010368,'2674G8W5Z8T7','zh_TW','票據期末餘額');
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '26763SIO4SCW';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1336948766489491456,'26763SIO4SCW','zh_CN','票据业务处理');
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '26763SIO4SCX';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1336948766489491456,'26763SIO4SCX','zh_TW','票據業務處理');
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '2675LQNEM603';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1336946015244171264,'2675LQNEM603','zh_CN','票据期末余额(业务)');
DELETE FROM T_AI_REC_COMMON_FILTER_L WHERE FPKID = '2675LQNEM604';
INSERT INTO T_AI_REC_COMMON_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1336946015244171264,'2675LQNEM604','zh_TW','票據期末餘額(業務)');

-- 通用设置的分录
DELETE FROM t_ai_rec_common_entry WHERE FENTRYID = 1336938549123004418;
INSERT INTO t_ai_rec_common_entry(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (1336938549123112960,' ',' ',1336938549123004418,1,'currency',' ',' ',' ',' ',' ');
DELETE FROM t_ai_rec_common_entry WHERE FENTRYID = 1336939394669633538;
INSERT INTO t_ai_rec_common_entry(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (1336939394669524992,' ',' ',1336939394669633538,1,'currency',' ',' ',' ',' ',' ');
DELETE FROM t_ai_rec_common_entry WHERE FENTRYID = 1336939911030290434;
INSERT INTO t_ai_rec_common_entry(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (1336939911022010368,' ',' ',1336939911030290434,1,'currency',' ',' ',' ',' ',' ');
DELETE FROM t_ai_rec_common_entry WHERE FENTRYID = 1336946015261057026;
INSERT INTO t_ai_rec_common_entry(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (1336946015244171264,' ',' ',1336946015261057026,1,'currency',' ',' ',' ',' ',' ');
DELETE FROM t_ai_rec_common_entry WHERE FENTRYID = 1336948766489600002;
INSERT INTO t_ai_rec_common_entry(FID,FBIZASSIST6,FBIZASSIST7,FENTRYID,FSEQ,FBIZASSIST0,FBIZASSIST1,FBIZASSIST2,FBIZASSIST3,FBIZASSIST4,FBIZASSIST5) VALUES (1336948766489491456,' ',' ',1336948766489600002,1,'currency',' ',' ',' ',' ',' ');

--取数规则
DELETE FROM t_ai_recdatarule WHERE FID = 1336967948618850304;
INSERT INTO t_ai_recdatarule(FID,FCREATEORGID,FORGID,FMASTERID,FAMOUNTTYPE,FSTATUS,FCTRLSTRATEGY,FNUMBER,FUSEORG,FCREATETIME,FMODIFIERID,FENABLE,FBIZAPP,FMODIFYTIME,FPRESET,FCREATORID) VALUES (1336967948618850304,100000,100000,1336967948618850304,0,'C','6','BILL001ForPreset',100000,{ts'2022-01-19  00:00:00'},0,'1','0=GV6L3QZ3D+',{ts'2022-01-19  00:00:00'},'1',0);

--取数规则多语言
DELETE FROM T_AI_RECDATARULE_L WHERE FPKID = '2679PJZ=0=CS';
INSERT INTO T_AI_RECDATARULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1336967948618850304,'2679PJZ=0=CS','zh_CN','票据管理(预置)');
DELETE FROM T_AI_RECDATARULE_L WHERE FPKID = '2679PJZ=0=CT';
INSERT INTO T_AI_RECDATARULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1336967948618850304,'2679PJZ=0=CT','zh_TW','票據管理(預置)');

--取数规则分录
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,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,1336946015244171264,'票面金额 ');
DELETE FROM t_ai_recdataruleentry WHERE FENTRYID = 1336967948660684804;
INSERT INTO t_ai_recdataruleentry(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (1336967948618850304,' ',1336967948660684804,'2','cdm_drafttradebill',' ',1336943339915862017,'amount','业务处理 在……中 (票据解付)',' ','{"expression":"","exprTran":"业务处理 在……中 (票据解付)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"26768/LC4BQ2","leftBracket":"","compareType":"17","fieldName":"tradetype","rightBracket":"","logic":"0","value":[{"id":"26768/LC2IBX","value":"payoff"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"26768/LC4BQ2\",\"leftBracket\":\"\",\"compareType\":\"17\",\"fieldName\":\"tradetype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"26768/LC2IBX\",\"value\":\"payoff\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"业务处理 在……中 (票据解付)"},"exprDesc":"业务处理 在……中 (票据解付)"}',3,1336948766489491456,'合计金额');
DELETE FROM t_ai_recdataruleentry WHERE FENTRYID = 1336967948660684805;
INSERT INTO t_ai_recdataruleentry(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (1336967948618850304,' ',1336967948660684805,'3','cdm_draftbillf7',' ',1336943339915862017,'amount','( 收付类型 等于 开票   and    票据状态 在……中 (已登记,已解付) )',' ','{"expression":"","exprTran":"( 收付类型 等于 开票   and    票据状态 在……中 (已登记,已解付) )","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2679C0G4DU0Q","leftBracket":"(","compareType":"105","fieldName":"rptype","rightBracket":"","logic":"0","value":[{"id":"2679C0G4C+OJ","value":"paybill"}],"baseDataIds":[]},{"id":"2679C0G4DU0R","leftBracket":"","compareType":"17","fieldName":"draftbillstatus","rightBracket":")","logic":"0","value":[{"id":"2679C0G4C+OK","value":"registered"},{"id":"2679C0G4DU0S","value":"payoffed"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2679C0G4DU0Q\",\"leftBracket\":\"(\",\"compareType\":\"105\",\"fieldName\":\"rptype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2679C0G4C+OJ\",\"value\":\"paybill\"}],\"baseDataIds\":[]},{\"id\":\"2679C0G4DU0R\",\"leftBracket\":\"\",\"compareType\":\"17\",\"fieldName\":\"draftbillstatus\",\"rightBracket\":\")\",\"logic\":\"0\",\"value\":[{\"id\":\"2679C0G4C+OK\",\"value\":\"registered\"},{\"id\":\"2679C0G4DU0S\",\"value\":\"payoffed\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"( 收付类型 等于 开票   and    票据状态 在……中 (已登记,已解付) )"},"exprDesc":"( 收付类型 等于 开票   and    票据状态 在……中 (已登记,已解付) )"}',4,1336939394669524992,'票面金额');
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,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,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,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,1336939911022010368,'票面金额');
DELETE FROM t_ai_recdataruleentry WHERE FENTRYID = 1336967948660684808;
INSERT INTO t_ai_recdataruleentry(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (1336967948618850304,' ',1336967948660684808,'2','cdm_draftbillf7',' ',1336943339915862016,'amount','收付类型 等于 收票   and    票据状态 在……中 (已登记,已质押,已托管,已背书,已贴现,已托收,已退票)',' ','{"expression":"","exprTran":"收付类型 等于 收票   and    票据状态 在……中 (已登记,已质押,已托管,已背书,已贴现,已托收,已退票)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2679MO2=+ETS","leftBracket":"","compareType":"105","fieldName":"rptype","rightBracket":"","logic":"0","value":[{"id":"2679MO2=095Z","value":"receivebill"}],"baseDataIds":[]},{"id":"2679MO2=+ETT","leftBracket":"","compareType":"17","fieldName":"draftbillstatus","rightBracket":"","logic":"0","value":[{"id":"2679MO2=096+","value":"registered"},{"id":"2679MO2=+ETU","value":"pledged"},{"id":"2679MO2=096/","value":"collocated"},{"id":"2679MO2=+ETV","value":"endorsed"},{"id":"2679MO2=0960","value":"discounted"},{"id":"2679MO2=+ETW","value":"collected"},{"id":"2679MO2=0961","value":"refunded"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2679MO2=+ETS\",\"leftBracket\":\"\",\"compareType\":\"105\",\"fieldName\":\"rptype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2679MO2=095Z\",\"value\":\"receivebill\"}],\"baseDataIds\":[]},{\"id\":\"2679MO2=+ETT\",\"leftBracket\":\"\",\"compareType\":\"17\",\"fieldName\":\"draftbillstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2679MO2=096+\",\"value\":\"registered\"},{\"id\":\"2679MO2=+ETU\",\"value\":\"pledged\"},{\"id\":\"2679MO2=096/\",\"value\":\"collocated\"},{\"id\":\"2679MO2=+ETV\",\"value\":\"endorsed\"},{\"id\":\"2679MO2=0960\",\"value\":\"discounted\"},{\"id\":\"2679MO2=+ETW\",\"value\":\"collected\"},{\"id\":\"2679MO2=0961\",\"value\":\"refunded\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"收付类型 等于 收票   and    票据状态 在……中 (已登记,已质押,已托管,已背书,已贴现,已托收,已退票)"},"exprDesc":"收付类型 等于 收票   and    票据状态 在……中 (已登记,已质押,已托管,已背书,已贴现,已托收,已退票)"}',7,1336938549123112960,'票面金额');
DELETE FROM t_ai_recdataruleentry WHERE FENTRYID = 1336967948660684809;
INSERT INTO t_ai_recdataruleentry(FID,FAMOUNTEXP,FENTRYID,FDATATYPE,FBIZOBJ,FDETAILRULE,FAMOUNTTYPE,FAMOUNTEXP_TAG,FDATAFILTERDESC,FDATAFILTER,FDATAFILTER_TAG,FSEQ,FCOMMONFILTER,FAMOUNT) VALUES (1336967948618850304,' ',1336967948660684809,'3','cdm_drafttradebill',' ',1336943339915862016,'amount','业务处理 在……中 (背书转让,票据贴现,票据托收,票据退票)',' ','{"expression":"","exprTran":"业务处理 在……中 (背书转让,票据贴现,票据托收,票据退票)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2678TIJCG8O7","leftBracket":"","compareType":"17","fieldName":"tradetype","rightBracket":"","logic":"0","value":[{"id":"2678TIJCEEA0","value":"endorse"},{"id":"2678TIJCG8O8","value":"discount"},{"id":"2678TIJCEEA1","value":"collect"},{"id":"2678TIJCG8O9","value":"refund"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2678TIJCG8O7\",\"leftBracket\":\"\",\"compareType\":\"17\",\"fieldName\":\"tradetype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2678TIJCEEA0\",\"value\":\"endorse\"},{\"id\":\"2678TIJCG8O8\",\"value\":\"discount\"},{\"id\":\"2678TIJCEEA1\",\"value\":\"collect\"},{\"id\":\"2678TIJCG8O9\",\"value\":\"refund\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"业务处理 在……中 (背书转让,票据贴现,票据托收,票据退票)"},"exprDesc":"业务处理 在……中 (背书转让,票据贴现,票据托收,票据退票)"}',8,1336948766489491456,'合计金额');
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,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,1336939911022010368,'票面金额');

    