DELETE FROM T_CAS_RECONCILIATIONRULE WHERE FID = 876055266653774848;
INSERT INTO T_CAS_RECONCILIATIONRULE(FID,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FORGFIELD,FMASTERID,FSTATUS,FCREATORID,FNUMBER) VALUES (876055266653774848,{ts'2020-04-23  17:25:25'},13466739,'1',{ts'2020-04-23  17:25:25'},100000000000000001,0,' ',13466739,' '); 

DELETE FROM T_CAS_RECONCILIATION_E WHERE FENTRYID = 876055266645386240;
INSERT INTO T_CAS_RECONCILIATION_E(FID,FDATAFILTERDESC_REAL,FDATAFILTERDESC,FENTRYID,FSEQ,FDATAFILTERDESC_REAL_TAG,FRULESNAME) VALUES (876055266653774848,' ','''贷方金额''等于''借方金额'' and ''借方金额''等于''贷方金额'' and ''对方户名''等于''对方户名'' and ''对方账号''等于''对方账号'' and ''日期''等于''业务日期'' and ''摘要''等于''摘要''',876055266645386240,2,'[{"bankjournal":"debitamount","condition":"equals","isnullmatch":false,"bankstatement":"creditamount","num":null},{"bankjournal":"creditamount","condition":"equals","isnullmatch":false,"bankstatement":"debitamount","num":null},{"bankjournal":"oppunit","condition":"equals","isnullmatch":false,"bankstatement":"oppunit","num":null},{"bankjournal":"oppacctnumber","condition":"equals","isnullmatch":false,"bankstatement":"oppaccountnumber","num":null},{"bankjournal":"bizdate","condition":"equals","isnullmatch":false,"bankstatement":"bizdate","num":null},{"bankjournal":"description","condition":"equals","isnullmatch":true,"bankstatement":"description","num":null}]','按对方信息、摘要、日期一致对账'); 
DELETE FROM T_CAS_RECONCILIATION_E WHERE FENTRYID = 876055266645388288;
INSERT INTO T_CAS_RECONCILIATION_E(FID,FDATAFILTERDESC_REAL,FDATAFILTERDESC,FENTRYID,FSEQ,FDATAFILTERDESC_REAL_TAG,FRULESNAME) VALUES (876055266653774848,' ','''对账标识码''等于''对账标识码''',876055266645388288,1,'[{"bankjournal":"bankcheckflag","condition":"equals","isnullmatch":false,"bankstatement":"bankcheckflag","num":null}]','按对账标识码对账'); 
DELETE FROM T_CAS_RECONCILIATION_E WHERE FENTRYID = 876055266645388289;
INSERT INTO T_CAS_RECONCILIATION_E(FID,FDATAFILTERDESC_REAL,FDATAFILTERDESC,FENTRYID,FSEQ,FDATAFILTERDESC_REAL_TAG,FRULESNAME) VALUES (876055266653774848,' ','''贷方金额''等于''借方金额'' and ''借方金额''等于''贷方金额'' and ''对方户名''等于''对方户名'' and ''对方账号''等于''对方账号'' and ''日期''相差小于3天 ''业务日期'' and ''摘要''等于''摘要''',876055266645388289,3,'[{"bankjournal":"debitamount","condition":"equals","isnullmatch":false,"bankstatement":"creditamount","num":null},{"bankjournal":"creditamount","condition":"equals","isnullmatch":false,"bankstatement":"debitamount","num":null},{"bankjournal":"oppunit","condition":"equals","isnullmatch":false,"bankstatement":"oppunit","num":null},{"bankjournal":"oppacctnumber","condition":"equals","isnullmatch":false,"bankstatement":"oppaccountnumber","num":null},{"bankjournal":"bizdate","condition":"diff","isnullmatch":false,"bankstatement":"bizdate","num":"3"},{"bankjournal":"description","condition":"equals","isnullmatch":true,"bankstatement":"description","num":null}]','按对方信息、摘要一致，日期相差小于3天对账'); 
DELETE FROM T_CAS_RECONCILIATION_E WHERE FENTRYID = 876055266645386241;
INSERT INTO T_CAS_RECONCILIATION_E(FID,FDATAFILTERDESC_REAL,FDATAFILTERDESC,FENTRYID,FSEQ,FDATAFILTERDESC_REAL_TAG,FRULESNAME) VALUES (876055266653774848,' ','''贷方金额''等于''借方金额'' and ''借方金额''等于''贷方金额'' and ''对方户名''等于''对方户名'' and ''对方账号''等于''对方账号'' and ''日期''等于''业务日期'' and ''摘要''模糊匹配''摘要''',876055266645386241,4,'[{"bankjournal":"debitamount","condition":"equals","isnullmatch":false,"bankstatement":"creditamount","num":null},{"bankjournal":"creditamount","condition":"equals","isnullmatch":false,"bankstatement":"debitamount","num":null},{"bankjournal":"oppunit","condition":"equals","isnullmatch":false,"bankstatement":"oppunit","num":null},{"bankjournal":"oppacctnumber","condition":"equals","isnullmatch":false,"bankstatement":"oppaccountnumber","num":null},{"bankjournal":"bizdate","condition":"equals","isnullmatch":false,"bankstatement":"bizdate","num":null},{"bankjournal":"description","condition":"like","isnullmatch":true,"bankstatement":"description","num":null}]','按对方信息、日期一致，摘要模糊匹配对账'); 
DELETE FROM T_CAS_RECONCILIATION_E WHERE FENTRYID = 876055266645388290;
INSERT INTO T_CAS_RECONCILIATION_E(FID,FDATAFILTERDESC_REAL,FDATAFILTERDESC,FENTRYID,FSEQ,FDATAFILTERDESC_REAL_TAG,FRULESNAME) VALUES (876055266653774848,' ','''贷方金额''等于''借方金额'' and ''借方金额''等于''贷方金额'' and ''对方户名''等于''对方户名'' and ''对方账号''等于''对方账号'' and ''摘要''等于''摘要''',876055266645388290,5,'[{"bankjournal":"debitamount","condition":"equals","isnullmatch":false,"bankstatement":"creditamount","num":null},{"bankjournal":"creditamount","condition":"equals","isnullmatch":false,"bankstatement":"debitamount","num":null},{"bankjournal":"oppunit","condition":"equals","isnullmatch":true,"bankstatement":"oppunit","num":null},{"bankjournal":"oppacctnumber","condition":"equals","isnullmatch":true,"bankstatement":"oppaccountnumber","num":null},{"bankjournal":"description","condition":"equals","isnullmatch":true,"bankstatement":"description","num":null}]','按金额一致对账'); 
