project QadFinancials > class BBankNumber > business logic query BankNumberByID

Description

BankNumberByID


Parameters


iiBankNumber_IDinteger
iiCompanyIdintegerCompany id


query condition


  each BankNumber where
BankNumber.BankNumber_ID = iiBankNumber_ID

      first CompanySharedSet (conditional-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = BankNumber.CompanySharedSet_ID AND

          first Company (conditional-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanySharedSet.Company_ID AND


query resultset tqBankNumberByID


field namedata typedb fielddescription
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tcBankNumberExtensioncharacterBankNumber.BankNumberExtensionBank Extension
tcBankNumberFormattedcharacterBankNumber.BankNumberFormattedFormatted Bank Account No
tcBankNumberValidationcharacterBankNumber.BankNumberValidationValidation
tiCompany_IDintegerCompany.Company_IDRecord ID
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(BankNumber),rowid(CompanySharedSet),rowid(Company)


Internal usage


QadFinancials
method BCDocument.ValidateComponentPreCreditor
method BDDocument.DataLoadByInput
method BDDocument.ValidateComponentPreDebtor
method BDPaymentSelection.GetToPayObjectsInitialLoad
method BPaymentSelection.AdditionalUpdatesRegister
method BPaymentSelection.AdditionalUpdatesRegisterPrePayment
method BPaymentSelection.GetToPayObjectsInitialLoad
method BPaymentSelection.GetToPayObjectsInitLoadFromInst
method BPaymentSelection.ValidateComponentPostSummary
method BPaymentSelection.ValidateComponentPreBankPayFormat