/* t_fcs_billdimbalance */
DELETE FROM t_fcs_billdimbalance WHERE FID = 1692857804408374272;
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 (1692857804408374272,'lc_receiptbal',0,'applydate','lc_receipt','id',' ','收证余额配置','A','currency',NULL,'BDB-00000007',{ts'2023-06-01  00:00:00'},NULL,0,' ','1','m','{"filterRow":[{"id":"3BLNN27IIK1D","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BLNN27IKO6O","value":"C"}],"baseDataIds":[]}],"forList":false}',NULL,'org',' ',0);
DELETE FROM t_fcs_billdimbalance WHERE FID = 1692868010072979456;
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 (1692868010072979456,'scf_fincreditbillbal',0,'startdate','scf_fincreditbill','id',' ','供应链债权余额设置','A','currency',NULL,'BDB-00000009',{ts'2023-06-01  00:00:00'},NULL,0,'enddate','1','m','{"filterRow":[{"id":"3BLNXCMDR2QV","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BLNXCMDP+LK","value":"C"}],"baseDataIds":[]}],"forList":false}',NULL,'org',' ',0);
DELETE FROM t_fcs_billdimbalance WHERE FID = 1692868648345146368;
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 (1692868648345146368,'scf_findebtsbillbal',0,'startdate','scf_findebtsbill','id',' ','供应链债务余额设置','A','currency',NULL,'BDB-00000010',{ts'2023-06-01  00:00:00'},NULL,0,'enddate','1','m','{"filterRow":[{"id":"3BLO+I0=XQV4","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BLO+I0=VMPV","value":"C"}],"baseDataIds":[]}],"forList":false}',NULL,'org',' ',0);
DELETE FROM t_fcs_billdimbalance WHERE FID = 1686136832393223168;
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 (1686136832393223168,'ifm_accountbalance',0,'opendate','bd_accountbanks','id',' ','内部账户余额配置','A','defaultcurrency',NULL,'BDB-00000004',{ts'2023-06-01  00:00:00'},NULL,0,'closedate','1','d','{"filterRow":[{"id":"3=O00VHC67+Z","leftBracket":"","compareType":"9","fieldName":"inneracct.number","rightBracket":"","logic":"0","value":[{"id":"3=O00VHC66AP","value":""}],"baseDataIds":[]},{"id":"3=O00VHC67/+","leftBracket":"","compareType":"105","fieldName":"finorgtype","rightBracket":"","logic":"0","value":[{"id":"3=O00VHC66AQ","value":"1"}],"baseDataIds":[]}],"forList":false}',NULL,'company',',,',0);
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'},NULL,0,'cleardate','1','m','{"filterRow":[{"id":"3BLNCOJSKJ+M","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BLNCOJSIEVB","value":"C"}],"baseDataIds":[]}],"forList":false}',NULL,'org',',,',0);
DELETE FROM t_fcs_billdimbalance WHERE FID = 1688425606389396480;
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 (1688425606389396480,'fbd_suretybillbal',0,'intdate','fbd_suretybill','id',' ','保证金额余额设置','A','currency',NULL,'BDB-00000005',{ts'2023-06-01  00:00:00'},NULL,0,'expiredate','1','m','{"filterRow":[{"id":"3BLNG5W=756F","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BLNG5W=99AQ","value":"C"}],"baseDataIds":[]}],"forList":false}',NULL,'org',' ',0);
DELETE FROM t_fcs_billdimbalance WHERE FID = 1690603315936734208;
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 (1690603315936734208,'lc_lettercreditbal',0,'applydate','lc_lettercredit','id',' ','开证余额配置','A','currency',NULL,'BDB-00000006',{ts'2023-06-01  00:00:00'},NULL,0,' ','1','m','{"filterRow":[{"id":"3BLNJNKM3YF7","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BLNJNKM60KH","value":"C"}],"baseDataIds":[]}],"forList":false}',NULL,'org',' ',0);
DELETE FROM t_fcs_billdimbalance WHERE FID = 1686136441073048576;
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 (1686136441073048576,'cfm_loanbillbal',0,'bizdate','cfm_loanbill','id',' ','贷款余额配置','A','currency',NULL,'BDB-00000001',{ts'2023-06-01  00:00:00'},NULL,0,'cleardate','1','m','{"filterRow":[{"id":"3BSYCG8DH35Q","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BSYCG8DFDIB","value":"C"}],"baseDataIds":[]},{"id":"3BSYCG8DH35R","leftBracket":"","compareType":"105","fieldName":"confirmstatus","rightBracket":"","logic":"0","value":[{"id":"3BSYCG8DFDIC","value":"yetconfirm"}],"baseDataIds":[]},{"id":"3BSYCG8DH35S","leftBracket":"","compareType":"17","fieldName":"loantype","rightBracket":"","logic":"0","value":[{"id":"3BSYCG8DFDID","value":"loan"},{"id":"3BSYCG8DH35T","value":"sl"},{"id":"3BSYCG8DFDIE","value":"ec"},{"id":"3BSYCG8DH35U","value":"entrust"}],"baseDataIds":[]}],"forList":false}',NULL,'org',' ',0);
DELETE FROM t_fcs_billdimbalance WHERE FID = 1708012716871946240;
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 (1708012716871946240,'cfm_loanbill_bondbal',0,'bizdate','cfm_loanbill_bond','id',' ','发债余额配置','A','currency',NULL,'BDB-00000019',{ts'2023-06-01  00:00:00'},NULL,0,'cleardate','1','m','{"filterRow":[{"id":"3BT++ZHLREX4","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BT++ZHLT4JI","value":"C"}],"baseDataIds":[]},{"id":"3BT++ZHLREX5","leftBracket":"","compareType":"105","fieldName":"confirmstatus","rightBracket":"","logic":"0","value":[{"id":"3BT++ZHLT4JJ","value":"yetconfirm"}],"baseDataIds":[]},{"id":"3BT++ZHLREX6","leftBracket":"","compareType":"105","fieldName":"loantype","rightBracket":"","logic":"0","value":[{"id":"3BT++ZHLT4JK","value":"bond"}],"baseDataIds":[]}],"forList":false}',NULL,'org',' ',0);
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'},NULL,0,'cleardate','1','m','{"filterRow":[{"id":"3BJA2Z49C5Z5","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BJA2Z49E9E6","value":"C"}],"baseDataIds":[]}],"forList":false}',NULL,'org',',,',0);


