project QadFinancials > class BClosingPostingsReport > business logic query GLOpenItemByClosingDate


Parameters


iiCompanyIdintegerCompany id
itClosingDatedate
iiGL_IDinteger


query condition


  each GLOpenItem where
GLOpenItem.Company_Id = iiCompanyId AND
GLOpenItem.GL_ID = iiGL_ID AND
GLOpenItem.GLOpenItemClosingDate > itClosingDate

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


query resultset tqGLOpenItemByClosingDate


field namedata typedb fielddescription
tiCurrency_IDintegerCurrency.Currency_IDRecord ID
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tiGLOpenItem_IDintegerGLOpenItem.GLOpenItem_IDRecord ID
tdGLOpenItemBalanceCreditCCdecimalGLOpenItem.GLOpenItemBalanceCreditCCSC Credit Balance
tdGLOpenItemBalanceCreditLCdecimalGLOpenItem.GLOpenItemBalanceCreditLCBC Balance Credit
tdGLOpenItemBalanceCreditTCdecimalGLOpenItem.GLOpenItemBalanceCreditTCTC Credit Balance
tdGLOpenItemBalanceDebitCCdecimalGLOpenItem.GLOpenItemBalanceDebitCCSC Debit Balance
tdGLOpenItemBalanceDebitLCdecimalGLOpenItem.GLOpenItemBalanceDebitLCBC Balance Debit
tdGLOpenItemBalanceDebitTCdecimalGLOpenItem.GLOpenItemBalanceDebitTCTC Debit Balance


Internal usage


QadFinancials
method BClosingPostingsReport.GLOpenItemControl