project QadFinancials > class BBankNumber > business logic query BankNumberOwnBankGLByID

Description

This query returns own bank and payment format info for the specified customer or supplier bank. The main table BankNumber is a customer or supplier bank.


Parameters


iiBankNumber_IDinteger
iiCompanyIdintegerCompany id


query condition


  each BankNumber where
BankNumber.BankNumber_ID = iiBankNumber_ID

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

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

              first Currency (outer-join) where
Currency.Currency_ID = BankNumber2.Currency_ID AND

              first GL (inner-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = BankNumber2.ParentObject_ID AND

          first PayFormatType (inner-join) where
PayFormatType.PayFormatTypeCode = BankPayFormat.PayFormatTypeCode AND


query resultset tqBankNumberOwnBankGLByID


field namedata typedb fielddescription
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tiBankPayFormat_IDintegerBankPayFormat.BankPayFormat_IDRecord ID
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tiGL_IDintegerGL.GL_IDRecord ID
tcGLCodecharacterGL.GLCodeA code identifying the GL account.
tcOwnBankNumbercharacterBankNumber2.BankNumberBank Number
tiOwnBankNumber_IDintegerBankNumber2.BankNumber_IDRecord ID
tcPayFormatTypeCodecharacterBankPayFormat.PayFormatTypeCodePayment Format
tcPayFormatTypePayInstrumentcharacterPayFormatType.PayFormatTypePayInstrumentPayment Instrument


Internal usage


QadFinancials
method BCDocument.DataLoadByInput
method BDCollectionReport.DCollectionReport
method BDDocument.ApiStdMaintainTT
method BDDocument.Calculate
method BDDocument.CreateDDocumentHeader
method BDDocument.DataLoadByInput
method BDDocument.DefaultValuesGLCode
method BDDocument.ValidateComponentPost
method BDPaymentSelection.DefaultValuesGLCode