project QadFinancials > class BBankEntry > business logic query BankStateByHighestNumberGLId
Description
query which just retrieves the highest banknumber
Parameters
| iiCompanyId | integer | Company id |
| iiGLId | integer | GL id |
| iiBankStateYear | integer | Year of bank statement |
query condition
each BankState where
BankState.Company_Id = iiCompanyId AND
BankState.BankStateYear = iiBankStateYear AND
BankState.GL_ID = iiGLId
query sort order
BankState.Company_ID (ascending)
BankState.GL_ID (ascending)
BankState.BankStateNumber (ascending)
query resultset tqBankStateByHighestNumberGLId
| field name | data type | db field | description |
|---|
| tcBankStateNumber | character | BankState.BankStateNumber | Bank Statement No |
| tiBankStateYear | integer | BankState.BankStateYear | Bank Statement Year |
| tiCompany_ID | integer | BankState.Company_ID | Link to Company |
| tiGL_ID | integer | BankState.GL_ID | GL Account |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(BankState) |
Internal usage
QadFinancials