EAS8.2 科目余额表 最新会计期间的科目余额SQL

EAS8.2 科目余额表 最新会计期间的科目余额SQL

SELECT DISTINCT
  ab.FBALTYPE as 凭证状态,
	p.fnumber as 会计期间,
	av.fnumber 科目代码,
	av.FNAME_L2 科目名称,
	c.FNAME_L2 as 所属公司,
  t2.fnumber 客户编码,
	t2.fname_l2 客户名称,
	cur.FNAME_L2 AS 币别,
	ab.FENDBALANCELOCAL as 科目余额 
FROM
	t_gl_assistbalance ab                                         ---辅助账余额
	INNER JOIN T_BD_CURRENCY cur ON cur.fid = ab.fcurrencyid      --币别
	INNER JOIN T_BD_PERIOD p ON p.FID = ab.fperiodid              --会计期间