project QadFinancials > class BBankNumber > business logic query BankNumberPrim

Description

this query can be used by other components that have the ID of a Bank Number but that needs to know the logical identification of the Bank Number or vice-versa


Parameters


iiBankNumberIdinteger
iiParentObjectIdinteger
icBankNumbercharacter
icBankNumberExtensioncharacter
iiBankPayFormatIDinteger


query condition


  each BankNumber where
BankNumber.BankNumber_ID = iiBankNumberId AND
BankNumber.ParentObject_ID = iiParentObjectId AND
BankNumber.BankNumber = icBankNumber AND
BankNumber.BankNumberExtension = icBankNumberExtension AND
BankNumber.BankPayFormat_ID = iiBankPayFormatID

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


query resultset tqBankNumberPrim


field namedata typedb fielddescription
tiBankBusinessRelation_IDintegerBankNumber.BankBusinessRelation_IDBusiness Relation
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tcBankNumberExtensioncharacterBankNumber.BankNumberExtensionBank Extension
tcBankNumberFormattedcharacterBankNumber.BankNumberFormattedFormatted Bank Account No
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.
tiCurrency_IDintegerBankNumber.Currency_IDCurrency Code
tiParentObject_IDintegerBankNumber.ParentObject_IDParent Object


Internal usage


QadFinancials
method BBankEntry.GetPossibleAllocationsCInvoice
method BBankEntry.GetPossibleAllocationsDInvoice
method BBankNumber.ApiStdMaintainTT
method BBankPayFormat.ApiMaintainStdTT
method BBankPayFormat.DataLoadByInput
method BCDocument.CalculateAll
method BCDocument.CalculateBankChargeTax
method BCDocument.ValidateComponentPreCreditor
method BCInvoice.CalculateCInvoiceBank
method BCInvoice.CreateCInvoicesValidate
method BCInvoice.DefaultValuesNewBankNumber
method BCInvoice.ValidateComponentPre
method BCInvoice.ValidateComponentPreBank
method BDDocument.Calculate
method BDDocument.CreateDDocumentHeader
method BDDocument.ValidateComponentPreDebtor
method BDInvoice.DefaultValuesNewBankNumber
method BDInvoice.ValidateComponentPre
method BDInvoice.ValidateComponentPreValidateBank
method BDPaymentSelection.AdditionalUpdatesDDocument
method BDPaymentSelection.StoreSelectedObjects
method BPaymentSelection.ExportBEAbroad
method BPaymentSelection.ExportBEInland
method BPaymentSelection.ExportNLInland
method BPaymentSelection.StoreSelectedObjects
read related business field(s) on tBankPayFormat.BankNumber_ID
read related business field(s) on tCInvoiceBank.BankNumber_ID
read related business field(s) on tDInvoiceBank.BankNumber_ID
read related business field(s) on tPayConf.BankNumber_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues