project QadFinancials > class BPaymentSelection > business logic query PaySelLineByParentId

Description

Get all payment selection lines where parent object is included in.


Parameters


iiCompanyIdintegerCompany id
iiParentObjectIDinteger
icParentObjectTypecharacter
icPaySelStatuscharacter


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 namedata typedb fielddescription
tiCompany_IDintegerPaySel.Company_IDLink to Company
tdPaySelLineAmountTCdecimalPaySelLine.PaySelLineAmountTCAmount
tdPaySelLineDiscountTCdecimalPaySelLine.PaySelLineDiscountTCDiscount
tcPaySelLineObjectTypecharacterPaySelLine.PaySelLineObjectTypeType
tiPaySelLineParentObject_IDintegerPaySelLine.PaySelLineParentObject_IDParent Object
tcPaySelStatuscharacterPaySel.PaySelStatusStatus


Internal usage


QadFinancials
method BCInvoiceAPMatching.ApiGetCInvoiceAPMatchingDetails