业务单据,业务凭证,总账凭证的关系
select
FVOUCHERID ,--业务凭证内码
FGLVOUCHERID,--总账凭证内码
*
from T_BAS_VOUCHER a --业务凭证表
left join T_GL_VOUCHER b on a.FGLVOUCHERID = b.FVOUCHERID --总账凭证表
left join t_AR_receivable c on a.FSOURCEBILLNO = c.FBILLNO --应收单表
where a.FSOURCEBILLKEY = 'AR_receivable' --应收单的标识
and a.FSOURCEBILLNO = 'FKD00000001'