sm_pub_filesystem
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 |