/* t_fcs_billdimbalance_ae */
DELETE FROM t_fcs_billdimbalance_ae WHERE FID = 1692857804408374272;
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1692857804408374272,'amount','billstatus = ''C''',' ',1706497872025059328,' ',2,'id','applydate','c','{"filterRow":[{"id":"3BLNSGH7C6A+","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BLNSGH7A25P","value":"C"}],"baseDataIds":[]}],"forList":false}','lc_receipt');
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1692857804408374272,'arrivalamount','billstatus = ''C'' AND arrivalstatus = ''present_confirm''',' ',1692857804408374273,' ',1,'lettercredit.id','arrivaldate','d','{"filterRow":[{"id":"3=YA6PJRE46T","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3=YA6PJR=Z9R","value":"C"}],"baseDataIds":[]},{"id":"3=YA6PJRE46U","leftBracket":"","compareType":"105","fieldName":"arrivalstatus","rightBracket":"","logic":"0","value":[{"id":"3=YA6PJR=Z9S","value":"present_confirm"}],"baseDataIds":[]}],"forList":false}','lc_present');

DELETE FROM t_fcs_billdimbalance_ae WHERE FID = 1686136441073048576;
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES(1686136441073048576,'loans.e_repayamount','billstatus = ''C'' AND confirmstatus = ''yetconfirm'' AND loantype IN (''loan'',''sl'',''entrust'',''ec'')',' ',1686136441073048577,' ',1,'loans.e_loanbill.id','bizdate','d','{"filterRow":[{"id":"3BSYETQOW6PW","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BSYETQOXXC9","value":"C"}],"baseDataIds":[]},{"id":"3BSYETQOW6PX","leftBracket":"","compareType":"105","fieldName":"confirmstatus","rightBracket":"","logic":"0","value":[{"id":"3BSYETQOXXC=","value":"yetconfirm"}],"baseDataIds":[]},{"id":"3BSYETQOW6PY","leftBracket":"","compareType":"17","fieldName":"loantype","rightBracket":"","logic":"0","value":[{"id":"3BSYETQOXXCA","value":"loan"},{"id":"3BSYETQOW6PZ","value":"sl"},{"id":"3BSYETQOXXCB","value":"ec"},{"id":"3BSYETQOW6Q+","value":"entrust"}],"baseDataIds":[]}],"forList":false}','cfm_repaymentbill');
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES(1686136441073048576,'drawamount','billstatus = ''C'' AND confirmstatus = ''yetconfirm'' AND loantype IN (''loan'',''sl'',''entrust'',''ec'')',' ',1706495163175763968,' ',2,'id','bizdate','c','{"filterRow":[{"id":"3BSYBLVUN1TC","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BSYBLVUOSFR","value":"C"}],"baseDataIds":[]},{"id":"3BSYBLVUN1TD","leftBracket":"","compareType":"105","fieldName":"confirmstatus","rightBracket":"","logic":"0","value":[{"id":"3BSYBLVUOSFS","value":"yetconfirm"}],"baseDataIds":[]},{"id":"3BSYBLVUN1TE","leftBracket":"","compareType":"17","fieldName":"loantype","rightBracket":"","logic":"0","value":[{"id":"3BSYBLVUOSFT","value":"entrust"},{"id":"3BSYBLVUN1TF","value":"ec"},{"id":"3BSYBLVUOSFU","value":"sl"},{"id":"3BSYBLVUN1TG","value":"loan"}],"baseDataIds":[]}],"forList":false}','cfm_loanbill');



