project QadFinancials > class BBankNumber > business logic query BankNumberForOwnBankNumber
Parameters
| iiCompanyId | integer | Company id |
| icOwnBankNumber | character | |
| icOwnGLCode | character | |
| icPayFormatTypeCode | character | |
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 name | data type | db field | description |
|---|
| tiBankNumber_ID | integer | BankNumber.BankNumber_ID | Record ID |
| tcBankNumberParentType | character | BankNumber.BankNumberParentType | Type |
| tiBankPayFormat_ID | integer | BankPayFormat.BankPayFormat_ID | Record ID |
| tiCompany_ID | integer | CompanySharedSet.Company_ID | Entity |
| tiGL_ID | integer | GL.GL_ID | Record ID |
| tcOwnBankNumber | character | BankNumber.BankNumber | Bank Number |
| tcOwnGLCode | character | GL.GLCode | A code identifying the GL account. |
| tiParentObject_ID | integer | BankNumber.ParentObject_ID | Parent Object |
| tcPayFormatTypeCode | character | BankPayFormat.PayFormatTypeCode | Payment Format |
Internal usage
QadFinancials