project QadFinancials > class BClosingPostingsReport > business logic query PostingHistByYearPeriodGLCurr


Parameters


iiCompanyIdintegerCompany id
iiGL_IDinteger
iiCurrency_IDinteger
iiYearPeriodinteger


query condition


  each PostingHist where
PostingHist.Company_Id = iiCompanyId AND
PostingHist.GL_ID = iiGL_ID AND
PostingHist.Currency_ID = iiCurrency_ID AND
PostingHist.PostingHistYearPeriodFrom <= iiYearPeriod AND
PostingHist.PostingHistYearPeriodTill >= iiYearPeriod


query resultset tqPostingHistByYearPeriodGLCurr


field namedata typedb fielddescription
tdPostingHistBalanceCreditCCdecimalPostingHist.PostingHistBalanceCreditCCSC Credit Balance
tdPostingHistBalanceCreditLCdecimalPostingHist.PostingHistBalanceCreditLCBC Balance Credit
tdPostingHistBalanceCreditTCdecimalPostingHist.PostingHistBalanceCreditTCTC Credit Balance
tdPostingHistBalanceDebitCCdecimalPostingHist.PostingHistBalanceDebitCCSC Debit Balance
tdPostingHistBalanceDebitLCdecimalPostingHist.PostingHistBalanceDebitLCBC Balance Debit
tdPostingHistBalanceDebitTCdecimalPostingHist.PostingHistBalanceDebitTCTC Debit Balance


Internal usage


QadFinancials
method BClosingPostingsReport.GLOpenItemControl