--产品中英文质量提升
--kd_1.5.247_fcs_checkctrl.sql
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696321736209032192;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FSRCRULE,FSRCCONDITION_TAG,FSRCMULAMT_TAG,FISTARGETMULAMT,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME,FSRCMULAMT,FID,FTARGETCONDITION_TAG,FISTARGETABS,FENTRYID,FISSRCABS,FTARGETCONDITION,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETMULAMT_TAG,FSRCMULAMTDESC,FTARGETMULAMT,FISSRCMULAMT,FTARGETMULAMTDESC) VALUES ('Head',' ',NULL,'0','Head','dpamt',1,'fee',' ',' ','单据头.手续费',' ',1415053612379286528,' ','0',1696321736209032192,'0',' ','委托付款组织.编码 为空   and    手续费独立流水 等于 是','单据头.异币种付款金额',NULL,' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1696321736209032193;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FSRCRULE,FSRCCONDITION_TAG,FSRCMULAMT_TAG,FISTARGETMULAMT,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME,FSRCMULAMT,FID,FTARGETCONDITION_TAG,FISTARGETABS,FENTRYID,FISSRCABS,FTARGETCONDITION,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETMULAMT_TAG,FSRCMULAMTDESC,FTARGETMULAMT,FISSRCMULAMT,FTARGETMULAMTDESC) VALUES ('Head',' ',NULL,'0','Head','actpayamt',2,'dpamt',' ',' ','单据头.异币种付款金额',' ',1415053612379286528,' ','0',1696321736209032193,'0',' ','委托付款组织.编码 不为空   and    异币种付款 等于 否','单据头.付款金额',NULL,' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1934836873470035968;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FSRCRULE,FSRCCONDITION_TAG,FSRCMULAMT_TAG,FISTARGETMULAMT,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME,FSRCMULAMT,FID,FTARGETCONDITION_TAG,FISTARGETABS,FENTRYID,FISSRCABS,FTARGETCONDITION,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETMULAMT_TAG,FSRCMULAMTDESC,FTARGETMULAMT,FISSRCMULAMT,FTARGETMULAMTDESC) VALUES ('Head',' ',' ','0','Head','actpayamt',3,'actpayamt',' ',' ','单据头.付款金额',' ',1415053612379286528,' ','0',1934836873470035968,'0',' ','委托付款组织.编码 不为空   and    异币种付款 等于 是','单据头.付款金额',' ',' ',' ','0',' '); 

--kd_1.5.226_fcs_checkctrl.sql
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1714082286724472832;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FSRCRULE,FSRCCONDITION_TAG,FSRCMULAMT_TAG,FISTARGETMULAMT,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME,FSRCMULAMT,FID,FTARGETCONDITION_TAG,FISTARGETABS,FENTRYID,FISSRCABS,FTARGETCONDITION,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETMULAMT_TAG,FSRCMULAMTDESC,FTARGETMULAMT,FISSRCMULAMT,FTARGETMULAMTDESC) VALUES ('EntrySingle',NULL,NULL,'1','EntrySum',' ',1,'e_approvedseleamt','单据状态 不在……中 (已退单,已作废)',' ','明细.核准金额折结算币种',' ',1714082286682529792,'{"expression":"","exprTran":"单据状态 不在……中 (已退单,已作废)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3KHPK6/C9NQA","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3KHPK6/C9ODK","value":"G"},{"id":"3KHPK6/C9NQB","value":"H"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3KHPK6/C9NQA\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3KHPK6/C9ODK\",\"value\":\"G\"},{\"id\":\"3KHPK6/C9NQB\",\"value\":\"H\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (已退单,已作废)"},"exprDesc":"单据状态 不在……中 (已退单,已作废)"}','1',1714082286724472832,'1',' ',' ',' ','[{"F":"entry.e_payableamt","FN":"分录.应付金额","CR":"-"},{"F":"entry.e_refundamt","FN":"分录.退款金额","CR":"+"}]',' ',' ','0','分录.应付金额-分录.退款金额'); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1823528447650135040;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FSRCRULE,FSRCCONDITION_TAG,FSRCMULAMT_TAG,FISTARGETMULAMT,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME,FSRCMULAMT,FID,FTARGETCONDITION_TAG,FISTARGETABS,FENTRYID,FISSRCABS,FTARGETCONDITION,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETMULAMT_TAG,FSRCMULAMTDESC,FTARGETMULAMT,FISSRCMULAMT,FTARGETMULAMTDESC) VALUES ('Head',' ',' ','1','EntrySum',' ',2,'aprseleamount','单据状态 不在……中 (已退单,已作废)',' ','单据头.核准金额折结算币种',' ',1714082286682529792,'{"expression":"","exprTran":"单据状态 不在……中 (已退单,已作废)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3Q+BD=MN7ZCC","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3Q+BD=MN8+0M","value":"G"},{"id":"3Q+BD=MN7ZCD","value":"H"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3Q+BD=MN7ZCC\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3Q+BD=MN8+0M\",\"value\":\"G\"},{\"id\":\"3Q+BD=MN7ZCD\",\"value\":\"H\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (已退单,已作废)"},"exprDesc":"单据状态 不在……中 (已退单,已作废)"}','1',1823528447650135040,'1',' ',' ',' ','[{"F":"entry.e_payableamt","FN":"分录.应付金额","CR":"-"},{"F":"entry.e_refundamt","FN":"分录.退款金额","CR":"+"}]',' ',' ','0','分录.应付金额-分录.退款金额'); 

