project QadFinancials > class BPaymentSelection > business logic query PaySelLineByParentId
Description
Get all payment selection lines where parent object is included in.
Parameters
| iiCompanyId | integer | Company id |
| iiParentObjectID | integer | |
| icParentObjectType | character | |
| icPaySelStatus | character | |
query condition
each PaySelLine where
PaySelLine.PaySelLineObjectType = icParentObjectType AND
PaySelLine.PaySelLineParentObject_ID = iiParentObjectID
first PaySel (inner-join) where
PaySel.Company_Id = iiCompanyId AND
PaySel.PaySel_ID = PaySelLine.PaySel_ID AND
PaySel.PaySelStatus = icPaySelStatus
query resultset tqPaySelLineByParentId
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | PaySel.Company_ID | Link to Company |
| 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