project BLF > class BNumber > business logic query FirstNumber
Parameters
| iiCompanyId | integer | Company id |
| iiNumbrYear | integer | |
| icNumbrType | character | |
| icNumbrStatus | character | |
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 name | data type | db field | description |
|---|
| tiNumbr | integer | Numbr.Numbr | Number |
| tlNumbrIsActive | logical | Numbr.NumbrIsActive | Inactive sequences cannot be used in a transaction. |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Numbr) |
Internal usage
BLF
QadFinancials