--kd_1.5.225_fcs_checkctrl.sql
DELETE FROM T_FCS_CHECKCTRL_SUBAMT WHERE FDETAILID = 1776942264149443584;
INSERT INTO T_FCS_CHECKCTRL_SUBAMT(FOTHERCONDITION,FOTHERCONDITION_TAG,FOTHERMULAMTDESC,FOTHERCONDITIONDESC,FOTHERMULAMT_TAG,FENTRYID,FISOTHERMULAMT,FOTHERMULAMT,FOTHERTARGETAMTFIELDNAME,FDETAILID,FISOTHERABS,FOTHERTARGETENTITY,FSEQ,FOTHERTARGETAMTFIELD) VALUES (' ','{"expression":"","exprTran":"状态 不等于 已关闭","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3K94MI+J=FPC","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3K94MI+J=GCM","value":"D"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3K94MI+J=FPC\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3K94MI+J=GCM\",\"value\":\"D\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"状态 不等于 已关闭"},"exprDesc":"状态 不等于 已关闭"}',' ','状态 不等于 已关闭',' ',1776942264149442560,'0',' ','明细.核准金额折结算币种',1776942264149443584,'1','ap_payapply',1,'e_approvedseleamt'); 
DELETE FROM T_FCS_CHECKCTRL_SUBAMT WHERE FDETAILID = 1776942264149443585;
INSERT INTO T_FCS_CHECKCTRL_SUBAMT(FOTHERCONDITION,FOTHERCONDITION_TAG,FOTHERMULAMTDESC,FOTHERCONDITIONDESC,FOTHERMULAMT_TAG,FENTRYID,FISOTHERMULAMT,FOTHERMULAMT,FOTHERTARGETAMTFIELDNAME,FDETAILID,FISOTHERABS,FOTHERTARGETENTITY,FSEQ,FOTHERTARGETAMTFIELD) VALUES (' ','{"expression":"","exprTran":"状态 不等于 已关闭","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3K94ZXCJ/EFD","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3K94ZXCJ/DS4","value":"D"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3K94ZXCJ/EFD\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3K94ZXCJ/DS4\",\"value\":\"D\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"状态 不等于 已关闭"},"exprDesc":"状态 不等于 已关闭"}',' ','状态 不等于 已关闭',' ',1776942264149442561,'0',' ','明细.核准金额折结算币种',1776942264149443585,'1','ap_payapply',1,'e_approvedseleamt'); 
DELETE FROM T_FCS_CHECKCTRL_SUBAMT WHERE FDETAILID = 1776989284453148672;
INSERT INTO T_FCS_CHECKCTRL_SUBAMT(FOTHERCONDITION,FOTHERCONDITION_TAG,FOTHERMULAMTDESC,FOTHERCONDITIONDESC,FOTHERMULAMT_TAG,FENTRYID,FISOTHERMULAMT,FOTHERMULAMT,FOTHERTARGETAMTFIELDNAME,FDETAILID,FISOTHERABS,FOTHERTARGETENTITY,FSEQ,FOTHERTARGETAMTFIELD) VALUES (' ','{"expression":"","exprTran":"状态 不等于 已关闭","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3K9CN6I+IL9E","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3K9CN6I+J0S2","value":"D"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3K9CN6I+IL9E\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3K9CN6I+J0S2\",\"value\":\"D\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"状态 不等于 已关闭"},"exprDesc":"状态 不等于 已关闭"}',' ','状态 不等于 已关闭',' ',1776989284453175296,'0',' ','明细.核准金额折结算币种',1776989284453148672,'1','ap_payapply',1,'e_approvedseleamt'); 
DELETE FROM T_FCS_CHECKCTRL_SUBAMT WHERE FDETAILID = 1776989284453148673;
INSERT INTO T_FCS_CHECKCTRL_SUBAMT(FOTHERCONDITION,FOTHERCONDITION_TAG,FOTHERMULAMTDESC,FOTHERCONDITIONDESC,FOTHERMULAMT_TAG,FENTRYID,FISOTHERMULAMT,FOTHERMULAMT,FOTHERTARGETAMTFIELDNAME,FDETAILID,FISOTHERABS,FOTHERTARGETENTITY,FSEQ,FOTHERTARGETAMTFIELD) VALUES (' ','{"expression":"","exprTran":"状态 不等于 已关闭","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3K9CRLFBVZPP","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3K9CRLFBVI70","value":"D"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3K9CRLFBVZPP\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3K9CRLFBVI70\",\"value\":\"D\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"状态 不等于 已关闭"},"exprDesc":"状态 不等于 已关闭"}',' ','状态 不等于 已关闭',' ',1776989284453175297,'0',' ','明细.核准金额折结算币种',1776989284453148673,'1','ap_payapply',1,'e_approvedseleamt'); 
DELETE FROM T_FCS_CHECKCTRL_SUBAMT WHERE FDETAILID = 1814713855725657088;
INSERT INTO T_FCS_CHECKCTRL_SUBAMT(FOTHERCONDITION,FOTHERCONDITION_TAG,FOTHERMULAMTDESC,FOTHERCONDITIONDESC,FOTHERMULAMT_TAG,FENTRYID,FISOTHERMULAMT,FOTHERMULAMT,FOTHERTARGETAMTFIELDNAME,FDETAILID,FISOTHERABS,FOTHERTARGETENTITY,FSEQ,FOTHERTARGETAMTFIELD) VALUES (' ','{"expression":"","exprTran":"状态 不等于 已关闭","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3OX3OV/LJOP8","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3OX3OV/LJ6V1","value":"D"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3OX3OV/LJOP8\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3OX3OV/LJ6V1\",\"value\":\"D\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"状态 不等于 已关闭"},"exprDesc":"状态 不等于 已关闭"}',' ','状态 不等于 已关闭',' ',1814713165083143168,'0',' ','明细.核准金额折结算币种',1814713855725657088,'1','ap_payapply',1,'e_approvedseleamt'); 
DELETE FROM T_FCS_CHECKCTRL_SUBAMT WHERE FDETAILID = 1818302328567089152;
INSERT INTO T_FCS_CHECKCTRL_SUBAMT(FOTHERCONDITION,FOTHERCONDITION_TAG,FOTHERMULAMTDESC,FOTHERCONDITIONDESC,FOTHERMULAMT_TAG,FENTRYID,FISOTHERMULAMT,FOTHERMULAMT,FOTHERTARGETAMTFIELDNAME,FDETAILID,FISOTHERABS,FOTHERTARGETENTITY,FSEQ,FOTHERTARGETAMTFIELD) VALUES (' ','{"expression":"","exprTran":"状态 不等于 已关闭","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3PB=YT+152X=","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3PB=YT+4SY8Z","value":"D"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3PB=YT+152X=\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3PB=YT+4SY8Z\",\"value\":\"D\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"状态 不等于 已关闭"},"exprDesc":"状态 不等于 已关闭"}',' ','状态 不等于 已关闭',' ',1818302328567064576,'0',' ','明细.核准金额折结算币种',1818302328567089152,'1','ap_payapply',1,'e_approvedseleamt'); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1768842793121316864;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FSRCRULE,FSRCCONDITION_TAG,FSRCMULAMT_TAG,FISTARGETMULAMT,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME,FSRCMULAMT,FID,FTARGETCONDITION_TAG,FISTARGETABS,FENTRYID,FISSRCABS,FTARGETCONDITION,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETMULAMT_TAG,FSRCMULAMTDESC,FTARGETMULAMT,FISSRCMULAMT,FTARGETMULAMTDESC) VALUES ('EntrySingle','{"expression":"GetSysParam(''/BBRH+122=39'', '''', org.id, 0, ''ar_003'') = \"1\"","exprTran":"GetSysParam(''/BBRH+122=39'', '''', 结算组织.内码(org.id), 0, ''ar_003'') = \"1\"","description":{"zh_CN":""},"filterCondition":{"filterRow":[],"forList":false},"filterString":"{\"filterRow\":[],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"GetSysParam(''/BBRH+122=39'', '''', 结算组织.内码(org.id), 0, ''ar_003'') = \"1\""},"exprDesc":"GetSysParam(''/BBRH+122=39'', '''', 结算组织.内码(org.id), 0, ''ar_003'') = \"1\""}',' ','0','EntrySum','e_approvedseleamt',3,'e_recamount','状态 不等于 已关闭',' ','明细.应收金额',' ',1768341607540593664,'{"expression":"","exprTran":"状态 不等于 已关闭","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3J9B1EVG26NO","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3J9B1EVG26+E","value":"D"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3J9B1EVG26NO\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3J9B1EVG26+E\",\"value\":\"D\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"状态 不等于 已关闭"},"exprDesc":"状态 不等于 已关闭"}','1',1768842793121316864,'1',' ','GetSysParam(''/BBRH+122=39'', '''', 结算组织.内码(......','明细.核准金额折结算币种',' ',' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1768842793121316866;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FSRCRULE,FSRCCONDITION_TAG,FSRCMULAMT_TAG,FISTARGETMULAMT,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME,FSRCMULAMT,FID,FTARGETCONDITION_TAG,FISTARGETABS,FENTRYID,FISSRCABS,FTARGETCONDITION,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETMULAMT_TAG,FSRCMULAMTDESC,FTARGETMULAMT,FISSRCMULAMT,FTARGETMULAMTDESC) VALUES ('EntrySingle','{"expression":"GetSysParam(''/BBRH+122=39'', '''', org.id, 0, ''ar_003'') = \"2\"","exprTran":"GetSysParam(''/BBRH+122=39'', '''', 结算组织.内码(org.id), 0, ''ar_003'') = \"2\"","description":{"zh_CN":""},"filterCondition":{"filterRow":[],"forList":false},"filterString":"{\"filterRow\":[],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"GetSysParam(''/BBRH+122=39'', '''', 结算组织.内码(org.id), 0, ''ar_003'') = \"2\""},"exprDesc":"GetSysParam(''/BBRH+122=39'', '''', 结算组织.内码(org.id), 0, ''ar_003'') = \"2\""}',' ','0','EntrySum','e_approvedseleamt',4,'planpricetax','状态 不等于 已关闭',' ','收款计划.应收金额',' ',1768341607540593664,'{"expression":"","exprTran":"状态 不等于 已关闭","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3J9B8XA0UJ80","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3J9B8XA0UIJS","value":"D"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3J9B8XA0UJ80\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3J9B8XA0UIJS\",\"value\":\"D\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"状态 不等于 已关闭"},"exprDesc":"状态 不等于 已关闭"}','1',1768842793121316866,'1',' ','GetSysParam(''/BBRH+122=39'', '''', 结算组织.内码(......','明细.核准金额折结算币种',' ',' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1768844273064707072;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FSRCRULE,FSRCCONDITION_TAG,FSRCMULAMT_TAG,FISTARGETMULAMT,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME,FSRCMULAMT,FID,FTARGETCONDITION_TAG,FISTARGETABS,FENTRYID,FISSRCABS,FTARGETCONDITION,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETMULAMT_TAG,FSRCMULAMTDESC,FTARGETMULAMT,FISSRCMULAMT,FTARGETMULAMTDESC) VALUES ('EntrySingle','{"expression":"GetSysParam(''+HKZHSKFXOX'', '''', org.id, 0, ''ap_003'')  = \"1\"","exprTran":"GetSysParam(''+HKZHSKFXOX'', '''', 结算组织.内码(org.id), 0, ''ap_003'')  = \"1\"","description":{"zh_CN":""},"filterCondition":{"filterRow":[],"forList":false},"filterString":"{\"filterRow\":[],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"GetSysParam(''+HKZHSKFXOX'', '''', 结算组织.内码(org.id), 0, ''ap_003'')  = \"1\""},"exprDesc":"GetSysParam(''+HKZHSKFXOX'', '''', 结算组织.内码(org.id), 0, ''ap_003'')  = \"1\""}',' ','0','EntrySum','e_approvedseleamt',3,'e_pricetaxtotal','状态 不等于 已关闭',' ','明细.应付金额',' ',1712458692122665984,'{"expression":"","exprTran":"状态 不等于 已关闭","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3J9BVVAHHVOF","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3J9BVVAHHV/6","value":"D"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3J9BVVAHHVOF\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3J9BVVAHHV/6\",\"value\":\"D\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"状态 不等于 已关闭"},"exprDesc":"状态 不等于 已关闭"}','1',1768844273064707072,'1',' ','GetSysParam(''+HKZHSKFXOX'', '''', 结算组织.内码(o......','明细.核准金额折结算币种',' ',' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1768844273064707074;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FSRCRULE,FSRCCONDITION_TAG,FSRCMULAMT_TAG,FISTARGETMULAMT,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME,FSRCMULAMT,FID,FTARGETCONDITION_TAG,FISTARGETABS,FENTRYID,FISSRCABS,FTARGETCONDITION,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETMULAMT_TAG,FSRCMULAMTDESC,FTARGETMULAMT,FISSRCMULAMT,FTARGETMULAMTDESC) VALUES ('EntrySingle','{"expression":"GetSysParam(''+HKZHSKFXOX'', '''', org.id, 0, ''ap_003'')  = \"2\"","exprTran":"GetSysParam(''+HKZHSKFXOX'', '''', 结算组织.内码(org.id), 0, ''ap_003'')  = \"2\"","description":{"zh_CN":""},"filterCondition":{"filterRow":[],"forList":false},"filterString":"{\"filterRow\":[],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"GetSysParam(''+HKZHSKFXOX'', '''', 结算组织.内码(org.id), 0, ''ap_003'')  = \"2\""},"exprDesc":"GetSysParam(''+HKZHSKFXOX'', '''', 结算组织.内码(org.id), 0, ''ap_003'')  = \"2\""}',' ','0','EntrySum','e_approvedseleamt',4,'planpricetax','状态 不等于 已关闭',' ','付款计划.应付金额',' ',1712458692122665984,'{"expression":"","exprTran":"状态 不等于 已关闭","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3J9BWLZFZ+QB","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3J9BWLZFZ+12","value":"D"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3J9BWLZFZ+QB\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3J9BWLZFZ+12\",\"value\":\"D\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"状态 不等于 已关闭"},"exprDesc":"状态 不等于 已关闭"}','1',1768844273064707074,'1',' ','GetSysParam(''+HKZHSKFXOX'', '''', 结算组织.内码(o......','明细.核准金额折结算币种',' ',' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1824563688984640513;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FSRCRULE,FSRCCONDITION_TAG,FSRCMULAMT_TAG,FISTARGETMULAMT,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME,FSRCMULAMT,FID,FTARGETCONDITION_TAG,FISTARGETABS,FENTRYID,FISSRCABS,FTARGETCONDITION,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETMULAMT_TAG,FSRCMULAMTDESC,FTARGETMULAMT,FISSRCMULAMT,FTARGETMULAMTDESC) VALUES ('Head',' ',' ','0','EntrySum','e_approvedseleamt',6,'recamount','状态 不等于 已关闭',' ','单据头.应收金额',' ',1768341607540593664,'{"expression":"","exprTran":"状态 不等于 已关闭","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3Q3=UNG4T6HU","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3Q3=UNG4T5UK","value":"D"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3Q3=UNG4T6HU\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3Q3=UNG4T5UK\",\"value\":\"D\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"状态 不等于 已关闭"},"exprDesc":"状态 不等于 已关闭"}','1',1824563688984640513,'1',' ',' ','明细.核准金额折结算币种',' ',' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1824566682484570113;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FSRCRULE,FSRCCONDITION_TAG,FSRCMULAMT_TAG,FISTARGETMULAMT,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME,FSRCMULAMT,FID,FTARGETCONDITION_TAG,FISTARGETABS,FENTRYID,FISSRCABS,FTARGETCONDITION,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETMULAMT_TAG,FSRCMULAMTDESC,FTARGETMULAMT,FISSRCMULAMT,FTARGETMULAMTDESC) VALUES ('Head',' ',' ','0','EntrySum','e_approvedseleamt',6,'pricetaxtotal','状态 不等于 已关闭',' ','单据头.应付金额',' ',1712458692122665984,'{"expression":"","exprTran":"状态 不等于 已关闭","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3Q3A7G62OUO5","leftBracket":"","compareType":"106","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3Q3A7G62OU+X","value":"D"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3Q3A7G62OUO5\",\"leftBracket\":\"\",\"compareType\":\"106\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3Q3A7G62OU+X\",\"value\":\"D\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"状态 不等于 已关闭"},"exprDesc":"状态 不等于 已关闭"}','1',1824566682484570113,'1',' ',' ','明细.核准金额折结算币种',' ',' ',' ','0',' '); 

--kd_1.5.223_fcs_snapschedule.sql
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3OWBTFHH/XKE';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1814555028011298816,'3OWBTFHH/XKE','zh_CN',' ','企业借贷币种分布-债权人');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3OWBTFPKCTD7';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1814555028951073792,'3OWBTFPKCTD7','zh_CN',' ','企业借贷币种分布-借款人');
DELETE FROM T_FCS_SNAPSCHEDULE_L WHERE FPKID = '3OWBTPGS7B4L';
INSERT INTO T_FCS_SNAPSCHEDULE_L(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1814555063360892928,'3OWBTPGS7B4L','zh_CN',' ','企业借贷币种分布表');
DELETE FROM t_fcs_snapschedule WHERE FID = 1814555063360892928;
INSERT INTO t_fcs_snapschedule(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1814555063360892928,0,'3NMNN713WKJO',NULL,NULL,1814555063360892928,'common','C','tda_interloanbycurrpt','企业借贷币种分布表',{ts'2023-11-09  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-11-09  00:00:00'},'kd.tmc.tda.report.interloan.data.InterLoanByCurrencyDataListPlugin',0,0,' ');
DELETE FROM t_fcs_snapschedule WHERE FID = 1814555028951073792;
INSERT INTO t_fcs_snapschedule(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1814555028951073792,0,'3NG5PC67SYJ9',NULL,NULL,1814555028951073792,'qing','C','tda_corlenddebitbycurqin','企业借贷币种分布-借款人',{ts'2023-11-09  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-11-09  00:00:00'},'kd.tmc.tda.report.interloan.qing.data.InterLoanDebtByCurrencyDataPlugin',0,0,' ');
DELETE FROM t_fcs_snapschedule WHERE FID = 1814555028011298816;
INSERT INTO t_fcs_snapschedule(FID,FENABLERID,FFORMID,FENABLEDATE,FDISABLEDATE,FMASTERID,FREPORTTYPE,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FFREQUENCY,FQUERYITEM,FMODIFYTIME,FQUERYPLUGIN,FCREATORID,FDISABLERID,FQUERYPARAM) VALUES (1814555028011298816,0,'3NIR0GHT6UQE',NULL,NULL,1814555028011298816,'qing','C','tda_corlendcreditbycurqin','企业借贷币种分布-债权人',{ts'2023-11-09  00:00:00'},1442714591590297600,'1',' ',' ',{ts'2023-11-09  00:00:00'},'kd.tmc.tda.report.interloan.qing.data.InterLoanCreditorByCurrencyDataPlugin',0,0,' ');

--kd_1.5.221_fcs_checkctrl.sql
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1415179594985651200;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FSRCRULE,FSRCCONDITION_TAG,FSRCMULAMT_TAG,FISTARGETMULAMT,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME,FSRCMULAMT,FID,FTARGETCONDITION_TAG,FISTARGETABS,FENTRYID,FISSRCABS,FTARGETCONDITION,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETMULAMT_TAG,FSRCMULAMTDESC,FTARGETMULAMT,FISSRCMULAMT,FTARGETMULAMTDESC) VALUES ('Head',NULL,NULL,'0','Head','convertdrawamt',1,'amount','循环贷款 等于 否   and    单据状态 不等于 暂存',' ','单据头.贷款金额',' ',1415179594960485376,' ','0',1415179594985651200,'0',' ',' ','单据头.折合同币种金额',NULL,' ',' ','0',' '); 

--kd_1.5.209_fcs_arap_suspectset.sql
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1714414399332049920;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1714414398686127104,'[{"destname":"结算组织","checkkey":"org","destkey":"org","checkname":"结算组织"},{"destname":"往来户","checkkey":"asstact","destkey":"asstact","checkname":"往来户"},{"destname":"结算币种","checkkey":"currency","destkey":"currency","checkname":"结算币种"},{"destname":"单据头.应付金额","checkkey":"pricetaxtotal","destkey":"pricetaxtotal","checkname":"单据头.应付金额"},{"destname":"明细.应付金额","checkkey":"detailentry.e_pricetaxtotal","destkey":"detailentry.e_pricetaxtotal","checkname":"明细.应付金额"}]',' ','{"expression":"","exprTran":"单据日期 本月","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3CKKWH30XMU=","leftBracket":"","compareType":"63","fieldName":"bizdate","rightBracket":"","logic":"0","value":[{"id":"3CKKWH30XM50","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3CKKWH30XMU=\",\"leftBracket\":\"\",\"compareType\":\"63\",\"fieldName\":\"bizdate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3CKKWH30XM50\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据日期 本月"},"exprDesc":"单据日期 本月"}','{"expression":"","exprTran":"单据日期 本月","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3CKKXXW39QC7","leftBracket":"","compareType":"63","fieldName":"bizdate","rightBracket":"","logic":"0","value":[{"id":"3CKKXXW39POZ","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3CKKXXW39QC7\",\"leftBracket\":\"\",\"compareType\":\"63\",\"fieldName\":\"bizdate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3CKKXXW39POZ\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据日期 本月"},"exprDesc":"单据日期 本月"}','单据日期 本月',1714414399332049920,1,' ','结算组织 等于 结算组织 and 往来户 等于 往来户 and 结算币种 等于 ......','单据日期 本月',' '); 
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1714418785961664512;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1714418785936498688,'[{"destname":"结算组织","checkkey":"org","destkey":"org","checkname":"结算组织"},{"destname":"往来户","checkkey":"asstact","destkey":"asstact","checkname":"往来户"},{"destname":"结算币种","checkkey":"currency","destkey":"currency","checkname":"结算币种"},{"destname":"单据头.应收金额","checkkey":"recamount","destkey":"recamount","checkname":"单据头.应收金额"},{"destname":"明细.应收金额","checkkey":"entry.e_recamount","destkey":"entry.e_recamount","checkname":"明细.应收金额"}]',' ','{"expression":"","exprTran":"单据日期 本月","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3CKLRNLKH606","leftBracket":"","compareType":"63","fieldName":"bizdate","rightBracket":"","logic":"0","value":[{"id":"3CKLRNLKH5BY","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3CKLRNLKH606\",\"leftBracket\":\"\",\"compareType\":\"63\",\"fieldName\":\"bizdate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3CKLRNLKH5BY\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据日期 本月"},"exprDesc":"单据日期 本月"}','{"expression":"","exprTran":"单据日期 本月","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3CKLS=F/7VIQ","leftBracket":"","compareType":"63","fieldName":"bizdate","rightBracket":"","logic":"0","value":[{"id":"3CKLS=F/7UVG","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3CKLS=F/7VIQ\",\"leftBracket\":\"\",\"compareType\":\"63\",\"fieldName\":\"bizdate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3CKLS=F/7UVG\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据日期 本月"},"exprDesc":"单据日期 本月"}','单据日期 本月',1714418785961664512,1,' ','结算组织 等于 结算组织 and 往来户 等于 往来户 and 结算币种 等于 ......','单据日期 本月',' '); 
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1714421093432844288;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1714421093399289856,'[{"destname":"结算组织","checkkey":"settleorg","destkey":"settleorg","checkname":"结算组织"},{"destname":"结算币种","checkkey":"settlecurrency","destkey":"settlecurrency","checkname":"结算币种"},{"destname":"往来户","checkkey":"entry.e_asstact","destkey":"entry.e_asstact","checkname":"往来户"},{"destname":"单据头.申请金额","checkkey":"applyamount","destkey":"applyamount","checkname":"单据头.申请金额"},{"destname":"明细.申请金额","checkkey":"entry.e_applyamount","destkey":"entry.e_applyamount","checkname":"明细.申请金额"}]',' ','{"expression":"","exprTran":"申请日期 本月","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3CKM562HD/BL","leftBracket":"","compareType":"63","fieldName":"applydate","rightBracket":"","logic":"0","value":[{"id":"3CKM562HD0/V","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3CKM562HD/BL\",\"leftBracket\":\"\",\"compareType\":\"63\",\"fieldName\":\"applydate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3CKM562HD0/V\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"申请日期 本月"},"exprDesc":"申请日期 本月"}','{"expression":"","exprTran":"申请日期 本月","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3CKM72EQX2/4","leftBracket":"","compareType":"63","fieldName":"applydate","rightBracket":"","logic":"0","value":[{"id":"3CKM72EQX1AW","value":""}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3CKM72EQX2/4\",\"leftBracket\":\"\",\"compareType\":\"63\",\"fieldName\":\"applydate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3CKM72EQX1AW\",\"value\":\"\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"申请日期 本月"},"exprDesc":"申请日期 本月"}','申请日期 本月',1714421093432844288,1,' ','结算组织 等于 结算组织 and 结算币种 等于 结算币种 and 往来户 等于......','申请日期 本月',' '); 

