project QadFinancials > class BBankNumber > business logic query BankNumberForParentObject


Parameters


iiCompanyIdintegerCompany id
iiParentObjectIDinteger
icBankNumbercharacter
icOwnBankNumbercharacter
icPayFormatTypeCodecharacter


query condition


  each BankNumber where
BankNumber.BankNumber = icBankNumber AND
BankNumber.ParentObject_ID = iiParentObjectID

      first BankPayFormat (inner-join) where
BankPayFormat.BankPayFormat_ID = BankNumber.BankPayFormat_ID AND
BankPayFormat.PayFormatTypeCode = icPayFormatTypeCode

          first BankNumber2 (inner-join) where
BankNumber2.BankNumber_ID = BankPayFormat.BankNumber_ID AND
BankNumber2.BankNumber = icOwnBankNumber


query resultset tqBankNumberForParentObject


field namedata typedb fielddescription
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tcBankNumberFormattedcharacterBankNumber.BankNumberFormattedFormatted Bank Account No
tcOwnBankNumbercharacterBankNumber2.BankNumberBank Number
tiOwnBankNumber_IDintegerBankNumber2.BankNumber_IDRecord ID
tiParentObject_IDintegerBankNumber.ParentObject_IDParent Object
tcPayFormatTypeCodecharacterBankPayFormat.PayFormatTypeCodePayment Format


Internal usage


QadFinancials
method BBankNumber.DataLoadByInput
method BCDocument.ValidateComponentPreCInvoice
method BCDocument.ValidateComponentPreCreditor
method BDDocument.ValidateComponentPreDebtor
method BDDocument.ValidateComponentPreDInvoice
method BDInvoice.CreateDInvoices