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