Parameters
iiCompanyId | integer | Company id |
iiGLOpenItemId | integer | |
iiSelectedPeriod | integer | |
itEndDate | date | |
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 name | data type | db field | description |
tiGLOpenItem_ID | integer | GLOpenItemMovement.GLOpenItem_ID | Link to GLOpenItem |
Internal usage
QadFinancials