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