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_ID | integer | |
| iiCompanyId | integer | Company 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 name | data type | db field | description |
|---|
| tcBankNumber | character | BankNumber.BankNumber | Bank Number |
| tiBankNumber_ID | integer | BankNumber.BankNumber_ID | Record ID |
| tiBankPayFormat_ID | integer | BankPayFormat.BankPayFormat_ID | Record ID |
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tiGL_ID | integer | GL.GL_ID | Record ID |
| tcGLCode | character | GL.GLCode | A code identifying the GL account. |
| tcOwnBankNumber | character | BankNumber2.BankNumber | Bank Number |
| tiOwnBankNumber_ID | integer | BankNumber2.BankNumber_ID | Record ID |
| tcPayFormatTypeCode | character | BankPayFormat.PayFormatTypeCode | Payment Format |
| tcPayFormatTypePayInstrument | character | PayFormatType.PayFormatTypePayInstrument | Payment Instrument |
Internal usage
QadFinancials