/*  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 = 1417416933602549760;
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','0',1417416933602549760,'{"filterRow":[],"forList":false}',' ','0',' ','【总账付款申请单】下推【付款处理】出现超额，请检查','1',' ',',submit,save,','LargerOrEqual',1417416933602549760,'cas_paybill',' ','C','1','fr_glreim_paybill -> cas_paybill',' ',1417395430831960064,',save,submit,',' ','1','1','0','fr_glreim_paybill'); 


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2F2P8YQW+3MB';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1417416933602549760,'2F2P8YQW+3MB','zh_TW','【總賬付款申請單】下推【付款處理】出現超額，請檢查',' ',' ',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '2F2P8YQW+3MA';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1417416933602549760,'2F2P8YQW+3MA','zh_CN','【总账付款申请单】下推【付款处理】出现超额，请检查',' ',' ',' '); 


DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1417416933728378880;
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,'0','EntrySingle','e_actamt',1,'payamount','单据状态 不在……中 (退款,已作废,已退单,银行退票)',' ','付款计划分录.金额',' ',1417416933602549760,'{"expression":"","exprTran":"单据状态 不在……中 (退款,已作废,已退单,银行退票)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"2FQGYDPGQ9NB","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2FQGYDPGQ=AL","value":"I"},{"id":"2FQGYDPGQ9NC","value":"H"},{"id":"2FQGYDPGQ=AM","value":"G"},{"id":"2FQGYDPGQ9ND","value":"F"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2FQGYDPGQ9NB\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2FQGYDPGQ=AL\",\"value\":\"I\"},{\"id\":\"2FQGYDPGQ9NC\",\"value\":\"H\"},{\"id\":\"2FQGYDPGQ=AM\",\"value\":\"G\"},{\"id\":\"2FQGYDPGQ9ND\",\"value\":\"F\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不在……中 (退款,已作废,已退单,银行退票)","localeExprTran":{"zh_CN":"单据状态 不在……中 (退款,已作废,已退单,银行退票)"}}','1',1417416933728378880,'1',' ',' ','分录.实付金额',NULL,' ',' ','0',' '); 


DELETE FROM T_FCS_CHECKCTRL_SUBAMT WHERE FDETAILID = 1417416933728333826;
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":"2FQGZIJKA+GX","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"2FQGZIJK=ZTN","value":"I"},{"id":"2FQGZIJKA+GY","value":"H"},{"id":"2FQGZIJK=ZTO","value":"G"},{"id":"2FQGZIJKA+GZ","value":"F"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"2FQGZIJKA+GX\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"2FQGZIJK=ZTN\",\"value\":\"I\"},{\"id\":\"2FQGZIJKA+GY\",\"value\":\"H\"},{\"id\":\"2FQGZIJK=ZTO\",\"value\":\"G\"},{\"id\":\"2FQGZIJKA+GZ\",\"value\":\"F\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不在……中 (退款,已作废,已退单,银行退票)","localeExprTran":{"zh_CN":"单据状态 不在……中 (退款,已作废,已退单,银行退票)"}}',' ','单据状态 不在……中 (退款,已作废,已退单,银行退票)',NULL,1417416933728378880,'0',' ','分录.付款金额',1417416933728333826,'1','cas_agentpaybill',1,'e_dpamt'); 


