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