/* t_fcs_billdimbalance */
DELETE FROM t_fcs_billdimbalance WHERE FID = 1701431918815381504;
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(1701431918815381504, 'cdm_receivablebillbal', 0, 'bizdate', 'cdm_receivablebill', 'id', ' ', '应收票据', 'A', 'currency', NULL, 'BDB-00001001', {ts'2023-07-01  00:00:00'}, NULL, 0, 'draftbillexpiredate', '1', 'm', '{"filterRow":[{"id":"3EUATLH4V=D2","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3EUATLHIBZUD","value":"C"}],"baseDataIds":[]},{"id":"3EUATLHIBZ54","leftBracket":"","compareType":"105","fieldName":"draftbilltranstatus","rightBracket":"","logic":"0","value":[{"id":"3EUATLHIBZUE","value":"success"}],"baseDataIds":[]}],"forList":false}', NULL, 'company', ' ', 0);

DELETE FROM t_fcs_billdimbalance WHERE FID = 1701432699467631616;
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(1701432699467631616, 'cdm_payablebillbal', 0, 'bizdate', 'cdm_payablebill', 'id', ' ', '应付票据', 'A', 'currency', NULL, 'BDB-00001002', {ts'2023-07-01  00:00:00'}, NULL, 0, 'draftbillexpiredate', '1', 'm', '{"filterRow":[{"id":"3EPX443CAO9S","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3EPX443CANLI","value":"C"}],"baseDataIds":[]},{"id":"3EPX443CAO9T","leftBracket":"","compareType":"105","fieldName":"draftbilltranstatus","rightBracket":"","logic":"0","value":[{"id":"3EPX443CANLJ","value":"success"}],"baseDataIds":[]}],"forList":false}', NULL, 'company', ' ', 0);


