原理：科目余额表 left join 科目 left join 辅助账横表    

baltype = 5 表示已过账

assbla.FCURRENCYID= 'dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC' 币别

sqlHeader.append(" SELECT  to_char(accview.FNUMBER) FNUMBER,to_char(accview.FNAME_L2) FNAME_L2, assbla.FDEBITLOCAL  ");

sqlHeader.append(" FROM T_GL_AssistBalance assbla  ");

sqlHeader.append(" LEFT JOIN T_BD_ACCOUNTVIEW accview ON ASSBLA.FACCOUNTID = ACCVIEW.FID  ");

sqlHeader.append(" LEFT JOIN T_BD_ASSISTANTHG asshg ON ASSBLA.FASSISTGRPID = ASSHG.FID  ");

sqlHeader.append(" where assbla.FBALTYPE = 5  ");

sqlHeader.append(" AND assbla.FCURRENCYID= 'dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC'  ");

sqlHeader.append(" AND ( asshg.FADMINORGID = 'nhoAAAAG6d3M567U' )  ");

sqlHeader.append(" AND accview.FACCOUNTTYPEID  = 'nhoAAAAKIz6dqOy7'  ");

sqlHeader.append(" AND ASSBLA.FORGUNITID  = '"+ storageUnit.getId() +"'  ");

sqlHeader.append(" AND (accview.FNUMBER = '5101.RLF' OR accview.FNUMBER = '5101.SYJYF' OR  )  ");

sqlHeader.append(" AND assbla.FPERIODID = '"+ periodinfo.getId() +"'  ");