project QadFinancials > class BPaymentSelection > business logic query PaySelLineByPaySelIDCInvoice
Parameters
| iiPaySelID | integer | |
| iiCompanyId | integer | Company id |
| iiBankPayFormatID | integer | |
query condition
each PaySelLine where
PaySelLine.PaySel_ID = iiPaySelID
first CInvoice (inner-join) where
CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = PaySelLine.PaySelLineParentObject_ID AND
first Creditor (inner-join) where
Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.Creditor_ID = CInvoice.Creditor_ID AND
each BankNumber (inner-join) where
BankNumber.ParentObject_ID = Creditor.Creditor_ID AND
BankNumber.BankPayFormat_ID = iiBankPayFormatID
query resultset tqPaySelLineByPaySelIDCInvoice
| field name | data type | db field | description |
|---|
| tcBankNumber | character | BankNumber.BankNumber | Bank Number |
| tiBankNumber_ID | integer | BankNumber.BankNumber_ID | Record ID |
| tcBankNumberExtension | character | BankNumber.BankNumberExtension | Bank Extension |
| tlBankNumberIsActive | logical | BankNumber.BankNumberIsActive | Active |
| tcBankNumberValidation | character | BankNumber.BankNumberValidation | Validation |
| tiBankPayFormat_ID | integer | BankNumber.BankPayFormat_ID | Link to BankPayFormat |
| tiCreditor_ID | integer | Creditor.Creditor_ID | Record ID |
| tiPaySel_ID | integer | PaySelLine.PaySel_ID | Link to PaySel |
| tiPaySelLine_ID | integer | PaySelLine.PaySelLine_ID | Record ID |
| tcPaySelLineObjectType | character | PaySelLine.PaySelLineObjectType | Type |
| tiPaySelLineParentObject_ID | integer | PaySelLine.PaySelLineParentObject_ID | Parent Object |
Internal usage
QadFinancials