DELETE FROM t_fcs_billdimbalance_ae WHERE FID = 1692868648345146368;
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1692868648345146368,'amount','billstatus = ''C''',' ',1695570436756204544,' ',1,'findebtsbillf7.id','bizdate','d','{"filterRow":[{"id":"3A9AHLZNB+HT","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3A9AHLZN9XQ0","value":"C"}],"baseDataIds":[]}],"forList":false}','scf_finrepaybill');
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1692868648345146368,'amount','billstatus = ''C''',' ',1706499306309380096,' ',2,'id','loandate','c','{"filterRow":[{"id":"3BLO1/D42+DX","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BLO1/D442J6","value":"C"}],"baseDataIds":[]}],"forList":false}','scf_findebtsbill');


DELETE FROM t_fcs_billdimbalance_ae WHERE FID = 1692868010072979456;
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1692868010072979456,'amount','billstatus = ''C''',' ',1695571424212929536,' ',1,'fincreditbillf7.id','recdate','d','{"filterRow":[{"id":"3A9AL295U6/D","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3A9AL295S37M","value":"C"}],"baseDataIds":[]}],"forList":false}','scf_finrecbill');
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1692868010072979456,'amount','billstatus = ''C''',' ',1706498861235005440,' ',2,'id','recdate','c','{"filterRow":[{"id":"3BLNZQ5G/OFV","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BLNZQ5G1SL4","value":"C"}],"baseDataIds":[]}],"forList":false}','scf_fincreditbill');


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''',' ',1686136555971805185,' ',1,'finbillno.id','redeemdate','d','{"filterRow":[{"id":"37JL5C930T=B","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"37JL5C93+PUA","value":"C"}],"baseDataIds":[]}],"forList":false}','cim_release');
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');


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''',' ',1686136709198126081,' ',1,'finbillno.id','redeemdate','d','{"filterRow":[{"id":"37JLFVBPPXS1","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"37JLFVBPS/82","value":"C"}],"baseDataIds":[]}],"forList":false}','cim_redeem');
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','intdate','c','{"filterRow":[{"id":"3BLNEUHTK4BT","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BLNEUHTM8H2","value":"C"}],"baseDataIds":[]}],"forList":false}','cim_finsubscribe');

