project QadFinancials > class BClosingPostingsReport > business logic query PostingHistByYearPeriodAndGL

Parameters


iiCompanyIdintegerCompany id
iiyearperiodinteger
iiGL_IDinteger

query condition


  each PostingHist where
PostingHist.Company_Id = iiCompanyId AND
PostingHist.GL_ID = iiGL_ID AND
PostingHist.PostingHistYearPeriodFrom <= iiyearperiod AND
PostingHist.PostingHistYearPeriodTill >= iiyearperiod

query resultset tqPostingHistByYearPeriodAndGL


field namedata typedb fielddescription
tiCurrency_IDintegerPostingHist.Currency_IDLink to Currency
tiGL_IDintegerPostingHist.GL_IDLink to GL
tdPostingHistBalanceCreditCCdecimalPostingHist.PostingHistBalanceCreditCCSC Credit Balance
tdPostingHistBalanceCreditLCdecimalPostingHist.PostingHistBalanceCreditLCBC Balance Credit
tdPostingHistBalanceCreditPCdecimalPostingHist.PostingHistBalanceCreditPCPC Credit Balance
tdPostingHistBalanceCreditTCdecimalPostingHist.PostingHistBalanceCreditTCTC Credit Balance
tdPostingHistBalanceDebitCCdecimalPostingHist.PostingHistBalanceDebitCCSC Debit Balance
tdPostingHistBalanceDebitLCdecimalPostingHist.PostingHistBalanceDebitLCBC Balance Debit
tdPostingHistBalanceDebitPCdecimalPostingHist.PostingHistBalanceDebitPCPC Debit Balance
tdPostingHistBalanceDebitTCdecimalPostingHist.PostingHistBalanceDebitTCTC Debit Balance
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(PostingHist)

Internal usage


QadFinancials
method BClosingPostingsReport.CIRECBalance