project QadFinancials > class BClosingPostingsReport > business logic query PostingLineByGLOpenItem


Parameters


iiCompanyIdintegerCompany id
iiGLOpenItemIdinteger
iiSelectedPeriodinteger
itEndDatedate


query condition


  each GLOpenItemMovement where
GLOpenItemMovement.GLOpenItem_ID = iiGLOpenItemId

      first PostingLine (inner-join) where
PostingLine.Company_Id = iiCompanyId AND
PostingLine.PostingLine_ID = GLOpenItemMovement.PostingLine_ID AND
PostingLine.PostingDate <= itEndDate AND
PostingLine.PostingYearPeriod <= iiSelectedPeriod


query resultset tqPostingLineByGLOpenItem


field namedata typedb fielddescription
tiGLOpenItem_IDintegerGLOpenItemMovement.GLOpenItem_IDLink to GLOpenItem


Internal usage


QadFinancials
method BClosingPostingsReport.GLOpenItemControl