DELETE FROM t_fcs_billdimbalance_ae WHERE FID = 1686136832393223168;
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1686136832393223168,'creditamount',' ',' ',1686136832401604608,' ',1,'accountbank.id','bizdate','c',' ','ifm_transdetail');
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1686136832393223168,'debitamount',' ',' ',1686136832401604609,' ',2,'accountbank.id','bizdate','d',' ','ifm_transdetail');


DELETE FROM t_fcs_billdimbalance_ae WHERE FID = 1688425606389396480;
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1688425606389396480,'appendamount','billstatus = ''C''',' ',1688425606389396481,' ',1,'suretybill.id','appendintdate','c','{"filterRow":[{"id":"3=D1TTVXKQ0D","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3=D1TTVXKQPN","value":"C"}],"baseDataIds":[]}],"forList":false}','fbd_surety_append');
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1688425606389396480,'amount','billstatus = ''C''',' ',1688425606389396482,' ',2,'suretybill.id','releasedate','d','{"filterRow":[{"id":"3=D1Y03X2POQ","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3=D1Y03X2QC+","value":"C"}],"baseDataIds":[]}],"forList":false}','fbd_suretyreleasebill');
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1688425606389396480,'amount','billstatus = ''C''',' ',1706496507987066880,' ',3,'id','intdate','c','{"filterRow":[{"id":"3BLNIL48MVL3","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BLNIL48KRFU","value":"C"}],"baseDataIds":[]}],"forList":false}','fbd_suretybill');

DELETE FROM t_fcs_billdimbalance_ae WHERE FID = 1690603315936734208;
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1690603315936734208,'arrivalamount','billstatus = ''C'' AND arrivalstatus IN (''arrival_confirm'',''arrival_pay'')', ' ', 1690603315936734209, ' ', 1, 'lettercredit.id', 'arrivaldate', 'd', '{"filterRow":[{"id":"3BM2B9AK5B9/","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BM2B9AK5BY9","value":"C"}],"baseDataIds":[]},{"id":"3BM2B9AK5B90","leftBracket":"","compareType":"17","fieldName":"arrivalstatus","rightBracket":"","logic":"0","value":[{"id":"3BM2B9AK5BY=","value":"arrival_confirm"},{"id":"3BM2B9AK5B91","value":"arrival_pay"}],"baseDataIds":[]}],"forList":false}', 'lc_arrival');
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES (1690603315936734208,'amount','billstatus = ''C''',' ',1706496942433075200,' ',2,'id','applydate','c','{"filterRow":[{"id":"3BLNLQMDQ0FB","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BLNLQMDNYA1","value":"C"}],"baseDataIds":[]}],"forList":false}','lc_lettercredit');

DELETE FROM t_fcs_billdimbalance_ae WHERE FID = 1708012716871946240;
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES(1708012716871946240,'drawamount','billstatus = ''C'' AND confirmstatus = ''yetconfirm'' AND loantype = ''bond''',' ',1708012716872047616,' ',1,'id','bizdate','c','{"filterRow":[{"id":"3BSXTRBIV=8A","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BSXTRBITKKY","value":"C"}],"baseDataIds":[]},{"id":"3BSXTRBIV=8B","leftBracket":"","compareType":"105","fieldName":"confirmstatus","rightBracket":"","logic":"0","value":[{"id":"3BSXTRBITKKZ","value":"yetconfirm"}],"baseDataIds":[]},{"id":"3BSXTRBIV=8C","leftBracket":"","compareType":"105","fieldName":"loantype","rightBracket":"","logic":"0","value":[{"id":"3BSXTRBITKL+","value":"bond"}],"baseDataIds":[]}],"forList":false}','cfm_loanbill_bond');
INSERT INTO t_fcs_billdimbalance_ae(FID,FAMOUNTPROP,FFILTERSET,FFILTER,FENTRYID,FDESTBILLPROP,FSEQ,FSRCBILLPROP,FBIZDATEPROP,FLOANSIGN,FFILTER_TAG,FBILLENTITY) VALUES(1708012716871946240,'loans.e_repayamount','billstatus = ''C'' AND confirmstatus = ''yetconfirm'' AND loantype = ''bond''',' ',1708012716872047617,' ',2,'loans.e_loanbill.id','bizdate','d','{"filterRow":[{"id":"3BSY4Q8E9M6I","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3BSY4Q8EAAUX","value":"C"}],"baseDataIds":[]},{"id":"3BSY4Q8E9M6J","leftBracket":"","compareType":"105","fieldName":"confirmstatus","rightBracket":"","logic":"0","value":[{"id":"3BSY4Q8EAAUY","value":"yetconfirm"}],"baseDataIds":[]},{"id":"3BSY4Q8E9M6K","leftBracket":"","compareType":"105","fieldName":"loantype","rightBracket":"","logic":"0","value":[{"id":"3BSY4Q8EAAUZ","value":"bond"}],"baseDataIds":[]}],"forList":false}','cfm_repaymentbill');



