project QadFinancials > class BClosingPostingsReport > business logic query GLBalanceCurrent

Parameters


iiCompanyIdintegerCompany id
icGLTypecharacter

query condition


  each GL where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GLTypeCode = icGLType

      each PostingHist (inner-join) where
PostingHist.Company_Id = iiCompanyId AND
PostingHist.GL_ID = GL.GL_ID AND
PostingHist.PostingHistYearPeriodTill = 999999

query resultset tqGLBalanceCurrent


field namedata typedb fielddescription
tcGLCodecharacterGL.GLCodeA code identifying the GL account.
tdPostingHistBalanceCreditCCdecimalPostingHist.PostingHistBalanceCreditCCSC Credit Balance
tdPostingHistBalanceCreditLCdecimalPostingHist.PostingHistBalanceCreditLCBC Balance Credit
tdPostingHistBalanceDebitCCdecimalPostingHist.PostingHistBalanceDebitCCSC Debit Balance
tdPostingHistBalanceDebitLCdecimalPostingHist.PostingHistBalanceDebitLCBC Balance Debit

Internal usage


QadFinancials
method BClosingPostingsReport.CreditorControlGLBalance
method BClosingPostingsReport.DebtorControlGLBalance