project QadFinancials > class BBankNumber > business logic query BankNumberForCIDefault


Parameters


iiParentObjectIdinteger
ilBankNumberIsDefaultlogical
ilBankNumberIsActivelogical
iiCompanyIdintegerCompany 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 namedata typedb fielddescription
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tcBankNumberExtensioncharacterBankNumber.BankNumberExtensionBank Extension
tcBankNumberFormattedcharacterBankNumber.BankNumberFormattedFormatted Bank Account No
tlBankNumberIsActivelogicalBankNumber.BankNumberIsActiveActive
tlBankNumberIsDefaultlogicalBankNumber.BankNumberIsDefaultDefault
tcBankNumberSwiftCodecharacterBankNumber.BankNumberSwiftCodeSWIFT Code
tcBankNumberValidationcharacterBankNumber.BankNumberValidationValidation
tiBankPayFormat_IDintegerBankNumber.BankPayFormat_IDLink to BankPayFormat
tcBusinessRelationCodecharacterBusinessRelation.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
tiParentObject_IDintegerBankNumber.ParentObject_IDParent 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