project QadFinancials > class BClosingPostingsReport > business logic query PostingHistByGLAndJournalType

Parameters


iiCompanyIdintegerCompany id
iiGL_IDinteger
icGLCodecharacter
iiYearPeriodinteger

query condition


  each PostingHist where
PostingHist.Company_Id = iiCompanyId AND
PostingHist.PostingHistYearPeriodFrom <= iiYearPeriod AND
PostingHist.GL_ID = iiGL_ID

      first Currency (inner-join) where
Currency.Currency_ID = PostingHist.Currency_ID AND

      first GL (inner-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = PostingHist.GL_ID AND

      first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = PostingHist.Journal_ID AND

          first JournalType (inner-join) where
JournalType.JournalTypeCode = Journal.JournalTypeCode AND

query resultset tqPostingHistByGLAndJournalType


field namedata typedb fielddescription
tiCurrency_IDintegerPostingHist.Currency_IDLink to Currency
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tiCurrencyNumberOfDecimalsintegerCurrency.CurrencyNumberOfDecimalsNumber of Decimals
tcJournalTypeCodecharacterJournalType.JournalTypeCodeDaybook Type Code
tdPostingHistBalanceCreditCCdecimalPostingHist.PostingHistBalanceCreditCCSC Credit Balance
tdPostingHistBalanceCreditLCdecimalPostingHist.PostingHistBalanceCreditLCBC Balance Credit
tdPostingHistBalanceCreditTCdecimalPostingHist.PostingHistBalanceCreditTCTC Credit Balance
tdPostingHistBalanceDebitCCdecimalPostingHist.PostingHistBalanceDebitCCSC Debit Balance
tdPostingHistBalanceDebitLCdecimalPostingHist.PostingHistBalanceDebitLCBC Balance Debit
tdPostingHistBalanceDebitTCdecimalPostingHist.PostingHistBalanceDebitTCTC Debit Balance
tdPostingHistYTDCreditCCdecimalPostingHist.PostingHistYTDCreditCCSC Credit (YTD)
tdPostingHistYTDCreditLCdecimalPostingHist.PostingHistYTDCreditLCBC YTD Credit
tdPostingHistYTDCreditTCdecimalPostingHist.PostingHistYTDCreditTCTC Credit (YTD)
tdPostingHistYTDDebitCCdecimalPostingHist.PostingHistYTDDebitCCSC Debit (YTD)
tdPostingHistYTDDebitLCdecimalPostingHist.PostingHistYTDDebitLCBC YTD Debit
tdPostingHistYTDDebitTCdecimalPostingHist.PostingHistYTDDebitTCTC Debit (YTD)
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(PostingHist),rowid(Currency),rowid(GL),rowid(Journal),rowid(JournalType)

Internal usage


QadFinancials
method BClosingPostingsReport.FAControlGLBalance