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