--kd_1.5.204_fcs_checkctrl_jy.sql
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1415104347158666240;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETCONDITION,FSRCCONDITION_TAG,FSRCCONDITIONDESC,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCAMTFIELDNAME) VALUES (1415104347049614336,'Head',' ',1415104347158666240,' ',' ','同步放款 等于 否   or   ( 同步放款 等于 是   and    数据......','单据头.折合同币种金额','Head','convertdrawamt',1,'amount','单据状态 不等于 暂存   and    循环贷款 等于 否',' ','单据头.借款金额');

--kd_1.5.167_fcs_suspectset.sql
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1469672561511030784;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1469672561469087744,'[{"destname":"付款账号.付款账号.银行账号","checkkey":"accountbank.bankaccountnumber","destkey":"accountbank.bankaccountnumber","checkname":"付款账号.付款账号.银行账号"},{"destname":"单据头.收款账号","checkkey":"payeeacct","destkey":"payeeacct","checkname":"单据头.收款账号"},{"destname":"币种.币种.货币代码","checkkey":"currency.number","destkey":"currency.number","checkname":"币种.币种.货币代码"},{"destname":"单据头.付款金额","checkkey":"amount","destkey":"amount","checkname":"单据头.付款金额"},{"destname":"单据头.附言","checkkey":"usage","destkey":"usage","checkname":"单据头.附言"},{"destname":"单据头.描述","checkkey":"description","destkey":"description","checkname":"单据头.描述"}]',' ',' ','{"expression":"","exprTran":"( 业务日期 本周   or    业务日期 上周 )  and    单据状态 不在……中 (已失败重付,已打回)   and    付款状态 不在……中 (交易失败)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2LI1+I59/ECH","leftBracket":"(","compareType":"10","fieldName":"bizdate","rightBracket":"","logic":"1","value":[{"id":"2LI1+I5906+S","value":""}],"baseDataIds":[]},{"id":"2LI1+I59/ECI","leftBracket":"","compareType":"61","fieldName":"bizdate","rightBracket":")","logic":"0","value":[{"id":"2LI1+I5906+T","value":""}],"baseDataIds":[]},{"id":"2LNXIR0ZN8FU","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2LNXIR0ZN942","value":"F"},{"id":"2LNXLIFMWMHK","value":"T"}],"baseDataIds":[]},{"id":"2LNXIR0ZN8FV","leftBracket":"","compareType":"34","fieldName":"bankpaystate","rightBracket":"","logic":"0","value":[{"id":"2LNXIR0ZN943","value":"TF"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2LI1+I59/ECH\",\"leftBracket\":\"(\",\"compareType\":\"10\",\"fieldName\":\"bizdate\",\"rightBracket\":\"\",\"logic\":\"1\",\"value\":[{\"id\":\"2LI1+I5906+S\",\"value\":\"\"}],\"baseDataIds\":[]},{\"id\":\"2LI1+I59/ECI\",\"leftBracket\":\"\",\"compareType\":\"61\",\"fieldName\":\"bizdate\",\"rightBracket\":\")\",\"logic\":\"0\",\"value\":[{\"id\":\"2LI1+I5906+T\",\"value\":\"\"}],\"baseDataIds\":[]},{\"id\":\"2LNXIR0ZN8FU\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2LNXIR0ZN942\",\"value\":\"F\"},{\"id\":\"2LNXLIFMWMHK\",\"value\":\"T\"}],\"baseDataIds\":[]},{\"id\":\"2LNXIR0ZN8FV\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"bankpaystate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2LNXIR0ZN943\",\"value\":\"TF\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"( 业务日期 本周   or    业务日期 上周 )  and    单据状态 不在……中 (已失败重付,已打回)   and    付款状态 不在……中 (交易失败)"},"exprDesc":"( 业务日期 本周   or    业务日期 上周 )  and    单据状态 不在……中 (已失败重付,已打回)   and    付款状态 不在……中 (交易失败)"}',' ',1469672561511030784,1,' ','付款账号.付款账号.银行账号 等于 付款账号.付款账号.银行账号 and 单据头......','( 业务日期 本周   or    业务日期 上周 )  and    单据状态......',' '); 
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1469693853937175552;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1469693853895232512,'[{"destname":"母账户银行账号.母账户银行账号.银行账号","checkkey":"accountbank.bankaccountnumber","destkey":"accountbank.bankaccountnumber","checkname":"母账户银行账号.母账户银行账号.银行账号"},{"destname":"币种.币种.货币代码","checkkey":"currency.number","destkey":"currency.number","checkname":"币种.币种.货币代码"},{"destname":"子账户银行账号.子账户银行账号.银行账号","checkkey":"entrys.subacct.bankaccountnumber","destkey":"entrys.subacct.bankaccountnumber","checkname":"子账户银行账号.子账户银行账号.银行账号"},{"destname":"划拨明细.上划金额","checkkey":"entrys.transamt","destkey":"entrys.transamt","checkname":"划拨明细.上划金额"},{"destname":"划拨明细.备注","checkkey":"entrys.remark","destkey":"entrys.remark","checkname":"划拨明细.备注"}]',' ',' ','{"expression":"","exprTran":"上划日期 今天   and    单据状态 不在……中 (已作废)   and    划拨明细.付款状态 不在……中 (交易失败)   and    划拨明细.明细状态 不在……中 (已作废,打回,删除)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2LI4ZRHUV2XD","leftBracket":"","compareType":"13","fieldName":"transbilldate","rightBracket":"","logic":"0","value":[{"id":"2LI4ZRHUV3KN","value":""}],"baseDataIds":[]},{"id":"2LI4ZRHUV2XE","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2LI4ZRHUV3KO","value":"S"}],"baseDataIds":[]},{"id":"2N72YA8Q7EB2","leftBracket":"","compareType":"34","fieldName":"paystatus","rightBracket":"","logic":"0","value":[{"id":"2N72YA8Q85=3","value":"payfail"}],"baseDataIds":[]},{"id":"2N72YA8Q7EB3","leftBracket":"","compareType":"34","fieldName":"state","rightBracket":"","logic":"0","value":[{"id":"2N72YA8Q85=4","value":"discard"},{"id":"2OJA7K8WXJX7","value":"back"},{"id":"2OJA7K8WXIJP","value":"delete"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2LI4ZRHUV2XD\",\"leftBracket\":\"\",\"compareType\":\"13\",\"fieldName\":\"transbilldate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2LI4ZRHUV3KN\",\"value\":\"\"}],\"baseDataIds\":[]},{\"id\":\"2LI4ZRHUV2XE\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2LI4ZRHUV3KO\",\"value\":\"S\"}],\"baseDataIds\":[]},{\"id\":\"2N72YA8Q7EB2\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"paystatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2N72YA8Q85=3\",\"value\":\"payfail\"}],\"baseDataIds\":[]},{\"id\":\"2N72YA8Q7EB3\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"state\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2N72YA8Q85=4\",\"value\":\"discard\"},{\"id\":\"2OJA7K8WXJX7\",\"value\":\"back\"},{\"id\":\"2OJA7K8WXIJP\",\"value\":\"delete\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"上划日期 今天   and    单据状态 不在……中 (已作废)   and    划拨明细.付款状态 不在……中 (交易失败)   and    划拨明细.明细状态 不在……中 (已作废,打回,删除)","localeExprTran":{"zh_CN":"上划日期 今天   and    单据状态 不在……中 (已作废)   and    划拨明细.付款状态 不在……中 (交易失败)   and    划拨明细.明细状态 不在……中 (已作废,打回,删除)"}}',' ',1469693853937175552,1,' ','母账户银行账号.母账户银行账号.银行账号 等于 母账户银行账号.母账户银行账号.......','上划日期 今天   and    单据状态 不在……中 (已作废)   and ......',' '); 
DELETE FROM T_FCS_SUSPECTSET_M WHERE FENTRYID = 1472350769737948160;
INSERT INTO T_FCS_SUSPECTSET_M(FID,FMATCHRECORD_TAG,FDESTFILTERRECORD,FDESTFILTERRECORD_TAG,FCHECKFILTERRECORD_TAG,FDESTFILTER,FENTRYID,FSEQ,FCHECKFILTERRECORD,FMATCHSCHEME,FCHECKFILTER,FMATCHRECORD) VALUES (1472350769704393728,'[{"destname":"母账户银行账号.母账户银行账号.银行账号","checkkey":"accountbank.bankaccountnumber","destkey":"accountbank.bankaccountnumber","checkname":"母账户银行账号.母账户银行账号.银行账号"},{"destname":"子账户银行账号.子账户银行账号.银行账号","checkkey":"entrys.subacct.bankaccountnumber","destkey":"entrys.subacct.bankaccountnumber","checkname":"子账户银行账号.子账户银行账号.银行账号"},{"destname":"币种.币种.货币代码","checkkey":"currency.number","destkey":"currency.number","checkname":"币种.币种.货币代码"},{"destname":"下拨明细.下拨金额","checkkey":"entrys.transamt","destkey":"entrys.transamt","checkname":"下拨明细.下拨金额"},{"destname":"下拨明细.备注","checkkey":"entrys.remark","destkey":"entrys.remark","checkname":"下拨明细.备注"}]',' ',' ','{"expression":"","exprTran":"下拨日期 今天   and    单据状态 不在……中 (已作废)   and    下拨明细.付款状态 不在……中 (交易失败)   and    下拨明细.明细状态 不在……中 (已作废,打回,删除)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2LUWDS/E3R+N","leftBracket":"","compareType":"13","fieldName":"transbilldate","rightBracket":"","logic":"0","value":[{"id":"2LUWDS/HRXTF","value":""}],"baseDataIds":[]},{"id":"2LUWDS/HR565","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2LUWDS/HRXTG","value":"S"}],"baseDataIds":[]},{"id":"2N744QOWOBKH","leftBracket":"","compareType":"34","fieldName":"paystatus","rightBracket":"","logic":"0","value":[{"id":"2N744QOWNLMG","value":"payfail"}],"baseDataIds":[]},{"id":"2N744QOWOBKI","leftBracket":"","compareType":"34","fieldName":"state","rightBracket":"","logic":"0","value":[{"id":"2N744QOWNLMH","value":"discard"},{"id":"2OJAB=QVXX9B","value":"back"},{"id":"2OJAB=QVXVXU","value":"delete"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2LUWDS/E3R+N\",\"leftBracket\":\"\",\"compareType\":\"13\",\"fieldName\":\"transbilldate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2LUWDS/HRXTF\",\"value\":\"\"}],\"baseDataIds\":[]},{\"id\":\"2LUWDS/HR565\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2LUWDS/HRXTG\",\"value\":\"S\"}],\"baseDataIds\":[]},{\"id\":\"2N744QOWOBKH\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"paystatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2N744QOWNLMG\",\"value\":\"payfail\"}],\"baseDataIds\":[]},{\"id\":\"2N744QOWOBKI\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"state\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2N744QOWNLMH\",\"value\":\"discard\"},{\"id\":\"2OJAB=QVXX9B\",\"value\":\"back\"},{\"id\":\"2OJAB=QVXVXU\",\"value\":\"delete\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"下拨日期 今天   and    单据状态 不在……中 (已作废)   and    下拨明细.付款状态 不在……中 (交易失败)   and    下拨明细.明细状态 不在……中 (已作废,打回,删除)","localeExprTran":{"zh_CN":"下拨日期 今天   and    单据状态 不在……中 (已作废)   and    下拨明细.付款状态 不在……中 (交易失败)   and    下拨明细.明细状态 不在……中 (已作废,打回,删除)"}}',' ',1472350769737948160,1,' ','母账户银行账号.母账户银行账号.银行账号 等于 母账户银行账号.母账户银行账号.......','下拨日期 今天   and    单据状态 不在……中 (已作废)   and ......',' '); 

