project BLF > class BNumber > business logic query FirstNumber


Parameters


iiCompanyIdintegerCompany id
iiNumbrYearinteger
icNumbrTypecharacter
icNumbrStatuscharacter


query condition


  each Numbr where
Numbr.Company_Id = iiCompanyId AND
Numbr.NumbrYear = iiNumbrYear AND
Numbr.NumbrType = icNumbrType AND
Numbr.NumbrStatus = icNumbrStatus


query sort order


Numbr.Numbr (ascending)


query resultset tqFirstNumber


field namedata typedb fielddescription
tiNumbrintegerNumbr.NumbrNumber
tlNumbrIsActivelogicalNumbr.NumbrIsActiveInactive sequences cannot be used in a transaction.
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Numbr)


Internal usage


BLF
method BNumber.GetFirstNumber

QadFinancials
method BMfgDaybookSetReport.DaybookSetReport