project QadFinancials > class BBankNumber > business logic query BankNumberForCDocument

Description

Used for checking whether a Bank Number has been used in a Supplier Payment.


Parameters


iiCompanyIdintegerCompany id
iiBankNumberIdinteger


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 namedata typedb fielddescription
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID


Internal usage


QadFinancials
method BBankNumber.ApiLoadSupplierBankNumber