project QadFinancials > class BBankNumber > business logic query BankNumberByNumber
Description
Get bank number by number of the bank account
Parameters
| icBankNumberParentType | character | |
| icBankNumberMATCHES | character | |
| iiCompanyId | integer | Company id |
| ilIsActive | logical | |
| icBankNumber1 | character | |
query condition
each BankNumber where
BankNumber.BankNumberParentType = icBankNumberParentType AND
BankNumber.BankNumber matches icBankNumberMATCHES AND
BankNumber.BankNumber = icBankNumber1 AND
BankNumber.BankNumberIsActive = ilIsActive
first CompanySharedSet (inner-join) where
CompanySharedSet.CompanySharedSet_ID = BankNumber.CompanySharedSet_ID AND
CompanySharedSet.Company_ID = iiCompanyId
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanySharedSet.Company_ID AND
first Currency (outer-join) where
Currency.Currency_ID = BankNumber.Currency_ID AND
query resultset tqBankNumberByNumber
| field name | data type | db field | description |
|---|
| tcBankNumber | character | BankNumber.BankNumber | Bank Number |
| tiBankNumber_ID | integer | BankNumber.BankNumber_ID | Record ID |
| tlBankNumberIsActive | logical | BankNumber.BankNumberIsActive | Active |
| tcBankNumberParentType | character | BankNumber.BankNumberParentType | Type |
| tiCompany_ID | integer | CompanySharedSet.Company_ID | Entity |
| tiCurrency_ID | integer | Currency.Currency_ID | Record ID |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tiParentObject_ID | integer | BankNumber.ParentObject_ID | Parent Object |
Internal usage
QadFinancials