/*
修复理财申购余额配置的发生额分录的业务日期字段配置
*/
DELETE FROM t_fcs_billdimbalance WHERE FID = 1686136709198126080;
INSERT INTO t_fcs_billdimbalance(FID,FBILLBALENTITY,FAUDITORID,FSTARTDATEPROP,FBILLENTITY,FBILLIDPROP,FBILLFILTER,FNAME,FBILLSTATUS,FCURRENCYPROP,FAUDITDATE,FBILLNO,FCREATETIME,FLASTBALTIME,FMODIFIERID,FENDDATEPROP,FENABLE,FCREATEBALCYCLE,FBILLFILTER_TAG,FMODIFYTIME,FORGPROP,FDIMENPROPS,FCREATORID) VALUES (1686136709198126080,'cim_finsubscribebal',0,'intdate','cim_finsubscribe','id',' ','理财申购余额配置','A','currency',NULL,'BDB-00000003',{ts'2023-06-01  00:00:00'},{ts'2023-08-30  00:00:00'},13466739,'cleardate','1','m','{"filterRow":[{"id":"3IKDM=4MHAPP","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3IKDM=4MHBCZ","value":"C"}],"baseDataIds":[]},{"id":"3IKDM=4MHAPQ","leftBracket":"((","compareType":"105","fieldName":"tradechannel","rightBracket":"","logic":"0","value":[{"id":"3IKDM=4MHBD+","value":"online"}],"baseDataIds":[]},{"id":"3IKDM=4MHAPR","leftBracket":"","compareType":"105","fieldName":"bebankstatus","rightBracket":")","logic":"1","value":[{"id":"3IKDM=4MHBD/","value":"TS"}],"baseDataIds":[]},{"id":"3IKDM=4MHAPS","leftBracket":"","compareType":"105","fieldName":"tradechannel","rightBracket":")","logic":"0","value":[{"id":"3IKDM=4MHBD0","value":"offline"}],"baseDataIds":[]}],"forList":false}',{ts'2023-08-30  00:00:00'},'org',',,',0);

DELETE FROM t_fcs_billdimbalance_ae WHERE FID = 1686136709198126080;
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1686136709198126080,'amount','billstatus = ''C''',' ',1706496020181248000,' ',2,'id','valuedate','c','{"filterRow":[{"id":"3BLNEUHTK4BT","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BLNEUHTM8H2","value":"C"}],"baseDataIds":[]}],"forList":false}','cim_finsubscribe');
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1686136709198126080,'amount - case when redeemway = ''copies_redeem'' then realrevenue else 0 end','billstatus = ''C'' AND (tradechannel = ''online'' AND bebankstatus = ''TS'' OR tradechannel = ''offline'')',' ',1686136709198126081,' ',1,'finbillno.id','redeemdate','d','{"filterRow":[{"id":"3IKFDLDR6H7H","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3IKFDLDR6GJ8","value":"C"}],"baseDataIds":[]},{"id":"3IKFDLDR6H7I","leftBracket":"((","compareType":"105","fieldName":"tradechannel","rightBracket":"","logic":"0","value":[{"id":"3IKFDLDR6GJ9","value":"online"}],"baseDataIds":[]},{"id":"3IKFDLDR6H7J","leftBracket":"","compareType":"105","fieldName":"bebankstatus","rightBracket":")","logic":"1","value":[{"id":"3IKFDLDR6GJ=","value":"TS"}],"baseDataIds":[]},{"id":"3IKFDLDR6H7K","leftBracket":"","compareType":"105","fieldName":"tradechannel","rightBracket":")","logic":"0","value":[{"id":"3IKFDLDR6GJA","value":"offline"}],"baseDataIds":[]}],"forList":false}','cim_redeem');

DELETE FROM t_fcs_billdimbalance WHERE FID = 1686136555971805184;
INSERT INTO t_fcs_billdimbalance(FID,FBILLBALENTITY,FAUDITORID,FSTARTDATEPROP,FBILLENTITY,FBILLIDPROP,FBILLFILTER,FNAME,FBILLSTATUS,FCURRENCYPROP,FAUDITDATE,FBILLNO,FCREATETIME,FLASTBALTIME,FMODIFIERID,FENDDATEPROP,FENABLE,FCREATEBALCYCLE,FBILLFILTER_TAG,FMODIFYTIME,FORGPROP,FDIMENPROPS,FCREATORID) VALUES (1686136555971805184,'cim_depositbal',0,'bizdate','cim_deposit','id',' ','存款余额配置','A','currency',NULL,'BDB-00000002',{ts'2023-06-01  00:00:00'},{ts'2023-08-30  00:00:00'},13466739,'cleardate','1','m','{"filterRow":[{"id":"3IKFQ1KJ40B0","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3IKFQ1KJ4/NS","value":"C"}],"baseDataIds":[]},{"id":"3IKFQ1KJ40B1","leftBracket":"((","compareType":"105","fieldName":"tradechannel","rightBracket":"","logic":"0","value":[{"id":"3IKFQ1KJ4/NT","value":"online"}],"baseDataIds":[]},{"id":"3IKFQ1KJ40B2","leftBracket":"","compareType":"105","fieldName":"bebankstatus","rightBracket":")","logic":"1","value":[{"id":"3IKFQ1KJ4/NU","value":"TS"}],"baseDataIds":[]},{"id":"3IKFQ1KJ40B3","leftBracket":"","compareType":"105","fieldName":"tradechannel","rightBracket":")","logic":"0","value":[{"id":"3IKFQ1KJ4/NV","value":"offline"}],"baseDataIds":[]}],"forList":false}',{ts'2023-08-30  00:00:00'},'org',',,',0);

DELETE FROM t_fcs_billdimbalance_ae WHERE FID = 1686136555971805184;
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1686136555971805184,'amount','billstatus = ''C''',' ',1706007548064415744,' ',2,'id','bizdate','c','{"filterRow":[{"id":"3BJA59YSHDO/","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BJA59YSJH40","value":"C"}],"baseDataIds":[]}],"forList":false}','cim_deposit');
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1686136555971805184,'srcprincipal','billstatus = ''C''',' ',1763217239965818880,' ',3,'srcdepositid','bizdate','d','{"filterRow":[{"id":"3IKDJPK2WN8K","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3IKDJPK2WMKA","value":"C"}],"baseDataIds":[]}],"forList":false}','cim_deposit');
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1686136555971805184,'amount','billstatus = ''C'' AND (tradechannel = ''online'' AND bebankstatus = ''TS'' OR tradechannel = ''offline'')',' ',1686136555971805185,' ',1,'finbillno.id','redeemdate','d','{"filterRow":[{"id":"3IKG9256AYJT","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3IKG9256AZ81","value":"C"}],"baseDataIds":[]},{"id":"3IKG9256AYJU","leftBracket":"((","compareType":"105","fieldName":"tradechannel","rightBracket":"","logic":"0","value":[{"id":"3IKG9256AZ82","value":"online"}],"baseDataIds":[]},{"id":"3IKG9256AYJV","leftBracket":"","compareType":"105","fieldName":"bebankstatus","rightBracket":")","logic":"1","value":[{"id":"3IKG9256AZ83","value":"TS"}],"baseDataIds":[]},{"id":"3IKG9256AYJW","leftBracket":"","compareType":"105","fieldName":"tradechannel","rightBracket":")","logic":"0","value":[{"id":"3IKG9256AZ84","value":"offline"}],"baseDataIds":[]}],"forList":false}','cim_release');
