project QadFinancials > class BCashBoxReport > business logic query PostingHistByYearPeriodGL

Parameters


iiCompanyIdintegerCompany id
iiGL_IDinteger
iiYearPeriodinteger

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 tqPostingHistByYearPeriodGL


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 BCashBoxReport.CashBook