project QadFinancials > class BBankEntry > business logic query BankStateByGLBankStateNbr
Description
BankStateByGLBankStateNbr; set of bank-states for a GL filtered and sorted by GL+BankStateNumber
Parameters
| iiCompanyId | integer | Company id |
| icMinBankStateNumber | character | When passing a value for this parameter then only those bank-states with a strictly higher banknumber will be returned |
| iiGLID | integer | GL-ID of the Bank-GL you need a number for |
| icBankStateLineStatus | character | Status of Bank State Line |
| icGLCode | character | GL code |
| icBankStateStatus | character | |
query condition
each BankState where
BankState.Company_Id = iiCompanyId AND
BankState.BankStateNumber > icMinBankStateNumber AND
BankState.GL_ID = iiGLID AND
BankState.BankStateStatus = icBankStateStatus
each BankStateLine (inner-join) where
BankStateLine.Company_Id = iiCompanyId AND
BankStateLine.BankState_ID = BankState.BankState_ID AND
BankStateLine.BankStateLineStatus matches icBankStateLineStatus
first GL (inner-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = BankState.GL_ID AND
GL.GLCode matches icGLCode
query sort order
BankState.Company_ID (ascending)
BankState.GL_ID (ascending)
BankState.BankStateNumber (ascending)
query resultset tqBankStateByGLBankStateNbr
| field name | data type | db field | description |
|---|
| tdBankStateLineAmountTC | decimal | BankStateLine.BankStateLineAmountTC | TC Amount |
| tcBankStateLineStatus | character | BankStateLine.BankStateLineStatus | Status |
| tcBankStateStatus | character | BankState.BankStateStatus | Status |
| tcGLCode | character | GL.GLCode | A code identifying the GL account. |
| tiCompany_ID | integer | BankState.Company_ID | Link to Company |
| tiBankState_ID | integer | BankState.BankState_ID | Record ID |
| tiGL_ID | integer | BankState.GL_ID | GL Account |
| tcBankStateNumber | character | BankState.BankStateNumber | Bank Statement No |
Internal usage
QadFinancials