project QadFinancials > class BBankNumber > business logic query BankNumberForParentObject2


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

              first CompanySharedSet (inner-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = BankNumber2.CompanySharedSet_ID AND

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


query resultset tqBankNumberForParentObject2


field namedata typedb fielddescription
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tcBankNumberExtension1characterBankNumber.BankNumberExtensionBank Extension
tcBankNumberFormattedcharacterBankNumber.BankNumberFormattedFormatted Bank Account No
tiBankPayFormat_IDintegerBankPayFormat.BankPayFormat_IDRecord ID
tiCompany_IDintegerCompany.Company_IDRecord ID
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tcOwnBankNumbercharacterBankNumber2.BankNumberBank Number
tiOwnBankNumber_IDintegerBankNumber2.BankNumber_IDRecord ID
tiParentObject_IDintegerBankNumber.ParentObject_IDParent Object
tcPayFormatTypeCodecharacterBankPayFormat.PayFormatTypeCodePayment Format


Internal usage


QadFinancials
method BBankNumber.DataLoadByInput