NC65 附件文件在服务器上路径的获取方式

1、查询附件节点信息：
select * from sm_pub_filesystem where filepath = ‘单据主键’ or filepath like ‘单据主键/%’;

2、查询文件信息：
select * from bap_fs_header where path = sm_pub_filesystem.pk_doc;

3、查询文件路径：
select storepath from bap_fs_body where headid = bap_fs_header.guid;

文章出处：https://www.52yonyou.com/nc65/20191214/8021.html