project QadFinancials > class BBankEntry > business logic query BankStateByYear
Description
find a BankState By Year
Parameters
| iiCompanyId | integer | Company id |
| icBankStateNumber | character | Bank State Number |
| iiGLID | integer | GL id |
| iiBankStateYear | integer | Year |
query condition
each BankState where
BankState.Company_Id = iiCompanyId AND
BankState.BankStateNumber = icBankStateNumber AND
BankState.GL_ID = iiGLID AND
BankState.BankStateYear = iiBankStateYear
query resultset tqBankStateByYear
| field name | data type | db field | description |
|---|
| tiBankState_ID | integer | BankState.BankState_ID | Record ID |
| tcBankStateNumber | character | BankState.BankStateNumber | Bank Statement No |
| tiBankStateYear | integer | BankState.BankStateYear | Bank Statement Year |
| tiGL_ID | integer | BankState.GL_ID | GL Account |
Internal usage
QadFinancials