project QadFinancials > class BPaymentSelection > business logic query PaySelLineByPaySelStatus
Parameters
| iiCompanyId | integer | Company id |
| iiPaySelObject_ID | integer | |
| icPaySelStatus | character | |
query condition
each PaySel where
PaySel.Company_Id = iiCompanyId AND
PaySel.PaySelStatus can-do icPaySelStatus
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = PaySel.Company_ID AND
each PaySelLine (inner-join) where
PaySelLine.PaySel_ID = PaySel.PaySel_ID AND
PaySelLine.PaySelLineParentObject_ID = iiPaySelObject_ID
query resultset tqPaySelLineByPaySelStatus
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | PaySel.Company_ID | Link to Company |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tcPaySelCode | character | PaySel.PaySelCode | Code |
| ttPaySelDate | date | PaySel.PaySelDate | Execution Date |
| tdPaySelLineAmountTC | decimal | PaySelLine.PaySelLineAmountTC | Amount |
| tdPaySelLineDiscountTC | decimal | PaySelLine.PaySelLineDiscountTC | Discount |
| tcPaySelLineObjectType | character | PaySelLine.PaySelLineObjectType | Type |
| tiPaySelLineParentObject_ID | integer | PaySelLine.PaySelLineParentObject_ID | Parent Object |
| tcPaySelStatus | character | PaySel.PaySelStatus | Status |
Internal usage
QadFinancials