project QadFinancials > class BPaymentSelection > business logic query PaySelLineByBankNmbrDInvoice
Description
find payment selection lines for a certain banknumber_id , and where the paysellineparentobject_id = dinvoice_id, and where rowid is different from input rowid
Parameters
| iiBankNumberId | integer | Bank Number ID |
| icCurrentRowId | character | Current Row ID |
| iiCompanyId | integer | Company id |
| iiDInvoiceId | integer | Customer Invoice ID |
query condition
each PaySelLine where
PaySelLine.BankNumber_ID = iiBankNumberId AND
PaySelLine.PaySelLineParentObject_ID = iiDInvoiceId AND
rowid(PaySelLine) <> to-rowid(icCurrentRowId)
first DInvoice (inner-join) where
DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = PaySelLine.PaySelLineParentObject_ID AND
query resultset tqPaySelLineByBankNmbrDInvoice
| field name | data type | db field | description |
|---|
| tiBankNumber_ID | integer | PaySelLine.BankNumber_ID | Link to BankNumber |
| tdPaySelLineAmountTC | decimal | PaySelLine.PaySelLineAmountTC | Amount |
| tcPaySelLineObjectType | character | PaySelLine.PaySelLineObjectType | Type |
| tiPaySelLineParentObject_ID | integer | PaySelLine.PaySelLineParentObject_ID | Parent Object |
Internal usage
QadFinancials