/* t_fcs_billdimbalance_be */
DELETE FROM t_fcs_billdimbalance_be WHERE FID = 1690603315936734208;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1690603315936734208,1690603315936734210,'id',1,'accountbank');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1690603315936734208,1690603315936734211,'org',2,'company');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1690603315936734208,1690603315936734212,'currency',3,'currency');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1690603315936734208,1690603315936734213,'bizdate',4,'bizdate');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1690603315936734208,1690603315936734214,'amount',5,'amount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1690603315936734208,1690603315936734215,'debitamount',6,'debitamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1690603315936734208,1690603315936734216,'creditamount',7,'creditamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1690603315936734208,1690603315936734217,'lstbalance',8,'lstbalance');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1690603315936734208,1690603315936734218,'valibalance',9,'valibalance');


DELETE FROM t_fcs_billdimbalance_be WHERE FID = 1686136441073048576;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES(1686136441073048576,1686136441073048578,'id',1,'accountbank');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES(1686136441073048576,1686136441073048579,'org',2,'company');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES(1686136441073048576,1686136441073048580,'currency',3,'currency');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES(1686136441073048576,1686136441073048581,'bizdate',4,'bizdate');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES(1686136441073048576,1686136441073048582,'amount',5,'amount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES(1686136441073048576,1686136441073048583,'debitamount',6,'debitamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES(1686136441073048576,1686136441073048584,'creditamount',7,'creditamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES(1686136441073048576,1686136441073048585,'lstbalance',8,'lstbalance');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES(1686136441073048576,1686136441073048586,'valibalance',9,'valibalance');

DELETE FROM t_fcs_billdimbalance_be WHERE FID = 1708012716871946240;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1708012716871946240,1708015137102896128,'id',1,'accountbank');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1708012716871946240,1708015137102896129,'org',2,'company');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1708012716871946240,1708015137102896130,'currency',3,'currency');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1708012716871946240,1708015137102896131,'bizdate',4,'bizdate');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1708012716871946240,1708015137102896132,'amount',5,'amount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1708012716871946240,1708015137102896133,'debitamount',6,'debitamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1708012716871946240,1708015137102896134,'creditamount',7,'creditamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1708012716871946240,1708015137102896135,'lstbalance',8,'lstbalance');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1708012716871946240,1708015137102896136,'valibalance',9,'valibalance');



DELETE FROM t_fcs_billdimbalance_be WHERE FID = 1686136555971805184;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136555971805184,1686136555971805186,'id',1,'accountbank');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136555971805184,1686136555971805187,'org',2,'company');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136555971805184,1686136555971805188,'currency',3,'currency');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136555971805184,1686136555971805189,'bizdate',4,'bizdate');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136555971805184,1686136555971805190,'amount',5,'amount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136555971805184,1686136555971805191,'debitamount',6,'debitamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136555971805184,1686136555971805192,'creditamount',7,'creditamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136555971805184,1686136555971805193,'lstbalance',8,'lstbalance');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136555971805184,1686136555971805194,'valibalance',9,'valibalance');


