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