--kd_1.5.147_fcs_checkctrl.sql
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1416766110623129600;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FSRCCONDITION_TAG,FTARGETCONDITION,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCCONDITIONDESC,FSRCAMTFIELDNAME) VALUES (1415325242217218048,'Head',' ',1416766110623129600,NULL,' ','单据头.第一行交割金额','Head','bizamt1',1,'amount','生命周期 不在……中 (展期,提前,近端提前,近端展期,远端提前,远端展期)  ......',' ',' ','单据头.近端基准币种金额');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1416763639406320640;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FSRCCONDITION_TAG,FTARGETCONDITION,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCCONDITIONDESC,FSRCAMTFIELDNAME) VALUES (1415326836623164416,'Head','{"expression":"","exprTran":"生命周期 不在……中 (展期,提前)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2GE520VAF8F2","leftBracket":"","compareType":"34","fieldName":"operate","rightBracket":"","logic":"0","value":[{"id":"2GE520VAF93B","value":"defer"},{"id":"2GE520VAF8F3","value":"maudate"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2GE520VAF8F2\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"operate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2GE520VAF93B\",\"value\":\"defer\"},{\"id\":\"2GE520VAF8F3\",\"value\":\"maudate\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"生命周期 不在……中 (展期,提前)","localeExprTran":{"zh_CN":"生命周期 不在……中 (展期,提前)"}}',1416763639406320640,NULL,' ','单据头.第一行交割金额','Head','bizamt1',1,'amount','生命周期 不在……中 (展期,提前)',' ',' ','单据头.基准币种金额');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1416763933955514368;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FSRCCONDITION_TAG,FTARGETCONDITION,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCCONDITIONDESC,FSRCAMTFIELDNAME) VALUES (1415325466738312192,'Head',NULL,1416763933955514368,NULL,' ','单据头.第一行交割金额','Head','bizamt1',1,'amount',' ',' ',' ','单据头.基准币种金额');
DELETE FROM t_fcs_checkctrl_amtctrl WHERE FENTRYID = 1416764052486544384;
INSERT INTO t_fcs_checkctrl_amtctrl(FID,FSRCRULE,FTARGETCONDITION_TAG,FENTRYID,FSRCCONDITION_TAG,FTARGETCONDITION,FTARGETAMTFIELDNAME,FTARGETRULE,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITIONDESC,FSRCCONDITION,FSRCCONDITIONDESC,FSRCAMTFIELDNAME) VALUES (1415325694958780416,'Head',NULL,1416764052486544384,NULL,' ','单据头.第一行交割金额','Head','bizamt1',1,'amount',' ',' ',' ','单据头.基准币种金额');

