project QadFinancials > class BBankNumber > business logic query BanknumberByBankNumberCurrency

Parameters


iiCompanyIdintegerCompany id
icBanknumbercharacter
ilBankNumberIsActivelogical
icBankNumberParentTypecharacter
icCurrencyCodecharacter
iiCurrencyIDinteger

query condition


  each BankNumber where
BankNumber.BankNumber = icBanknumber AND
BankNumber.BankNumberIsActive = ilBankNumberIsActive AND
BankNumber.BankNumberParentType = icBankNumberParentType AND
BankNumber.Currency_ID = iiCurrencyID

      first CompanySharedSet (conditional-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = BankNumber.CompanySharedSet_ID AND

          first Company (outer-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanySharedSet.Company_ID AND

      first Currency (conditional-join) where
Currency.Currency_ID = BankNumber.Currency_ID AND
Currency.CurrencyCode = icCurrencyCode

query resultset tqBanknumberByBankNumberCurrency


field namedata typedb fielddescription
tiCompany_ID2integerCompany.Company_IDRecord ID
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tlCompanyIsActivelogicalCompany.CompanyIsActiveActive
tcBankNumbercharacterBankNumber.BankNumberBank Number
tcBankNumberFormattedcharacterBankNumber.BankNumberFormattedFormatted Bank Account No
tcBankNumberExtensioncharacterBankNumber.BankNumberExtensionBank Extension
tlBankNumberIsActivelogicalBankNumber.BankNumberIsActiveActive
tlBankNumberIsDefaultlogicalBankNumber.BankNumberIsDefaultDefault
tcBankNumberParentTypecharacterBankNumber.BankNumberParentTypeType
tcBankNumberValidationcharacterBankNumber.BankNumberValidationValidation
tiCurrency_IDintegerBankNumber.Currency_IDCurrency Code
tiParentObject_IDintegerBankNumber.ParentObject_IDParent Object
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tiCurrencyNumberOfDecimalsintegerCurrency.CurrencyNumberOfDecimalsNumber of Decimals
tiCurrency_ID2integerCurrency.Currency_IDRecord ID
tiCompany_IDintegerCompanySharedSet.Company_IDEntity
tiCompanySharedSet_IDintegerCompanySharedSet.CompanySharedSet_IDRecord ID

Internal usage


QadFinancials
method BBankStateImport.AdditionalUpdatesCodeStart1
method BBankStateImport.AdditionalUpdatesSwiftStart