project QadFinancials > class BBankNumber > business logic query BankNumberForCreditorDebtor

Description

The query is used to check whether a bank number has been created for the specific creditor.


Parameters


iiParentObjectIdinteger
icBankNumbercharacter
icBankNumberExtensioncharacter
iiBankPayFormatIDinteger
icBankNumberValidationcharacter


query condition


  each BankNumber where
BankNumber.ParentObject_ID = iiParentObjectId AND
BankNumber.BankNumber = icBankNumber AND
BankNumber.BankNumberExtension = icBankNumberExtension AND
BankNumber.BankPayFormat_ID = iiBankPayFormatID AND
BankNumber.BankNumberValidation = icBankNumberValidation


query resultset tqBankNumberForCreditorDebtor


field namedata typedb fielddescription
tiBankBusinessRelation_IDintegerBankNumber.BankBusinessRelation_IDBusiness Relation
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tcBankNumberExtensioncharacterBankNumber.BankNumberExtensionBank Extension
tcBankNumberFormattedcharacterBankNumber.BankNumberFormattedFormatted Bank Account No
tcBankNumberSwiftCodecharacterBankNumber.BankNumberSwiftCodeSWIFT Code
tcBankNumberValidationcharacterBankNumber.BankNumberValidationValidation
tiBankPayFormat_IDintegerBankNumber.BankPayFormat_IDLink to BankPayFormat
tiCurrency_IDintegerBankNumber.Currency_IDCurrency Code
tiParentObject_IDintegerBankNumber.ParentObject_IDParent Object


Internal usage


QadFinancials
method BCDocument.ValidateComponentPreCreditor
method BDDocument.ValidateComponentPreDebtor