/*  creator：齐博旭
请注意数据库属于资金库：dbkey="tmc"
示例：<SqlScript dbkey="tmc" Separator=";" Type="KSQL">preinsdata/kd_X.X.X_fcs_checkctrl.sql</SqlScript> 
********************************************************************* 
*/ 
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1503709074154344448;
INSERT INTO T_FCS_CHECKCTRL(FISMATCH,FISBYRECORD,FMASTERID,FFILTER_TAG,FCUSTOMSIGN,FISBOTP,FREPEATOP,FCTRLMESSAGE,FENABLE,FREPEATMESSAGE,FOPREAT,FCTRLRULE,FID,FCTRLENTITYID,FSRCBILLIDFIELD,FSTATUS,FISLOAD,FNUMBER,FNAME,FPAYACCESSID,FCTRLAMTOP,FFILTER,FISCTRLAMT,FISPRESET,FISREPEAT,FSRCENTITYID) VALUES ('0','1',1503709074154344448,'{"filterRow":[],"forList":false}',' ','0',' ','【预付单】下推【代发处理】出现超额，请检查','1','【预付单】下推【代发处理】出现重复，请检查',',submit,save,','LargerOrEqual',1503709074154344448,'cas_agentpaybill',' ','C','1','er_prepaybill -> cas_agentpaybill',' ',1503708191077191680,',save,submit,',' ','1','1','0','er_prepaybill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2PP3K=HGCRCW';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1503709074154344448,'2PP3K=HGCRCW','zh_CN','【预付单】下推【代发处理】出现超额，请检查',' ','【预付单】下推【代发处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2PP3K=HGCRCX';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1503709074154344448,'2PP3K=HGCRCX','zh_TW','【預付單】下推【代發處理】出現超額，請檢查',' ','【預付單】下推【代發處理】出現重複，請檢查',' ');


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1505110717135710208;
INSERT INTO T_FCS_CHECKCTRL_AMTCTRL(FID,FSRCRULE,FTARGETRULE,FTARGETCONDITION_TAG,FENTRYID,FTARGETAMTFIELD,FSEQ,FSRCAMTFIELD,FTARGETCONDITION,FTARGETCONDITIONDESC,FSRCAMTFIELDNAME,FTARGETAMTFIELDNAME) VALUES (1503709074154344448,'EntrySingle','EntrySum','{"expression":"","exprTran":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2PVUFVZKISJ=","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2PVUFVZKGPRI","value":"F"},{"id":"2PVUFVZKISJA","value":"G"},{"id":"2PVUFVZKGPRJ","value":"H"},{"id":"2PVUFVZKISJB","value":"I"}],"baseDataIds":[]},{"id":"2PVUFVZKGPRK","leftBracket":"","compareType":"34","fieldName":"refundtype","rightBracket":"","logic":"0","value":[{"id":"2PVUFVZO56QT","value":"refund"},{"id":"2PVUFVZO33Z0","value":"renote"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2PVUFVZKISJ=\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2PVUFVZKGPRI\",\"value\":\"F\"},{\"id\":\"2PVUFVZKISJA\",\"value\":\"G\"},{\"id\":\"2PVUFVZKGPRJ\",\"value\":\"H\"},{\"id\":\"2PVUFVZKISJB\",\"value\":\"I\"}],\"baseDataIds\":[]},{\"id\":\"2PVUFVZKGPRK\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"refundtype\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2PVUFVZO56QT\",\"value\":\"refund\"},{\"id\":\"2PVUFVZO33Z0\",\"value\":\"renote\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)","localeExprTran":{"zh_CN":"单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录.退类型 不在……中 (退款,退票)"}}',1505110717135710208,'e_amount',1,'orireceiveamount',' ','单据状态 不在……中 (银行退票,已退单,已作废,退款)   and    分录......','收款信息.收款金额','分录.金额');



