project QadFinancials > class BBankNumber > business logic query BankNumberByParentNumberExt


Parameters


iiParentObjectIDinteger
icBankNumbercharacter
icBankNumberExtensioncharacter


query condition


  each BankNumber where
BankNumber.BankNumber = icBankNumber AND
BankNumber.BankNumberExtension = icBankNumberExtension AND
BankNumber.ParentObject_ID = iiParentObjectID

      first Currency (outer-join) where
Currency.Currency_ID = BankNumber.Currency_ID AND


query resultset tqBankNumberByParentNumberExt


field namedata typedb fielddescription
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tcBankNumberExtensioncharacterBankNumber.BankNumberExtensionBank Extension
tcBankNumberValidationcharacterBankNumber.BankNumberValidationValidation
tiCurrency_IDintegerBankNumber.Currency_IDCurrency Code
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tiParentObject_IDintegerBankNumber.ParentObject_IDParent Object


Internal usage


QadFinancials
method BJournalEntry.DumpJEForConsolid