project QadFinancials > class BBankNumber > business logic query BankNumberForDDocument
Description
Used for checking whether a Bank Number has been used in a Customer Payment.
Parameters
| iiCompanyId | integer | Company id |
| iiBankNumberId | integer | |
query condition
each BankNumber where
BankNumber.BankNumber_ID = iiBankNumberId
each DDocument (inner-join) where
DDocument.Company_Id = iiCompanyId AND
DDocument.BankNumber_ID = BankNumber.BankNumber_ID AND
query resultset tqBankNumberForDDocument
| field name | data type | db field | description |
|---|
| tiBankNumber_ID | integer | BankNumber.BankNumber_ID | Record ID |
Internal usage
QadFinancials