project QadFinancials > class BBankNumber > business logic query BankNumberByNumber

Description

Get bank number by number of the bank account


Parameters


icBankNumberParentTypecharacter
icBankNumberMATCHEScharacter
iiCompanyIdintegerCompany id
ilIsActivelogical
icBankNumber1character


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 namedata typedb fielddescription
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tlBankNumberIsActivelogicalBankNumber.BankNumberIsActiveActive
tcBankNumberParentTypecharacterBankNumber.BankNumberParentTypeType
tiCompany_IDintegerCompanySharedSet.Company_IDEntity
tiCurrency_IDintegerCurrency.Currency_IDRecord ID
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tiParentObject_IDintegerBankNumber.ParentObject_IDParent Object


Internal usage


QadFinancials
method BBankImportLine.GetBankNumberByNumber