project QadFinancials > class BBankNumber > business logic query BankNumberByPayFormat
Parameters
| icBankNumber | character | |
| icCreditorCode | character | |
| icOwnBankNumber | character | |
| icPaymentFormat | character | |
| iiCompanyId | integer | Company id |
query condition
each BankNumber where
BankNumber.BankNumber = icBankNumber
first BankPayFormat (inner-join) where
BankPayFormat.BankPayFormat_ID = BankNumber.BankPayFormat_ID AND
BankPayFormat.PayFormatTypeCode = icPaymentFormat
first BankNumber2 (inner-join) where
BankNumber2.BankNumber_ID = BankPayFormat.BankNumber_ID AND
BankNumber2.BankNumber = icOwnBankNumber
first Creditor (inner-join) where
Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.Creditor_ID = BankNumber.ParentObject_ID AND
Creditor.CreditorCode = icCreditorCode
query resultset tqBankNumberByPayFormat
| 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 |
| tlBankNumberIsDefault | logical | BankNumber.BankNumberIsDefault | Default |
| tcCreditorCode | character | Creditor.CreditorCode | Supplier Code |
| tcOwnBankNumber | character | BankNumber2.BankNumber | Bank Number |
| tcPayFormatTypeCode | character | BankPayFormat.PayFormatTypeCode | Payment Format |
Internal usage
QadFinancials