--kd_1.5.147_fcs_payaccess.sql
DELETE FROM t_fcs_payaccess_l WHERE FPKID = '2EUHPVVZQF/N';
INSERT INTO t_fcs_payaccess_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1415289293986910208,'2EUHPVVZQF/N','zh_CN',' ','离线明细导入 -> 结算中心扣款');
DELETE FROM t_fcs_payaccess_l WHERE FPKID = '2EUHPVVZQF/O';
INSERT INTO t_fcs_payaccess_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (1415289293986910208,'2EUHPVVZQF/O','zh_TW',' ','離線明細導入 -> 結算中心扣款');
DELETE FROM t_fcs_payaccess WHERE FID = 1415289293986910208;
INSERT INTO t_fcs_payaccess(FID,FDESTENTITYID,FISBOTPADD,FOPERATE,FMASTERID,FSTATUS,FFILTER_TAG,FCUSTOMSIGN,FNUMBER,FNAME,FFILTER,FDESTLKFIELD,FISCUSTOMENTITY,FENABLE,FISPRESET,FSRCLKPROP,FSRCENTITYID,FDESTLKPKFIELD) VALUES (1415289293986910208,'ifm_deduction','1',',save,submit,delete,',1415289293986910208,'C',' ',' ','bei_betransdetail_imp -> ifm_deduction','离线明细导入 -> 结算中心扣款',' ',' ','0','1','1','1','bei_betransdetail_imp',' ');

