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