/* t_fcs_billdimbalance_ae */
DELETE FROM t_fcs_billdimbalance_ae WHERE FID = 1701431918815381504;
INSERT INTO t_fcs_billdimbalance_ae (FID, FAMOUNTPROP, FFILTERSET, FFILTER, FENTRYID, FDESTBILLPROP, FSEQ, FSRCBILLPROP, FBIZDATEPROP, FLOANSIGN, FFILTER_TAG, FBILLENTITY) VALUES(1701431918815381504, 'entrys.billamt', 'tradetype IN (''trusteeship'',''discount'',''pledge'',''collect'',''endorse'') AND billstatus = ''C'' AND draftbilltranstatus IN (''success'',''porsuccess'') AND isrepaygen = ''0''', ' ', 1705866148857271296, ' ', 2, 'entrys.draftbill.id', 'bizdate', 'd', '{"filterRow":[{"id":"3CRGD2YGX1BB","leftBracket":"","compareType":"17","fieldName":"tradetype","rightBracket":"","logic":"0","value":[{"id":"3CRGD2YGX2/L","value":"endorse"},{"id":"3CRGD2YGX1BC","value":"discount"},{"id":"3CRGD2YGX2/M","value":"collect"},{"id":"3CRGD2YGX1BD","value":"trusteeship"},{"id":"3CRGD2YGX2/N","value":"pledge"}],"baseDataIds":[]},{"id":"3CRGD2YGX1BE","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3CRGD2YGX2/O","value":"C"}],"baseDataIds":[]},{"id":"3CRGD2YGX1BF","leftBracket":"","compareType":"17","fieldName":"draftbilltranstatus","rightBracket":"","logic":"0","value":[{"id":"3CRGD2YGX2/P","value":"success"},{"id":"3CRGD2YGX1BG","value":"porsuccess"}],"baseDataIds":[]},{"id":"3CRGD2YGX2/Q","leftBracket":"","compareType":"105","fieldName":"isrepaygen","rightBracket":"","logic":"0","value":[{"id":"3CRGD2YGX1BH","value":"0"}],"baseDataIds":[]}],"forList":false}', 'cdm_drafttradebill');
INSERT INTO t_fcs_billdimbalance_ae (FID, FAMOUNTPROP, FFILTERSET, FFILTER, FENTRYID, FDESTBILLPROP, FSEQ, FSRCBILLPROP, FBIZDATEPROP, FLOANSIGN, FFILTER_TAG, FBILLENTITY) VALUES(1701431918815381504, 'amount', 'billstatus = ''C'' AND draftbilltranstatus = ''success''', ' ', 1729097173464810496, ' ', 1, 'id', 'bizdate', 'c', '{"filterRow":[{"id":"3ECYBH93SVZ/","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3ECYBH93SV9R","value":"C"}],"baseDataIds":[]},{"id":"3ECYBH93SVZ0","leftBracket":"","compareType":"105","fieldName":"draftbilltranstatus","rightBracket":"","logic":"0","value":[{"id":"3ECYBH93SV9S","value":"success"}],"baseDataIds":[]}],"forList":false}', 'cdm_receivablebill');
INSERT INTO t_fcs_billdimbalance_ae (FID, FAMOUNTPROP, FFILTERSET, FFILTER, FENTRYID, FDESTBILLPROP, FSEQ, FSRCBILLPROP, FBIZDATEPROP, FLOANSIGN, FFILTER_TAG, FBILLENTITY) VALUES(1701431918815381504, 'entrys.billamt', 'tradetype IN (''rlspledge'',''retrieve'',''refund'') AND billstatus = ''C'' AND draftbilltranstatus IN (''success'',''porsuccess'') AND isrepaygen = ''0''', ' ', 1715844881575856128, ' ', 3, 'entrys.draftbill.id', 'bizdate', 'c', '{"filterRow":[{"id":"3CRGCP9QHMXM","leftBracket":"","compareType":"17","fieldName":"tradetype","rightBracket":"","logic":"0","value":[{"id":"3CRGCP9QHNKW","value":"rlspledge"},{"id":"3CRGCP9QHMXN","value":"retrieve"},{"id":"3CRGCP9QHNKX","value":"refund"}],"baseDataIds":[]},{"id":"3CRGCP9QHMXO","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3CRGCP9QHNKY","value":"C"}],"baseDataIds":[]},{"id":"3CRGCP9QHMXP","leftBracket":"","compareType":"17","fieldName":"draftbilltranstatus","rightBracket":"","logic":"0","value":[{"id":"3CRGCP9QHNKZ","value":"porsuccess"},{"id":"3CRGCP9QHMXQ","value":"success"}],"baseDataIds":[]},{"id":"3CRGCP9QHNL+","leftBracket":"","compareType":"105","fieldName":"isrepaygen","rightBracket":"","logic":"0","value":[{"id":"3CRGCP9QHMXR","value":"0"}],"baseDataIds":[]}],"forList":false}', 'cdm_drafttradebill');

DELETE FROM t_fcs_billdimbalance_ae WHERE FID = 1701432699467631616;
INSERT INTO t_fcs_billdimbalance_ae (FID, FAMOUNTPROP, FFILTERSET, FFILTER, FENTRYID, FDESTBILLPROP, FSEQ, FSRCBILLPROP, FBIZDATEPROP, FLOANSIGN, FFILTER_TAG, FBILLENTITY) VALUES(1701432699467631616, 'amount', 'billstatus = ''C'' AND draftbilltranstatus = ''success''', ' ', 1729096440082367488, ' ', 2, 'id', 'issuedate', 'c', '{"filterRow":[{"id":"3ECY7QYASYXL","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3ECY7QYASZKV","value":"C"}],"baseDataIds":[]},{"id":"3ECY7QYASYXM","leftBracket":"","compareType":"105","fieldName":"draftbilltranstatus","rightBracket":"","logic":"0","value":[{"id":"3ECY7QYASZKW","value":"success"}],"baseDataIds":[]}],"forList":false}', 'cdm_payablebill');
INSERT INTO t_fcs_billdimbalance_ae (FID, FAMOUNTPROP, FFILTERSET, FFILTER, FENTRYID, FDESTBILLPROP, FSEQ, FSRCBILLPROP, FBIZDATEPROP, FLOANSIGN, FFILTER_TAG, FBILLENTITY) VALUES(1701432699467631616, 'entrys.billamt', 'tradetype IN (''payoff'') AND billstatus = ''C'' AND draftbilltranstatus IN (''success'',''porsuccess'') AND isrepay = ''0''', ' ', 1715847125662714880, ' ', 1, 'entrys.draftbill.id', 'bizdate', 'd', '{"filterRow":[{"id":"3CRGF20Z3DJJ","leftBracket":"","compareType":"17","fieldName":"tradetype","rightBracket":"","logic":"0","value":[{"id":"3CRGF20Z3E7T","value":"payoff"}],"baseDataIds":[]},{"id":"3CRGF20Z3DJK","leftBracket":"","compareType":"105","fieldName":"billstatus","rightBracket":"","logic":"0","value":[{"id":"3CRGF20Z3E7U","value":"C"}],"baseDataIds":[]},{"id":"3CRGF20Z3DJL","leftBracket":"","compareType":"17","fieldName":"draftbilltranstatus","rightBracket":"","logic":"0","value":[{"id":"3CRGF20Z3E7V","value":"porsuccess"},{"id":"3CRGF20Z3DJM","value":"success"}],"baseDataIds":[]},{"id":"3CRGF20Z3E7W","leftBracket":"","compareType":"105","fieldName":"isrepay","rightBracket":"","logic":"0","value":[{"id":"3CRGF20Z3DJN","value":"0"}],"baseDataIds":[]}],"forList":false}', 'cdm_drafttradebill');



