应收票据二开字段结算操作携带到应收票据结算单/付款单/收款单,配置即可

应收票据单据增加一个单选辅助基础资料 F_PUB_ASSISTANT_QTR

创建应收票据基础资料视图 ,打开数据库,找到对应账套,在视图里找到应收票据基础资料视图V_CN_BILLRECEIVABLE,如下图(不同版本的创建视图sql可能不一样,案列sql版本是PT-151005 [8.2.0.20231109])


如上图,把复制出来的sql 后面加上二开字段,按照以上 先删除应收票据基础资料视图
--先删除视图 DROP VIEW V_CN_BILLRECEIVABLE;
再执行创建应收票据基础资料视图V_CN_BILLRECEIVABLE
--再重新创建视图,这里加上二开字段 create view V_CN_BILLRECEIVABLE as SELECT L.FID AS 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 AS fnumber, L.FCUSTOMERID, L.FDATE, L.FTRADEAMOUNTFOR, L.FSALEORGID, L.FDEPARTMENTID, L.FSALEGROUPID, L.FSALEERID, L.FSETTLESTATUS, L.FDOCUMENTSTATUS, L.FPARLEFTAMOUNTFOR, 'A' AS fforbidstatus, L.FCONTACTUNITTYPE, L.FCONTACTUNIT, '' AS fnouse, L.FISREC, L.FSOURREC, L.FISTRUST, L.FISPLEDGE, L.FISINIT, O.FESTIMATEDRATE, O.FESTIMATEDCHARGE, O.FESTIMATEDREALRECAMOUNT,
应收票据二开字段结算操作携带到应收票据结算单/付款单/收款单,配置即可
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。



