SELECT ORG_FINANCEORG.NAME 财务组织,

       BD_CURRTYPE.NAME 币种,

       D.NUM 账户编码,

       --D.NUMNAME 账户名称,

       --D.SUBCODE 子户编码,

       --D.SUBNAME 子户名称,

       D.ACCTYPE 账户类型,

       D.YHLB 银行类别,

       --D.SFSX 收付属性,

       --D.ZJXT 资金形态,

       A.INIT_PRIMAL - NVL(C.PAY, 0) + NVL(C.REC, 0) 期初原币余额,

       A.INIT_LOCAL - NVL(C.OLCPAY, 0) + NVL(C.OLCREC, 0) 期初本币余额,

       --A.GROUPINIT_LOCAL - NVL(C.GLCPAY, 0) + NVL(C.GLCREC, 0) 期初集团本币,

       --A.GLOBALINIT_LOCAL - NVL(C.GLLCPAY, 0) + NVL(C.GLLCREC, 0) 期初全局本币,

       B.REC 本期收入原币金额,

       B.OLCREC 本期收入本币金额,

       --B.GLCREC 本期收入集团本币金额,

       --B.GLLCREC 本期收入全局本币金额,

       B.PAY 本期支出原币金额,

       B.OLCPAY 本期支出本币金额,

       --B.GLCPAY 本期支出集团本币金额,

       --B.GLLCPAY 本期支出全局本币金额,

       A.INIT_PRIMAL - NVL(C.PAY, 0) + NVL(C.REC, 0) - NVL(B.PAY, 0) +

       NVL(B.REC, 0) 期末原币金额,

       A.INIT_LOCAL - NVL(C.OLCPAY, 0) + NVL(C.OLCREC, 0) -

       NVL(B.OLCPAY, 0) + NVL(B.OLCREC, 0) 期末本币金额 

       --A.CURRENT_PRIMAL 账面原币余额,

       --A.CURRENT_LOCAL 账面本币余额,

       --A.GROUPCURRENT_LOCAL 账面集团本币,

       --A.GLOBALCURRENT_LOCAL 账面全局本币,

       --A.PK_ORG 组织PK,

       --A.PK_CURRTYPE 币种PK,

       --A.PK_ACCOUNT 账户PK,

       --A.ORGACC1 组织及账户,

       --A.PK_INITDATA 期初主键,

       --A.PK_GROUP 集团PK,

       --A.FORMCODE 资金形态枚举值,

       --BD_BANKACCSUB.PK_BANKACCSUB 银行账户子户主键,

       --BD_CASHACCOUNT.PK_CASHACCOUNT 现金账户主键,

       --D.YHLBPK 银行类别主键,

       --SUBSTR(BD_BANKACCBAS.ACCXHDATE, 0, 10) 销户日期

  FROM VIEW_HF_NC_FIN_ZHYEB_QC A

  LEFT JOIN (SELECT PK_ACCOUNT AS PKACCOUNT,

                    PK_ORG AS ORG,

                    SUM(PAYMONEY) AS PAY,

                    SUM(OLCPAYMONEY) AS OLCPAY,

                    SUM(GLCPAYMONEY) AS GLCPAY,

                    SUM(GLLCPAYMONEY) AS GLLCPAY,

                    SUM(RECMONEY) AS REC,

                    SUM(OLCRECMONEY) AS OLCREC,

                    SUM(GLCRECMONEY) AS GLCREC,

                    SUM(GLLCRECMONEY) AS GLLCREC,

                    CONCAT(PK_ORG, PK_ACCOUNT) AS ORGACC2

               FROM CMP_BANKACCDETAIL

              WHERE TALLYDATE = '${日期}'

                AND USEFLAG = 1

              GROUP BY PK_ORG, PK_ACCOUNT) B

    ON A.ORGACC1 = B.ORGACC2

  LEFT JOIN (SELECT PK_ACCOUNT AS PK,

                    PK_ORG AS ORG,

                    SUM(PAYMONEY) AS PAY,

                    SUM(OLCPAYMONEY) AS OLCPAY,

                    SUM(GLCPAYMONEY) AS GLCPAY,

                    SUM(GLLCPAYMONEY) AS GLLCPAY,

                    SUM(RECMONEY) AS REC,

                    SUM(OLCRECMONEY) AS OLCREC,

                    SUM(GLCRECMONEY) AS GLCREC,

                    SUM(GLLCRECMONEY) AS GLLCREC,

                    CONCAT(PK_ORG, PK_ACCOUNT) AS ORGACC3

               FROM CMP_BANKACCDETAIL

              WHERE TALLYDATE < '${日期}'

                AND USEFLAG = 1

              GROUP BY PK_ORG, PK_ACCOUNT) C

    ON A.ORGACC1 = C.ORGACC3

  LEFT JOIN VIEW_HF_NC_FIN_ZHYEB_QT D

    ON A.PK_INITDATA = D.PK_INITDATA

  LEFT JOIN BD_CURRTYPE BD_CURRTYPE

    ON A.PK_CURRTYPE = BD_CURRTYPE.PK_CURRTYPE

   AND NVL(BD_CURRTYPE.DR, 0) = 0

  LEFT JOIN ORG_FINANCEORG ORG_FINANCEORG

    ON A.PK_ORG = ORG_FINANCEORG.PK_FINANCEORG

   AND NVL(ORG_FINANCEORG.DR, 0) = 0

  LEFT JOIN BD_BANKACCSUB BD_BANKACCSUB

    ON A.PK_ACCOUNT = BD_BANKACCSUB.PK_BANKACCSUB

   AND NVL(BD_BANKACCSUB.DR, 0) = 0

  LEFT JOIN BD_CASHACCOUNT BD_CASHACCOUNT

    ON A.PK_ACCOUNT = BD_CASHACCOUNT.PK_CASHACCOUNT

   AND NVL(BD_CASHACCOUNT.DR, 0) = 0

  LEFT JOIN BD_BANKACCBAS BD_BANKACCBAS

    ON BD_BANKACCSUB.PK_BANKACCBAS = BD_BANKACCBAS.PK_BANKACCBAS

   AND NVL(BD_BANKACCBAS.DR, 0) = 0

   AND (SUBSTR(BD_BANKACCBAS.ACCXHDATE, 0, 10) >= '${日期}' OR

       BD_BANKACCBAS.ACCXHDATE IS NULL)

 WHERE NVL(A.DR, 0) = 0