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