从科目余额表查 辅助账查 ，前提是科目挂了辅助账，目前的 总额都是一样
---辅助账查
select sum( a.本期发生额 ) from(
select av.fid 科目id , av.FNUMBER 科目编码 , av.FNAME_L2 会计科目名称, unit.fid 辅助账成本id , unit.Fnumber 辅助账成本编码 , unit.FNAME_L2 辅助账成本中心 , parcost.FCOSTCENTERTYPE 成本中心类型 , ae.FDEBITFOR 本期发生额 from T_GL_AssistBalance_1F ae inner join t_bd_accountview av on av.fid = ae.faccountid inner join t_bd_assistanthg hg on hg.fid=ae.FASSISTGRPID inner join T_ORG_BaseUnit unit on unit.fid=hg.FCOSTORGID inner join T_ORG_OUPartCostCenter parcost on parcost.fid= unit.FPARTCOSTCENTERID where ae.fperiod in ('202301') and av.fcompanyid in ( select fid from T_ORG_BaseUnit where FPARENTID='10YAAAAAF8/M567U' ) and av.FNUMBER in ( '6601.01.01','6601.01.01' ) order by av.FNUMBER ) a
-- 科目余额表查
select sum( a.FDEBITFOR) from ( select ab1.FDEBITFOR from T_GL_ACCOUNTBALANCE_1F ab1
inner join T_ORG_COMPANY c on ab1.FORGUNITID =c.fid
inner join T_BD_ACCOUNTVIEW av ON AB1.FACCOUNTID = AV.FID
inner join T_BD_AccountTable at on av.FAccountTableID=at.fid
where c.fid in ( select fid from T_ORG_BaseUnit where FPARENTID='10YAAAAAF8/M567U' ) and ab1.fperiod in ('202301') and av.fnumber in ( '6601.01.01','6601.01.01' ) )a
