project QadFinancials > class BBankNumber > business logic query BankNumberForOwnBankNumber


Parameters


iiCompanyIdintegerCompany id
icOwnBankNumbercharacter
icOwnGLCodecharacter
icPayFormatTypeCodecharacter


query condition


  each BankNumber where
BankNumber.BankNumber = icOwnBankNumber

      each BankPayFormat (inner-join) where
BankPayFormat.BankNumber_ID = BankNumber.BankNumber_ID AND
BankPayFormat.PayFormatTypeCode = icPayFormatTypeCode

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

      first GL (conditional-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = BankNumber.ParentObject_ID AND
GL.GLCode = icOwnGLCode


query sort order


BankNumber.OwnBankNumber (ascending)
BankPayFormat.PayFormatTypeCode (ascending)


query resultset tqBankNumberForOwnBankNumber


field namedata typedb fielddescription
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tcBankNumberParentTypecharacterBankNumber.BankNumberParentTypeType
tiBankPayFormat_IDintegerBankPayFormat.BankPayFormat_IDRecord ID
tiCompany_IDintegerCompanySharedSet.Company_IDEntity
tiGL_IDintegerGL.GL_IDRecord ID
tcOwnBankNumbercharacterBankNumber.BankNumberBank Number
tcOwnGLCodecharacterGL.GLCodeA code identifying the GL account.
tiParentObject_IDintegerBankNumber.ParentObject_IDParent Object
tcPayFormatTypeCodecharacterBankPayFormat.PayFormatTypeCodePayment Format


Internal usage


QadFinancials
method BBankNumber.ApiStdMaintainTT
method BBankNumber.DataLoadByInput
method BBankNumber.ValidateComponentBeforeAncestor
method BCDocument.DefaultValuesBankNumber
method BCDocument.ValidateComponentPreCInvoice
method BDDocument.DefaultValuesBankNumber
method BDDocument.ValidateComponentPreDInvoice