business logic query BankNumberForCreditorDebtor

Description

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

Parameters

iiParentObjectId	integer
icBankNumber	character
icBankNumberExtension	character
iiBankPayFormatID	integer
icBankNumberValidation	character

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 name	data type	db field	description
tiBankBusinessRelation_ID	integer	BankNumber.BankBusinessRelation_ID	Business Relation
tcBankNumber	character	BankNumber.BankNumber	Bank Number
tiBankNumber_ID	integer	BankNumber.BankNumber_ID	Record ID
tcBankNumberExtension	character	BankNumber.BankNumberExtension	Bank Extension
tcBankNumberFormatted	character	BankNumber.BankNumberFormatted	Formatted Bank Account No
tcBankNumberSwiftCode	character	BankNumber.BankNumberSwiftCode	SWIFT Code
tcBankNumberValidation	character	BankNumber.BankNumberValidation	Validation
tiBankPayFormat_ID	integer	BankNumber.BankPayFormat_ID	Link to BankPayFormat
tiCurrency_ID	integer	BankNumber.Currency_ID	Currency Code
tiParentObject_ID	integer	BankNumber.ParentObject_ID	Parent Object

Internal usage

QadFinancials

method BCDocument.ValidateComponentPreCreditor
method BDDocument.ValidateComponentPreDebtor