project QadFinancials > class BBankNumber > business logic query BankNumberByParentTypeDefAct

Description

Give all bank numbers based on input parameters


Parameters


iiParentObjectIdintegerParentObjectID
icBankNumberParentTypecharacterBankNumberParentType
ilBankNumberIsDefaultlogicalBank Number Is Default
iiCompanyIdintegerCompany id
ilActivelogicalActive
icBankNumbercharacterBank Number
icBankNumberExtensioncharacterBank 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 namedata typedb fielddescription
tiBankPayFormat_IDintegerBankNumber.BankPayFormat_IDLink to BankPayFormat
tiBankBusinessRelation_IDintegerBankNumber.BankBusinessRelation_IDBusiness Relation
tcBankNumbercharacterBankNumber.BankNumberBank Number
tcBankNumberExtensioncharacterBankNumber.BankNumberExtensionBank Extension
tlBankNumberIsActivelogicalBankNumber.BankNumberIsActiveActive
tlBankNumberIsDefaultlogicalBankNumber.BankNumberIsDefaultDefault
tcBankNumberParentTypecharacterBankNumber.BankNumberParentTypeType
tcBankNumberSwiftCodecharacterBankNumber.BankNumberSwiftCodeSWIFT Code
tcBankNumberValidationcharacterBankNumber.BankNumberValidationValidation
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tiParentObject_IDintegerBankNumber.ParentObject_IDParent Object
tiCurrency_IDintegerBankNumber.Currency_IDCurrency Code
tiCompanySharedSet_IDintegerBankNumber.CompanySharedSet_IDLink to CompanySharedSet
tcBankNumberBusinessRelationCodecharacterBusinessRelation.BusinessRelationCodeBusiness 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_IDintegerCompanySharedSet.Company_IDEntity
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tcBankNumberFormattedcharacterBankNumber.BankNumberFormattedFormatted Bank Account No


Internal usage


QadFinancials
method BCreditor.ValBankNumberAndPayCodeRef
method BDebtor.ValBankNumberandPayCodeRef