project QadFinancials > class BBankNumber > business logic query BankNumberByPayFormatTypeCode
Parameters
| icPaymentFormatTypeCode | character | |
| icBankNumber | character | |
| iiCompanyId | integer | Company id |
query condition
each BankNumber where
BankNumber.BankNumber = icBankNumber
each BankPayFormat (inner-join) where
BankPayFormat.BankNumber_ID = BankNumber.BankNumber_ID AND
BankPayFormat.PayFormatTypeCode = icPaymentFormatTypeCode
first CompanySharedSet (inner-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = BankNumber.CompanySharedSet_ID AND
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanySharedSet.Company_ID AND
query resultset tqBankNumberByPayFormatTypeCode
| field name | data type | db field | description |
|---|
| tcBankNumber | character | BankNumber.BankNumber | Bank Number |
| tiBankPayFormat_ID | integer | BankPayFormat.BankPayFormat_ID | Record ID |
| tcPayFormatTypeCode | character | BankPayFormat.PayFormatTypeCode | Payment Format |
Internal usage
QadFinancials