business logic query BankNumberByParentTypeDefAct

Description

Give all bank numbers based on input parameters

Parameters

iiParentObjectId	integer	ParentObjectID
icBankNumberParentType	character	BankNumberParentType
ilBankNumberIsDefault	logical	Bank Number Is Default
iiCompanyId	integer	Company id
ilActive	logical	Active
icBankNumber	character	Bank Number
icBankNumberExtension	character	Bank Number Extension

query condition

each BankNumber where

BankNumber.ParentObject_ID = iiParentObjectId AND
BankNumber.BankNumberParentType = icBankNumberParentType AND
BankNumber.BankNumberIsDefault = ilBankNumberIsDefault AND
BankNumber.BankNumberIsActive = ilActive AND
BankNumber.BankNumber matches icBankNumber AND
BankNumber.BankNumberExtension matches icBankNumberExtension

first BusinessRelation (conditional-join) where

BusinessRelation.BusinessRelation_ID = BankNumber.BankBusinessRelation_ID AND

first CompanySharedSet (outer-join) where

CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = BankNumber.CompanySharedSet_ID AND

first Company (outer-join) where

Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanySharedSet.Company_ID AND

query resultset tqBankNumberByParentTypeDefAct

field name	data type	db field	description
tiBankPayFormat_ID	integer	BankNumber.BankPayFormat_ID	Link to BankPayFormat
tiBankBusinessRelation_ID	integer	BankNumber.BankBusinessRelation_ID	Business Relation
tcBankNumber	character	BankNumber.BankNumber	Bank Number
tcBankNumberExtension	character	BankNumber.BankNumberExtension	Bank Extension
tlBankNumberIsActive	logical	BankNumber.BankNumberIsActive	Active
tlBankNumberIsDefault	logical	BankNumber.BankNumberIsDefault	Default
tcBankNumberParentType	character	BankNumber.BankNumberParentType	Type
tcBankNumberSwiftCode	character	BankNumber.BankNumberSwiftCode	SWIFT Code
tcBankNumberValidation	character	BankNumber.BankNumberValidation	Validation
tiBankNumber_ID	integer	BankNumber.BankNumber_ID	Record ID
tiParentObject_ID	integer	BankNumber.ParentObject_ID	Parent Object
tiCurrency_ID	integer	BankNumber.Currency_ID	Currency Code
tiCompanySharedSet_ID	integer	BankNumber.CompanySharedSet_ID	Link to CompanySharedSet
tcBankNumberBusinessRelationCode	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
tcCompanyCode	character	Company.CompanyCode	Entity Code
tcBankNumberFormatted	character	BankNumber.BankNumberFormatted	Formatted Bank Account No

Internal usage

QadFinancials

method BCreditor.ValBankNumberAndPayCodeRef
method BDebtor.ValBankNumberandPayCodeRef