/*  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 = 1714082286682529792;
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',1714082286682529792,'{"filterRow":[{"id":"3DOQAICO/3TW","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3DOQAICO/34M","value":"F"},{"id":"3DOQAICO/3TX","value":"G"},{"id":"3DOQAICO/34N","value":"H"},{"id":"3DOQAICO/3TY","value":"I"}],"baseDataIds":[]}],"forList":false}',' ','0',' ','【付款申请】下推【付款处理】出现超额，请检查！','1','【付款申请】下推【付款处理】出现重复，请检查！',',submit,save,','LargerOrEqual',1714082286682529792,'cas_paybill',' ','C','1','ap_payapply -> cas_paybill',' ',1419551782748568576,',save,submit,',' ','1','0','0','ap_payapply'); 
DELETE FROM T_FCS_CHECKCTRL WHERE FID = 1714085318317073408;
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',1714085318317073408,'{"filterRow":[{"id":"3DOQGOC3/727","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3DOQGOC3/7RG","value":"G"}],"baseDataIds":[]}],"forList":false}',' ','0',' ','【财务应收】下推【收款处理】出现超额，请检查！','1','【财务应收】下推【收款处理】出现重复，请检查！',',submit,save,','LargerOrEqual',1714085318317073408,'cas_recbill',' ','C','1','ar_finarbill -> cas_recbill',' ',1419552486426950656,',save,submit,',' ','1','0','0','ar_finarbill'); 


DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3CJ+X=N+QGNV';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1714082286682529792,'3CJ+X=N+QGNV','zh_CN','【付款申请】下推【付款处理】出现超额，请检查！',' ','【付款申请】下推【付款处理】出现重复，请检查！',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3CJ+X=N+QGNW';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1714082286682529792,'3CJ+X=N+QGNW','zh_TW','【付款申請】下推【付款處理】出現超額，請檢查！',' ','【付款申請】下推【付款處理】出現重複，請檢查！',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3CJ/GD7777SY';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1714085318317073408,'3CJ/GD7777SY','zh_CN','【财务应收】下推【收款处理】出现超额，请检查！',' ','【财务应收】下推【收款处理】出现重复，请检查！',' '); 
DELETE FROM T_FCS_CHECKCTRL_L WHERE FPKID = '3CJ/GD7777SZ';
INSERT INTO T_FCS_CHECKCTRL_L(FID,FPKID,FLOCALEID,FCTRLMESSAGE,FCOMMENT,FREPEATMESSAGE,FNAME) VALUES (1714085318317073408,'3CJ/GD7777SZ','zh_TW','【財務應收】下推【收款處理】出現超額，請檢查！',' ','【財務應收】下推【收款處理】出現重複，請檢查！',' '); 


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 = 1714085318367405057;
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','EntrySum','e_receivableamt',2,'recamount','单据状态 不在……中 (已退单)',' ','单据头.应收金额',' ',1714085318317073408,'{"expression":"","exprTran":"单据状态 不在……中 (已退单)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3CJ/DC88FVNR","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3CJ/DC88FV+H","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3CJ/DC88FVNR\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3CJ/DC88FV+H\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (已退单)"},"exprDesc":"单据状态 不在……中 (已退单)"}','1',1714085318367405057,'1',' ',' ','收款明细.应收金额',NULL,' ',' ','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','分录.应付金额-分录.退款金额'); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1714085318367405056;
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 ('EntrySum','{"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\""}',NULL,'0','EntrySum','e_receivableamt',1,'e_recamount','单据状态 不在……中 (已退单)',' ','明细.应收金额',' ',1714085318317073408,'{"expression":"","exprTran":"单据状态 不在……中 (已退单)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3CJ/BGSKU9B8","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3CJ/BGSKU8O+","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3CJ/BGSKU9B8\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3CJ/BGSKU8O+\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"exprDesc":"单据状态 不在……中 (已退单)","localeExprTran":{"zh_CN":"单据状态 不在……中 (已退单)"}}','1',1714085318367405056,'1',' ','GetSysParam(''/BBRH+122=39'', '''', 结算组织.内码(......','收款明细.应收金额',NULL,' ',' ','0',' '); 
DELETE FROM T_FCS_CHECKCTRL_AMTCTRL WHERE FENTRYID = 1714085318367405058;
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 ('EntrySum','{"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\""}',NULL,'0','EntrySum','e_receivableamt',3,'planpricetax','单据状态 不在……中 (已退单)',' ','收款计划.应收金额',' ',1714085318317073408,'{"expression":"","exprTran":"单据状态 不在……中 (已退单)","description":{"zh_CN":""},"filterCondition":{"filterRow":[{"id":"3CJ/G=4SFQJ2","leftBracket":"","compareType":"34","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3CJ/G=4SFR7B","value":"G"}],"baseDataIds":[]}],"forList":false},"filterString":"{\"filterRow\":[{\"id\":\"3CJ/G=4SFQJ2\",\"leftBracket\":\"\",\"compareType\":\"34\",\"fieldName\":\"billstatus\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3CJ/G=4SFR7B\",\"value\":\"G\"}],\"baseDataIds\":[]}],\"forList\":false}","initialized":false,"localeExprTran":{"zh_CN":"单据状态 不在……中 (已退单)"},"exprDesc":"单据状态 不在……中 (已退单)"}','1',1714085318367405058,'1',' ','GetSysParam(''/BBRH+122=39'', '''', 结算组织.内码(......','收款明细.应收金额',NULL,' ',' ','0',' '); 




