project QadFinancials > class BBankEntry > business logic query BankStateByYear

Description

find a BankState By Year


Parameters


iiCompanyIdintegerCompany id
icBankStateNumbercharacterBank State Number
iiGLIDintegerGL id
iiBankStateYearintegerYear


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 namedata typedb fielddescription
tiBankState_IDintegerBankState.BankState_IDRecord ID
tcBankStateNumbercharacterBankState.BankStateNumberBank Statement No
tiBankStateYearintegerBankState.BankStateYearBank Statement Year
tiGL_IDintegerBankState.GL_IDGL Account


Internal usage


QadFinancials
method BBankStateImport.AdditionalUpdatesCodeStart2
method BBankStateImport.AdditionalUpdatesSwiftStart