project QadFinancials > class BPaymentSelection > business logic query PaySelLineByBankNmbrCInvoice

Description

find payment selection lines for a certain banknumber_id , and where the paysellineparentobject_id = cinvoice_id, and where rowid is different from input rowid


Parameters


iiBankNumberIdintegerBank Number ID
icCurrentRowIdcharacterCurrent Row ID
iiCompanyIdintegerCompany id
iiCInvoiceIdintegerSupplier invoice ID


query condition


  each PaySelLine where
PaySelLine.BankNumber_ID = iiBankNumberId AND
PaySelLine.PaySelLineParentObject_ID = iiCInvoiceId AND
rowid(PaySelLine) <> to-rowid(icCurrentRowId)

      first CInvoice (inner-join) where
CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = PaySelLine.PaySelLineParentObject_ID AND


query resultset tqPaySelLineByBankNmbrCInvoice


field namedata typedb fielddescription
tiBankNumber_IDintegerPaySelLine.BankNumber_IDLink to BankNumber
tcPayFormatTypeCodecharacterPaySelLine.PayFormatTypeCodePayment format of the payment selection
tcPaySelLineObjectTypecharacterPaySelLine.PaySelLineObjectTypeType
tiPaySelLineParentObject_IDintegerPaySelLine.PaySelLineParentObject_IDParent Object


Internal usage


QadFinancials
method BCInvoice.UpdateCInvoiceBankNumber