project QadFinancials > class BDCollectionReport > business logic query DCollectionOwnBankNumber
Parameters
| iiParentObjectID | integer | |
| icParentType | character | |
query condition
each BankNumber where
BankNumber.BankNumberParentType = icParentType AND
BankNumber.ParentObject_ID = iiParentObjectID
each BankPayFormat (inner-join) where
BankPayFormat.BankNumber_ID = BankNumber.BankNumber_ID AND
first Currency (inner-join) where
Currency.Currency_ID = BankNumber.Currency_ID AND
query resultset tqDCollectionOwnBankNumber
| field name | data type | db field | description |
|---|
| tcBankNumber | character | BankNumber.BankNumber | Bank Number |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tcPayFormatTypeCode | character | BankPayFormat.PayFormatTypeCode | Payment Format |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(BankNumber),rowid(BankPayFormat),rowid(Currency) |
Internal usage
QadFinancials