升级到2023年9月补丁后，涉及票据的单据操作报错，字段无效\Invalid column name

--2023年9月补丁增加了等分化拆分的功能；系统预设的基础资料-应收、应付票据的视图增加了几个字段，导致历史在这两个基础资料新增字段后重建过的视图被覆盖了；解决方法：需要再次重建视图加上自定义的字段
--例如：报错‘F_CSCSCS’字段无效 或者 Invalid column name ‘F_CSCSCS’

--查询应收票据的视图语句 （可以确认缺失了该字段）

sp_helptext V_CN_BILLRECEIVABLE;

--删除视图

DROP VIEW V_CN_BILLRECEIVABLE;

--重建视图 加上该字段F_CSCSCS

CREATE VIEW V_CN_BILLRECEIVABLE AS SELECT L.FID fbillid, L.FBILLTYPE, L.FBILLNUMBER, L.FCURRENCYID, L.FISSUEDATE, L.FDUEDATE, L.FPAYMENTPERIOD, L.FPARAMOUNTFOR, L.FPARRATE, L.FDUEAMOUNTFOR, L.FDRAWER, L.FACCEPTOR, L.FACCEPTDEALNO, L.FACCEPTDATE, L.FCOMMENT, L.FREVOCABLE, L.FRECOURSE, L.FSETTLEORGID, L.FPAYORGID, L.FBILLNO fnumber, L.FCUSTOMERID, L.FDATE, L.FTRADEAMOUNTFOR, L.FSALEORGID, L.FDEPARTMENTID, L.FSALEGROUPID, L.FSALEERID, L.FSETTLESTATUS, L.FDocumentStatus, L.FPARLEFTAMOUNTFOR, 'A' fforbidstatus, L.FCONTACTUNITTYPE, L.FCONTACTUNIT, '' fnouse, L.FISREC, L.FSOURREC, L.FISTRUST, L.FISPLEDGE, L.FISINIT, O.FESTIMATEDRATE, O.FESTIMATEDCHARGE, O.FESTIMATEDREALRECAMOUNT, O.FAVGESTIMATEDRATE, O.FNOTESTATUS, L.FRECBANKACNTID, O.FBANKSINGIN, O.FISSUPPORTSPLIT, O.FNOSPLITAMOUNT, O.FSPLITAMOUNT, O.FISELECTRONICBILL, O.FRCBILLNUMBER, O.FSUBBILLSTARTNO, O.FSUBBILLENDNO, O.FEQUIDIFFBILL, O.FSOURRECBILL, O.FPARENTBILL, L.F_CSCSCS FROM T_CN_BILLRECEIVABLE L INNER JOIN T_CN_BILLRECEIVABLE_O O ON L.FID = O.FID;

--查询应付票据的视图语句 （可以确认缺失了该字段）

sp_helptext V_CN_BILLPAYABLE;

--删除视图

DROP VIEW V_CN_BILLPAYABLE;

--重建视图 加上该字段F_CSCSCS

CREATE VIEW V_CN_BILLPAYABLE AS SELECT A.FID AS FBILLID, A.FBILLTYPE, A.FBILLNUMBER, A.FCURRENCYID, A.FDATE, A.FDUEDATE, A.FPAYMENTPERIOD, A.FPARAMOUNTFOR, A.FPARLEFTAMOUNTFOR, A.FPARRATE, A.FDUEAMOUNTFOR, A.FACCEPTOR, A.FCOMMENT, A.FREVOCABLE, A.FRECOURSE, A.FSETTLEORGID,A.FPAYORGID, A.FBILLNO AS FNUMBER, A.FSUPPLIERID, A.FPURCHASEORGID, A.FDEPARTMENTID, A.FPURCHASERGROUPID, A.FPURCHASERID, A.FSETTLESTATUS, A.FDocumentStatus, 'A' AS FFORBIDSTATUS, A.FCONTACTUNITTYPE,A.FCONTACTUNIT,A.FISINIT,A.FNOTESTATUS,A.FPAYBANKID ,A.FUNPAYAMOUTFOR,B.FRCBILLNUMBER, B.FSUBBILLSTARTNO,B.FSUBBILLENDNO,B.FEQUIDIFFBILL, A.F_CSCSCS FROM T_CN_BILLPAYABLE A INNER JOIN T_CN_BILLPAYABLE_O B ON A.FID=B.FID;