NC查询文件服务器及路径

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