project BLF > class BUser > business logic query UserPrim
Description
Query that can be used to convert the ID into the Code and vice-versa (Code is also a related-key-business-field in this query).
Parameters
| iiUsrId | integer | User ID |
| icUsrLogin | character | User name |
query condition
each Usr where
Usr.Usr_ID = iiUsrId AND
Usr.UsrLogin = icUsrLogin
query resultset tqUserPrim
| field name | data type | db field | description |
|---|
| tcUsrLogin | character | Usr.UsrLogin | Login |
| tiUsr_ID | integer | Usr.Usr_ID | Record ID |
Internal usage
BLF
QadFinancials