project QadFinancials > class BClosingPostingsReport > business logic query GLMovementsInPeriod

Parameters


iiCompanyIdintegerCompany id
icGLTypecharacter
iiYearPeriodinteger

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.PostingHistYearPeriodFrom = iiYearPeriod

query resultset tqGLMovementsInPeriod


field namedata typedb fielddescription
tcGLCodecharacterGL.GLCodeA code identifying the GL account.
tdPostingHistMovemntCreditCCdecimalPostingHist.PostingHistMovemntCreditCCSC Credit Activity
tdPostingHistMovemntCreditLCdecimalPostingHist.PostingHistMovemntCreditLCBC Movement Credit
tdPostingHistMovemntDebitCCdecimalPostingHist.PostingHistMovemntDebitCCSC Debit Activity
tdPostingHistMovemntDebitLCdecimalPostingHist.PostingHistMovemntDebitLCBC Movement Debit

Internal usage


QadFinancials
method BClosingPostingsReport.CreditorControlGLBalance
method BClosingPostingsReport.DebtorControlGLBalance