project QadFinancials > class BBankNumber > business logic query BankNumberByParentNumberExt
Parameters
| iiParentObjectID | integer | |
| icBankNumber | character | |
| icBankNumberExtension | character | |
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 name | data type | db field | description |
|---|
| tcBankNumber | character | BankNumber.BankNumber | Bank Number |
| tiBankNumber_ID | integer | BankNumber.BankNumber_ID | Record ID |
| tcBankNumberExtension | character | BankNumber.BankNumberExtension | Bank Extension |
| tcBankNumberValidation | character | BankNumber.BankNumberValidation | Validation |
| tiCurrency_ID | integer | BankNumber.Currency_ID | Currency Code |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tiParentObject_ID | integer | BankNumber.ParentObject_ID | Parent Object |
Internal usage
QadFinancials