/* t_fcs_billdimbalance_be */
DELETE FROM t_fcs_billdimbalance_be WHERE FID = 1701431918815381504;
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701431918815381504, 1702081377597520896, 'id', 1, 'accountbank');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701431918815381504, 1702081377597520897, 'org', 2, 'company');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701431918815381504, 1702081377597520898, 'currency', 3, 'currency');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701431918815381504, 1702081377597520899, 'bizdate', 4, 'bizdate');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701431918815381504, 1702081377597520900, 'amount', 5, 'amount');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701431918815381504, 1702081377597520901, 'debitamount', 6, 'debitamount');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701431918815381504, 1702081377597520902, 'creditamount', 7, 'creditamount');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701431918815381504, 1702081377597520903, 'lstbalance', 8, 'lstbalance');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701431918815381504, 1702081377597520904, 'valibalance', 9, 'valibalance');

DELETE FROM t_fcs_billdimbalance_be WHERE FID = 1701432699467631616;
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701432699467631616, 1702080612883503104, 'id', 1, 'accountbank');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701432699467631616, 1702080612883503105, 'org', 2, 'company');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701432699467631616, 1702080612883503106, 'currency', 3, 'currency');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701432699467631616, 1702080612883503107, 'bizdate', 4, 'bizdate');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701432699467631616, 1702080612883503108, 'amount', 5, 'amount');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701432699467631616, 1702080612883503109, 'debitamount', 6, 'debitamount');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701432699467631616, 1702080612883503110, 'creditamount', 7, 'creditamount');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701432699467631616, 1702080612883503111, 'lstbalance', 8, 'lstbalance');
INSERT INTO t_fcs_billdimbalance_be (FID, FENTRYID, FBALPROP, FSEQ, FBALSELPROP) VALUES(1701432699467631616, 1702080612883503112, 'valibalance', 9, 'valibalance');



/* t_fcs_billdimbalance_l */
DELETE FROM t_fcs_billdimbalance_l WHERE FID = 1701431918815381504;
INSERT INTO t_fcs_billdimbalance_l (FID, FPKID, FLOCALEID, FNAME) VALUES(1701431918815381504, '3B+D8=1LDJB6', 'zh_CN', '应收票据');
INSERT INTO t_fcs_billdimbalance_l (FID, FPKID, FLOCALEID, FNAME) VALUES(1701431918815381504, '3B+D8=1LDJB7', 'zh_TW', '應收票據');

DELETE FROM t_fcs_billdimbalance_l WHERE FID = 1701432699467631616;
INSERT INTO t_fcs_billdimbalance_l (FID, FPKID, FLOCALEID, FNAME) VALUES(1701432699467631616, '3B+DCZXZF1LI', 'zh_CN', '应付票据');
INSERT INTO t_fcs_billdimbalance_l (FID, FPKID, FLOCALEID, FNAME) VALUES(1701432699467631616, '3B+DCZXZF1LJ', 'zh_TW', '應付票據');