DELETE FROM t_fcs_billdimbalance_be WHERE FID = 1686136709198126080;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136709198126080,1686136709198126082,'id',1,'accountbank');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136709198126080,1686136709198126083,'org',2,'company');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136709198126080,1686136709198126084,'currency',3,'currency');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136709198126080,1686136709198126085,'bizdate',4,'bizdate');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136709198126080,1686136709198126086,'amount',5,'amount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136709198126080,1686136709198126087,'debitamount',6,'debitamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136709198126080,1686136709198126088,'creditamount',7,'creditamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136709198126080,1686136709198126089,'lstbalance',8,'lstbalance');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136709198126080,1686136709198126090,'valibalance',9,'valibalance');

DELETE FROM t_fcs_billdimbalance_be WHERE FID = 1686136832393223168;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136832393223168,1686136832401611777,'id',1,'accountbank');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136832393223168,1686136832401611778,'org',2,'company');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136832393223168,1686136832401611779,'currency',3,'currency');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136832393223168,1686136832401611780,'bizdate',4,'bizdate');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136832393223168,1686136832401611781,'amount',5,'amount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136832393223168,1686136832401611782,'debitamount',6,'debitamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136832393223168,1686136832401611783,'creditamount',7,'creditamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136832393223168,1686136832401611784,'lstbalance',8,'lstbalance');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136832393223168,1686136832401611785,'valibalance',9,'valibalance');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1686136832393223168,1686136832401611786,'freezebalance',10,'freezebalance');

DELETE FROM t_fcs_billdimbalance_be WHERE FID = 1688425606389396480;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1688425606389396480,1688425606389396484,'org',2,'company');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1688425606389396480,1688425606389396485,'currency',3,'currency');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1688425606389396480,1688425606389396486,'bizdate',4,'bizdate');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1688425606389396480,1688425606389396487,'amount',5,'amount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1688425606389396480,1688425606389396488,'debitamount',6,'debitamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1688425606389396480,1688425606389396489,'creditamount',7,'creditamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1688425606389396480,1688425606389396490,'lstbalance',8,'lstbalance');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1688425606389396480,1688425606389396491,'valibalance',9,'valibalance');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1688425606389396480,1688425606389396483,'id',1,'accountbank');


DELETE FROM t_fcs_billdimbalance_be WHERE FID = 1692857804408374272;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692857804408374272,1692858486293152768,'id',1,'accountbank');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692857804408374272,1692858486293152769,'org',2,'company');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692857804408374272,1692858486293152770,'currency',3,'currency');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692857804408374272,1692858486293152771,'bizdate',4,'bizdate');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692857804408374272,1692858486293152772,'amount',5,'amount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692857804408374272,1692858486293152773,'debitamount',6,'debitamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692857804408374272,1692858486293152774,'creditamount',7,'creditamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692857804408374272,1692858486293152775,'lstbalance',8,'lstbalance');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692857804408374272,1692858486293152776,'valibalance',9,'valibalance');

DELETE FROM t_fcs_billdimbalance_be WHERE FID = 1692868648345146368;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868648345146368,1695541614715587584,'id',1,'accountbank');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868648345146368,1695541614715587585,'org',2,'company');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868648345146368,1695541614715587586,'currency',3,'currency');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868648345146368,1695541614715587587,'bizdate',4,'bizdate');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868648345146368,1695541614715587588,'amount',5,'amount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868648345146368,1695541614715587589,'debitamount',6,'debitamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868648345146368,1695541614715587590,'creditamount',7,'creditamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868648345146368,1695541614715587591,'lstbalance',8,'lstbalance');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868648345146368,1695541614715587592,'valibalance',9,'valibalance');

DELETE FROM t_fcs_billdimbalance_be WHERE FID = 1692868010072979456;
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868010072979456,1695542449499401216,'id',1,'accountbank');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868010072979456,1695542449499401217,'org',2,'company');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868010072979456,1695542449499401218,'currency',3,'currency');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868010072979456,1695542449499401219,'bizdate',4,'bizdate');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868010072979456,1695542449499401220,'amount',5,'amount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868010072979456,1695542449499401221,'debitamount',6,'debitamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868010072979456,1695542449499401222,'creditamount',7,'creditamount');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868010072979456,1695542449499401223,'lstbalance',8,'lstbalance');
INSERT INTO t_fcs_billdimbalance_be(FID,FENTRYID,FBALPROP,FSEQ,FBALSELPROP) VALUES (1692868010072979456,1695542449499401224,'valibalance',9,'valibalance');




