DELETE FROM t_fcs_billdimbalance WHERE FID = 1818163672770850816;
INSERT INTO t_fcs_billdimbalance(FID,FBILLBALENTITY,FAUDITORID,FSTARTDATEPROP,FNAME,FBILLFILTER,FBILLENTITY,FBILLIDPROP,FBILLSTATUS,FCURRENCYPROP,FAUDITDATE,FCREATETIME,FBILLNO,FLASTBALTIME,FMODIFIERID,FENDDATEPROP,FENABLE,FCREATEBALCYCLE,FISPRESET,FBILLFILTER_TAG,FMODIFYTIME,FDIMENPROPS,FORGPROP,FCREATORID) VALUES (1818163672770850816,'cfm_loanbill_investbal',0,'bizdate','放款余额配置',' ','cim_invest_loanbill','id','C','currency',NULL,{ts'2023-06-01  00:00:00'},'BDB-00000020',NULL,0,'cleardate','1','m','1','{"filterRow":[{"id":"3PLAUA0GMMPO","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3PLAUA0GMNCY","value":"C"}],"baseDataIds":[]},{"id":"3PLAUA0GMMPP","leftBracket":"","compareType":"105","fieldName":"confirmstatus","rightBracket":"","logic":"0","value":[{"id":"3PLAUA0GMNCZ","value":"yetconfirm"}],"baseDataIds":[]},{"id":"3PLAUA0GMMPQ","leftBracket":"","compareType":"17","fieldName":"creditortype","rightBracket":"","logic":"0","value":[{"id":"3PLAUA0GMND+","value":"innerunit"},{"id":"3PLAUA0GMMPR","value":"settlecenter"}],"baseDataIds":[]},{"id":"3PLAUA0GMND/","leftBracket":"","compareType":"9","fieldName":"creditorg.number","rightBracket":"","logic":"0","value":[{"id":"3PLAUA0GMMPS","value":""}],"baseDataIds":[]}],"forList":false}',NULL,',,','creditorg',0);
DELETE FROM t_fcs_billdimbalance_L WHERE FPKID = '3PAN1KLHMFKW';
INSERT INTO t_fcs_billdimbalance_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1818163672770850816,'3PAN1KLHMFKW','zh_TW','放款餘額配置');
DELETE FROM t_fcs_billdimbalance_L WHERE FPKID = '3PAN1KLHMFKX';
INSERT INTO t_fcs_billdimbalance_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1818163672770850816,'3PAN1KLHMFKX','zh_CN','放款余额配置');
DELETE FROM t_fcs_billdimbalance_ae WHERE FENTRYID = 1818163672770726912;
INSERT INTO t_fcs_billdimbalance_ae(FID,FFILTERSET,FAMOUNTPROP,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FBIZDATEPROP,FSRCBILLPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1818163672770850816,'billstatus = ''C'' AND confirmstatus = ''yetconfirm''','amount',' ',1818163672770726912,' ',1,'bizdate','id','c','{"filterRow":[{"id":"3PAMSDAS4CJ5","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3PAMSDAS2=24","value":"C"}],"baseDataIds":[]},{"id":"3PAMSDAS4CJ6","leftBracket":"","compareType":"105","fieldName":"confirmstatus","rightBracket":"","logic":"0","value":[{"id":"3PAMSDAS2=25","value":"yetconfirm"}],"baseDataIds":[]}],"forList":false}','cim_invest_loanbill');
DELETE FROM t_fcs_billdimbalance_ae WHERE FENTRYID = 1818163672770726913;
INSERT INTO t_fcs_billdimbalance_ae(FID,FFILTERSET,FAMOUNTPROP,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FBIZDATEPROP,FSRCBILLPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1818163672770850816,'billstatus = ''C'' AND confirmstatus = ''yetconfirm''','loans.e_repayamount',' ',1818163672770726913,' ',2,'bizdate','loans.e_loanbill.id','d','{"filterRow":[{"id":"3PAN10PRO/1+","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3PAN10PRQ2I/","value":"C"}],"baseDataIds":[]},{"id":"3PAN10PRO/1/","leftBracket":"","compareType":"105","fieldName":"confirmstatus","rightBracket":"","logic":"0","value":[{"id":"3PAN10PRQ2I0","value":"yetconfirm"}],"baseDataIds":[]}],"forList":false}','cfm_repaymentbill');
DELETE FROM t_fcs_billdimbalance_be WHERE FENTRYID = 1818163672770726914;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1818163672770850816,1818163672770726914,'id',1,'accountbank');
DELETE FROM t_fcs_billdimbalance_be WHERE FENTRYID = 1818163672770726915;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1818163672770850816,1818163672770726915,'org',2,'company');
DELETE FROM t_fcs_billdimbalance_be WHERE FENTRYID = 1818163672770726916;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1818163672770850816,1818163672770726916,'currency',3,'currency');
DELETE FROM t_fcs_billdimbalance_be WHERE FENTRYID = 1818163672770726917;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1818163672770850816,1818163672770726917,'bizdate',4,'bizdate');
DELETE FROM t_fcs_billdimbalance_be WHERE FENTRYID = 1818163672770726918;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1818163672770850816,1818163672770726918,'amount',5,'amount');
DELETE FROM t_fcs_billdimbalance_be WHERE FENTRYID = 1818163672770726919;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1818163672770850816,1818163672770726919,'debitamount',6,'debitamount');
DELETE FROM t_fcs_billdimbalance_be WHERE FENTRYID = 1818163672770726920;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1818163672770850816,1818163672770726920,'creditamount',7,'creditamount');
DELETE FROM t_fcs_billdimbalance_be WHERE FENTRYID = 1818163672770726921;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1818163672770850816,1818163672770726921,'lstbalance',8,'lstbalance');
DELETE FROM t_fcs_billdimbalance_be WHERE FENTRYID = 1818163672770726922;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1818163672770850816,1818163672770726922,'valibalance',9,'valibalance');


