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