/*  creator：齐博旭
请注意数据库属于资金库：dbkey="tmc"
示例：<SqlScript dbkey="tmc" Separator=";" Type="KSQL">preinsdata/kd_X.X.X_fcs_checkctrl.sql</SqlScript>
*********************************************************************
*/
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1507112591561278464;
INSERT INTO T_FCS_CHECKCTRL(FISMATCH,FISBYRECORD,FMASTERID,FFILTER_TAG,FCUSTOMSIGN,FISBOTP,FREPEATOP,FCTRLMESSAGE,FENABLE,FREPEATMESSAGE,FOPREAT,FCTRLRULE,FID,FCTRLENTITYID,FSRCBILLIDFIELD,FSTATUS,FISLOAD,FNUMBER,FNAME,FPAYACCESSID,FCTRLAMTOP,FFILTER,FISCTRLAMT,FISPRESET,FISREPEAT,FSRCENTITYID) VALUES ('0','1',1507112591561278464,'{"filterRow":[{"id":"2Q3EHNUZWW2P","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2Q3EHNV1G6U6","value":"F"},{"id":"2Q3EHNV1I==7","value":"G"},{"id":"2Q3EHNV1G6U7","value":"H"},{"id":"2Q3EHNV1I==8","value":"I"}],"baseDataIds":[]}],"forList":false}','openapi_cas_paybill_save','0',',save,submit,','【】下推【】出现超额，请检查','1','OpenAP生成【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1507112591561278464,'cas_paybill',' ','C','1','openapi_cas_paybill_save ->  cas_paybill',' ',1507092894388274176,' ',' ','0','1','1',' ');
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1507228270910129152;
INSERT INTO T_FCS_CHECKCTRL(FISMATCH,FISBYRECORD,FMASTERID,FFILTER_TAG,FCUSTOMSIGN,FISBOTP,FREPEATOP,FCTRLMESSAGE,FENABLE,FREPEATMESSAGE,FOPREAT,FCTRLRULE,FID,FCTRLENTITYID,FSRCBILLIDFIELD,FSTATUS,FISLOAD,FNUMBER,FNAME,FPAYACCESSID,FCTRLAMTOP,FFILTER,FISCTRLAMT,FISPRESET,FISREPEAT,FSRCENTITYID) VALUES ('0','1',1507228270910129152,'{"filterRow":[{"id":"2Q4+3M/OQVIS","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2Q4+3M/OQUVI","value":"G"},{"id":"2Q4+3M/OQVIT","value":"H"},{"id":"2Q4+3M/OQUVJ","value":"I"},{"id":"2Q4+3M/OQVIU","value":"F"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【】下推【】出现超额，请检查','1','【供应链融资还款处理】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1507228270910129152,'cas_paybill',' ','C','1','scf_finrepaybill -> cas_paybill',' ',1507226116849812480,' ',' ','0','1','1','scf_finrepaybill');
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1507228936420344832;
INSERT INTO T_FCS_CHECKCTRL(FISMATCH,FISBYRECORD,FMASTERID,FFILTER_TAG,FCUSTOMSIGN,FISBOTP,FREPEATOP,FCTRLMESSAGE,FENABLE,FREPEATMESSAGE,FOPREAT,FCTRLRULE,FID,FCTRLENTITYID,FSRCBILLIDFIELD,FSTATUS,FISLOAD,FNUMBER,FNAME,FPAYACCESSID,FCTRLAMTOP,FFILTER,FISCTRLAMT,FISPRESET,FISREPEAT,FSRCENTITYID) VALUES ('0','1',1507228936420344832,'{"filterRow":[{"id":"2Q4+8G9PF+OT","leftBracket":"","compareType":"106","fieldName":"paidstatus","rightBracket":"","logic":"0","value":[{"id":"2Q4+8G9PF/C1","value":"C"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【】下推【】出现超额，请检查','1','【供应链融资还款处理】下推【付款交易处理】出现重复，请检查',',submit,save,','LargerOrEqual',1507228936420344832,'ifm_transhandlebill',' ','C','1','scf_finrepaybill -> ifm_transhandlebill',' ',1507225883956888576,' ',' ','0','1','1','scf_finrepaybill');
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1507229316566892544;
INSERT INTO T_FCS_CHECKCTRL(FISMATCH,FISBYRECORD,FMASTERID,FFILTER_TAG,FCUSTOMSIGN,FISBOTP,FREPEATOP,FCTRLMESSAGE,FENABLE,FREPEATMESSAGE,FOPREAT,FCTRLRULE,FID,FCTRLENTITYID,FSRCBILLIDFIELD,FSTATUS,FISLOAD,FNUMBER,FNAME,FPAYACCESSID,FCTRLAMTOP,FFILTER,FISCTRLAMT,FISPRESET,FISREPEAT,FSRCENTITYID) VALUES ('0','1',1507229316566892544,'{"filterRow":[{"id":"2Q4+A8=DWI0P","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2Q4+A8=DWIPZ","value":"F"},{"id":"2Q4+A8=DWI0Q","value":"G"},{"id":"2Q4+A8=DWIQ+","value":"H"},{"id":"2Q4+A8=DWI0R","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',',save,submit,','【】下推【】出现超额，请检查','1','【供应链融资债权业务处理】下推【付款处理】出现重复，请检查',',submit,save,','LargerOrEqual',1507229316566892544,'cas_paybill',' ','C','1','scf_fincreditbill -> cas_paybill',' ',1507225607753580544,' ',' ','0','1','1','scf_fincreditbill');


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2Q3EHO11=XD=';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1507112591561278464,'2Q3EHO11=XD=','zh_CN','【】下推【】出现超额，请检查',' ','OpenAP生成【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2Q3EHO11=XDA';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1507112591561278464,'2Q3EHO11=XDA','zh_TW',' ',' ','OpenAP生成【付款處理】出現重複，請檢查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2Q4+3M81276O';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1507228270910129152,'2Q4+3M81276O','zh_CN','【】下推【】出现超额，请检查',' ','【供应链融资还款处理】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2Q4+3M81276P';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1507228270910129152,'2Q4+3M81276P','zh_TW',' ',' ','【供應鏈融資還款處理】下推【付款處理】出現重複，請檢查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2Q4+8GBOG9V7';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1507228936420344832,'2Q4+8GBOG9V7','zh_CN','【】下推【】出现超额，请检查',' ','【供应链融资还款处理】下推【付款交易处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2Q4+8GBOG9V8';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1507228936420344832,'2Q4+8GBOG9V8','zh_TW',' ',' ','【供應鏈融資還款處理】下推【付款交易處理】出現重複，請檢查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2Q4+A8D3Y4EG';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1507229316566892544,'2Q4+A8D3Y4EG','zh_CN','【】下推【】出现超额，请检查',' ','【供应链融资债权业务处理】下推【付款处理】出现重复，请检查',' ');
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2Q4+A8D3Y4EH';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1507229316566892544,'2Q4+A8D3Y4EH','zh_TW',' ',' ','【供應鏈融資債權業務處理】下推【付款處理】出現重複，請檢查',' ');