UPDATE t_fcs_billdimbalance SET FBILLSTATUS = 'C', FISPRESET = '1', FBILLFILTER_TAG  = '{"filterRow":[{"id":"3PLAS7SWHSB/","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3PLAS7SWHRNR","value":"C"}],"baseDataIds":[]},{"id":"3PLAS7SWHSB0","leftBracket":"","compareType":"105","fieldName":"confirmstatus","rightBracket":"","logic":"0","value":[{"id":"3PLAS7SWHRNS","value":"yetconfirm"}],"baseDataIds":[]},{"id":"3PLAS7SWHSB1","leftBracket":"","compareType":"17","fieldName":"loantype","rightBracket":"","logic":"0","value":[{"id":"3PLAS7SWHRNT","value":"loan"},{"id":"3PLAS7SWHSB2","value":"sl"},{"id":"3PLAS7SWHRNU","value":"ec"},{"id":"3PLAS7SWHSB3","value":"entrust"}],"baseDataIds":[]},{"id":"3PLAS7SWHRNV","leftBracket":"","compareType":"9","fieldName":"org.number","rightBracket":"","logic":"0","value":[{"id":"3PLAS7SWHSB4","value":""}],"baseDataIds":[]},{"id":"3PLAS7SWHRNW","leftBracket":"","compareType":"9","fieldName":"bizdate","rightBracket":"","logic":"0","value":[{"id":"3PLAS7SWHSB5","value":""}],"baseDataIds":[]}],"forList":false}' WHERE FID = 1686136441073048576;
DELETE FROM t_fcs_billdimbalance_ae WHERE FENTRYID = 1686136441073048577;
INSERT INTO t_fcs_billdimbalance_ae(FID,FFILTERSET,FAMOUNTPROP,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FBIZDATEPROP,FSRCBILLPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1686136441073048576,'billstatus = ''C'' AND confirmstatus = ''yetconfirm''','loans.e_repayamount',' ',1686136441073048577,' ',1,'bizdate','loans.e_loanbill.id','d','{"filterRow":[{"id":"3PAO4FBHPHBC","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3PAO4FBHRKTD","value":"C"}],"baseDataIds":[]},{"id":"3PAO4FBHPHBD","leftBracket":"","compareType":"105","fieldName":"confirmstatus","rightBracket":"","logic":"0","value":[{"id":"3PAO4FBHRKTE","value":"yetconfirm"}],"baseDataIds":[]}],"forList":false}','cfm_repaymentbill');
DELETE FROM t_fcs_billdimbalance_ae WHERE FENTRYID = 1706495163175763968;
INSERT INTO t_fcs_billdimbalance_ae(FID,FFILTERSET,FAMOUNTPROP,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FBIZDATEPROP,FSRCBILLPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1686136441073048576,'billstatus = ''C'' AND confirmstatus = ''yetconfirm''','drawamount',' ',1706495163175763968,' ',2,'bizdate','id','c','{"filterRow":[{"id":"3PAO55ROC7CO","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3PAO55ROE=UP","value":"C"}],"baseDataIds":[]},{"id":"3PAO55ROC7CP","leftBracket":"","compareType":"105","fieldName":"confirmstatus","rightBracket":"","logic":"0","value":[{"id":"3PAO55ROE=UQ","value":"yetconfirm"}],"baseDataIds":[]}],"forList":false}','cfm_loanbill');


/** 更新状态和是否为预置 */
UPDATE t_fcs_billdimbalance set FBILLSTATUS = 'C', FISPRESET = '1' where FID in (1818163672770850816,1686136832393223168,1686136709198126080,1686136555971805184,1686136441073048576,1708012716871946240,1701432699467631616,1701431918815381504,1692857804408374272,1688425606389396480,1692868648345146368,1692868010072979456,1690603315936734208);