NC65辅助核算相关表的关系
select * from fi_freemap 辅助核算类型表
select * from gl_docfree1 辅助核算内容表1-30
select * from gl_docfree2 辅助核算内容表31-60 内容表与类型表的num相对应
select * from gl_docfree3 辅助核算内容表61-90
凭证明细(分录)跟辅助核算内容、客商关联关系
select a.explanation, a. assid, b.f4, c.name, c.pk_cust_sup
from gl_detail a
left join gl_docfree1 b
on b.assid = a.assid
left join bd_cust_supplier c
on b.f4 = c.pk_cust_sup
where a.explanation like '%%'
or a.explanation like '%%'
and b.f4<>"nn/a"