--kd_1.5.147_fcs_checkctrl.sql
DELETE FROM t_fcs_checkctrl WHERE FID = 1415289797915758592;
INSERT INTO t_fcs_checkctrl(FISMATCH,FISBYRECORD,FMASTERID,FFILTER_TAG,FCUSTOMSIGN,FISBOTP,FREPEATOP,FCTRLMESSAGE,FENABLE,FREPEATMESSAGE,FOPREAT,FID,FCTRLENTITYID,FSRCBILLIDFIELD,FSTATUS,FISLOAD,FNUMBER,FNAME,FFILTER,FPAYACCESSID,FCTRLAMTOP,FCTRLRULE,FISCTRLAMT,FISPRESET,FISREPEAT,FSRCENTITYID) VALUES ('0','1',1415289797915758592,'{"filterRow":[{"id":"2G8P42Z28KES","leftBracket":"","compareType":"106","fieldName":"bizstatus","rightBracket":"","logic":"0","value":[{"id":"2G8P42Z29B11","value":"chargeback"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,',' ','1','【离线明细导入】下推【结算中心扣款】出现重复，请检查',',submit,save,',1415289797915758592,'ifm_deduction',' ','C','0','bei_betransdetail_imp -> ifm_deduction',' ',' ',1415289293986910208,' ','LargerOrEqual','0','1','1','bei_betransdetail_imp');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2EUHTJ2BWXFU';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415289797915758592,'2EUHTJ2BWXFU','zh_CN',' ',' ','【离线明细导入】下推【结算中心扣款】出现重复，请检查',' ');
DELETE FROM t_fcs_checkctrl_l WHERE FPKID = '2EUHTJ2BWXFV';
INSERT INTO t_fcs_checkctrl_l(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1415289797915758592,'2EUHTJ2BWXFV','zh_TW',' ',' ','【離線明細導入】下推【結算中心扣款】出現重複，請檢查',' ');