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
| iiBankNumberId | integer | Bank Number ID |
| icCurrentRowId | character | Current Row ID |
| iiCompanyId | integer | Company id |
| iiCInvoiceId | integer | Supplier 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 name | data type | db field | description |
|---|
| tiBankNumber_ID | integer | PaySelLine.BankNumber_ID | Link to BankNumber |
| tcPayFormatTypeCode | character | PaySelLine.PayFormatTypeCode | Payment format of the payment selection |
| tcPaySelLineObjectType | character | PaySelLine.PaySelLineObjectType | Type |
| tiPaySelLineParentObject_ID | integer | PaySelLine.PaySelLineParentObject_ID | Parent Object |
Internal usage
QadFinancials