project QadFinancials > class BBankNumber > business logic query BankNumberByIDAllInfo


Parameters


iiBankNumber_IDinteger
ilBankNumberIsDefaultlogical


query condition


  each BankNumber where
BankNumber.BankNumber_ID = iiBankNumber_ID AND
BankNumber.BankNumberIsDefault = ilBankNumberIsDefault

      first BusinessRelation (conditional-join) where
BusinessRelation.BusinessRelation_ID = BankNumber.BankBusinessRelation_ID AND


query resultset tqBankNumberByIDAllInfo


field namedata typedb fielddescription
tiBankAccFormat_IDintegerBankNumber.BankAccFormat_IDBank Account Format
tiBankBusinessRelation_IDintegerBankNumber.BankBusinessRelation_IDBusiness Relation
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tcBankNumberBankAccountTypecharacterBankNumber.BankNumberBankAccountTypeBank Account Type
tcBankNumberBranchcharacterBankNumber.BankNumberBranchBranch
tcBankNumberExtensioncharacterBankNumber.BankNumberExtensionBank Extension
tcBankNumberFormattedcharacterBankNumber.BankNumberFormattedFormatted Bank Account No
tlBankNumberIsActivelogicalBankNumber.BankNumberIsActiveActive
tlBankNumberIsBankChargelogicalBankNumber.BankNumberIsBankChargeBank Charge
tlBankNumberIsDefaultlogicalBankNumber.BankNumberIsDefaultDefault
tcBankNumberParentTypecharacterBankNumber.BankNumberParentTypeType
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.
tiCompanySharedSet_IDintegerBankNumber.CompanySharedSet_IDLink to CompanySharedSet
tiCurrency_IDintegerBankNumber.Currency_IDCurrency Code
tcCustomCombo0characterBankNumber.CustomCombo0Custom Combo Field
tcCustomCombo1characterBankNumber.CustomCombo1Custom Combo Field
tcCustomCombo2characterBankNumber.CustomCombo2Custom Combo Field
tcCustomCombo3characterBankNumber.CustomCombo3Custom Combo Field
tcCustomCombo4characterBankNumber.CustomCombo4Custom Combo Field
tcCustomCombo5characterBankNumber.CustomCombo5Custom Combo Field
tcCustomCombo6characterBankNumber.CustomCombo6Custom Combo Field
tcCustomCombo7characterBankNumber.CustomCombo7Custom Combo Field
tcCustomCombo8characterBankNumber.CustomCombo8Custom Combo Field
tcCustomCombo9characterBankNumber.CustomCombo9Custom Combo Field
ttCustomDate0dateBankNumber.CustomDate0Custom Date Field
ttCustomDate1dateBankNumber.CustomDate1Custom Date Field
ttCustomDate2dateBankNumber.CustomDate2Custom Date Field
ttCustomDate3dateBankNumber.CustomDate3Custom Date Field
ttCustomDate4dateBankNumber.CustomDate4Custom Date Field
tdCustomDecimal0decimalBankNumber.CustomDecimal0Custom Decimal Field
tdCustomDecimal1decimalBankNumber.CustomDecimal1Custom Decimal Field
tdCustomDecimal2decimalBankNumber.CustomDecimal2Custom Decimal Field
tdCustomDecimal3decimalBankNumber.CustomDecimal3Custom Decimal Field
tdCustomDecimal4decimalBankNumber.CustomDecimal4Custom Decimal Field
tiCustomInteger0integerBankNumber.CustomInteger0Custom Integer Field
tiCustomInteger1integerBankNumber.CustomInteger1Custom Integer Field
tiCustomInteger2integerBankNumber.CustomInteger2Custom Integer Field
tiCustomInteger3integerBankNumber.CustomInteger3Custom Integer Field
tiCustomInteger4integerBankNumber.CustomInteger4Custom Integer Field
tcCustomLong0characterBankNumber.CustomLong0Custom Long Field
tcCustomLong1characterBankNumber.CustomLong1Custom Long Field
tcCustomNotecharacterBankNumber.CustomNoteCustom Note Field
tcCustomShort0characterBankNumber.CustomShort0Custom Short Field
tcCustomShort1characterBankNumber.CustomShort1Custom Short Field
tcCustomShort2characterBankNumber.CustomShort2Custom Short Field
tcCustomShort3characterBankNumber.CustomShort3Custom Short Field
tcCustomShort4characterBankNumber.CustomShort4Custom Short Field
tcCustomShort5characterBankNumber.CustomShort5Custom Short Field
tcCustomShort6characterBankNumber.CustomShort6Custom Short Field
tcCustomShort7characterBankNumber.CustomShort7Custom Short Field
tcCustomShort8characterBankNumber.CustomShort8Custom Short Field
tcCustomShort9characterBankNumber.CustomShort9Custom Short Field
ttLastModifiedDatedateBankNumber.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerBankNumber.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterBankNumber.LastModifiedUserLast Modified User
tiParentObject_IDintegerBankNumber.ParentObject_IDParent Object
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(BankNumber),rowid(BusinessRelation)


Internal usage


QadFinancials
method BBillReport.GetBillReportTitleInfo
method BCDocument.ApiSetCDocumentStatusChange
method BCDocument.GetBankChargeAmount
method BCDocument.GetBankChargeValidandType
method BCreditor.ValBankNumberAndPayCodeRef
method BDCollection.FillProDataSetDocument
method BDDocument.ApiSetDDocumentStatusChange
method BDDocument.GetPossibleAllocationsByBank
method BDebtor.ValBankNumberandPayCodeRef
method BDInvoiceJournalEntry.ApiStdMaintainTTDefValExtPost
method BPaymentSelection.FillProdataSetPaymentBankNumber