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