project QadFinancials > class BDCollection > business logic query DCollectionByPaySel
Parameters
| iiCompanyId | integer | Company id |
| iiPaySelId | integer | |
| ilExecuted | logical | |
query condition
each DCollection where
DCollection.Company_Id = iiCompanyId AND
DCollection.DPaySel_ID = iiPaySelId AND
DCollection.DCollectionIsExecuted = ilExecuted
query resultset tqDCollectionByPaySel
| field name | data type | db field | description |
|---|
| tiDCollection_ID | integer | DCollection.DCollection_ID | Record ID |
| tlDCollectionIsExecuted | logical | DCollection.DCollectionIsExecuted | Executed |
| tiDPaySel_ID | integer | DCollection.DPaySel_ID | Link to DPaySel |
Internal usage
QadFinancials