business logic query BankNumberForCIDefault

Parameters

iiParentObjectId	integer
ilBankNumberIsDefault	logical
ilBankNumberIsActive	logical
iiCompanyId	integer	Company id

query condition

each BankNumber where

BankNumber.ParentObject_ID = iiParentObjectId AND
BankNumber.BankNumberIsActive = ilBankNumberIsActive AND
BankNumber.BankNumberIsDefault = ilBankNumberIsDefault

first BankPayFormat (inner-join) where

BankPayFormat.BankPayFormat_ID = BankNumber.BankPayFormat_ID AND

first BankNumber2 (inner-join) where

BankNumber2.BankNumber_ID = BankPayFormat.BankNumber_ID AND

first CompanySharedSet (inner-join) where

CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = BankNumber2.CompanySharedSet_ID AND

first BusinessRelation (outer-join) where

BusinessRelation.BusinessRelation_ID = BankNumber.BankBusinessRelation_ID AND

query resultset tqBankNumberForCIDefault

field name	data type	db field	description
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
tlBankNumberIsActive	logical	BankNumber.BankNumberIsActive	Active
tlBankNumberIsDefault	logical	BankNumber.BankNumberIsDefault	Default
tcBankNumberSwiftCode	character	BankNumber.BankNumberSwiftCode	SWIFT Code
tcBankNumberValidation	character	BankNumber.BankNumberValidation	Validation
tiBankPayFormat_ID	integer	BankNumber.BankPayFormat_ID	Link to BankPayFormat
tcBusinessRelationCode	character	BusinessRelation.BusinessRelationCode	Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create.
tiCompany_ID	integer	CompanySharedSet.Company_ID	Entity
tiParentObject_ID	integer	BankNumber.ParentObject_ID	Parent Object

Internal usage

QadFinancials

method BCInvoice.CreateCInvoices
method BCInvoice.DefaultValuesBank
method BCInvoice.ValidateComponentPreBank
method BCInvoiceJournalEntry.ApiStdMaintainTTValidationsAndDef
method BCreditorOpenBalance.ApiCreateCreditorOpenBalanceV01
method BDInvoice.DefaultValuesBank
method BDInvoiceJournalEntry.ApiStdMaintainTTDefValExtPost