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