--银企互联智能执行方案升级

-- 银行付款单 
UPDATE t_gl_intellexecoperentry 
SET FBUSSINESS = 'bei_bankpaybill' , FAPPID = '/LSWHQ7US+Q6' , FOPER = 'syncstatus' , FDATAFILTER ='{"_Type_":"FilterCondition","FilterRow":[{"_Type_":"SimpleFilterRow","RightBracket":"","LeftBracket":"","Value":[{"_Type_":"FilterValue","Value":"TS","Id":"0BICG3MD4JR5"}],"CompareType":"106","Id":"0BICG3M=IEAR","Logic":"0","FieldName":"bankpaystate"},{"_Type_":"SimpleFilterRow","RightBracket":"","LeftBracket":"","Value":[{"_Type_":"FilterValue","Value":"TF","Id":"0BICG3MD4JR6"}],"CompareType":"106","Id":"0BICG3MD4UI9","Logic":"0","FieldName":"bankpaystate"}]}' 
WHERE FBUSSINESS = 'be_bankpaying';

-- 银行代发单
UPDATE t_gl_intellexecoperentry 
SET FBUSSINESS = 'bei_bankagentpay' , FAPPID = '/LSWHQ7US+Q6' , FOPER = 'syncstatus' , FDATAFILTER ='{"_Type_":"FilterCondition","FilterRow":[{"_Type_":"SimpleFilterRow","RightBracket":"","LeftBracket":"","Value":[{"_Type_":"FilterValue","Value":"TS","Id":"0BIBR8HAS0NA"}],"CompareType":"106","Id":"0BIBR8HASAEE","Logic":"0","FieldName":"paystate"},{"_Type_":"SimpleFilterRow","RightBracket":"","LeftBracket":"","Value":[{"_Type_":"FilterValue","Value":"TF","Id":"0BIBR8HAS0NB"}],"CompareType":"106","Id":"0BIBR8HASAEF","Logic":"0","FieldName":"paystate"}]}' WHERE FBUSSINESS = 'be_bankagentpay';

-- 设置执行人为空
UPDATE T_GL_INTELLACCOUNTSCHEMA SET FEXECUTORID = '0' WHERE FNUMBER = 'CAS003' OR FNUMBER = 'CAS004';