/* t_fcs_billdimbalance_fe */
DELETE FROM t_fcs_billdimbalance_fe WHERE fid = 1686136832393223168;
INSERT INTO t_fcs_billdimbalance_fe
(fid, fentryid, fseq, fbillentity, fsrcbillprop, fdestbillprop, fbizdateprop, famountprop, ffilter, ffilter_tag, ffilterset, ffreezetypeprop)
VALUES(1686136832393223168, 1686136832401611776, 1, 'ifm_accountfrozen', 'account.id', 'inneracct.id', 'applydate', 'frozenamount', ' ', '{"filterRow":[{"id":"37JKGQ2T0F7Z","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"37JKGQ2T+BRY","value":"C"}],"baseDataIds":[]}],"forList":false}', 'billstatus = ''C''', 'frozentype');


/* t_fcs_billdimbalance_l */
DELETE FROM t_fcs_billdimbalance_l WHERE FID = 1686136555971805184;
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1686136555971805184,'3=33C876UJDG','zh_TW','存款餘額配置');
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1686136555971805184,'3=33C876UJDH','zh_CN','存款余额配置');

DELETE FROM t_fcs_billdimbalance_l WHERE FID = 1686136709198126080;
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1686136709198126080,'3=33DBRGXDCV','zh_TW','理財申購餘額配置');
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1686136709198126080,'3=33DBRGXDCW','zh_CN','理财申购余额配置');

DELETE FROM t_fcs_billdimbalance_l WHERE FID = 1686136832393223168;
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1686136832393223168,'3=33E8S/ECMO','zh_TW','內部賬戶餘額配置');
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1686136832393223168,'3=33E8S/ECMP','zh_CN','内部账户余额配置');

DELETE FROM t_fcs_billdimbalance_l WHERE FID = 1688425606389396480;
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1688425606389396480,'3=D21HST2MQ=','zh_CN','保证金额余额设置');
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1688425606389396480,'3=D21HST2MQA','zh_TW','保證金額餘額設置');

DELETE FROM t_fcs_billdimbalance_l WHERE FID = 1690603315936734208;
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1690603315936734208,'3=NHZF4R=3JE','zh_CN','开证余额配置');
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1690603315936734208,'3=NHZF4R=3JF','zh_TW','開證餘額配置');

DELETE FROM t_fcs_billdimbalance_l WHERE FID = 1692857804408374272;
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1692857804408374272,'3=YA6VH+BQ=7','zh_CN','收证余额配置');
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1692857804408374272,'3=YA6VH+BQ=8','zh_TW','收證餘額配置');

DELETE FROM t_fcs_billdimbalance_l WHERE FID = 1692868010072979456;
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1692868010072979456,'3=YC37VGDPOM','zh_CN','供应链债权余额设置');
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1692868010072979456,'3=YC37VGDPON','zh_TW','供應鏈債權餘額設置');

DELETE FROM t_fcs_billdimbalance_l WHERE FID = 1692868648345146368;
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1692868648345146368,'3=YC7W8RY4VV','zh_CN','供应链债务余额设置');
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1692868648345146368,'3=YC7W8RY4VW','zh_TW','供應鏈債務餘額設置');

DELETE FROM t_fcs_billdimbalance_l WHERE FID = 1686136441073048576;
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1686136441073048576,'3=33BDJQ2H4L','zh_CN','贷款余额配置');
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1686136441073048576,'3=33BDJQ2H4K','zh_TW','貸款餘額配置');

DELETE FROM t_fcs_billdimbalance_l WHERE FID = 1708012716871946240;
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1708012716871946240,'3BSXUFEFMZC1','zh_CN','发债余额配置');
INSERT INTO t_fcs_billdimbalance_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1708012716871946240,'3BSXUFEFMZC2','zh_TW','發債餘額配置');
