--勾选等分化票据，只允许修改状态为空或者背书退回的，同时未勾选可支持拆分的

--备份表数据

select * into T_CN_BILLRECEIVABLE_O_20240116bak from T_CN_BILLRECEIVABLE_O

--查询应收票据-结算状态-等分化票据关联字段

select FSETTLESTATUS,FID,* from T_CN_BILLRECEIVABLE where fbillno ='BR0555'  --应收票据

select FEQUIDIFFBILL,FStandardAmt,FSUBBILLSTARTNO,FSUBBILLENDNO,* from T_CN_BILLRECEIVABLE_O where FID IN (143738)  --应收票据扩展表

--修改票据为等分化票据，修改开始和结束序号

UPDATE T_CN_BILLRECEIVABLE_O SET FEQUIDIFFBILL = 1,FStandardAmt =0.01 ,FSUBBILLSTARTNO = 1,FSUBBILLENDNO = (FNOSPLITAMOUNT * 100) where FID IN (143738);