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