HHJS 记录

最新推荐文章于 2024-04-26 16:06:24 发布

艳阳天_.

最新推荐文章于 2024-04-26 16:06:24 发布

阅读量359

点赞数 6

文章标签：前端

本文链接：https://blog.csdn.net/MZ199290/article/details/136042733

版权

--- 余额表查  （包含未过账）
---- 直接查余额表 SELECT FCURRENTPERIODID   FROM T_BD_SYSTEMSTATUSCTROL    WHERE FISSTART = 1   and FCOMPANYID = '5OQAAAAAAbbM567U' and FSYSTEMSTATUSID ='e45c1988-00fd-1000-e000-33d8c0a8100d02A5514C'  系统当前会计期间的余额
 SELECT -1 * FENDBALANCELOCAL kemuyue  FROM T_GL_ASSISTBALANCE A, T_BD_ASSISTANTHG B  WHERE A.FASSISTGRPID = B.FID    and b.FPROJECTID = 'JFxuLY3UrkGs4qnpz/M+kdreBe4='and b.FPROVIDERID = '5OQAAAAAQrA3xn38'     and b.FASSTACCOUNTID = '5OQAAAAANNVGWhD4'     AND A.FPERIODID =   (SELECT FCURRENTPERIODID   FROM T_BD_SYSTEMSTATUSCTROL    WHERE FISSTART = 1   and FCOMPANYID = '5OQAAAAAAbbM567U' and FSYSTEMSTATUSID ='e45c1988-00fd-1000-e000-33d8c0a8100d02A5514C')   and a.FACCOUNTID = (   select  fid  from T_BD_AccountView  where FNumber='2241.02'  and  FCompanyID='5OQAAAAAAbbM567U' )     and a.FCURRENCYID = 'dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC'    and a.FBALTYPE = 1 



--- 凭证关联辅助账查 （包含未过账）    isnull(SUM(case  b.FEntryDC  when  1 then  -1*b.FOriginalAmount  when 0  then  b.FOriginalAmount  end ),0) as  amt 这里 是将借贷方发生额 判断借贷方合计  实现余额累计的 
select  isnull(SUM(case  b.FEntryDC  when  1 then  -1*b.FOriginalAmount  when 0  then  b.FOriginalAmount  end ),0) as  amt  from   t_gl_voucher  a  join  T_GL_VOUCHERENTRY  b  on   a.FID=b.FBILLID  and   b.FACCOUNTID=  (   select  fid  from T_BD_AccountView  where FNumber='2241.02'  and  FCompanyID='5OQAAAAAAbbM567U' )    and   b.FCurrencyID='dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC'   join   T_GL_VOUCHERASSISTRECORD  c  on   a.FID=c.FBILLID   and  b.FID=c.FENTRYID  and  c.FASSGRPID  in  (select   FID  from   T_BD_AssistantHG  where  FAsstAccountID='5OQAAAAANNVGWhD4'   AND  FProviderID='5OQAAAAAQrA3xn38'  AND  FProjectID='JFxuLY3UrkGs4qnpz/M+kdreBe4=' ) 


 
--- 该科目辅助账 该公司累计借方发生额 （包含未过账）--从凭证上查询 
 select  isnull(SUM   (case  b.FEntryDC  when  1 then  -1*b.FOriginalAmount     end   )  ,0) as  amt  from   t_gl_voucher  a  join  T_GL_VOUCHERENTRY  b  on   a.FID=b.FBILLID  and   b.FACCOUNTID=  (   select  fid  from T_BD_AccountView  where FNumber='2241.02'  and  FCompanyID='5OQAAAAAAbbM567U' )    and   b.FCurrencyID='dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC'   join   T_GL_VOUCHERASSISTRECORD  c  on   a.FID=c.FBILLID   and  b.FID=c.FENTRYID  and  c.FASSGRPID  in  (select   FID  from   T_BD_AssistantHG  where  FAsstAccountID='5OQAAAAANNVGWhD4'   AND  FProviderID='5OQAAAAAQrA3xn38'  AND  FProjectID='JFxuLY3UrkGs4qnpz/M+kdreBe4=' ) 


 

 --- 该科目辅助账 该公司累计贷方发生额 （包含未过账）--从凭证上查询  
 select  isnull(SUM   (case  b.FEntryDC  when  0 then  1*b.FOriginalAmount     end   )  ,0) as  amt  from   t_gl_voucher  a  join  T_GL_VOUCHERENTRY  b  on   a.FID=b.FBILLID  and   b.FACCOUNTID=  (   select  fid  from T_BD_AccountView  where FNumber='2241.02'  and  FCompanyID='5OQAAAAAAbbM567U' )    and   b.FCurrencyID='dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC'   join   T_GL_VOUCHERASSISTRECORD  c  on   a.FID=c.FBILLID   and  b.FID=c.FENTRYID  and  c.FASSGRPID  in  (select   FID  from   T_BD_AssistantHG  where  FAsstAccountID='5OQAAAAANNVGWhD4'   AND  FProviderID='5OQAAAAAQrA3xn38'  AND  FProjectID='JFxuLY3UrkGs4qnpz/M+kdreBe4=' )