project QadFinancials > class BDPaymentSelection > business logic query DPaySelLineByParentObjectID


Parameters


iiParentObjectIDinteger
icObjectTypecharacter
iiCompanyIdintegerCompany id
icLineStatuscharacter


query condition


  each DPaySelLine where
DPaySelLine.DPaySelLineParentObject_ID = iiParentObjectID AND
DPaySelLine.DPaySelLineObjectType = icObjectType AND
DPaySelLine.DPaySelLineStatus <> icLineStatus

      first DPaySel (inner-join) where
DPaySel.Company_Id = iiCompanyId AND
DPaySel.DPaySel_ID = DPaySelLine.DPaySel_ID AND


query resultset tqDPaySelLineByParentObjectID


field namedata typedb fielddescription
tiDPaySel_IDintegerDPaySelLine.DPaySel_IDLink to DPaySel
tcDPaySelCodecharacterDPaySel.DPaySelCodePayment Selection
tiDPaySelLine_IDintegerDPaySelLine.DPaySelLine_IDRecord ID
tcDPaySelLineObjectTypecharacterDPaySelLine.DPaySelLineObjectTypeObject Type
tiDPaySelLineParentObject_IDintegerDPaySelLine.DPaySelLineParentObject_IDReference ID of the caller


Internal usage


QadFinancials
method BDInvoice.ApiUpdateCInvoiceWithNewBank
method BDInvoice.ValidateComponentPre